PageRenderTime 50ms CodeModel.GetById 16ms RepoModel.GetById 0ms app.codeStats 0ms

/equilibrium.php

https://github.com/obenauer/equilibrium
PHP | 1845 lines | 1626 code | 103 blank | 116 comment | 246 complexity | 51067564049f7c319f68ead5793eb38f MD5 | raw file
Possible License(s): GPL-2.0, LGPL-2.0 
    

  1. <?php
    2. 

  2. // Copyright 2008, St. Jude Children's Research Hospital.
    3. 

  3. // Written by Dr. John Obenauer, john.obenauer@stjude.org.
    4. 

  4. 

  5. // This file is part of Equilibrium.  Equilibrium is free software:
    6. 

  6. // you can redistribute it and/or modify it under the terms of the
    7. 

  7. // GNU General Public License as published by the Free Software
    8. 

  8. // Foundation, either version 2 of the License, or (at your option)
    9. 

  9. // any later version.
    10. 

  10. 

  11. // Equilibrium is distributed in the hope that it will be useful,
    12. 

  12. // but WITHOUT ANY WARRANTY; without even the implied warranty of
    13. 

  13. // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    14. 

  14. // GNU General Public License for more details.
    15. 

  15. 

  16. // You should have received a copy of the GNU General Public License
    17. 

  17. // along with Equilibrium.  If not, see <http://www.gnu.org/licenses/>.
    18. 

  18. 

  19. function build_todolist($staff, $status, $todostatus, $priority, $calmode,
    20. 

  20.     $project, $duty, $pageflag, $dragonly, $page, $maxresults) {
    21. 

  21. 

  22.     global $displayed_user;
    23. 

  23.     //global $page;
    24. 

  24.     //global $maxresults;
    25. 

  25.     global $heading_color;
    26. 

  26.     global $background_color;
    27. 

  27.     
    28. 

  28.     // Only allow authorized people to sort or mark off to-do items
    29. 

  29.     if (($_SESSION['SESSION_ADMIN'] == "Y") 
    30. 

  30.         || ($staff == $_SESSION['SESSION_USERID'])) {
    31. 

  31.         $edit_priv = "Y";
    32. 

  32.     } else {
    33. 

  33.         $edit_priv = "N";
    34. 

  34.     }
    35. 

  35.     
    36. 

  36.     if ($staff == 0) {
    37. 

  37.         $staffclause = "";
    38. 

  38.     } else {
    39. 

  39.         $staffclause = "and t.staff_assigned = \"$staff\" ";
    40. 

  40.     }
    41. 

  41. 

  42.     if ($priority == "All") {
    43. 

  43.         $priorityclause = "";
    44. 

  44.     } else {
    45. 

  45.         $priorityclause = "and t.priority = \"$priority\" ";
    46. 

  46.     }
    47. 

  47. 

  48.     if (($project == 0) && ($duty == 0)) {
    49. 

  49.     
    50. 

  50.         // Query conditions for To Do page
    51. 

  51.         if ($status == "All") {
    52. 

  52.             $statusclause = "";
    53. 

  53.         } else if ($status == "Open") {
    54. 

  54.             $statusclause = "and ((p.status in ('Pending', 'Active', 'Suspended') " .
    55. 

  55.                 "or t.project_id = 0) " .
    56. 

  56.                 "and (d.status = \"Active\"  or t.duty_id = 0)) ";
    57. 

  57.         } else {
    58. 

  58.             $statusclause = "and ((p.status = \"$status\" " .
    59. 

  59.                 "or t.project_id = 0) " .
    60. 

  60.                 "and (d.status = \"Active\"  or t.duty_id = 0)) ";
    61. 

  61.         }
    62. 

  62.         
    63. 

  63.         if ($todostatus == "Pending") {
    64. 

  64.             if ($calmode) {
    65. 

  65.                 $orderclause = "order by u.last_name, u.first_name, " .
    66. 

  66.                     "schedulenull asc, t.schedule_date, t.order_number asc ";
    67. 

  67.             } else {
    68. 

  68.                 $orderclause = "order by u.last_name, u.first_name, " .
    69. 

  69.                     "t.order_number asc ";
    70. 

  70.             }
    71. 

  71.         } else {
    72. 

  72.             $orderclause = "order by u.last_name, u.first_name, t.completed_date desc, " .
    73. 

  73.                 "t.completed_time desc ";
    74. 

  74.         }
    75. 

  75.     
    76. 

  76.     } else if ($project == 0) {
    77. 

  77.     
    78. 

  78.         // Query conditions for Duties page
    79. 

  79.         $statusclause = "and t.duty_id = \"$duty\" ";
    80. 

  80. 

  81.         $staffclause = "";        
    82. 

  82.     
    83. 

  83.         if ($todostatus == "Pending") {
    84. 

  84.             $orderclause = "order by t.priority, t.duty_order asc ";
    85. 

  85.         } else {
    86. 

  86.             $orderclause = "order by t.completed_date desc, t.completed_time desc ";
    87. 

  87.         }
    88. 

  88.     } else {
    89. 

  89.     
    90. 

  90.         // Query conditions for Projects page
    91. 

  91.         $statusclause = "and t.project_id = \"$project\" ";
    92. 

  92.         
    93. 

  93.         $staffclause = "";        
    94. 

  94.                 
    95. 

  95.         if ($todostatus == "Pending") {
    96. 

  96.             $orderclause = "order by t.priority, t.project_order asc ";
    97. 

  97.         } else {
    98. 

  98.             $orderclause = "order by t.completed_date desc, t.completed_time desc ";
    99. 

  99.         }
    100. 

  100.     }
    101. 

  101.     
    102. 

  102.     if ($todostatus == "Completed") {
    103. 

  103.         $todoflag = "Y";
    104. 

  104.         $dateheading = "Completed";
    105. 

  105.         $checkimage = "checkmark.png";
    106. 

  106.         $checkother = "checkbox.png";
    107. 

  107.         $marktext = "Undo Completion";
    108. 

  108.     } else {
    109. 

  109.         $todoflag = "N";
    110. 

  110.         $dateheading = "Schedule";
    111. 

  111.         $checkimage = "checkbox.png";
    112. 

  112.         $checkother = "checkmark.png";
    113. 

  113.         $marktext = "Mark Completed";
    114. 

  114.     }
    115. 

  115. 

  116.     // Get staff list for reassigning
    117. 

  117.     $conn = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
    118. 

  118.     $query = "select user_id, first_name, last_name " .
    119. 

  119.         "from users where staff_flag = \"Y\" " .
    120. 

  120.         "order by last_name asc, first_name asc ";
    121. 

  121.     $get_staff = $conn->query($query);
    122. 

  122.     $stafflist = array();
    123. 

  123.     $staffnames = array();
    124. 

  124.     $nstaff = 0;
    125. 

  125.     while ($row = $get_staff->fetch_array(MYSQLI_ASSOC)) {
    126. 

  126.         $stafflist[$nstaff] = $row['user_id'];
    127. 

  127.         $staffnames[$nstaff] = $row['first_name'] . " " . $row['last_name'];
    128. 

  128.         $nstaff++;
    129. 

  129.     }
    130. 

  130.     $get_staff->free_result();
    131. 

  131.     $conn->close();
    132. 

  132.     
    133. 

  133.     // Create JavaScript array of staff names
    134. 

  134.     printf("<script language='JavaScript'>\n");
    135. 

  135.     printf("var stafflist = new Array(%d);\n", $nstaff);
    136. 

  136.     printf("var staffnames = new Array(%d);\n", $nstaff);
    137. 

  137.     for ($i = 0; $i < $nstaff; $i++) {
    138. 

  138.         printf("stafflist[$i] = '$stafflist[$i]';\n");
    139. 

  139.         printf("staffnames[$i] = '$staffnames[$i]';\n");
    140. 

  140.     }
    141. 

  141.     printf("</script>\n");
    142. 

  142.     
    143. 

  143.     // Get open projects for this staff member
    144. 

  144.     $conn = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
    145. 

  145.     $query = "select t.project_id, t.title from projects as t " .
    146. 

  146.         "where t.status in ('Pending', 'Active', 'Suspended') " .
    147. 

  147.         $staffclause .
    148. 

  148.         "order by t.date_entered desc ";
    149. 

  149.     //printf("query = $query<br>\n");
    150. 

  150.     $get_projects = $conn->query($query);
    151. 

  151.     $project_ids = array();
    152. 

  152.     $projects = array();
    153. 

  153.     $nprojects = 0;
    154. 

  154.     while ($row = $get_projects->fetch_array(MYSQLI_ASSOC)) {
    155. 

  155.         if (strlen($row['title']) > 40) {
    156. 

  156.             $project_title = substr($row['title'], 0, 37) . "...";
    157. 

  157.         } else {
    158. 

  158.             $project_title = $row['title'];
    159. 

  159.         }
    160. 

  160.         $project_ids[$nprojects] = $row['project_id'];
    161. 

  161.         $projects[$nprojects] = $project_title;
    162. 

  162.         $nprojects++;
    163. 

  163.     }
    164. 

  164.     $get_projects->free_result();
    165. 

  165.     $conn->close();
    166. 

  166.     
    167. 

  167.     // Get active duties for this staff member
    168. 

  168.     $conn = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
    169. 

  169.     $query = "select t.duty_id, t.title from duties as t " .
    170. 

  170.         "where t.status = 'Active' " .
    171. 

  171.         $staffclause .
    172. 

  172.         "order by t.date_entered desc ";
    173. 

  173.     $get_duties = $conn->query($query);
    174. 

  174.     $duty_ids = array();
    175. 

  175.     $duties = array();
    176. 

  176.     $nduties = 0;
    177. 

  177.     while ($row = $get_duties->fetch_array(MYSQLI_ASSOC)) {
    178. 

  178.         if (strlen($row['title']) > 40) {
    179. 

  179.             $duty_title = substr($row['title'], 0, 37) . "...";
    180. 

  180.         } else {
    181. 

  181.             $duty_title = $row['title'];
    182. 

  182.         }
    183. 

  183.         $duty_ids[$nduties] = $row['duty_id'];
    184. 

  184.         $duties[$nduties] = $duty_title;
    185. 

  185.         $nduties++;
    186. 

  186.     }
    187. 

  187.     $get_duties->free_result();
    188. 

  188.     $conn->close();
    189. 

  189.     
    190. 

  190.     // Choose dates to display in schedule options
    191. 

  191.     $weekend = 0;
    192. 

  192.     $dates = array();
    193. 

  193.     if ($weekend) {
    194. 

  194.     
    195. 

  195.         // Show all dates for next two weeks
    196. 

  196.         for ($i = 0; $i <= 14; $i++) {
    197. 

  197.             $day = mktime(0, 0, 0, date("m"), date("d") + $i, date("Y"));
    198. 

  198.             $dates[$i] = date("Y", $day) . "-" . date("m", $day) . "-" . 
    199. 

  199.                 date("d", $day);
    200. 

  200.         }
    201. 

  201.     } else {
    202. 

  202.     
    203. 

  203.         // Show only weekdays for next two weeks
    204. 

  204.         $count = 0;
    205. 

  205.         for ($i = 0; $i <= 14; $i++) {
    206. 

  206.             $day = mktime(0, 0, 0, date("m"), date("d") + $i, date("Y"));
    207. 

  207.             $dayofweek = date('l', $day);
    208. 

  208.             if (($dayofweek != "Saturday") && ($dayofweek != "Sunday")) {
    209. 

  209.                 $dates[$count] = date("Y", $day) . "-" . date("m", $day) . "-" . 
    210. 

  210.                     date("d", $day);
    211. 

  211.                 $count++;
    212. 

  212.             }
    213. 

  213.         }
    214. 

  214.     }
    215. 

  215.                 
    216. 

  216.     // Put relevant to-do's in order
    217. 

  217.     $conn = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
    218. 

  218.     //$query = "select t.todo_id, t.schedule_date is null as schedulenull " .
    219. 

  219.     //    "from todos as t left join users as u on t.staff_assigned = u.user_id " .
    220. 

  220.     //    "left join projects as p on t.project_id = p.project_id " .
    221. 

  221.     //    "left join duties as d on t.duty_id = d.duty_id " .
    222. 

  222.     //    "where t.completed = \"$todoflag\" " .
    223. 

  223.     //    $staffclause .
    224. 

  224.     //    $statusclause .
    225. 

  225.     //    $priorityclause .
    226. 

  226.     //    $orderclause;
    227. 

  227.     //$todo_order = $conn->query($query);
    228. 

  228.     //$count = 1;
    229. 

  229.     //if ($project) {
    230. 

  230.     //    $order_var = "project_order";
    231. 

  231.     //} else if ($duty) {
    232. 

  232.     //    $order_var = "duty_order";
    233. 

  233.     //} else {
    234. 

  234.     //    $order_var = "order_number";
    235. 

  235.     //}
    236. 

  236.     //while ($row = $todo_order->fetch_array(MYSQLI_ASSOC)) {
    237. 

  237.     //    $set_order = $conn->query("update todos set $order_var = \"$count\" " .
    238. 

  238.     //        "where todo_id = \"" . $row['todo_id'] . "\" ");
    239. 

  239.     //    $count++;
    240. 

  240.     //}
    241. 

  241.     //$todo_order->free_result();
    242. 

  242.     
    243. 

  243.     // Define visibility clause
    244. 

  244.     if ($_SESSION['SESSION_USERID'] != $staff) {
    245. 

  245.         $visclause = "and t.visibility = 'Public' ";
    246. 

  246.     } else {
    247. 

  247.         $visclause = "";
    248. 

  248.     }
    249. 

  249.     
    250. 

  250.     // Get to-do items and display them    
    251. 

  251.     $query = "select t.todo_id, t.completed, t.schedule_date, t.completed_date, " .
    252. 

  252.         "t.priority, t.visibility, u.first_name, u.last_name, u.user_id, " .
    253. 

  253.         "u2.user_id as project_owner, u3.user_id as duty_owner, " .
    254. 

  254.         "p.project_id, p.icon_id as project_icon, p.title as project_title, " .
    255. 

  255.         "d.duty_id, d.icon_id as duty_icon, d.title as duty_title, t.description, " .
    256. 

  256.         "(t.schedule_date is null or t.schedule_date = '0000-00-00') as schedulenull " .
    257. 

  257.         "from todos as t left join users as u on t.staff_assigned = u.user_id " .
    258. 

  258.         "left join projects as p on t.project_id = p.project_id " .
    259. 

  259.         "left join users as u2 on p.staff_assigned = u2.user_id " .
    260. 

  260.         "left join duties as d on t.duty_id = d.duty_id " .
    261. 

  261.         "left join users as u3 on d.staff_assigned = u3.user_id " .
    262. 

  262.         "where t.completed = \"$todoflag\" " .
    263. 

  263.         $staffclause .
    264. 

  264.         $statusclause .
    265. 

  265.         $visclause .
    266. 

  266.         $priorityclause .
    267. 

  267.         $orderclause;
    268. 

  268.     //printf("query = $query limit " . (($page - 1) * $maxresults) . ", $maxresults <br>\n");
    269. 

  269.     $list_full = $conn->query($query);
    270. 

  270. 

  271.     if ($pageflag) {
    272. 

  272.         $list_page = $conn->query($query . "limit " . (($page - 1) * $maxresults) . 
    273. 

  273.             ", $maxresults ");
    274. 

  274.     } else {
    275. 

  275.         $list_page = $list_full;
    276. 

  276.     }
    277. 

  277. 

  278.     $list = "<div id='$todostatus" . "_todoblock'>\n";
    279. 

  279.     //printf("query = $query limit %d, %d<br>\n", (($page - 1) * $maxresults), $maxresults);
    280. 

  280.     //$list .= "query = $query<br>\n";
    281. 

  281.     //$list .= "projectclause = $projectclause<br>\n";
    282. 

  282. 

  283.     if ($list_full->num_rows) {
    284. 

  284. 

  285.         // Show "Pending" or "Completed" label for individual projects and duties
    286. 

  286.         if (($project) || ($duty)) {
    287. 

  287.             $list .= "<b>$todostatus</b><br>\n";
    288. 

  288.         }
    289. 

  289.         
    290. 

  290.         // Show page numbers for results
    291. 

  291.         if ($pageflag) {
    292. 

  292.             $page_url = "todolist.php?staff=$staff&status=$status&todostatus=$todostatus" .
    293. 

  293.                 "&priority=$priority&calmode=$calmode";
    294. 

  294.             $list .= page_results($list_full->num_rows, $page, $maxresults, $page_url);
    295. 

  295.             //$list .= "BUILD_TODOLIST PAGEFLAG=$pageflag<BR>\n";
    296. 

  296.         }
    297. 

  297.         
    298. 

  298.         // Start div for to do list
    299. 

  299.         $list .= "<div id='$todostatus" . "_todolist' class='sortable_list'>\n";
    300. 

  300. 

  301.         //$list .= "<div id='todolist' onmouseup='update_list(\"todolist\", " .
    302. 

  302.         //    "\"common.php?cmd=updatelist&staff=$staff&status=$status" .
    303. 

  303.         //    "&todostatus=$todostatus&edit_priv=$edit_priv&project=$project&duty=$duty&pageflag=$pageflag\");'>\n";
    304. 

  304. 

  305.         $lastscheduledate = "";
    306. 

  306.         while ($row = $list_page->fetch_array(MYSQLI_ASSOC)) {
    307. 

  307. 

  308.             // If schedule date is present, convert it to Unix time
    309. 

  309.             $pastscheduledate = 0;
    310. 

  310.             if (($row['schedule_date'] == "0000-00-00") ||
    311. 

  311.                 ($row['schedule_date'] == "NULL") ||
    312. 

  312.                 ($row['schedule_date'] == NULL)) {
    313. 

  313.                 $row['schedule_date'] = "";
    314. 

  314.             }
    315. 

  315.             if ($row['schedule_date']) {
    316. 

  316.                 $parts = explode("-", $row['schedule_date']);
    317. 

  317.                 $calday = mktime(0, 0, 0, $parts[1], $parts[2], $parts[0]);
    318. 

  318.                 $schedule_column = $row['schedule_date'];
    319. 

  319.                 // Check if scheduled date is before current day
    320. 

  320.                 $today = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
    321. 

  321.                 if ($calday < $today) {
    322. 

  322.                     $pastscheduledate = 1;
    323. 

  323.                 }
    324. 

  324.             } else {
    325. 

  325.                 $schedule_column = "";
    326. 

  326.             }
    327. 

  327. 

  328.             // If all staff members selected, show their initials
    329. 

  329.             if ($staff == 0) {
    330. 

  330.                 $initials = substr($row['first_name'], 0, 1) .
    331. 

  331.                     substr($row['last_name'], 0, 1) . " ";
    332. 

  332.             } else {
    333. 

  333.                 $initials = "";
    334. 

  334.             }
    335. 

  335. 

  336.             // Identify to-do owner
    337. 

  337.             if ($row['user_id']) {
    338. 

  338.                 $todo_owner = $row['user_id'];
    339. 

  339.             } else {
    340. 

  340.                 $todo_owner = 0;
    341. 

  341.             }
    342. 

  342.             
    343. 

  343.             // Identify project owner
    344. 

  344.             if ($row['project_owner']) {
    345. 

  345.                 $project_owner = $row['project_owner'];
    346. 

  346.             } else {
    347. 

  347.                 $project_owner = 0;
    348. 

  348.             }
    349. 

  349.             
    350. 

  350.             // Identify duty owner
    351. 

  351.             if ($row['duty_owner']) {
    352. 

  352.                 $duty_owner = $row['duty_owner'];
    353. 

  353.             } else {
    354. 

  354.                 $duty_owner = 0;
    355. 

  355.             }
    356. 

  356.             
    357. 

  357.             // Check whether this is a private or public to-do item
    358. 

  358.             if ($row['visibility'] == 'Private') {
    359. 

  359.                 $bgcolor = "style='background-color: $heading_color'";
    360. 

  360.                 
    361. 

  361.             } else {
    362. 

  362.                 $bgcolor = "";
    363. 

  363.             }
    364. 

  364.             
    365. 

  365.             // Draw lines between to-do's with different schedule dates
    366. 

  366.             // (in Calendar Mode)
    367. 

  367.             if ($calmode) {
    368. 

  368. 

  369.                 if (($lastscheduledate == "") && ($pastscheduledate)) {
    370. 

  370.                     $list .= "<div id='A" . $row['todo_id'] . "'>";
    371. 

  371.                     $list .= "<font color='blue' size='-1'><b>" .
    372. 

  372.                         "Overdue</b></font><br clear=left></div>\n";
    373. 

  373.                 } else if (($row['schedule_date'] != $lastscheduledate) 
    374. 

  374.                     && (!$pastscheduledate)) {
    375. 

  375.                     $list .= "<div id='A" . $row['todo_id'] . "'>";
    376. 

  376.                     if ($row['schedule_date']) {
    377. 

  377.                         $list .= "<font color='blue' size='-1'><b>" .
    378. 

  378.                             short_date($row['schedule_date']) .
    379. 

  379.                             "</b></font><br clear=left></div>\n";
    380. 

  380.                     } else {
    381. 

  381.                         $list .= "<font color='blue' size='-1'><b>" .
    382. 

  382.                             "Unscheduled</b></font><br clear=left></div>\n";
    383. 

  383.                     }
    384. 

  384.                 }
    385. 

  385.                 $lastscheduledate = $row['schedule_date'];
    386. 

  386.             }
    387. 

  387. 

  388.             $list .= "<div class='todo_item' id='" . $row['todo_id']. "' style='background-color: " . $background_color . "'>\n";
    389. 

  389.             $list .= "<table style='font-size: 14px'><tr valign='top'>\n";
    390. 

  390. 

  391.             // Mark to-do completed, or undo it
    392. 

  392.             if ($dragonly == 0) {
    393. 

  393.                 if ($edit_priv == "Y") {
    394. 

  394.                     //$list .= "<td style=\"width:30px\">\n";
    395. 

  395.                     $list .= "<td>\n";
    396. 

  396.                     $list .= "<img id='check_image_" . $row['todo_id'] . 
    397. 

  397.                         "' src=\"images/$checkimage\" title='$marktext' ";
    398. 

  398.                     if (($project) || ($duty)) {
    399. 

  399.                         $list .= "onclick='{ $(\"check_image_" . $row['todo_id'] . 
    400. 

  400.                             "\").src=\"images/$checkother\"; modify_two_lists(\"" . 
    401. 

  401.                             $row['todo_id'] . "\", \"togglecomplete\", \"$staff\", " .
    402. 

  402.                             "\"$status\", \"$priority\", \"$calmode\", " .
    403. 

  403.                             "\"$project\", \"$duty\", \"$pageflag\", " .
    404. 

  404.                             "\"$dragonly\", \"$page\", \"$maxresults\");}'>\n";
    405. 

  405.                     } else {
    406. 

  406.                         $list .= "onclick='{ $(\"check_image_" . $row['todo_id'] . 
    407. 

  407.                             "\").src=\"images/$checkother\"; modify_todo(\"" . 
    408. 

  408.                             $row['todo_id'] . "\", \"togglecomplete\", \"$staff\", " .
    409. 

  409.                             "\"$status\", \"$todostatus\", \"$priority\", \"$calmode\", " .
    410. 

  410.                             "\"$project\", \"$duty\", " .
    411. 

  411.                             "\"$pageflag\", \"$dragonly\", \"$page\", \"$maxresults\"" .
    412. 

  412.                             ");}'>\n";
    413. 

  413.                     }
    414. 

  414.                     $list .= "</td>\n";
    415. 

  415.                 } else {
    416. 

  416.                     //$list .= "<td style=\"width:30px\">\n";
    417. 

  417.                     $list .= "<td>\n";
    418. 

  418.                     $list .= "<img id='check_image_" . $row['todo_id'] . 
    419. 

  419.                         "' src=\"images/$checkimage\" ";
    420. 

  420.                     $list .= "title='$marktext'>\n";
    421. 

  421.                     $list .= "</td>\n";
    422. 

  422.     
    423. 

  423.                 }
    424. 

  424.             }
    425. 

  425.             
    426. 

  426.             // Show staff initials if "All" staff is selected
    427. 

  427.             $list .= "<td><font color='blue'>$initials</font>\n";
    428. 

  428. 

  429.             // Show project icon (if any), unless only one project is being viewed
    430. 

  430.             if (!$project) {
    431. 

  431.                 if (($row['project_id'])  && ($row['project_id'] != "NULL")) {
    432. 

  432.                     $list .= "<a href='projects.php?action=view&project=" . 
    433. 

  433.                         $row['project_id'] . "'><img src=\"icons18/icon_" . 
    434. 

  434.                         $row['project_icon'] . ".png\" title='" . 
    435. 

  435.                         $row['project_title'] . "' border='0'></a>\n";
    436. 

  436.                 }
    437. 

  437.             }
    438. 

  438.                 
    439. 

  439.             // Show duty icon (if any), unless only one duty is being viewed
    440. 

  440.             if (!$duty) {
    441. 

  441.                 if (($row['duty_id'])  && ($row['duty_id'] != "NULL")) {
    442. 

  442.                     $list .= "<a href='duties.php?action=view&duty=" . 
    443. 

  443.                         $row['duty_id'] . "'><img src=\"icons18/icon_" . 
    444. 

  444.                         $row['duty_icon'] . ".png\" title='" . 
    445. 

  445.                         $row['duty_title'] . "' border='0'></a>\n";
    446. 

  446.                 }
    447. 

  447.             }
    448. 

  448.             
    449. 

  449.             // Show to-do item description
    450. 

  450.             $list .= "<span class='draghandle' onclick='modify_todo(\"$todostatus" . 
    451. 

  451.             "_todolist\", \"updatelist\", \"$staff\", \"$status\", \"$todostatus\", " .
    452. 

  452.             "\"$priority\", \"$calmode\", \"$project\", \"$duty\", \"$pageflag\", " .
    453. 

  453.             "\"$dragonly\", \"$page\", " .
    454. 

  454.             "\"$maxresults\");' $bgcolor>" . $row['description'] . "</span>\n";
    455. 

  455. 

  456.             // Show to-do owner if different from project owner
    457. 

  457.             if ($project && $project_owner && $todo_owner) {
    458. 

  458.                 if ($project_owner != $todo_owner) {
    459. 

  459.                     $todoname = $staffnames[array_search($todo_owner, $stafflist, true)];
    460. 

  460.                 } else {
    461. 

  461.                     $todoname = "";
    462. 

  462.                 }
    463. 

  463.             }
    464. 

  464.             
    465. 

  465.             if ($duty) {
    466. 

  466.                 if ($duty_owner != $todo_owner) {
    467. 

  467.                     $todoname = $staffnames[array_search($todo_owner, $stafflist, true)];
    468. 

  468.                 } else {
    469. 

  469.                     $todoname = "";
    470. 

  470.                 }
    471. 

  471.             }
    472. 

  472.             
    473. 

  473.             if ($dragonly) {
    474. 

  474.                 
    475. 

  475.                 //$list .= "</td></tr></table></div>\n";
    476. 

  476.                 $list .= "</td></tr></table>\n";
    477. 

  477. 

  478.             } else if ($todostatus == "Completed") {
    479. 

  479.                 
    480. 

  480.                 if ($todoname) {
    481. 

  481.                     $list .= " (<b>$todoname</b>, " . short_date($row['completed_date']) . ")\n";
    482. 

  482.                 } else {
    483. 

  483.                     $list .= " (" . short_date($row['completed_date']) . ")\n";
    484. 

  484.                 }               
    485. 

  485.                 $list .= "</tr></table>\n";
    486. 

  486. 

  487.             } else {
    488. 

  488.                 
    489. 

  489.                 if ($calmode) {
    490. 

  490.                     if ($pastscheduledate) {
    491. 

  491.                         if ($todoname && $schedule_column) {
    492. 

  492.                             $list .= " (<b>$todoname</b>, " . short_date($schedule_column) . ")\n";
    493. 

  493.                         } else if ($schedule_column) {
    494. 

  494.                             $list .= " (" . short_date($schedule_column) . ")\n";
    495. 

  495.                         } else if ($todoname) {
    496. 

  496.                             $list .= " (<b>$todoname</b>)\n";
    497. 

  497.                         }
    498. 

  498.                     } else {
    499. 

  499.                         if ($todoname) {
    500. 

  500.                             $list .= " (<b>$todoname</b>)\n";
    501. 

  501.                         }
    502. 

  502.                     }
    503. 

  503.                 } else {
    504. 

  504.                     if ($todoname && $schedule_column) {
    505. 

  505.                         $list .= " (<b>$todoname</b>, " . short_date($schedule_column) . ")\n";
    506. 

  506.                     } else if ($schedule_column) {
    507. 

  507.                         $list .= " (" . short_date($schedule_column) . ")\n";
    508. 

  508.                     } else if ($todoname) {
    509. 

  509.                         $list .= " (<b>$todoname</b>)\n";
    510. 

  510.                     }
    511. 

  511.                 }
    512. 

  512. 

  513.                 // Priority icon
    514. 

  514.                 if ($row['priority'] == 'High') {
    515. 

  515.                     $list .= "&nbsp; &nbsp; <img src='images/plus.png' height='16' " .
    516. 

  516.                         "title='Priority' onclick='modify_todo(\"" . $row['todo_id'] . 
    517. 

  517.                         "\", \"togglepriority\", \"$staff\", \"$status\", " . 
    518. 

  518.                         "\"$todostatus\", \"$priority\", \"$calmode\", " .
    519. 

  519.                         "\"$project\", \"$duty\", " .
    520. 

  520.                         "\"$pageflag\", \"$dragonly\", \"$page\", " .
    521. 

  521.                         "\"$maxresults\");'>";
    522. 

  522.                 } else {
    523. 

  523.                     $list .= "&nbsp; <img src='images/minus.png' height='16' " .
    524. 

  524.                         "title='Priority' onclick='modify_todo(\"" . $row['todo_id'] . 
    525. 

  525.                         "\", \"togglepriority\", \"$staff\", \"$status\", " . 
    526. 

  526.                         "\"$todostatus\", \"$priority\", \"$calmode\", " .
    527. 

  527.                         "\"$project\", \"$duty\", " .
    528. 

  528.                         "\"$pageflag\", \"$dragonly\", \"$page\", " .
    529. 

  529.                         "\"$maxresults\");'>";
    530. 

  530.                 }
    531. 

  531. 

  532.                 // Edit icon
    533. 

  533.                 $list .= "&nbsp; <img src='images/edit.png' height='16' " .
    534. 

  534.                 "title='Edit' " .
    535. 

  535.                 "onclick='show_item(\"edit_" . $row['todo_id'] . "\");'>";
    536. 

  536. 

  537.                 // Delete icon
    538. 

  538.                 $list .= "&nbsp; <img src='images/delete.png' height='16' " .
    539. 

  539.                 "title='Delete' " .
    540. 

  540.                 "onclick='show_item(\"confirm_" . $row['todo_id'] . "\");'>";
    541. 

  541.                 $list .= "</td>";
    542. 

  542.                 $list .= "</tr></table>\n";
    543. 

  543.                 //$list .= "</div>\n";
    544. 

  544. 

  545.                 // Div for edit box
    546. 

  546.                 $list .= "<div style='display: none' id='edit_" . $row['todo_id'] . "' >" .
    547. 

  547.                 "<center>Edit: <input type='text' " .
    548. 

  548.                 " id='txtEditItem_" . 
    549. 

  549.                 $row['todo_id'] . 
    550. 

  550.                 "' size='100' maxlength='255' value=\"" . $row['description'] ."\" " .
    551. 

  551.                 ">\n<br>";
    552. 

  552.                 
    553. 

  553.                 // Project/duty selection
    554. 

  554.                 if ($row['project_id']) {
    555. 

  555.                     $pstyle = "style='font-weight: bold' ";
    556. 

  556.                     $dstyle = "style='font-weight: normal' ";
    557. 

  557.                     $selectname = "name = 'projectchange_" . $row['todo_id'] . 
    558. 

  558.                     "' ";
    559. 

  559.                 } else if ($row['duty_id']) {
    560. 

  560.                     $pstyle = "style='font-weight: normal' ";
    561. 

  561.                     $dstyle = "style='font-weight: bold' ";
    562. 

  562.                     $selectname = "name = 'dutychange_" . $row['todo_id'] . 
    563. 

  563.                     "' ";
    564. 

  564.                 } else {
    565. 

  565.                     $pstyle = "style='font-weight: bold' ";
    566. 

  566.                     $dstyle = "style='font-weight: normal' ";
    567. 

  567.                     $selectname = "name = 'projectchange_" . $row['todo_id'] . 
    568. 

  568.                     "' ";
    569. 

  569.                 }
    570. 

  570.                 $list .= "<font id='projectlabel_" . $row['todo_id'] . "' onclick='pdflag_" . $row['todo_id'] . " = \"Project\"; populate_projects( $(\"pdlist_" . $row['todo_id'] . "\"), $(\"projectlabel_" . $row['todo_id'] . "\"), $(\"dutylabel_" . $row['todo_id'] . "\"), project_ids, projects, \"" . 
    571. 

  571.                 $row['project_id'] . "\");' $pstyle>";
    572. 

  572.                 $list .= "Project</font> / ";
    573. 

  573.                 $list .= "<font id='dutylabel_" . $row['todo_id'] . "' onclick='pdflag_" . $row['todo_id'] . " = \"Duty\"; populate_duties( $(\"pdlist_" . $row['todo_id'] . "\"), $(\"projectlabel_" . $row['todo_id'] . "\"), $(\"dutylabel_" . $row['todo_id'] . "\"), duty_ids, duties, \"" . 
    574. 

  574.                 $row['duty_id'] . "\");' $dstyle>Duty</font>: \n";
    575. 

  575.                 $list .= "<select id='pdlist_" . $row['todo_id'] . "' size='1' onChange=\"if (pdflag_" . $row['todo_id'] . " == 'Project') {duty = 0; project = project_ids[$('pdlist_" . $row['todo_id'] . "').selectedIndex - 1];} else {project = 0; duty = duty_ids[$('pdlist_" . $row['todo_id'] . "').selectedIndex - 1];}\" $selectname>\n";
    576. 

  576.                 if ($row['project_id']) {
    577. 

  577.                     $list .= "<option value='P0'></option>\n";
    578. 

  578.                     for ($i = 0; $i < $nprojects; $i++) {
    579. 

  579.                         if ($row['project_id'] == $project_ids[$i]) {
    580. 

  580.                             $list .= "<option value='P" . $project_ids[$i] . 
    581. 

  581.                                 "' selected>" . $projects[$i] . "</option>\n";
    582. 

  582.                         } else {
    583. 

  583.                             $list .= "<option value='P" . $project_ids[$i] . 
    584. 

  584.                                 "'>" . $projects[$i] . "</option>\n";
    585. 

  585.                         }
    586. 

  586.                     }
    587. 

  587.                 } else if ($row['duty_id']) {
    588. 

  588.                     $list .= "<option value='D0'></option>\n";
    589. 

  589.                     for ($i = 0; $i < $nduties; $i++) {
    590. 

  590.                         if ($row['duty_id'] == $duty_ids[$i]) {
    591. 

  591.                             $list .= "<option value='D" . $duty_ids[$i] . 
    592. 

  592.                                 "' selected>" . $duties[$i] . "</option>\n";
    593. 

  593.                         } else {
    594. 

  594.                             $list .= "<option value='D" . $duty_ids[$i] . 
    595. 

  595.                                 "'>" . $duties[$i] . "</option>\n";
    596. 

  596.                         }
    597. 

  597.                     }
    598. 

  598.                 } else {
    599. 

  599.                     $list .= "<option value='P0'></option>\n";
    600. 

  600.                     for ($i = 0; $i < $nprojects; $i++) {
    601. 

  601.                         if ($row['project_id'] == $project_ids[$i]) {
    602. 

  602.                             $list .= "<option value='P" . $project_ids[$i] . 
    603. 

  603.                                 "' selected>" . $projects[$i] . "</option>\n";
    604. 

  604.                         } else {
    605. 

  605.                             $list .= "<option value='P" . $project_ids[$i] . 
    606. 

  606.                                 "'>" . $projects[$i] . "</option>\n";
    607. 

  607.                         }
    608. 

  608.                     }
    609. 

  609.                 }
    610. 

  610.                 $list .= "</select> &nbsp; \n";
    611. 

  611.                 
    612. 

  612.                 // Staff assigned selection
    613. 

  613.                 $list .= "Staff assigned: ";
    614. 

  614.                 $list .= "<select id='staff_assigned_" . $row['todo_id'] . 
    615. 

  615.                     "' name='staff_assigned_" . $row['todo_id'] . 
    616. 

  616.                     "'>\n";
    617. 

  617.                 for ($i = 0; $i < $nstaff; $i++) {
    618. 

  618.                     if ($stafflist[$i] == $todo_owner) {
    619. 

  619.                         $list .= "<option value='" . $stafflist[$i]. 
    620. 

  620.                             "' selected>" . $staffnames[$i] . "</option>\n";
    621. 

  621.                     } else {
    622. 

  622.                         $list .= "<option value='" . $stafflist[$i]. 
    623. 

  623.                             "'>" . $staffnames[$i] . "</option>\n";
    624. 

  624.                     }
    625. 

  625.                 }
    626. 

  626.                 $list .= "</select><br>\n";
    627. 

  627.                 
    628. 

  628.                 // Visibility selection
    629. 

  629.                 $list .= "Visibility: ";
    630. 

  630.                 $list .= "<select id='visibility_" . $row['todo_id'] . 
    631. 

  631.                     "' name='visibility_" . $row['todo_id'] . 
    632. 

  632.                     "'>\n";
    633. 

  633.                 if ($row['visibility'] == 'Public') {
    634. 

  634.                     $list .= "<option value='Public' selected>Public</option>\n";
    635. 

  635.                 } else {
    636. 

  636.                     $list .= "<option value='Public'>Public</option>\n";
    637. 

  637.                 }
    638. 

  638.                 if ($row['visibility'] == 'Private') {
    639. 

  639.                     $list .= "<option value='Private' selected>Private</option>\n";
    640. 

  640.                 } else {
    641. 

  641.                     $list .= "<option value='Private'>Private</option>\n";
    642. 

  642.                 }
    643. 

  643.                 $list .= "</select>\n";
    644. 

  644.                 
    645. 

  645.                 // Schedule date selection
    646. 

  646.                 $list .= "Schedule: ";
    647. 

  647.                 $list .= "<select id='schedule_" . $row['todo_id'] . 
    648. 

  648.                     "' name='schedule_" . $row['todo_id'] . 
    649. 

  649.                     "'>\n";
    650. 

  650.                 if ($pastscheduledate) {
    651. 

  651.                     $list .= "<option value='$schedule_column' selected " .
    652. 

  652.                         "style='background-color: $heading_color'>" . 
    653. 

  653.                         short_date($schedule_column) . "</option>\n";
    654. 

  654.                 }
    655. 

  655.                 if ($schedule_column == "") {
    656. 

  656.                     $list .= "<option value='NULL' selected></option>\n";
    657. 

  657.                 } else {
    658. 

  658.                     $list .= "<option value='NULL'></option>\n";
    659. 

  659.                 }
    660. 

  660.                 for ($i = 0; $i < count($dates); $i++) {
    661. 

  661.                     if ($schedule_column == $dates[$i]) {
    662. 

  662.                         $list .= "<option value='$dates[$i]' selected>" . 
    663. 

  663.                             short_date($dates[$i]) . "</option>\n";
    664. 

  664.                     } else {
    665. 

  665.                         $list .= "<option value='$dates[$i]'>" . 
    666. 

  666.                             short_date($dates[$i]) . "</option>\n";
    667. 

  667.                     }
    668. 

  668.                 }
    669. 

  669.                 $list .= "</select><br>\n";
    670. 

  670.                 
    671. 

  671.                 // Update and cancel icons
    672. 

  672.                 $list .= "<input type='button' value='Update' " .
    673. 

  673.                 "onclick='{modify_todo(\"" . $row['todo_id'] . 
    674. 

  674.                 "\", \"edititem\", \"$staff\", \"$status\", \"$todostatus\", " .
    675. 

  675.                 "\"$priority\", \"$calmode\", \"$project\", \"$duty\", \"$pageflag\", " .
    676. 

  676.                 "\"$dragonly\", \"$page\", \"$maxresults\");}'>  &nbsp; &nbsp; " .
    677. 

  677.                 "<input type='button' value='Cancel' onclick='hide_item(\"edit_" . 
    678. 

  678.                 $row['todo_id'] . "\");'></center></div>\n";
    679. 

  679. 

  680.                 // Set variable for project/duty flag
    681. 

  681.                 printf("<script type='text/javascript'>\n");
    682. 

  682.                 if ($row['project_id']) {
    683. 

  683.                     printf("var pdflag_" . $row['todo_id'] . " = \"Project\";\n");
    684. 

  684.                 } else if ($row['duty_id']) {
    685. 

  685.                     printf("var pdflag_" . $row['todo_id'] . " = \"Duty\";\n");
    686. 

  686.                 } else {
    687. 

  687.                     printf("var pdflag_" . $row['todo_id'] . " = \"Project\";\n");
    688. 

  688.                 }
    689. 

  689.                 printf("</script>\n");
    690. 

  690. 

  691.                 // Div to confirm deletion
    692. 

  692.                 $list .= "<div class='confirm' id='confirm_" . $row['todo_id'] . 
    693. 

  693.                 "' ><font color='red'>" .
    694. 

  694.                 "<center>Are you sure you want to delete this item?</font><br>" .
    695. 

  695.                 "<input type='button' value='Confirm Deletion' " .
    696. 

  696.                 "onclick='{Element.hide(\$(\"confirm_" . $row['todo_id'] . 
    697. 

  697.                 "\").id); modify_todo(\"" . $row['todo_id'] . 
    698. 

  698.                 "\", \"deleteitem\", \"$staff\", \"$status\", \"$todostatus\", " .
    699. 

  699.                 "\"$priority\", \"$calmode\", \"$project\", \"$duty\", \"$pageflag\", " .
    700. 

  700.                 "\"$dragonly\", \"$page\", \"$maxresults\");" .
    701. 

  701.                 "}'>  &nbsp; &nbsp; " .
    702. 

  702.                 "<input type='button' value='Cancel' onclick='hide_item(\"confirm_" . 
    703. 

  703.                 $row['todo_id'] . "\");'></center></div>\n";
    704. 

  704.     
    705. 

  705.                 // End the div for this to-do item (containing edit and delete divs)
    706. 

  706.                 $list .= "</div>\n";
    707. 

  707.             }
    708. 

  708. 

  709.         }
    710. 

  710. 

  711.         // End the div for all to-do items
    712. 

  712.         $list .= "</div>\n";
    713. 

  713.         
    714. 

  714.     } else {
    715. 

  715.         if ($project) {
    716. 

  716.             $list .= "<b>No " . strtolower($todostatus) . " to-do items found " .
    717. 

  717.                 "for this project.</b><br>\n";
    718. 

  718.         } else if ($duty) {
    719. 

  719.             $list .= "<b>No " . strtolower($todostatus) . " to-do items found " .
    720. 

  720.                 "for this duty.</b><br>\n";
    721. 

  721.         } else {
    722. 

  722.             if ($displayed_user == "All") {
    723. 

  723.                 if ($status == "All") {
    724. 

  724.                     $list .= "<b>No " . strtolower($todostatus) . " to-do items found " .
    725. 

  725.                         "in database.</b><br>\n";
    726. 

  726.                 } else {
    727. 

  727.                     $list .= "<b>No " . strtolower($todostatus) . " to-do items for " . 
    728. 

  728.                         strtolower($status) . " projects found in database.</b><br>\n";
    729. 

  729.                 }
    730. 

  730.             } else {
    731. 

  731.                 if ($status == "All") {
    732. 

  732.                     $list .= "<b>No " . strtolower($todostatus) . " to-do items found " .
    733. 

  733.                         "for $displayed_user.</b><br>\n";
    734. 

  734.                 } else {
    735. 

  735.                     $list .= "<b>No " . strtolower($todostatus) . " to-do items for " . 
    736. 

  736.                         strtolower($status) . " projects found for " .
    737. 

  737.                         "$displayed_user.</b><br>\n";
    738. 

  738.                 }
    739. 

  739.             }
    740. 

  740.         }
    741. 

  741.     }
    742. 

  742. 

  743.     // End the "to do block" div 
    744. 

  744.     $list .= "</div>\n";
    745. 

  745.         
    746. 

  746.     // Close the database connection
    747. 

  747.     $list_full->free_result();
    748. 

  748.     if ($pageflag) {
    749. 

  749.         $list_page->free_result();
    750. 

  750.     }
    751. 

  751.     $conn->close();
    752. 

  752. 

  753.     // Make list sortable
    754. 

  754.     if (($todostatus == "Pending") && ($_SESSION['SESSION_USERID'] == $staff)) {
    755. 

  755.         $list .= "<script type='text/javascript'>\n";
    756. 

  756.         $list .= "Sortable.create('$todostatus" . "_todolist', {tag:'div', handle:'draghandle'});\n"; 
    757. 

  757.         $list .= "</script>\n";
    758. 

  758.     }
    759. 

  759. 

  760.     return $list;
    761. 

  761. }
    762. 

  762. 

  763. function build_two_lists($staff, $status, $priority, $calmode, $project, $duty,
    764. 

  764.     $pageflag, $dragonly, $page, $maxresults) {
    765. 

  765. 

  766.     $two_lists = build_todolist($staff, $status, "Pending", $priority, $calmode,
    767. 

  767.         $project, $duty, '0', '0', $page, $maxresults);
    768. 

  768.     $two_lists .= "<br>\n";
    769. 

  769.     $two_lists .= build_todolist($staff, $status, "Completed", $priority, $calmode,
    770. 

  770.         $project, $duty, '0', '0', $page, $maxresults);
    771. 

  771. 

  772.     return $two_lists;
    773. 

  773. }
    774. 

  774. 

  775. function build_commentlist($staff, $project, $duty, $fromdate, $todate,
    776. 

  776.     $pageflag, $page, $maxresults) {
    777. 

  777. 

  778.     global $displayed_user;
    779. 

  779.     //global $page;
    780. 

  780.     //global $maxresults;
    781. 

  781.     global $heading_color;
    782. 

  782.     global $background_color;
    783. 

  783. 

  784.     // Only the assigned staff or administrators can edit this project, unless it's not assigned
    785. 

  785.     if (($_SESSION['SESSION_ADMIN'] == "Y") || ($staff == $_SESSION['SESSION_USERID'])) {
    786. 

  786.         $edit_priv = "Y";
    787. 

  787.     } else {
    788. 

  788.         $edit_priv = "N";
    789. 

  789.     }
    790. 

  790. 

  791.     if ($staff == 0) {
    792. 

  792.         $staffclause = "";
    793. 

  793.     } else {
    794. 

  794.         $staffclause = "where c.submitter_id = \"$staff\" ";
    795. 

  795.     }
    796. 

  796. 

  797.     // Define visibility clause
    798. 

  798.     if ($_SESSION['SESSION_USERID'] != $staff) {
    799. 

  799.         $visclause = "and c.visibility = 'Public' ";
    800. 

  800.     } else {
    801. 

  801.         $visclause = "";
    802. 

  802.     }
    803. 

  803.     
    804. 

  804.     // Define date clause
    805. 

  805.     if ($project) {
    806. 

  806.         $dateclause = "";
    807. 

  807.         $pdclause = "and c.project_id = \"$project\" ";
    808. 

  808.     } else if ($duty) {
    809. 

  809.         $dateclause = "";
    810. 

  810.         $pdclause = "and c.duty_id = \"$duty\" ";
    811. 

  811.     } else {
    812. 

  812.         $dateclause = "and c.submit_date >= \"$fromdate\" " .
    813. 

  813.             "and c.submit_date <= \"$todate\" ";
    814. 

  814.         $pdclause = "";
    815. 

  815.     }
    816. 

  816.     
    817. 

  817.     // Fill Javascript arrays with open projects and active duties
    818. 

  818.     fill_pdlist_arrays($staff, $projects, $project_ids, $duties, $duty_ids);
    819. 

  819.         
    820. 

  820.     // Get to-do items for active projects and display them
    821. 

  821.     $conn = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
    822. 

  822.     $query = "select c.comment_id, c.comment_text, c.submit_date, " .
    823. 

  823.         "u.user_id, u.first_name, u.last_name, c.visibility, " .
    824. 

  824.         "p.project_id, p.icon_id as project_icon, p.title as project_title, " .
    825. 

  825.         "d.duty_id, d.icon_id as duty_icon, d.title as duty_title " .
    826. 

  826.         "from comments as c left join users as u on c.submitter_id = u.user_id " .
    827. 

  827.         "left join projects as p on c.project_id = p.project_id " .
    828. 

  828.         "left join duties as d on c.duty_id = d.duty_id " .
    829. 

  829.         $staffclause . $visclause . $dateclause . $pdclause . 
    830. 

  830.         "order by c.submit_time desc ";
    831. 

  831.         //printf("query = $query<br>\n");
    832. 

  832.     $list_full = $conn->query($query);
    833. 

  833.     if ($pageflag) {
    834. 

  834.         $list_page = $conn->query($query . "limit " . (($page - 1) * $maxresults) . 
    835. 

  835.             ", $maxresults ");
    836. 

  836.     } else {
    837. 

  837.         $list_page = $list_full;
    838. 

  838.     }
    839. 

  839. 

  840.     $list = "<div id='commentblock'>\n";
    841. 

  841.     //$list .= "fromdate = $fromdate, todate = $todate<br>\n";
    842. 

  842.     
    843. 

  843.     if ($list_page->num_rows) {
    844. 

  844. 

  845.         // Show page numbers for results
    846. 

  846.         if ($pageflag) {
    847. 

  847.             $page_url = "logbook.php?staff=$staff&fromdate=$fromdate&todate=$todate";
    848. 

  848.             $list .= page_results($list_full->num_rows, $page, $maxresults, $page_url);
    849. 

  849.         }
    850. 

  850.         
    851. 

  851.         while ($row = $list_page->fetch_array(MYSQLI_ASSOC)) {
    852. 

  852.     
    853. 

  853.             // If all staff members selected, show their initials
    854. 

  854.             if ($staff == 0) {
    855. 

  855.                 $initials = substr($row['first_name'], 0, 1) .
    856. 

  856.                     substr($row['last_name'], 0, 1) . " ";
    857. 

  857.             } else {
    858. 

  858.                 $initials = "";
    859. 

  859.             }
    860. 

  860. 

  861.             $list .= "<div id='comment_" . $row['comment_id'] . "'>";
    862. 

  862. 

  863.             // Check whether this is a private or public to-do item
    864. 

  864.             if ($row['visibility'] == 'Private') {
    865. 

  865.                 $bgcolor = "$heading_color";
    866. 

  866.                 
    867. 

  867.             } else {
    868. 

  868.                 $bgcolor = "white";
    869. 

  869.             }
    870. 

  870.         
    871. 

  871.             // Date submitted
    872. 

  872.             $list .= "<table><tr valign='top'><td>" . short_date($row['submit_date']) . "</td>\n";
    873. 

  873.             $list .= "<td bgcolor='$bgcolor' style='{border: 1px solid $heading_color; padding-left: 5px; padding-right: 5px;}'><font color='blue'>$initials</font>";
    874. 

  874.             
    875. 

  875.             // Show project icon (if any), unless only one project is being viewed
    876. 

  876.             if (!$project) {
    877. 

  877.                 if (($row['project_id'])  && ($row['project_id'] != "NULL")) {
    878. 

  878.                     $list .= "<a href='projects.php?action=view&project=" . 
    879. 

  879.                         $row['project_id'] . "'><img src=\"icons18/icon_" . 
    880. 

  880.                         $row['project_icon'] . ".png\" title='" . 
    881. 

  881.                         $row['project_title'] . "' border='0'></a>\n";
    882. 

  882.                 }
    883. 

  883.             }
    884. 

  884.                 
    885. 

  885.             // Show duty icon (if any), unless only one duty is being viewed
    886. 

  886.             if (!$duty) {
    887. 

  887.                 if (($row['duty_id'])  && ($row['duty_id'] != "NULL")) {
    888. 

  888.                     $list .= "<a href='duties.php?action=view&duty=" . 
    889. 

  889.                         $row['duty_id'] . "'><img src=\"icons18/icon_" . 
    890. 

  890.                         $row['duty_icon'] . ".png\" title='" . 
    891. 

  891.                         $row['duty_title'] . "' border='0'></a>\n";
    892. 

  892.                 }
    893. 

  893.             }
    894. 

  894.             
    895. 

  895.             // Comment text
    896. 

  896.             $comment_text = str_replace("\'", "'", $row['comment_text']);
    897. 

  897.             $comment_text = str_replace('\"', '"', $comment_text);
    898. 

  898.             $comment_text = str_replace("%", "%%", $comment_text);
    899. 

  899.             $list .= $comment_text . "</td>\n";
    900. 

  900.     
    901. 

  901.             // Don't show edit or delete icons if user does not have edit_priv
    902. 

  902.             if ($edit_priv == "Y") {
    903. 

  903.     
    904. 

  904.                 // "Edit" icon
    905. 

  905.                 $list .= "<td><img src='images/edit.png' height='16' style='{position:relative; padding-left:20px;}' " .
    906. 

  906.                     "onclick='show_item(\"editcomment_" . $row['comment_id'] . "\");'></td>";
    907. 

  907.         
    908. 

  908.                 // "Delete" icon
    909. 

  909.                 $list .= "<td style='background-color:" . $background_color . "'><img src='images/delete.png' height='16' onclick='show_item(\"confirmcomment_" . $row['comment_id'] . "\");'>" .
    910. 

  910.                 "</td></tr></table>\n";
    911. 

  911.         
    912. 

  912.                 // Div for edit box
    913. 

  913.                 $list .= "<div style='display: none' id='editcomment_" . 
    914. 

  914.                     $row['comment_id'] . "'><center>Edit: <textarea id='txtEditEntry_" . 
    915. 

  915.                     $row['comment_id'] . 
    916. 

  916.                     "' rows='4' cols='120' class='description'>" .$comment_text . 
    917. 

  917.                     "</textarea>\n<br>";
    918. 

  918.                 
    919. 

  919.                 // Project/duty selection
    920. 

  920.                 $list .= make_pdlist($staff, $row['comment_id'], $row['project_id'], 
    921. 

  921.                     $projects, $project_ids, $row['duty_id'], $duties, $duty_ids, 0);
    922. 

  922.                 
    923. 

  923.                 // Visibility selection
    924. 

  924.                 $list .= "Visibility: ";
    925. 

  925.                 $list .= "<select id='viscomment_" . $row['comment_id'] . 
    926. 

  926.                     "' name='viscomment_" . $row['comment_id'] . 
    927. 

  927.                     "'>\n";
    928. 

  928.                 if ($row['visibility'] == 'Public') {
    929. 

  929.                     $list .= "<option value='Public' selected>Public</option>\n";
    930. 

  930.                 } else {
    931. 

  931.                     $list .= "<option value='Public'>Public</option>\n";
    932. 

  932.                 }
    933. 

  933.                 if ($row['visibility'] == 'Private') {
    934. 

  934.                     $list .= "<option value='Private' selected>Private</option>\n";
    935. 

  935.                 } else {
    936. 

  936.                     $list .= "<option value='Private'>Private</option>\n";
    937. 

  937.                 }
    938. 

  938.                 $list .= "</select><br>\n";
    939. 

  939.                 
    940. 

  940.                 // Update and cancel icons
    941. 

  941.                 $list .= "<input type='button' value='Update' " .
    942. 

  942.                 "onclick='{modify_comment(\"" . $row['comment_id'] . 
    943. 

  943.                 "\", \"editcomment\", \"$staff\", \"$project\", \"$duty\", " .
    944. 

  944.                 "\"$fromdate\", \"$todate\", \"$pageflag\", \"$page\", \"$maxresults\");}'>  &nbsp; &nbsp; " .
    945. 

  945.                 "<input type='button' value='Cancel' onclick='hide_item(\"editcomment_" . 
    946. 

  946.                 $row['comment_id'] . "\");'></center><br></div>\n";
    947. 

  947. 

  948.                 // Set variable for project/duty flag
    949. 

  949.                 printf("<script type='text/javascript'>\n");
    950. 

  950.                 if ($row['project_id']) {
    951. 

  951.                     printf("var pdflag_" . $row['comment_id'] . " = \"Project\";\n");
    952. 

  952.                 } else if ($row['duty_id']) {
    953. 

  953.                     printf("var pdflag_" . $row['comment_id'] . " = \"Duty\";\n");
    954. 

  954.                 } else {
    955. 

  955.                     printf("var pdflag_" . $row['comment_id'] . " = \"Project\";\n");
    956. 

  956.                 }
    957. 

  957.                 printf("</script>\n");
    958. 

  958. 

  959.                 // Div to confirm deletion
    960. 

  960.                 $list .= "<div class='confirm' id='confirmcomment_" . $row['comment_id'] . 
    961. 

  961.                 "' ><font color='red'>" .
    962. 

  962.                 "<center>Are you sure you want to delete this comment?</font><br>" .
    963. 

  963.                 "<input type='button' value='Confirm Deletion' " .
    964. 

  964.                 "onclick='{modify_comment(\"" . $row['comment_id'] . 
    965. 

  965.                 "\", \"deletecomment\", \"$staff\", \"$project\", \"$duty\", " .
    966. 

  966.                 "\"$fromdate\", \"$todate\", \"$pageflag\", \"$page\", \"$maxresults\");" .
    967. 

  967.                 "}'>  &nbsp; &nbsp; " .
    968. 

  968.                 "<input type='button' value='Cancel' onclick='hide_item(\"confirmcomment_" . 
    969. 

  969.                 $row['comment_id'] . "\");'></center><br></div>\n";
    970. 

  970.                 
    971. 

  971.                 $list .= "</div>\n";
    972. 

  972.             
    973. 

  973.             } else {
    974. 

  974.     
    975. 

  975.                 // Don't show "Edit" icon
    976. 

  976.                 $list .= "<td></td>";
    977. 

  977.         
    978. 

  978.                 // Don't show "Delete" icon
    979. 

  979.                 $list .= "<td></td></tr></table>\n";
    980. 

  980.             
    981. 

  981.                 $list .= "</div>\n";
    982. 

  982.             }
    983. 

  983.     
    984. 

  984.         }
    985. 

  985. 

  986.         // End comment block div
    987. 

  987.         $list .= "</div>\n";
    988. 

  988.     } else {
    989. 

  989.     
    990. 

  990.         if ($project) {
    991. 

  991.             $list .= "<b>No comments entered for this project.</b><br>\n";
    992. 

  992.         } else if ($duty) {
    993. 

  993.             $list .= "<b>No comments entered for this duty.</b><br>\n";
    994. 

  994.         } else {
    995. 

  995.             if ($displayed_user == "All") {
    996. 

  996.                 $list .= "<b>No comments entered during this date range.</b><br>\n";
    997. 

  997.             } else {
    998. 

  998.                 $list .= "<b>No comments entered by $displayed_user in this date range.</b><br>\n";
    999. 

  999.             }
    1000. 

  1000.         }
    1001. 

  1001.     }
    1002. 

  1002. 

  1003.     // Close the database connection
    1004. 

  1004.     $list_full->free_result();
    1005. 

  1005.     if ($pageflag) {
    1006. 

  1006.         $list_page->free_result();
    1007. 

  1007.     }
    1008. 

  1008.     $conn->close();
    1009. 

  1009. 

  1010.     return $list;
    1011. 

  1011. }
    1012. 

  1012. 

  1013. function show_project_comments($project, $edit_priv) {
    1014. 

  1014. 

  1015.     global $background_color;
    1016. 

  1016.     global $heading_color;
    1017. 

  1017. 

  1018.     $myList = "";
    1019. 

  1019. 

  1020.     $conn = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD)
    1021. 

  1021.         or die ("Cannot connect to database. " . mysql_error() . "\n<br>");
    1022. 

  1022.     mysql_select_db(DB_DATABASE);
    1023. 

  1023.     $get_comments = mysql_query("select comment_id, comment_text, submit_date, " .
    1024. 

  1024.         "submit_time from comments where project_id = \"$project\" " .
    1025. 

  1025.         "order by submit_time desc ");
    1026. 

  1026. 

  1027.     if (mysql_num_rows($get_comments) == 0) {
    1028. 

  1028.         $myList .= "No comments entered for this project.<br>\n";
    1029. 

  1029.     }
    1030. 

  1030. 

  1031.     // Don't show edit or delete icons if user does not have edit_priv
    1032. 

  1032.     if ($edit_priv == "Y") {
    1033. 

  1033. 

  1034.         while ($row = mysql_fetch_array($get_comments, MYSQL_ASSOC))
    1035. 

  1035.         {
    1036. 

  1036. 

  1037.             $myList .= "<div id='comment_" . $row['comment_id'] . "'>";
    1038. 

  1038. 

  1039.             // Date submitted
    1040. 

  1040.             $myList .= "<table><tr valign='top'><td>" . short_date($row['submit_date
    1041. 

  1041. ']) . "</td>\n";
    1042. 

    1043. 

  1043.             // Comment text
    1044. 

  1044.             $myList .= "<td bgcolor='white' style='{border: 1px solid $heading_color
    1045. 

  1045. ; padding-left: 5px; padding-right: 5px;}'>"
    1046. 

  1046.                 . $row['comment_text'] . "</td>\n";
    1047. 

  1047. 

  1048.             // "Edit" icon
    1049. 

  1049.             $myList .= "<td><img src='images/pencil.gif' style='{position:relative;
    1050. 

  1050. padding-left:20px;}' " .
    1051. 

  1051.                 "onclick='show_editbox(\"editcomment_" . $row['comment_id'] . "\");'
    1052. 

  1052. ></td>";
    1053. 

    1054. 

  1054.             // "Delete" icon
    1055. 

  1055.             $myList .= "<td style='background-color:" . $background_color . "'><img src='images/trash.gif' onclick='show_confirm(\"confirmcomment_" . $row['comment_id'] . "\");'>" .
    1056. 

  1056.             "</td></tr></table>\n";
    1057. 

  1057. 

  1058.             // Div for edit box
    1059. 

  1059.             $myList .= "<div class='editbox' id='editcomment_" . $row['comment_id'] . "' style='background-color: white;'>" .
    1060. 

  1060.             "<center><font color='red'>Edit:</font><br>\n<textarea id='txtEditComment_" .
    1061. 

  1061.             $row['comment_id'] .
    1062. 

  1062.             "' rows='3' cols='100'>\n" .
    1063. 

  1063.             //"onkeydown='handleKeyEditComment(event, $project, " . $row['comment_id'] . ")'>\n" .
    1064. 

  1064.             $row['comment_text'] . "</textarea><br>" .
    1065. 

  1065.             "<img src='images/update_icon.png' " .
    1066. 

  1066.             "onclick='{var editcomm = $(\"comment_" . $row['comment_id'] . "\"); Element.hide(editcomm); " .
    1067. 

  1067.             "process_comments(" . $row['comment_id'] . ", \"editComment\", \"" . $project . "\");}'>  &nbsp; &nbsp; " .
    1068. 

  1068.             //"process_comments(editcomm.id, \"editComment\", \"" . $project . "\");}'>  &nbsp; &nbsp; " .
    1069. 

  1069.             "<img src='images/cancel_icon.png' onclick='hide_editbox(\"editcomment_" . $row['comment_id'] . "\");'></center></div>\n";
    1070. 

  1070. 

  1071.             // Div to confirm deletion
    1072. 

  1072.             $myList .= "<div class='confirm' id='confirmcomment_" . $row['comment_id'] . "' style='background-color: white;'><font color='red'>" .
    1073. 

  1073.             "<center>Are you sure you want to delete this item?</font><br>" .
    1074. 

  1074.             "<img src='images/confirm_delete_icon.png' " .
    1075. 

  1075.             "onclick='{var remcomm = $(\"comment_" . $row['comment_id'] . "\"); Element.hide(remcomm); " .
    1076. 

  1076.             "process_comments(" . $row['comment_id'] . ", \"delComment\", \"" .
    1077. 

  1077.             $project . "\");}'>  &nbsp; &nbsp; " .
    1078. 

  1078.             "<img src='images/cancel_icon.png' onclick='hide_confirm(\"confirmcomment_" . $row['comment_id'] . "\");'></center></div>";
    1079. 

  1079. 

  1080. 

  1081.             $myList .= "</div>\n";
    1082. 

  1082.         }
    1083. 

  1083.     } else {
    1084. 

  1084. 

  1085.         while ($row = mysql_fetch_array($get_comments, MYSQL_ASSOC))
    1086. 

  1086.         {
    1087. 

  1087. 

  1088.             $myList .= "<div id='comment_" . $row['comment_id'] . "' style='background-color: white'>";
    1089. 

  1089. 

  1090.             // Date submitted
    1091. 

  1091.             $myList .= "<table><tr valign='top'><td>" . short_date($row['submit_date']) . "</td>\n";
    1092. 

  1092. 

  1093.             // Comment text
    1094. 

  1094.             $myList .= "<td bgcolor='white' style='border: 1px solid $heading_color;'>"
    1095. 

  1095.                 . $row['comment_text'] . "</td>\n";
    1096. 

  1096. 

  1097.             // Don't show "Edit" icon
    1098. 

  1098.             $myList .= "<td></td>";
    1099. 

  1099. 

  1100.             // Don't show "Delete" icon
    1101. 

  1101.             $myList .= "<td></td></tr></table>\n";
    1102. 

  1102. 

  1103.             $myList .= "</div>\n";
    1104. 

  1104.         }
    1105. 

  1105. 

  1106.     }
    1107. 

  1107. 

  1108.     mysql_free_result($get_comments);
    1109. 

  1109.     mysql_close($conn);
    1110. 

  1110. 

  1111.     return $myList;
    1112. 

  1112. }
    1113. 

  1113. 

  1114. 

  1115. 

  1116. function ugly_date($formatted_date) {
    1117. 

  1117. 

  1118.     if ($formatted_date) {
    1119. 

  1119.         $parts = explode(" ", $formatted_date);
    1120. 

  1120.         $months = array("January", "February", "March", "April", "May", "June", "July", 
    1121. 

  1121.             "August", "September", "October", "November", "December");
    1122. 

  1122.         $monthnum = array_search($parts[0], $months) + 1;
    1123. 

  1123.         if (strlen($monthnum) < 2) {
    1124. 

  1124.             $monthnum = "0" . $monthnum;
    1125. 

  1125.         }
    1126. 

  1126.         $daynum = substr($parts[1], 0, strlen($parts[1]) - 1);
    1127. 

  1127.         if (strlen($daynum) < 2) {
    1128. 

  1128.             $daynum = "0" . $daynum;
    1129. 

  1129.         }
    1130. 

  1130.         $year = $parts[2];
    1131. 

  1131.         $newformat = $year . "-" . $monthnum . "-" . $daynum;
    1132. 

  1132.         return $newformat;
    1133. 

  1133.     } else {
    1134. 

  1134.         return $formatted_date;
    1135. 

  1135.     }
    1136. 

  1136. }
    1137. 

  1137. 

  1138. function pretty_date($formatted_date) {
    1139. 

  1139. 

  1140.     if ($formatted_date) {
    1141. 

  1141. 

  1142.         if ($formatted_date == "0000-00-00") {
    1143. 

  1143.             return "";
    1144. 

  1144.         }
    1145. 

  1145. 

  1146.         $parts = explode("-", $formatted_date);
    1147. 

  1147.         $months = array("January", "February", "March", "April", "May", "June", "July", 
    1148. 

  1148.             "August", "September", "October", "November", "December");
    1149. 

  1149.         $monthname = $months[$parts[1] - 1];
    1150. 

  1150.         $daynum = $parts[2];
    1151. 

  1151.         if (substr($daynum, 0, 1) == "0") {
    1152. 

  1152.             $daynum = substr($daynum, 1);
    1153. 

  1153.         }
    1154. 

  1154.         $year = $parts[0];
    1155. 

  1155.         $newformat = "$monthname $daynum, $year";
    1156. 

  1156.         return $newformat;
    1157. 

  1157.     } else {
    1158. 

  1158.         return $formatted_date;
    1159. 

  1159.     }
    1160. 

  1160. }
    1161. 

  1161. 

  1162. function short_date($formatted_date) {
    1163. 

  1163. 

  1164.     if ($formatted_date) {
    1165. 

  1165. 

  1166.         if ($formatted_date == "0000-00-00") {
    1167. 

  1167.             return "";
    1168. 

  1168.         }
    1169. 

  1169. 

  1170.         $parts = explode("-", $formatted_date);
    1171. 

  1171.         $monthnum = $parts[1];
    1172. 

  1172.         if (substr($monthnum, 0, 1) == "0") {
    1173. 

  1173.             $monthnum = substr($monthnum, 1);
    1174. 

  1174.         }
    1175. 

  1175.         $daynum = $parts[2];
    1176. 

  1176.         if (substr($daynum, 0, 1) == "0") {
    1177. 

  1177.             $daynum = substr($daynum, 1);
    1178. 

  1178.         }
    1179. 

  1179.         $year = $parts[0];
    1180. 

  1180.         $weekday = date("D", mktime(0, 0, 0, $monthnum, $daynum, $year));
    1181. 

  1181.         $shortyear = date("y", mktime(0, 0, 0, $monthnum, $daynum, $year));
    1182. 

  1182. 

  1183.         // If the date isn't in the current year, specify the year
    1184. 

  1184.         if ($year != date("Y")) {
    1185. 

  1185.             $newformat = "$weekday $monthnum/$daynum/$shortyear";
    1186. 

  1186.         } else {
    1187. 

  1187.             $newformat = "$weekday $monthnum/$daynum";
    1188. 

  1188.         }
    1189. 

  1189.         return $newformat;
    1190. 

  1190.     } else {
    1191. 

  1191.         return "";
    1192. 

  1192.     }
    1193. 

  1193. }
    1194. 

  1194. 

  1195. function shorter_date($formatted_date) {
    1196. 

  1196. 

  1197.     if ($formatted_date) {
    1198. 

  1198. 

  1199.         if ($formatted_date == "0000-00-00") {
    1200. 

  1200.             return "";
    1201. 

  1201.         }
    1202. 

  1202. 

  1203.         $parts = explode("-", $formatted_date);
    1204. 

  1204.         $monthnum = $parts[1];
    1205. 

  1205.         if (substr($monthnum, 0, 1) == "0") {
    1206. 

  1206.             $monthnum = substr($monthnum, 1);
    1207. 

  1207.         }
    1208. 

  1208.         $daynum = $parts[2];
    1209. 

  1209.         if (substr($daynum, 0, 1) == "0") {
    1210. 

  1210.             $daynum = substr($daynum, 1);
    1211. 

  1211.         }
    1212. 

  1212.         $year = $parts[0];
    1213. 

  1213.         $weekday = date("D", mktime(0, 0, 0, $monthnum, $daynum, $year));
    1214. 

  1214.         $shortyear = date("y", mktime(0, 0, 0, $monthnum, $daynum, $year));
    1215. 

  1215. 

  1216.         // If the date isn't in the current year, specify the year
    1217. 

  1217.         if ($year != date("Y")) {
    1218. 

  1218.             $newformat = "$monthnum/$daynum/$shortyear";
    1219. 

  1219.         } else {
    1220. 

  1220.             $newformat = "$monthnum/$daynum";
    1221. 

  1221.         }
    1222. 

  1222.         return $newformat;
    1223. 

  1223.     } else {
    1224. 

  1224.         return "";
    1225. 

  1225.     }
    1226. 

  1226. }
    1227. 

  1227. 

  1228. function mysql_date($standard_date) {
    1229. 

  1229. 

  1230.     if ($standard_date) {
    1231. 

  1231.         $parts = explode("/", $standard_date);
    1232. 

  1232.         $monthnum = $parts[0];
    1233. 

  1233.         if (strlen($monthnum) < 2) {
    1234. 

  1234.             $monthnum = "0" . $monthnum;
    1235. 

  1235.         }
    1236. 

  1236.         $daynum = $parts[1];
    1237. 

  1237.         if (strlen($daynum) < 2) {
    1238. 

  1238.             $daynum = "0" . $daynum;
    1239. 

  1239.         }
    1240. 

  1240.         $year = $parts[2];
    1241. 

  1241.         $newformat = $year . "-" . $monthnum . "-" . $daynum;
    1242. 

  1242.         return $newformat;
    1243. 

  1243.     } else {
    1244. 

  1244.         return $standard_date;
    1245. 

  1245.     }
    1246. 

  1246. }
    1247. 

  1247. 

  1248. function standard_date($mysql_date) {
    1249. 

  1249. 

  1250.     if ($mysql_date) {
    1251. 

  1251. 

  1252.         if ($mysql_date == "0000-00-00") {
    1253. 

  1253.             return "";
    1254. 

  1254.         }
    1255. 

  1255. 

  1256.         $parts = explode("-", $mysql_date);
    1257. 

  1257.         $monthnum = $parts[1];
    1258. 

  1258.         //if (substr($monthnum, 0, 1) == "0") {
    1259. 

  1259.         //    $monthnum = substr($monthnum, 1);
    1260. 

  1260.         //}
    1261. 

  1261.         $daynum = $parts[2];
    1262. 

  1262.         //if (substr($daynum, 0, 1) == "0") {
    1263. 

  1263.         //    $daynum = substr($daynum, 1);
    1264. 

  1264.         //}
    1265. 

  1265.         $longyear = $parts[0];
    1266. 

  1266. 

  1267.         // If the date isn't in the current year, specify the year
    1268. 

  1268.         $newformat = "$monthnum/$daynum/$longyear";
    1269. 

  1269.         return $newformat;
    1270. 

  1270.     } else {
    1271. 

  1271.         return "";
    1272. 

  1272.     }
    1273. 

  1273. }
    1274. 

  1274. 

  1275. function display_controls($fields, $values) {
    1276. 

  1276. 

  1277.     // Make sure at least one field was passed
    1278. 

  1278.     if (count($fields) < 1) {
    1279. 

  1279.         return "";
    1280. 

  1280.     }
    1281. 

  1281. 

  1282.     // Start table for controls
    1283. 

  1283.     printf("<table class='smalltext'><tr>\n");
    1284. 

  1284. 

  1285.     // Store passed arguments into local variables
    1286. 

  1286.     for ($i = 0; $i < count($fields); $i++) {
    1287. 

  1287.         if ($fields[$i] == "Staff") {
    1288. 

  1288.             
    1289. 

  1289.             // Staff Member
    1290. 

  1290.             $staff = $values[$i];
    1291. 

  1291.             //printf("<td>Staff Member: \n");
    1292. 

  1292.             printf("<td>Staff: \n");
    1293. 

  1293.             printf("<select name='staff' size='1' onChange='viewform.submit()'>\n");
    1294. 

  1294.             
    1295. 

  1295.             // Retrieve and display list of staff members
    1296. 

  1296.             $conn = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) 
    1297. 

  1297.                 or die ("Cannot connect to database. " . mysql_error() . "\n<br>");
    1298. 

  1298.             mysql_select_db (DB_DATABASE);
    1299. 

  1299.             $get_staff = mysql_query("select user_id, first_name, last_name from users " .
    1300. 

  1300.                 "where staff_flag = \"Y\" order by last_name ");
    1301. 

  1301.             if ($staff == 0) {
    1302. 

  1302.                 printf("<option value='0' selected>All\n");
    1303. 

  1303.             } else {
    1304. 

  1304.                 printf("<option value='0'>All\n");
    1305. 

  1305.             }
    1306. 

  1306.             $displayed_user = "All";
    1307. 

  1307.             while ($row = mysql_fetch_array($get_staff)) {
    1308. 

  1308.                 if ($staff == $row[0]) {
    1309. 

  1309.                     printf("<option value='$row[0]' selected>$row[1] $row[2]\n");
    1310. 

  1310.                     $displayed_user = "$row[1] $row[2]";
    1311. 

  1311.                 } else {
    1312. 

  1312.                     printf("<option value='$row[0]'>$row[1] $row[2]\n");
    1313. 

  1313.                 }
    1314. 

  1314.                 
    1315. 

  1315.             }
    1316. 

  1316.             mysql_free_result($get_staff);
    1317. 

  1317.             mysql_close($conn);
    1318. 

  1318.             
    1319. 

  1319.             printf("</select></td>\n");
    1320. 

  1320. 

  1321.             continue;
    1322. 

  1322.         }
    1323. 

  1323.         if ($fields[$i] == "Pstatus") {
    1324. 

  1324. 

  1325.             // Project status
    1326. 

  1326.             $status = $values[$i];
    1327. 

  1327.             //printf("<td>Project Status: \n");
    1328. 

  1328.             printf("<td>Projects: \n");
    1329. 

  1329.             printf("<select name='status' size='1' onChange='viewform.submit()'>\n");
    1330. 

  1330.             
    1331. 

  1331.             // Default status is Active
    1332. 

  1332.             if ($status == "") {
    1333. 

  1333.                 $status = "Active";
    1334. 

  1334.             }
    1335. 

  1335.     
    1336. 

  1336.             // Show list of status values
    1337. 

  1337.             if ($status == "All") {
    1338. 

  1338.                 printf("<option value='All' selected>All\n");
    1339. 

  1339.             } else {
    1340. 

  1340.                 printf("<option value='All'>All\n");
    1341. 

  1341.             }
    1342. 

  1342.             if ($status == "Open") {
    1343. 

  1343.                 printf("<option value='Open' selected>Open\n");
    1344. 

  1344.             } else {
    1345. 

  1345.                 printf("<option value='Open'>Open\n");
    1346. 

  1346.             }
    1347. 

  1347.             if ($status == "Proposed") {
    1348. 

  1348.                 printf("<option value='Proposed' selected>Proposed\n");
    1349. 

  1349.             } else {
    1350. 

  1350.                 printf("<option value='Proposed'>Proposed\n");
    1351. 

  1351.             }
    1352. 

  1352.             if ($status == "Pending") {
    1353. 

  1353.                 printf("<option value='Pending' selected>Pending\n");
    1354. 

  1354.             } else {
    1355. 

  1355.                 printf("<option value='Pending'>Pending\n");
    1356. 

  1356.             }
    1357. 

  1357.             if ($status == "Active") {
    1358. 

  1358.                 printf("<option value='Active' selected>Active\n");
    1359. 

  1359.             } else {
    1360. 

  1360.                 printf("<option value='Active'>Active\n");
    1361. 

  1361.             }
    1362. 

  1362.             if ($status == "Suspended") {
    1363. 

  1363.                 printf("<option value='Suspended' selected>Suspended\n");
    1364. 

  1364.             } else {
    1365. 

  1365.                 printf("<option value='Suspended'>Suspended\n");
    1366. 

  1366.             }
    1367. 

  1367.             if ($status == "Aborted") {
    1368. 

  1368.                 printf("<option value='Aborted' selected>Aborted\n");
    1369. 

  1369.             } else {
    1370. 

  1370.                 printf("<option value='Aborted'>Aborted\n");
    1371. 

  1371.             }
    1372. 

  1372.             if ($status == "Completed") {
    1373. 

  1373.                 printf("<option value='Completed' selected>Completed\n");
    1374. 

  1374.             } else {
    1375. 

  1375.                 printf("<option value='Completed'>Completed\n");
    1376. 

  1376.             }
    1377. 

  1377.             
    1378. 

  1378.             printf("</select></td>\n");
    1379. 

  1379. 

  1380.             continue;
    1381. 

  1381.         }
    1382. 

  1382.         if ($fields[$i] == "Dstatus") {
    1383. 

  1383. 

  1384.             // Duty Status
    1385. 

  1385.             $dutystatus = $values[$i];
    1386. 

  1386.             //printf("<td>Duty Status: \n");
    1387. 

  1387.             printf("<td>Duties: \n");
    1388. 

  1388.             printf("<select name='status' size='1' onChange='viewform.submit()'>\n");
    1389. 

  1389.             
    1390. 

  1390.             // Default status is Active
    1391. 

  1391.             if ($dutystatus == "") {
    1392. 

  1392.                 $dutystatus = "Active";
    1393. 

  1393.             }
    1394. 

  1394.     
    1395. 

  1395.             // Show list of status values
    1396. 

  1396.             if ($dutystatus == "All") {
    1397. 

  1397.                 printf("<option value='All' selected>All\n");
    1398. 

  1398.             } else {
    1399. 

  1399.                 printf("<option value='All'>All\n");
    1400. 

  1400.             }
    1401. 

  1401.             if ($dutystatus == "Active") {
    1402. 

  1402.                 printf("<option value='Active' selected>Active\n");
    1403. 

  1403.             } else {
    1404. 

  1404.                 printf("<option value='Active'>Active\n");
    1405. 

  1405.             }
    1406. 

  1406.             if ($dutystatus == "Inactive") {
    1407. 

  1407.                 printf("<option value='Inactive' selected>Inactive\n");
    1408. 

  1408.             } else {
    1409. 

  1409.                 printf("<option value='Inactive'>Inactive\n");
    1410. 

  1410.             }            
    1411. 

  1411.             printf("</select></td>\n");
    1412. 

  1412. 

  1413.             continue;
    1414. 

  1414.         }
    1415. 

  1415.         if ($fields[$i] == "Tstatus") {
    1416. 

  1416. 

  1417.             // ToDo Status
    1418. 

  1418.             $todostatus = $values[$i];
    1419. 

  1419.             //printf("<td>To Do Status: \n");
    1420. 

  1420.             printf("<td>To Do Status: \n");
    1421. 

  1421.             printf("<select name='todostatus' size='1' onChange='viewform.submit()'>\n");
    1422. 

  1422.             
    1423. 

  1423.             // Default todo status is Pending
    1424. 

  1424.             if ($todostatus == "") {
    1425. 

  1425.                 $todostatus = "Pending";
    1426. 

  1426.             }
    1427. 

  1427.     
    1428. 

  1428.             // Show list of status values
    1429. 

  1429.             if ($todostatus == "Pending") {
    1430. 

  1430.                 printf("<option value='Pending' selected>Pending\n");
    1431. 

  1431.             } else {
    1432. 

  1432.                 printf("<option value='Pending'>Pending\n");
    1433. 

  1433.             }
    1434. 

  1434.             if ($todostatus == "Completed") {
    1435. 

  1435.                 printf("<option value='Completed' selected>Completed\n");
    1436. 

  1436.             } else {
    1437. 

  1437.                 printf("<option value='Completed'>Completed\n");
    1438. 

  1438.             }
    1439. 

  1439.             
    1440. 

  1440.             printf("</select></td>\n");
    1441. 

  1441. 

  1442.             continue;
    1443. 

  1443.         }
    1444. 

  1444.         if ($fields[$i] == "Priority") {
    1445. 

  1445. 

  1446.             // ToDo Status
    1447. 

  1447.             $priority = $values[$i];
    1448. 

  1448.             printf("<td>Priority: \n");
    1449. 

  1449.             printf("<select name='priority' size='1' onChange='viewform.submit()'>\n");
    1450. 

  1450.             
    1451. 

  1451.             // Default priority is High
    1452. 

  1452.             if ($priority == "") {
    1453. 

  1453.                 $priority = "High";
    1454. 

  1454.             }
    1455. 

  1455.     
    1456. 

  1456.             // Show list of status values
    1457. 

  1457.             if ($priority == "High") {
    1458. 

  1458.                 printf("<option value='High' selected>High\n");
    1459. 

  1459.             } else {
    1460. 

  1460.                 printf("<option value='High'>High\n");
    1461. 

  1461.             }
    1462. 

  1462.             if ($priority == "Low") {
    1463. 

  1463.                 printf("<option value='Low' selected>Low\n");
    1464. 

  1464.             } else {
    1465. 

  1465.                 printf("<option value='Low'>Low\n");
    1466. 

  1466.             }
    1467. 

  1467.             
    1468. 

  1468.             printf("</select></td>\n");
    1469. 

  1469. 

  1470.             continue;
    1471. 

  1471.         }
    1472. 

  1472.         if ($fields[$i] == "FromDate") {
    1473. 

  1473. 

  1474.             // From Date
    1475. 

  1475.             $fromdate = $values[$i];
    1476. 

  1476.             printf("<td>From: \n");
    1477. 

  1477.             show_date_form_onchange('fromdate', $fromdate);
    1478. 

  1478.             printf("</td>\n");
    1479. 

  1479. 

  1480.             continue;
    1481. 

  1481.         }
    1482. 

  1482.         if ($fields[$i] == "ToDate") {
    1483. 

  1483. 

  1484.             // To Date
    1485. 

  1485.             $todate = $values[$i];
    1486. 

  1486.             printf("<td>To: \n");
    1487. 

  1487.             show_date_form_onchange('todate', $todate);
    1488. 

  1488.             printf("</td>\n");
    1489. 

  1489. 

  1490.             continue;
    1491. 

  1491.         }
    1492. 

  1492.         if ($fields[$i] == "Ftype") {
    1493. 

  1493. 

  1494.             // File Type
    1495. 

  1495.             $filetype = $values[$i];
    1496. 

  1496.             printf("<td>File Type: \n");
    1497. 

  1497.             printf("<select name='filetype' size='1' onChange='viewform.submit()'>\n");
    1498. 

  1498.             
    1499. 

  1499.             // Default todo status is Pending
    1500. 

  1500.             if ($todostatus == "") {
    1501. 

  1501.                 $todostatus = "Pending";
    1502. 

  1502.             }
    1503. 

  1503.     
    1504. 

  1504.             // Show list of file type values
    1505. 

  1505.             if ($filetype == "") {
    1506. 

  1506.                 printf("<option value='NULL' selected>\n");
    1507. 

  1507.             } else {
    1508. 

  1508.                 printf("<option value='NULL'>\n");
    1509. 

  1509.             }
    1510. 

  1510.             if ($filetype == "Report") {
    1511. 

  1511.                 printf("<option value='Report' selected>Report\n");
    1512. 

  1512.             } else {
    1513. 

  1513.                 printf("<option value='Report'>Report\n");
    1514. 

  1514.             }
    1515. 

  1515.             if ($filetype == "Program") {
    1516. 

  1516.                 printf("<option value='Program' selected>Program\n");
    1517. 

  1517.             } else {
    1518. 

  1518.                 printf("<option value='Program'>Program\n");
    1519. 

  1519.             }
    1520. 

  1520.             if ($filetype == "Protocol") {
    1521. 

  1521.                 printf("<option value='Protocol' selected>Protocol\n");
    1522. 

  1522.             } else {
    1523. 

  1523.                 printf("<option value='Protocol'>Protocol\n");
    1524. 

  1524.             }
    1525. 

  1525.             
    1526. 

  1526.             printf("</select></td>\n");
    1527. 

  1527. 

  1528.             continue;
    1529. 

  1529.         }
    1530. 

  1530.         if ($fields[$i] == "Results") {
    1531. 

  1531. 

  1532.             // Results Per Page
    1533. 

  1533.             $maxresults = $values[$i];
    1534. 

  1534.             printf("<td>Results Per Page: \n");
    1535. 

  1535.             printf("<input type='text' name='maxresults' size='2' value='$maxresults' onChange='viewform.submit()'>\n");
    1536. 

  1536.             printf("</td>\n");
    1537. 

  1537.             continue;
    1538. 

  1538.         }
    1539. 

  1539.     }
    1540. 

  1540. 

  1541.     printf("</tr></table>\n");
    1542. 

  1542. 

  1543.     return $displayed_user;
    1544. 

  1544. 

  1545. }
    1546. 

  1546. 

  1547. function show_date_form($datevar, $defaultvalue) {
    1548. 

  1548. 

  1549.     // Show a date variable in a form
    1550. 

  1550.     printf("<input type='text' name='$datevar' id='$datevar' size='12' value='$defaultvalue'>\n");
    1551. 

  1551.     printf("<img src='images/calendar.gif' id='$datevar" . "_cal' ");
    1552. 

  1552.     printf("style='cursor: pointer; border: 1px solid red;' title='Date selector' ");
    1553. 

  1553.     printf("onmouseover=\"this.style.background='red';\" ");
    1554. 

  1554.     printf("onmouseout=\"this.style.background=''\">\n");
    1555. 

  1555.     printf("<script type='text/javascript'>\n");
    1556. 

  1556.     printf("    Calendar.setup({\n");
    1557. 

  1557.     printf("        inputField     :    \"$datevar\",     // id of the input field\n");
    1558. 

  1558.     printf("        ifFormat       :    \"%%m/%%d/%%Y\",      // format of the input field\n");
    1559. 

  1559.     printf("        button         :    \"$datevar" . "_cal\",  // trigger for the calendar (button ID)\n");
    1560. 

  1560.     printf("        align          :    \"Tl\",           // alignment (defaults to \"Bl\")\n");
    1561. 

  1561.     printf("        singleClick    :    true\n");
    1562. 

  1562.     printf("    });\n");
    1563. 

  1563.     printf("</script>\n");
    1564. 

  1564. 

  1565. }
    1566. 

  1566. 

  1567. function show_date_form_onchange($datevar, $defaultvalue) {
    1568. 

  1568. 

  1569.     // Show a date variable in a form
    1570. 

  1570.     printf("<input type='text' name='$datevar' id='$datevar' size='12' value='$defaultvalue' onChange='viewform.submit()'>\n");
    1571. 

  1571.     printf("<img src='images/calendar.gif' id='$datevar" . "_cal' ");
    1572. 

  1572.     printf("style='cursor: pointer; border: 1px solid red;' title='Date selector' ");
    1573. 

  1573.     printf("onmouseover=\"this.style.background='red';\" ");
    1574. 

  1574.     printf("onmouseout=\"this.style.background=''\">\n");
    1575. 

  1575.     printf("<script type='text/javascript'>\n");
    1576. 

  1576.     printf("    Calendar.setup({\n");
    1577. 

  1577.     printf("        inputField     :    \"$datevar\",     // id of the input field\n");
    1578. 

  1578.     printf("        ifFormat       :    \"%%m/%%d/%%Y\",      // format of the input field\n");
    1579. 

  1579.     printf("        button         :    \"$datevar" . "_cal\",  // trigger for the calendar (button ID)\n");
    1580. 

  1580.     printf("        align          :    \"Tl\",           // alignment (defaults to \"Bl\")\n");
    1581. 

  1581.     printf("        singleClick    :    true\n");
    1582. 

  1582.     printf("    });\n");
    1583. 

  1583.     printf("</script>\n");
    1584. 

  1584. 

  1585. }
    1586. 

  1586. 

  1587. function page_results($rowcount, $page, $maxresults, $url) {
    1588. 

  1588. 

  1589.     // Show total number of results
    1590. 

  1590.     $paging = "<table cellspacing='5' cellpadding='0' class='smalltext'><tr>";
    1591. 

  1591.     $paging .= "<td><b>Results: $rowcount</b></td>\n";
    1592. 

  1592. 

  1593.     // Show page number
    1594. 

  1594.     $maxpage = ceil($rowcount / $maxresults);
    1595. 

  1595.     $paging .= "<td>&nbsp; Page $page of $maxpage</td>\n";
    1596. 

  1596.     
    1597. 

  1597.     // Previous page button
    1598. 

  1598.     if ($page > 1) {
    1599. 

  1599.         $paging .= "<td>&nbsp; <a href='$url&page=" . ($page - 1) . 
    1600. 

  1600.             "&maxresults=$maxresults'>Prev</a></td>\n";
    1601. 

  1601.     }
    1602. 

  1602. 

  1603.     // Next page button
    1604. 

  1604.     if ($page < $maxpage) {
    1605. 

  1605.         $paging .= "<td>&nbsp; <a href='$url&page=" . ($page + 1) . 
    1606. 

  1606.             "&maxresults=$maxresults'>Next</a></td>\n";
    1607. 

  1607.     }
    1608. 

  1608.     $paging .= "</tr></table>\n";
    1609. 

  1609. 

  1610.     return $paging;
    1611. 

  1611. 

  1612. }
    1613. 

  1613. 

  1614. function fill_pdlist_arrays($staff, &$projects, &$project_ids, &$duties, &$duty_ids) {
    1615. 

  1615. 

  1616.     // Create JavaScript array of open projects
    1617. 

  1617.     $conn = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) 
    1618. 

  1618.         or die ("Cannot connect to database. " . mysql_error() . "\n<br>");
    1619. 

  1619.     mysql_select_db (DB_DATABASE);
    1620. 

  1620.     $get_projects = mysql_query("select project_id, title from projects " .
    1621. 

  1621.         "where staff_assigned = \"$staff\" " .
    1622. 

  1622.         "and status in ('Pending', 'Active', 'Suspended') " .
    1623. 

  1623.         "order by date_entered desc ");
    1624. 

  1624.     $project_ids = array();
    1625. 

  1625.     $projects = array();
    1626. 

  1626.     $nprojects = 0;
    1627. 

  1627.     while ($row = mysql_fetch_array($get_projects, MYSQL_ASSOC)) {
    1628. 

  1628.         if (strlen($row['title']) > 40) {
    1629. 

  1629.             $project_title = substr($row['title'], 0, 37) . "...";
    1630. 

  1630.         } else {
    1631. 

  1631.             $project_title = $row['title'];
    1632. 

  1632.         }
    1633. 

  1633.         $project_ids[$nprojects] = $row['project_id'];
    1634. 

  1634.         $projects[$nprojects] = $project_title;
    1635. 

  1635.         $nprojects++;
    1636. 

  1636.     }
    1637. 

  1637.     mysql_free_result($get_projects);
    1638. 

  1638.     mysql_close($conn);
    1639. 

  1639.     printf("<script language='JavaScript'>\n");
    1640. 

  1640.     printf("var project_ids = new Array(%d);\n", $nprojects);
    1641. 

  1641.     printf("var projects = new Array(%d);\n", $nprojects);
    1642. 

  1642.     for ($i = 0; $i < $nprojects; $i++) {
    1643. 

  1643.         printf("project_ids[$i] = '$project_ids[$i]';\n");
    1644. 

  1644.         printf("projects[$i] = '$projects[$i]';\n");
    1645. 

  1645.     }
    1646. 

  1646.     printf("</script>\n");
    1647. 

  1647. 

  1648.     // Create JavaScript array of active duties
    1649. 

  1649.     $conn = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) 
    1650. 

  1650.         or die ("Cannot connect to database. " . mysql_error() . "\n<br>");
    1651. 

  1651.     mysql_select_db (DB_DATABASE);
    1652. 

  1652.     $get_duties = mysql_query("select duty_id, title from duties " .
    1653. 

  1653.         "where staff_assigned = \"$staff\" " .
    1654. 

  1654.         "and status = 'Active' " .
    1655. 

  1655.         "order by date_entered desc ");
    1656. 

  1656.     $duty_ids = array();
    1657. 

  1657.     $duties = array();
    1658. 

  1658.     $nduties = 0;
    1659. 

  1659.     while ($row = mysql_fetch_array($get_duties, MYSQL_ASSOC)) {
    1660. 

  1660.         if (strlen($row['title']) > 40) {
    1661. 

  1661.             $duty_title = substr($row['title'], 0, 37) . "...";
    1662. 

  1662.         } else {
    1663. 

  1663.             $duty_title = $row['title'];
    1664. 

  1664.         }
    1665. 

  1665.         $duty_ids[$nduties] = $row['duty_id'];
    1666. 

  1666.         $duties[$nduties] = $duty_title;
    1667. 

  1667.         $nduties++;
    1668. 

  1668.     }
    1669. 

  1669.     mysql_free_result($get_duties);
    1670. 

  1670.     mysql_close($conn);
    1671. 

  1671.     printf("<script language='JavaScript'>\n");
    1672. 

  1672.     printf("var duty_ids = new Array(%d);\n", $nduties);
    1673. 

  1673.     printf("var duties = new Array(%d);\n", $nduties);
    1674. 

  1674.     for ($i = 0; $i < $nduties; $i++) {
    1675. 

  1675.         printf("duty_ids[$i] = '$duty_ids[$i]';\n");
    1676. 

  1676.         printf("duties[$i] = '$duties[$i]';\n");
    1677. 

  1677.     }
    1678. 

  1678.     printf("</script>\n");
    1679. 

  1679. 

  1680.     return;
    1681. 

  1681. }
    1682. 

  1682. 

  1683. function make_pdlist($staff, $id, $project, $projects, $project_ids, 
    1684. 

  1684.     $duty, $duties, $duty_ids, $breakflag) {
    1685. 

  1685. 

  1686.     if ($id) {
    1687. 

  1687.         $suffix = "_" . $id;
    1688. 

  1688.     } else {
    1689. 

  1689.         $suffix = "";
    1690. 

  1690.     }
    1691. 

  1691.     
    1692. 

  1692.     $nprojects = count($projects);
    1693. 

  1693.     $nduties = count($duties);
    1694. 

  1694.     
    1695. 

  1695.     if ($row['project_id']) {
    1696. 

  1696.         $pstyle = "style='font-weight: bold' ";
    1697. 

  1697.         $dstyle = "style='font-weight: normal' ";
    1698. 

  1698.     } else if ($row['duty_id']) {
    1699. 

  1699.         $pstyle = "style='font-weight: normal' ";
    1700. 

  1700.         $dstyle = "style='font-weight: bold' ";
    1701. 

  1701.     } else {
    1702. 

  1702.         $pstyle = "style='font-weight: bold' ";
    1703. 

  1703.         $dstyle = "style='font-weight: normal' ";
    1704. 

  1704.     }
    1705. 

  1705.     
    1706. 

  1706.     // Project/Duty selection
    1707. 

  1707.     $list = "<font id='projectlabel$suffix' onclick='pdflag$suffix = \"Project\"; " .
    1708. 

  1708.         "populate_projects( $(\"pdlist$suffix\"), $(\"projectlabel$suffix\"), " .
    1709. 

  1709.         "$(\"dutylabel$suffix\"), project_ids, projects, \"$project\");' $pstyle>";
    1710. 

  1710.     $list .= "Project</font> / ";
    1711. 

  1711.     $list .= "<font id='dutylabel$suffix' onclick='pdflag$suffix = \"Duty\"; " .
    1712. 

  1712.         "populate_duties( $(\"pdlist$suffix\"), $(\"projectlabel$suffix\"), " .
    1713. 

  1713.         "$(\"dutylabel$suffix\"), duty_ids, duties, \"$duty\");' $dstyle>Duty</font>";
    1714. 

  1714.     if ($breakflag) {
    1715. 

  1715.         $list .= "<br>\n";
    1716. 

  1716.     } else {
    1717. 

  1717.         $list .= "\n";
    1718. 

  1718.     }
    1719. 

  1719.     $list .= "<select id='pdlist$suffix' size='1' " .
    1720. 

  1720.         "onChange=\"if (pdflag$suffix == 'Project') {duty = 0; " .
    1721. 

  1721.         "project = project_ids[$('pdlist$suffix').selectedIndex - 1];} " .
    1722. 

  1722.         "else {project = 0; duty = duty_ids[$('pdlist$suffix').selectedIndex - 1];}\" >\n";
    1723. 

  1723.         
    1724. 

  1724.     if ($project) {
    1725. 

  1725.         $list .= "<option value='P0'></option>\n";
    1726. 

  1726.         for ($i = 0; $i < $nprojects; $i++) {
    1727. 

  1727.             if ($project == $project_ids[$i]) {
    1728. 

  1728.                 $list .= "<option value='P" . $project_ids[$i] . 
    1729. 

  1729.                     "' selected>" . $projects[$i] . "</option>\n";
    1730. 

  1730.             } else {
    1731. 

  1731.                 $list .= "<option value='P" . $project_ids[$i] . 
    1732. 

  1732.                     "'>" . $projects[$i] . "</option>\n";
    1733. 

  1733.             }
    1734. 

  1734.         }
    1735. 

  1735.     } else if ($duty) {
    1736. 

  1736.         $list .= "<option value='D0'></option>\n";
    1737. 

  1737.         for ($i = 0; $i < $nduties; $i++) {
    1738. 

  1738.             if ($duty == $duty_ids[$i]) {
    1739. 

  1739.                 $list .= "<option value='D" . $duty_ids[$i] . 
    1740. 

  1740.                     "' selected>" . $duties[$i] . "</option>\n";
    1741. 

  1741.             } else {
    1742. 

  1742.                 $list .= "<option value='D" . $duty_ids[$i] . 
    1743. 

  1743.                     "'>" . $duties[$i] . "</option>\n";
    1744. 

  1744.             }
    1745. 

  1745.         }
    1746. 

  1746.     } else {
    1747. 

  1747.         $list .= "<option value='P0'></option>\n";
    1748. 

  1748.         for ($i = 0; $i < $nprojects; $i++) {
    1749. 

  1749.             if ($project == $project_ids[$i]) {
    1750. 

  1750.                 $list .= "<option value='P" . $project_ids[$i] . 
    1751. 

  1751.                     "' selected>" . $projects[$i] . "</option>\n";
    1752. 

  1752.             } else {
    1753. 

  1753.                 $list .= "<option value='P" . $project_ids[$i] . 
    1754. 

  1754.                     "'>" . $projects[$i] . "</option>\n";
    1755. 

  1755.             }
    1756. 

  1756.         }
    1757. 

  1757.     }
    1758. 

  1758.     
    1759. 

  1759.     $list .= "</select>\n";
    1760. 

  1760. 

  1761.     return $list;
    1762. 

  1762. }
    1763. 

  1763. 

  1764. function find_mover($oldorderlist1, $neworderlist, &$mover, &$datepartner) {
    1765. 

  1765. 

  1766.     // Find date borders in the new order
    1767. 

  1767.     $borders = array();
    1768. 

  1768.     $nborders = 0;
    1769. 

  1769.     for ($i = 0; $i < count($neworderlist); $i++) {
    1770. 

  1770.         if (substr($neworderlist[$i], 0, 1) == "A") {
    1771. 

  1771.             $borders[$nborders] = $neworderlist[$i];
    1772. 

  1772.             $nborders++;
    1773. 

  1773.         }
    1774. 

  1774.     }
    1775. 

  1775. 

  1776.     // Fill in missing borders in old order
    1777. 

  1777.     $oldorderlist = array();
    1778. 

  1778.     $count = 0;
    1779. 

  1779.     for ($i = 0; $i < count($oldorderlist1); $i++) {
    1780. 

  1780.         $testborder = "A" . $oldorderlist1[$i];
    1781. 

  1781.         if (in_array($testborder, $borders)) {
    1782. 

  1782.             $oldorderlist[$count] = $testborder;
    1783. 

  1783.             $count++;
    1784. 

  1784.         }
    1785. 

  1785.         $oldorderlist[$count] = $oldorderlist1[$i];
    1786. 

  1786.         $count++;
    1787. 

  1787.     }
    1788. 

  1788. 

  1789.     // Find first change in lists, from front and back
    1790. 

  1790.     for ($i = 0; $i < count($neworderlist); $i++) {
    1791. 

  1791.         if ($neworderlist[$i] != $oldorderlist[$i]) {
    1792. 

  1792.             $candidate1 = $neworderlist[$i];
    1793. 

  1793.             $c1new = $i;
    1794. 

  1794.             break;
    1795. 

  1795.         }
    1796. 

  1796.     }
    1797. 

  1797.     for ($i = (count($neworderlist) - 1); $i >= 0; $i--) {
    1798. 

  1798.         if ($neworderlist[$i] != $oldorderlist[$i]) {
    1799. 

  1799.             $candidate2 = $neworderlist[$i];
    1800. 

  1800.             $c2new = $i;
    1801. 

  1801.             break;
    1802. 

  1802.         }
    1803. 

  1803.     }
    1804. 

  1804. 

  1805.     // Find positions of candidates in old order
    1806. 

  1806.     $c1old = array_search($neworderlist[$c1new], $oldorderlist);
    1807. 

  1807.     $c2old = array_search($neworderlist[$c2new], $oldorderlist);
    1808. 

  1808. 

  1809.     // The real moved item will have two different neighbors
    1810. 

  1810.     if (($oldorderlist[$c1old - 1] != $neworderlist[$c1new - 1]) &&
    1811. 

  1811.         ($oldorderlist[$c1old + 1] != $neworderlist[$c1new + 1])) {
    1812. 

  1812. 

  1813.         // Candidate 1 is the mover
    1814. 

  1814.         $mover = $candidate1;
    1815. 

  1815. 

  1816.         // Find date partner
    1817. 

  1817.         if (substr($neworderlist[$c1new - 1], 0, 1) == "A") {
    1818. 

  1818.             $datepartner = $neworderlist[$c1new + 1];
    1819. 

  1819.         } else if (substr($neworderlist[$c1new + 1], 0, 1) == "A") {
    1820. 

  1820.             $datepartner = $neworderlist[$c1new - 1];
    1821. 

  1821.         } else {
    1822. 

  1822.             $datepartner = $neworderlist[$c1new + 1];
    1823. 

  1823.         }
    1824. 

  1824. 

  1825.     } else {
    1826. 

  1826. 

  1827.         // Candidate 2 is the mover
    1828. 

  1828.         $mover = $candidate2;
    1829. 

  1829. 

  1830.         // Find date partner
    1831. 

  1831.         if (substr($neworderlist[$c2new - 1], 0, 1) == "A") {
    1832. 

  1832.             $datepartner = $neworderlist[$c2new + 1];
    1833. 

  1833.         } else if (substr($neworderlist[$c2new + 1], 0, 1) == "A") {
    1834. 

  1834.             $datepartner = $neworderlist[$c2new - 1];
    1835. 

  1835.         } else {
    1836. 

  1836.             $datepartner = $neworderlist[$c2new + 1];
    1837. 

  1837.         }
    1838. 

  1838. 

  1839.     }
    1840. 

  1840. 

  1841.     return;
    1842. 

  1842. 

  1843. }
    1844. 

  1844. 

  1845. ?>
    1846. 

  1846.