01.$sqldoc="select * from document_approve where ct_code='$cont' and status = '2' AND date >= '".date("$yearchk-12-16 00:00:00")."' AND date <= '".date("$yearchk-12-31 00:00:00")."' order by id asc ";
02. $sqldocinfra="select * from document_approveinfra where ct_code='$cont' and status = '2' AND date >= '".date("$yearchk-12-16 00:00:00")."' AND date <= '".date("$yearchk-12-31 00:00:00")."' order by id asc ";
03. $count_user = mysql_query("select count(*) from document_approve where ct_code='$cont' and status = '2' AND date >= '".date("$yearchk-12-16 00:00:00")."' AND date <= '".date("$yearchk-12-31 00:00:00")."' ");
04. $count_userinfra = mysql_query("select count(*) from document_approveinfra where ct_code='$cont' and status = '2' AND date >= '".date("$yearchk-12-16 00:00:00")."' AND date <= '".date("$yearchk-12-31 00:00:00")."' ");
05. $resultsdoc = mysql_query($sqldoc);
06. $resultsdocinfra = mysql_query($sqldocinfra);
07. $user_online = mysql_result($count_user,0);
08. $user_onlineinfra = mysql_result($count_userinfra,0);
09. while($fetcharrsdoc = mysql_fetch_array($resultsdoc))
10. while($fetcharrsdoc = mysql_fetch_array($resultsdocinfra))
11. {
12. $status = $fetcharrsdoc['status'];
13. $statusinfra = $fetcharrsdocinfra['status'];
14. $dateapprove = $fetcharrsdoc['date'];
15. $dateapproveinfra = $fetcharrsdocinfra['date'];
16. $iddocument = $fetcharrsdoc['id'];
17. $iddocumentinfra = $fetcharrsdocinfra['id'];
18. }
19. $datestamp = "15";
20. $datestampinfra = "15";
21. $day = "AND date >= '".date("$yearchk-12-16 00:00:00")."' AND date <= '".date("$yearchk-12-31 00:00:00")."' ";
22. $dayinfra = "AND date >= '".date("$yearchk-12-16 00:00:00")."' AND date <= '".date("$yearchk-12-31 00:00:00")."' ";
23. }
