1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
<div style='display:block' id='detail_commande'>
<table width='700' style='position: absolute; top: 325px; left: 102px;'>
<tr>
<td>
<div id='gridbox2' style='width:100%; height:175px;'></div>
</td>
</tr>
</table>
</div>
<script type="text/javascript">
mygrid = new dhtmlXGridObject('gridbox2');
mygrid.setImagePath('../imgs/imgstableau/');
mygrid.setHeader('Code article,Quantité,Description,Date org. remise, Date remise, Date livraison');
mygrid.setInitWidths('90,70,*,100,100,100')
mygrid.setColAlign('center,center,center,center,center,center')
mygrid.setColTypes('ro,ro,ro,ro,ro,ro');
mygrid.setColSorting('int,int,str,date,date,date');
mygrid.setColumnColor('#33FFFF,#CCFFFF,#33FFFF,#CCFFFF,#33FFFF,#CCFFFF');
mygrid.init();
mygrid.loadXML("../../php/php_s/sql_query_to_xgrid.php?SQL_QUERY=SELECT A.ART_CODE,CP.CP_QTE,A.ART_DESCRIPTION,CP.DATE_ORG_REMISE,CP.DATE_REMISE,CP.DATE_LIV_CLIENT FROM Articles A, CommandePoste CP WHERE A.ID_ARTICLE=CP.ID_ARTICLE AND COL_ID=ID_COMMANDE");
</script> |
