/************************* Change History ***************************** 08/16/2006 - Jian Wu - Corrected tracks delivered calculation logic. - Updated # Tracks CI Delivered query to fix a time-out issue. ************************************************************************/ ?> $page = ($page) ? $page : 1; $sort_by = isset($sort_by) ? stripslashes($sort_by) : 'customer_name'; $sort_desc = ($sort_desc) ? stripslashes($sort_desc) : 0; $pageRecord = ($pageRecord) ? $pageRecord : 50; $varQueryString = formatURLQueryString('page,pageRecord', array($_REQUEST)); $url = formatURLQueryString('sort_by,sort_desc,page,pageRecord', array($_REQUEST)); $pageNum = 0; $total = 0; $viewall = $viewall ? $viewall : false; $no_url = $no_url ? $no_url : false; // get all dms names $dmss = array(); $sql = 'SELECT customer_id, name FROM customer_master ORDER BY name'; if (!$customer_result = mysql_query($sql)) showerror(); while ($customer_row = mysql_fetch_array($customer_result)) { $dmss[$customer_row['customer_id']] = $customer_row['name']; } // construct main array $mainarray = array(); if (count($bArray)) { $orch_failuers = 0; $ci_failuers = 0; foreach ($bArray as $dms_id=>$details) { $customer_name = $dmss[$dms_id]; $tracks_submitted = array_sum($details); $orch_failuers = count(array_intersect(array_keys($details), $orch_failed_upcs)); $ci_failuers = count(array_intersect(array_keys($details), $ci_failed_upcs)); $mainarray[$dms_id] = array('customer_name'=>$customer_name, 'tracks_submitted'=>$tracks_submitted, 'tracks_delivered'=>0, 'orch_failures'=>$orch_failuers, 'ci_failures'=>$ci_failuers); } } if (count($bArray1)) { foreach ($bArray1 as $dms_id=>$details) { $tracks_delivered = array_sum($details); $mainarray[$dms_id]['tracks_delivered']=$tracks_delivered; } } $mainarray = multisort($mainarray, $sort_by, ($sort_desc?false:true), 1); $varTable = '
| ' . ((!$viewall or $no_url) ? 'DMS' : sortColumnHeader('DMS', 'customer_name', $url)) . ' | ' . ((!$viewall or $no_url) ? '# of Tracks Submitted to CI' : sortColumnHeader('# of Tracks Submitted to CI', 'tracks_submitted', $url)) . ' | ' . ((!$viewall or $no_url) ? '# of Tracks Delivered by CI' : sortColumnHeader('# of Tracks Delivered by CI', 'tracks_delivered', $url)) . ' | ' . ((!$viewall or $no_url) ? '# of Orch Failures' : sortColumnHeader('# of Orch Failures', 'orch_failures', $url)) . ' | ' . ((!$viewall or $no_url) ? '# of CI Failures' : sortColumnHeader('# of CI Failures', 'ci_failures', $url)) . ' |
|---|---|---|---|---|
| ' . $subarray['customer_name'] . ' | ' . number_format($subarray['tracks_submitted']) . ' | ' . number_format($subarray['tracks_delivered']) . ' | ' . number_format($subarray['orch_failures']) . ' | ' . number_format($subarray['ci_failures']) . ' |
| No results found from ' . $date1 . ' to ' . $date2 . '. | ||||