inc/work-form.php

   1 <?php
   2 function nice_time( $in_time ) {
   3   /* does nothing yet... */
   4   return substr("$in_time", 2);
   5 }
   6   if ( "$because" != "" )
   7     echo $because;
   8 ?>
   9
  10 <?php
  11   if ( "$search_for$system_id " != "" ) {
  12     if ( !isset($maxresults) || intval($maxresults) == 0 ) $maxresults = 200;
  13     $query = "SELECT request.*, organisation.*, request_timesheet.*, ";
  14     $query .= " worker.fullname AS worker_name, requester.fullname AS requester_name, ";
  15     $query .= " last_status_on(request.request_id) AS status_on, last_status AS status, get_status_desc(last_status) AS status_desc ";
  16     $query .= " FROM request ";
  17     if ( ! is_member_of('Admin', 'Support') ) {
  18       $query .= "JOIN work_system USING (system_id) ";
  19       $query .= "JOIN system_usr ON (work_system.system_id = system_usr.system_id AND system_usr.user_no = $session->user_no) ";
  20     }
  21     $query .= ", usr AS worker, usr AS requester, organisation, request_timesheet ";
  22     $query .= " WHERE request_timesheet.request_id = request.request_id";
  23     $query .= " AND worker.user_no = work_by_id ";
  24     $query .= " AND requester.user_no = requester_id ";
  25     $query .= " AND organisation.org_code = requester.org_code ";
  26
  27     if ( "$user_no" <> "" ) {
  28       $query .= " AND work_by_id=".intval($user_no);
  29     }
  30
  31     if ( "$search_for" <> "" ) {
  32       $query .= " AND work_description ~* '$search_for' ";
  33     }
  34     if ( "$system_id" <> "" ) {
  35       $query .= " AND request.system_id=".intval($system_id);
  36     }
  37     if ( "$org_code" <> "" ) {
  38       $query .= " AND requester.org_code=".intval($org_code);
  39     }
  40
  41     if ( "$after" != "" )
  42       $query .= " AND request_timesheet.work_on>'$after' ";
  43     if ( "$before" != "" )
  44       $query .= " AND request_timesheet.work_on<'$before' ";
  45
  46     if( isset ($filter) && is_array($filter) ) {
  47       while( list( $k, $v ) = each ( $filter ) ) {
  48         if ($v != "") { $query .= " AND $k = $v "; }
  49       }
  50     }
  51
  52     if( "$order_by" == "" && isset ($sort) && is_array($sort) ) {
  53       while( list( $k, $v ) = each ( $sort ) ) {
  54         $order_by = " ORDER BY $k";
  55       }
  56     }
  57
  58     $query .= " $order_by ";
  59     $query .= " LIMIT $maxresults ";
  60
  61     $result = awm_pgexec( $dbconn, $query );
  62     if ( ! $result ) {
  63       $error_loc = "work-form.php";
  64       $error_qry = "$query";
  65       include("error.php");
  66     }
  67     else {
  68       echo "<FORM METHOD=POST ACTION=\"$REQUEST_URI\">\n";
  69       echo "<table border=0 align=center>\n";
  70
  71       // Build table of organisations found
  72       for ( $i=0; $i < pg_NumRows($result); $i++ ) {
  73         $timesheet = pg_Fetch_Object( $result, $i );
  74
  75         if ( ($i % 2) == 0 ) echo "<tr class=bgcolor0>";
  76         else echo "<tr class=bgcolor1>";
  77
  78         echo "<td class=sml valign=top>$timesheet->requester_name</td>\n";
  79         echo "<td class=sml valign=top>$timesheet->abbreviation</td>\n";
  80         echo "<td class=sml valign=top>$timesheet->debtor_no</td>\n";
  81         echo "<td class=sml valign=top><a href=\"/wr.php?request_id=$timesheet->request_id\">$timesheet->request_id</a></td>\n";
  82
  83         echo "<td class=sml valign=top>" ;
  84         echo "$timesheet->status_desc";
  85         echo  "</td>\n";
  86
  87         echo "<td class=sml valign=top>" ;
  88         echo "$timesheet->status_on";
  89         echo  "</td>\n";
  90
  91         echo "<td class=sml valign=top>$timesheet->brief</td>\n";
  92         echo "<td class=sml valign=top>" . html_format( $timesheet->work_description) . "</td>\n";
  93         echo "<td class=sml valign=top>$timesheet->worker_name</td>\n";
  94         echo "<td class=sml valign=top nowrap>" . substr( nice_date($timesheet->work_on), 7) . "</td>\n";
  95         echo "<td class=sml valign=top>$timesheet->work_quantity $timesheet->work_units</td>\n";
  96         echo "<td class=sml valign=top align=right nowrap>$timesheet->work_rate</td>\n";
  97         echo "<td class=sml valign=top align=right nowrap>";
  98         if ( "$timesheet->work_charged" == "" ) {
  99           echo "<input type=text size=6 name=\"chg_amt[$timesheet->timesheet_id]\" value=\"" ;
 100           if ( "$timesheet->charged_amount" == "" ) echo $timesheet->work_rate*$timesheet->work_quantity;
 101           else echo $timesheet->charged_amount ;
 102           echo "\">";
 103         }
 104         else echo "$timesheet->charged_amount";
 105         echo "</td>\n";
 106         echo "<td class=sml valign=top>";
 107         if ( "$timesheet->work_charged" == "" ) {
 108           echo "<input type=checkbox value=1 name=\"chg_ok[$timesheet->timesheet_id]\"";
 109           if ( "$timesheet->ok_to_charge" == "t" ) echo " checked";
 110           echo ">";
 111         }
 112         echo "</td>\n";
 113
 114         echo "<td class=sml valign=top>";
 115         if ( "$timesheet->work_charged" == "" && "$timesheet->ok_to_charge" == "t" ) {
 116           echo "<input name=\"chg_on[$timesheet->timesheet_id]\" type=text size=10 value=\"" . date("d/m/Y") . "\">";
 117         }
 118         else echo substr( nice_date($timesheet->work_charged), 7) ;
 119         echo "</td>\n";
 120
 121         echo "<td class=sml valign=top>";
 122         if ( "$timesheet->work_charged" == "" && "$timesheet->ok_to_charge" == "t" ) {
 123           echo "<input name=\"chg_inv[$timesheet->timesheet_id]\" type=text size=6 >";
 124         }
 125         else echo $timesheet->charged_details ;
 126         echo "</td>\n";
 127
 128         echo "</tr>\n";
 129       }
 130       if ( "$uncharged" != "" ) {
 131         echo "<tr><td class=mand colspan=6 align=center><input type=submit alt=\"apply changes\" name=submit value=\"Apply Charges\"></td></tr>\n";
 132         echo "</form>\n";
 133       }
 134
 135
 136       echo "<form method=post action=\"$REQUEST_URI\" name=\"options\">\n";
 137       echo   "<thead>";
 138       echo     "<tr>";
 139       echo       "<th class=cols>Requested by";
 140       echo         '<select class=sml name="filter[request.requester_id]">' . "\n";
 141       echo           "<option class=sml value=''>All</option>\n";
 142       $select_query = "SELECT user_no, fullname FROM usr ";
 143       if ( ! is_member_of('Admin', 'Support') ) {
 144         $select_query .= "WHERE usr.org_code = $session->org_code";
 145       }
 146       $select_query .= "ORDER BY fullname";
 147       $select_result = awm_pgexec( $dbconn, $select_query );
 148       for ( $i=0; $i < pg_NumRows($select_result); $i++ ) {
 149         $select_option = pg_Fetch_Object( $select_result, $i );
 150         echo "<option class=sml value='$select_option->user_no'";
 151         if ( $select_option->user_no == $filter["request.requester_id"] ) {
 152           echo ' selected';
 153         }
 154         echo ">$select_option->fullname</option>\n";
 155       }
 156       echo         "</select>\n";
 157       echo       "</th>\n";
 158
 159       echo       "<th class=cols>Org.";
 160       echo         '<select class=sml name="filter[organisation.org_code]">' . "\n";
 161       echo           "<option class=sml value=''>All</option>\n";
 162       $select_query = "SELECT org_code, abbreviation FROM organisation ";
 163       if ( ! is_member_of('Admin', 'Support') ) {
 164         $select_query .= "WHERE organisation.org_code = $session->org_code";
 165       }
 166       $select_query .= "ORDER BY abbreviation";
 167       $select_result = awm_pgexec( $dbconn, $select_query );
 168       for ( $i=0; $i < pg_NumRows($select_result); $i++ ) {
 169         $select_option = pg_Fetch_Object( $select_result, $i );
 170         echo "<option class=sml value='$select_option->org_code'";
 171         if ( $select_option->org_code == $filter["organisation.org_code"] ) {
 172           echo ' selected';
 173         }
 174         echo ">$select_option->abbreviation</option>\n";
 175       }
 176       echo         "</select>\n";
 177       echo       "</th>\n";
 178
 179       echo       '<th class=cols>Dbtr. No.';
 180       echo         '<input type="Image" src="$theme->images/down.gif" title="Sort" border="0" name="sort[organisation.org_code]" >';
 181       echo       "</th>\n";
 182
 183       echo       '<th class=cols>WR No.<input TYPE="Image" src="/'.$theme->images.'/down.gif" alt="Sort" BORDER="0" name="sort[request_timesheet.request_id]" ></th>' . "\n";
 184
 185       echo       "<th class=cols>WR Status";
 186       echo         '<select class=sml name="filter[request.last_status]">' . "\n";
 187       echo           "<option class=sml value=''>All</option>\n";
 188       $select_query = "SELECT lookup_code, lookup_desc FROM lookup_code";
 189       $select_query .= " WHERE lookup_code.source_table = 'request' ";
 190       $select_query .= " AND lookup_code.source_field = 'status_code' ";
 191       $select_query .= " ORDER BY lookup_code.lookup_desc";
 192       $select_result = awm_pgexec( $dbconn, $select_query );
 193       for ( $i=0; $i < pg_NumRows($select_result); $i++ ) {
 194         $select_option = pg_Fetch_Object( $select_result, $i );
 195         echo "<option class=sml value=\"'$select_option->lookup_code'\"";
 196         if ( "'" . $select_option->lookup_code . "'" == $filter["request.last_status"] ) {
 197           echo ' selected';
 198         }
 199         echo ">$select_option->lookup_desc</option>\n";
 200       }
 201       echo         "</select>\n";
 202       echo       "</th>\n";
 203
 204       echo       "<th class=cols>Status On</th>\n";
 205       echo       "<th class=cols>WR Brief</th>\n";
 206       echo       '<th class=cols>';
 207       echo         '<table cellpadding=2 cellspacing=0 border=0>';
 208       echo           '<tr>';
 209       echo             '<td></td>';
 210       echo             '<td align="middle"><input TYPE="Image" src="/'.$theme->images.'/up.gif" alt="Sort Ascending" BORDER="0" name="sort_asc[request_timesheet.work_description]" ></td>';
 211       echo           '</tr>';
 212       echo           '<tr>';
 213       echo             '<td><input TYPE="Image" src="/$theme->images/hide.gif" alt="Hide Work Description" BORDER="0" name="hide[request_timesheet.work_description]" ></td>';
 214       echo             '<td>Work Description</td>';
 215       echo           '</tr>';
 216       echo           '<tr>';
 217       echo             '<td></td>';
 218       echo             '<td align="middle"><input TYPE="Image" src="/'.$theme->images.'/down.gif" alt="Sort Descending" BORDER="0" name="sort[request_timesheet.work_description]" ></td>';
 219       echo           '</tr>';
 220       echo         '</table>';
 221       echo       "</th>\n";
 222       echo       "<th class=cols>Done By</th>\n";
 223
 224       echo       '<th class=cols nowrap>Done on<br>';
 225       echo         '<input type="text" name="done_on_from_date" size=10 maxlength=10 class=sml >';
 226       echo         '<a href="javascript:show_calendar(\'options.done_on_from_date\');"';
 227       echo           ' onmouseover="window.status=\'Date Picker\';return true;"';
 228       echo           ' onmouseout="window.status=\'\';return true;">';
 229       echo           '<img valign="middle" src="/'.$theme->images.'/date-picker.gif" border=0>';
 230       echo         '</a><br>';
 231       echo         '<input type="text" name="done_on_to_date" size=10 maxlength=10 class=sml >';
 232       echo         '<a href="javascript:show_calendar(\'options.done_on_to_date\');"';
 233       echo           ' onmouseover="window.status=\'Date Picker\';return true;"';
 234       echo           ' onmouseout="window.status=\'\';return true;">';
 235       echo           '<img valign="middle" src="/'.$theme->images.'/date-picker.gif" border=0>';
 236       echo         '</a>';
 237       echo       "</th>\n";
 238       echo       "<th class=cols>Qty.</th>\n";
 239       echo       "<th class=cols>Rate</th>\n";
 240       echo       "<th class=cols>Charge Amount</th>\n";
 241       echo       "<th class=cols>Ok to Charge</th>\n";
 242       echo       "<th class=cols>Charged On</th>\n";
 243       echo       "<th class=cols>Invoice No.</th>\n";
 244       echo     "</tr>\n";
 245       echo   "</thead>\n";
 246
 247       echo "</form>\n";
 248
 249       echo "</table>\n";
 250     }
 251   }
 252 ?>
 253 </TABLE>
 254 </FORM>
 255