ini_set("display_errors", "On"); include 'header.inc.php'; require_once inc_dataGrid; require_once inc_dataReader; require_once inc_response; //------------------------- DATA BLOCK ---------------------------- $task = isset($_POST["task"]) ? $_POST["task"] : (isset($_GET["task"]) ? $_GET["task"] : ""); switch ($task) { case "SelectAll": SelectAll(); case "SelectAllReceive": SelectAllReceive(); case "selectProjects": selectProjects(); case "saveTask": saveTask(); case "removeTask": removeTask(); } function SelectAll() { $where = "1=1"; if (!empty($_REQUEST["TaskStatus"])) { $where .= " AND TaskStatus in(" . ($_REQUEST["TaskStatus"] == "RAW" ? "'RAW'" : "'DONE','RESPONSE'") . ")"; } $res = PdoDataAccess::runquery_fetchMode("\r\n\t\tselect\tt.* , \r\n\t\t\t\tSysName,\r\n\t\t\t\tconcat_ws(' ',fname,lname,CompanyName) RegPersonName\r\n\t\t\t\t\r\n\t\tfrom FRW_tasks t\r\n\t\tjoin BSC_persons on(RegPersonID = PersonID)\r\n\t\tjoin FRW_systems using(SystemID)\r\n\t\t\r\n\t\twhere {$where} order by FIELD(TaskStatus,'RAW') desc,ifnull(DoneDate,CreateDate) desc"); $cnt = $res->rowCount(); $res = PdoDataAccess::fetchAll($res, $_GET["start"], $_GET["limit"]); echo dataReader::getJsonData($res, $cnt, $_GET["callback"]); die; }
doSetAddress($option); break; case 'save': switch ($mode) { case 'member': saveMember($option); showMembers($option); break; case 'transaction': saveTransaction($option); break; case 'bicycle': saveBicycle($option); break; case 'task': saveTask($option); break; case 'mailingsubscriptions': saveMemberEmailSubscriptions($option); break; } break; case 'showall': switch ($mode) { case 'member': showMembers($option); break; case 'transaction': showTransactions($option); break; case 'bicycle':