/iaLib/ia_examples/ia/JqGrid/Filter2where_example.php

<?php

    $ia_example = [
        'title' => 'ia\JqGrid\Filter2where', // fully qualified className
        'summary' => '', // class summary
        'full_example' => '', // full usage example, relative path from ia_examples, blank '' not shown.
        'example_file' => 'code/ia/JqGrid/Filter2where_example_code.php', // method by method example, blank '' not shown.
    ];
     include( __DIR__ . '/../../template/ia_example_class.php');

/iaLib/ia_examples/code/ia/JqGrid/Filter2where_example_code.php

use ia\JqGrid\Filter2where;
use ia\DocumentIt\DocumentIt;

echo '<h3>Disclaimer: Auto generated file.
                Please help us setting parameters to useful values and extending the examples.
        </h3>';

try {


echo '<ul class="usage">';



///////// Filter2where::filter2where(null /* == */); //////////////////////////////////////////////////
echo <<< FUNCTIONDEF
<li id='u_filter2where'><b>Filter2where::filter2where(<span class="type"></span> \$filters, <span class="type"></span> \$groupOp <span class="default">= 'AND'</span>) <span>: </span></b>
FUNCTIONDEF;

echo "<pre class='docBlock'>".DocumentIt::methodDocBlockProtected("ia\JqGrid\Filter2where", "filter2where")."</pre>";

echo "<ol class='usage'>";



    /// display ///
    echo <<< DOCUMENT_EXAMPLE
        <li>Filter2where::filter2where(null /* == */);
        -&gt;&nbsp; </b><br><pre>
DOCUMENT_EXAMPLE;
    /// run ///
        print_r(
        Filter2where::filter2where(null /* == */)
        );
        echo "</pre>";


	echo '</ol>';


///////// Filter2where::rule2sql(null /* == */); //////////////////////////////////////////////////
echo <<< FUNCTIONDEF
<li id='u_rule2sql'><b>Filter2where::rule2sql(<span class="type"></span> \$r) <span>: </span></b>
FUNCTIONDEF;

echo "<pre class='docBlock'>".DocumentIt::methodDocBlockProtected("ia\JqGrid\Filter2where", "rule2sql")."</pre>";

echo "<ol class='usage'>";



    /// display ///
    echo <<< DOCUMENT_EXAMPLE
        <li>Filter2where::rule2sql(null /* == */);
        -&gt;&nbsp; </b><br><pre>
DOCUMENT_EXAMPLE;
    /// run ///
        print_r(
        Filter2where::rule2sql(null /* == */)
        );
        echo "</pre>";


	echo '</ol>';


/* PerfilExample adds new methods here */

echo '</ul>';

} catch(Exception $exception) { echo "<pre class='errorBlock'>$exception</pre>"; }

phpunit test file template

<?php

use ia\JqGrid\Filter2where;
use PHPUnit\Framework\TestCase;

class Filter2whereTest extends TestCase {



    /**
     * @dataProvider filter2where_Provider
     *
     */
    public function test_filter2where($filters, $groupOp , $expected) {
        
        $this->assertEquals($expected, Filter2where::filter2where($filters, $groupOp) );
    }

        function filter2where_Provider() {
            return [
                'test 1' => [ '', '', '' ],
            ];
        }



    /**
     * @dataProvider rule2sql_Provider
     *
     */
    public function test_rule2sql($r , $expected) {
        
        $this->assertEquals($expected, Filter2where::rule2sql($r) );
    }

        function rule2sql_Provider() {
            return [
                'test 1' => [ '', '' ],
            ];
        }


}

ia Doc

AesCipher ^🔧
iaLibAutoLoader ^🔧
iaSqlite ^🔧
ia
- Data
  - MexicoEstados ^🔧
- Date
- DevTools
  - iaTimer ^🔧
- DocumentIt
  - DocumentIt ^🔧
  - PerfilExample ^🔧
- JqGrid
  - Filter2where ^🔧
  - JqGridRead ^🔧
- Lib
- Math
- Sql
  - Mysql
- Util
- Work
  - WorkDay
  - Workflow
PushId ^🔧
URLify ^🔧
XLSXWriter ^🔧