Guriddo » reynierpm's Replies

reynierpm

Guriddo

Forum Replies Created

Viewing 9 replies - 1 through 9 (of 9 total)

Author

Replies

February 6, 2017 at 3:14 pm in reply to: Suito PHP and ZF1 integration through Zend_Db_Adapter_Pdo_Mysql #125816

reynierpm

Participant

Hi there, I think you miss understand => “Finally I have managed to make the library work” this mean I didn’t get the “Script expired” message but I can’t get this to work, the same issue where the JSON is printed out to a popup window still happening so nothing is really fixed I am still need some support to make this work otherwise my boss won’t never buy something that doesn’t work with our system.

Thanks

February 3, 2017 at 8:32 pm in reply to: Suito PHP and ZF1 integration through Zend_Db_Adapter_Pdo_Mysql #125814

reynierpm

Participant

Finally I have managed to make the library work and this is how the code looks like currently:


    public function indexAction()
    {
        $CODE_PATH = &#039;PHPSuito/&#039;;

        require_once $CODE_PATH.&#039;jqGrid.php&#039;;
        require_once $CODE_PATH.&#039;jqGridRender.php&#039;;
        require_once $CODE_PATH.&#039;DBdrivers/jqGridPdo.php&#039;;

        $adapter = Zend_Registry::get(&#039;dbAdapter&#039;);

        $grid                = new jqGridRender($adapter-&gt;getConnection());
        $grid-&gt;SelectCommand = &#039;SELECT * FROM companies&#039;;
        $grid-&gt;dataType      = &#039;json&#039;;
        $grid-&gt;setColModel();
        $grid_url = Zend_Controller_Front::getInstance()-&gt;getRequest()-&gt;getControllerName().&#039;/&#039;.Zend_Controller_Front::getInstance()-&gt;getRequest()-&gt;getActionName();
        $grid-&gt;setUrl($grid_url);
        $grid-&gt;setGridOptions(array(
            &quot;rownumbers&quot;  =&gt; true,
            &quot;rownumWidth&quot; =&gt; 35,
            &quot;rowNum&quot;      =&gt; 10,
            &quot;sortname&quot;    =&gt; &quot;companies_id&quot;,
            &quot;toppager&quot;    =&gt; true,
            &quot;rowList&quot;     =&gt; array(10, 20, 50),
        ));

        $grid-&gt;setColProperty(&quot;companies_id&quot;, array(&quot;label&quot; =&gt; &quot;ID&quot;, &quot;width&quot; =&gt; 60));
        $grid-&gt;setColProperty(&quot;created_date&quot;, array(
                &quot;formatter&quot;     =&gt; &quot;date&quot;,
                &quot;formatoptions&quot; =&gt; array(&quot;srcformat&quot; =&gt; &quot;Y-m-d H:i:s&quot;, &quot;newformat&quot; =&gt; &quot;m/d/Y&quot;)
            )
        );

        $grid-&gt;navigator = true;
        $grid-&gt;setNavOptions(
            &#039;navigator&#039;,
            array(&quot;cloneToTop&quot; =&gt; true, &quot;add&quot; =&gt; false, &quot;edit&quot; =&gt; false, &quot;del&quot; =&gt; false, &quot;excel&quot; =&gt; false)
        );

        $grid-&gt;renderGrid(&#039;#grid&#039;, &#039;#pager&#039;, true, null, null, true, true);
    }

public function indexAction()

{

$CODE_PATH = 'PHPSuito/';

require_once $CODE_PATH.'jqGrid.php';

require_once $CODE_PATH.'jqGridRender.php';

require_once $CODE_PATH.'DBdrivers/jqGridPdo.php';

$adapter = Zend_Registry::get('dbAdapter');

$grid = new jqGridRender($adapter->getConnection());

$grid->SelectCommand = 'SELECT * FROM companies';

$grid->dataType = 'json';

$grid->setColModel();

$grid_url = Zend_Controller_Front::getInstance()->getRequest()->getControllerName().'/'.Zend_Controller_Front::getInstance()->getRequest()->getActionName();

$grid->setUrl($grid_url);

$grid->setGridOptions(array(

"rownumbers" => true,

"rownumWidth" => 35,

"rowNum" => 10,

"sortname" => "companies_id",

"toppager" => true,

"rowList" => array(10, 20, 50),

));

$grid->setColProperty("companies_id", array("label" => "ID", "width" => 60));

$grid->setColProperty("created_date", array(

"formatter" => "date",

"formatoptions" => array("srcformat" => "Y-m-d H:i:s", "newformat" => "m/d/Y")

)

);

$grid->navigator = true;

$grid->setNavOptions(

'navigator',

array("cloneToTop" => true, "add" => false, "edit" => false, "del" => false, "excel" => false)

);

$grid->renderGrid('#grid', '#pager', true, null, null, true, true);

}

There is not “echo” or “print_f” or any other output statement around meaing the code you’re seeing here is the code being executed. The template is completely empty as well.

No matter what the error still happening and for some reason the response comes as a whole HTML page and not a JSON, why? no ideas!!

Any other clue or test you want me to perform?

February 3, 2017 at 8:09 pm in reply to: Suito PHP and ZF1 integration through Zend_Db_Adapter_Pdo_Mysql #125813

reynierpm

Participant

That’s exactly what I did but still not working :-\

February 3, 2017 at 3:17 pm in reply to: Suito PHP and ZF1 integration through Zend_Db_Adapter_Pdo_Mysql #125811

reynierpm

Participant

I can’t test anymore apparently, I got this “Script expired” message when I try to execute the code 🙁

February 2, 2017 at 8:28 pm in reply to: Suito PHP and ZF1 integration through Zend_Db_Adapter_Pdo_Mysql #125806

reynierpm

Participant

There is not such thing on my code, what you’re seeing here is exactly what I currently have in my class

February 1, 2017 at 4:34 pm in reply to: Suito PHP and ZF1 integration through Zend_Db_Adapter_Pdo_Mysql #125797

reynierpm

Participant

Hi, by setting:

$grid->logtofile = false;

the error above dissapear but I am still getting an issue. Check below:

February 1, 2017 at 4:10 pm in reply to: Suito PHP and ZF1 integration through Zend_Db_Adapter_Pdo_Mysql #125795

reynierpm

Participant

Ok, I’ve discovered how to fix the previous issue by setting:


$grid-&gt;logtofile     = false;

$grid->logtofile = false;

But the error still and I can see the following on the debug output:


Array
(
    [0] =&gt; Array
        (
            [time] =&gt; 2017-02-01 14:07:44
            [query] =&gt; SELECT COUNT(*) AS COUNTR  FROM companies
            [data] =&gt; 
            [types] =&gt; 
            [fields] =&gt; 
            [primary] =&gt; 
            [input] =&gt; 
        )

    [1] =&gt; Array
        (
            [time] =&gt; 2017-02-01 14:07:44
            [query] =&gt; SELECT * FROM companies ORDER BY companies_id asc LIMIT 0, 10
            [data] =&gt; 
            [types] =&gt; 
            [fields] =&gt; 
            [primary] =&gt; 
            [input] =&gt; 
        )

)

Array

(

[0] => Array

(

[time] => 2017-02-01 14:07:44

[query] => SELECT COUNT(*) AS COUNTR FROM companies

[data] =>

[types] =>

[fields] =>

[primary] =>

[input] =>

)

[1] => Array

(

[time] => 2017-02-01 14:07:44

[query] => SELECT * FROM companies ORDER BY companies_id asc LIMIT 0, 10

[data] =>

[types] =>

[fields] =>

[primary] =>

[input] =>

)

I am not sure what this means or what I’m missing, could you help?

February 1, 2017 at 3:41 pm in reply to: Suito PHP and ZF1 integration through Zend_Db_Adapter_Pdo_Mysql #125793

reynierpm

Participant

Hi there, I am getting an error when the grid is being render and I don’t know why or how to trace it. This is how my code looks like:


    public function indexAction()
    {
        $CODE_PATH = &#039;PHPSuito/&#039;;

        require_once $CODE_PATH.&#039;jqGrid.php&#039;;
        require_once $CODE_PATH.&#039;jqGridRender.php&#039;;
        require_once $CODE_PATH.&#039;DBdrivers/jqGridPdo.php&#039;;

        $adapter = Zend_Registry::get(&#039;dbAdapter&#039;);

        $grid                = new jqGridRender($adapter-&gt;getConnection());
        $grid-&gt;SelectCommand = &#039;SELECT * FROM companies&#039;;
        $grid-&gt;dataType      = &#039;json&#039;;
        $grid-&gt;setColModel();
        $grid_url = Zend_Controller_Front::getInstance()-&gt;getRequest()-&gt;getControllerName().&#039;/&#039;.Zend_Controller_Front::getInstance()-&gt;getRequest()-&gt;getActionName();
        $grid-&gt;setUrl($grid_url);
        $grid-&gt;setGridOptions(array(
            &quot;rownumbers&quot;  =&gt; true,
            &quot;rownumWidth&quot; =&gt; 35,
            &quot;rowNum&quot;      =&gt; 10,
            &quot;sortname&quot;    =&gt; &quot;companies_id&quot;,
            &quot;toppager&quot;    =&gt; true,
            &quot;rowList&quot;     =&gt; array(10, 20, 50),
        ));

        $grid-&gt;setColProperty(&quot;companies_id&quot;, array(&quot;label&quot; =&gt; &quot;ID&quot;, &quot;width&quot; =&gt; 60));
        $grid-&gt;setColProperty(&quot;created_date&quot;, array(
                &quot;formatter&quot;     =&gt; &quot;date&quot;,
                &quot;formatoptions&quot; =&gt; array(&quot;srcformat&quot; =&gt; &quot;Y-m-d H:i:s&quot;, &quot;newformat&quot; =&gt; &quot;m/d/Y&quot;)
            )
        );
        $grid-&gt;navigator = true;
        $grid-&gt;setNavOptions(
            &#039;navigator&#039;,
            array(&quot;cloneToTop&quot; =&gt; true, &quot;add&quot; =&gt; false, &quot;edit&quot; =&gt; false, &quot;del&quot; =&gt; false, &quot;excel&quot; =&gt; false)
        );
        $grid-&gt;renderGrid(&#039;#grid&#039;, &#039;#pager&#039;, true, null, null, true, true);
    }

public function indexAction()

{

$CODE_PATH = 'PHPSuito/';

require_once $CODE_PATH.'jqGrid.php';

require_once $CODE_PATH.'jqGridRender.php';

require_once $CODE_PATH.'DBdrivers/jqGridPdo.php';

$adapter = Zend_Registry::get('dbAdapter');

$grid = new jqGridRender($adapter->getConnection());

$grid->SelectCommand = 'SELECT * FROM companies';

$grid->dataType = 'json';

$grid->setColModel();

$grid_url = Zend_Controller_Front::getInstance()->getRequest()->getControllerName().'/'.Zend_Controller_Front::getInstance()->getRequest()->getActionName();

$grid->setUrl($grid_url);

$grid->setGridOptions(array(

"rownumbers" => true,

"rownumWidth" => 35,

"rowNum" => 10,

"sortname" => "companies_id",

"toppager" => true,

"rowList" => array(10, 20, 50),

));

$grid->setColProperty("companies_id", array("label" => "ID", "width" => 60));

$grid->setColProperty("created_date", array(

"formatter" => "date",

"formatoptions" => array("srcformat" => "Y-m-d H:i:s", "newformat" => "m/d/Y")

)

);

$grid->navigator = true;

$grid->setNavOptions(

'navigator',

array("cloneToTop" => true, "add" => false, "edit" => false, "del" => false, "excel" => false)

);

$grid->renderGrid('#grid', '#pager', true, null, null, true, true);

}

Then the JSON returned is something like:


{
  &quot;records&quot;: &quot;1&quot;,
  &quot;page&quot;: 1,
  &quot;total&quot;: 1,
  &quot;rows&quot;: [
    {
      &quot;companies_id&quot;: &quot;1&quot;,
      &quot;parent_companies_id&quot;: &quot;0&quot;,
      &quot;client_of_companies_id&quot;: &quot;0&quot;,
      &quot;asset_locations_id&quot;: null,
      &quot;companies_name&quot;: &quot;container&quot;,
      &quot;companies_number&quot;: &quot;000001&quot;,
      &quot;companies_url&quot;: &quot;&quot;,
      &quot;location_number&quot;: null,
      &quot;statuses_id&quot;: &quot;1&quot;,
      &quot;managed&quot;: &quot;0&quot;,
      &quot;created_date&quot;: &quot;0000-00-00 00:00:00&quot;,
      &quot;created_by_users_id&quot;: &quot;0&quot;,
      &quot;updated_date&quot;: &quot;2017-01-16 15:53:35&quot;,
      &quot;updated_by_users_id&quot;: null,
      &quot;host_companies_id&quot;: &quot;0&quot;,
      &quot;host_company&quot;: &quot;0&quot;,
      &quot;view_pricing&quot;: &quot;1&quot;,
      &quot;is_demo&quot;: &quot;0&quot;,
      &quot;expired_date&quot;: &quot;0000-00-00&quot;,
      &quot;companies_region_name&quot;: null,
      &quot;companies_location_name&quot;: null,
      &quot;companies_address1&quot;: null,
      &quot;companies_address2&quot;: null,
      &quot;companies_city&quot;: null,
      &quot;companies_state_name&quot;: null,
      &quot;companies_state_abbr&quot;: null,
      &quot;companies_country_name&quot;: null,
      &quot;companies_country_abbr&quot;: null,
      &quot;companies_logo&quot;: &quot;default.jpg&quot;,
      &quot;companies_zip&quot;: null,
      &quot;internal_name&quot;: null,
      &quot;internal_number&quot;: null,
      &quot;phone&quot;: null,
      &quot;fax&quot;: null,
      &quot;number_of_subcompanies&quot;: &quot;0&quot;,
      &quot;company_type&quot;: null,
      &quot;companies_header&quot;: &quot;default_header.jpg&quot;,
      &quot;send_alert&quot;: &quot;1&quot;,
      &quot;create_asset&quot;: &quot;1&quot;,
      &quot;create_servicepak&quot;: &quot;1&quot;,
      &quot;create_contract&quot;: &quot;1&quot;,
      &quot;alert_section_1&quot;: null,
      &quot;alert_section_2&quot;: null,
      &quot;group_companies_id&quot;: &quot;0&quot;,
      &quot;email&quot;: null,
      &quot;VAT&quot;: null,
      &quot;CustomerSiteID&quot;: null,
      &quot;DistributorID&quot;: null
    }
  ]
}
Can not write to log!

{

"records": "1",

"page": 1,

"total": 1,

"rows": [

{

"companies_id": "1",

"parent_companies_id": "0",

"client_of_companies_id": "0",

"asset_locations_id": null,

"companies_name": "container",

"companies_number": "000001",

"companies_url": "",

"location_number": null,

"statuses_id": "1",

"managed": "0",

"created_date": "0000-00-00 00:00:00",

"created_by_users_id": "0",

"updated_date": "2017-01-16 15:53:35",

"updated_by_users_id": null,

"host_companies_id": "0",

"host_company": "0",

"view_pricing": "1",

"is_demo": "0",

"expired_date": "0000-00-00",

"companies_region_name": null,

"companies_location_name": null,

"companies_address1": null,

"companies_address2": null,

"companies_city": null,

"companies_state_name": null,

"companies_state_abbr": null,

"companies_country_name": null,

"companies_country_abbr": null,

"companies_logo": "default.jpg",

"companies_zip": null,

"internal_name": null,

"internal_number": null,

"phone": null,

"fax": null,

"number_of_subcompanies": "0",

"company_type": null,

"companies_header": "default_header.jpg",

"send_alert": "1",

"create_asset": "1",

"create_servicepak": "1",

"create_contract": "1",

"alert_section_1": null,

"alert_section_2": null,

"group_companies_id": "0",

"email": null,

"VAT": null,

"CustomerSiteID": null,

"DistributorID": null

}

]

}

Can not write to log!

What log is that? How I disable such feature? I don’t need to write anything

This reply was modified 9 years, 2 months ago by reynierpm.

December 12, 2016 at 3:34 pm in reply to: jqGrid PHP and Zend Framework 1 integration #125725

reynierpm

Participant

Suppose I can extract the connection information from $dbAdapter->conn can I use Zend_Db_Select or Zend_Db_Table for build proper SQL queries? Could you investigate this part with your team and let me know? I don’t want to pay for something I can’t use in this project so I want to be sure I can use it

Thanks in advance

Author

Replies

Viewing 9 replies - 1 through 9 (of 9 total)