PageRenderTime 52ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 0ms

/p078_dealerd1/p077_DealLog1/GSM_Main/GSM_Grid/ajax/Work_In_Progress_Stats.php

https://bitbucket.org/rlm3/rlm3_staging
PHP | 1379 lines | 1209 code | 150 blank | 20 comment | 127 complexity | c98db197fdd20a288eebddc9ef9f4133 MD5 | raw file
Possible License(s): MPL-2.0-no-copyleft-exception, GPL-2.0, BSD-3-Clause, GPL-3.0, LGPL-2.1

Large files files are truncated, but you can click here to view the full file

    

  1. <?php
    2. 

  2. include_once ($_SERVER['DOCUMENT_ROOT']."/p093_includes/bootstrap.php");
    3. 

  3. include_once('../include/functions.php');
    4. 

  4. 

  5. $grid = new GSM\Grid($_REQUEST);
    6. 

  6. 

  7. $departments     = $grid->getDepartments();
    8. 

  8. $departmentNames = $grid->getDepartmentsNames();
    9. 

  9. 

  10. $dptWhere = $db->prepareQuery("`dpt`.`cDepartment_ID` IN (%%1)", $grid->getDepartmentsIds());
    11. 

  11. 

  12. $data                                               = array();
    13. 

  13. $data['Recon Cars']                                 = array_fill_keys($departmentNames, 0);
    14. 

  14. $data['Stock Cars']                                 = array_fill_keys($departmentNames, 0);
    15. 

  15. $data['Deal Situation']                             = array_fill_keys($departmentNames, 0);
    16. 

  16. $data['Orphans (Net) >30min']                       = array_fill_keys($departmentNames, 0);
    17. 

  17. $data['Orphans >1hr']                               = array_fill_keys($departmentNames, 0);
    18. 

  18. $data['Orphans >16hrs']                             = array_fill_keys($departmentNames, 0);
    19. 

  19. $data['Internet Escalated']                         = array_fill_keys($departmentNames, 0);
    20. 

  20. $data['Lost >1day']                                 = array_fill_keys($departmentNames, 0);
    21. 

  21. $data['Recon Current']                              = array_fill_keys($departmentNames, 0);
    22. 

  22. $data['Avg Sales Days']                             = array_fill_keys($departmentNames, 0);
    23. 

  23. $data['Wholesale < 10 Days']                        = array_fill_keys($departmentNames, 0);
    24. 

  24. $data['Wholesale 11 - 20 Days']                     = array_fill_keys($departmentNames, 0);
    25. 

  25. $data['Wholesale > 20 Days']                        = array_fill_keys($departmentNames, 0);
    26. 

  26. $data['Deliveries Today']                           = array_fill_keys($departmentNames, array('Today' => 0, 'Yesterday' => 0, 'DayBefore' => 0));
    27. 

  27. $data['Sales2Service Handover']                     = array_fill_keys($departmentNames, array('Y' => 0, 'All' => 0));
    28. 

  28. $data['Call Center Penetration']                    = array_fill_keys($departmentNames, array('Surveyed' => 0, 'Total' => 0));
    29. 

  29. $data['NPS']                                        = array_fill_keys($departmentNames, array('Promoters' => 0, 'Detractors' => 0, 'Total' => 0));
    30. 

  30. $data['Parts Not Fitted on Delivery (Outstanding)'] = array_fill_keys($departmentNames, 0);
    31. 

  31. $data['Parts Not Fitted on Delivery (Booked)']      = array_fill_keys($departmentNames, 0);
    32. 

  32. $data['Target Gross']                               = array_fill_keys($departmentNames, 0);
    33. 

  33. $data['Target Units']                               = array_fill_keys($departmentNames, 0);
    34. 

  34. $data['Weekly Dots Gross']                          = array_fill_keys($departmentNames, 0);
    35. 

  35. $data['Weekly Dots Units']                          = array_fill_keys($departmentNames, 0);
    36. 

  36. $data['ITU (Individual)']                           = array_fill_keys($departmentNames, 0);
    37. 

  37. $data['Total Completed']                            = array_fill_keys($departmentNames, 0);
    38. 

  38. $data['Total Scheduled']                            = array_fill_keys($departmentNames, 0);
    39. 

  39. $data['Total Waiting Manager Approval']             = array_fill_keys($departmentNames, 0);
    40. 

  40. $data['Total Waiting HR Approval']                  = array_fill_keys($departmentNames, 0);
    41. 

  41. 

  42. $today     = $grid->getToday();
    43. 

  43. $yesterday = $grid->getYesterday();
    44. 

  44. $daybefore = $grid->getDayBeforeYesterday();
    45. 

  45. 

  46. /* Recon Cars */
    47. 

  47. $sql = "SELECT `dpt`.`Short_Desc`,
    48. 

  48.                `dpt`.`DMS_DPT_Code`,
    49. 

  49.                COUNT(*) as `Count`
    50. 

  50.         FROM `p133_Recon` `r`
    51. 

  51.         INNER JOIN `p133_Recon_Status` `rs` ON `rs`.`Recon_Stat_Code` = `r`.`p133_Recon_Status`
    52. 

  52.         INNER JOIN `p109_Veh_Stk` `veh` ON `veh`.`p109_STKNO` = `r`.`p133_Stock_no`
    53. 

  53.         INNER JOIN `cDepartment` `dpt` ON `dpt`.`DMS_DPT_Code` = `r`.`p133_cDepartment_Sales` AND `dpt`.`Department_Types_ID` = 1 AND `dpt`.`Dpt_Active` = 'Y'
    54. 

  54.         WHERE (`rs`.`Is_Current` = 'Y' OR (`r`.`p133_Recon_Status` = 'Instock' AND `veh`.`Status` < 90)) AND `r`.`p133_Stock_Car` = 'N' AND `rs`.`p133_Recon_Time_Count_As_ID` = 1
    55. 

  55.         GROUP BY `r`.`p133_cDepartment_Sales`";
    56. 

  56. $db->query($sql);
    57. 

  57. while ($row = $db->fetchRow())
    58. 

  58. {
    59. 

  59.     if (isset($data['Recon Cars'][$row['Short_Desc']]))
    60. 

  60.     {
    61. 

  61.         $data['Recon Cars'][$row['Short_Desc']] = $row['Count'];
    62. 

  62.     }
    63. 

  63. }
    64. 

  64. 

  65. /* Stock Cars */
    66. 

  66. $sql = "SELECT `dpt`.`Short_Desc`,
    67. 

  67.                `dpt`.`DMS_DPT_Code`,
    68. 

  68.                COUNT(*) as `Count`
    69. 

  69.         FROM `p133_Recon` `r`
    70. 

  70.         INNER JOIN `p133_Recon_Status` `rs` ON `rs`.`Recon_Stat_Code` = `r`.`p133_Recon_Status`
    71. 

  71.         INNER JOIN `p109_Veh_Stk` `veh` ON `veh`.`p109_STKNO` = `r`.`p133_Stock_no`
    72. 

  72.         INNER JOIN `cDepartment` `dpt` ON `dpt`.`DMS_DPT_Code` = `r`.`p133_cDepartment_Sales` AND `dpt`.`Department_Types_ID` = 1 AND `dpt`.`Dpt_Active` = 'Y'
    73. 

  73.         WHERE (`rs`.`Is_Current` = 'Y' OR (`r`.`p133_Recon_Status` = 'Instock' AND `veh`.`Status` < 90)) AND `r`.`p133_Stock_Car` = 'Y' AND `rs`.`p133_Recon_Time_Count_As_ID` = 1
    74. 

  74.         GROUP BY `r`.`p133_cDepartment_Sales`";
    75. 

  75. $db->query($sql);
    76. 

  76. while ($row = $db->fetchRow())
    77. 

  77. {
    78. 

  78.     if (isset($data['Stock Cars'][$row['Short_Desc']]))
    79. 

  79.     {
    80. 

  80.         $data['Stock Cars'][$row['Short_Desc']] = $row['Count'];
    81. 

  81.     }
    82. 

  82. }
    83. 

  83. 

  84. /* Deal Situation Cars */
    85. 

  85. $where = "`d`.`SM_Delivery_Month` = '{$_REQUEST['period']}'";
    86. 

  86. $sql = "SELECT `dpt`.`Short_Desc`,
    87. 

  87.                `dpt`.`DMS_DPT_Code`,
    88. 

  88.                COUNT(*) as `Count`
    89. 

  89.         FROM `p077_Deal_Log` `d`
    90. 

  90.         INNER JOIN `p077_Deal_Situation_Status` `dss` ON `dss`.`Deal_Situation_Status` = `d`.`p077_Deal_Situation`
    91. 

  91.         INNER JOIN `p109_Veh_Stk` `vs` ON `vs`.`p109_STKNO` = `d`.`p077_Stock_Num`
    92. 

  92.         INNER JOIN `cDepartment` `dpt` ON `dpt`.`DMS_DPT_Code` = `d`.`p077_DPTID` AND `dpt`.`Department_Types_ID` = 1 AND `dpt`.`Dpt_Active` = 'Y'
    93. 

  93.         WHERE $where
    94. 

  94.         GROUP BY `dpt`.`DMS_DPT_Code`";
    95. 

  95. $db->query($sql);
    96. 

  96. while ($row = $db->fetchRow())
    97. 

  97. {
    98. 

  98.     if (isset($data['Deal Situation'][$row['Short_Desc']]))
    99. 

  99.     {
    100. 

  100.         $data['Deal Situation'][$row['Short_Desc']] = $row['Count'];
    101. 

  101.     }
    102. 

  102. }
    103. 

  103. 

  104. /* Orphans >1hr */
    105. 

  105. $sql = "SELECT `dpt`.`Short_Desc`,
    106. 

  106.                `l`.`L_Day`,
    107. 

  107.                `l`.`p108_Lead_Type_ID`
    108. 

  108.         FROM `p108_Leads` `l`
    109. 

  109.         INNER JOIN `cDepartment` `dpt` ON (`dpt`.`cDepartment_ID` = `l`.`L_cDepartment_ID` AND `dpt`.`Department_Types_ID` = 1 AND `dpt`.`Dpt_Active` = 'Y')
    110. 

  110.         WHERE `l`.`p108_Lead_Status_ID` = '1'";
    111. 

  111. $db->query($sql);
    112. 

  112. while ($row = $db->fetchRow())
    113. 

  113. {
    114. 

  114.     $hours = (time() - strtotime($row['L_Day'])) / 3600;
    115. 

  115.     $minutes = $hours - (int) $hours;
    116. 

  116.     if ($minutes < 0.5)
    117. 

  117.     {
    118. 

  118.         $hours = floor($hours);
    119. 

  119.     }
    120. 

  120. 

  121.     if (isset($data['Orphans >1hr'][$row['Short_Desc']]) && $hours >= 1)
    122. 

  122.     {
    123. 

  123.         $data['Orphans >1hr'][$row['Short_Desc']]++;
    124. 

  124.     }
    125. 

  125. 

  126.     if (isset($data['Orphans >16hrs'][$row['Short_Desc']]) && $hours >= 16)
    127. 

  127.     {
    128. 

  128.         $data['Orphans >16hrs'][$row['Short_Desc']]++;
    129. 

  129.     }
    130. 

  130. 

  131.     if (isset($data['Orphans (Net) >30min'][$row['Short_Desc']]) && $hours >= 0.5 && $row['p108_Lead_Type_ID'] == 3)
    132. 

  132.     {
    133. 

  133.         $data['Orphans (Net) >30min'][$row['Short_Desc']]++;
    134. 

  134.     }
    135. 

  135. 

  136. }
    137. 

  137. 

  138. /* Internet Escalated */
    139. 

  139. $sql = "SELECT `dpt`.`Short_Desc`,
    140. 

  140.                `l`.`p108_Lead_Type_ID`,
    141. 

  141.                COUNT(*) as `Count`
    142. 

  142.         FROM `p108_Leads` `l`
    143. 

  143.         INNER JOIN `cDepartment` `dpt` ON (`dpt`.`cDepartment_ID` = `l`.`L_cDepartment_ID` AND `dpt`.`Department_Types_ID` = 1 AND `dpt`.`Dpt_Active` = 'Y')
    144. 

  144.         WHERE DATE(`l`.`L_Day`) = CURDATE() AND `l`.`Escalation_SMS` = 'Y' AND `l`.`p108_Lead_Type_ID` = 3
    145. 

  145.         GROUP BY `l`.`L_cDepartment_ID`";
    146. 

  146. $db->query($sql);
    147. 

  147. while ($row = $db->fetchRow())
    148. 

  148. {
    149. 

  149.     $data['Internet Escalated'][$row['Short_Desc']] = $row['Count'];
    150. 

  150. }
    151. 

  151. 

  152. $lostDays = 1;
    153. 

  153. if (Date::format('D') == 'Mon')
    154. 

  154. {
    155. 

  155.     $lostDays = 3;
    156. 

  156. }
    157. 

  157. /* Lost >1day */
    158. 

  158. $sql = "SELECT `dpt`.`Short_Desc`,
    159. 

  159.                SUM(DATEDIFF(NOW(), `l`.`L_Day`) > $lostDays) as `Days`
    160. 

  160.         FROM `p108_Leads` `l`
    161. 

  161.         INNER JOIN `cDepartment` `dpt` ON (`dpt`.`cDepartment_ID` = `l`.`L_cDepartment_ID` AND `dpt`.`Department_Types_ID` = 1 AND `dpt`.`Dpt_Active` = 'Y')
    162. 

  162.         WHERE `l`.`p108_Lead_Status_ID` = '11'
    163. 

  163.         GROUP BY `l`.`L_cDepartment_ID`";
    164. 

  164. $db->query($sql);
    165. 

  165. while ($row = $db->fetchRow())
    166. 

  166. {
    167. 

  167.     if (isset($data["Lost >$lostDays day"][$row['Short_Desc']]))
    168. 

  168.     {
    169. 

  169.         $data["Lost >$lostDays day"][$row['Short_Desc']] = $row['Days'];
    170. 

  170.     }
    171. 

  171. }
    172. 

  172. 

  173. /* Avg Sales Days */
    174. 

  174. $sql = "SELECT SUM(`rdl`.`Status_Days_Adjusted`) as `Days`,
    175. 

  175.                `dpt`.`Short_Desc`,
    176. 

  176.                COUNT(DISTINCT `r`.`p133_Recon_ID`) as `Count`
    177. 

  177.         FROM `p133_Recon` `r`
    178. 

  178.         INNER JOIN `cDepartment` `dpt` ON `dpt`.`DMS_DPT_Code` = `r`.`p133_cDepartment_Sales` AND $dptWhere AND `dpt`.`Dpt_Active` = 'Y'
    179. 

  179.         INNER JOIN `p133_Recon_Days_Log` `rdl` ON `rdl`.`Recon_Master_Log_ID` = `r`.`p133_Recon_ID`
    180. 

  180.         INNER JOIN `p133_Recon_Status` `rs` ON `r`.`p133_Recon_Status` = `rs`.`Recon_Stat_Code`
    181. 

  181.         INNER JOIN `M012_Tasks` `t` ON `t`.`M012_Task_Driver_Parm5` = `r`.`p133_Stock_no`
    182. 

  182.         WHERE `rs`.`p133_Recon_Status_ID` = '6' AND `t`.`M012_Task_Type` = 'Used Recon' AND `rs`.`Is_Recon` = 'Y' AND `r`.`p133_Stock_Car` = 'N'
    183. 

  183.                 AND DATE_FORMAT(`r`.`p133_Recon_Completed`, '%Y-%m-01') = DATE_FORMAT('{$_REQUEST['period']}', '%Y-%m-01')
    184. 

  184.         GROUP BY `r`.`p133_cDepartment_Sales`";
    185. 

  185. $db->query($sql);
    186. 

  186. while ($row = $db->fetchRow())
    187. 

  187. {
    188. 

  188.     if (empty($data['Avg Sales Days'][$row['Short_Desc']]))
    189. 

  189.     {
    190. 

  190.         $data['Avg Sales Days'][$row['Short_Desc']] = array('Count' => 0, 'Days' => 0);
    191. 

  191.     }
    192. 

  192. 

  193.     $data['Avg Sales Days'][$row['Short_Desc']]['Count'] = $row['Count'];
    194. 

  194.     $data['Avg Sales Days'][$row['Short_Desc']]['Days'] = $row['Days'];
    195. 

  195. }
    196. 

  196. 

  197. /* Recon Current */
    198. 

  198. $sql = "SELECT SUM(`rdl`.`Status_Days_Adjusted`) as `Days`,
    199. 

  199.                `dpt`.`Short_Desc`,
    200. 

  200.                `rtca`.`p133_Recon_Time_Count_As_ID`,
    201. 

  201.                `rtca`.`p133_Target`,
    202. 

  202.                `r`.`p133_Recon_ID`,
    203. 

  203.                `r`.`p133_Stock_no`
    204. 

  204.         FROM `p133_Recon` `r`
    205. 

  205.         INNER JOIN `cDepartment` `dpt` ON `dpt`.`DMS_DPT_Code` = `r`.`p133_cDepartment_Sales` AND `dpt`.`Department_Types_ID` = 1 AND `dpt`.`Dpt_Active` = 'Y'
    206. 

  206.         INNER JOIN `p133_Recon_Days_Log` `rdl` ON `rdl`.`Recon_Master_Log_ID` = `r`.`p133_Recon_ID`
    207. 

  207.         INNER JOIN `p133_Recon_Time_Count_As` `rtca` ON `rtca`.`p133_Recon_Time_Count_As_ID` = `rdl`.`p133_Recon_Time_Count_As_ID`
    208. 

  208.         INNER JOIN `p133_Recon_Status` `rs` ON `r`.`p133_Recon_Status` = `rs`.`Recon_Stat_Code`
    209. 

  209.         INNER JOIN `M012_Tasks` `t` ON `t`.`M012_Task_Driver_Parm5` = `r`.`p133_Stock_no`
    210. 

  210.         WHERE `rs`.`p133_Recon_Status_ID` = '6' AND `t`.`M012_Task_Type` = 'Used Recon' AND `rs`.`Is_Recon` = 'Y' AND `r`.`p133_Stock_Car` = 'N'
    211. 

  211.                 AND DATE_FORMAT(`r`.`p133_Recon_Completed`, '%Y-%m-01') = DATE_FORMAT('{$_REQUEST['period']}', '%Y-%m-01')
    212. 

  212.         GROUP BY `r`.`p133_Recon_ID`, `rtca`.`p133_Recon_Time_Count_As_ID`
    213. 

  213.         HAVING `Days` > `rtca`.`p133_Target`";
    214. 

    215. 

  215. $sql = "SELECT * FROM ($sql) t
    216. 

  216.         GROUP BY `t`.`p133_Recon_ID`";
    217. 

  217. $db->query($sql);
    218. 

  218. while ($row = $db->fetchRow())
    219. 

  219. {
    220. 

  220.     $data['Recon Current'][$row['Short_Desc']]++;
    221. 

  221. }
    222. 

  222. 

  223. /* Wholesale */
    224. 

  224. $sql = "SELECT `dpt`.`Short_Desc`,
    225. 

  225.                DATEDIFF(NOW(), `vehs`.`IntoStock_Date`) as `Days`
    226. 

  226.         FROM `p109_Veh_Stk` `vehs`
    227. 

  227.         INNER JOIN `cDepartment` `dpt` ON `dpt`.`DMS_DPT_Code` = `vehs`.`Dept` AND `dpt`.`Dpt_Active` = 'Y'
    228. 

  228.         WHERE `vehs`.`Dept` IN (180, 380) AND `vehs`.`On_Order` = 'N'";
    229. 

  229. $db->query($sql);
    230. 

  230. while ($row = $db->fetchRow())
    231. 

  231. {
    232. 

  232.     if ($row['Days'] < 10)
    233. 

  233.     {
    234. 

  234.         $data['Wholesale < 10 Days'][$row['Short_Desc']]++;
    235. 

  235.     }
    236. 

  236.     elseif ($row['Days'] >= 10 && $row['Days'] < 20)
    237. 

  237.     {
    238. 

  238.         $data['Wholesale 11 - 20 Days'][$row['Short_Desc']]++;
    239. 

  239.     }
    240. 

  240.     elseif ($row['Days'] >= 20)
    241. 

  241.     {
    242. 

  242.         $data['Wholesale > 20 Days'][$row['Short_Desc']]++;
    243. 

  243.     }
    244. 

  244. }
    245. 

  245. 

  246. /* Deliveries Today */
    247. 

  247. $sql = "SELECT `dpt`.`Short_Desc`,
    248. 

  248.                SUM(DATE(`d`.`Cust_Handover_Date`) = '%%1') AS `Today`,
    249. 

  249.                SUM(DATE(`d`.`Cust_Handover_Date`) = '%%2') AS `Yesterday`,
    250. 

  250.                SUM(DATE(`d`.`Cust_Handover_Date`) = '%%3') AS `DayBefore`
    251. 

  251.         FROM `p077_Deal_Log` `d`
    252. 

  252.         INNER JOIN `cDepartment` `dpt` ON `dpt`.`DMS_DPT_Code` = `d`.`p077_DPTID` AND `dpt`.`Department_Types_ID` = 1 AND `sale_cat` = 'R' AND `dpt`.`Dpt_Active` = 'Y'
    253. 

  253.         GROUP BY `d`.`p077_DPTID`";
    254. 

  254. $db->query($sql, $today, $yesterday, $daybefore);
    255. 

  255. while ($row = $db->fetchRow())
    256. 

  256. {
    257. 

  257.     $data['Deliveries Today'][$row['Short_Desc']]['Today']     = $row['Today'];
    258. 

  258.     $data['Deliveries Today'][$row['Short_Desc']]['Yesterday'] = $row['Yesterday'];
    259. 

  259.     $data['Deliveries Today'][$row['Short_Desc']]['DayBefore'] = $row['DayBefore'];
    260. 

  260. }
    261. 

  261. 

  262. /* Sales2Service Handover */
    263. 

  263. $sql = "SELECT `dpt`.`Short_Desc`,
    264. 

  264.                SUM(`d`.`STS_Handover` = 'Y') as `Y`,
    265. 

  265.                SUM(`d`.`STS_Handover` IN ('Y', 'N', 'DOS', 'NS')) as `All`
    266. 

  266.         FROM `p077_Deal_Log` `d`
    267. 

  267.         INNER JOIN `cDepartment` `dpt` ON `dpt`.`DMS_DPT_Code` = `d`.`p077_DPTID` AND `dpt`.`Department_Types_ID` = 1 AND `dpt`.`Dpt_Active` = 'Y'
    268. 

  268.         WHERE DATE(`d`.`Cust_Handover_Date`) = CURDATE()
    269. 

  269.         GROUP BY `d`.`p077_DPTID`";
    270. 

  270. $db->query($sql);
    271. 

  271. while ($row = $db->fetchRow())
    272. 

  272. {
    273. 

  273.     $data['Sales2Service Handover'][$row['Short_Desc']]['Y']   = $row['Today'];
    274. 

  274.     $data['Sales2Service Handover'][$row['Short_Desc']]['All'] = $row['All'];
    275. 

  275. }
    276. 

  276. 

  277. /* Call Center Penetration */
    278. 

  278. $sql = "SELECT SUM(`nm`.`p101_NPS_Score` BETWEEN 9 AND 10) as `Promoters`,
    279. 

  279.                SUM(`nm`.`p101_NPS_Score` BETWEEN 7 AND 8) as `Passives`,
    280. 

  280.                SUM(`nm`.`p101_NPS_Score` BETWEEN 0 AND 6) as `Detractors`,
    281. 

  281.                COUNT(*) as `Total`,
    282. 

  282.                `dpt`.`Short_Desc`
    283. 

  283.         FROM `p101_NPS_Master` nm
    284. 

  284.         INNER JOIN `cDepartment` `dpt` ON `dpt`.`DMS_DPT_Code` = `nm`.`p101_AOC2` AND `dpt`.`Department_Types_ID` = 1 AND `dpt`.`Dpt_Active` = 'Y'
    285. 

  285.         WHERE DATE_FORMAT(`nm`.`p101_Interaction_Date`, '%Y-%m-01') = '%%1' AND `nm`.`p101_AOC1` = 'Sales'
    286. 

  286.         GROUP BY `dpt`.`DMS_DPT_Code`";
    287. 

  287. $db->query($sql, $_REQUEST['period']);
    288. 

  288. while ($row = $db->fetchRow())
    289. 

  289. {
    290. 

  290.     $data['Call Center Penetration'][$row['Short_Desc']]['Surveyed'] = $row['Promoters'] + $row['Passives'] + $row['Detractors'];
    291. 

  291.     $data['Call Center Penetration'][$row['Short_Desc']]['Total']    = $row['Total'];
    292. 

  292. }
    293. 

  293. 

  294. /* NPS */
    295. 

  295. $sql = "SELECT SUM(`nm`.`p101_NPS_Score` BETWEEN 9 AND 10) as `Promoters`,
    296. 

  296.                SUM(`nm`.`p101_NPS_Score` BETWEEN 0 AND 6) as `Detractors`,
    297. 

  297.                SUM(`nm`.`p101_NPS_Score` > -1) as `Total`,
    298. 

  298.                `dpt`.`Short_Desc`
    299. 

  299.         FROM `p101_NPS_Master` nm
    300. 

  300.         INNER JOIN `cDepartment` `dpt` ON `dpt`.`DMS_DPT_Code` = `nm`.`p101_AOC2` AND `dpt`.`Department_Types_ID` = 1 AND `dpt`.`Dpt_Active` = 'Y'
    301. 

  301.         WHERE DATE(`nm`.`p101_Surveyed`) = CURDATE() AND `nm`.`p101_AOC1` = 'Sales' AND `nm`.`p101_NPS_Status` = 'Completed'
    302. 

  302.         GROUP BY `dpt`.`DMS_DPT_Code`";
    303. 

  303. $db->query($sql);
    304. 

  304. while ($row = $db->fetchRow())
    305. 

  305. {
    306. 

  306.     $data['NPS'][$row['Short_Desc']]['Promoters']  = $row['Promoters'];
    307. 

  307.     $data['NPS'][$row['Short_Desc']]['Detractors'] = $row['Detractors'];
    308. 

  308.     $data['NPS'][$row['Short_Desc']]['Total']      = $row['Total'];
    309. 

  309. }
    310. 

  310. 

  311. /* Parts Not Fitted on Delivery (Outstanding) */
    312. 

  312. $sql = "SELECT `dpt`.`Short_Desc`,
    313. 

  313.                `dpt`.`DMS_DPT_Code`
    314. 

  314.         FROM `p077_Deal_Log` `d`
    315. 

  315.         INNER JOIN `p077_Deal_DET` `det` ON `det`.`p077_Deal_Log_ID` = `d`.`p077_Deal_Log_ID`
    316. 

  316.         INNER JOIN `p109_Veh_Stk` `veh` ON `veh`.`p109_STKNO` = `d`.`p077_Stock_Num`
    317. 

  317.         INNER JOIN `p077_Deal_PNFD_Status` `pnfds` USING(`p077_Deal_PNFD_Status_ID`)
    318. 

  318.         INNER JOIN `cDepartment` `dpt` ON `dpt`.`DMS_DPT_Code` = `d`.`p077_DPTID` AND `dpt`.`Department_Types_ID` = 1 AND `dpt`.`Dpt_Active` = 'Y'
    319. 

  319.         WHERE `pnfds`.`p077_PNFD_Completed_Status` = 'N' AND `pnfds`.`p077_Deal_PNFD_Status_ID` <> 4
    320. 

  320.         GROUP BY `d`.`p077_Deal_Log_ID`";
    321. 

  321. $sql = "SELECT *,
    322. 

  322.                COUNT(*) as `Count`
    323. 

  323.         FROM ($sql) t
    324. 

  324.         GROUP BY `t`.`DMS_DPT_Code`";
    325. 

  325. $db->query($sql);
    326. 

  326. while ($row = $db->fetchRow())
    327. 

  327. {
    328. 

  328.     if (isset($data['Parts Not Fitted on Delivery (Outstanding)'][$row['Short_Desc']]))
    329. 

  329.     {
    330. 

  330.         $data['Parts Not Fitted on Delivery (Outstanding)'][$row['Short_Desc']] = $row['Count'];
    331. 

  331.     }
    332. 

  332. }
    333. 

  333. 

  334. /* Parts Not Fitted on Delivery (Booked) */
    335. 

  335. $sql = "SELECT `dpt`.`Short_Desc`,
    336. 

  336.                `dpt`.`DMS_DPT_Code`
    337. 

  337.         FROM `p077_Deal_Log` `d`
    338. 

  338.         INNER JOIN `p077_Deal_DET` `det` ON `det`.`p077_Deal_Log_ID` = `d`.`p077_Deal_Log_ID`
    339. 

  339.         INNER JOIN `p109_Veh_Stk` `veh` ON `veh`.`p109_STKNO` = `d`.`p077_Stock_Num`
    340. 

  340.         INNER JOIN `p077_Deal_PNFD_Status` `pnfds` USING(`p077_Deal_PNFD_Status_ID`)
    341. 

  341.         INNER JOIN `cDepartment` `dpt` ON `dpt`.`DMS_DPT_Code` = `d`.`p077_DPTID` AND `dpt`.`Department_Types_ID` = 1 AND `dpt`.`Dpt_Active` = 'Y'
    342. 

  342.         WHERE `pnfds`.`p077_Deal_PNFD_Status_ID` = 4
    343. 

  343.         GROUP BY `d`.`p077_Deal_Log_ID`";
    344. 

  344. $sql = "SELECT *,
    345. 

  345.                COUNT(*) as `Count`
    346. 

  346.         FROM ($sql) t
    347. 

  347.         GROUP BY `t`.`DMS_DPT_Code`";
    348. 

  348. $db->query($sql);
    349. 

  349. while ($row = $db->fetchRow())
    350. 

  350. {
    351. 

  351.     if (isset($data['Parts Not Fitted on Delivery (Booked)'][$row['Short_Desc']]))
    352. 

  352.     {
    353. 

  353.         $data['Parts Not Fitted on Delivery (Booked)'][$row['Short_Desc']] = $row['Count'];
    354. 

  354.     }
    355. 

  355. }
    356. 

  356. 

  357. /* Target Gross */
    358. 

  358. $exportCodes = array();
    359. 

  359. foreach($departments as $department)
    360. 

  360. {
    361. 

  361.     $exportCodes[] = "DL\\\\DB\\\\SM\\\\{$department->DMS_DPT_Code}\\\\Target\\\\TOT_EX_FI";
    362. 

  362. }
    363. 

  363. 

  364. $exportCodes = implode("', '", $exportCodes);
    365. 

  365. 

  366. $sql = "SELECT * FROM `b005_MSTDET_Share`
    367. 

  367.         WHERE `b005_CODE` IN ('$exportCodes') AND DATE_FORMAT(`ASAT`, '%Y-%m-01') = '%%1'";
    368. 

  368. $db->query($sql, $_REQUEST['period']);
    369. 

  369. 

  370. while ($row = $db->fetchRow())
    371. 

  371. {
    372. 

  372.     $b005_CODE = $row['b005_CODE'];
    373. 

  373.     $DMS_DPT_Code = substr(substr($b005_CODE, 9), 0, -17);
    374. 

  374.     $Short_Desc = $departments[$DMS_DPT_Code]->Short_Desc;
    375. 

  375.     $data['Target Gross'][$Short_Desc] = $row['Result'];
    376. 

  376. }
    377. 

  377. 

  378. /* Target Units */
    379. 

  379. $exportCodes = array();
    380. 

  380. foreach($departments as $department)
    381. 

  381. {
    382. 

  382.     $exportCodes[] = "DL\\\\DB\\\\SM\\\\{$department->DMS_DPT_Code}\\\\Target\\\\DelTarget";
    383. 

  383. }
    384. 

  384. 

  385. $exportCodes = implode("', '", $exportCodes);
    386. 

  386. 

  387. $sql = "SELECT * FROM `b005_MSTDET_Share`
    388. 

  388.         WHERE `b005_CODE` IN ('$exportCodes') AND DATE_FORMAT(`ASAT`, '%Y-%m-01') = '%%1'";
    389. 

  389. $db->query($sql, $_REQUEST['period']);
    390. 

  390. 

  391. while ($row = $db->fetchRow())
    392. 

  392. {
    393. 

  393.     $b005_CODE = $row['b005_CODE'];
    394. 

  394.     $DMS_DPT_Code = substr(substr($b005_CODE, 9), 0, -17);
    395. 

  395.     $Short_Desc = $departments[$DMS_DPT_Code]->Short_Desc;
    396. 

  396.     $data['Target Units'][$Short_Desc] = $row['Result'];
    397. 

  397. }
    398. 

  398. 

  399. /* Weekly Dots Gross */
    400. 

  400. $exportCodes = array();
    401. 

  401. foreach($departments as $department)
    402. 

  402. {
    403. 

  403.     $exportCodes[] = "DL\\\\DB\\\\DPT\\\\{$department->DMS_DPT_Code}\\\\Dots\\\\Week1\\\\TOT_EX_FI";
    404. 

  404.     $exportCodes[] = "DL\\\\DB\\\\DPT\\\\{$department->DMS_DPT_Code}\\\\Dots\\\\Week2\\\\TOT_EX_FI";
    405. 

  405.     $exportCodes[] = "DL\\\\DB\\\\DPT\\\\{$department->DMS_DPT_Code}\\\\Dots\\\\Week3\\\\TOT_EX_FI";
    406. 

  406.     $exportCodes[] = "DL\\\\DB\\\\DPT\\\\{$department->DMS_DPT_Code}\\\\Dots\\\\Week4\\\\TOT_EX_FI";
    407. 

  407. }
    408. 

  408. 

  409. $exportCodes = implode("', '", $exportCodes);
    410. 

  410. 

  411. $sql = "SELECT * FROM `b005_MSTDET_Share`
    412. 

  412.         WHERE `b005_CODE` IN ('$exportCodes') AND DATE_FORMAT(`ASAT`, '%Y-%m-01') = '%%1'";
    413. 

  413. $db->query($sql, $_REQUEST['period']);
    414. 

  414. 

  415. while ($row = $db->fetchRow())
    416. 

  416. {
    417. 

  417.     $b005_CODE = $row['b005_CODE'];
    418. 

  418.     $tokens = explode('\\', $b005_CODE);
    419. 

  419.     $DMS_DPT_Code = $tokens[3];
    420. 

  420.     $Short_Desc = $departments[$DMS_DPT_Code]->Short_Desc;
    421. 

  421.     $data['Weekly Dots Gross'][$Short_Desc] += $row['Result'];
    422. 

  422. }
    423. 

  423. 

  424. /* Weekly Dots Units */
    425. 

  425. $exportCodes = array();
    426. 

  426. foreach($departments as $department)
    427. 

  427. {
    428. 

  428.     $exportCodes[] = "DL\\\\DB\\\\DPT\\\\{$department->DMS_DPT_Code}\\\\Dots\\\\Week1\\\\DelTarget";
    429. 

  429.     $exportCodes[] = "DL\\\\DB\\\\DPT\\\\{$department->DMS_DPT_Code}\\\\Dots\\\\Week2\\\\DelTarget";
    430. 

  430.     $exportCodes[] = "DL\\\\DB\\\\DPT\\\\{$department->DMS_DPT_Code}\\\\Dots\\\\Week3\\\\DelTarget";
    431. 

  431.     $exportCodes[] = "DL\\\\DB\\\\DPT\\\\{$department->DMS_DPT_Code}\\\\Dots\\\\Week4\\\\DelTarget";
    432. 

  432. }
    433. 

  433. 

  434. $exportCodes = implode("', '", $exportCodes);
    435. 

  435. 

  436. $sql = "SELECT * FROM `b005_MSTDET_Share`
    437. 

  437.         WHERE `b005_CODE` IN ('$exportCodes') AND DATE_FORMAT(`ASAT`, '%Y-%m-01') = '%%1'";
    438. 

  438. $db->query($sql, $_REQUEST['period']);
    439. 

  439. 

  440. while ($row = $db->fetchRow())
    441. 

  441. {
    442. 

  442.     $b005_CODE = $row['b005_CODE'];
    443. 

  443.     $tokens = explode('\\', $b005_CODE);
    444. 

  444.     $DMS_DPT_Code = $tokens[3];
    445. 

  445.     $Short_Desc = $departments[$DMS_DPT_Code]->Short_Desc;
    446. 

  446.     $data['Weekly Dots Units'][$Short_Desc] += $row['Result'];
    447. 

  447. }
    448. 

  448. 

  449. /* ITU (Individual) */
    450. 

  450. $departmentCodes = implode("', '", array_keys($departments));
    451. 

  451. $sql = "SELECT `p`.`cPeople_ID`,
    452. 

  452.                `p`.`SLMID`,
    453. 

  453.                `dpt`.`DMS_DPT_Code`
    454. 

  454.         FROM `cPeople` `p`
    455. 

  455.         INNER JOIN `cDepartment` `dpt` ON `dpt`.`cDepartment_ID` = `p`.`cDepartment` AND `dpt`.`Dpt_Active` = 'Y'
    456. 

  456.         WHERE `p`.`Active` <> 0 AND `dpt`.`DMS_DPT_Code` IN ('$departmentCodes')
    457. 

  457.         ORDER BY `p`.`cPeople_ID` ASC";
    458. 

  458. $db->query($sql);
    459. 

  459. $peopleDepartments = array();
    460. 

  460. $shareCodes = array();
    461. 

  461. while ($row = $db->fetchRow())
    462. 

  462. {
    463. 

  463.     $shareCodes[] = "DL\\\\DB\\\\SM\\\\{$row['SLMID']}\\\\Target\\\\DelTarget";
    464. 

  464.     $peopleDepartments[$row['SLMID']] = $row['DMS_DPT_Code'];
    465. 

  465. }
    466. 

  466. 

  467. $shareCodes = implode("', '", $shareCodes);
    468. 

  468. 

  469. $sql = "SELECT * FROM `b005_MSTDET_Share`
    470. 

  470.         WHERE `b005_CODE` IN ('$shareCodes') AND DATE_FORMAT(`ASAT`, '%Y-%m-01') = '%%1'";
    471. 

  471. $db->query($sql, $_REQUEST['period']);
    472. 

  472. 

  473. while ($row = $db->fetchRow())
    474. 

  474. {
    475. 

  475.     $b005_CODE = $row['b005_CODE'];
    476. 

  476.     $SLMID = substr(substr($b005_CODE, 9), 0, -17);
    477. 

  477.     $DMS_DPT_Code = $peopleDepartments[$SLMID];
    478. 

  478.     $Short_Desc = $departments[$DMS_DPT_Code]->Short_Desc;
    479. 

  479. 

  480.     if (!isset($data['ITU (Individual)'][$Short_Desc]))
    481. 

  481.     {
    482. 

  482.         $data['ITU (Individual)'][$Short_Desc] = 0;
    483. 

  483.     }
    484. 

  484. 

  485.     $data['ITU (Individual)'][$Short_Desc] += $row['Result'];
    486. 

  486. }
    487. 

  487. 

  488. /* Total Completed */
    489. 

  489. $sql = "SELECT `dpt`.`Short_Desc`,
    490. 

  490.                SUM(`h`.`completed_date` <> '0000-00-00 00:00:00' AND DATE(`p`.`Review_Due`) >= DATE(NOW())) as `Total_Completed`,
    491. 

  491.                SUM(DATE(`p`.`Review_Due`) > DATE(NOW())) as `Total_Scheduled`,
    492. 

  492.                SUM(`h`.`p115_Status` = 'Completed' AND `h`.`hr_status` = 'Ready') as `Total_Waiting_HR_Approval`,
    493. 

  493.                SUM(`h`.`p115_Status` = 'Completed' AND `h`.`mgrs_mgr_status` = 'Ready') as `Total_Waiting_Manager_Approval`,
    494. 

  494.                COUNT(*) as `Count`
    495. 

  495. 

  496.         FROM `cDepartment` `dpt`
    497. 

  497.         INNER JOIN `cPeople` `p` ON `p`.`PhoneBook_cDepartment_ID` = `dpt`.`cDepartment_ID`
    498. 

  498.         INNER JOIN `p115_Per_R_Header` `h` ON `h`.`employee_id` = `p`.`cPeople_ID`
    499. 

  499.         WHERE `dpt`.`DMS_DPT_Code` IN ('$departmentCodes') AND `p`.`p115_Include` = 'Y' AND `p`.`Active` <> 0 AND `dpt`.`Show_Per_Review_Summary` = 'Y' AND `dpt`.`Dpt_Active` = 'Y'
    500. 

  500.         GROUP BY `dpt`.`DMS_DPT_Code`";
    501. 

    502. 

  502. $db->query($sql);
    503. 

  503. while ($row = $db->fetchRow())
    504. 

  504. {
    505. 

  505.     $data['Total Completed'][$row['Short_Desc']] += $row['Total_Completed'];
    506. 

  506.     $data['Total Scheduled'][$row['Short_Desc']] += $row['Total_Scheduled'];
    507. 

  507.     $data['Total Waiting Manager Approval'][$row['Short_Desc']] += $row['Total_Waiting_Manager_Approval'];
    508. 

  508.     $data['Total Waiting HR Approval'][$row['Short_Desc']] += $row['Total_Waiting_HR_Approval'];
    509. 

  509. }
    510. 

  510. ?>
    511. 

  511. <h3>Stats below are Work in Progress</h3>
    512. 

  512. <table class="list-table highlight-row" cellpadding="0" cellspacing="0" id="sales-departments-table">
    513. 

  513.     <tr>
    514. 

  514.         <th>&nbsp;</th>
    515. 

  515.         <th>Total</th>
    516. 

  516.     <?php foreach ($departments as $department): ?>
    517. 

  517.         <th><?php echo $department->Short_Desc; ?></th>
    518. 

  518.     <?php endforeach ?>
    519. 

  519.     </tr>
    520. 

  520. 

  521.     <?php $name = 'Orphans (Net) >30min'; $total = 0 ?>
    522. 

  522.     <tr>
    523. 

  523.         <td><?php echo $name; ?></td>
    524. 

  524.     <?php ob_start() ?>
    525. 

  525.     <?php foreach ($departments as $department): ?>
    526. 

  526.         <td class="align-center">
    527. 

  527.         <?php if (isset($data[$name][$department->Short_Desc])): ?>
    528. 

  528.             <?php if ($data[$name][$department->Short_Desc] > 0): ?>
    529. 

  529.                 <a target="_blank" href="/p078_dealerd1/p108_Lead_Management/Diary/Diary_Log.php?department=<?php echo $department->cDepartment_ID; ?>&status=1&salesperson=%40All&leadTypeId=3&category=&search=&deal=&publication=&mediaType=&campaign=&reminderOn=%40All&dataQ=&from_search=&refund_request=@All"><?php echo number_format($data[$name][$department->Short_Desc], 0); ?></a>
    530. 

  530.             <?php else: ?>
    531. 

  531.                 &nbsp;
    532. 

  532.             <?php endif ?>
    533. 

  533.             <?php $total += $data[$name][$department->Short_Desc]; ?>
    534. 

  534.         <?php else: ?>
    535. 

  535.             0
    536. 

  536.         <?php endif ?>
    537. 

  537.         </td>
    538. 

  538.     <?php endforeach ?>
    539. 

  539.     <?php $html = ob_get_clean() ?>
    540. 

  540. 

  541.         <td class="align-center bold">
    542. 

  542.             <?php if ($total > 0): ?>
    543. 

  543.                 <a target="_blank" href="/p078_dealerd1/p108_Lead_Management/Diary/Diary_Log.php?department=&status=1&salesperson=%40All&leadTypeId=3&category=&search=&deal=&publication=&mediaType=&campaign=&reminderOn=%40All&dataQ=&from_search=&refund_request=@All"><?php echo number_format($total, 0); ?></a>
    544. 

  544.             <?php else: ?>
    545. 

  545.                 &nbsp;
    546. 

  546.             <?php endif ?>
    547. 

  547.         </td>
    548. 

  548. 

  549.         <?php echo $html; ?>
    550. 

  550.     </tr>
    551. 

  551. 

  552.     <?php $name = 'Orphans >1hr'; $total = 0 ?>
    553. 

  553.     <tr>
    554. 

  554.         <td><?php echo $name; ?></td>
    555. 

  555.     <?php ob_start() ?>
    556. 

  556.     <?php foreach ($departments as $department): ?>
    557. 

  557.         <td class="align-center">
    558. 

  558.         <?php if (isset($data[$name][$department->Short_Desc])): ?>
    559. 

  559.             <?php if ($data[$name][$department->Short_Desc] > 0): ?>
    560. 

  560.                 <a target="_blank" href="/p078_dealerd1/p108_Lead_Management/Diary/Diary_Log.php?department=<?php echo $department->cDepartment_ID; ?>&status=1&salesperson=%40All&leadTypeId=&category=&search=&deal=&publication=&mediaType=&campaign=&reminderOn=%40All&dataQ=&from_search=&refund_request=@All"><?php echo number_format($data[$name][$department->Short_Desc], 0); ?></a>
    561. 

  561.             <?php else: ?>
    562. 

  562.                 &nbsp;
    563. 

  563.             <?php endif ?>
    564. 

  564.             <?php $total += $data[$name][$department->Short_Desc]; ?>
    565. 

  565.         <?php else: ?>
    566. 

  566.             0
    567. 

  567.         <?php endif ?>
    568. 

  568.         </td>
    569. 

  569.     <?php endforeach ?>
    570. 

  570.     <?php $html = ob_get_clean() ?>
    571. 

  571. 

  572.         <td class="align-center bold">
    573. 

  573.             <?php if ($total > 0): ?>
    574. 

  574.                 <a target="_blank" href="/p078_dealerd1/p108_Lead_Management/Diary/Diary_Log.php?department=&status=1&salesperson=%40All&leadTypeId=&category=&search=&deal=&publication=&mediaType=&campaign=&reminderOn=%40All&dataQ=&from_search=&refund_request=@All"><?php echo number_format($total, 0); ?></a>
    575. 

  575.             <?php else: ?>
    576. 

  576.                 &nbsp;
    577. 

  577.             <?php endif ?>
    578. 

  578.         </td>
    579. 

  579. 

  580.         <?php echo $html; ?>
    581. 

  581.     </tr>
    582. 

  582. 

  583.     <?php $name = 'Orphans >16hrs'; $total = 0 ?>
    584. 

  584.     <tr>
    585. 

  585.         <td><?php echo $name; ?></td>
    586. 

  586.     <?php ob_start() ?>
    587. 

  587.     <?php foreach ($departments as $department): ?>
    588. 

  588.         <td class="align-center">
    589. 

  589.         <?php if (isset($data[$name][$department->Short_Desc])): ?>
    590. 

  590.             <?php if ($data[$name][$department->Short_Desc] > 0): ?>
    591. 

  591.                 <a target="_blank" href="/p078_dealerd1/p108_Lead_Management/Diary/Diary_Log.php?department=<?php echo $department->cDepartment_ID; ?>&status=1&salesperson=%40All&leadTypeId=&category=&search=&deal=&publication=&mediaType=&campaign=&reminderOn=%40All&dataQ=&from_search=&refund_request=@All"><?php echo number_format($data[$name][$department->Short_Desc], 0); ?></a>
    592. 

  592.             <?php else: ?>
    593. 

  593.                 &nbsp;
    594. 

  594.             <?php endif ?>
    595. 

  595.             <?php $total += $data[$name][$department->Short_Desc]; ?>
    596. 

  596.         <?php else: ?>
    597. 

  597.             0
    598. 

  598.         <?php endif ?>
    599. 

  599.         </td>
    600. 

  600.     <?php endforeach ?>
    601. 

  601.     <?php $html = ob_get_clean() ?>
    602. 

  602. 

  603.         <td class="align-center bold">
    604. 

  604.             <?php if ($total > 0): ?>
    605. 

  605.                 <a target="_blank" href="/p078_dealerd1/p108_Lead_Management/Diary/Diary_Log.php?department=&status=1&salesperson=%40All&leadTypeId=&category=&search=&deal=&publication=&mediaType=&campaign=&reminderOn=%40All&dataQ=&from_search=&refund_request=@All"><?php echo number_format($total, 0); ?></a>
    606. 

  606.             <?php else: ?>
    607. 

  607.                 &nbsp;
    608. 

  608.             <?php endif; ?>
    609. 

  609.         </td>
    610. 

  610. 

  611.         <?php echo $html; ?>
    612. 

  612.     </tr>
    613. 

  613. 

  614.     <?php $name = 'Internet Escalated'; $total = 0 ?>
    615. 

  615.     <tr>
    616. 

  616.         <td><?php echo $name; ?></td>
    617. 

  617.     <?php ob_start() ?>
    618. 

  618.     <?php foreach ($departments as $department): ?>
    619. 

  619.         <td class="align-center">
    620. 

  620.         <?php if (isset($data[$name][$department->Short_Desc])): ?>
    621. 

  621.             <?php if ($data[$name][$department->Short_Desc] > 0): ?>
    622. 

  622.                 <a target="_blank" href="/p078_dealerd1/p108_Lead_Management/Diary/Diary_Log.php?department=<?php echo $department->cDepartment_ID; ?>&status=@AllActive&salesperson=@All&leadTypeId=3&category=&search=&deal=&publication=&mediaType=&campaign=&reminderOn=@All&dataQ=&from_search=&refund_request=@All"><?php echo number_format($data[$name][$department->Short_Desc], 0); ?></a>
    623. 

  623.             <?php else: ?>
    624. 

  624.                 &nbsp;
    625. 

  625.             <?php endif ?>
    626. 

  626.             <?php $total += $data[$name][$department->Short_Desc]; ?>
    627. 

  627.         <?php else: ?>
    628. 

  628.             0
    629. 

  629.         <?php endif ?>
    630. 

  630.         </td>
    631. 

  631.     <?php endforeach ?>
    632. 

  632.     <?php $html = ob_get_clean() ?>
    633. 

  633. 

  634.         <td class="align-center bold">
    635. 

  635.             <?php if ($total > 0): ?>
    636. 

  636.                 <a target="_blank" href="/p078_dealerd1/p108_Lead_Management/Diary/Diary_Log.php?department=&status=@AllActive&salesperson=@All&leadTypeId=3&category=&search=&deal=&publication=&mediaType=&campaign=&reminderOn=@All&dataQ=&from_search=&refund_request=@All"><?php echo number_format($total, 0); ?></a>
    637. 

  637.             <?php else: ?>
    638. 

  638.                 &nbsp;
    639. 

  639.             <?php endif; ?>
    640. 

  640.         </td>
    641. 

  641. 

  642.         <?php echo $html; ?>
    643. 

  643.     </tr>
    644. 

  644. 

  645.     <tr><td colspan="<?php echo count($departments) + 2; ?>">&nbsp;</td></tr>
    646. 

  646. 

  647.     <?php $name = "Lost >$lostDays day"; $total = 0 ?>
    648. 

  648.     <tr>
    649. 

  649.         <td><?php echo $name; ?></td>
    650. 

  650.     <?php ob_start() ?>
    651. 

  651.     <?php foreach ($departments as $department): ?>
    652. 

  652.         <td class="align-center">
    653. 

  653.         <?php if (isset($data[$name][$department->Short_Desc])): ?>
    654. 

  654.             <?php if ($data[$name][$department->Short_Desc] > 0): ?>
    655. 

  655.                 <a target="_blank" href="/p078_dealerd1/p108_Lead_Management/Diary/Diary_Log.php?department=<?php echo $department->cDepartment_ID; ?>&status=11&salesperson=%40All&leadTypeId=&category=&search=&deal=&publication=&mediaType=&campaign=&reminderOn=%40All&dataQ=&from_search=&refund_request=@All"><?php echo number_format($data[$name][$department->Short_Desc], 0); ?></a>
    656. 

  656.             <?php else: ?>
    657. 

  657.                 &nbsp;
    658. 

  658.             <?php endif; ?>
    659. 

  659.             <?php $total += $data[$name][$department->Short_Desc]; ?>
    660. 

  660.         <?php else: ?>
    661. 

  661.             0
    662. 

  662.         <?php endif ?>
    663. 

  663.         </td>
    664. 

  664.     <?php endforeach ?>
    665. 

  665.     <?php $html = ob_get_clean() ?>
    666. 

  666. 

  667.         <td class="align-center bold">
    668. 

  668.             <?php if ($total > 0): ?>
    669. 

  669.                 <a target="_blank" href="/p078_dealerd1/p108_Lead_Management/Diary/Diary_Log.php?department=&status=11&salesperson=%40All&leadTypeId=&category=&search=&deal=&publication=&mediaType=&campaign=&reminderOn=%40All&dataQ=&from_search=&refund_request=@All"><?php echo number_format($total, 0); ?></a>
    670. 

  670.             <?php else: ?>
    671. 

  671.                 &nbsp;
    672. 

  672.             <?php endif ?>
    673. 

  673.         </td>
    674. 

  674. 

  675.         <?php echo $html; ?>
    676. 

  676.     </tr>
    677. 

  677. 

  678.     <tr><td colspan="<?php echo count($departments) + 2; ?>">&nbsp;</td></tr>
    679. 

  679. 

  680.     <?php $name = 'Target Gross'; $total = 0 ?>
    681. 

  681.     <tr>
    682. 

  682.         <td><?php echo $name; ?></td>
    683. 

  683.     <?php ob_start() ?>
    684. 

  684.     <?php foreach ($departments as $department): ?>
    685. 

  685.         <td class="align-center">
    686. 

  686.         <?php if (isset($data[$name][$department->Short_Desc]) && $data[$name][$department->Short_Desc] > 0): ?>
    687. 

  687.             <a target="blank" href="/p078_dealerd1/Dashboard1/Sales_Dashboard/Targets.php?month=<?php echo $_REQUEST['period']; ?>&department=<?php echo $department->DMS_DPT_Code; ?>">$<?php echo number_format($data[$name][$department->Short_Desc], 0); ?></a>
    688. 

  688.             <?php $total += $data[$name][$department->Short_Desc]; ?>
    689. 

  689.         <?php else: ?>
    690. 

  690.             $0
    691. 

  691.         <?php endif ?>
    692. 

  692.         </td>
    693. 

  693.     <?php endforeach ?>
    694. 

  694.         <?php $html = ob_get_clean() ?>
    695. 

  695. 

  696.         <td class="align-center bold">
    697. 

  697.         <?php if ($total > 0): ?>
    698. 

  698.             <a target="blank" href="/p078_dealerd1/Dashboard1/Sales_Dashboard/Targets.php?month=<?php echo $_REQUEST['period']; ?>&department=@All">$<?php echo number_format($total, 0); ?></a>
    699. 

  699.         <?php else: ?>
    700. 

  700.             $0
    701. 

  701.         <?php endif ?>
    702. 

  702.         </td>
    703. 

  703. 

  704.         <?php echo $html; ?>
    705. 

  705.     </tr>
    706. 

  706. 

  707.     <?php $name = 'Target Units'; $total = 0 ?>
    708. 

  708.     <tr>
    709. 

  709.         <td><?php echo $name; ?></td>
    710. 

  710.     <?php ob_start() ?>
    711. 

  711.     <?php foreach ($departments as $department): ?>
    712. 

  712.         <td class="align-center">
    713. 

  713.         <?php if (isset($data[$name][$department->Short_Desc]) && $data[$name][$department->Short_Desc] > 0): ?>
    714. 

  714.             <a target="blank" href="/p078_dealerd1/Dashboard1/Sales_Dashboard/Targets.php?month=<?php echo $_REQUEST['period']; ?>&department=<?php echo $department->DMS_DPT_Code; ?>"><?php echo number_format($data[$name][$department->Short_Desc], 0); ?></a>
    715. 

  715.             <?php $total += $data[$name][$department->Short_Desc]; ?>
    716. 

  716.         <?php else: ?>
    717. 

  717.             0
    718. 

  718.         <?php endif ?>
    719. 

  719.         </td>
    720. 

  720.     <?php endforeach ?>
    721. 

  721.         <?php $html = ob_get_clean() ?>
    722. 

  722. 

  723.         <td class="align-center bold">
    724. 

  724.         <?php if ($total > 0): ?>
    725. 

  725.             <a target="blank" href="/p078_dealerd1/Dashboard1/Sales_Dashboard/Targets.php?month=<?php echo $_REQUEST['period']; ?>&department=@All"><?php echo number_format($total, 0); ?></a>
    726. 

  726.         <?php else: ?>
    727. 

  727.             0
    728. 

  728.         <?php endif ?>
    729. 

  729.         </td>
    730. 

  730. 

  731.         <?php echo $html; ?>
    732. 

  732.     </tr>
    733. 

  733. 

  734.     <?php $name = 'Weekly Dots Gross'; $total = 0 ?>
    735. 

  735.     <tr>
    736. 

  736.         <td><?php echo $name; ?></td>
    737. 

  737.     <?php ob_start() ?>
    738. 

  738.     <?php foreach ($departments as $department): ?>
    739. 

  739.         <td class="align-center">
    740. 

  740.         <?php if (isset($data[$name][$department->Short_Desc]) && $data[$name][$department->Short_Desc] > 0): ?>
    741. 

  741.             <a target="blank" href="/p078_dealerd1/Dashboard1/Sales_Dashboard/Weekly_Targets.php?month=<?php echo $_REQUEST['period']; ?>">$<?php echo number_format($data[$name][$department->Short_Desc], 0); ?></a>
    742. 

  742.             <?php $total += $data[$name][$department->Short_Desc]; ?>
    743. 

  743.         <?php else: ?>
    744. 

  744.             $0
    745. 

  745.         <?php endif ?>
    746. 

  746.         </td>
    747. 

  747.     <?php endforeach ?>
    748. 

  748.         <?php $html = ob_get_clean() ?>
    749. 

  749. 

  750.         <td class="align-center bold">
    751. 

  751.         <?php if ($total > 0): ?>
    752. 

  752.             <a target="blank" href="/p078_dealerd1/Dashboard1/Sales_Dashboard/Weekly_Targets.php?month=<?php echo $_REQUEST['period']; ?>">$<?php echo number_format($total, 0); ?></a>
    753. 

  753.         <?php else: ?>
    754. 

  754.             $0
    755. 

  755.         <?php endif ?>
    756. 

  756.         </td>
    757. 

  757. 

  758.         <?php echo $html; ?>
    759. 

  759.     </tr>
    760. 

  760. 

  761.     <?php $name = 'Weekly Dots Units'; $total = 0 ?>
    762. 

  762.     <tr>
    763. 

  763.         <td><?php echo $name; ?></td>
    764. 

  764.     <?php ob_start() ?>
    765. 

  765.     <?php foreach ($departments as $department): ?>
    766. 

  766.         <td class="align-center">
    767. 

  767.         <?php if (isset($data[$name][$department->Short_Desc]) && $data[$name][$department->Short_Desc] > 0): ?>
    768. 

  768.             <a target="blank" href="/p078_dealerd1/Dashboard1/Sales_Dashboard/Weekly_Targets.php?month=<?php echo $_REQUEST['period']; ?>"><?php echo number_format($data[$name][$department->Short_Desc], 0); ?></a>
    769. 

  769.             <?php $total += $data[$name][$department->Short_Desc]; ?>
    770. 

  770.         <?php else: ?>
    771. 

  771.             0
    772. 

  772.         <?php endif ?>
    773. 

  773.         </td>
    774. 

  774.     <?php endforeach ?>
    775. 

  775.         <?php $html = ob_get_clean() ?>
    776. 

  776. 

  777.         <td class="align-center bold">
    778. 

  778.         <?php if ($total > 0): ?>
    779. 

  779.             <a target="blank" href="/p078_dealerd1/Dashboard1/Sales_Dashboard/Weekly_Targets.php?month=<?php echo $_REQUEST['period']; ?>"><?php echo number_format($total, 0); ?></a>
    780. 

  780.         <?php else: ?>
    781. 

  781.             0
    782. 

  782.         <?php endif ?>
    783. 

  783.         </td>
    784. 

  784. 

  785.         <?php echo $html; ?>
    786. 

  786.     </tr>
    787. 

  787. 

  788.     <?php $name = 'ITU (Individual)'; $total = 0 ?>
    789. 

  789.     <tr>
    790. 

  790.         <td><?php echo $name; ?></td>
    791. 

  791.     <?php ob_start() ?>
    792. 

  792.     <?php foreach ($departments as $department): ?>
    793. 

  793.         <td class="align-center">
    794. 

  794.         <?php if (isset($data[$name][$department->Short_Desc]) && $data[$name][$department->Short_Desc] > 0): ?>
    795. 

  795.             <a target="blank" href="/p078_dealerd1/Dashboard1/Sales_Dashboard/Targets.php?month=<?php echo $_REQUEST['period']; ?>&department=<?php echo $department->DMS_DPT_Code; ?>"><?php echo number_format($data[$name][$department->Short_Desc], 0); ?></a>
    796. 

  796.             <?php $total += $data[$name][$department->Short_Desc]; ?>
    797. 

  797.         <?php else: ?>
    798. 

  798.             0
    799. 

  799.         <?php endif ?>
    800. 

  800.         </td>
    801. 

  801.     <?php endforeach ?>
    802. 

  802.         <?php $html = ob_get_clean() ?>
    803. 

  803. 

  804.         <td class="align-center bold">
    805. 

  805.         <?php if ($total > 0): ?>
    806. 

  806.             <a target="blank" href="/p078_dealerd1/Dashboard1/Sales_Dashboard/Targets.php?month=<?php echo $_REQUEST['period']; ?>&department=@All"><?php echo number_format($total, 0); ?></a>
    807. 

  807.         <?php else: ?>
    808. 

  808.             0
    809. 

  809.         <?php endif ?>
    810. 

  810.         </td>
    811. 

  811. 

  812.         <?php echo $html; ?>
    813. 

  813.     </tr>
    814. 

  814. 

  815.     <?php $name = 'GSM Dashboard'; $total = 0 ?>
    816. 

  816.     <tr>
    817. 

  817.         <td><?php echo $name; ?></td>
    818. 

  818. 

  819.         <td class="align-center">
    820. 

  820.             [<a target="_blank" href="/p078_dealerd1/Dashboard1/GSM_Dashboard/index.php?month=<?php echo $_REQUEST['period']; ?>&department=@All">Dash</a>]
    821. 

  821.         </td>
    822. 

  822. 

  823.     <?php foreach ($departments as $department): ?>
    824. 

  824.         <?php $departmentFilter = '@All'; ?>
    825. 

  825.         <?php if (!empty($department->Franchise)): ?>
    826. 

  826.             <?php $departmentFilter = '$Franchise-' . $department->Franchise; ?>
    827. 

  827.         <?php elseif ($department->Location_Group == 'Booval'): ?>
    828. 

  828.             <?php $departmentFilter = '@1' ?>
    829. 

  829.         <?php elseif ($department->Location_Group == 'Laidley'): ?>
    830. 

  830.             <?php $departmentFilter = '@2' ?>
    831. 

  831.         <?php endif ?>
    832. 

  832.         <td class="align-center">
    833. 

  833.             [<a target="_blank" href="/p078_dealerd1/Dashboard1/GSM_Dashboard/index.php?month=<?php echo $_REQUEST['period']; ?>&department=<?php echo $departmentFilter ?>">Dash</a>]
    834. 

  834.         </td>
    835. 

  835.     <?php endforeach ?>
    836. 

  836.     </tr>
    837. 

  837. 

  838.     <?php $name = 'Deal Situation'; $total = 0 ?>
    839. 

  839.     <tr>
    840. 

  840.         <td><?php echo $name; ?></td>
    841. 

  841.     <?php ob_start() ?>
    842. 

  842.     <?php foreach ($departments as $department): ?>
    843. 

  843.         <td class="align-center">
    844. 

  844.         <?php if (isset($data[$name][$department->Short_Desc])): ?>
    845. 

  845.             <?php if ($data[$name][$department->Short_Desc] > 0): ?>
    846. 

  846.                 <a target="_blank" href="/p078_dealerd1/p077_DealLog1/PD_Main/Deal_Situation_Overview.php?month=<?php echo $_REQUEST['period']; ?>&category=@All&person=@All&fin_manager=@All&show_for=@All&department=<?php echo $department->DMS_DPT_Code; ?>&reference_no=@Stock"><?php echo number_format($data[$name][$department->Short_Desc], 0); ?></a>
    847. 

  847.             <?php else: ?>
    848. 

  848.                 &nbsp;
    849. 

  849.             <?php endif; ?>
    850. 

  850.             <?php $total += $data[$name][$department->Short_Desc]; ?>
    851. 

  851.         <?php else: ?>
    852. 

  852.             &nbsp;
    853. 

  853.         <?php endif ?>
    854. 

  854.         </td>
    855. 

  855.     <?php endforeach ?>
    856. 

  856.         <?php $html = ob_get_clean() ?>
    857. 

  857. 

  858.         <td class="align-center bold">
    859. 

  859.             <?php if ($total > 0): ?>
    860. 

  860.                 <a target="_blank" href="/p078_dealerd1/p077_DealLog1/PD_Main/Deal_Situation_Overview.php?month=<?php echo $_REQUEST['period']; ?>&category=@All&reference_no=@Stock&person=@All&fin_manager=@All&show_for=@All&department=@All"><?php echo number_format($total, 0); ?></a>
    861. 

  861.             <?php else: ?>
    862. 

  862.                 &nbsp;
    863. 

  863.             <?php endif ?>
    864. 

  864.         </td>
    865. 

  865. 

  866.         <?php echo $html; ?>
    867. 

  867.     </tr>
    868. 

  868. 

  869.     <tr><td colspan="<?php echo count($departments) + 2; ?>">&nbsp;</td></tr>
    870. 

  870.     <tr><td colspan="<?php echo count($departments) + 2; ?>">&nbsp;</td></tr>
    871. 

  871.     <tr><td colspan="<?php echo count($departments) + 2; ?>">&nbsp;</td></tr>
    872. 

  872. 

  873.     <?php $name = 'Recon Cars'; $total = 0 ?>
    874. 

  874.     <tr>
    875. 

  875.         <td><?php echo $name; ?></td>
    876. 

  876.     <?php ob_start() ?>
    877. 

  877.     <?php foreach ($departments as $department): ?>
    878. 

  878.         <td class="align-center">
    879. 

  879.         <?php if (isset($data[$name][$department->Short_Desc])): ?>
    880. 

  880.             <?php if ($data[$name][$department->Short_Desc] > 0): ?>
    881. 

  881.                 <a target="_blank" href="/p078_dealerd1/p1xx/p133_Recon/p133_Recon_Overview.php?view=@All&service_department=@All&stock_car=N&sale_department=<?php echo $department->DMS_DPT_Code; ?>"><?php echo number_format($data[$name][$department->Short_Desc], 0); ?></a>
    882. 

  882.             <?php else: ?>
    883. 

  883.                 &nbsp;
    884. 

  884.             <?php endif ?>
    885. 

  885.             <?php $total += $data[$name][$department->Short_Desc]; ?>
    886. 

  886.         <?php else: ?>
    887. 

  887.             &nbsp;
    888. 

  888.         <?php endif ?>
    889. 

  889.         </td>
    890. 

  890.     <?php endforeach ?>
    891. 

  891.     <?php $html = ob_get_clean() ?>
    892. 

  892. 

  893.         <td class="align-center bold">
    894. 

  894.             <?php if ($total > 0): ?>
    895. 

  895.                 <a target="_blank" href="/p078_dealerd1/p1xx/p133_Recon/p133_Recon_Overview.php?view=@All&service_department=@All&stock_car=N&sale_department=@All"><?php echo number_format($total, 0); ?></a>
    896. 

  896.             <?php else: ?>
    897. 

  897.                 &nbsp;
    898. 

  898.             <?php endif ?>
    899. 

  899.         </td>
    900. 

  900. 

  901.         <?php echo $html; ?>
    902. 

  902.     </tr>
    903. 

  903. 

  904.     <?php $name = 'Avg Sales Days'; $totals = array('Days' => 0, 'Count' => 0) ?>
    905. 

  905.     <tr>
    906. 

  906.         <td><?php echo $name; ?></td>
    907. 

  907.     <?php ob_start() ?>
    908. 

  908.     <?php foreach ($departments as $department): ?>
    909. 

  909.         <td class="align-center">
    910. 

  910.         <?php if (isset($data[$name][$department->Short_Desc])): ?>
    911. 

  911.             <?php if ($data[$name][$department->Short_Desc]['Days'] > 0): ?>
    912. 

  912.                 <a target="_blank" href="/p078_dealerd1/p1xx/p133_Recon/p133_Recon_Trend_days.php?service_department=&show=@All&stock_car=N&sale_department=<?php echo $department->DMS_DPT_Code; ?>"><?php echo number_format($data[$name][$department->Short_Desc]['Days'] / $data[$name][$department->Short_Desc]['Count'], 1); ?></a>
    913. 

  913.             <?php else: ?>
    914. 

  914.                 &nbsp;
    915. 

  915.             <?php endif; ?>
    916. 

  916.             <?php $totals['Days'] += $data[$name][$department->Short_Desc]['Days']; $totals['Count'] += $data[$name][$department->Short_Desc]['Count'] ?>
    917. 

  917.         <?php else: ?>
    918. 

  918.             &nbsp;
    919. 

  919.         <?php endif ?>
    920. 

  920.         </td>
    921. 

  921.     <?php endforeach ?>
    922. 

  922.     <?php $html = ob_get_clean() ?>
    923. 

  923. 

  924.         <td class="align-center bold">
    925. 

  925.             <?php if ($totals['Days'] > 0): ?>
    926. 

  926.                 <a target="_blank" href="/p078_dealerd1/p1xx/p133_Recon/p133_Recon_Trend_days.php?service_department=&show=@All&stock_car=N&sale_department=@All"><?php echo number_format($totals['Days'] / $totals['Count'], 1); ?></a>
    927. 

  927.             <?php else: ?>
    928. 

  928.                 &nbsp;
    929. 

  929.             <?php endif ?>
    930. 

  930.         </td>
    931. 

  931. 

  932.         <?php echo $html; ?>
    933. 

  933.     </tr>
    934. 

  934. 

  935.     <?php $name = 'Recon Current'; $total = 0 ?>
    936. 

  936.     <tr>
    937. 

  937.         <td><?php echo $name; ?></td>
    938. 

  938.     <?php ob_start() ?>
    939. 

  939.     <?php foreach ($departments as $department): ?>
    940. 

  940.         <td class="align-center">
    941. 

  941.         <?php if (isset($data[$name][$department->Short_Desc])): ?>
    942. 

  942.             <?php if ($data[$name][$department->Short_Desc] > 0): ?>
    943. 

  943.                 <a target="_blank" href="/p078_dealerd1/p1xx/p133_Recon/p133_Recon_Log.php?view=@All&recon_completed=<?php echo $_REQUEST['period']; ?>&recon_status=6&recon_sort=status&sale_department=<?php echo $department->DMS_DPT_Code; ?>&service_department=@All&stock_car=N"><?php echo number_format($data[$name][$department->Short_Desc], 0); ?></a>
    944. 

  944.             <?php else: ?>
    945. 

  945.                 &nbsp;
    946. 

  946.             <?php endif ?>
    947. 

  947.             <?php $total += $data[$name][$department->Short_Desc] ?>
    948. 

  948.         <?php else: ?>
    949. 

  949.             &nbsp;
    950. 

  950.         <?php endif ?>
    951. 

  951.         </td>
    952. 

  952.     <?php endforeach ?>
    953. 

  953.     <?php $html = ob_get_clean() ?>
    954. 

  954. 

  955.         <td class="align-center bold">
    956. 

  956.             <?php if ($total > 0): ?>
    957. 

  957.                 <a target="_blank" href="/p078_dealerd1/p1xx/p133_Recon/p133_Recon_Log.php?view=@All&recon_completed=<?php echo $_REQUEST['period']; ?>&recon_status=6&recon_sort=status&sale_department=@All&service_department=@All&stock_car=N"><?php echo number_format($total, 0); ?></a>
    958. 

  958.             <?php else: ?>
    959. 

  959.                 &nbsp;
    960. 

  960.             <?php endif ?>
    961. 

  961.         </td>
    962. 

  962. 

  963.         <?php echo $html; ?>
    964. 

  964.     </tr>
    965. 

  965. 

  966.     <?php $name = 'Stock Cars'; $total = 0 ?>
    967. 

  967.     <tr>
    968. 

  968.         <td><?php echo $name; ?></td>
    969. 

  969.     <?php ob_start() ?>
    970. 

  970.     <?php foreach ($departments as $department): ?>
    971. 

  971.         <td class="align-center">
    972. 

  972.         <?php if (isset($data[$name][$department->Short_Desc])): ?>
    973. 

  973.             <?php if ($data[$name][$department->Short_Desc] > 0): ?>
    974. 

  974.                 <a target="_blank" href="/p078_dealerd1/p1xx/p133_Recon/p133_Recon_Overview.php?view=@All&service_department=@All&stock_car=Y&sale_department=<?php echo $department->DMS_DPT_Code; ?>"><?php echo number_format($data[$name][$department->Short_Desc], 0); ?></a>
    975. 

  975.             <?php else: ?>
    976. 

  976.                 &nbsp;
    977. 

  977.             <?php endif ?>
    978. 

  978.             <?php $total += $data[$name][$department->Short_Desc]; ?>
    979. 

  979.         <?php else: ?>
    980. 

  980.             &nbsp;
    981. 

  981.         <?php endif ?>
    982. 

  982.         </td>
    983. 

  983.     <?php endforeach ?>
    984. 

  984.         <?php $html = ob_get_clean() ?>
    985. 

  985. 

  986.         <td class="align-center bold">
    987. 

  987.             <?php if ($total > 0): ?>
    988. 

  988.                 <a target="_blank" href="/p078_dealerd1/p1xx/p133_Recon/p133_Recon_Overview.php?view=@All&service_department=@All&stock_car=Y&sale_department=@All"><?php echo number_format($total, 0); ?></a>
    989. 

  989.             <?php else: ?>
    990. 

  990.                 &nbsp;
    991. 

  991.             <?php endif ?>
    992. 

  992.         </td>
    993. 

  993. 

  994.         <?php echo $html; ?>
    995. 

  995.     </tr>
    996. 

  996. 

  997.     <tr><td colspan="<?php echo count($departments) + 2; ?>">&nbsp;</td></tr>
    998. 

  998. 

  999.     <?php $name = 'Wholesale < 10 Days'; $total = 0 ?>
    1000. 

  1000.     <tr>
    1001. 

  1001.         <td><?php echo $name; ?></td>
    1002. 

  1002.     <?php ob_start() ?>
    1003. 

  1003.     <?php foreach ($departments as $department): ?>
    1004. 

  1004.         <td class="align-center">
    1005. 

  1005.         <?php if (isset($data[$name][$department->Short_Desc])): ?>
    1006. 

  1006.             <?php if ($data[$name][$department->Short_Desc] > 0): ?>
    1007. 

  1007.                 <a target="_blank" href="/p078_dealerd1/p077_DealLog1/SC_Main/SC_Status_Reporting.php?srt=1&department=<?php echo $department->DMS_DPT_Code; ?>&frn=@All&range=@All&colour=@All&sort=1&location=@All&age=@All"><?php echo number_format($data[$name][$department->Short_Desc], 0); ?></a>
    1008. 

  1008.             <?php else: ?>
    1009. 

  1009.                 &nbsp;
    1010. 

  1010.             <?php endif ?>
    1011. 

  1011.             <?php $total += $data[$name][$department->Short_Desc] ?>
    1012. 

  1012.         <?php else: ?>
    1013. 

  1013.             &nbsp;
    1014. 

  1014.         <?php endif ?>
    1015. 

  1015.         </td>
    1016. 

  1016.     <?php endforeach ?>
    1017. 

  1017.     <?php $html = ob_get_clean() ?>
    1018. 

  1018. 

  1019.         <td class="align-center bold">
    1020. 

  1020.             <?php if ($total > 0): ?>
    1021. 

  1021.                 <a target="_blank" href="/p078_dealerd1/p077_DealLog1/SC_Main/SC_Status_Reporting.php?srt=1&department=@All&frn=@All&range=@All&colour=@All&sort=1&location=@All&age=@All"><?php echo number_format($total, 0); ?></a>
    1022. 

  1022.             <?php else: ?>
    1023. 

  1023.                 &nbsp;
    1024. 

  1024.             <?php endif ?>
    1025. 

  1025.         </td>
    1026. 

  1026. 

  1027.         <?php echo $html; ?>
    1028. 

  1028.     </tr>
    1029. 

  1029. 

  1030.     <?php $name = 'Wholesale 11 - 20 Days'; $total = 0 ?>
    1031. 

  1031.     <tr>
    1032. 

  1032.         <td><?php echo $name; ?></td>
    1033. 

  1033.     <?php ob_start() ?>
    1034. 

  1034.     <?php foreach ($departments as $department): ?>
    1035. 

  1035.         <td class="align-center">
    1036. 

  1036.         <?php if (isset($data[$name][$department->Short_Desc])): ?>
    1037. 

  1037.             <?php if ($data[$name][$department->Short_Desc] > 0): ?>
    1038. 

  1038.                 <a target="_blank" href="/p078_dealerd1/p077_DealLog1/SC_Main/SC_Status_Reporting.php?srt=1&department=<?php echo $department->DMS_DPT_Code; ?>&frn=@All&range=@All&colour=@All&sort=1&location=@All&age=@All"><?php echo number_format($data[$name][$department->Short_Desc], 0); ?></a>
    1039. 

  1039.             <?php else: ?>
    1040. 

  1040.                 &nbsp;
    1041. 

  1041.             <?php endif ?>
    1042. 

  1042.             <?php $total += $data[$name][$department->Short_Desc] ?>
    1043. 

  1043.         <?php else: ?>
    1044. 

  1044.             &nbsp;
    1045. 

  1045.         <?php endif ?>
    1046. 

  1046.         </td>
    1047. 

  1047.     <?php endforeach ?>
    1048. 

  1048.     <?php $html = ob_get_clean() ?>
    1049. 

  1049. 

  1050.         <td class="align-center bold">
    1051. 

  1051.             <?php if ($total > 0): ?>
    1052. 

  1052.                 <a target="_blank" href="/p078_dealerd1/p077_DealLog1/SC_Main/SC_Status_Reporting.php?srt=1&department=@All&frn=@All&range=@All&colour=@All&sort=1&location=@All&age=@All"><?php echo number_format($total, 0); ?></a>
    1053. 

  1053.             <?php else: ?>
    1054. 

  1054.                 &nbsp;
    1055. 

  1055.             <?php endif ?>
    1056. 

  1056.         </td>
    1057. 

  1057. 

  1058.         <?php echo $html; ?>
    1059. 

  1059.     </tr>
    1060. 

  1060. 

  1061.     <?php $name = 'Wholesale > 20 Days'; $total = 0 ?>
    1062. 

  1062.     <tr>
    1063. 

  1063.         <td><?php echo $name; ?></td>
    1064. 

  1064.     <?php ob_start() ?>
    1065. 

  1065.     <?php foreach ($departments as $department): ?>
    1066. 

  1066.         <td class="align-center">
    1067. 

  1067.         <?php if (isset($data[$name][$department->Short_Desc])): ?>
    1068. 

  1068.             <?php if ($data[$name][$department->Short_Desc] > 0): ?>
    1069. 

  1069.                 <a target="_blank" href="/p078_dealerd1/p077_DealLog1/SC_Main/SC_Status_Reporting.php?srt=1&department=<?php echo $department->DMS_DPT_Code; ?>&frn=@All&range=@All&colour=@All&sort=1&location=@All&age=@All"><?php echo number_format($data[$name][$department->Short_Desc], 0); ?></a>
    1070. 

  1070.             <?php else: ?>
    1071. 

  1071.                 &nbsp;
    1072. 

  1072.             <?php endif ?>
    1073. 

  1073.             <?php $total += $data[$name][$department->Short_Desc] ?>
    1074. 

  1074.         <?php else: ?>
    1075. 

  1075.             &nbsp;
    1076. 

  1076.         <?php endif ?>
    1077. 

  1077.         </td>
    1078. 

  1078.     <?php endforeach ?>
    1079. 

  1079.     <?php $html = ob_get_clean() ?>
    1080. 

  1080. 

  1081.         <td class="align-center bold">
    1082. 

  1082.             <?php if ($total > 0): ?>
    1083. 

  1083.                 <a target="_blank" href="/p078_dealerd1/p077_DealLog1/SC_Main/SC_Status_Reporting.php?srt=1&department=<?php echo $department->DMS_DPT_Code; ?>&frn=@All&range=@All&colour=@All&sort=1&location=@All&age=@All"><?php echo number_format($total, 0); ?></a>
    1084. 

  1084.             <?php else: ?>
    1085. 

  1085.                 &nbsp;
    1086. 

  1086.             <?php endif ?>
    1087. 

  1087.         </td>
    1088. 

  1088. 

  1089.         <?php echo $html; ?>
    1090. 

  1090.     </tr>
    1091. 

  1091. 

  1092.     <?php $name = 'Deliveries Today'; $totals = array('Today' => 0, 'Yesterday' => 0, 'DayBefore' => 0) ?>
    1093. 

  1093.     <tr>
    1094. 

  1094.         <td><?php echo $name; ?></td>
    1095. 

  1095.     <?php ob_start() ?>
    1096. 

  1096.     <?php foreach ($departments as $department): ?>
    1097. 

  1097.         <td class="align-center">
    1098. 

  1098.         <?php if (isset($data[$name][$department->Short_Desc])): ?>
    1099. 

  1099.          …
    1100.

Large files files are truncated, but you can click here to view the full file