public function index()
{
if (Auth::check()) {
$sum1 = Salary::select(DB::raw('count(distinct cid) as a'))->where('level', '=', 'พกส.(ปฏิบัติงาน)')->first();
$sum2 = Salary::select(DB::raw('count(distinct cid) as a'))->where('level', '=', 'ลูกจ้างประจำ')->first();
$sum3 = Salary::select(DB::raw('count(distinct cid) as a'))->where('level', '=', 'ข้าราชการ')->first();
$sum4 = Salary::select(DB::raw('count(distinct cid) as a'))->where('level', '=', 'ลูกจ้างชั่วคราว')->first();
return View::make('home.index', array('sum1' => $sum1, 'sum2' => $sum2, 'sum3' => $sum3, 'sum4' => $sum4));
} else {
//return login
return View::make('users.index');
}
}
/**
* Shows task editing/management form
*
* @global object $ubillingConfig
* @param int $taskid
*
* @return void
*/
function ts_TaskChangeForm($taskid)
{
global $ubillingConfig;
$altercfg = $ubillingConfig->getAlter();
$taskid = vf($taskid, 3);
$taskdata = ts_GetTaskData($taskid);
$result = '';
$allemployee = ts_GetAllEmployee();
$activeemployee = ts_GetActiveEmployee();
$alljobtypes = ts_GetAllJobtypes();
$messages = new UbillingMessageHelper();
$smsData = '';
if (!empty($taskdata)) {
//not done task
if (empty($taskdata['login'])) {
$login_detected = ts_DetectUserByAddress($taskdata['address']);
if ($login_detected) {
$addresslink = wf_Link("?module=userprofile&username="******"?module=userprofile&username="******"H:i", strtotime($taskdata['starttime'])) : '';
$smsJobNote = mysql_real_escape_string($taskdata['jobnote']);
$smsEmployee = vf($taskdata['employee']);
$newSmsText = $smsAddress . ' ' . $smsPhone . ' ' . $smsJobNote . $smsJobTime;
$smsDataCells = wf_TableCell(__('Employee'), '', 'row2');
$smsDataCells .= wf_TableCell(@$allemployee[$taskdata['employee']]);
$smsDataRows = wf_TableRow($smsDataCells, 'row3');
$smsDataCells = wf_TableCell(__('Message'), '', 'row2');
$smsDataCells .= wf_TableCell(zb_TranslitString($newSmsText));
$smsDataRows .= wf_TableRow($smsDataCells, 'row3');
$smsDataTable = wf_TableBody($smsDataRows, '100%', '0', 'glamour');
$smsInputs = $smsDataTable;
$smsInputs .= wf_HiddenInput('postsendemployee', $smsEmployee);
$smsInputs .= wf_HiddenInput('postsendsmstext', $newSmsText);
$smsInputs .= wf_Submit(__('Send SMS'));
$smsForm = wf_Form('', 'POST', $smsInputs, '');
$smsData = wf_modal(wf_img_sized('skins/icon_mobile.gif', __('Send SMS'), '10'), __('Send SMS'), $smsForm, '', '400', '200');
}
}
$tablecells = wf_TableCell(__('ID'), '30%');
$tablecells .= wf_TableCell($taskdata['id']);
$tablerows = wf_TableRow($tablecells, 'row3');
$tablecells = wf_TableCell(__('Task creation date') . ' / ' . __('Administrator'));
$tablecells .= wf_TableCell($taskdata['date'] . ' / ' . $taskdata['admin']);
$tablerows .= wf_TableRow($tablecells, 'row3');
$tablecells = wf_TableCell(__('Target date'));
$tablecells .= wf_TableCell(wf_tag('strong') . $taskdata['startdate'] . ' ' . $taskdata['starttime'] . wf_tag('strong', true));
$tablerows .= wf_TableRow($tablecells, 'row3');
$tablecells = wf_TableCell(__('Task address'));
$tablecells .= wf_TableCell($addresslink);
$tablerows .= wf_TableRow($tablecells, 'row3');
$tablecells = wf_TableCell(__('Login'));
$tablecells .= wf_TableCell($taskLogin . $loginType);
$tablerows .= wf_TableRow($tablecells, 'row3');
$tablecells = wf_TableCell(__('Phone'));
$tablecells .= wf_TableCell($taskdata['phone']);
$tablerows .= wf_TableRow($tablecells, 'row3');
$tablecells = wf_TableCell(__('Job type'));
$tablecells .= wf_TableCell(@$alljobtypes[$taskdata['jobtype']]);
$tablerows .= wf_TableRow($tablecells, 'row3');
$tablecells = wf_TableCell(__('Who should do'));
$tablecells .= wf_TableCell(@$allemployee[$taskdata['employee']] . ' ' . $smsData);
$tablerows .= wf_TableRow($tablecells, 'row3');
$tablecells = wf_TableCell(__('Job note'));
$tablecells .= wf_TableCell(nl2br($taskdata['jobnote']));
$tablerows .= wf_TableRow($tablecells, 'row3');
$result .= wf_TableBody($tablerows, '100%', '0', 'glamour');
$result .= wf_tag('div', false, '', 'style="clear:both;"') . wf_tag('div', true);
// show task preview
show_window(__('View task') . ' ' . $modform, $result);
//Salary accounting
if ($altercfg['SALARY_ENABLED']) {
if (cfr('SALARYTASKSVIEW')) {
$salary = new Salary();
show_window(__('Additional jobs done'), $salary->taskJobCreateForm($_GET['edittask']));
}
}
//warehouse integration
if ($altercfg['WAREHOUSE_ENABLED']) {
if (cfr('WAREHOUSE')) {
$warehouse = new Warehouse();
show_window(__('Additionally spent materials'), $warehouse->taskMaterialsReport($_GET['edittask']));
}
}
//if task undone
if ($taskdata['status'] == 0) {
$sup = wf_tag('sup') . '*' . wf_tag('sup', false);
$inputs = wf_HiddenInput('changetask', $taskid);
$inputs .= wf_DatePicker('editenddate') . wf_tag('label', false) . __('Finish date') . $sup . wf_tag('label', true) . wf_tag('br');
$inputs .= wf_tag('br');
$inputs .= wf_Selector('editemployeedone', $activeemployee, __('Worker done'), $taskdata['employee'], true);
$inputs .= wf_tag('br');
$inputs .= wf_tag('label', false) . __('Finish note') . wf_tag('label', true) . wf_tag('br');
$inputs .= wf_TextArea('editdonenote', '', '', true, '35x3');
$inputs .= wf_tag('br');
$inputs .= $jobgencheckbox;
$inputs .= wf_Submit(__('This task is done'));
$form = wf_Form("", 'POST', $inputs, 'glamour');
if (cfr('TASKMANDELETE')) {
show_window('', wf_JSAlertStyled('?module=taskman&deletetask=' . $taskid, web_delete_icon() . ' ' . __('Remove this task - it is an mistake'), $messages->getDeleteAlert(), 'ubButton'));
}
//show editing form
if (cfr('TASKMANDONE')) {
show_window(__('If task is done'), $form);
}
} else {
$donecells = wf_TableCell(__('Finish date'), '30%');
$donecells .= wf_TableCell($taskdata['enddate']);
$donerows = wf_TableRow($donecells, 'row3');
$donecells = wf_TableCell(__('Worker done'));
$donecells .= wf_TableCell($allemployee[$taskdata['employeedone']]);
$donerows .= wf_TableRow($donecells, 'row3');
$donecells = wf_TableCell(__('Finish note'));
$donecells .= wf_TableCell($taskdata['donenote']);
$donerows .= wf_TableRow($donecells, 'row3');
$doneresult = wf_TableBody($donerows, '100%', '0', 'glamour');
if (cfr('TASKMANDELETE')) {
$doneresult .= wf_JSAlertStyled('?module=taskman&deletetask=' . $taskid, web_delete_icon() . ' ' . __('Remove this task - it is an mistake'), $messages->getDeleteAlert(), 'ubButton');
}
if (cfr('TASKMANDONE')) {
$doneresult .= ' ';
$doneresult .= wf_JSAlertStyled('?module=taskman&setundone=' . $taskid, wf_img('skins/icon_key.gif') . ' ' . __('No work was done'), $messages->getEditAlert(), 'ubButton');
}
show_window(__('Task is done'), $doneresult);
}
}
}
<?php
if (cfr('SALARYTSHEETS')) {
$altcfg = $ubillingConfig->getAlter();
if ($altcfg['SALARY_ENABLED']) {
$greed = new Avarice();
$beggar = $greed->runtime('SALARY');
if (!empty($beggar)) {
$salary = new Salary();
//creating of new timesheet
if (wf_CheckPost(array('newtimesheet', 'newtimesheetdate', '_employeehours'))) {
$tsSheetCreateResult = $salary->timesheetCreate();
if ($tsSheetCreateResult == 0) {
//succeful creation
rcms_redirect('?module=salary_timesheets');
} else {
if ($tsSheetCreateResult == 1) {
//date duplicate
show_error(__('Timesheets with that date already exist'));
}
}
}
$tsCf = $salary->timesheetCreateForm();
if ($tsCf) {
$timesheetsControls = wf_modal(web_add_icon() . ' ' . __('Create'), __('Create') . ' ' . __('Timesheet'), $tsCf, 'ubButton', '800', '600');
show_window('', $timesheetsControls);
if (!wf_CheckGet(array('showdate'))) {
//render available timesheets list by date
show_window(__('Timesheets'), $salary->timesheetsListRender('?module=salary_timesheets'));
} else {
//saving changes for single timesheet row
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer $id the ID of the model to be loaded
* @return Salary the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = Salary::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
//flushing dark void
$darkVoid = new DarkVoid();
$darkVoid->flushCache();
rcms_redirect('?module=taskman&edittask=' . $_GET['edittask']);
}
}
//sms data flush
if (wf_CheckGet(array('flushsmsdata'))) {
ts_FlushSMSData($_GET['flushsmsdata']);
rcms_redirect('?module=taskman&edittask=' . $_GET['flushsmsdata']);
}
/**
* Salary accounting actions
*/
if ($altCfg['SALARY_ENABLED']) {
$salary = new Salary();
//salary job deletion
if (wf_CheckGet(array('deletejobid'))) {
$salary->deleteJob($_GET['deletejobid']);
rcms_redirect($salary::URL_TS . $_GET['edittask']);
}
//salary job editing
if (wf_CheckPost(array('editsalaryjobid', 'editsalaryemployeeid', 'editsalaryjobtypeid'))) {
$salary->jobEdit($_POST['editsalaryjobid'], $_POST['editsalaryemployeeid'], $_POST['editsalaryjobtypeid'], $_POST['editsalaryfactor'], $_POST['editsalaryoverprice'], $_POST['editsalarynotes']);
rcms_redirect($salary::URL_TS . $_GET['edittask']);
}
//salary job creation
if (wf_CheckPost(array('newsalarytaskid', 'newsalaryemployeeid', 'newsalaryjobtypeid'))) {
$salary->createSalaryJob($_POST['newsalarytaskid'], $_POST['newsalaryemployeeid'], $_POST['newsalaryjobtypeid'], $_POST['newsalaryfactor'], $_POST['newsalaryoverprice'], $_POST['newsalarynotes']);
rcms_redirect($salary::URL_TS . $_GET['edittask']);
}
public function actionSalary($employer_id, $salary_date)
{
$model = Salary::model()->findByPk(array('employer_id' => $employer_id, 'salary_date' => $salary_date));
$this->renderPartial('salary', array('model' => $model));
}
function delete($id)
{
$salary = new Salary();
$salary->_delete($id);
$this->session->set_flashdata('message', 'Salary successfully deleted!');
redirect('salaries/');
}
