/**
* 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']);
}
