$qry="1";
// search filters
if (IsSet($this->user_id)) {
$user_id=$this->user_id;
$qry.=" AND USER_ID='".$this->user_id."'";
} else {
global $user_id;
}
global $added_to;
if ($added_to) {
$qry.=" AND TO_DAYS(ADDED)<=TO_DAYS('".toDBDate($added_to)."')";
}
global $added_from;
if ($added_from) {
$qry.=" AND TO_DAYS(ADDED)>=TO_DAYS('".toDBDate($added_from)."')";
}
// QUERY READY
global $save_qry;
if ($save_qry) {
$qry=$session->data['userlog_qry'];
} else {
$session->data['userlog_qry']=$qry;
}
if (!$qry) $qry="1";
// FIELDS ORDER
global $sortby;
$rec['TITLE'] = $title;
if ($rec['TITLE'] == '') {
$out['ERR_TITLE'] = 1;
$ok = 0;
}
//updating 'NOTES' (text)
global $notes;
$rec['NOTES'] = $notes;
//updating 'DUE' (date)
global $due;
$rec['DUE'] = toDBDate($due);
//updating 'ADDED' (datetime)
global $added_date;
global $added_minutes;
global $added_hours;
$rec['ADDED'] = toDBDate($added_date) . " {$added_hours}:{$added_minutes}:00";
//updating 'IS_TASK' (int)
global $is_task;
$rec['IS_TASK'] = (int) $is_task;
//updating 'IS_NODATE' (int)
global $is_nodate;
$rec['IS_NODATE'] = (int) $is_nodate;
//updating 'IS_REPEATING' (int)
global $is_repeating;
$rec['IS_REPEATING'] = (int) $is_repeating;
//updating 'REPEAT_TYPE' (select)
global $repeat_type;
$rec['REPEAT_TYPE'] = $repeat_type;
//updating 'WEEK_DAYS' (varchar)
global $week_days;
$rec['WEEK_DAYS'] = $week_days;
global $title;
$rec['TITLE'] = $title;
if ($rec['TITLE'] == '') {
$out['ERR_TITLE'] = 1;
$ok = 0;
}
//updating 'Category' (select)
if (isset($this->category_id)) {
$rec['CATEGORY_ID'] = $this->category_id;
} else {
global $category_id;
$rec['CATEGORY_ID'] = $category_id;
}
//updating 'EXPIRE_DATE' (date)
global $expire_date;
$rec['EXPIRE_DATE'] = toDBDate($expire_date);
//updating 'EXPIRE_DEFAULT' (int)
global $expire_default;
$rec['EXPIRE_DEFAULT'] = (int) $expire_default;
//updating 'UPDATED' (datetime)
/*
global $updated_date;
global $updated_minutes;
global $updated_hours;
$rec['UPDATED']=toDBDate($updated_date)." $updated_hours:$updated_minutes:00";
*/
//updating 'QTY' (int)
global $qty;
$rec['QTY'] = (int) $qty;
//updating 'MIN_QTY' (int)
global $min_qty;
$rec['TITLE']=$title;
if ($rec['TITLE']=='') {
$out['ERR_TITLE']=1;
$ok=0;
}
//updating 'NOTES' (text)
global $notes;
$rec['NOTES']=$notes;
//updating 'DUE' (date)
global $due;
$rec['DUE']=toDBDate($due);
//updating 'ADDED' (datetime)
global $added_date;
global $added_minutes;
global $added_hours;
$rec['ADDED']=toDBDate($added_date)." $added_hours:$added_minutes:00";
//updating 'IS_TASK' (int)
global $is_task;
$rec['IS_TASK']=(int)$is_task;
//updating 'IS_NODATE' (int)
global $is_nodate;
$rec['IS_NODATE']=(int)$is_nodate;
//updating 'IS_REPEATING' (int)
global $is_repeating;
$rec['IS_REPEATING']=(int)$is_repeating;
//updating 'REPEAT_TYPE' (select)
global $repeat_type;
$rec['REPEAT_TYPE']=$repeat_type;
//updating 'WEEK_DAYS' (varchar)
global $week_days;
$rec['WEEK_DAYS']=$week_days;
global $system_name;
$rec['SYSTEM_NAME'] = $system_name;
//updating 'CODE_TYPE' (int)
global $code_type;
$rec['CODE_TYPE'] = (int) $code_type;
//updating 'CODE' (text)
global $code;
$rec['CODE'] = $code;
//updating 'XML' (varchar)
global $xml;
$rec['XML'] = $xml;
//updating 'UPDATED' (datetime)
global $updated_date;
global $updated_minutes;
global $updated_hours;
$rec['UPDATED'] = toDBDate($updated_date) . " {$updated_hours}:{$updated_minutes}:00";
//UPDATING RECORD
if ($ok) {
if ($rec['ID']) {
SQLUpdate($table_name, $rec);
// update
} else {
$new_rec = 1;
$rec['ID'] = SQLInsert($table_name, $rec);
// adding new record
}
$out['OK'] = 1;
} else {
$out['ERR'] = 1;
}
}
$rec['SCRIPT_ID']=$this->script_id;
} else {
global $script_id;
$rec['SCRIPT_ID']=$script_id;
}
//updating 'CODE' (text)
global $code;
$rec['CODE']=$code;
//updating 'LOG' (text)
global $log;
$rec['LOG']=$log;
//updating 'EXECUTED' (datetime)
global $executed_date;
global $executed_minutes;
global $executed_hours;
$rec['EXECUTED']=toDBDate($executed_date)." $executed_hours:$executed_minutes:00";
//UPDATING RECORD
if ($ok) {
if ($rec['ID']) {
SQLUpdate($table_name, $rec); // update
} else {
$new_rec=1;
$rec['ID']=SQLInsert($table_name, $rec); // adding new record
}
$out['OK']=1;
} else {
$out['ERR']=1;
}
}
//options for 'LOCATION_ID' (select)
$tmp=SQLSelect("SELECT ID, TITLE FROM gpslocations ORDER BY TITLE");
$rec['SCRIPT_ID'] = $this->script_id;
} else {
global $script_id;
$rec['SCRIPT_ID'] = $script_id;
}
//updating 'CODE' (text)
global $code;
$rec['CODE'] = $code;
//updating 'LOG' (text)
global $log;
$rec['LOG'] = $log;
//updating 'EXECUTED' (datetime)
global $executed_date;
global $executed_minutes;
global $executed_hours;
$rec['EXECUTED'] = toDBDate($executed_date) . " {$executed_hours}:{$executed_minutes}:00";
//UPDATING RECORD
if ($ok) {
if ($rec['ID']) {
SQLUpdate($table_name, $rec);
// update
} else {
$new_rec = 1;
$rec['ID'] = SQLInsert($table_name, $rec);
// adding new record
}
$out['OK'] = 1;
} else {
$out['ERR'] = 1;
}
}
//updating 'WINDOW' (varchar)
global $window;
$rec['WINDOW']=$window;
//updating 'DETAILS' (text)
global $details;
$rec['DETAILS']=$details;
//updating 'ADDED' (datetime)
global $added_date;
global $added_minutes;
global $added_hours;
$rec['ADDED']=toDBDate($added_date)." $added_hours:$added_minutes:00";
//updating 'EXPIRE' (datetime)
global $expire_date;
global $expire_minutes;
global $expire_hours;
$rec['EXPIRE']=toDBDate($expire_date)." $expire_hours:$expire_minutes:00";
//updating 'PROCESSED' (int)
global $processed;
$rec['PROCESSED']=(int)$processed;
//UPDATING RECORD
if ($ok) {
if ($rec['ID']) {
SQLUpdate($table_name, $rec); // update
} else {
$new_rec=1;
$rec['ID']=SQLInsert($table_name, $rec); // adding new record
}
$out['OK']=1;
} else {
$out['ERR']=1;
}
//updating 'WINDOW' (varchar)
global $window;
$rec['WINDOW'] = $window;
//updating 'DETAILS' (text)
global $details;
$rec['DETAILS'] = $details;
//updating 'ADDED' (datetime)
global $added_date;
global $added_minutes;
global $added_hours;
$rec['ADDED'] = toDBDate($added_date) . " {$added_hours}:{$added_minutes}:00";
//updating 'EXPIRE' (datetime)
global $expire_date;
global $expire_minutes;
global $expire_hours;
$rec['EXPIRE'] = toDBDate($expire_date) . " {$expire_hours}:{$expire_minutes}:00";
//updating 'PROCESSED' (int)
global $processed;
$rec['PROCESSED'] = (int) $processed;
//UPDATING RECORD
if ($ok) {
if ($rec['ID']) {
SQLUpdate($table_name, $rec);
// update
} else {
$new_rec = 1;
$rec['ID'] = SQLInsert($table_name, $rec);
// adding new record
}
$out['OK'] = 1;
} else {
