WEB-INF/templates/reports.tpl

   1 <script>
   2 // We need a couple of array-like objects, one for associated task ids, another for task names.
   3 // For performance, and because associated arrays are frowned upon in JavaScript, we'll use a simple object
   4 // with properties for project tasks. Format:
   5
   6 // obj_tasks.p325 = "100,101,302,303,304"; // Tasks ids for project 325 are "100,101,302,303,304".
   7 // obj_tasks.p408 = "100,302";  // Tasks ids for project 408 are "100,302".
   8
   9 // Create an object for task ids.
  10 obj_tasks = {};
  11 var project_prefix = "p"; // Prefix for project property.
  12 var project_property;
  13
  14 // Populate obj_tasks with task ids for each relevant project.
  15 {foreach $project_list as $project}
  16   project_property = project_prefix + {$project.id};
  17   obj_tasks[project_property] = "{$project.tasks}";
  18 {/foreach}
  19
  20 // Prepare an array of task names.
  21 // Format: task_names[0] = Array(100, 'Coding'), task_names[1] = Array(302, 'Debugging'), etc...
  22 // First element = task_id, second element = task name.
  23 task_names = new Array();
  24 var idx = 0;
  25 {foreach $task_list as $task}
  26   task_names[idx] = new Array({$task.id}, "{$task.name|escape:'javascript'}");
  27   idx++;
  28 {/foreach}
  29
  30
  31 // empty_label is the mandatory top option in the tasks dropdown.
  32 empty_label = '{$i18n.dropdown.all|escape:'javascript'}';
  33
  34 // inArray - determines whether needle is in haystack array.
  35 function inArray(needle, haystack) {
  36   var length = haystack.length;
  37   for(var i = 0; i < length; i++) {
  38     if(haystack[i] == needle) return true;
  39   }
  40   return false;
  41 }
  42
  43 // The fillTaskDropdown function populates the task combo box with
  44 // tasks associated with a selected project_id.
  45 function fillTaskDropdown(project_id) {
  46   var str_task_ids;
  47   // Get a string of comma-separated task ids.
  48   if (project_id) {
  49     var property = "p" + project_id;
  50     str_task_ids = obj_tasks[property];
  51   }
  52   if (str_task_ids) {
  53     var task_ids = new Array(); // Array of task ids.
  54     task_ids = str_task_ids.split(",");
  55   }
  56
  57   var dropdown = document.getElementById("task");
  58   // Determine previously selected item.
  59   var selected_item = dropdown.options[dropdown.selectedIndex].value;
  60
  61   // Remove existing content.
  62   dropdown.length = 0;
  63   // Add mandatory top option.
  64   dropdown.options[0] = new Option(empty_label, '', true);
  65
  66   // Populate the dropdown with associated tasks.
  67   len = task_names.length;
  68   var dropdown_idx = 0;
  69   for (var i = 0; i < len; i++) {
  70     if (!project_id) {
  71       // No project is selected. Fill in all tasks.
  72       dropdown.options[dropdown_idx+1] = new Option(task_names[i][1], task_names[i][0]);
  73       dropdown_idx++;
  74     } else if (str_task_ids) {
  75       // Project is selected and has associated tasks. Fill them in.
  76       if (inArray(task_names[i][0], task_ids)) {
  77         dropdown.options[dropdown_idx+1] = new Option(task_names[i][1], task_names[i][0]);
  78         dropdown_idx++;
  79       }
  80     }
  81   }
  82
  83   // If a previously selected item is still in dropdown - select it.
  84   if (dropdown.options.length > 0) {
  85     for (var i = 0; i < dropdown.options.length; i++) {
  86       if (dropdown.options[i].value == selected_item)  {
  87         dropdown.options[i].selected = true;
  88       }
  89     }
  90   }
  91 }
  92
  93 // Build JavaScript array for assigned projects out of passed in PHP array.
  94 var assigned_projects = new Array();
  95 {if $assigned_projects}
  96   {foreach $assigned_projects as $user_id => $projects}
  97     assigned_projects[{$user_id}] = new Array();
  98     {if $projects}
  99       {foreach $projects as $idx => $project_id}
 100         assigned_projects[{$user_id}][{$idx}] = {$project_id};
 101       {/foreach}
 102     {/if}
 103   {/foreach}
 104 {/if}
 105
 106 // selectAssignedUsers is called when a project is changed in project dropdown.
 107 // It selects users on the form who are assigned to this project.
 108 function selectAssignedUsers(project_id) {
 109   var user_id;
 110   var len;
 111
 112   for (var i = 0; i < document.reportForm.elements.length; i++) {
 113     if ((document.reportForm.elements[i].type == 'checkbox') && (document.reportForm.elements[i].name == 'users[]')) {
 114       user_id = document.reportForm.elements[i].value;
 115       if (project_id)
 116         document.reportForm.elements[i].checked = false;
 117       else
 118         document.reportForm.elements[i].checked = true;
 119
 120       if(assigned_projects[user_id] != undefined)
 121         len = assigned_projects[user_id].length;
 122       else
 123         len = 0;
 124
 125       if (project_id != '')
 126         for (var j = 0; j < len; j++) {
 127           if (project_id == assigned_projects[user_id][j]) {
 128             document.reportForm.elements[i].checked = true;
 129             break;
 130           }
 131         }
 132     }
 133   }
 134 }
 135
 136 // handleCheckboxes - unmarks and hides the "Totals only" checkbox when
 137 // "no grouping" is selected in the associated group by dropdowns.
 138 function handleCheckboxes() {
 139   var totalsOnlyCheckbox = document.getElementById("chtotalsonly");
 140   var totalsOnlyLabel = document.getElementById("totals_only_label");
 141   var groupBy1 = document.getElementById("group_by1");
 142   var groupBy2 = document.getElementById("group_by2");
 143   var groupBy3 = document.getElementById("group_by3");
 144   var grouping = false;
 145   if ((groupBy1 != null && "no_grouping" != groupBy1.value) ||
 146       (groupBy2 != null && "no_grouping" != groupBy2.value) ||
 147       (groupBy3 != null && "no_grouping" != groupBy3.value)) {
 148     grouping = true;
 149   }
 150   if (grouping) {
 151     // Show the "Totals only" checkbox.
 152     totalsOnlyCheckbox.style.visibility = "visible";
 153     totalsOnlyLabel.style.visibility = "visible";
 154   } else {
 155     // Unmark and hide the "Totals only" checkbox.
 156     totalsOnlyCheckbox.checked = false;
 157     totalsOnlyCheckbox.style.visibility = "hidden";
 158     totalsOnlyLabel.style.visibility = "hidden";
 159   }
 160 }
 161 </script>
 162
 163 {$forms.reportForm.open}
 164 <div style="padding: 0 0 10 0;">
 165   <table border="0" class="divider">
 166     <tr>
 167       <td>
 168         <table cellspacing="1" cellpadding="3" border="0">
 169           <tr>
 170             <td>{$i18n.label.fav_report}:</td><td>{$forms.reportForm.favorite_report.control}</td>
 171             <td>{$forms.reportForm.btn_generate.control}&nbsp;{$forms.reportForm.btn_delete.control}</td>
 172           </tr>
 173         </table>
 174       </td>
 175     </tr>
 176   </table>
 177 </div>
 178
 179 <table cellspacing="4" cellpadding="7" border="0">
 180   <tr>
 181     <td valign="top" colspan="2" align="center">
 182       <table border="0" cellpadding="3">
 183 {if (($user->isPluginEnabled('cl') && !($user->isClient() && $user->client_id)) || ($custom_fields && $custom_fields->fields[0] && $custom_fields->fields[0]['type'] == CustomFields::TYPE_DROPDOWN))}
 184         <tr>
 185   {if $user->isPluginEnabled('cl') && !($user->isClient() && $user->client_id)}<td><b>{$i18n.label.client}</b></td>{else}<td>&nbsp;</td>{/if}
 186           <td>&nbsp;</td>
 187   {if ($custom_fields && $custom_fields->fields[0] && $custom_fields->fields[0]['type'] == CustomFields::TYPE_DROPDOWN)}<td><b>{$i18n.label.option}</b></td>{else}<td>&nbsp;</td>{/if}
 188         </tr>
 189         <tr>
 190           <td>{$forms.reportForm.client.control}</td>
 191           <td>&nbsp;</td>
 192           <td>{$forms.reportForm.option.control}</td>
 193         </tr>
 194 {/if}
 195 {if ($smarty.const.MODE_PROJECTS == $user->tracking_mode || $smarty.const.MODE_PROJECTS_AND_TASKS == $user->tracking_mode)}
 196         <tr>
 197           <td><b>{$i18n.label.project}</b></td>
 198           <td>&nbsp;</td>
 199   {if ($smarty.const.MODE_PROJECTS_AND_TASKS == $user->tracking_mode)}
 200           <td><b>{$i18n.label.task}</b></td>
 201   {/if}
 202         </tr>
 203 {/if}
 204 {if ($smarty.const.MODE_PROJECTS == $user->tracking_mode || $smarty.const.MODE_PROJECTS_AND_TASKS == $user->tracking_mode)}
 205         <tr>
 206           <td>{$forms.reportForm.project.control}</td>
 207           <td>&nbsp;</td>
 208   {if ($smarty.const.MODE_PROJECTS_AND_TASKS == $user->tracking_mode)}
 209           <td>{$forms.reportForm.task.control}</td>
 210   {/if}
 211         </tr>
 212 {/if}
 213 {if $user->isPluginEnabled('iv')}
 214         <tr>
 215           <td><b>{$i18n.form.time.billable}</b></td>
 216           <td>&nbsp;</td>
 217   {if $user->can('manage_invoices')}
 218           <td><b>{$i18n.label.invoice}</b></td>
 219   {/if}
 220         </tr>
 221         <tr valign="top">
 222           <td>{$forms.reportForm.include_records.control}</td>
 223           <td>&nbsp;</td>
 224   {if $user->can('manage_invoices')}
 225           <td>{$forms.reportForm.invoice.control}</td>
 226         </tr>
 227   {/if}
 228 {/if}
 229 {if ($user->can('manage_invoices') && $user->isPluginEnabled('ps'))}
 230         <tr>
 231           <td><b>{$i18n.label.paid_status}</b></td>
 232         </tr>
 233         <tr>
 234           <td>{$forms.reportForm.paid_status.control}</td>
 235         </tr>
 236 {/if}
 237 {if $user->can('view_reports') || $user->can('view_all_reports') || $user->isClient()}
 238         <tr>
 239           <td colspan="3"><b>{$i18n.label.users}</b></td>
 240         </tr>
 241         <tr>
 242           <td colspan="3">{$forms.reportForm.users.control}</td>
 243         </tr>
 244 {/if}
 245         <tr>
 246           <td><b>{$i18n.form.reports.select_period}</b></td>
 247           <td>&nbsp;</td>
 248           <td><b>{$i18n.form.reports.set_period}</b></td>
 249         </tr>
 250         <tr valign="top">
 251           <td>{$forms.reportForm.period.control}</td>
 252           <td align="right">{$i18n.label.start_date}:</td>
 253           <td>{$forms.reportForm.start_date.control}</td>
 254         </tr>
 255         <tr>
 256           <td></td>
 257           <td align="right">{$i18n.label.end_date}:</td>
 258           <td>{$forms.reportForm.end_date.control}</td>
 259         </tr>
 260         <tr><td colspan="3"><b>{$i18n.form.reports.show_fields}</b></td></tr>
 261         <tr>
 262           <td colspan="3">
 263             <table border="0" width="100%">
 264 {if $user->can('view_reports') || $user->can('view_all_reports') || $user->isPluginEnabled('cl') || $user->isPluginEnabled('iv') || $user->isPluginEnabled('ps')}
 265               <tr>
 266   {if $user->isPluginEnabled('cl')}
 267                 <td width="25%"><label>{$forms.reportForm.chclient.control}&nbsp;{$i18n.label.client}</label></td>
 268   {/if}
 269   {if ($user->can('manage_invoices') || $user->isClient()) && $user->isPluginEnabled('iv')}
 270                 <td width="25%"><label>{$forms.reportForm.chinvoice.control}&nbsp;{$i18n.label.invoice}</label></td>
 271   {/if}
 272   {if ($user->can('manage_invoices') && $user->isPluginEnabled('ps'))}
 273                 <td width="25%"><label>{$forms.reportForm.chpaid.control}&nbsp;{$i18n.label.paid}</label></td>
 274   {/if}
 275   {if $user->can('view_reports') || $user->can('view_all_reports')}
 276                 <td width="25%"><label>{$forms.reportForm.chip.control}&nbsp;{$i18n.label.ip}</label></td>
 277   {/if}
 278               </tr>
 279 {/if}
 280               <tr>
 281                 <td width="25%">{if ($smarty.const.MODE_PROJECTS == $user->tracking_mode || $smarty.const.MODE_PROJECTS_AND_TASKS == $user->tracking_mode)}<label>{$forms.reportForm.chproject.control}&nbsp;{$i18n.label.project}</label>{/if}</td>
 282                 <td width="25%">{if (($smarty.const.TYPE_START_FINISH == $user->record_type) || ($smarty.const.TYPE_ALL == $user->record_type))}<label>{$forms.reportForm.chstart.control}&nbsp;{$i18n.label.start}</label>{/if}</td>
 283                 <td width="25%"><label>{$forms.reportForm.chduration.control}&nbsp;{$i18n.label.duration}</label></td>
 284 {if ($user->can('manage_invoices') || $user->isClient()) || $user->isPluginEnabled('ex')}
 285                   <td width="25%"><label>{$forms.reportForm.chcost.control}&nbsp;{$i18n.label.cost}</label></td>
 286 {else}
 287                   <td></td>
 288 {/if}
 289               </tr>
 290               <tr>
 291                 <td>{if ($smarty.const.MODE_PROJECTS_AND_TASKS == $user->tracking_mode)}<label>{$forms.reportForm.chtask.control}&nbsp;{$i18n.label.task}</label>{/if}</td>
 292                 <td>{if (($smarty.const.TYPE_START_FINISH == $user->record_type) || ($smarty.const.TYPE_ALL == $user->record_type))}<label>{$forms.reportForm.chfinish.control}&nbsp;{$i18n.label.finish}</label>{/if}</td>
 293                 <td><label>{$forms.reportForm.chnote.control}&nbsp;{$i18n.label.note}</label></td>
 294 {if ($custom_fields && $custom_fields->fields[0])}
 295                 <td><label>{$forms.reportForm.chcf_1.control}&nbsp;{$custom_fields->fields[0]['label']|escape}</label></td>
 296 {else}
 297                 <td></td>
 298 {/if}
 299               </tr>
 300 {if $user->isPluginEnabled('wu')}
 301               <tr>
 302                 <td></td>
 303                 <td></td>
 304                 <td width="25%"><label>{$forms.reportForm.chunits.control}&nbsp;{$i18n.label.work_units}</label></td>
 305                 <td></td>
 306               </tr>
 307 {/if}
 308             </table>
 309           </td>
 310         </tr>
 311         <tr>
 312             <td><b>{$i18n.form.reports.group_by}</b></td>
 313         </tr>
 314         <tr valign="top">
 315           <td>{$forms.reportForm.group_by1.control}</td>
 316           <td>{$forms.reportForm.group_by2.control}</td>
 317           <td>{$forms.reportForm.group_by3.control}</td>
 318         </tr>
 319         <tr>
 320             <td><span id="totals_only_label"><label>{$forms.reportForm.chtotalsonly.control} {$i18n.label.totals_only}</label></span></td>
 321         </tr>
 322       </table>
 323
 324 <div style="padding: 10 0 10 0;">
 325   <table border="0" class="divider">
 326     <tr>
 327       <td align="center">
 328         <table cellspacing="1" cellpadding="3" border="0">
 329           <tr>
 330             <td>{$i18n.form.reports.save_as_favorite}:</td><td>{$forms.reportForm.new_fav_report.control}</td>
 331             <td>{$forms.reportForm.btn_save.control}</td>
 332           </tr>
 333         </table>
 334       </td>
 335     </tr>
 336   </table>
 337 </div>
 338
 339       <table border="0" cellpadding="3" width="100%">
 340         <tr><td colspan="3" height="50" align="center">{$forms.reportForm.btn_generate.control}</td></tr>
 341       </table>
 342     </td>
 343   </tr>
 344 </table>
 345 {$forms.reportForm.close}