「ERP php程式碼」:修訂間差異

出自TSK WIKI
跳至導覽 跳至搜尋
Root​(留言 | 貢獻)
Tpl​(留言 | 貢獻)
第5行: 第5行:
$q_where->set_q_title('TD002',array('訂單號','2'));
$q_where->set_q_title('TD002',array('訂單號','2'));
$cond= $q_where->display();
$cond= $q_where->display();
</php>
==繼承用程式碼==
<php>
//利用exC_DataGrid以及exset_col_title,可繼承ADMMD中之欄位
$sg1 = new exC_DataGrid("SELECT TD001,TD002,TD003,TD004,COPTD.UDF01,TC093 FROM COPTD JOIN COPTC ON TC001=TD001 AND TC002=TD002",array("TD001","TD002","TD003"),"COPTD");
$sg1 ->exset_col_title("TD001,TD002,TD003,TD004,COPTD.UDF01","COPTD");
$sg1 ->exset_col_title("TC093","COPTC");
$sg1 -> display();
</php>
</php>

於 2015年12月29日 (二) 08:29 的修訂

搜尋用程式碼

<php> $q_where=new Wherequery(); $q_where->set_q_title('TD001',array('訂單別')); $q_where->set_q_title('TD002',array('訂單號','2')); $cond= $q_where->display(); </php>

繼承用程式碼

<php> //利用exC_DataGrid以及exset_col_title,可繼承ADMMD中之欄位 $sg1 = new exC_DataGrid("SELECT TD001,TD002,TD003,TD004,COPTD.UDF01,TC093 FROM COPTD JOIN COPTC ON TC001=TD001 AND TC002=TD002",array("TD001","TD002","TD003"),"COPTD"); $sg1 ->exset_col_title("TD001,TD002,TD003,TD004,COPTD.UDF01","COPTD"); $sg1 ->exset_col_title("TC093","COPTC"); $sg1 -> display(); </php>