13 lines
486 B
PHP
13 lines
486 B
PHP
|
<?php
|
||
|
|
$db = $GLOBALS['db'];
|
||
|
|
global $app_list_strings;
|
||
|
|
$query2=$db->query("select items.id,items.ecmproduct_id,pr.unit_id from ecmsaleitems as items
|
||
|
|
join ecmsales as doc on doc.id=items.ecmsale_id
|
||
|
|
join ecmproducts as pr on pr.id=items.ecmproduct_id;");
|
||
|
|
while($r = $db->fetchByAssoc($query2)){
|
||
|
|
$db->query("update ecmsaleitems set
|
||
|
|
dd_unit_id='".$r['unit_id']."',
|
||
|
|
dd_unit_name='".$app_list_strings['ecmproducts_unit_dom'][$r['unit_id']]."'
|
||
|
|
where id='".$r['id']."'");
|
||
|
|
}
|
||
|
|
?>
|