Grid Postgres data connector

Discontinued products Uncategorized discussions
#1

I am having a tough time with sending data over to my postgres database. Some of the values are coming in correctly, but some are not.



grid setup looks like this:



    mygrid = new dhtmlXGridObject(‘mygrid_container’);

    mygrid.setImagePath(‘javascript/dhtmlxGrid/codebase/imgs/’);

    mygrid.setHeader(“Line, Product Id, Product, Qty, On Hand, UOM, Price, Discount %, Ext Price,TP,Haz/Res, Date Req’d, Reserved, Delivered, Invoiced, Returned, Description, Haz Mat Handling, Restrictions,Weight, avgcost,taxamount”);

    mygrid.setColumnIds(“line_no,m_product_id,product_name,quantity, onhand,uom, price,discount,extprice,tp,hazres, datereqd, reserved, delivered, invoiced, returned,description, hazmathandling,restrictions,weight,avgcost,taxamount”);

    //mygrid.attachHeader("#connector_text_filter,#connector_text_filter")

    mygrid.setInitWidths(“50,0,180,40,50,100,70,70,70,50,70,90,70,70,70,70,100,100,100,0,0,0”);

    mygrid.setColTypes(“cntr,ed,ed,ed,ro,combo,ron,ed,ron,ed,ro,dhxCalendar,ro,ro,ro,ro,ro,txt,ro,ro,ro,ro”);

    mygrid.setColSorting(“connector,connector”)

    //mygrid.setColumnVisibility(“false,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,true”);

    //mygrid.enableSmartRendering(true)

    mygrid.enableMultiselect(true);

    mygrid.submitOnlyChanged(false);

    mygrid.setSkin(“light”);

    mygrid.setNumberFormat(“0,000.00”, 6,".",",");

    mygrid.setNumberFormat(“0,000.00”, 8,".",",");

    mygrid.enableEditEvents(1,1,1);

    //mygrid.setDateFormat("%m/%d/%Y");

    mygrid.attachEvent(“onEditCell”, doGetProduct);

    mygrid.attachEvent(“onRowSelect”,doOnRowSelected);

    mygrid.init();

    uomCombo = mygrid.getColumnCombo(5);

    uomCombo.readonly(true);

//uomCombo.enableFilteringMode(true);

    

uomCombo.loadXML(“functions/buildCombos.php?comboType=c_uom&orgfilter=false”);



        mygrid.loadXML(“php/product_row_connector.php?salesorderno=”+document.getElementById(‘salesorderno’).value);

    

        //var dp = new dataProcessor(“php/product_row_connector.php?salesorderno=”+document.getElementById(‘salesorderno’).value);

        var dp = new dataProcessor(“php/product_row_connector.php?salesorderno=”+document.getElementById(‘salesorderno’).value);

        dp.setVerificator(1,checkRowForInsert);

        //dp.setTransactionMode(“GET”,true);

        //dp.setUpdateMode(“row”);

        //dp.enableDataNames(true);

        //dp.enableDebug(true);

        dp.init(mygrid);





product_row_connector.php looks like this:



    require_once("…/config.php");

    $res=pg_connect($postrgre_connection);



    require("…/javascript/dhtmlxConnector/codebase/grid_connector.php");

    require("…/javascript/dhtmlxConnector/codebase/db_postgre.php");

    

    $salesorderno=$_GET[‘salesorderno’];

    $grid = new GridConnector($res,“Postgre”);

    $grid->enable_log(“temp.log”,true);

    $grid->dynamic_loading(100);





    //$grid->event->attach(“beforeInsert”,“productInsert”);







    //$grid->render_table(“pos_line_data”,“pos_line_data_id”,“line_no,m_product_id,product_name,quantity”);



    $grid->sql->attach(“Update”,“update pos_line_data set line_no=’{line_no}’, m_product_id=’{m_product_id}’, product_name=’{product_name}’, quantity=’{quantity}’, on_hand=’{on_hand’},uom=’{uom}’, price=’{price}’, discount_price=’{discount_price}’, ext_price=’{ext_price}’, sales_order_no=’{$salesorderno}’,tp=’{tp}’,hazres=’{hazres}’ where pos_line_data_id=’{pos_line_data_id}’”);

    $grid->sql->attach(“Insert”,"insert into pos_line_data (pos_line_data_id, line_no, m_product_id,product_name,quantity,on_hand,uom,price,discount_price,ext_price, sales_order_no,tp,hazres) values(’{pos_line_data_id}’,’{line_no}’, ‘{m_product_id}’,’{product_name}’,’{quantity}’,’{onhand}’,’{uom}’,’{price}’,’{discount_price}’,’{ext_price}’,’{$salesorderno}’,’{tp}’,’{hazres}’) ");

    $grid->render_sql(“select pos_line_data_id, line_no, m_product_id, product_name, quantity, uom, price, discount_price, ext_price,tp,hazres from pos_line_data where sales_order_no={$salesorderno}”, “pos_line_data_id”, “line_no,m_product_id,product_name,quantity,uom,price,discount_price,ext_price”);







However, when my database table gets updated. Some of the values are in the wrong column and the onhand, tp and hazres show up as {onhand}, {tp}, {hazres} instead of their values from the grid. The other fields come across as values just fine but some go into the wrong columns in the db.



What am I doing wrong?



Thank you

#2

Please beware that mygrid.setColumnIds will not affect the names in server side scripts.
The connector uses the same list of columns names as was used in render_table, render_sql command ( the first element of list will be used as name for data from first columns and so for )