function ts_EmployeeMonthGraphs() { $curmonth = curmonth(); $employees = ts_GetAllEmployee(); $month_jobs_q = "SELECT `workerid`,`jobid` from `jobs` WHERE `date` LIKE '" . $curmonth . "%'"; $alljobs = simple_queryall($month_jobs_q); $jobtypes = ts_GetAllJobtypes(); $jobdata = array(); $result = ''; if (!empty($employees)) { if (!empty($alljobs)) { foreach ($alljobs as $io => $eachjob) { if (isset($jobdata[$eachjob['workerid']][$eachjob['jobid']])) { $jobdata[$eachjob['workerid']][$eachjob['jobid']]++; } else { $jobdata[$eachjob['workerid']][$eachjob['jobid']] = 1; } } } //build graphs for each employee if (!empty($jobdata)) { foreach ($jobdata as $employee => $each) { $employeeName = isset($employees[$employee]) ? $employees[$employee] : __('Deleted'); $result .= wf_tag('h3', false) . $employeeName . wf_tag('h3', true); $rows = ''; if (!empty($each)) { foreach ($each as $jobid => $count) { $cells = wf_TableCell(@$jobtypes[$jobid], '40%'); $cells .= wf_TableCell($count, '20%'); $cells .= wf_TableCell(web_bar($count, sizeof($alljobs)), '40%'); $rows .= wf_TableRow($cells, 'row3'); } } $result .= wf_TableBody($rows, '100%', 0); $result .= wf_delimiter(); } } } return $result; }
/** * Returns list of expired undone tasks * * @return string */ function ts_ShowLate() { $allemployee = ts_GetAllEmployee(); $alljobtypes = ts_GetAllJobtypes(); $curyear = curyear(); $curmonth = date("m"); $curdate = curdate(); if ($curmonth != 1 and $curmonth != 12) { $query = "SELECT * from `taskman` WHERE `status`='0' AND `startdate` LIKE '" . $curyear . "-%' AND `startdate`< '" . $curdate . "' ORDER BY `startdate` ASC"; } else { $query = "SELECT * from `taskman` WHERE `status`='0' AND `startdate`< '" . $curdate . "' ORDER BY `startdate` ASC"; } $cells = wf_TableCell(__('Target date')); $cells .= wf_TableCell(__('Task address')); $cells .= wf_TableCell(__('Phone')); $cells .= wf_TableCell(__('Job type')); $cells .= wf_TableCell(__('Who should do')); $cells .= wf_TableCell(__('Actions')); $rows = wf_TableRow($cells, 'row1'); $all = simple_queryall($query); if (!empty($all)) { foreach ($all as $io => $each) { $cells = wf_TableCell($each['startdate']); $cells .= wf_TableCell($each['address']); $cells .= wf_TableCell($each['phone']); $cells .= wf_TableCell(@$alljobtypes[$each['jobtype']]); $cells .= wf_TableCell(@$allemployee[$each['employee']]); $actions = wf_Link('?module=taskman&edittask=' . $each['id'], web_edit_icon(), false, ''); $cells .= wf_TableCell($actions); $rows .= wf_TableRow($cells, 'row3'); } } $result = wf_TableBody($rows, '100%', '0', 'sortable'); return $result; }
/** * Loads available jobtypes from database * * @return void */ protected function loadJobtypes() { $this->allJobtypes = ts_GetAllJobtypes(); }
/** * Returns ajax selector reply for outcoming operation creation form * * @param string $destMark * @return string */ public function outcomindAjaxDestSelector($destMark) { $result = ''; $destMark = vf($destMark); $result .= wf_HiddenInput('newoutdesttype', $destMark); switch ($destMark) { case 'task': $tasksTmp = array(); $allJobTypes = ts_GetAllJobtypes(); $allUndoneTasks = ts_GetUndoneTasksArray(); if (!empty($allUndoneTasks)) { foreach ($allUndoneTasks as $io => $each) { $tasksTmp[$io] = $each['address'] . ' - ' . $allJobTypes[$each['jobtype']]; } } $result .= wf_Selector('newoutdestparam', $tasksTmp, __('Undone tasks'), '', false); break; case 'contractor': $result .= wf_Selector('newoutdestparam', $this->allContractors, __('Contractor'), '', false); break; case 'employee': $result .= wf_Selector('newoutdestparam', $this->activeEmployee, __('Worker'), '', false); break; case 'storage': $result .= wf_Selector('newoutdestparam', $this->allStorages, __('Warehouse storage'), '', false); break; case 'user': $allUsers = zb_UserGetAllIPs(); if (!empty($allUsers)) { $allUsers = array_flip($allUsers); } $result .= wf_AutocompleteTextInput('newoutdestparam', $allUsers, __('Login'), '', false); break; case 'sale': $result .= wf_HiddenInput('newoutdestparam', 'true'); break; case 'cancellation': $result .= wf_HiddenInput('newoutdestparam', 'true'); break; case 'mistake': $result .= wf_HiddenInput('newoutdestparam', 'true'); break; default: $result = __('Strange exeption'); break; } return $result; }