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':
