$eta = null;
$target = null;
$deadline = null;
$kickoff_date = null;
$pic = null;
$pic_name = null;
$pic_image = '';
$name = tep_db_prepare_input($_POST['name'], true);
$desc = tep_db_prepare_input($_POST['desc'], true);
$desc_tech = null;
$goal = tep_db_prepare_input($_POST['goal'], true);
$status = tep_db_prepare_input($_POST['status']);
if ($_POST['me_action'] == 'CREATENEWDATA') {
$improvement->create($name, $team, $owner_id, $owner_name, $owner_image, '', $date_added, $teamcat, '0', $pic, $pic_name, $pic_image, $desc, $goal, $eta, $deadline, $kickoff_date);
if ($status > 1) {
$improvement->updateStatus('1', $status, 'auto-set');
}
} else {
$improvement->update($owner_id, $owner_name, $owner_image, $date_added, $name, $team, null, $teamcat, $pic, $pic_name, $pic_image, $desc, $goal, $eta, $deadline, $kickoff_date, $desc_tech, $target);
}
echo utf8_encode($improvement->id);
exit;
} elseif ($_POST['me_action'] == 'UPDATEDATAPIC') {
$owner_id = null;
$owner_name = null;
$owner_image = null;
$date_added = null;
$team = null;
$pic = tep_db_prepare_input($_POST['pic']);
$pic_name = tep_db_prepare_input($_POST['pic_name']);
$teamcat = tep_db_prepare_input($_POST['teamcat']);
$class_jo = new jng_sp_orders();
$class_jo->checkAndSetCompleteOrders();
$logger->write("- SP Orders Updated");
$logger->write("Task 2 - End");
$logger->write("Task 3 (IMPROVEMENTS/MIMS) - Start");
//////////////////////////////////////////////////////////////
// 1) IMPROVEMENTS AUTO MOVE FROM TESTINGS TO CHECKINGS TAB //
// 2) IMPROVEMENTS DEADLINE REMINDER (STARTING FROM D-1) //
//////////////////////////////////////////////////////////////
$username = '******';
$today = date('Y-m-d', strtotime('tomorrow'));
use_class('improvement');
$q = tep_db_query("SELECT improvements_id FROM improvements WHERE status=4 AND check_date<='{$today}'");
while ($row = tep_db_fetch_array($q)) {
$i = new improvement($row['improvements_id']);
$i->updateStatus('4', '5', $username);
}
$logger->write("- Auto move to Checkings Tab");
//$q = tep_db_query("SELECT improvements_id, DATEDIFF(deadline, '$today') AS deadline_diff FROM improvements WHERE status<4 HAVING deadline_diff<=1");
$q = tep_db_query("SELECT improvements_id, DATEDIFF(deadline, '{$today}') AS deadline_diff FROM improvements WHERE status<4 OR status=7 HAVING deadline_diff<=1");
while ($row = tep_db_fetch_array($q)) {
$i = new improvement($row['improvements_id']);
$targets = array();
$targets[] = $i->owner_id;
if ($i->pic > 0) {
$targets[] = $i->pic;
}
$message = $obj_notifications->messageTemplateDeadlineReminder($username, 'Improvement', $i->id, $row['deadline_diff'], improvement::getTeamCategories($i->team, $i->category), $i->name);
$obj_notifications->broadcast($targets, $message, $username, 'open=improvement&id=' . $i->id, false, $targets);
}
$logger->write("- Deadline Notifications Sent");
$value = '$nbsp;';
}
$row .= '<td class="' . $class . '">' . $value . '</td>';
}
$row .= '</tr>';
$result = array();
$result['id'] = $id;
$result['row'] = $row;
ajaxReturn($result);
exit;
} elseif ($_POST['me_action'] == 'UPDATESTATUS') {
$id = tep_db_prepare_input($_POST['datas_id']);
$old_status = tep_db_prepare_input($_POST['old_status']);
$new_status = tep_db_prepare_input($_POST['new_status']);
$object = new improvement($id);
$object->updateStatus($old_status, $new_status, $session_userinfo['username']);
if ($old_status == '2' && $new_status == '3') {
$object->updatePIC($session_userinfo['id'], $session_userinfo['username']);
}
if (isset($_POST['check_date']) && $_POST['check_date'] != '') {
$object->updateCheckDate(tep_db_prepare_input($_POST['check_date']));
}
$result = array();
$result['id'] = $id;
$result['old_status'] = $old_status;
$result['new_status'] = $new_status;
$result['st_counter'] = datasCountByStatus();
ajaxReturn($result);
exit;
} elseif ($_POST['me_action'] == 'UPDATESDATE') {
$id = tep_db_prepare_input($_POST['datas_id']);
