$r = tep_db_query($q);
}
}
if ($post_content == 'DONE') {
$date = date('Y-m-d H:i:s');
$where = "drafts_id = '{$draft_id}'";
$update_content = '|' . $date . '|';
$q = "UPDATE designs_drafts SET wax_history_info = CONCAT(wax_history_info, '{$update_content}') WHERE {$where}";
$r = tep_db_query($q);
}
$ajaxResult = array();
$ajaxResult['des_id'] = $draft->designs_id;
ajaxReturn($ajaxResult);
exit;
}
objectSocialLinePostAction(array('des' => 'design', 'dra' => 'design_draft'));
}
if (isset($_GET['status']) && array_key_exists($_GET['status'], $tabs)) {
$status = tep_db_prepare_input($_GET['status']);
$sub_status = tep_db_prepare_input($_GET['sub_status']);
$order_by = 'd.target_date_start';
// 'dsh.status_time';
$q = "SELECT mu.id AS owner_id, mu.username AS owner_name";
$q .= ", COUNT(DISTINCT d2.designs_id) AS totaldes";
$q .= " FROM minierp_users mu";
$q .= " INNER JOIN designs d ON d.owner=mu.id";
$q .= " LEFT JOIN designs d2 ON d2.owner=mu.id AND d2.status={$status}";
if ($sub_status != '') {
$q .= " AND d2.sub_status={$sub_status}";
}
// $q .= " WHERE d.status IN (1,2,3,4,5,6,7,8,10,11,12)";
public static function processPostAction()
{
global $session_userinfo;
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'WALLPOSTADD') {
$user_id = tep_db_prepare_input($_POST['user_id']);
$team = tep_db_prepare_input($_POST['team']);
$message = htmlspecialchars(tep_db_prepare_input($_POST['message'], true));
$wp = new wall_post();
$wp->create($user_id, $team, $session_userinfo['id'], date('Y-m-d H:i:s'), $message);
$ajaxResult = array();
$ajaxResult['user_id'] = $wp->user_id;
$ajaxResult['newpost'] = $wp->draw(true, true);
ajaxReturn($ajaxResult);
exit;
} elseif ($_POST['me_action'] == 'WALLPOSTREM') {
$wpid = tep_db_prepare_input($_POST['wpid']);
$wp = new wall_post($wpid);
$wp->delete();
echo utf8_encode($wpid);
exit;
}
objectSocialLinePostAction('wall_post');
}
}
improvement::updatePriority($id, $priority);
}
echo 'OK';
exit;
} elseif ($_POST['me_action'] == 'UPDATECHECKDATE') {
$id = tep_db_prepare_input($_POST['datas_id']);
$check_date = tep_db_prepare_input($_POST['check_date']);
$object = new improvement($id);
$scd = $object->updateCheckDate($check_date);
$result = array();
$result['id'] = $id;
$result['check_date'] = $check_date;
ajaxReturn($result);
exit;
}
objectSocialLinePostAction('improvement');
}
if (isset($_GET['status']) && array_key_exists($_GET['status'], $tabs)) {
$status = $_GET['status'];
$status_sort_by_ownner = array('1');
if ($filter_type == '0') {
$filter = " AND i.department={$filter_team}";
if ($filter_teamcat != 0) {
$filter .= " AND i.category='{$filter_teamcat}' ";
}
if ($filter_pic > 0) {
$filter .= " AND i.pic={$filter_pic}";
} elseif ($filter_pic == 'UNSET') {
$filter .= " AND i.pic='0'";
}
} elseif ($filter_type == '1') {
