7 lines
475 B
PHP
Executable File
7 lines
475 B
PHP
Executable File
<?php
|
|
$w=$GLOBALS[db]->query("select id,document_no,status,register_date from ecmstockdocouts where status!='registered' and register_date like '2010-%' and deleted='0'");
|
|
while($r=$GLOBALS[db]->fetchByAssoc($w)){
|
|
$rr=$GLOBALS[db]->fetchByAssoc($GLOBALS[db]->query("select count(*) as cnt from ecmreceipts where register_date>'2010-%' and wz_id='".$r['id']."' and deleted='0'"));
|
|
if($rr['cnt']==0)echo $r['document_no']." ".$r['register_date']." ".$r['status']."<br>";
|
|
}
|
|
?>
|