/** * Creates new task in database * * @param string $startdate * @param string $starttime * @param string $address * @param string $login * @param string $phone * @param int $jobtypeid * @param int $employeeid * @param string $jobnote * * @return void */ function ts_CreateTask($startdate, $starttime, $address, $login, $phone, $jobtypeid, $employeeid, $jobnote) { $altercfg = rcms_parse_ini_file(CONFIG_PATH . "alter.ini"); $curdate = curdatetime(); $admin = whoami(); $address = str_replace('\'', '`', $address); $address = mysql_real_escape_string($address); $login = mysql_real_escape_string($login); $phone = mysql_real_escape_string($phone); $startdate = mysql_real_escape_string($startdate); $jobSendTime = !empty($starttime) ? ' ' . date("H:i", strtotime($starttime)) : ''; if (!empty($starttime)) { $starttime = "'" . mysql_real_escape_string($starttime) . "'"; } else { $starttime = 'NULL'; } $jobtypeid = vf($jobtypeid, 3); $employeeid = vf($employeeid, 3); $jobnote = mysql_real_escape_string($jobnote); $smsData = 'NULL'; //store sms for backround processing via watchdog if ($altercfg['WATCHDOG_ENABLED']) { if (isset($_POST['newtasksendsms'])) { $newSmsText = $address . ' ' . $phone . ' ' . $jobnote . $jobSendTime; $smsDataRaw = ts_SendSMS($employeeid, $newSmsText); if (!empty($smsDataRaw)) { $smsData = serialize($smsDataRaw); $smsData = "'" . base64_encode($smsData) . "'"; } } } $query = "INSERT INTO `taskman` (`id` , `date` , `address` , `login` , `jobtype` , `jobnote` , `phone` , `employee` , `employeedone` ,`donenote` , `startdate` ,`starttime`, `enddate` , `admin` , `status`,`smsdata`)\n VALUES (NULL , '" . $curdate . "', '" . $address . "', '" . $login . "', '" . $jobtypeid . "', '" . $jobnote . "', '" . $phone . "', '" . $employeeid . "',NULL, NULL , '" . $startdate . "'," . $starttime . ",NULL , '" . $admin . "', '0'," . $smsData . ");"; nr_query($query); //flushing darkvoid $darkVoid = new DarkVoid(); $darkVoid->flushCache(); log_register("TASKMAN CREATE `" . $address . "`"); }
show_window('', $customJobColorStyle . wf_FullCalendar($showtasks)); } else { show_window(__('Show late'), ts_ShowLate()); } } else { //printable result if (wf_CheckPost(array('printdatefrom', 'printdateto'))) { ts_PrintTasks($_POST['printdatefrom'], $_POST['printdateto']); } //show printing form show_window(__('Tasks printing'), ts_PrintDialogue()); } } else { //sms post sending if (wf_CheckPost(array('postsendemployee', 'postsendsmstext'))) { $smsDataRaw = ts_SendSMS($_POST['postsendemployee'], $_POST['postsendsmstext']); if (!empty($smsDataRaw)) { $smsDataSave = serialize($smsDataRaw); $smsDataSave = "'" . base64_encode($smsDataSave) . "'"; simple_update_field('taskman', 'smsdata', $smsDataSave, "WHERE `id`='" . $_GET['edittask'] . "'"); //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']); }