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 dropdown.
 138 function handleCheckboxes() {
 139   var totalsOnlyCheckbox = document.getElementById("chtotalsonly");
 140   var totalsOnlyLabel = document.getElementById("totals_only_label");
 141   if ("no_grouping" == document.getElementById("group_by1").value
 142       && "no_grouping" == document.getElementById("group_by2").value
 143       && "no_grouping" == document.getElementById("group_by3").value) {
 144     // Unmark and hide the "Totals only" checkbox.
 145     totalsOnlyCheckbox.checked = false;
 146     totalsOnlyCheckbox.style.visibility = "hidden";
 147     totalsOnlyLabel.style.visibility = "hidden";
 148   } else {
 149     totalsOnlyCheckbox.style.visibility = "visible";
 150     totalsOnlyLabel.style.visibility = "visible";
 151   }
 152 }
 153 </script>
 154
 155 {$forms.reportForm.open}
 156 <div style="padding: 0 0 10 0;">
 157   <table border="0" class="divider">
 158     <tr>
 159       <td>
 160         <table cellspacing="1" cellpadding="3" border="0">
 161           <tr>
 162             <td>{$i18n.label.fav_report}:</td><td>{$forms.reportForm.favorite_report.control}</td>
 163             <td>{$forms.reportForm.btn_generate.control}&nbsp;{$forms.reportForm.btn_delete.control}</td>
 164           </tr>
 165         </table>
 166       </td>
 167     </tr>
 168   </table>
 169 </div>
 170
 171 <table cellspacing="4" cellpadding="7" border="0">
 172   <tr>
 173     <td valign="top" colspan="2" align="center">
 174       <table border="0" cellpadding="3">
 175 {if (($user->isPluginEnabled('cl') && !($user->isClient() && $user->client_id)) || ($custom_fields && $custom_fields->fields[0] && $custom_fields->fields[0]['type'] == CustomFields::TYPE_DROPDOWN))}
 176         <tr>
 177   {if $user->isPluginEnabled('cl') && !($user->isClient() && $user->client_id)}<td><b>{$i18n.label.client}</b></td>{else}<td>&nbsp;</td>{/if}
 178           <td>&nbsp;</td>
 179   {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}
 180         </tr>
 181         <tr>
 182           <td>{$forms.reportForm.client.control}</td>
 183           <td>&nbsp;</td>
 184           <td>{$forms.reportForm.option.control}</td>
 185         </tr>
 186 {/if}
 187 {if ($smarty.const.MODE_PROJECTS == $user->tracking_mode || $smarty.const.MODE_PROJECTS_AND_TASKS == $user->tracking_mode)}
 188         <tr>
 189           <td><b>{$i18n.label.project}</b></td>
 190           <td>&nbsp;</td>
 191   {if ($smarty.const.MODE_PROJECTS_AND_TASKS == $user->tracking_mode)}
 192           <td><b>{$i18n.label.task}</b></td>
 193   {/if}
 194         </tr>
 195 {/if}
 196 {if ($smarty.const.MODE_PROJECTS == $user->tracking_mode || $smarty.const.MODE_PROJECTS_AND_TASKS == $user->tracking_mode)}
 197         <tr>
 198           <td>{$forms.reportForm.project.control}</td>
 199           <td>&nbsp;</td>
 200   {if ($smarty.const.MODE_PROJECTS_AND_TASKS == $user->tracking_mode)}
 201           <td>{$forms.reportForm.task.control}</td>
 202   {/if}
 203         </tr>
 204 {/if}
 205 {if $user->isPluginEnabled('iv')}
 206         <tr>
 207           <td><b>{$i18n.form.time.billable}</b></td>
 208           <td>&nbsp;</td>
 209   {if $user->can('manage_invoices')}
 210           <td><b>{$i18n.label.invoice}</b></td>
 211   {/if}
 212         </tr>
 213         <tr valign="top">
 214           <td>{$forms.reportForm.include_records.control}</td>
 215           <td>&nbsp;</td>
 216   {if $user->can('manage_invoices')}
 217           <td>{$forms.reportForm.invoice.control}</td>
 218         </tr>
 219   {/if}
 220 {/if}
 221 {if ($user->can('manage_invoices') && $user->isPluginEnabled('ps'))}
 222         <tr>
 223           <td><b>{$i18n.label.paid_status}</b></td>
 224         </tr>
 225         <tr>
 226           <td>{$forms.reportForm.paid_status.control}</td>
 227         </tr>
 228 {/if}
 229 {if $user->can('view_reports') || $user->can('view_all_reports') || $user->isClient()}
 230         <tr>
 231           <td colspan="3"><b>{$i18n.label.users}</b></td>
 232         </tr>
 233         <tr>
 234           <td colspan="3">{$forms.reportForm.users.control}</td>
 235         </tr>
 236 {/if}
 237         <tr>
 238           <td><b>{$i18n.form.reports.select_period}</b></td>
 239           <td>&nbsp;</td>
 240           <td><b>{$i18n.form.reports.set_period}</b></td>
 241         </tr>
 242         <tr valign="top">
 243           <td>{$forms.reportForm.period.control}</td>
 244           <td align="right">{$i18n.label.start_date}:</td>
 245           <td>{$forms.reportForm.start_date.control}</td>
 246         </tr>
 247         <tr>
 248           <td></td>
 249           <td align="right">{$i18n.label.end_date}:</td>
 250           <td>{$forms.reportForm.end_date.control}</td>
 251         </tr>
 252         <tr><td colspan="3"><b>{$i18n.form.reports.show_fields}</b></td></tr>
 253         <tr>
 254           <td colspan="3">
 255             <table border="0" width="100%">
 256 {if $user->can('view_reports') || $user->can('view_all_reports') || $user->isPluginEnabled('cl') || $user->isPluginEnabled('iv') || $user->isPluginEnabled('ps')}
 257               <tr>
 258   {if $user->isPluginEnabled('cl')}
 259                 <td width="25%"><label>{$forms.reportForm.chclient.control}&nbsp;{$i18n.label.client}</label></td>
 260   {/if}
 261   {if ($user->can('manage_invoices') || $user->isClient()) && $user->isPluginEnabled('iv')}
 262                 <td width="25%"><label>{$forms.reportForm.chinvoice.control}&nbsp;{$i18n.label.invoice}</label></td>
 263   {/if}
 264   {if ($user->can('manage_invoices') && $user->isPluginEnabled('ps'))}
 265                 <td width="25%"><label>{$forms.reportForm.chpaid.control}&nbsp;{$i18n.label.paid}</label></td>
 266   {/if}
 267   {if $user->can('view_reports') || $user->can('view_all_reports')}
 268                 <td width="25%"><label>{$forms.reportForm.chip.control}&nbsp;{$i18n.label.ip}</label></td>
 269   {/if}
 270               </tr>
 271 {/if}
 272               <tr>
 273                 <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>
 274                 <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>
 275                 <td width="25%"><label>{$forms.reportForm.chduration.control}&nbsp;{$i18n.label.duration}</label></td>
 276 {if ($user->can('manage_invoices') || $user->isClient()) || $user->isPluginEnabled('ex')}
 277                   <td width="25%"><label>{$forms.reportForm.chcost.control}&nbsp;{$i18n.label.cost}</label></td>
 278 {else}
 279                   <td></td>
 280 {/if}
 281               </tr>
 282               <tr>
 283                 <td>{if ($smarty.const.MODE_PROJECTS_AND_TASKS == $user->tracking_mode)}<label>{$forms.reportForm.chtask.control}&nbsp;{$i18n.label.task}</label>{/if}</td>
 284                 <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>
 285                 <td><label>{$forms.reportForm.chnote.control}&nbsp;{$i18n.label.note}</label></td>
 286 {if ($custom_fields && $custom_fields->fields[0])}
 287                 <td><label>{$forms.reportForm.chcf_1.control}&nbsp;{$custom_fields->fields[0]['label']|escape}</label></td>
 288 {else}
 289                 <td></td>
 290 {/if}
 291               </tr>
 292 {if $user->isPluginEnabled('wu')}
 293               <tr>
 294                 <td></td>
 295                 <td></td>
 296                 <td width="25%"><label>{$forms.reportForm.chunits.control}&nbsp;{$i18n.label.work_units}</label></td>
 297                 <td></td>
 298               </tr>
 299 {/if}
 300             </table>
 301           </td>
 302         </tr>
 303         <tr>
 304             <td><b>{$i18n.form.reports.group_by}</b></td>
 305         </tr>
 306         <tr valign="top">
 307           <td>{$forms.reportForm.group_by1.control}</td>
 308           <td>{$forms.reportForm.group_by2.control}</td>
 309           <td>{$forms.reportForm.group_by3.control}</td>
 310         </tr>
 311         <tr>
 312             <td><span id="totals_only_label"><label>{$forms.reportForm.chtotalsonly.control} {$i18n.label.totals_only}</label></span></td>
 313         </tr>
 314       </table>
 315
 316 <div style="padding: 10 0 10 0;">
 317   <table border="0" class="divider">
 318     <tr>
 319       <td align="center">
 320         <table cellspacing="1" cellpadding="3" border="0">
 321           <tr>
 322             <td>{$i18n.form.reports.save_as_favorite}:</td><td>{$forms.reportForm.new_fav_report.control}</td>
 323             <td>{$forms.reportForm.btn_save.control}</td>
 324           </tr>
 325         </table>
 326       </td>
 327     </tr>
 328   </table>
 329 </div>
 330
 331       <table border="0" cellpadding="3" width="100%">
 332         <tr><td colspan="3" height="50" align="center">{$forms.reportForm.btn_generate.control}</td></tr>
 333       </table>
 334     </td>
 335   </tr>
 336 </table>
 337 {$forms.reportForm.close}