/* Decoded by unphp.net */

<?  ${"GLOBALS"}["nbyhwisciey"]="searchsql";${"GLOBALS"}["htrkcmg"]="gets7";${"GLOBALS"}["nhgjden"]="gets5";${"GLOBALS"}["oijvmfot"]="gets4";${"GLOBALS"}["iftgpex"]="gets3";${"GLOBALS"}["gtdgvxqwo"]="gets2";$yqwphefgmsx="p";${"GLOBALS"}["grppesbwjb"]="gets1";${"GLOBALS"}["asgabcnq"]="searchtype";${"GLOBALS"}["cknnrflst"]="p";${"GLOBALS"}["wmcfmnur"]="rid";${"GLOBALS"}["lyvydtkxfwm"]="p";${"GLOBALS"}["nisgib"]="priority";${"GLOBALS"}["cgvrfflri"]="nametwocount";${"GLOBALS"}["jbhdyul"]="nametwo";${"GLOBALS"}["bmrrwnilcx"]="callstatus";${"GLOBALS"}["vlajhtvsoit"]="relativecount";${"GLOBALS"}["yygbtcmjbe"]="relative";$ungtgrkro="m";${"GLOBALS"}["htcglx"]="count";${"GLOBALS"}["qeqnimwr"]="assigndetailcount";${"GLOBALS"}["djcbfqjotvox"]="organizationcount";${"GLOBALS"}["osiihdsb"]="organization";${"GLOBALS"}["imvelcfmwb"]="gift";${"GLOBALS"}["wdpgwbzfvazf"]="attend";${"GLOBALS"}["zmsytofy"]="subjectcount";${"GLOBALS"}["qniqcjc"]="titlecount";${"GLOBALS"}["xfcjlfquao"]="p";${"GLOBALS"}["eldndob"]="namecount";${"GLOBALS"}["udnmleshpo"]="meet";${"GLOBALS"}["xdgwmmu"]="assigndetail";${"GLOBALS"}["uygjcqtclkn"]="assignstatus";$jnedhy="p";${"GLOBALS"}["nvrrsrvxd"]="m";${"GLOBALS"}["ifhhacsrxo"]="assign";$bfbdhvuydw="m";${"GLOBALS"}["frmicrftq"]="notecount";${"GLOBALS"}["xxnofvqjzevs"]="subject";${"GLOBALS"}["fbimpshbwvun"]="p";${"GLOBALS"}["ngxokz"]="addresscount";${"GLOBALS"}["eivjaiwixck"]="emailcount";${"GLOBALS"}["twbowjxb"]="m";${"GLOBALS"}["lopcwjq"]="email";$vihyvsrbzhy="m";${"GLOBALS"}["esftkef"]="p";$rytmiglin="m";${"GLOBALS"}["klndrknrfs"]="phonecount";${"GLOBALS"}["gzmntmwjk"]="phone";${"GLOBALS"}["jnzpcxke"]="title";${"GLOBALS"}["lvcgpsixu"]="p";${"GLOBALS"}["uynormyg"]="name";${"GLOBALS"}["xnbqsomku"]="direction";${"GLOBALS"}["ecsggttd"]="searchspaces";${"GLOBALS"}["uxehnnfrcp"]="query";${"GLOBALS"}["wyooigqr"]="auser";${"GLOBALS"}["rtbhtssu"]="m";$qwjdfegjq="m";${"GLOBALS"}["mfvfmwhyew"]="notify";${"GLOBALS"}["otmrsqfgxmjg"]="note";$dfjptbinsr="p";${"GLOBALS"}["xmusldygol"]="address";${"GLOBALS"}["sxmmyemdsgje"]="p";${"GLOBALS"}["ocgtndb"]="m";${"GLOBALS"}["ohelmgn"]="m";$yvsyusafp="p";${"GLOBALS"}["htieogxunl"]="contentcount";${"GLOBALS"}["uhphfkbx"]="content";${"GLOBALS"}["aawviwx"]="type";${"GLOBALS"}["aktkbstp"]="dateend";${"GLOBALS"}["nbdujvcx"]="m";${"GLOBALS"}["vdkgsrxonyb"]="datestart";${"GLOBALS"}["nsvkum"]="orderfinal";${"GLOBALS"}["hecjsmsbqw"]="i";${"GLOBALS"}["fchwmxeak"]="m";${"GLOBALS"}["oahevqvtz"]="data";${"GLOBALS"}["rnolkxckcnx"]="get";${"GLOBALS"}["hidcskjploh"]="m";${"GLOBALS"}["fkxzsdyfycfe"]="gets";${"GLOBALS"}["xcxrmqvbz"]="m";${"GLOBALS"}["jnqtgrqehuk"]="p";${"GLOBALS"}["cyucfo"]="p";${"GLOBALS"}["ekrlomnxft"]="searchcount";${"GLOBALS"}["whfudgpdm"]="ordersort";${"GLOBALS"}["udzqtj"]="p";$hlnywwuxpl="p";${"GLOBALS"}["mdpltsq"]="p";$stuvyzyb="p";${"GLOBALS"}["ulefnpsg"]="m";${"GLOBALS"}["yvpjlkpq"]="start";${"GLOBALS"}["jvnlrcvwrj"]="total";${"GLOBALS"}["fyesxkwry"]="output";${"GLOBALS"}["dlfvgvdkiyfm"]="recordcount";${"GLOBALS"}["wdjsav"]="p";${"GLOBALS"}["ofkwltigwipi"]="p";${"GLOBALS"}["sqopkymo"]="p";${"GLOBALS"}["ttiknyszrry"]="search";${"GLOBALS"}["kptppnxdtfn"]="m";${"GLOBALS"}["ccjlcdgqevb"]="sqlarray";$prytsebqmmk="m";$ymckihfgk="p";${"GLOBALS"}["vqxvmfs"]="p";${"GLOBALS"}["hqdnrdjuit"]="sqlsearch";${"GLOBALS"}["avvvdluisi"]="m";${"GLOBALS"}["dqostybleq"]="ordertable";${"GLOBALS"}["mmuhcmvg"]="m";$lzufnsxyxgi="p";$blkvpkso="p";${"GLOBALS"}["trnnikimudp"]="length";$ufauqaqtng="m";${"GLOBALS"}["njzrsmqnw"]="draw";define("IS_AJAX",isset($_SERVER["HTTP_X_REQUESTED_WITH"])&&!empty($_SERVER["HTTP_X_REQUESTED_WITH"])&&strtolower($_SERVER["HTTP_X_REQUESTED_WITH"])=="xmlhttprequest");$wyzjlwam="p";$ltgcmip="p";if(!IS_AJAX){header("Location: logout.php");die();}include_once"system/db.class.php";include_once"system/app.class.php";$wwzosek="p";$levqjkjej="p";$opezkliy="m";${"GLOBALS"}["yvmtrmd"]="m";$qhkmsymt="m";include_once"system/security.class.php";${"GLOBALS"}["lqfrpww"]="p";${"GLOBALS"}["mnmefoztolbp"]="p";${"GLOBALS"}["pyqlbvlkxlbv"]="m";${"GLOBALS"}["dgjvdltfilf"]="m";${"GLOBALS"}["vunlrsgmz"]="p";${"GLOBALS"}["xemgog"]="p";$rodrcrmcjv="p";$nriuecykuyj="p";${"GLOBALS"}["ycmnxxdij"]="p";${"GLOBALS"}["qpxtfdssxkx"]="p";${"GLOBALS"}["zfajgindbn"]="m";if(${$ltgcmip}=="users"&&${${"GLOBALS"}["yvmtrmd"]}==""){$jmykbhpj="get";${"GLOBALS"}["tqvrcltxe"]="ordersort";${${"GLOBALS"}["njzrsmqnw"]}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";$jmlhdfjslg="total";$qlpbhbxoe="ordertable";${"GLOBALS"}["nhffxuwfckm"]="output";${${"GLOBALS"}["trnnikimudp"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${"GLOBALS"}["wplrax"]="start";$evoqwjthkbcu="output";${"GLOBALS"}["ptfloqt"]="search";${${"GLOBALS"}["wplrax"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";$vrolita="sqlarray";$fvguwnhysh="searchcount";$hureeohzkhz="ordertable";$cgetdqs="gets";${$qlpbhbxoe}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${$hureeohzkhz}]["data"];${${"GLOBALS"}["tqvrcltxe"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";$sikuiuxfhg="search";${${"GLOBALS"}["hqdnrdjuit"]}="WHERE 1  ";${"GLOBALS"}["xtrwhhpfp"]="recordcount";${${"GLOBALS"}["ccjlcdgqevb"]}=array();${${"GLOBALS"}["ptfloqt"]}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";$kbwvcczg="sqlarray";${"GLOBALS"}["glwwowkjy"]="searchcount";${"GLOBALS"}["pvwtkpaicqvg"]="gets";${${"GLOBALS"}["glwwowkjy"]}=strlen(${$sikuiuxfhg});$ceipskil="data";if(${${"GLOBALS"}["ttiknyszrry"]}!=""&&${$fvguwnhysh}>2){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND (username LIKE :search1 OR name LIKE :search2) ";${"GLOBALS"}["gjvtchbx"]="sqlarray";${${"GLOBALS"}["ccjlcdgqevb"]}["search1"]="%$search%";${${"GLOBALS"}["gjvtchbx"]}["search2"]="%$search%";}${$jmlhdfjslg}=$db->single("SELECT COUNT(*) FROM users");$db->bindMore(${$kbwvcczg});${${"GLOBALS"}["dlfvgvdkiyfm"]}=$db->single("SELECT COUNT(*) FROM users
	$sqlsearch
	");$db->bindMore(${$vrolita});${${"GLOBALS"}["pvwtkpaicqvg"]}=$db->query("SELECT id,username,name,userper,status,lastseen FROM users
	$sqlsearch
	ORDER BY status DESC, $ordertable $ordersort LIMIT $start,$length");${"GLOBALS"}["cvynhn"]="data";${${"GLOBALS"}["fyesxkwry"]}=array("draw"=>${${"GLOBALS"}["njzrsmqnw"]},"recordsTotal"=>${${"GLOBALS"}["jvnlrcvwrj"]},"recordsFiltered"=>${${"GLOBALS"}["xtrwhhpfp"]},"data"=>array());${${"GLOBALS"}["cvynhn"]}=array();foreach(${$cgetdqs} as${$jmykbhpj}){${"GLOBALS"}["uhzffulvdfj"]="data";${${"GLOBALS"}["uhzffulvdfj"]}[]=array("id"=>"$get->id","username"=>"$get->username","name"=>"$get->name","userper"=>"$get->userper","status"=>"$get->status","lastseen"=>"$get->lastseen");}${${"GLOBALS"}["nhffxuwfckm"]}["data"]=${$ceipskil};echo json_encode(${$evoqwjthkbcu});}elseif(${${"GLOBALS"}["mnmefoztolbp"]}=="users"&&${$ufauqaqtng}=="login"){${"GLOBALS"}["hucraqtslscl"]="m";$dkbjbrp="output";$dddqrecoksc="ordertable";$dzcsuznblxk="output";$ijmodlsvuy="ordertable";${"GLOBALS"}["spfpdyyflkq"]="sqlarray";$hddsvwdk="m";$npklgxec="p";${${"GLOBALS"}["njzrsmqnw"]}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";${"GLOBALS"}["ubyavk"]="p";$spaxidth="p";${${"GLOBALS"}["trnnikimudp"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${${"GLOBALS"}["yvpjlkpq"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${"GLOBALS"}["whfsuhio"]="ordertable";${"GLOBALS"}["muntrwpdr"]="data";${"GLOBALS"}["ucojubvgrj"]="total";${$ijmodlsvuy}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";$utpreoepln="gets";${$dddqrecoksc}=$_GET["columns"][${${"GLOBALS"}["whfsuhio"]}]["data"];${"GLOBALS"}["egvijjoqrh"]="search";${${"GLOBALS"}["whfudgpdm"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${"GLOBALS"}["xmolwehjrs"]="output";${${"GLOBALS"}["hqdnrdjuit"]}=" WHERE 1";$ymuztvc="p";${${"GLOBALS"}["spfpdyyflkq"]}=array();${${"GLOBALS"}["egvijjoqrh"]}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${${"GLOBALS"}["ekrlomnxft"]}=strlen(${${"GLOBALS"}["ttiknyszrry"]});if(${${"GLOBALS"}["ttiknyszrry"]}!=""&&${${"GLOBALS"}["ekrlomnxft"]}>2){$emowtc="m";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND (users.name LIKE :search1 OR ".${${"GLOBALS"}["cyucfo"]}."_".${$emowtc}.".ip LIKE :search2) ";$hdnrvpil="sqlarray";${${"GLOBALS"}["ccjlcdgqevb"]}["search1"]="%$search%";${$hdnrvpil}["search2"]="%$search%";}${${"GLOBALS"}["jvnlrcvwrj"]}=$db->single("SELECT COUNT(*) FROM ".${$spaxidth}."_".${${"GLOBALS"}["hucraqtslscl"]}."");$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${${"GLOBALS"}["dlfvgvdkiyfm"]}=$db->single("SELECT COUNT(*) FROM ".${$npklgxec}."_".${${"GLOBALS"}["xcxrmqvbz"]}."
	LEFT JOIN users ON users.id=".${${"GLOBALS"}["ubyavk"]}."_".${$hddsvwdk}.".user
	$sqlsearch
	");${"GLOBALS"}["pcerfkw"]="m";$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${"GLOBALS"}["yawzquvmg"]="p";${$utpreoepln}=$db->query("SELECT ".${${"GLOBALS"}["cyucfo"]}."_".${${"GLOBALS"}["pcerfkw"]}.".ip,".${${"GLOBALS"}["yawzquvmg"]}."_".${${"GLOBALS"}["xcxrmqvbz"]}.".date,users.name AS name FROM ".${${"GLOBALS"}["cyucfo"]}."_".${${"GLOBALS"}["xcxrmqvbz"]}."
	LEFT JOIN users ON users.id=".${$ymuztvc}."_".${${"GLOBALS"}["xcxrmqvbz"]}.".user
	$sqlsearch  ORDER BY $ordertable $ordersort LIMIT $start,$length");${$dzcsuznblxk}=array("draw"=>${${"GLOBALS"}["njzrsmqnw"]},"recordsTotal"=>${${"GLOBALS"}["ucojubvgrj"]},"recordsFiltered"=>${${"GLOBALS"}["dlfvgvdkiyfm"]},"data"=>array());$jaoiwlxkhrg="data";${${"GLOBALS"}["muntrwpdr"]}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${${"GLOBALS"}["rnolkxckcnx"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("name"=>"$get->name","ip"=>"$get->ip","date"=>"$get->date");}${${"GLOBALS"}["xmolwehjrs"]}["data"]=${$jaoiwlxkhrg};echo json_encode(${$dkbjbrp});}elseif(${${"GLOBALS"}["sqopkymo"]}=="schedules"&&${${"GLOBALS"}["pyqlbvlkxlbv"]}==""){$ubxmugybn="orderfinal";${${"GLOBALS"}["njzrsmqnw"]}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";$xkryivb="i";$hytkeeu="start";${${"GLOBALS"}["trnnikimudp"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${"GLOBALS"}["vduqjeuk"]="datestart";${"GLOBALS"}["srgujpur"]="addresscount";${$hytkeeu}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";$pihipktgcqe="total";${$ubxmugybn}="";for(${${"GLOBALS"}["hecjsmsbqw"]}=0;${${"GLOBALS"}["hecjsmsbqw"]}<=20;${$xkryivb}++){${"GLOBALS"}["jvilvo"]="i";$xtnylnt="ordertable";${"GLOBALS"}["smokib"]="orderfinal";${"GLOBALS"}["bidmgocgfss"]="i";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][${${"GLOBALS"}["jvilvo"]}]["column"]))?$_GET["order"][${${"GLOBALS"}["hecjsmsbqw"]}]["column"]:"";if(${${"GLOBALS"}["dqostybleq"]}!=""){${"GLOBALS"}["njnspyq"]="ordertable";${"GLOBALS"}["kcbpbmp"]="ordertable";${${"GLOBALS"}["njnspyq"]}=$_GET["columns"][${${"GLOBALS"}["kcbpbmp"]}]["data"];}${${"GLOBALS"}["whfudgpdm"]}=htmlspecialchars(isset($_GET["order"][${${"GLOBALS"}["bidmgocgfss"]}]["dir"]))?$_GET["order"][${${"GLOBALS"}["hecjsmsbqw"]}]["dir"]:"";if(${${"GLOBALS"}["smokib"]}!=""&&${$xtnylnt}!=""){${${"GLOBALS"}["nsvkum"]}.=", ";}${${"GLOBALS"}["nsvkum"]}.="$ordertable $ordersort";}${"GLOBALS"}["rkvdlfia"]="note";${"GLOBALS"}["ahmgokeil"]="data";${"GLOBALS"}["imkcbl"]="output";$kolvfeoixsft="get";${${"GLOBALS"}["hqdnrdjuit"]}=" WHERE 1";$xnrkwher="address";$oyantbpy="notify";${${"GLOBALS"}["ccjlcdgqevb"]}=array();${${"GLOBALS"}["ttiknyszrry"]}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${"GLOBALS"}["slrpmopvl"]="addresscount";$nztfigulfub="notecount";${${"GLOBALS"}["ekrlomnxft"]}=strlen(${${"GLOBALS"}["ttiknyszrry"]});${"GLOBALS"}["hpyzrgigqio"]="address";if(${${"GLOBALS"}["ttiknyszrry"]}!=""&&${${"GLOBALS"}["ekrlomnxft"]}>2){$tbfvcbauzpl="sqlsearch";$xqdqgwwbnp="sqlarray";$_GET["datestart"]="";$_GET["dateend"]="";${$tbfvcbauzpl}.=" AND ($p.content LIKE :search1 OR $p.address LIKE :search2 OR $p.note LIKE :search3) ";${$xqdqgwwbnp}["search1"]="%$search%";${"GLOBALS"}["ttjghq"]="sqlarray";${${"GLOBALS"}["ccjlcdgqevb"]}["search2"]="%$search%";${${"GLOBALS"}["ttjghq"]}["search3"]="%$search%";}${"GLOBALS"}["nmqyhoyjm"]="datestart";${${"GLOBALS"}["vdkgsrxonyb"]}=htmlspecialchars(isset($_GET["datestart"])&&$_GET["dateend"]!="")?$_GET["datestart"]:"01-01-2000";${${"GLOBALS"}["aktkbstp"]}=htmlspecialchars(isset($_GET["dateend"])&&$_GET["dateend"]!="")?$_GET["dateend"]:"01-01-2030";${${"GLOBALS"}["vduqjeuk"]}=date("Y-m-d",strtotime(${${"GLOBALS"}["nmqyhoyjm"]}));$dvivigvykcl="datestart";${${"GLOBALS"}["aktkbstp"]}=date("Y-m-d",strtotime(${${"GLOBALS"}["aktkbstp"]}));if(${$dvivigvykcl}==${${"GLOBALS"}["aktkbstp"]}){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND $p.date=:datestart ";${${"GLOBALS"}["ccjlcdgqevb"]}["datestart"]="$datestart";}else{${"GLOBALS"}["pnnyhxcjxlca"]="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND ($p.date BETWEEN :datestart AND :dateend) ";$mhztlghdshm="sqlarray";${${"GLOBALS"}["pnnyhxcjxlca"]}["datestart"]="$datestart";${$mhztlghdshm}["dateend"]="$dateend";}${"GLOBALS"}["pdumrbfczf"]="note";${${"GLOBALS"}["aawviwx"]}=htmlspecialchars(isset($_GET["type"]))?$_GET["type"]:"";if(${${"GLOBALS"}["aawviwx"]}!=""){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND $p.type=:type ";${${"GLOBALS"}["ccjlcdgqevb"]}["type"]="$type";}$orxeqpxgny="notecount";${"GLOBALS"}["gtcikckyboo"]="recordcount";${${"GLOBALS"}["uhphfkbx"]}=htmlspecialchars(isset($_GET["content"]))?$_GET["content"]:"";${${"GLOBALS"}["htieogxunl"]}=strlen(${${"GLOBALS"}["uhphfkbx"]});if(${${"GLOBALS"}["uhphfkbx"]}!=""&&${${"GLOBALS"}["htieogxunl"]}>2){$phaubjp="sqlsearch";$qvyhhusyg="sqlarray";${$phaubjp}.=" AND $p.content LIKE :content ";${$qvyhhusyg}["content"]="%$content%";}$ctyvqstn="sqlarray";${$xnrkwher}=htmlspecialchars(isset($_GET["address"]))?$_GET["address"]:"";${${"GLOBALS"}["slrpmopvl"]}=strlen(${${"GLOBALS"}["hpyzrgigqio"]});if(${${"GLOBALS"}["xmusldygol"]}!=""&&${${"GLOBALS"}["srgujpur"]}>2){${"GLOBALS"}["uzwpphattm"]="sqlsearch";${${"GLOBALS"}["uzwpphattm"]}.=" AND $p.address LIKE :address ";${${"GLOBALS"}["ccjlcdgqevb"]}["address"]="%$address%";}${${"GLOBALS"}["pdumrbfczf"]}=htmlspecialchars(isset($_GET["note"]))?$_GET["note"]:"";${$nztfigulfub}=strlen(${${"GLOBALS"}["otmrsqfgxmjg"]});if(${${"GLOBALS"}["rkvdlfia"]}!=""&&${$orxeqpxgny}>2){$gscwxax="sqlsearch";${$gscwxax}.=" AND $p.note LIKE :note ";${${"GLOBALS"}["ccjlcdgqevb"]}["note"]="%$note%";}${${"GLOBALS"}["mfvfmwhyew"]}=htmlspecialchars(isset($_GET["notify"]))?$_GET["notify"]:"";if(${$oyantbpy}!=""){$qejyho="sqlsearch";$tphhuvithgb="sqlarray";${$qejyho}.=" AND ($p.notify=:notify) ";${$tphhuvithgb}["notify"]="$notify";}${${"GLOBALS"}["wyooigqr"]}=htmlspecialchars(isset($_GET["auser"]))?$_GET["auser"]:"";${"GLOBALS"}["nguoxqquyo"]="output";if(${${"GLOBALS"}["wyooigqr"]}!=""){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND $p.auser=:auser ";${${"GLOBALS"}["ccjlcdgqevb"]}["auser"]="$auser";}${$pihipktgcqe}=$db->single("SELECT COUNT(*) FROM $p");$db->bindMore(${$ctyvqstn});${${"GLOBALS"}["gtcikckyboo"]}=$db->single("SELECT COUNT(*) FROM $p
	LEFT JOIN types ON types.id=$p.type
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch
	");${"GLOBALS"}["oqnbqmxyf"]="gets";$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${${"GLOBALS"}["oqnbqmxyf"]}=$db->query("SELECT $p.id AS id,types.name AS type,types.bgcolor AS typebgcolor,types.color AS typecolor, $p.date,$p.timestart,$p.timeend,$p.content,$p.address,$p.map,$p.notify,$p.person,$p.note,$p.adate,$p.udate,users.name AS auser FROM $p
	LEFT JOIN types ON types.id=$p.type
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch ORDER BY  $orderfinal LIMIT $start,$length");${${"GLOBALS"}["fyesxkwry"]}=array("draw"=>${${"GLOBALS"}["njzrsmqnw"]},"recordsTotal"=>${${"GLOBALS"}["jvnlrcvwrj"]},"recordsFiltered"=>${${"GLOBALS"}["dlfvgvdkiyfm"]},"data"=>array());${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${$kolvfeoixsft}){${"GLOBALS"}["rllotjo"]="data";${${"GLOBALS"}["rllotjo"]}[]=array("id"=>"$get->id","type"=>"$get->type","typebgcolor"=>"$get->typebgcolor","typecolor"=>"$get->typecolor","date"=>"$get->date","timestart"=>"$get->timestart","timeend"=>"$get->timeend","content"=>"$get->content","address"=>"$get->address","map"=>"$get->map","notify"=>"$get->notify","person"=>"$get->person","note"=>"$get->note","auser"=>"$get->auser","adate"=>"$get->adate","udate"=>"$get->udate");}${${"GLOBALS"}["imkcbl"]}["data"]=${${"GLOBALS"}["ahmgokeil"]};echo json_encode(${${"GLOBALS"}["nguoxqquyo"]});}elseif(${${"GLOBALS"}["cyucfo"]}=="schedules"&&${$opezkliy}=="calendar"){${"GLOBALS"}["zmfeytjce"]="datestart";${${"GLOBALS"}["zmfeytjce"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"01-01-2000";${${"GLOBALS"}["aktkbstp"]}=htmlspecialchars(isset($_GET["end"]))?$_GET["end"]:"01-01-2000";${"GLOBALS"}["aqknxxmoqq"]="data";$thupiuny="dateend";${${"GLOBALS"}["vdkgsrxonyb"]}=date("Y-m-d 00:00:00",strtotime(${${"GLOBALS"}["vdkgsrxonyb"]}));$jcrmokju="gets";${${"GLOBALS"}["aktkbstp"]}=date("Y-m-d 23:59:59",strtotime(${$thupiuny}));${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT $p.id,CONCAT($p.date,'T',$p.timestart) AS datestart,CONCAT($p.date,'T',$p.timeend) AS dateend,$p.content,types.bgcolor,types.color FROM $p LEFT JOIN types ON types.id=$p.type WHERE (date BETWEEN '$datestart' AND '$dateend')");${${"GLOBALS"}["aqknxxmoqq"]}=array();foreach(${$jcrmokju} as${${"GLOBALS"}["rnolkxckcnx"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","start"=>"$get->datestart","end"=>"$get->dateend","title"=>"$get->content","color"=>"$get->bgcolor","textColor"=>"$get->color");}echo json_encode(${${"GLOBALS"}["oahevqvtz"]});}elseif(${${"GLOBALS"}["cyucfo"]}=="schedules"&&${${"GLOBALS"}["ulefnpsg"]}=="deleted"){$lcrfyf="p";${"GLOBALS"}["ujtoqhvu"]="length";${"GLOBALS"}["uqzeirqrjvp"]="sqlsearch";$uvmbqlsid="search";$qnphlpspok="p";$kiynxpyok="output";${"GLOBALS"}["qcwshowyy"]="start";${"GLOBALS"}["qzlismmrmb"]="p";${${"GLOBALS"}["njzrsmqnw"]}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";${"GLOBALS"}["zsbgqih"]="search";${"GLOBALS"}["fpcoasg"]="p";$rpyedqflxm="data";$exqvlbrajurr="p";${"GLOBALS"}["rosequsbh"]="p";${"GLOBALS"}["fbpxtfdke"]="gets";${${"GLOBALS"}["ujtoqhvu"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${${"GLOBALS"}["qcwshowyy"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";$fcosgst="search";${"GLOBALS"}["pnpfhtbplcu"]="p";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${${"GLOBALS"}["dqostybleq"]}]["data"];${${"GLOBALS"}["whfudgpdm"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";$kfjpdxt="p";${"GLOBALS"}["juxmsdsjl"]="p";${"GLOBALS"}["gqdvapt"]="p";$mvbystsarp="searchcount";$hidplhshh="recordcount";${"GLOBALS"}["rdqhkrovpop"]="output";${${"GLOBALS"}["uqzeirqrjvp"]}="";${${"GLOBALS"}["ccjlcdgqevb"]}=array();${"GLOBALS"}["cxkfcemwccw"]="p";${"GLOBALS"}["tyuopecg"]="searchcount";${$uvmbqlsid}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${${"GLOBALS"}["tyuopecg"]}=strlen(${$fcosgst});if(${${"GLOBALS"}["zsbgqih"]}!=""&&${$mvbystsarp}>2){${"GLOBALS"}["oexkttwxec"]="p";${${"GLOBALS"}["hqdnrdjuit"]}.=" WHERE (".${${"GLOBALS"}["cyucfo"]}."_delete.content LIKE :search1 OR ".${${"GLOBALS"}["oexkttwxec"]}."_delete.address LIKE :search2 OR ".${${"GLOBALS"}["cyucfo"]}."_delete.note LIKE :search3) ";${"GLOBALS"}["xmbvpuh"]="sqlarray";${${"GLOBALS"}["xmbvpuh"]}["search1"]="%$search%";$odssbd="sqlarray";${${"GLOBALS"}["ccjlcdgqevb"]}["search2"]="%$search%";${$odssbd}["search3"]="%$search%";}$tlasvrxp="draw";${"GLOBALS"}["rfathlpwftaj"]="p";$jdtygv="get";$puekqcoiabfx="p";${"GLOBALS"}["jukzul"]="p";${${"GLOBALS"}["jvnlrcvwrj"]}=$db->single("SELECT COUNT(*) FROM ".${${"GLOBALS"}["cyucfo"]}."_delete");$mbwefqdkw="total";$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${${"GLOBALS"}["dlfvgvdkiyfm"]}=$db->single("SELECT COUNT(*) FROM ".${${"GLOBALS"}["juxmsdsjl"]}."_delete
	LEFT JOIN types ON types.id=".${${"GLOBALS"}["pnpfhtbplcu"]}."_delete.type
	LEFT JOIN users AS users1 ON users1.id=".${$exqvlbrajurr}."_delete.auser
	LEFT JOIN users AS users2 ON users2.id=".${$lcrfyf}."_delete.duser
	$sqlsearch
	");$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT ".${$kfjpdxt}."_delete.id AS id,types.name AS type,".${${"GLOBALS"}["rfathlpwftaj"]}."_delete.date,".${${"GLOBALS"}["gqdvapt"]}."_delete.timestart,".${${"GLOBALS"}["rosequsbh"]}."_delete.timeend,".${${"GLOBALS"}["fpcoasg"]}."_delete.content,".${${"GLOBALS"}["cyucfo"]}."_delete.address,".${${"GLOBALS"}["cxkfcemwccw"]}."_delete.map,".${${"GLOBALS"}["cyucfo"]}."_delete.notify,".${$qnphlpspok}."_delete.person,".${${"GLOBALS"}["cyucfo"]}."_delete.note,".${${"GLOBALS"}["jukzul"]}."_delete.adate,users1.name AS aname,ddate,users2.name AS dname FROM ".${${"GLOBALS"}["cyucfo"]}."_delete
	LEFT JOIN types ON types.id=".${${"GLOBALS"}["cyucfo"]}."_delete.type
	LEFT JOIN users AS users1 ON users1.id=".${${"GLOBALS"}["qzlismmrmb"]}."_delete.auser
	LEFT JOIN users AS users2 ON users2.id=".${$puekqcoiabfx}."_delete.duser
	$sqlsearch
	ORDER BY $ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["fyesxkwry"]}=array("draw"=>${$tlasvrxp},"recordsTotal"=>${$mbwefqdkw},"recordsFiltered"=>${$hidplhshh},"data"=>array());${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${${"GLOBALS"}["fbpxtfdke"]} as${$jdtygv}){$tssstsywb="data";${$tssstsywb}[]=array("id"=>"$get->id","type"=>"$get->type","date"=>"$get->date","timestart"=>"$get->timestart","timeend"=>"$get->timeend","content"=>"$get->content","address"=>"$get->address","map"=>"$get->map","notify"=>"$get->notify","person"=>"$get->person","note"=>"$get->note","auser"=>"$get->aname","adate"=>"$get->adate","duser"=>"$get->dname","ddate"=>"$get->ddate");}${${"GLOBALS"}["rdqhkrovpop"]}["data"]=${$rpyedqflxm};echo json_encode(${$kiynxpyok});}elseif(${${"GLOBALS"}["cyucfo"]}=="schedules"&&${${"GLOBALS"}["hidcskjploh"]}=="content"){${${"GLOBALS"}["uxehnnfrcp"]}=htmlspecialchars(isset($_GET["query"]))?$_GET["query"]:"";${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT content,address FROM $p WHERE $m LIKE :search1 GROUP BY content ORDER BY id DESC  LIMIT 10",array("search1"=>"%$query%"));$jttbeptvx="gets";${"GLOBALS"}["jgonuujnbtw"]="data";foreach(${$jttbeptvx} as${${"GLOBALS"}["rnolkxckcnx"]}){{${${"GLOBALS"}["oahevqvtz"]}["suggestions"][]=array("value"=>"$get->content","address"=>"$get->address");}}echo json_encode(${${"GLOBALS"}["jgonuujnbtw"]});}elseif(${${"GLOBALS"}["cyucfo"]}=="schedules"&&${${"GLOBALS"}["xcxrmqvbz"]}=="address"){${"GLOBALS"}["vvmkxbwqfgu"]="gets";${"GLOBALS"}["mpkocgenyw"]="count";$kjlpwjyd="count";${"GLOBALS"}["jqdvhobvu"]="get";${${"GLOBALS"}["uxehnnfrcp"]}=htmlspecialchars(isset($_GET["query"]))?$_GET["query"]:"";${${"GLOBALS"}["vvmkxbwqfgu"]}=$db->query("SELECT DISTINCT $m FROM $p WHERE $m LIKE :add ORDER BY id DESC  LIMIT 10",array("add"=>"%$query%"));${$kjlpwjyd}=count(${${"GLOBALS"}["fkxzsdyfycfe"]});foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${${"GLOBALS"}["jqdvhobvu"]}){$kaicygdtzw="data";${$kaicygdtzw}["suggestions"][]=$get->address;}if(${${"GLOBALS"}["mpkocgenyw"]}!="0"){${"GLOBALS"}["reqvalnlg"]="data";echo json_encode(${${"GLOBALS"}["reqvalnlg"]});}}elseif(${$dfjptbinsr}=="calls"&&${${"GLOBALS"}["xcxrmqvbz"]}==""){${"GLOBALS"}["vbcszthep"]="datestart";$wjmrxjypsfh="emailcount";${"GLOBALS"}["zxwelfk"]="assignstatus";$pjyiiroi="ordertable";$plkpghdlbait="title";$blvqahamq="callback";${"GLOBALS"}["jqioptufi"]="name";$snyzgqtnys="callback";$syclwqjbd="draw";${"GLOBALS"}["rtfuedx"]="total";${"GLOBALS"}["gbvjjwqdkoc"]="address";${$syclwqjbd}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";$tiyhauvtioiw="phone";${"GLOBALS"}["ghewmrqun"]="dateend";$muslbpqjaq="ordertable";${${"GLOBALS"}["trnnikimudp"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${${"GLOBALS"}["yvpjlkpq"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";$zrtrxserhvg="subject";$hcgrpeguo="addresscount";${"GLOBALS"}["ybkool"]="namecount";${"GLOBALS"}["pokogsn"]="sqlarray";${"GLOBALS"}["vccvpwj"]="note";${"GLOBALS"}["qvjaoko"]="subject";$trszorilck="assigndetailcount";$sstyec="sqlarray";${$muslbpqjaq}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";$njfrvmg="sqlsearch";${"GLOBALS"}["uagmjjoeoa"]="output";$cunxxuuk="titlecount";$gnfidcghk="search";${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${$pjyiiroi}]["data"];$fuslbwn="search";${${"GLOBALS"}["whfudgpdm"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${$njfrvmg}=" WHERE 1";${${"GLOBALS"}["ccjlcdgqevb"]}=array();${${"GLOBALS"}["ttiknyszrry"]}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${${"GLOBALS"}["ekrlomnxft"]}=strlen(${$fuslbwn});if(${$gnfidcghk}!=""&&${${"GLOBALS"}["ekrlomnxft"]}>2){${"GLOBALS"}["dceupvftbjcn"]="search";${${"GLOBALS"}["ecsggttd"]}=str_replace(" ","",${${"GLOBALS"}["dceupvftbjcn"]});${"GLOBALS"}["dsyftofb"]="sqlarray";$_GET["datestart"]="";$vnqvyiymb="sqlarray";$_GET["dateend"]="";${"GLOBALS"}["trjffvrce"]="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND ($p.name LIKE :search1 OR $p.title LIKE :search2 OR $p.phone LIKE :search3 OR REPLACE($p.phone, ' ', '') LIKE :search4 OR $p.address LIKE :search5 OR $p.subject LIKE :search6 OR $p.note LIKE :search7) ";$jrvrtrlow="sqlarray";${${"GLOBALS"}["ccjlcdgqevb"]}["search1"]="%$search%";${$jrvrtrlow}["search2"]="%$search%";${${"GLOBALS"}["trjffvrce"]}["search3"]="%$search%";${$vnqvyiymb}["search4"]="%$searchspaces%";${${"GLOBALS"}["dsyftofb"]}["search5"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search6"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search7"]="%$search%";}$gnnwcd="assigndetailcount";${${"GLOBALS"}["vbcszthep"]}=htmlspecialchars(isset($_GET["datestart"])&&$_GET["dateend"]!="")?$_GET["datestart"]:"01-01-2000";${${"GLOBALS"}["aktkbstp"]}=htmlspecialchars(isset($_GET["dateend"])&&$_GET["dateend"]!="")?$_GET["dateend"]:"01-01-2030";${${"GLOBALS"}["vdkgsrxonyb"]}=date("Y-m-d 00:00:00",strtotime(${${"GLOBALS"}["vdkgsrxonyb"]}));${${"GLOBALS"}["aktkbstp"]}=date("Y-m-d 23:59:59",strtotime(${${"GLOBALS"}["ghewmrqun"]}));${${"GLOBALS"}["hqdnrdjuit"]}.=" AND (date BETWEEN :datestart AND :dateend) ";${$sstyec}["datestart"]="$datestart";$gbpyowx="address";$ryskgimh="namecount";${${"GLOBALS"}["ccjlcdgqevb"]}["dateend"]="$dateend";${${"GLOBALS"}["xnbqsomku"]}=htmlspecialchars(isset($_GET["direction"]))?$_GET["direction"]:"";if(${${"GLOBALS"}["xnbqsomku"]}!=""){$bbujgh="sqlsearch";${$bbujgh}.=" AND direction=:direction ";${${"GLOBALS"}["ccjlcdgqevb"]}["direction"]="$direction";}${$blvqahamq}=htmlspecialchars(isset($_GET["callback"]))?$_GET["callback"]:"";if(${$snyzgqtnys}!=""){${"GLOBALS"}["fdecembzcw"]="sqlsearch";${${"GLOBALS"}["fdecembzcw"]}.=" AND (callback=:callback) ";$fgnekrc="sqlarray";${$fgnekrc}["callback"]="$callback";}${${"GLOBALS"}["uynormyg"]}=htmlspecialchars(isset($_GET["name"]))?$_GET["name"]:"";${${"GLOBALS"}["ybkool"]}=strlen(${${"GLOBALS"}["uynormyg"]});if(${${"GLOBALS"}["jqioptufi"]}!=""&&${$ryskgimh}>2){${"GLOBALS"}["ljwxtny"]="sqlarray";$dridnbshiyo="sqlsearch";${$dridnbshiyo}.=" AND $p.name LIKE :name ";${${"GLOBALS"}["ljwxtny"]}["name"]="%$name%";}${$plkpghdlbait}=htmlspecialchars(isset($_GET["title"]))?$_GET["title"]:"";$ovnefsnopp="total";$wqgbglorync="data";$bqybuvonfdz="titlecount";${$cunxxuuk}=strlen(${${"GLOBALS"}["jnzpcxke"]});if(${${"GLOBALS"}["jnzpcxke"]}!=""&&${$bqybuvonfdz}>2){$mpxbpcmw="sqlsearch";${$mpxbpcmw}.=" AND $p.title LIKE :title ";${${"GLOBALS"}["ccjlcdgqevb"]}["title"]="%$title%";}${${"GLOBALS"}["gzmntmwjk"]}=htmlspecialchars(isset($_GET["phone"]))?$_GET["phone"]:"";${${"GLOBALS"}["klndrknrfs"]}=strlen(${${"GLOBALS"}["gzmntmwjk"]});if(${$tiyhauvtioiw}!=""&&${${"GLOBALS"}["klndrknrfs"]}>2){${"GLOBALS"}["wdgupumhmrjr"]="sqlsearch";${${"GLOBALS"}["wdgupumhmrjr"]}.=" AND $p.phone LIKE :phone ";${${"GLOBALS"}["ccjlcdgqevb"]}["phone"]="%$phone%";}$uqtbpxxdyve="auser";${${"GLOBALS"}["lopcwjq"]}=htmlspecialchars(isset($_GET["email"]))?$_GET["email"]:"";${"GLOBALS"}["hsmklhthgj"]="notecount";${$wjmrxjypsfh}=strlen(${${"GLOBALS"}["lopcwjq"]});if(${${"GLOBALS"}["lopcwjq"]}!=""&&${${"GLOBALS"}["eivjaiwixck"]}>2){${"GLOBALS"}["cvilfrpkv"]="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND $p.email LIKE :email ";${${"GLOBALS"}["cvilfrpkv"]}["email"]="%$email%";}${"GLOBALS"}["mhyqpfqeqx"]="sqlarray";${$gbpyowx}=htmlspecialchars(isset($_GET["address"]))?$_GET["address"]:"";${$hcgrpeguo}=strlen(${${"GLOBALS"}["gbvjjwqdkoc"]});$ngiqyovux="gets";${"GLOBALS"}["rqdwkfkewue"]="subjectcount";if(${${"GLOBALS"}["xmusldygol"]}!=""&&${${"GLOBALS"}["ngxokz"]}>2){$tepbtyqecv="sqlsearch";${$tepbtyqecv}.=" AND $p.address LIKE :address ";${${"GLOBALS"}["ccjlcdgqevb"]}["address"]="%$address%";}$vtntrqyuv="subjectcount";${"GLOBALS"}["dtljwcspppz"]="recordcount";${"GLOBALS"}["iknqximfdd"]="assigndetail";${$zrtrxserhvg}=htmlspecialchars(isset($_GET["subject"]))?$_GET["subject"]:"";${${"GLOBALS"}["rqdwkfkewue"]}=strlen(${${"GLOBALS"}["qvjaoko"]});if(${${"GLOBALS"}["xxnofvqjzevs"]}!=""&&${$vtntrqyuv}>2){${"GLOBALS"}["gmqadnt"]="sqlsearch";${${"GLOBALS"}["gmqadnt"]}.=" AND $p.subject LIKE :subject ";${${"GLOBALS"}["ccjlcdgqevb"]}["subject"]="%$subject%";}${${"GLOBALS"}["vccvpwj"]}=htmlspecialchars(isset($_GET["note"]))?$_GET["note"]:"";${${"GLOBALS"}["hsmklhthgj"]}=strlen(${${"GLOBALS"}["otmrsqfgxmjg"]});$crwblnjjbo="assign";if(${${"GLOBALS"}["otmrsqfgxmjg"]}!=""&&${${"GLOBALS"}["frmicrftq"]}>2){${"GLOBALS"}["icwhmyrlubr"]="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND $p.note LIKE :note ";${${"GLOBALS"}["icwhmyrlubr"]}["note"]="%$note%";}${$uqtbpxxdyve}=htmlspecialchars(isset($_GET["auser"]))?$_GET["auser"]:"";if(${${"GLOBALS"}["wyooigqr"]}!=""){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND auser=:auser ";${${"GLOBALS"}["ccjlcdgqevb"]}["auser"]="$auser";}${${"GLOBALS"}["ifhhacsrxo"]}=htmlspecialchars(isset($_GET["assign"]))?$_GET["assign"]:"";if(${$crwblnjjbo}!=""){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND (assign=:assign) ";${${"GLOBALS"}["ccjlcdgqevb"]}["assign"]="$assign";}${${"GLOBALS"}["zxwelfk"]}=htmlspecialchars(isset($_GET["assignstatus"]))?$_GET["assignstatus"]:"";if(${${"GLOBALS"}["uygjcqtclkn"]}!=""){${"GLOBALS"}["dsewmlk"]="sqlsearch";${${"GLOBALS"}["dsewmlk"]}.=" AND (assignstatus=:assignstatus) ";${${"GLOBALS"}["ccjlcdgqevb"]}["assignstatus"]="$assignstatus";}${${"GLOBALS"}["xdgwmmu"]}=htmlspecialchars(isset($_GET["assigndetail"]))?$_GET["assigndetail"]:"";${$gnnwcd}=strlen(${${"GLOBALS"}["xdgwmmu"]});if(${${"GLOBALS"}["iknqximfdd"]}!=""&&${$trszorilck}>2){${"GLOBALS"}["iqkybeng"]="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND assigndetail LIKE :assigndetail ";${${"GLOBALS"}["iqkybeng"]}["assigndetail"]="%$assigndetail%";}${$ovnefsnopp}=$db->single("SELECT COUNT(*) FROM $p");$db->bindMore(${${"GLOBALS"}["mhyqpfqeqx"]});${${"GLOBALS"}["dlfvgvdkiyfm"]}=$db->single("SELECT COUNT(*) FROM $p
	LEFT JOIN users ON users.id=$p.auser
	LEFT JOIN assigns ON assigns.id=$p.assign
	$sqlsearch
	");$db->bindMore(${${"GLOBALS"}["pokogsn"]});${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT $p.id AS id,$p.name,$p.title,$p.phone,$p.email,$p.address,$p.date,$p.subject,$p.direction,$p.callback,$p.note,assigns.name AS assign,$p.assignstatus,$p.assignstart,$p.assignend,$p.assigndetail,$p.adate,$p.udate,users.name AS auser FROM $p
	LEFT JOIN users ON users.id=$p.auser
	LEFT JOIN assigns ON assigns.id=$p.assign
	$sqlsearch  ORDER BY $ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["fyesxkwry"]}=array("draw"=>${${"GLOBALS"}["njzrsmqnw"]},"recordsTotal"=>${${"GLOBALS"}["rtfuedx"]},"recordsFiltered"=>${${"GLOBALS"}["dtljwcspppz"]},"data"=>array());${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${$ngiqyovux} as${${"GLOBALS"}["rnolkxckcnx"]}){${"GLOBALS"}["jgqwitmmgrx"]="data";${${"GLOBALS"}["jgqwitmmgrx"]}[]=array("id"=>"$get->id","name"=>"$get->name","title"=>"$get->title","phone"=>"$get->phone","email"=>"$get->email","address"=>"$get->address","date"=>"$get->date","subject"=>"$get->subject","direction"=>"$get->direction","callback"=>"$get->callback","note"=>"$get->note","assign"=>"$get->assign","assignstatus"=>"$get->assignstatus","assignstart"=>"$get->assignstart","assignend"=>"$get->assignend","assigndetail"=>"$get->assigndetail","auser"=>"$get->auser","adate"=>"$get->adate","udate"=>"$get->udate");}${${"GLOBALS"}["fyesxkwry"]}["data"]=${$wqgbglorync};echo json_encode(${${"GLOBALS"}["uagmjjoeoa"]});}elseif(${$yvsyusafp}=="calls"&&${${"GLOBALS"}["avvvdluisi"]}=="calendar"){$juqhonylbtvi="datestart";${$juqhonylbtvi}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"01-01-2000";$wucxzqynxnos="dateend";$lxjvvcxq="datestart";$iuymlmckdcn="get";${${"GLOBALS"}["aktkbstp"]}=htmlspecialchars(isset($_GET["end"]))?$_GET["end"]:"01-01-2000";${"GLOBALS"}["yxskbpjemdv"]="datestart";$gsyygnkoot="data";${$lxjvvcxq}=date("Y-m-d 00:00:00",strtotime(${${"GLOBALS"}["yxskbpjemdv"]}));${${"GLOBALS"}["aktkbstp"]}=date("Y-m-d 23:59:59",strtotime(${$wucxzqynxnos}));$rcuykdvtkk="data";${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT id,date,name,subject FROM $p WHERE (date BETWEEN '$datestart' AND '$dateend')");${$gsyygnkoot}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${$iuymlmckdcn}){${"GLOBALS"}["skveucsx"]="data";${${"GLOBALS"}["skveucsx"]}[]=array("id"=>"$get->id","start"=>"$get->date","end"=>"$get->date","title"=>"$get->name - $get->subject");}echo json_encode(${$rcuykdvtkk});}elseif(${${"GLOBALS"}["vqxvmfs"]}=="calls"&&${${"GLOBALS"}["nbdujvcx"]}=="deleted"){${"GLOBALS"}["ucuohvxon"]="p";${"GLOBALS"}["qldujvzkgu"]="search";$xughqgvini="p";${"GLOBALS"}["dltmiub"]="p";${${"GLOBALS"}["njzrsmqnw"]}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";${${"GLOBALS"}["trnnikimudp"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${"GLOBALS"}["vjqqqiw"]="searchcount";${"GLOBALS"}["gkxwfgw"]="sqlarray";${"GLOBALS"}["thzxqowkrl"]="p";$emxrlqe="ordertable";${${"GLOBALS"}["yvpjlkpq"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${"GLOBALS"}["thuflr"]="searchcount";$yejmgzhwi="draw";${$emxrlqe}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";$ypxtdrhsek="p";${"GLOBALS"}["buplqpgdqs"]="recordcount";${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${${"GLOBALS"}["dqostybleq"]}]["data"];${${"GLOBALS"}["whfudgpdm"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${${"GLOBALS"}["hqdnrdjuit"]}="";${"GLOBALS"}["byzlzderl"]="data";$xthxupm="search";${"GLOBALS"}["laupqmavpunp"]="p";$vjgzfr="data";${"GLOBALS"}["ghvjwn"]="p";$gaznerwr="p";${${"GLOBALS"}["gkxwfgw"]}=array();${"GLOBALS"}["xetstcecgo"]="p";${"GLOBALS"}["phhwkndlfi"]="p";${"GLOBALS"}["nyynsczysmg"]="gets";${${"GLOBALS"}["qldujvzkgu"]}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${${"GLOBALS"}["thuflr"]}=strlen(${${"GLOBALS"}["ttiknyszrry"]});$nocoymnuwkig="p";if(${$xthxupm}!=""&&${${"GLOBALS"}["vjqqqiw"]}>2){$qkggjb="p";$pcpjvilvgd="p";$twpvsjigpmp="sqlarray";${"GLOBALS"}["qyobkhrhny"]="sqlarray";${"GLOBALS"}["ijbhmpgmjgu"]="sqlsearch";${${"GLOBALS"}["ijbhmpgmjgu"]}.=" WHERE (".${$pcpjvilvgd}."_delete.name LIKE :search1 OR ".${${"GLOBALS"}["cyucfo"]}."_delete.title LIKE :search2 OR ".${$qkggjb}."_delete.subject LIKE :search3 OR ".${${"GLOBALS"}["cyucfo"]}."_delete.note LIKE :search4) ";${${"GLOBALS"}["ccjlcdgqevb"]}["search1"]="%$search%";${${"GLOBALS"}["qyobkhrhny"]}["search2"]="%$search%";${$twpvsjigpmp}["search3"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search4"]="%$search%";}$zfzqhnpbepf="total";${${"GLOBALS"}["jvnlrcvwrj"]}=$db->single("SELECT COUNT(*) FROM ".${$ypxtdrhsek}."_delete");$kysscfonbf="p";$gdfvphi="p";$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${${"GLOBALS"}["dlfvgvdkiyfm"]}=$db->single("SELECT COUNT(*) FROM ".${${"GLOBALS"}["cyucfo"]}."_delete
	LEFT JOIN assigns ON assigns.id=".${${"GLOBALS"}["cyucfo"]}."_delete.assign
	LEFT JOIN users AS users1 ON users1.id=".${${"GLOBALS"}["cyucfo"]}."_delete.auser
	LEFT JOIN users AS users2 ON users2.id=".${${"GLOBALS"}["cyucfo"]}."_delete.duser
	$sqlsearch
	");$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${${"GLOBALS"}["nyynsczysmg"]}=$db->query("SELECT ".${$kysscfonbf}."_delete.id AS id,".${${"GLOBALS"}["ghvjwn"]}."_delete.name,".${$xughqgvini}."_delete.title,".${${"GLOBALS"}["ucuohvxon"]}."_delete.phone,".${${"GLOBALS"}["xetstcecgo"]}."_delete.email,".${${"GLOBALS"}["cyucfo"]}."_delete.address,".${${"GLOBALS"}["laupqmavpunp"]}."_delete.date,".${${"GLOBALS"}["cyucfo"]}."_delete.subject,".${$gaznerwr}."_delete.direction,".${${"GLOBALS"}["thzxqowkrl"]}."_delete.callback,".${${"GLOBALS"}["cyucfo"]}."_delete.note,assigns.name AS assign,".${${"GLOBALS"}["cyucfo"]}."_delete.assignstatus,".${${"GLOBALS"}["cyucfo"]}."_delete.assignstart,".${$nocoymnuwkig}."_delete.assignend,".${${"GLOBALS"}["cyucfo"]}."_delete.assigndetail,".${${"GLOBALS"}["cyucfo"]}."_delete.adate,".${${"GLOBALS"}["cyucfo"]}."_delete.udate,users1.name AS aname,ddate,users2.name AS dname FROM ".${${"GLOBALS"}["cyucfo"]}."_delete
	LEFT JOIN assigns ON assigns.id=".${${"GLOBALS"}["dltmiub"]}."_delete.assign
	LEFT JOIN users AS users1 ON users1.id=".${${"GLOBALS"}["phhwkndlfi"]}."_delete.auser
	LEFT JOIN users AS users2 ON users2.id=".${$gdfvphi}."_delete.duser
	$sqlsearch
	ORDER BY $ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["fyesxkwry"]}=array("draw"=>${$yejmgzhwi},"recordsTotal"=>${$zfzqhnpbepf},"recordsFiltered"=>${${"GLOBALS"}["buplqpgdqs"]},"data"=>array());${${"GLOBALS"}["byzlzderl"]}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${${"GLOBALS"}["rnolkxckcnx"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","name"=>"$get->name","title"=>"$get->title","phone"=>"$get->phone","email"=>"$get->email","address"=>"$get->address","date"=>"$get->date","subject"=>"$get->subject","direction"=>"$get->direction","callback"=>"$get->callback","note"=>"$get->note","assign"=>"$get->assign","assignstatus"=>"$get->assignstatus","assignstart"=>"$get->assignstart","assignend"=>"$get->assignend","assigndetail"=>"$get->assigndetail","auser"=>"$get->aname","adate"=>"$get->adate","duser"=>"$get->dname","ddate"=>"$get->ddate");}${${"GLOBALS"}["fyesxkwry"]}["data"]=${$vjgzfr};echo json_encode(${${"GLOBALS"}["fyesxkwry"]});}elseif(${${"GLOBALS"}["cyucfo"]}=="appointments"&&${${"GLOBALS"}["kptppnxdtfn"]}==""){$fvxrwrdwxvp="length";${"GLOBALS"}["yiwyuoqzrf"]="sqlarray";${${"GLOBALS"}["njzrsmqnw"]}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";${"GLOBALS"}["chcblyplkr"]="notify";${"GLOBALS"}["sqzoku"]="title";${$fvxrwrdwxvp}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${"GLOBALS"}["tmubqxemmwt"]="sqlsearch";${${"GLOBALS"}["yvpjlkpq"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${"GLOBALS"}["jkybkzd"]="sqlarray";$worvcywuh="title";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";$uobjigzucsfw="phonecount";${"GLOBALS"}["hpgpirtq"]="datestart";$rjcgihlfce="sqlarray";$bhwlckbie="gets";${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${${"GLOBALS"}["dqostybleq"]}]["data"];${${"GLOBALS"}["whfudgpdm"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${"GLOBALS"}["ngmuouc"]="name";$mpxvydfre="searchcount";${${"GLOBALS"}["hqdnrdjuit"]}=" WHERE 1 ";${"GLOBALS"}["vrlbtlhg"]="phonecount";${"GLOBALS"}["uhxqrkl"]="dateend";$maruovetqd="datestart";${"GLOBALS"}["yvzflkgcyqpi"]="namecount";${"GLOBALS"}["gykxwwo"]="searchcount";${${"GLOBALS"}["yiwyuoqzrf"]}=array();${${"GLOBALS"}["ttiknyszrry"]}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${$mpxvydfre}=strlen(${${"GLOBALS"}["ttiknyszrry"]});if(${${"GLOBALS"}["ttiknyszrry"]}!=""&&${${"GLOBALS"}["gykxwwo"]}>2){${"GLOBALS"}["vpylonlpjyo"]="sqlarray";${"GLOBALS"}["amisgyo"]="sqlarray";$rrptqddr="sqlarray";${${"GLOBALS"}["ecsggttd"]}=str_replace(" ","",${${"GLOBALS"}["ttiknyszrry"]});$_GET["datestart"]="";$_GET["dateend"]="";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND ($p.name LIKE :search1 OR $p.title LIKE :search2 OR $p.phone LIKE :search3 OR REPLACE($p.phone, ' ', '') LIKE :search4 OR $p.address LIKE :search5 OR $p.subject LIKE :search6 OR $p.note LIKE :search7) ";${${"GLOBALS"}["vpylonlpjyo"]}["search1"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search2"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search3"]="%$search%";${${"GLOBALS"}["amisgyo"]}["search4"]="%$searchspaces%";${$rrptqddr}["search5"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search6"]="%$search%";$dbttgqg="sqlarray";${$dbttgqg}["search7"]="%$search%";}${"GLOBALS"}["jfvlyrm"]="phone";${"GLOBALS"}["ppwxtwtuegj"]="titlecount";${$maruovetqd}=htmlspecialchars(isset($_GET["datestart"])&&$_GET["dateend"]!="")?$_GET["datestart"]:"01-01-2000";${${"GLOBALS"}["uhxqrkl"]}=htmlspecialchars(isset($_GET["dateend"])&&$_GET["dateend"]!="")?$_GET["dateend"]:"01-01-2030";${${"GLOBALS"}["hpgpirtq"]}=date("Y-m-d 00:00:00",strtotime(${${"GLOBALS"}["vdkgsrxonyb"]}));${${"GLOBALS"}["aktkbstp"]}=date("Y-m-d 23:59:59",strtotime(${${"GLOBALS"}["aktkbstp"]}));${${"GLOBALS"}["tmubqxemmwt"]}.=" AND (date BETWEEN :datestart AND :dateend) ";${${"GLOBALS"}["ccjlcdgqevb"]}["datestart"]="$datestart";${${"GLOBALS"}["ccjlcdgqevb"]}["dateend"]="$dateend";$ldxbabsrn="assign";${${"GLOBALS"}["udnmleshpo"]}=htmlspecialchars(isset($_GET["meet"]))?$_GET["meet"]:"";if(${${"GLOBALS"}["udnmleshpo"]}!=""){$hbjnxfrrqk="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND meet=:meet ";${$hbjnxfrrqk}["meet"]="$meet";}${"GLOBALS"}["rfddmgqs"]="subject";$fkqlogdesetq="address";${"GLOBALS"}["jcnxdhg"]="name";$hcpqvsmnmlqk="name";${${"GLOBALS"}["mfvfmwhyew"]}=htmlspecialchars(isset($_GET["notify"]))?$_GET["notify"]:"";if(${${"GLOBALS"}["chcblyplkr"]}!=""){$ovetmrpl="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND (notify=:notify) ";${$ovetmrpl}["notify"]="$notify";}${${"GLOBALS"}["jcnxdhg"]}=htmlspecialchars(isset($_GET["name"]))?$_GET["name"]:"";${"GLOBALS"}["ybmveioh"]="addresscount";${"GLOBALS"}["wiavkcnndj"]="address";${${"GLOBALS"}["eldndob"]}=strlen(${${"GLOBALS"}["ngmuouc"]});if(${$hcpqvsmnmlqk}!=""&&${${"GLOBALS"}["yvzflkgcyqpi"]}>2){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND appointments.name LIKE :name ";${${"GLOBALS"}["ccjlcdgqevb"]}["name"]="%$name%";}${$worvcywuh}=htmlspecialchars(isset($_GET["title"]))?$_GET["title"]:"";${"GLOBALS"}["rpdcpgpr"]="email";${${"GLOBALS"}["ppwxtwtuegj"]}=strlen(${${"GLOBALS"}["jnzpcxke"]});${"GLOBALS"}["wsvwcja"]="subjectcount";if(${${"GLOBALS"}["sqzoku"]}!=""&&${${"GLOBALS"}["qniqcjc"]}>2){$krvcmoi="sqlsearch";${$krvcmoi}.=" AND title LIKE :title ";${${"GLOBALS"}["ccjlcdgqevb"]}["title"]="%$title%";}${${"GLOBALS"}["jfvlyrm"]}=htmlspecialchars(isset($_GET["phone"]))?$_GET["phone"]:"";${${"GLOBALS"}["vrlbtlhg"]}=strlen(${${"GLOBALS"}["gzmntmwjk"]});$yqlcnwin="assigndetail";if(${${"GLOBALS"}["gzmntmwjk"]}!=""&&${$uobjigzucsfw}>2){${"GLOBALS"}["wvseejffn"]="sqlsearch";${"GLOBALS"}["onqloox"]="sqlarray";${${"GLOBALS"}["wvseejffn"]}.=" AND $p.phone LIKE :phone ";${${"GLOBALS"}["onqloox"]}["phone"]="%$phone%";}${${"GLOBALS"}["lopcwjq"]}=htmlspecialchars(isset($_GET["email"]))?$_GET["email"]:"";${${"GLOBALS"}["eivjaiwixck"]}=strlen(${${"GLOBALS"}["rpdcpgpr"]});if(${${"GLOBALS"}["lopcwjq"]}!=""&&${${"GLOBALS"}["eivjaiwixck"]}>2){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND $p.email LIKE :email ";${${"GLOBALS"}["ccjlcdgqevb"]}["email"]="%$email%";}${${"GLOBALS"}["wiavkcnndj"]}=htmlspecialchars(isset($_GET["address"]))?$_GET["address"]:"";${${"GLOBALS"}["ngxokz"]}=strlen(${${"GLOBALS"}["xmusldygol"]});if(${$fkqlogdesetq}!=""&&${${"GLOBALS"}["ybmveioh"]}>2){${"GLOBALS"}["hxdlojiywr"]="sqlsearch";${${"GLOBALS"}["hxdlojiywr"]}.=" AND $p.address LIKE :address ";${${"GLOBALS"}["ccjlcdgqevb"]}["address"]="%$address%";}${"GLOBALS"}["rguyklep"]="assigndetailcount";${${"GLOBALS"}["xxnofvqjzevs"]}=htmlspecialchars(isset($_GET["subject"]))?$_GET["subject"]:"";$fnsueedywvt="auser";${"GLOBALS"}["bspttrywj"]="total";${${"GLOBALS"}["zmsytofy"]}=strlen(${${"GLOBALS"}["xxnofvqjzevs"]});$ucqawewbn="draw";if(${${"GLOBALS"}["rfddmgqs"]}!=""&&${${"GLOBALS"}["wsvwcja"]}>2){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND subject LIKE :subject ";${${"GLOBALS"}["ccjlcdgqevb"]}["subject"]="%$subject%";}${${"GLOBALS"}["otmrsqfgxmjg"]}=htmlspecialchars(isset($_GET["note"]))?$_GET["note"]:"";${"GLOBALS"}["sxsqxcwbvoo"]="notecount";${${"GLOBALS"}["frmicrftq"]}=strlen(${${"GLOBALS"}["otmrsqfgxmjg"]});$qrxujdy="total";if(${${"GLOBALS"}["otmrsqfgxmjg"]}!=""&&${${"GLOBALS"}["sxsqxcwbvoo"]}>2){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND note LIKE :note ";$fsluupyz="sqlarray";${$fsluupyz}["note"]="%$note%";}${$fnsueedywvt}=htmlspecialchars(isset($_GET["auser"]))?$_GET["auser"]:"";if(${${"GLOBALS"}["wyooigqr"]}!=""){$xirjaefnjrcp="sqlsearch";${$xirjaefnjrcp}.=" AND auser=:auser ";${${"GLOBALS"}["ccjlcdgqevb"]}["auser"]="$auser";}${$ldxbabsrn}=htmlspecialchars(isset($_GET["assign"]))?$_GET["assign"]:"";if(${${"GLOBALS"}["ifhhacsrxo"]}!=""){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND (assign=:assign) ";${${"GLOBALS"}["ccjlcdgqevb"]}["assign"]="$assign";}${"GLOBALS"}["dvjiqgszvfe"]="recordcount";${${"GLOBALS"}["uygjcqtclkn"]}=htmlspecialchars(isset($_GET["assignstatus"]))?$_GET["assignstatus"]:"";if(${${"GLOBALS"}["uygjcqtclkn"]}!=""){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND (assignstatus=:assignstatus) ";${"GLOBALS"}["rndfwl"]="sqlarray";${${"GLOBALS"}["rndfwl"]}["assignstatus"]="$assignstatus";}${"GLOBALS"}["svspoihn"]="assigndetailcount";${$yqlcnwin}=htmlspecialchars(isset($_GET["assigndetail"]))?$_GET["assigndetail"]:"";${${"GLOBALS"}["svspoihn"]}=strlen(${${"GLOBALS"}["xdgwmmu"]});if(${${"GLOBALS"}["xdgwmmu"]}!=""&&${${"GLOBALS"}["rguyklep"]}>2){${"GLOBALS"}["kcmyklmzhqjl"]="sqlarray";${"GLOBALS"}["hzcuwvw"]="sqlsearch";${${"GLOBALS"}["hzcuwvw"]}.=" AND assigndetail LIKE :assigndetail ";${${"GLOBALS"}["kcmyklmzhqjl"]}["assigndetail"]="%$assigndetail%";}${${"GLOBALS"}["bspttrywj"]}=$db->single("SELECT COUNT(*) FROM $p");$db->bindMore(${$rjcgihlfce});${${"GLOBALS"}["dvjiqgszvfe"]}=$db->single("SELECT COUNT(*) FROM $p
	LEFT JOIN assigns ON assigns.id=$p.assign
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch
	");$db->bindMore(${${"GLOBALS"}["jkybkzd"]});${"GLOBALS"}["ckotaqggr"]="data";${$bhwlckbie}=$db->query("SELECT $p.id AS id,$p.name,$p.title,$p.phone,$p.email,$p.address,$p.date,$p.subject,$p.meet,$p.notify,$p.note,$p.assignstatus,$p.assignstart,$p.assignend,$p.assigndetail,$p.adate,$p.udate,assigns.name AS assign,users.name AS auser FROM $p
	LEFT JOIN assigns ON assigns.id=$p.assign
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch  ORDER BY $ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["fyesxkwry"]}=array("draw"=>${$ucqawewbn},"recordsTotal"=>${$qrxujdy},"recordsFiltered"=>${${"GLOBALS"}["dlfvgvdkiyfm"]},"data"=>array());${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${${"GLOBALS"}["rnolkxckcnx"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","name"=>"$get->name","title"=>"$get->title","phone"=>"$get->phone","email"=>"$get->email","address"=>"$get->address","date"=>"$get->date","subject"=>"$get->subject","meet"=>"$get->meet","notify"=>"$get->notify","note"=>"$get->note","assign"=>"$get->assign","assignstatus"=>"$get->assignstatus","assignstart"=>"$get->assignstart","assignend"=>"$get->assignend","assigndetail"=>"$get->assigndetail","auser"=>"$get->auser","adate"=>"$get->adate","udate"=>"$get->udate");}${${"GLOBALS"}["fyesxkwry"]}["data"]=${${"GLOBALS"}["ckotaqggr"]};echo json_encode(${${"GLOBALS"}["fyesxkwry"]});}elseif(${$wyzjlwam}=="appointments"&&${${"GLOBALS"}["rtbhtssu"]}=="calendar"){${${"GLOBALS"}["vdkgsrxonyb"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"01-01-2000";${${"GLOBALS"}["aktkbstp"]}=htmlspecialchars(isset($_GET["end"]))?$_GET["end"]:"01-01-2000";${${"GLOBALS"}["vdkgsrxonyb"]}=date("Y-m-d 00:00:00",strtotime(${${"GLOBALS"}["vdkgsrxonyb"]}));${${"GLOBALS"}["aktkbstp"]}=date("Y-m-d 23:59:59",strtotime(${${"GLOBALS"}["aktkbstp"]}));${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT id,date,name,subject FROM appointments WHERE (date BETWEEN '$datestart' AND '$dateend')");${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${${"GLOBALS"}["rnolkxckcnx"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","start"=>"$get->date","end"=>"$get->date","title"=>"$get->name - $get->subject");}echo json_encode(${${"GLOBALS"}["oahevqvtz"]});}elseif(${$hlnywwuxpl}=="appointments"&&${${"GLOBALS"}["xcxrmqvbz"]}=="deleted"){${"GLOBALS"}["rxeeeacyu"]="sqlarray";${"GLOBALS"}["sdbhudxqy"]="p";$lqrvgvumqgi="draw";${"GLOBALS"}["rwhticump"]="p";$kctfkqlgv="ordertable";$yaycbwjc="p";${"GLOBALS"}["ryzdpvmtpq"]="start";${"GLOBALS"}["dyncutspppy"]="output";${"GLOBALS"}["ibqdbudreyup"]="ordertable";$qribqbgvs="p";$wvqlwwzjbk="search";${"GLOBALS"}["lvdjlxobno"]="data";$rymmtxzskpni="p";${$lqrvgvumqgi}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";${"GLOBALS"}["ipzmbqoguf"]="search";${"GLOBALS"}["anyrxrkff"]="p";${${"GLOBALS"}["trnnikimudp"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${${"GLOBALS"}["ryzdpvmtpq"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${$kctfkqlgv}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";${"GLOBALS"}["kqkjbpekj"]="p";${"GLOBALS"}["bxerfiwsrk"]="sqlsearch";${"GLOBALS"}["ovajazzvut"]="p";${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${${"GLOBALS"}["ibqdbudreyup"]}]["data"];$gvjbuvi="p";${${"GLOBALS"}["whfudgpdm"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${"GLOBALS"}["hubmhaxu"]="recordcount";${${"GLOBALS"}["bxerfiwsrk"]}="";$shtewfretrb="total";${"GLOBALS"}["rcblfhjupom"]="p";${${"GLOBALS"}["ccjlcdgqevb"]}=array();${$wvqlwwzjbk}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${${"GLOBALS"}["ekrlomnxft"]}=strlen(${${"GLOBALS"}["ttiknyszrry"]});if(${${"GLOBALS"}["ipzmbqoguf"]}!=""&&${${"GLOBALS"}["ekrlomnxft"]}>2){${"GLOBALS"}["fvuibwbkkh"]="p";$gxtfkbavos="p";$aehamuskfc="p";${"GLOBALS"}["pskzxoyzu"]="sqlarray";$pwghdnensig="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" WHERE (".${${"GLOBALS"}["fvuibwbkkh"]}."_delete.name LIKE :search1 OR ".${$gxtfkbavos}."_delete.title LIKE :search2 OR ".${${"GLOBALS"}["cyucfo"]}."_delete.subject LIKE :search3 OR ".${$aehamuskfc}."_delete.assigndetail LIKE :search4) ";${${"GLOBALS"}["pskzxoyzu"]}["search1"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search2"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search3"]="%$search%";${$pwghdnensig}["search4"]="%$search%";}$ccioogd="draw";$wcqulcejk="sqlarray";${"GLOBALS"}["ymboncc"]="p";${$shtewfretrb}=$db->single("SELECT COUNT(*) FROM ".${${"GLOBALS"}["cyucfo"]}."_delete");$db->bindMore(${$wcqulcejk});${${"GLOBALS"}["hubmhaxu"]}=$db->single("SELECT COUNT(*) FROM ".${$gvjbuvi}."_delete
	LEFT JOIN assigns ON assigns.id=".${${"GLOBALS"}["cyucfo"]}."_delete.assign
	LEFT JOIN users AS users1 ON users1.id=".${$yaycbwjc}."_delete.auser
	LEFT JOIN users AS users2 ON users2.id=".${${"GLOBALS"}["anyrxrkff"]}."_delete.duser
	$sqlsearch
	");${"GLOBALS"}["anvghldr"]="p";$db->bindMore(${${"GLOBALS"}["rxeeeacyu"]});${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT ".${${"GLOBALS"}["ymboncc"]}."_delete.id AS id,".${${"GLOBALS"}["cyucfo"]}."_delete.name,".${${"GLOBALS"}["ovajazzvut"]}."_delete.title,".${${"GLOBALS"}["sdbhudxqy"]}."_delete.phone,".${${"GLOBALS"}["cyucfo"]}."_delete.email,".${${"GLOBALS"}["anvghldr"]}."_delete.address,".${${"GLOBALS"}["cyucfo"]}."_delete.date,".${${"GLOBALS"}["cyucfo"]}."_delete.subject,".${${"GLOBALS"}["cyucfo"]}."_delete.meet,".${${"GLOBALS"}["kqkjbpekj"]}."_delete.notify,".${${"GLOBALS"}["rwhticump"]}."_delete.note,assigns.name AS assign,".${${"GLOBALS"}["cyucfo"]}."_delete.assignstatus,".${${"GLOBALS"}["cyucfo"]}."_delete.assignstart,".${${"GLOBALS"}["cyucfo"]}."_delete.assignend,".${${"GLOBALS"}["cyucfo"]}."_delete.assigndetail,".${${"GLOBALS"}["rcblfhjupom"]}."_delete.adate,".${${"GLOBALS"}["cyucfo"]}."_delete.udate,users1.name AS aname,ddate,users2.name AS dname FROM appointments_delete
	LEFT JOIN assigns ON assigns.id=".${${"GLOBALS"}["cyucfo"]}."_delete.assign
	LEFT JOIN users AS users1 ON users1.id=".${$rymmtxzskpni}."_delete.auser
	LEFT JOIN users AS users2 ON users2.id=".${$qribqbgvs}."_delete.duser
	$sqlsearch
	ORDER BY $ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["dyncutspppy"]}=array("draw"=>${$ccioogd},"recordsTotal"=>${${"GLOBALS"}["jvnlrcvwrj"]},"recordsFiltered"=>${${"GLOBALS"}["dlfvgvdkiyfm"]},"data"=>array());${${"GLOBALS"}["lvdjlxobno"]}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${${"GLOBALS"}["rnolkxckcnx"]}){$dmdqgy="data";${$dmdqgy}[]=array("id"=>"$get->id","name"=>"$get->name","title"=>"$get->title","phone"=>"$get->phone","email"=>"$get->email","address"=>"$get->address","date"=>"$get->date","subject"=>"$get->subject","meet"=>"$get->meet","notify"=>"$get->notify","note"=>"$get->note","assign"=>"$get->assign","assignstatus"=>"$get->assignstatus","assignstart"=>"$get->assignstart","assignend"=>"$get->assignend","assigndetail"=>"$get->assigndetail","auser"=>"$get->aname","adate"=>"$get->adate","duser"=>"$get->dname","ddate"=>"$get->ddate");}${${"GLOBALS"}["fyesxkwry"]}["data"]=${${"GLOBALS"}["oahevqvtz"]};echo json_encode(${${"GLOBALS"}["fyesxkwry"]});}elseif(${${"GLOBALS"}["jnqtgrqehuk"]}=="invitations"&&${${"GLOBALS"}["mmuhcmvg"]}==""){$cydewpegs="note";${${"GLOBALS"}["njzrsmqnw"]}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";${"GLOBALS"}["iqisegntanpr"]="sqlarray";${"GLOBALS"}["sweqmjacbw"]="search";${"GLOBALS"}["dbiskfdj"]="ordersort";$sejbbwzngln="length";$ekrehnuhoy="namecount";${"GLOBALS"}["miybqri"]="start";${$sejbbwzngln}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${"GLOBALS"}["npxtbowwbza"]="datestart";$zsieexo="ordertable";${"GLOBALS"}["ycfvczgegqu"]="searchcount";$aldwhju="assigndetail";${"GLOBALS"}["uhhutsxjy"]="dateend";$leuxxsict="sqlarray";${"GLOBALS"}["qukuyfv"]="notecount";$uncdqvwizov="type";$rfnvhpyhcf="sqlarray";${"GLOBALS"}["eefhrpyzyom"]="callback";${"GLOBALS"}["tivfwa"]="datestart";$udsdsby="phone";${"GLOBALS"}["pkmqbwpfp"]="subjectcount";$owewchnui="searchcount";${${"GLOBALS"}["miybqri"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${"GLOBALS"}["wgqbnvq"]="ordertable";${"GLOBALS"}["rnelsj"]="subject";${${"GLOBALS"}["wgqbnvq"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";$osfsgqwtds="callback";$ltgnjqfmm="search";$krddiudhq="type";${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${$zsieexo}]["data"];${${"GLOBALS"}["dbiskfdj"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";$oedqylyhobz="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}=" WHERE 1 ";$hhjvesn="organizationcount";$doecuaxwb="subject";${$oedqylyhobz}=array();${"GLOBALS"}["ikkxedrof"]="search";$qsafjyesso="sqlarray";${$ltgnjqfmm}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${"GLOBALS"}["wwjrvxjcdby"]="data";${$owewchnui}=strlen(${${"GLOBALS"}["ikkxedrof"]});if(${${"GLOBALS"}["sweqmjacbw"]}!=""&&${${"GLOBALS"}["ycfvczgegqu"]}>2){$eimrcqb="sqlarray";$cgxlndkrudvd="sqlarray";$myoontjsbyy="sqlarray";${${"GLOBALS"}["ecsggttd"]}=str_replace(" ","",${${"GLOBALS"}["ttiknyszrry"]});$_GET["datestart"]="";${"GLOBALS"}["efzhktykestq"]="sqlarray";$_GET["dateend"]="";${"GLOBALS"}["uhzwmpsegvt"]="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND ($p.name LIKE :search1 OR $p.subject LIKE :search2 OR $p.organization LIKE :search3 OR $p.address LIKE :search4 OR $p.phone LIKE :search5 OR REPLACE($p.phone, ' ', '') LIKE :search6 OR $p.note LIKE :search7 ) ";${$eimrcqb}["search1"]="%$search%";${${"GLOBALS"}["uhzwmpsegvt"]}["search2"]="%$search%";${$myoontjsbyy}["search3"]="%$search%";$iidhvkvj="sqlarray";${${"GLOBALS"}["ccjlcdgqevb"]}["search4"]="%$search%";${$iidhvkvj}["search5"]="%$search%";${${"GLOBALS"}["efzhktykestq"]}["search6"]="%$searchspaces%";${$cgxlndkrudvd}["search7"]="%$search%";}${"GLOBALS"}["qaiorcqtkh"]="output";${${"GLOBALS"}["vdkgsrxonyb"]}=htmlspecialchars(isset($_GET["datestart"])&&$_GET["dateend"]!="")?$_GET["datestart"]:"01-01-2000";${${"GLOBALS"}["aktkbstp"]}=htmlspecialchars(isset($_GET["dateend"])&&$_GET["dateend"]!="")?$_GET["dateend"]:"01-01-2030";${${"GLOBALS"}["npxtbowwbza"]}=date("Y-m-d 00:00:00",strtotime(${${"GLOBALS"}["tivfwa"]}));${${"GLOBALS"}["uhhutsxjy"]}=date("Y-m-d 23:59:59",strtotime(${${"GLOBALS"}["aktkbstp"]}));${${"GLOBALS"}["hqdnrdjuit"]}.=" AND ((datestart BETWEEN :datestart AND :dateend) OR (dateend BETWEEN :datestart2 AND :dateend2) OR (:datestart3 BETWEEN datestart AND dateend) OR (:dateend3 BETWEEN datestart AND dateend)) ";${$rfnvhpyhcf}["datestart"]="$datestart";${${"GLOBALS"}["iqisegntanpr"]}["dateend"]="$dateend";$nxoybwyff="organization";${${"GLOBALS"}["ccjlcdgqevb"]}["datestart2"]="$datestart";${"GLOBALS"}["kgjpclcbxm"]="gets";$ydnrkv="notecount";${${"GLOBALS"}["ccjlcdgqevb"]}["dateend2"]="$dateend";$lzupflt="name";${$qsafjyesso}["datestart3"]="$datestart";${"GLOBALS"}["jrfkkghf"]="address";${$leuxxsict}["dateend3"]="$datestart";$myqxlpy="addresscount";${$krddiudhq}=htmlspecialchars(isset($_GET["type"]))?$_GET["type"]:"";if(${$uncdqvwizov}!=""){${"GLOBALS"}["eduueqn"]="sqlarray";$ilmidcsecaz="sqlsearch";${$ilmidcsecaz}.=" AND type=:type ";${${"GLOBALS"}["eduueqn"]}["type"]="$type";}${${"GLOBALS"}["eefhrpyzyom"]}=htmlspecialchars(isset($_GET["callback"]))?$_GET["callback"]:"";if(${$osfsgqwtds}!=""){${"GLOBALS"}["bouilsnmxzp"]="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND callback=:callback ";${${"GLOBALS"}["bouilsnmxzp"]}["callback"]="$callback";}${"GLOBALS"}["pwwjyhskxw"]="address";${${"GLOBALS"}["wdpgwbzfvazf"]}=htmlspecialchars(isset($_GET["attend"]))?$_GET["attend"]:"";if(${${"GLOBALS"}["wdpgwbzfvazf"]}!=""){$derozoec="sqlsearch";${$derozoec}.=" AND attend=:attend ";${${"GLOBALS"}["ccjlcdgqevb"]}["attend"]="$attend";}${${"GLOBALS"}["imvelcfmwb"]}=htmlspecialchars(isset($_GET["gift"]))?$_GET["gift"]:"";$xdnsdtjtc="name";$geondanwql="phonecount";if(${${"GLOBALS"}["imvelcfmwb"]}!=""){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND gift=:gift ";${${"GLOBALS"}["ccjlcdgqevb"]}["gift"]="$gift";}${"GLOBALS"}["tmyxmbdgztl"]="assigndetail";${"GLOBALS"}["nwphpmy"]="phone";${$lzupflt}=htmlspecialchars(isset($_GET["name"]))?$_GET["name"]:"";${$ekrehnuhoy}=strlen(${$xdnsdtjtc});if(${${"GLOBALS"}["uynormyg"]}!=""&&${${"GLOBALS"}["eldndob"]}>2){$mfuuwmomrw="sqlsearch";$mqneqih="sqlarray";${$mfuuwmomrw}.=" AND invitations.name LIKE :name ";${$mqneqih}["name"]="%$name%";}${$doecuaxwb}=htmlspecialchars(isset($_GET["subject"]))?$_GET["subject"]:"";${"GLOBALS"}["wcdbpqunc"]="subjectcount";$yvdvanjbc="phonecount";${${"GLOBALS"}["pkmqbwpfp"]}=strlen(${${"GLOBALS"}["rnelsj"]});if(${${"GLOBALS"}["xxnofvqjzevs"]}!=""&&${${"GLOBALS"}["wcdbpqunc"]}>2){${"GLOBALS"}["npmsweuxsy"]="sqlsearch";$orynqwhoun="sqlarray";${${"GLOBALS"}["npmsweuxsy"]}.=" AND subject LIKE :subject ";${$orynqwhoun}["subject"]="%$subject%";}${${"GLOBALS"}["osiihdsb"]}=htmlspecialchars(isset($_GET["organization"]))?$_GET["organization"]:"";${${"GLOBALS"}["djcbfqjotvox"]}=strlen(${${"GLOBALS"}["osiihdsb"]});if(${$nxoybwyff}!=""&&${$hhjvesn}>2){${"GLOBALS"}["qziexnb"]="sqlsearch";${"GLOBALS"}["rvwvlw"]="sqlarray";${${"GLOBALS"}["qziexnb"]}.=" AND organization LIKE :organization ";${${"GLOBALS"}["rvwvlw"]}["organization"]="%$organization%";}${${"GLOBALS"}["pwwjyhskxw"]}=htmlspecialchars(isset($_GET["address"]))?$_GET["address"]:"";${$myqxlpy}=strlen(${${"GLOBALS"}["xmusldygol"]});if(${${"GLOBALS"}["jrfkkghf"]}!=""&&${${"GLOBALS"}["ngxokz"]}>2){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND address LIKE :address ";${${"GLOBALS"}["ccjlcdgqevb"]}["address"]="%$address%";}${${"GLOBALS"}["nwphpmy"]}=htmlspecialchars(isset($_GET["phone"]))?$_GET["phone"]:"";$krvdunghsvgw="recordcount";${$geondanwql}=strlen(${$udsdsby});if(${${"GLOBALS"}["gzmntmwjk"]}!=""&&${$yvdvanjbc}>2){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND $p.phone LIKE :phone ";${${"GLOBALS"}["ccjlcdgqevb"]}["phone"]="%$phone%";}$kjtvqduvv="assignstatus";${$cydewpegs}=htmlspecialchars(isset($_GET["note"]))?$_GET["note"]:"";${$ydnrkv}=strlen(${${"GLOBALS"}["otmrsqfgxmjg"]});if(${${"GLOBALS"}["otmrsqfgxmjg"]}!=""&&${${"GLOBALS"}["qukuyfv"]}>2){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND note LIKE :note ";${${"GLOBALS"}["ccjlcdgqevb"]}["note"]="%$note%";}${${"GLOBALS"}["wyooigqr"]}=htmlspecialchars(isset($_GET["auser"]))?$_GET["auser"]:"";if(${${"GLOBALS"}["wyooigqr"]}!=""){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND auser=:auser ";${${"GLOBALS"}["ccjlcdgqevb"]}["auser"]="$auser";}${"GLOBALS"}["eamgeyblg"]="assigndetailcount";${${"GLOBALS"}["ifhhacsrxo"]}=htmlspecialchars(isset($_GET["assign"]))?$_GET["assign"]:"";if(${${"GLOBALS"}["ifhhacsrxo"]}!=""){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND (assign=:assign) ";${${"GLOBALS"}["ccjlcdgqevb"]}["assign"]="$assign";}$ybfphaxmjbr="output";${${"GLOBALS"}["uygjcqtclkn"]}=htmlspecialchars(isset($_GET["assignstatus"]))?$_GET["assignstatus"]:"";if(${$kjtvqduvv}!=""){${"GLOBALS"}["mppohnwlq"]="sqlsearch";${${"GLOBALS"}["mppohnwlq"]}.=" AND (assignstatus=:assignstatus) ";${${"GLOBALS"}["ccjlcdgqevb"]}["assignstatus"]="$assignstatus";}${$aldwhju}=htmlspecialchars(isset($_GET["assigndetail"]))?$_GET["assigndetail"]:"";${${"GLOBALS"}["eamgeyblg"]}=strlen(${${"GLOBALS"}["tmyxmbdgztl"]});if(${${"GLOBALS"}["xdgwmmu"]}!=""&&${${"GLOBALS"}["qeqnimwr"]}>2){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND assigndetail LIKE :assigndetail ";${${"GLOBALS"}["ccjlcdgqevb"]}["assigndetail"]="%$assigndetail%";}${${"GLOBALS"}["jvnlrcvwrj"]}=$db->single("SELECT COUNT(*) FROM $p");$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${${"GLOBALS"}["dlfvgvdkiyfm"]}=$db->single("SELECT COUNT(*) FROM $p
	LEFT JOIN invitations_type ON invitations_type.id=$p.type
	LEFT JOIN assigns ON assigns.id=$p.assign
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch
	");$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT $p.id AS id,$p.name,$p.subject,$p.organization,$p.address,$p.phone,$p.datestart,$p.dateend,$p.callback,$p.attend,$p.gift,$p.note,$p.assignstatus,$p.assignstart,$p.assignend,$p.assigndetail,$p.adate,$p.udate,invitations_type.name AS type,users.name AS aname,assigns.name AS assign FROM $p
	LEFT JOIN invitations_type ON invitations_type.id=$p.type
	LEFT JOIN assigns ON assigns.id=$p.assign
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch  ORDER BY $ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["qaiorcqtkh"]}=array("draw"=>${${"GLOBALS"}["njzrsmqnw"]},"recordsTotal"=>${${"GLOBALS"}["jvnlrcvwrj"]},"recordsFiltered"=>${$krvdunghsvgw},"data"=>array());${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${${"GLOBALS"}["kgjpclcbxm"]} as${${"GLOBALS"}["rnolkxckcnx"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","name"=>"$get->name","subject"=>"$get->subject","organization"=>"$get->organization","type"=>"$get->type","address"=>"$get->address","phone"=>"$get->phone","datestart"=>"$get->datestart","dateend"=>"$get->dateend","callback"=>"$get->callback","attend"=>"$get->attend","gift"=>"$get->gift","note"=>"$get->note","assign"=>"$get->assign","assignstatus"=>"$get->assignstatus","assignstart"=>"$get->assignstart","assignend"=>"$get->assignend","assigndetail"=>"$get->assigndetail","auser"=>"$get->aname","adate"=>"$get->adate","udate"=>"$get->udate");}${${"GLOBALS"}["fyesxkwry"]}["data"]=${${"GLOBALS"}["wwjrvxjcdby"]};echo json_encode(${$ybfphaxmjbr});}elseif(${${"GLOBALS"}["cyucfo"]}=="invitations"&&${${"GLOBALS"}["xcxrmqvbz"]}=="calendar"){$mrzulkeqhhf="data";${"GLOBALS"}["lnhbfkrdra"]="datestart";${"GLOBALS"}["gwjoikokeuy"]="gets";${${"GLOBALS"}["lnhbfkrdra"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"01-01-2000";$vsibiho="dateend";${${"GLOBALS"}["aktkbstp"]}=htmlspecialchars(isset($_GET["end"]))?$_GET["end"]:"01-01-2000";${${"GLOBALS"}["vdkgsrxonyb"]}=date("Y-m-d 00:00:00",strtotime(${${"GLOBALS"}["vdkgsrxonyb"]}));${$vsibiho}=date("Y-m-d 23:59:59",strtotime(${${"GLOBALS"}["aktkbstp"]}));${${"GLOBALS"}["gwjoikokeuy"]}=$db->query("SELECT id,datestart,dateend,name,subject FROM invitations WHERE (datestart BETWEEN '$datestart' AND '$dateend') OR (dateend BETWEEN '$datestart' AND '$dateend')");${$mrzulkeqhhf}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${${"GLOBALS"}["rnolkxckcnx"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","start"=>"$get->datestart","end"=>"$get->dateend","title"=>"$get->name - $get->subject");}echo json_encode(${${"GLOBALS"}["oahevqvtz"]});}elseif(${$stuvyzyb}=="invitations"&&${${"GLOBALS"}["xcxrmqvbz"]}=="deleted"){$pxwxutrsdgnr="p";$wjqnaoeukfe="p";$goyoocb="sqlarray";${"GLOBALS"}["lxnebpjxwm"]="start";$zragsbaghq="draw";${"GLOBALS"}["jonsyrcvwblr"]="searchcount";$zijmid="total";${"GLOBALS"}["izopnrajrvc"]="search";${$zragsbaghq}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";$cnxchqdvj="p";${"GLOBALS"}["rktpsswcsqt"]="p";$hkvcdx="ordertable";$agjgexhzd="p";${${"GLOBALS"}["trnnikimudp"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";$flrgidlv="p";${"GLOBALS"}["diyhnrxh"]="p";${"GLOBALS"}["gyhfpatfrik"]="p";$jbkwvxgot="p";${${"GLOBALS"}["lxnebpjxwm"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";$hlfiei="ordertable";${"GLOBALS"}["fobpikddts"]="ordersort";${"GLOBALS"}["igmvqlgy"]="p";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";$tcrgifqfkl="p";$wifeblnlefeg="recordcount";${"GLOBALS"}["pvsrosjzt"]="draw";${"GLOBALS"}["zpbqfqnulf"]="p";${$hlfiei}=$_GET["columns"][${$hkvcdx}]["data"];$mzzvzdh="p";${${"GLOBALS"}["fobpikddts"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${"GLOBALS"}["jtqcacuc"]="search";$ymjjfimaerv="data";${"GLOBALS"}["evqmeebim"]="p";${${"GLOBALS"}["hqdnrdjuit"]}="";${${"GLOBALS"}["ccjlcdgqevb"]}=array();${${"GLOBALS"}["jtqcacuc"]}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${"GLOBALS"}["tdmjfnlc"]="gets";${${"GLOBALS"}["ekrlomnxft"]}=strlen(${${"GLOBALS"}["izopnrajrvc"]});if(${${"GLOBALS"}["ttiknyszrry"]}!=""&&${${"GLOBALS"}["jonsyrcvwblr"]}>2){${"GLOBALS"}["nhtfbqe"]="sqlsearch";${"GLOBALS"}["ujdfwqeyzlli"]="sqlarray";$drrxuntku="p";$zrpehsp="p";$aasvxrdekr="sqlarray";${"GLOBALS"}["rzcqbtehdxgl"]="sqlarray";$xkpngqclei="p";${${"GLOBALS"}["nhtfbqe"]}.=" WHERE (".${${"GLOBALS"}["cyucfo"]}."_delete.name LIKE :search1 OR ".${${"GLOBALS"}["cyucfo"]}."_delete.subject LIKE :search2 OR ".${$drrxuntku}."_delete.organization LIKE :search3 OR ".${$zrpehsp}."_delete.note LIKE :search4 OR ".${${"GLOBALS"}["cyucfo"]}."_delete.note LIKE :search5 OR ".${$xkpngqclei}."_delete.assigndetail LIKE :search6) ";${${"GLOBALS"}["ccjlcdgqevb"]}["search1"]="%$search%";${${"GLOBALS"}["rzcqbtehdxgl"]}["search2"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search3"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search4"]="%$search%";${${"GLOBALS"}["ujdfwqeyzlli"]}["search5"]="%$search%";${$aasvxrdekr}["search6"]="%$search%";}$pxzwvdjxz="p";$pmonul="p";${"GLOBALS"}["uhtnwncpohhz"]="p";${${"GLOBALS"}["jvnlrcvwrj"]}=$db->single("SELECT COUNT(*) FROM ".${${"GLOBALS"}["cyucfo"]}."_delete");$db->bindMore(${$goyoocb});${$wifeblnlefeg}=$db->single("SELECT COUNT(*) FROM invitations_delete
	LEFT JOIN invitations_type ON invitations_type.id=".${${"GLOBALS"}["cyucfo"]}."_delete.type
	LEFT JOIN assigns ON assigns.id=".${${"GLOBALS"}["igmvqlgy"]}."_delete.assign
	LEFT JOIN users AS users1 ON users1.id=".${$mzzvzdh}."_delete.auser
	LEFT JOIN users AS users2 ON users2.id=".${$cnxchqdvj}."_delete.duser
	$sqlsearch
	");$emjkcxeecy="p";$hegyinvj="p";${"GLOBALS"}["kalaefeh"]="p";$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${${"GLOBALS"}["tdmjfnlc"]}=$db->query("SELECT ".${${"GLOBALS"}["rktpsswcsqt"]}."_delete.id AS id,".${$flrgidlv}."_delete.name,".${$pmonul}."_delete.subject,".${${"GLOBALS"}["cyucfo"]}."_delete.organization,".${${"GLOBALS"}["evqmeebim"]}."_delete.address,".${$wjqnaoeukfe}."_delete.phone,".${${"GLOBALS"}["kalaefeh"]}."_delete.datestart,".${${"GLOBALS"}["gyhfpatfrik"]}."_delete.dateend,".${$jbkwvxgot}."_delete.callback,".${${"GLOBALS"}["cyucfo"]}."_delete.attend,".${$tcrgifqfkl}."_delete.gift,".${$hegyinvj}."_delete.note,".${${"GLOBALS"}["zpbqfqnulf"]}."_delete.assignstatus,".${${"GLOBALS"}["cyucfo"]}."_delete.assignstart,".${$pxzwvdjxz}."_delete.assignend,".${$agjgexhzd}."_delete.assigndetail,".${$emjkcxeecy}."_delete.adate,".${${"GLOBALS"}["uhtnwncpohhz"]}."_delete.ddate,invitations_type.name AS type,users1.name AS aname,users2.name AS dname,assigns.name AS assign  FROM ".${$pxwxutrsdgnr}."_delete
	LEFT JOIN invitations_type ON invitations_type.id=invitations_delete.type
	LEFT JOIN assigns ON assigns.id=".${${"GLOBALS"}["diyhnrxh"]}."_delete.assign
	LEFT JOIN users AS users1 ON users1.id=invitations_delete.auser
	LEFT JOIN users AS users2 ON users2.id=invitations_delete.duser
	$sqlsearch
	ORDER BY $ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["fyesxkwry"]}=array("draw"=>${${"GLOBALS"}["pvsrosjzt"]},"recordsTotal"=>${$zijmid},"recordsFiltered"=>${${"GLOBALS"}["dlfvgvdkiyfm"]},"data"=>array());${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${${"GLOBALS"}["rnolkxckcnx"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","name"=>"$get->name","subject"=>"$get->subject","organization"=>"$get->organization","type"=>"$get->type","address"=>"$get->address","phone"=>"$get->phone","datestart"=>"$get->datestart","dateend"=>"$get->dateend","callback"=>"$get->callback","attend"=>"$get->attend","gift"=>"$get->gift","note"=>"$get->note","assign"=>"$get->assign","assignstatus"=>"$get->assignstatus","assignstart"=>"$get->assignstart","assignend"=>"$get->assignend","assigndetail"=>"$get->assigndetail","auser"=>"$get->aname","adate"=>"$get->adate","duser"=>"$get->dname","ddate"=>"$get->ddate");}${${"GLOBALS"}["fyesxkwry"]}["data"]=${$ymjjfimaerv};echo json_encode(${${"GLOBALS"}["fyesxkwry"]});}elseif(${${"GLOBALS"}["cyucfo"]}=="invitations"&&${${"GLOBALS"}["xcxrmqvbz"]}=="organization"){${"GLOBALS"}["odgbmrdalhoe"]="gets";${"GLOBALS"}["uvvtqbrpjbf"]="gets";${${"GLOBALS"}["uxehnnfrcp"]}=htmlspecialchars(isset($_GET["query"]))?$_GET["query"]:"";${"GLOBALS"}["fooecfkq"]="gets";$mcoiyr="count";${${"GLOBALS"}["uvvtqbrpjbf"]}=$db->query("SELECT DISTINCT $m FROM $p WHERE $m LIKE :add ORDER BY id DESC  LIMIT 10",array("add"=>"%$query%"));${$mcoiyr}=count(${${"GLOBALS"}["fooecfkq"]});foreach(${${"GLOBALS"}["odgbmrdalhoe"]} as${${"GLOBALS"}["rnolkxckcnx"]}){${${"GLOBALS"}["oahevqvtz"]}["suggestions"][]=$get->organization;}if(${${"GLOBALS"}["htcglx"]}!="0"){echo json_encode(${${"GLOBALS"}["oahevqvtz"]});}}elseif(${${"GLOBALS"}["cyucfo"]}=="invitations"&&${${"GLOBALS"}["xcxrmqvbz"]}=="address"){$iuvhtnk="gets";${${"GLOBALS"}["uxehnnfrcp"]}=htmlspecialchars(isset($_GET["query"]))?$_GET["query"]:"";${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT DISTINCT $m FROM $p WHERE $m LIKE :add ORDER BY id DESC  LIMIT 10",array("add"=>"%$query%"));${${"GLOBALS"}["htcglx"]}=count(${$iuvhtnk});foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${${"GLOBALS"}["rnolkxckcnx"]}){${${"GLOBALS"}["oahevqvtz"]}["suggestions"][]=$get->address;}if(${${"GLOBALS"}["htcglx"]}!="0"){echo json_encode(${${"GLOBALS"}["oahevqvtz"]});}}elseif(${${"GLOBALS"}["cyucfo"]}=="visits"&&${${"GLOBALS"}["xcxrmqvbz"]}==""){${"GLOBALS"}["sbxyyidcrq"]="datestart";$sptcdyq="length";$zxpsdqe="title";${${"GLOBALS"}["njzrsmqnw"]}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";$awfqicvme="phone";$jtgijed="dateend";${"GLOBALS"}["fyzbpsscsnb"]="total";${"GLOBALS"}["gicrohlhxu"]="sqlsearch";${"GLOBALS"}["vtehcreb"]="dateend";${"GLOBALS"}["zizxwei"]="name";${"GLOBALS"}["sdnjemo"]="name";${"GLOBALS"}["ihrttvymshf"]="assignstatus";${"GLOBALS"}["vwetev"]="ordertable";${"GLOBALS"}["kawmwrms"]="ordertable";$fjckieud="ordersort";${"GLOBALS"}["nbiqnherjm"]="title";${$sptcdyq}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${${"GLOBALS"}["yvpjlkpq"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";$xjzpiostfsi="searchcount";$ghdklgeggy="name";${${"GLOBALS"}["kawmwrms"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";${"GLOBALS"}["jrxpyd"]="visit";${"GLOBALS"}["mercqcogz"]="assigndetailcount";${"GLOBALS"}["yyesfbfpwoi"]="visit";${${"GLOBALS"}["vwetev"]}=$_GET["columns"][${${"GLOBALS"}["dqostybleq"]}]["data"];${$fjckieud}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";$rlprgt="phone";$jjvpjn="assignstatus";${"GLOBALS"}["kdhgrkes"]="dateend";$msmmou="output";${${"GLOBALS"}["gicrohlhxu"]}=" WHERE 1 ";${${"GLOBALS"}["ccjlcdgqevb"]}=array();${"GLOBALS"}["pkdaihdnfycm"]="gets";${"GLOBALS"}["hxigbvp"]="datestart";$wkumehrp="sqlarray";${"GLOBALS"}["xgebquji"]="subjectcount";$eylgocvj="note";$gdlgojyysr="subject";${${"GLOBALS"}["ttiknyszrry"]}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${"GLOBALS"}["rmsrbqid"]="subjectcount";${"GLOBALS"}["vrewvkxuhy"]="namecount";${${"GLOBALS"}["ekrlomnxft"]}=strlen(${${"GLOBALS"}["ttiknyszrry"]});$mhxsmhs="phone";${"GLOBALS"}["yxjsxp"]="data";$shfkmvlsoq="notecount";if(${${"GLOBALS"}["ttiknyszrry"]}!=""&&${$xjzpiostfsi}>2){$qoojgxjji="searchspaces";${"GLOBALS"}["prwolrfsof"]="search";$euclkuserex="sqlarray";$gijjjvqm="sqlarray";$qurqppehca="sqlarray";${$qoojgxjji}=str_replace(" ","",${${"GLOBALS"}["prwolrfsof"]});$mwqvemlmkwq="sqlarray";$_GET["datestart"]="";$_GET["dateend"]="";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND ($p.name LIKE :search1 OR $p.title LIKE :search2 OR $p.phone LIKE :search3 OR REPLACE($p.phone, ' ', '') LIKE :search4 OR $p.address LIKE :search5 OR $p.subject LIKE :search6 OR $p.note LIKE :search7) ";${$mwqvemlmkwq}["search1"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search2"]="%$search%";${$euclkuserex}["search3"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search4"]="%$searchspaces%";${$qurqppehca}["search5"]="%$search%";${$gijjjvqm}["search6"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search7"]="%$search%";}${${"GLOBALS"}["hxigbvp"]}=htmlspecialchars(isset($_GET["datestart"])&&$_GET["dateend"]!="")?$_GET["datestart"]:"01-01-2000";${$jtgijed}=htmlspecialchars(isset($_GET["dateend"])&&$_GET["dateend"]!="")?$_GET["dateend"]:"01-01-2030";${${"GLOBALS"}["vdkgsrxonyb"]}=date("Y-m-d 00:00:00",strtotime(${${"GLOBALS"}["sbxyyidcrq"]}));${${"GLOBALS"}["kdhgrkes"]}=date("Y-m-d 23:59:59",strtotime(${${"GLOBALS"}["vtehcreb"]}));$hgopqap="address";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND (date BETWEEN :datestart AND :dateend) ";${${"GLOBALS"}["ccjlcdgqevb"]}["datestart"]="$datestart";${"GLOBALS"}["qqajopr"]="output";${$wkumehrp}["dateend"]="$dateend";${${"GLOBALS"}["yyesfbfpwoi"]}=htmlspecialchars(isset($_GET["visit"]))?$_GET["visit"]:"";if(${${"GLOBALS"}["jrxpyd"]}!=""){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND visit=:visit ";${${"GLOBALS"}["ccjlcdgqevb"]}["visit"]="$visit";}${"GLOBALS"}["slnlncmdqdd"]="auser";${"GLOBALS"}["mpevbdwdvi"]="email";$czjfyjdwa="sqlarray";${${"GLOBALS"}["aawviwx"]}=htmlspecialchars(isset($_GET["type"]))?$_GET["type"]:"";${"GLOBALS"}["wyvmkioi"]="recordcount";if(${${"GLOBALS"}["aawviwx"]}!=""){$roamoqz="sqlsearch";${"GLOBALS"}["giejtemkrr"]="sqlarray";${$roamoqz}.=" AND (type=:type) ";${${"GLOBALS"}["giejtemkrr"]}["type"]="$type";}${$ghdklgeggy}=htmlspecialchars(isset($_GET["name"]))?$_GET["name"]:"";${${"GLOBALS"}["eldndob"]}=strlen(${${"GLOBALS"}["sdnjemo"]});if(${${"GLOBALS"}["zizxwei"]}!=""&&${${"GLOBALS"}["vrewvkxuhy"]}>2){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND visits.name LIKE :name ";${${"GLOBALS"}["ccjlcdgqevb"]}["name"]="%$name%";}$riacjkxwbl="recordcount";${"GLOBALS"}["ebkbdkbqi"]="subject";$gqqlipvm="title";$hcsuhct="notecount";${${"GLOBALS"}["nbiqnherjm"]}=htmlspecialchars(isset($_GET["title"]))?$_GET["title"]:"";${${"GLOBALS"}["qniqcjc"]}=strlen(${$zxpsdqe});if(${$gqqlipvm}!=""&&${${"GLOBALS"}["qniqcjc"]}>2){${"GLOBALS"}["xebzclb"]="sqlsearch";${${"GLOBALS"}["xebzclb"]}.=" AND title LIKE :title ";${${"GLOBALS"}["ccjlcdgqevb"]}["title"]="%$title%";}${$mhxsmhs}=htmlspecialchars(isset($_GET["phone"]))?$_GET["phone"]:"";${${"GLOBALS"}["klndrknrfs"]}=strlen(${$awfqicvme});if(${$rlprgt}!=""&&${${"GLOBALS"}["klndrknrfs"]}>2){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND $p.phone LIKE :phone ";${${"GLOBALS"}["ccjlcdgqevb"]}["phone"]="%$phone%";}${${"GLOBALS"}["lopcwjq"]}=htmlspecialchars(isset($_GET["email"]))?$_GET["email"]:"";${${"GLOBALS"}["eivjaiwixck"]}=strlen(${${"GLOBALS"}["mpevbdwdvi"]});if(${${"GLOBALS"}["lopcwjq"]}!=""&&${${"GLOBALS"}["eivjaiwixck"]}>2){${"GLOBALS"}["gteduvht"]="sqlsearch";${${"GLOBALS"}["gteduvht"]}.=" AND $p.email LIKE :email ";${${"GLOBALS"}["ccjlcdgqevb"]}["email"]="%$email%";}${"GLOBALS"}["uqfywlna"]="note";$pbdjpgl="assigndetail";${${"GLOBALS"}["xmusldygol"]}=htmlspecialchars(isset($_GET["address"]))?$_GET["address"]:"";${${"GLOBALS"}["ngxokz"]}=strlen(${${"GLOBALS"}["xmusldygol"]});if(${$hgopqap}!=""&&${${"GLOBALS"}["ngxokz"]}>2){$hcovbvyiv="sqlsearch";$nvlnbuccuqr="sqlarray";${$hcovbvyiv}.=" AND $p.address LIKE :address ";${$nvlnbuccuqr}["address"]="%$address%";}${${"GLOBALS"}["xxnofvqjzevs"]}=htmlspecialchars(isset($_GET["subject"]))?$_GET["subject"]:"";${${"GLOBALS"}["rmsrbqid"]}=strlen(${$gdlgojyysr});if(${${"GLOBALS"}["ebkbdkbqi"]}!=""&&${${"GLOBALS"}["xgebquji"]}>2){$vvvhuc="sqlsearch";$kxfkreskj="sqlarray";${$vvvhuc}.=" AND subject LIKE :subject ";${$kxfkreskj}["subject"]="%$subject%";}${${"GLOBALS"}["otmrsqfgxmjg"]}=htmlspecialchars(isset($_GET["note"]))?$_GET["note"]:"";${$shfkmvlsoq}=strlen(${$eylgocvj});${"GLOBALS"}["lhsqiux"]="gets";if(${${"GLOBALS"}["uqfywlna"]}!=""&&${$hcsuhct}>2){${"GLOBALS"}["irrwajyj"]="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND note LIKE :note ";${${"GLOBALS"}["irrwajyj"]}["note"]="%$note%";}${${"GLOBALS"}["wyooigqr"]}=htmlspecialchars(isset($_GET["auser"]))?$_GET["auser"]:"";if(${${"GLOBALS"}["slnlncmdqdd"]}!=""){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND auser=:auser ";${${"GLOBALS"}["ccjlcdgqevb"]}["auser"]="$auser";}${"GLOBALS"}["xkunqayslib"]="assigndetailcount";${${"GLOBALS"}["ifhhacsrxo"]}=htmlspecialchars(isset($_GET["assign"]))?$_GET["assign"]:"";if(${${"GLOBALS"}["ifhhacsrxo"]}!=""){${"GLOBALS"}["sfyidklwsws"]="sqlsearch";${${"GLOBALS"}["sfyidklwsws"]}.=" AND (assign=:assign) ";${${"GLOBALS"}["ccjlcdgqevb"]}["assign"]="$assign";}${$jjvpjn}=htmlspecialchars(isset($_GET["assignstatus"]))?$_GET["assignstatus"]:"";if(${${"GLOBALS"}["ihrttvymshf"]}!=""){${"GLOBALS"}["uxtnfou"]="sqlsearch";$xhzgtg="sqlarray";${${"GLOBALS"}["uxtnfou"]}.=" AND (assignstatus=:assignstatus) ";${$xhzgtg}["assignstatus"]="$assignstatus";}${${"GLOBALS"}["xdgwmmu"]}=htmlspecialchars(isset($_GET["assigndetail"]))?$_GET["assigndetail"]:"";${${"GLOBALS"}["xkunqayslib"]}=strlen(${${"GLOBALS"}["xdgwmmu"]});if(${$pbdjpgl}!=""&&${${"GLOBALS"}["mercqcogz"]}>2){$sjsiwesly="sqlsearch";${$sjsiwesly}.=" AND assigndetail LIKE :assigndetail ";$zqdogkiyf="sqlarray";${$zqdogkiyf}["assigndetail"]="%$assigndetail%";}${${"GLOBALS"}["fyzbpsscsnb"]}=$db->single("SELECT COUNT(*) FROM $p");$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${${"GLOBALS"}["wyvmkioi"]}=$db->single("SELECT COUNT(*) FROM $p
	LEFT JOIN visits_type ON visits_type.id=$p.type
	LEFT JOIN assigns ON assigns.id=$p.assign
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch
	");$db->bindMore(${$czjfyjdwa});${${"GLOBALS"}["pkdaihdnfycm"]}=$db->query("SELECT $p.id AS id,$p.name,$p.title,$p.phone,$p.email,$p.address,$p.date,$p.subject,$p.visit,$p.note,$p.assignstatus,$p.assignstart,$p.assignend,$p.assigndetail,$p.adate,$p.udate,visits_type.name AS type,users.name AS aname,assigns.name AS asname FROM $p
	LEFT JOIN visits_type ON visits_type.id=$p.type
	LEFT JOIN assigns ON assigns.id=$p.assign
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch  ORDER BY $ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["fyesxkwry"]}=array("draw"=>${${"GLOBALS"}["njzrsmqnw"]},"recordsTotal"=>${${"GLOBALS"}["jvnlrcvwrj"]},"recordsFiltered"=>${$riacjkxwbl},"data"=>array());${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${${"GLOBALS"}["lhsqiux"]} as${${"GLOBALS"}["rnolkxckcnx"]}){${"GLOBALS"}["gutgvgiyvvf"]="data";${${"GLOBALS"}["gutgvgiyvvf"]}[]=array("id"=>"$get->id","name"=>"$get->name","title"=>"$get->title","phone"=>"$get->phone","email"=>"$get->email","address"=>"$get->address","date"=>"$get->date","type"=>"$get->type","subject"=>"$get->subject","visit"=>"$get->visit","note"=>"$get->note","assign"=>"$get->asname","assignstatus"=>"$get->assignstatus","assignstart"=>"$get->assignstart","assignend"=>"$get->assignend","assigndetail"=>"$get->assigndetail","auser"=>"$get->aname","adate"=>"$get->adate","udate"=>"$get->udate");}${$msmmou}["data"]=${${"GLOBALS"}["yxjsxp"]};echo json_encode(${${"GLOBALS"}["qqajopr"]});}elseif(${${"GLOBALS"}["lvcgpsixu"]}=="visits"&&${${"GLOBALS"}["xcxrmqvbz"]}=="calendar"){$infues="datestart";${${"GLOBALS"}["vdkgsrxonyb"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"01-01-2000";${${"GLOBALS"}["aktkbstp"]}=htmlspecialchars(isset($_GET["end"]))?$_GET["end"]:"01-01-2000";${"GLOBALS"}["feazpy"]="datestart";$snnicpbapxqo="gets";${"GLOBALS"}["mnemvou"]="data";${${"GLOBALS"}["feazpy"]}=date("Y-m-d 00:00:00",strtotime(${$infues}));${"GLOBALS"}["teuecyruds"]="get";${${"GLOBALS"}["aktkbstp"]}=date("Y-m-d 23:59:59",strtotime(${${"GLOBALS"}["aktkbstp"]}));${$snnicpbapxqo}=$db->query("SELECT id,date,name,subject FROM visits WHERE (date BETWEEN '$datestart' AND '$dateend')");${${"GLOBALS"}["mnemvou"]}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${${"GLOBALS"}["teuecyruds"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","start"=>"$get->date","end"=>"$get->date","title"=>"$get->name - $get->subject");}echo json_encode(${${"GLOBALS"}["oahevqvtz"]});}elseif(${${"GLOBALS"}["udzqtj"]}=="visits"&&${${"GLOBALS"}["fchwmxeak"]}=="deleted"){$ogeoicmykqs="searchcount";$jzmsuxf="p";${"GLOBALS"}["wbbekkwaeem"]="output";${"GLOBALS"}["foeobhma"]="search";$ysxvwvpjhgdl="total";${"GLOBALS"}["bqourzxzmsg"]="p";$izqljb="p";$rkapjpsf="ordertable";${"GLOBALS"}["veehttxypuv"]="output";${"GLOBALS"}["aqvqva"]="search";${${"GLOBALS"}["njzrsmqnw"]}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";$cccqtemicg="p";$ksxzar="data";${"GLOBALS"}["icjyvpdfpto"]="length";${${"GLOBALS"}["icjyvpdfpto"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${"GLOBALS"}["nnqdjphv"]="draw";${"GLOBALS"}["yfniufw"]="sqlsearch";${${"GLOBALS"}["yvpjlkpq"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${$rkapjpsf}]["data"];${"GLOBALS"}["sysepmbqfxb"]="sqlarray";${"GLOBALS"}["tnagzdxllx"]="data";${${"GLOBALS"}["whfudgpdm"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";$bpwmdrhs="p";$yllxqgkcbh="p";${${"GLOBALS"}["yfniufw"]}="";${${"GLOBALS"}["sysepmbqfxb"]}=array();$ojgtpvcmt="gets";${"GLOBALS"}["zkuwolu"]="p";${${"GLOBALS"}["aqvqva"]}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${${"GLOBALS"}["ekrlomnxft"]}=strlen(${${"GLOBALS"}["foeobhma"]});if(${${"GLOBALS"}["ttiknyszrry"]}!=""&&${$ogeoicmykqs}>2){$wejwhulj="p";$pxhvzcknmks="p";${"GLOBALS"}["hjapyqlrjey"]="sqlarray";$mhuxleq="sqlarray";${"GLOBALS"}["jycxjm"]="sqlarray";$eabdqvj="p";${${"GLOBALS"}["hqdnrdjuit"]}.=" WHERE (".${$wejwhulj}."_delete.name LIKE :search1 OR ".${${"GLOBALS"}["cyucfo"]}."_delete.title LIKE :search2 OR ".${$eabdqvj}."_delete.subject LIKE :search3 OR ".${$pxhvzcknmks}."_delete.note LIKE :search4 OR ".${${"GLOBALS"}["cyucfo"]}."_delete.assigndetail LIKE :search5) ";$ycdrijf="sqlarray";${${"GLOBALS"}["jycxjm"]}["search1"]="%$search%";${$ycdrijf}["search2"]="%$search%";${$mhuxleq}["search3"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search4"]="%$search%";${${"GLOBALS"}["hjapyqlrjey"]}["search5"]="%$search%";}$wifoykhk="p";${${"GLOBALS"}["jvnlrcvwrj"]}=$db->single("SELECT COUNT(*) FROM ".${$cccqtemicg}."_delete");$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${${"GLOBALS"}["dlfvgvdkiyfm"]}=$db->single("SELECT COUNT(*) FROM ".${${"GLOBALS"}["cyucfo"]}."_delete
	LEFT JOIN types ON types.id=".${${"GLOBALS"}["cyucfo"]}."_delete.type
	LEFT JOIN assigns ON assigns.id=".${${"GLOBALS"}["bqourzxzmsg"]}."_delete.assign
	LEFT JOIN users AS users1 ON users1.id=visits_delete.auser
	LEFT JOIN users AS users2 ON users2.id=visits_delete.duser
	$sqlsearch
	");$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT ".${${"GLOBALS"}["cyucfo"]}."_delete.id AS id,".${$izqljb}."_delete.name,".${${"GLOBALS"}["cyucfo"]}."_delete.title,".${$jzmsuxf}."_delete.phone,".${${"GLOBALS"}["cyucfo"]}."_delete.email,".${${"GLOBALS"}["cyucfo"]}."_delete.address,".${${"GLOBALS"}["cyucfo"]}."_delete.date,".${${"GLOBALS"}["cyucfo"]}."_delete.subject,".${$bpwmdrhs}."_delete.visit,".${${"GLOBALS"}["cyucfo"]}."_delete.note,".${${"GLOBALS"}["zkuwolu"]}."_delete.assignstatus,".${${"GLOBALS"}["cyucfo"]}."_delete.assignstart,".${${"GLOBALS"}["cyucfo"]}."_delete.assignend,".${$yllxqgkcbh}."_delete.assigndetail,adate,ddate,visits_type.name AS type,users1.name AS aname,users2.name AS dname,assigns.name AS asname FROM ".${$wifoykhk}."_delete
	LEFT JOIN visits_type ON visits_type.id=visits_delete.type
	LEFT JOIN assigns ON assigns.id=".${${"GLOBALS"}["cyucfo"]}."_delete.assign
	LEFT JOIN users AS users1 ON users1.id=visits_delete.auser
	LEFT JOIN users AS users2 ON users2.id=visits_delete.duser
	$sqlsearch
	ORDER BY $ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["fyesxkwry"]}=array("draw"=>${${"GLOBALS"}["nnqdjphv"]},"recordsTotal"=>${$ysxvwvpjhgdl},"recordsFiltered"=>${${"GLOBALS"}["dlfvgvdkiyfm"]},"data"=>array());${$ksxzar}=array();foreach(${$ojgtpvcmt} as${${"GLOBALS"}["rnolkxckcnx"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","name"=>"$get->name","title"=>"$get->title","phone"=>"$get->phone","email"=>"$get->email","address"=>"$get->address","date"=>"$get->date","type"=>"$get->type","subject"=>"$get->subject","visit"=>"$get->visit","note"=>"$get->note","assign"=>"$get->asname","assignstatus"=>"$get->assignstatus","assignstart"=>"$get->assignstart","assignend"=>"$get->assignend","assigndetail"=>"$get->assigndetail","auser"=>"$get->aname","adate"=>"$get->adate","duser"=>"$get->dname","ddate"=>"$get->ddate");}${${"GLOBALS"}["wbbekkwaeem"]}["data"]=${${"GLOBALS"}["tnagzdxllx"]};echo json_encode(${${"GLOBALS"}["veehttxypuv"]});}elseif(${${"GLOBALS"}["vunlrsgmz"]}=="visits_type"){}elseif(${${"GLOBALS"}["esftkef"]}=="funerals"&&${$ungtgrkro}==""){$hupdflvcshb="name";$nwvbqip="draw";$lheeccdxrr="sqlsearch";${"GLOBALS"}["wsamfyzy"]="start";${$nwvbqip}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";$nccptsbejew="ordertable";${${"GLOBALS"}["trnnikimudp"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${"GLOBALS"}["fciqjiodwo"]="recordcount";${"GLOBALS"}["sqbzpr"]="callstatus";${"GLOBALS"}["jlencbuy"]="auser";$kuuliyztekwu="ordersort";${${"GLOBALS"}["wsamfyzy"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${"GLOBALS"}["gtzsvgcdiak"]="sqlarray";${"GLOBALS"}["qqpypsol"]="total";${"GLOBALS"}["tyzxguufw"]="relativecount";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";$vyjtmosfzfye="sqlsearch";${"GLOBALS"}["oinmpx"]="relative";$cttwgbrgdg="output";${"GLOBALS"}["hztccdvvqq"]="dateend";${"GLOBALS"}["tvuteqjytti"]="sqlarray";$jsopefg="searchcount";${$nccptsbejew}=$_GET["columns"][${${"GLOBALS"}["dqostybleq"]}]["data"];${$kuuliyztekwu}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${$vyjtmosfzfye}=" WHERE ";${${"GLOBALS"}["ccjlcdgqevb"]}=array();$elhivmyo="dateend";$wvfifbsbv="datestart";${${"GLOBALS"}["vdkgsrxonyb"]}=htmlspecialchars(isset($_GET["datestart"])&&$_GET["dateend"]!="")?$_GET["datestart"]:"01-01-2000";${${"GLOBALS"}["hztccdvvqq"]}=htmlspecialchars(isset($_GET["dateend"])&&$_GET["dateend"]!="")?$_GET["dateend"]:"01-01-2030";${$wvfifbsbv}=date("Y-m-d",strtotime(${${"GLOBALS"}["vdkgsrxonyb"]}));${"GLOBALS"}["rjyqxalwg"]="callstatus";${${"GLOBALS"}["aktkbstp"]}=date("Y-m-d",strtotime(${$elhivmyo}));${$lheeccdxrr}.=" (date BETWEEN :datestart AND :dateend) ";${${"GLOBALS"}["tvuteqjytti"]}["datestart"]="$datestart";$csfedxubhu="gets";${${"GLOBALS"}["ccjlcdgqevb"]}["dateend"]="$dateend";${${"GLOBALS"}["sqbzpr"]}=htmlspecialchars(isset($_GET["callstatus"]))?$_GET["callstatus"]:"";if(${${"GLOBALS"}["rjyqxalwg"]}!=""){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND (callstatus=:callstatus) ";${${"GLOBALS"}["ccjlcdgqevb"]}["callstatus"]="$callstatus";}${$hupdflvcshb}=htmlspecialchars(isset($_GET["name"]))?$_GET["name"]:"";${${"GLOBALS"}["eldndob"]}=strlen(${${"GLOBALS"}["uynormyg"]});if(${${"GLOBALS"}["uynormyg"]}!=""&&${${"GLOBALS"}["eldndob"]}>2){${"GLOBALS"}["uokwuuxniz"]="sqlsearch";${${"GLOBALS"}["uokwuuxniz"]}.=" AND $p.name LIKE :name ";${${"GLOBALS"}["ccjlcdgqevb"]}["name"]="%$name%";}${"GLOBALS"}["ptzbchhnvr"]="output";$ijvakdkj="get";$jsooyasb="draw";${${"GLOBALS"}["yygbtcmjbe"]}=htmlspecialchars(isset($_GET["relative"]))?$_GET["relative"]:"";${${"GLOBALS"}["vlajhtvsoit"]}=strlen(${${"GLOBALS"}["oinmpx"]});${"GLOBALS"}["akspdkwrufq"]="search";if(${${"GLOBALS"}["yygbtcmjbe"]}!=""&&${${"GLOBALS"}["tyzxguufw"]}>2){$htdesr="sqlsearch";${$htdesr}.=" AND relative LIKE :relative ";${${"GLOBALS"}["ccjlcdgqevb"]}["relative"]="%$relative%";}${${"GLOBALS"}["wyooigqr"]}=htmlspecialchars(isset($_GET["auser"]))?$_GET["auser"]:"";if(${${"GLOBALS"}["jlencbuy"]}!=""){$nvxxrxhy="sqlsearch";${$nvxxrxhy}.=" AND auser=:auser ";${${"GLOBALS"}["ccjlcdgqevb"]}["auser"]="$auser";}$itpcxgjau="search";${${"GLOBALS"}["ttiknyszrry"]}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${$jsopefg}=strlen(${$itpcxgjau});if(${${"GLOBALS"}["akspdkwrufq"]}!=""&&${${"GLOBALS"}["ekrlomnxft"]}>2){${"GLOBALS"}["lgmivjvd"]="sqlarray";$cnxvhfcgwlbj="sqlsearch";${$cnxvhfcgwlbj}.=" AND ($p.name LIKE :search1 OR relative LIKE :search2 OR address LIKE :search3) ";$ohljeuwsm="sqlarray";${${"GLOBALS"}["lgmivjvd"]}["search1"]="%$search%";${$ohljeuwsm}["search2"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search3"]="%$search%";}${${"GLOBALS"}["qqpypsol"]}=$db->single("SELECT COUNT(*) FROM $p");$omljheobg="recordcount";$db->bindMore(${${"GLOBALS"}["gtzsvgcdiak"]});${${"GLOBALS"}["fciqjiodwo"]}=$db->single("SELECT COUNT(*) FROM $p
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch
	");$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${$csfedxubhu}=$db->query("SELECT $p.id AS id,$p.date,$p.name,$p.address,$p.relative,$p.phone,$p.callstatus,adate,udate,users.name AS aname FROM $p
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch  ORDER BY $ordertable $ordersort LIMIT $start,$length");$yykqgbtmx="total";${${"GLOBALS"}["fyesxkwry"]}=array("draw"=>${$jsooyasb},"recordsTotal"=>${$yykqgbtmx},"recordsFiltered"=>${$omljheobg},"data"=>array());${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${$ijvakdkj}){$xepwaqb="data";${$xepwaqb}[]=array("id"=>"$get->id","date"=>"$get->date","name"=>"$get->name","address"=>"$get->address","relative"=>"$get->relative","phone"=>"$get->phone","callstatus"=>"$get->callstatus","auser"=>"$get->aname","adate"=>"$get->adate","udate"=>"$get->udate");}${$cttwgbrgdg}["data"]=${${"GLOBALS"}["oahevqvtz"]};echo json_encode(${${"GLOBALS"}["ptzbchhnvr"]});}elseif(${${"GLOBALS"}["cyucfo"]}=="funerals"&&${${"GLOBALS"}["xcxrmqvbz"]}=="calendar"){$rqdjmzdn="gets";${"GLOBALS"}["dxcyacbmmh"]="dateend";$ruooowckqnwm="get";$itkdykscprib="datestart";${"GLOBALS"}["nhkflogwlu"]="dateend";${$itkdykscprib}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"01-01-2000";${${"GLOBALS"}["nhkflogwlu"]}=htmlspecialchars(isset($_GET["end"]))?$_GET["end"]:"01-01-2000";${${"GLOBALS"}["vdkgsrxonyb"]}=date("Y-m-d",strtotime(${${"GLOBALS"}["vdkgsrxonyb"]}));${${"GLOBALS"}["dxcyacbmmh"]}=date("Y-m-d",strtotime(${${"GLOBALS"}["aktkbstp"]}));${$rqdjmzdn}=$db->query("SELECT id,date,name,relative FROM funerals WHERE (date BETWEEN '$datestart' AND '$dateend')");${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${$ruooowckqnwm}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","start"=>"$get->date","end"=>"$get->date","title"=>"$get->name - $get->relative");}echo json_encode(${${"GLOBALS"}["oahevqvtz"]});}elseif(${${"GLOBALS"}["xemgog"]}=="funerals"&&${${"GLOBALS"}["xcxrmqvbz"]}=="deleted"){${"GLOBALS"}["cuhxdsr"]="gets";${"GLOBALS"}["ggozkfvb"]="recordcount";$suljxr="ordertable";${${"GLOBALS"}["njzrsmqnw"]}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";$zpplipzuaskz="sqlarray";${${"GLOBALS"}["trnnikimudp"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";$llqdwvtrhmwi="searchcount";${${"GLOBALS"}["yvpjlkpq"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${"GLOBALS"}["vwllfoyvwpev"]="data";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";$cpqwtxyrqv="ordertable";${"GLOBALS"}["mnpgiwmi"]="search";$qayiebax="output";$ryiiabmnqae="data";${$suljxr}=$_GET["columns"][${$cpqwtxyrqv}]["data"];$bzvlngw="recordcount";$bqakgnn="sqlsearch";${${"GLOBALS"}["whfudgpdm"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";$xnkmcsocgfbo="searchcount";${$bqakgnn}="";${${"GLOBALS"}["ccjlcdgqevb"]}=array();${${"GLOBALS"}["ttiknyszrry"]}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${$llqdwvtrhmwi}=strlen(${${"GLOBALS"}["ttiknyszrry"]});if(${${"GLOBALS"}["mnpgiwmi"]}!=""&&${$xnkmcsocgfbo}>2){$xymsjrtcl="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" WHERE (funerals_delete.name LIKE :search1 OR relative LIKE :search2 OR address LIKE :search3) ";${$xymsjrtcl}["search1"]="%$search%";${"GLOBALS"}["mxgympqow"]="sqlarray";${${"GLOBALS"}["mxgympqow"]}["search2"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search3"]="%$search%";}$bavnwsh="output";${${"GLOBALS"}["jvnlrcvwrj"]}=$db->single("SELECT COUNT(*) FROM funerals_delete");$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${"GLOBALS"}["oqnkiti"]="total";${$bzvlngw}=$db->single("SELECT COUNT(*) FROM funerals_delete
	LEFT JOIN users AS users1 ON users1.id=funerals_delete.auser
	LEFT JOIN users AS users2 ON users2.id=funerals_delete.duser
	$sqlsearch
	");$popebplwgfs="draw";$db->bindMore(${$zpplipzuaskz});$crwkvkdwdj="gets";${"GLOBALS"}["ezgyxewcwp"]="get";${${"GLOBALS"}["cuhxdsr"]}=$db->query("SELECT funerals_delete.id AS id,funerals_delete.date,funerals_delete.name,funerals_delete.address,funerals_delete.relative,funerals_delete.phone,funerals_delete.callstatus,adate,ddate,users1.name AS aname,users2.name AS dname FROM funerals_delete
	LEFT JOIN users AS users1 ON users1.id=funerals_delete.auser
	LEFT JOIN users AS users2 ON users2.id=funerals_delete.duser
	$sqlsearch
	ORDER BY $ordertable $ordersort LIMIT $start,$length");${$bavnwsh}=array("draw"=>${$popebplwgfs},"recordsTotal"=>${${"GLOBALS"}["oqnkiti"]},"recordsFiltered"=>${${"GLOBALS"}["ggozkfvb"]},"data"=>array());${${"GLOBALS"}["vwllfoyvwpev"]}=array();foreach(${$crwkvkdwdj} as${${"GLOBALS"}["ezgyxewcwp"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","name"=>"$get->name","date"=>"$get->date","address"=>"$get->address","relative"=>"$get->relative","phone"=>"$get->phone","callstatus"=>"$get->callstatus","auser"=>"$get->aname","adate"=>"$get->adate","duser"=>"$get->dname","ddate"=>"$get->ddate");}${${"GLOBALS"}["fyesxkwry"]}["data"]=${$ryiiabmnqae};echo json_encode(${$qayiebax});}elseif(${${"GLOBALS"}["cyucfo"]}=="anniversaries"&&${${"GLOBALS"}["xcxrmqvbz"]}==""){$frlhmmxtktlq="draw";$tdswyrsn="sqlarray";$wqhjkxgatwyb="length";$xtdatnjba="ordertable";$bgbsiuttcohj="gets";${$frlhmmxtktlq}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";${$wqhjkxgatwyb}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";$tdbkmq="name";${${"GLOBALS"}["yvpjlkpq"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";$odxironu="nametwo";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";${$xtdatnjba}=$_GET["columns"][${${"GLOBALS"}["dqostybleq"]}]["data"];$nsodcjhit="datestart";$fgauvjft="data";$lbzssdc="draw";${${"GLOBALS"}["whfudgpdm"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${${"GLOBALS"}["hqdnrdjuit"]}=" WHERE ";${"GLOBALS"}["xyhhosmba"]="callstatus";${"GLOBALS"}["dadwtasy"]="name";${${"GLOBALS"}["ccjlcdgqevb"]}=array();${$nsodcjhit}=htmlspecialchars(isset($_GET["datestart"])&&$_GET["dateend"]!="")?$_GET["datestart"]:"01-01-2000";$xezopwe="nametwo";$lkuojeyhoq="data";${"GLOBALS"}["xwemkrgonof"]="datestart";${${"GLOBALS"}["aktkbstp"]}=htmlspecialchars(isset($_GET["dateend"])&&$_GET["dateend"]!="")?$_GET["dateend"]:"01-01-2030";${"GLOBALS"}["kuqfseq"]="dateend";$cwlxupthkmaf="search";$kytwuhoby="sqlarray";$rvmbqyufv="sqlarray";${${"GLOBALS"}["vdkgsrxonyb"]}=date("Y-m-d 00:00:00",strtotime(${${"GLOBALS"}["xwemkrgonof"]}));$xkorhnjb="auser";${${"GLOBALS"}["aktkbstp"]}=date("Y-m-d 23:59:59",strtotime(${${"GLOBALS"}["kuqfseq"]}));${${"GLOBALS"}["hqdnrdjuit"]}.=" (date BETWEEN :datestart AND :dateend) ";${${"GLOBALS"}["ccjlcdgqevb"]}["datestart"]="$datestart";${$kytwuhoby}["dateend"]="$dateend";${${"GLOBALS"}["bmrrwnilcx"]}=htmlspecialchars(isset($_GET["callstatus"]))?$_GET["callstatus"]:"";${"GLOBALS"}["pnuglhtr"]="notecount";if(${${"GLOBALS"}["xyhhosmba"]}!=""){${"GLOBALS"}["chsgtikxo"]="sqlarray";${"GLOBALS"}["ufcdrngrgnmh"]="sqlsearch";${${"GLOBALS"}["ufcdrngrgnmh"]}.=" AND (callstatus=:callstatus) ";${${"GLOBALS"}["chsgtikxo"]}["callstatus"]="$callstatus";}$dhfjrucj="name";${$tdbkmq}=htmlspecialchars(isset($_GET["name"]))?$_GET["name"]:"";${${"GLOBALS"}["eldndob"]}=strlen(${$dhfjrucj});if(${${"GLOBALS"}["dadwtasy"]}!=""&&${${"GLOBALS"}["eldndob"]}>2){$nvflahtwshe="sqlsearch";$kroywxmmo="sqlarray";${$nvflahtwshe}.=" AND $p.name LIKE :name ";${$kroywxmmo}["name"]="%$name%";}${${"GLOBALS"}["jbhdyul"]}=htmlspecialchars(isset($_GET["nametwo"]))?$_GET["nametwo"]:"";${${"GLOBALS"}["cgvrfflri"]}=strlen(${$xezopwe});if(${$odxironu}!=""&&${${"GLOBALS"}["cgvrfflri"]}>2){${"GLOBALS"}["grjmul"]="sqlsearch";$qwfwjnbsc="sqlarray";${${"GLOBALS"}["grjmul"]}.=" AND $p.nametwo LIKE :nametwo ";${$qwfwjnbsc}["nametwo"]="%$nametwo%";}${${"GLOBALS"}["otmrsqfgxmjg"]}=htmlspecialchars(isset($_GET["note"]))?$_GET["note"]:"";${${"GLOBALS"}["pnuglhtr"]}=strlen(${${"GLOBALS"}["otmrsqfgxmjg"]});if(${${"GLOBALS"}["otmrsqfgxmjg"]}!=""&&${${"GLOBALS"}["frmicrftq"]}>2){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND $p.note LIKE :note ";${${"GLOBALS"}["ccjlcdgqevb"]}["note"]="%$note%";}${"GLOBALS"}["cdnqlmfblt"]="total";${$xkorhnjb}=htmlspecialchars(isset($_GET["auser"]))?$_GET["auser"]:"";if(${${"GLOBALS"}["wyooigqr"]}!=""){$dlwwkulvjer="sqlsearch";${$dlwwkulvjer}.=" AND auser=:auser ";${${"GLOBALS"}["ccjlcdgqevb"]}["auser"]="$auser";}${${"GLOBALS"}["ttiknyszrry"]}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${${"GLOBALS"}["ekrlomnxft"]}=strlen(${${"GLOBALS"}["ttiknyszrry"]});${"GLOBALS"}["ejqghhvldg"]="total";if(${$cwlxupthkmaf}!=""&&${${"GLOBALS"}["ekrlomnxft"]}>2){${"GLOBALS"}["mxwnlhlul"]="sqlarray";$ibhcbsubdkbd="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND ($p.name LIKE :search1 OR nametwo LIKE :search2 OR note LIKE :search3) ";${${"GLOBALS"}["mxwnlhlul"]}["search1"]="%$search%";${$ibhcbsubdkbd}["search2"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search3"]="%$search%";}${${"GLOBALS"}["ejqghhvldg"]}=$db->single("SELECT COUNT(*) FROM $p");$db->bindMore(${$tdswyrsn});${${"GLOBALS"}["dlfvgvdkiyfm"]}=$db->single("SELECT COUNT(*) FROM $p
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch
	");$db->bindMore(${$rvmbqyufv});${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT $p.id AS id,$p.date,$p.name,$p.nametwo,$p.phone,$p.address,$p.note,$p.callstatus,adate,udate,users.name AS aname FROM $p
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch  ORDER BY $ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["fyesxkwry"]}=array("draw"=>${$lbzssdc},"recordsTotal"=>${${"GLOBALS"}["cdnqlmfblt"]},"recordsFiltered"=>${${"GLOBALS"}["dlfvgvdkiyfm"]},"data"=>array());$hywmlle="output";${$lkuojeyhoq}=array();foreach(${$bgbsiuttcohj} as${${"GLOBALS"}["rnolkxckcnx"]}){$vvlgrfve="data";${$vvlgrfve}[]=array("id"=>"$get->id","date"=>"$get->date","name"=>"$get->name","nametwo"=>"$get->nametwo","phone"=>"$get->phone","address"=>"$get->address","note"=>"$get->note","callstatus"=>"$get->callstatus","auser"=>"$get->aname","adate"=>"$get->adate","udate"=>"$get->udate");}${$hywmlle}["data"]=${$fgauvjft};echo json_encode(${${"GLOBALS"}["fyesxkwry"]});}elseif(${$rodrcrmcjv}=="anniversaries"&&${$qhkmsymt}=="calendar"){$ljmqfuyvf="get";${${"GLOBALS"}["vdkgsrxonyb"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"01-01-2000";$tycuodwrcwx="gets";$gpsugfvk="dateend";${"GLOBALS"}["inxnvbgjtjs"]="dateend";$ofuvrpiqsng="gets";${${"GLOBALS"}["aktkbstp"]}=htmlspecialchars(isset($_GET["end"]))?$_GET["end"]:"01-01-2000";${${"GLOBALS"}["vdkgsrxonyb"]}=date("Y-m-d 00:00:00",strtotime(${${"GLOBALS"}["vdkgsrxonyb"]}));${${"GLOBALS"}["inxnvbgjtjs"]}=date("Y-m-d 23:59:59",strtotime(${$gpsugfvk}));${$ofuvrpiqsng}=$db->query("SELECT id,date,name,nametwo FROM $p WHERE (date BETWEEN '$datestart' AND '$dateend')");${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${$tycuodwrcwx} as${$ljmqfuyvf}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","start"=>"$get->date","end"=>"$get->date","title"=>"$get->name - $get->nametwo");}echo json_encode(${${"GLOBALS"}["oahevqvtz"]});}elseif(${${"GLOBALS"}["cyucfo"]}=="anniversaries"&&${${"GLOBALS"}["xcxrmqvbz"]}=="deleted"){${${"GLOBALS"}["njzrsmqnw"]}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";$jkjexvei="sqlarray";$xaspca="recordcount";${${"GLOBALS"}["trnnikimudp"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${"GLOBALS"}["tyhyongqr"]="sqlarray";${${"GLOBALS"}["yvpjlkpq"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";${"GLOBALS"}["nmpulvebk"]="search";${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${${"GLOBALS"}["dqostybleq"]}]["data"];${${"GLOBALS"}["whfudgpdm"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${"GLOBALS"}["ozksmykhk"]="data";${${"GLOBALS"}["hqdnrdjuit"]}="";${"GLOBALS"}["dtmxqwtjamw"]="searchcount";${"GLOBALS"}["ytqeyrg"]="search";${${"GLOBALS"}["ccjlcdgqevb"]}=array();${${"GLOBALS"}["ytqeyrg"]}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${"GLOBALS"}["qnpuhiw"]="output";${"GLOBALS"}["wiptoqygbpp"]="total";${${"GLOBALS"}["ekrlomnxft"]}=strlen(${${"GLOBALS"}["nmpulvebk"]});if(${${"GLOBALS"}["ttiknyszrry"]}!=""&&${${"GLOBALS"}["dtmxqwtjamw"]}>2){${"GLOBALS"}["jvhqqyfwsc"]="sqlsearch";${"GLOBALS"}["vujymqodsuj"]="sqlarray";${${"GLOBALS"}["jvhqqyfwsc"]}.=" WHERE (anniversaries_delete.name LIKE :search1 OR nametwo LIKE :search2 OR note LIKE :search3) ";${${"GLOBALS"}["ccjlcdgqevb"]}["search1"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search2"]="%$search%";${${"GLOBALS"}["vujymqodsuj"]}["search3"]="%$search%";}${${"GLOBALS"}["wiptoqygbpp"]}=$db->single("SELECT COUNT(*) FROM anniversaries_delete");$db->bindMore(${${"GLOBALS"}["tyhyongqr"]});${${"GLOBALS"}["dlfvgvdkiyfm"]}=$db->single("SELECT COUNT(*) FROM anniversaries_delete
	LEFT JOIN users AS users1 ON users1.id=anniversaries_delete.auser
	LEFT JOIN users AS users2 ON users2.id=anniversaries_delete.duser
	$sqlsearch
	");$db->bindMore(${$jkjexvei});${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT anniversaries_delete.id AS id,anniversaries_delete.date,anniversaries_delete.name,anniversaries_delete.nametwo,anniversaries_delete.phone,anniversaries_delete.address,anniversaries_delete.note,anniversaries_delete.callstatus,adate,ddate,users1.name AS aname,users2.name AS dname FROM anniversaries_delete
	LEFT JOIN users AS users1 ON users1.id=anniversaries_delete.auser
	LEFT JOIN users AS users2 ON users2.id=anniversaries_delete.duser
	$sqlsearch
	ORDER BY $ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["fyesxkwry"]}=array("draw"=>${${"GLOBALS"}["njzrsmqnw"]},"recordsTotal"=>${${"GLOBALS"}["jvnlrcvwrj"]},"recordsFiltered"=>${$xaspca},"data"=>array());${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${${"GLOBALS"}["rnolkxckcnx"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","name"=>"$get->name","nametwo"=>"$get->nametwo","date"=>"$get->date","phone"=>"$get->phone","address"=>"$get->address","note"=>"$get->note","callstatus"=>"$get->callstatus","auser"=>"$get->aname","adate"=>"$get->adate","duser"=>"$get->dname","ddate"=>"$get->ddate");}${${"GLOBALS"}["qnpuhiw"]}["data"]=${${"GLOBALS"}["ozksmykhk"]};echo json_encode(${${"GLOBALS"}["fyesxkwry"]});}elseif(${$nriuecykuyj}=="waitschedules"&&${${"GLOBALS"}["xcxrmqvbz"]}==""){${"GLOBALS"}["wyelsuexhhv"]="start";${${"GLOBALS"}["njzrsmqnw"]}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";${"GLOBALS"}["cmcynzn"]="address";$aylpzboepqh="data";${"GLOBALS"}["upqgdsssqcu"]="orderfinal";${"GLOBALS"}["htwwstny"]="search";$zxgtfsn="datestart";$rruczogoip="length";$zclkirbmj="total";${$rruczogoip}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";$iujymc="note";$wasngyckxo="note";${"GLOBALS"}["ttmkedq"]="data";${${"GLOBALS"}["wyelsuexhhv"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";$itkxxpuubmm="i";${${"GLOBALS"}["upqgdsssqcu"]}="";for(${${"GLOBALS"}["hecjsmsbqw"]}=0;${$itkxxpuubmm}<=20;${${"GLOBALS"}["hecjsmsbqw"]}++){$kvxuksrdlui="ordersort";$shefmppf="ordertable";$gsiuwoqw="ordertable";${$gsiuwoqw}=htmlspecialchars(isset($_GET["order"][${${"GLOBALS"}["hecjsmsbqw"]}]["column"]))?$_GET["order"][${${"GLOBALS"}["hecjsmsbqw"]}]["column"]:"";if(${$shefmppf}!=""){${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${${"GLOBALS"}["dqostybleq"]}]["data"];}$vvyjyfkn="ordertable";$ejkkfxt="i";${$kvxuksrdlui}=htmlspecialchars(isset($_GET["order"][${$ejkkfxt}]["dir"]))?$_GET["order"][${${"GLOBALS"}["hecjsmsbqw"]}]["dir"]:"";if(${${"GLOBALS"}["nsvkum"]}!=""&&${$vvyjyfkn}!=""){${${"GLOBALS"}["nsvkum"]}.=", ";}${${"GLOBALS"}["nsvkum"]}.="$ordertable $ordersort";}${"GLOBALS"}["vdflbnbfy"]="dateend";${${"GLOBALS"}["hqdnrdjuit"]}=" WHERE 1";${${"GLOBALS"}["ccjlcdgqevb"]}=array();$bdqtjeaxda="search";$rqhvkgvko="notecount";${$bdqtjeaxda}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${${"GLOBALS"}["ekrlomnxft"]}=strlen(${${"GLOBALS"}["ttiknyszrry"]});if(${${"GLOBALS"}["htwwstny"]}!=""&&${${"GLOBALS"}["ekrlomnxft"]}>2){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND ($p.content LIKE :search1 OR $p.address LIKE :search2 OR $p.note LIKE :search3) ";${${"GLOBALS"}["ccjlcdgqevb"]}["search1"]="%$search%";$kcwvme="sqlarray";${"GLOBALS"}["vkkwfolsf"]="sqlarray";${${"GLOBALS"}["vkkwfolsf"]}["search2"]="%$search%";${$kcwvme}["search3"]="%$search%";}${$zxgtfsn}=htmlspecialchars(isset($_GET["datestart"])&&$_GET["dateend"]!="")?$_GET["datestart"]:"01-01-2000";${${"GLOBALS"}["aktkbstp"]}=htmlspecialchars(isset($_GET["dateend"])&&$_GET["dateend"]!="")?$_GET["dateend"]:"01-01-2030";${${"GLOBALS"}["vdkgsrxonyb"]}=date("Y-m-d",strtotime(${${"GLOBALS"}["vdkgsrxonyb"]}));${"GLOBALS"}["ixvwfdl"]="datestart";${${"GLOBALS"}["vdflbnbfy"]}=date("Y-m-d",strtotime(${${"GLOBALS"}["aktkbstp"]}));$jxqfvjgtnr="type";if(${${"GLOBALS"}["ixvwfdl"]}==${${"GLOBALS"}["aktkbstp"]}){$webwjtl="sqlsearch";${$webwjtl}.=" AND $p.date=:datestart ";${${"GLOBALS"}["ccjlcdgqevb"]}["datestart"]="$datestart";}else{$dlgspmbv="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND ($p.date BETWEEN :datestart AND :dateend) ";$vnetjhe="sqlarray";${$dlgspmbv}["datestart"]="$datestart";${$vnetjhe}["dateend"]="$dateend";}${"GLOBALS"}["fofwfub"]="addresscount";$cwqrfvpnubt="contentcount";${"GLOBALS"}["kwhjirwxq"]="gets";${"GLOBALS"}["cmspqpl"]="auser";${${"GLOBALS"}["aawviwx"]}=htmlspecialchars(isset($_GET["type"]))?$_GET["type"]:"";if(${$jxqfvjgtnr}!=""){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND $p.type=:type ";${${"GLOBALS"}["ccjlcdgqevb"]}["type"]="$type";}$wcwfqkxv="auser";$kqmzbucvg="address";${${"GLOBALS"}["nisgib"]}=htmlspecialchars(isset($_GET["priority"]))?$_GET["priority"]:"";${"GLOBALS"}["ewwrxudoto"]="contentcount";$yeswxhoxmn="get";if(${${"GLOBALS"}["nisgib"]}!=""){$hllubms="sqlsearch";${$hllubms}.=" AND $p.priority=:priority ";${${"GLOBALS"}["ccjlcdgqevb"]}["priority"]="$priority";}${${"GLOBALS"}["uhphfkbx"]}=htmlspecialchars(isset($_GET["content"]))?$_GET["content"]:"";${$cwqrfvpnubt}=strlen(${${"GLOBALS"}["uhphfkbx"]});if(${${"GLOBALS"}["uhphfkbx"]}!=""&&${${"GLOBALS"}["ewwrxudoto"]}>2){$uivoelpeqnkk="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND $p.content LIKE :content ";${$uivoelpeqnkk}["content"]="%$content%";}${${"GLOBALS"}["xmusldygol"]}=htmlspecialchars(isset($_GET["address"]))?$_GET["address"]:"";${${"GLOBALS"}["ngxokz"]}=strlen(${${"GLOBALS"}["cmcynzn"]});if(${$kqmzbucvg}!=""&&${${"GLOBALS"}["fofwfub"]}>2){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND $p.address LIKE :address ";${${"GLOBALS"}["ccjlcdgqevb"]}["address"]="%$address%";}${$wasngyckxo}=htmlspecialchars(isset($_GET["note"]))?$_GET["note"]:"";${${"GLOBALS"}["frmicrftq"]}=strlen(${$iujymc});if(${${"GLOBALS"}["otmrsqfgxmjg"]}!=""&&${$rqhvkgvko}>2){${"GLOBALS"}["tmnvpnqwxrx"]="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND $p.note LIKE :note ";${${"GLOBALS"}["tmnvpnqwxrx"]}["note"]="%$note%";}${${"GLOBALS"}["mfvfmwhyew"]}=htmlspecialchars(isset($_GET["notify"]))?$_GET["notify"]:"";if(${${"GLOBALS"}["mfvfmwhyew"]}!=""){$qqhydjrn="sqlsearch";${$qqhydjrn}.=" AND ($p.notify=:notify) ";${${"GLOBALS"}["ccjlcdgqevb"]}["notify"]="$notify";}${$wcwfqkxv}=htmlspecialchars(isset($_GET["auser"]))?$_GET["auser"]:"";if(${${"GLOBALS"}["cmspqpl"]}!=""){${"GLOBALS"}["pmbslodsmi"]="sqlsearch";${${"GLOBALS"}["pmbslodsmi"]}.=" AND $p.auser=:auser ";${${"GLOBALS"}["ccjlcdgqevb"]}["auser"]="$auser";}${$zclkirbmj}=$db->single("SELECT COUNT(*) FROM $p");$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${${"GLOBALS"}["dlfvgvdkiyfm"]}=$db->single("SELECT COUNT(*) FROM $p
	LEFT JOIN types ON types.id=$p.type
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch
	");$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${${"GLOBALS"}["kwhjirwxq"]}=$db->query("SELECT $p.id AS id,types.name AS type,types.bgcolor AS typebgcolor,types.color AS typecolor,$p.date,$p.timestart,$p.timeend,$p.content,$p.address,$p.map,$p.notify,$p.priority,$p.note,$p.adate,$p.udate,users.name AS auser FROM $p
	LEFT JOIN types ON types.id=$p.type
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch  ORDER BY  $orderfinal LIMIT $start,$length");${${"GLOBALS"}["fyesxkwry"]}=array("draw"=>${${"GLOBALS"}["njzrsmqnw"]},"recordsTotal"=>${${"GLOBALS"}["jvnlrcvwrj"]},"recordsFiltered"=>${${"GLOBALS"}["dlfvgvdkiyfm"]},"data"=>array());${$aylpzboepqh}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${$yeswxhoxmn}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","type"=>"$get->type","typebgcolor"=>"$get->typebgcolor","typecolor"=>"$get->typecolor","date"=>"$get->date","timestart"=>"$get->timestart","timeend"=>"$get->timeend","content"=>"$get->content","address"=>"$get->address","map"=>"$get->map","notify"=>"$get->notify","priority"=>"$get->priority","note"=>"$get->note","auser"=>"$get->auser","adate"=>"$get->adate","udate"=>"$get->udate");}${${"GLOBALS"}["fyesxkwry"]}["data"]=${${"GLOBALS"}["ttmkedq"]};echo json_encode(${${"GLOBALS"}["fyesxkwry"]});}elseif(${$ymckihfgk}=="waitschedules"&&${${"GLOBALS"}["dgjvdltfilf"]}=="calendar"){${"GLOBALS"}["qqkkoalizcqe"]="dateend";${"GLOBALS"}["jmpcymcjwoo"]="dateend";$pxhkkbkwhmkr="get";${${"GLOBALS"}["vdkgsrxonyb"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"01-01-2000";${"GLOBALS"}["oeddrguu"]="gets";${"GLOBALS"}["atvyieho"]="datestart";${${"GLOBALS"}["aktkbstp"]}=htmlspecialchars(isset($_GET["end"]))?$_GET["end"]:"01-01-2000";${${"GLOBALS"}["vdkgsrxonyb"]}=date("Y-m-d 00:00:00",strtotime(${${"GLOBALS"}["atvyieho"]}));${${"GLOBALS"}["qqkkoalizcqe"]}=date("Y-m-d 23:59:59",strtotime(${${"GLOBALS"}["jmpcymcjwoo"]}));${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT id,CONCAT(date,'T',timestart) AS datestart,CONCAT(date,'T',timeend) AS dateend,content FROM $p WHERE (date BETWEEN '$datestart' AND '$dateend')");${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${${"GLOBALS"}["oeddrguu"]} as${$pxhkkbkwhmkr}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","start"=>"$get->datestart","end"=>"$get->dateend","title"=>"$get->content");}echo json_encode(${${"GLOBALS"}["oahevqvtz"]});}elseif(${${"GLOBALS"}["ycmnxxdij"]}=="waitschedules"&&${${"GLOBALS"}["xcxrmqvbz"]}=="deleted"){$iocsywyea="p";${"GLOBALS"}["bpulhw"]="search";${"GLOBALS"}["cadljtdsi"]="ordertable";${"GLOBALS"}["xcpdgghn"]="p";${"GLOBALS"}["zjqygvmvpzj"]="p";${${"GLOBALS"}["njzrsmqnw"]}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";$hscrklfeni="ordertable";${"GLOBALS"}["gzalvf"]="searchcount";$vgjjukdopfnw="search";${"GLOBALS"}["kcjikddquhr"]="p";${${"GLOBALS"}["trnnikimudp"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${"GLOBALS"}["ephtkbc"]="p";$fxoruhst="p";${"GLOBALS"}["xtccgnf"]="start";${"GLOBALS"}["kolkrghy"]="output";${${"GLOBALS"}["xtccgnf"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${${"GLOBALS"}["cadljtdsi"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";$deymfwoumc="ordersort";$rpbxkahgr="output";${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${$hscrklfeni}]["data"];$dfojrg="search";${"GLOBALS"}["dktkdgimqqt"]="sqlsearch";${$deymfwoumc}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${${"GLOBALS"}["dktkdgimqqt"]}="";${${"GLOBALS"}["ccjlcdgqevb"]}=array();${$dfojrg}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${${"GLOBALS"}["ekrlomnxft"]}=strlen(${${"GLOBALS"}["bpulhw"]});if(${$vgjjukdopfnw}!=""&&${${"GLOBALS"}["gzalvf"]}>2){${"GLOBALS"}["lerjnsth"]="p";${"GLOBALS"}["frrunxj"]="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" WHERE (".${${"GLOBALS"}["cyucfo"]}."_delete.content LIKE :search1 OR ".${${"GLOBALS"}["lerjnsth"]}."_delete.address LIKE :search2 OR ".${${"GLOBALS"}["cyucfo"]}."_delete.note LIKE :search3) ";${${"GLOBALS"}["frrunxj"]}["search1"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search2"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search3"]="%$search%";}${"GLOBALS"}["umoneortmv"]="p";${${"GLOBALS"}["jvnlrcvwrj"]}=$db->single("SELECT COUNT(*) FROM ".${${"GLOBALS"}["cyucfo"]}."_delete");$kvsuiwtoh="total";${"GLOBALS"}["uvfvqnjjpk"]="draw";$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});$ttwhgidniug="p";${${"GLOBALS"}["dlfvgvdkiyfm"]}=$db->single("SELECT COUNT(*) FROM ".${${"GLOBALS"}["cyucfo"]}."_delete
	LEFT JOIN types ON types.id=".${${"GLOBALS"}["ephtkbc"]}."_delete.type
	LEFT JOIN users AS users1 ON users1.id=".${${"GLOBALS"}["cyucfo"]}."_delete.auser
	LEFT JOIN users AS users2 ON users2.id=".${$fxoruhst}."_delete.duser
	$sqlsearch
	");${"GLOBALS"}["sttnkfbcuj"]="output";$xebvmhi="p";$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT ".${${"GLOBALS"}["cyucfo"]}."_delete.id AS id,types.name AS type,".${${"GLOBALS"}["cyucfo"]}."_delete.transfer,".${${"GLOBALS"}["cyucfo"]}."_delete.date,".${$ttwhgidniug}."_delete.timestart,".${${"GLOBALS"}["cyucfo"]}."_delete.timeend,".${${"GLOBALS"}["xcpdgghn"]}."_delete.content,".${${"GLOBALS"}["cyucfo"]}."_delete.address,".${${"GLOBALS"}["cyucfo"]}."_delete.map,".${${"GLOBALS"}["zjqygvmvpzj"]}."_delete.notify,".${$xebvmhi}."_delete.priority,".${${"GLOBALS"}["umoneortmv"]}."_delete.note,".${${"GLOBALS"}["cyucfo"]}."_delete.adate,users1.name AS aname,ddate,users2.name AS dname FROM ".${${"GLOBALS"}["cyucfo"]}."_delete
	LEFT JOIN types ON types.id=".${$iocsywyea}."_delete.type
	LEFT JOIN users AS users1 ON users1.id=".${${"GLOBALS"}["cyucfo"]}."_delete.auser
	LEFT JOIN users AS users2 ON users2.id=".${${"GLOBALS"}["kcjikddquhr"]}."_delete.duser
	$sqlsearch
	ORDER BY $ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["sttnkfbcuj"]}=array("draw"=>${${"GLOBALS"}["uvfvqnjjpk"]},"recordsTotal"=>${$kvsuiwtoh},"recordsFiltered"=>${${"GLOBALS"}["dlfvgvdkiyfm"]},"data"=>array());${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${${"GLOBALS"}["rnolkxckcnx"]}){$sidxil="data";${$sidxil}[]=array("id"=>"$get->id","type"=>"$get->type","transfer"=>"$get->transfer","date"=>"$get->date","timestart"=>"$get->timestart","timeend"=>"$get->timeend","content"=>"$get->content","address"=>"$get->address","map"=>"$get->map","notify"=>"$get->notify","priority"=>"$get->priority","note"=>"$get->note","auser"=>"$get->aname","adate"=>"$get->adate","duser"=>"$get->dname","ddate"=>"$get->ddate");}${${"GLOBALS"}["kolkrghy"]}["data"]=${${"GLOBALS"}["oahevqvtz"]};echo json_encode(${$rpbxkahgr});}elseif(${$blkvpkso}=="addressbook"&&${${"GLOBALS"}["ocgtndb"]}==""){${"GLOBALS"}["bxhlyrs"]="ordertable";${"GLOBALS"}["zlwkpbxuy"]="draw";${"GLOBALS"}["xwegrawfmwv"]="addresscount";${"GLOBALS"}["lhqpqtp"]="ordersort";${"GLOBALS"}["ffvqvj"]="data";${"GLOBALS"}["yrszvpvnr"]="address";${"GLOBALS"}["qtxvfaymgl"]="name";${${"GLOBALS"}["zlwkpbxuy"]}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";${${"GLOBALS"}["trnnikimudp"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${${"GLOBALS"}["yvpjlkpq"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${"GLOBALS"}["kxxlpfkltn"]="phonecount";${"GLOBALS"}["klpibh"]="titlecount";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${${"GLOBALS"}["bxhlyrs"]}]["data"];${"GLOBALS"}["vcjgehjnxo"]="email";${"GLOBALS"}["nnasrgrylv"]="address";${"GLOBALS"}["wyhfdshsbcx"]="namecount";$rqupbehgueuw="emailcount";$blwixjlm="gets";${"GLOBALS"}["kmelpit"]="search";${${"GLOBALS"}["lhqpqtp"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${${"GLOBALS"}["hqdnrdjuit"]}=" WHERE 1 ";${"GLOBALS"}["ocpprbdq"]="output";${${"GLOBALS"}["ccjlcdgqevb"]}=array();${${"GLOBALS"}["qtxvfaymgl"]}=htmlspecialchars(isset($_GET["name"]))?$_GET["name"]:"";${${"GLOBALS"}["wyhfdshsbcx"]}=strlen(${${"GLOBALS"}["uynormyg"]});${"GLOBALS"}["uggebwfr"]="search";${"GLOBALS"}["wxuhyoadm"]="total";${"GLOBALS"}["bpsjnhne"]="title";if(${${"GLOBALS"}["uynormyg"]}!=""&&${${"GLOBALS"}["eldndob"]}>2){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND $p.name LIKE :name ";${${"GLOBALS"}["ccjlcdgqevb"]}["name"]="%$name%";}$vfwrcbyytwbl="auser";${"GLOBALS"}["urabkxwbsp"]="sqlarray";$ghyxhvjzpd="phone";${"GLOBALS"}["duyentwrtyhx"]="auser";$jkenlyfy="titlecount";${${"GLOBALS"}["jnzpcxke"]}=htmlspecialchars(isset($_GET["title"]))?$_GET["title"]:"";${$jkenlyfy}=strlen(${${"GLOBALS"}["bpsjnhne"]});if(${${"GLOBALS"}["jnzpcxke"]}!=""&&${${"GLOBALS"}["klpibh"]}>2){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND $p.title LIKE :title ";${${"GLOBALS"}["ccjlcdgqevb"]}["title"]="%$title%";}$xnvyoou="search";${${"GLOBALS"}["gzmntmwjk"]}=htmlspecialchars(isset($_GET["phone"]))?$_GET["phone"]:"";${${"GLOBALS"}["klndrknrfs"]}=strlen(${$ghyxhvjzpd});if(${${"GLOBALS"}["gzmntmwjk"]}!=""&&${${"GLOBALS"}["kxxlpfkltn"]}>2){${"GLOBALS"}["jqpoughtah"]="sqlarray";${"GLOBALS"}["uwelhnj"]="phone";${${"GLOBALS"}["uwelhnj"]}=str_replace(" ","",${${"GLOBALS"}["gzmntmwjk"]});${${"GLOBALS"}["hqdnrdjuit"]}.=" AND REPLACE($p.phone, ' ', '')  LIKE :phone ";${${"GLOBALS"}["jqpoughtah"]}["phone"]="%$phone%";}${${"GLOBALS"}["lopcwjq"]}=htmlspecialchars(isset($_GET["email"]))?$_GET["email"]:"";${$rqupbehgueuw}=strlen(${${"GLOBALS"}["vcjgehjnxo"]});if(${${"GLOBALS"}["lopcwjq"]}!=""&&${${"GLOBALS"}["eivjaiwixck"]}>2){$mhsroccyzej="sqlsearch";${$mhsroccyzej}.=" AND email LIKE :email ";${${"GLOBALS"}["ccjlcdgqevb"]}["email"]="%$email%";}${${"GLOBALS"}["xmusldygol"]}=htmlspecialchars(isset($_GET["address"]))?$_GET["address"]:"";${${"GLOBALS"}["xwegrawfmwv"]}=strlen(${${"GLOBALS"}["nnasrgrylv"]});if(${${"GLOBALS"}["yrszvpvnr"]}!=""&&${${"GLOBALS"}["ngxokz"]}>2){$zeylwvbcb="sqlarray";${"GLOBALS"}["fbwqvvt"]="sqlsearch";${${"GLOBALS"}["fbwqvvt"]}.=" AND address LIKE :address ";${$zeylwvbcb}["address"]="%$address%";}$tfvtcjkr="searchcount";$dkwchg="output";${${"GLOBALS"}["duyentwrtyhx"]}=htmlspecialchars(isset($_GET["auser"]))?$_GET["auser"]:"";if(${$vfwrcbyytwbl}!=""){${"GLOBALS"}["fnxbncqtx"]="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND auser=:auser ";${${"GLOBALS"}["fnxbncqtx"]}["auser"]="$auser";}${$xnvyoou}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${$tfvtcjkr}=strlen(${${"GLOBALS"}["kmelpit"]});if(${${"GLOBALS"}["uggebwfr"]}!=""&&${${"GLOBALS"}["ekrlomnxft"]}>2){$mbceoepb="searchspaces";$odfuufw="searchspacesw";$jntduxhl="sqlarray";${"GLOBALS"}["jnbinjtg"]="sqlarray";$oossrjg="sqlsearch";$rhesjxgxo="search";${$mbceoepb}=str_replace(" ","",${$rhesjxgxo});${$odfuufw}=str_replace(" ","%",${${"GLOBALS"}["ttiknyszrry"]});${$oossrjg}.=" AND (REPLACE($p.phone, ' ', '') LIKE :search1 OR CONCAT_WS(' ',$p.name,$p.title,$p.phone,$p.email,$p.address) LIKE :search2) ";${$jntduxhl}["search1"]="%$searchspaces%";${${"GLOBALS"}["jnbinjtg"]}["search2"]="%$searchspacesw%";}${${"GLOBALS"}["wxuhyoadm"]}=$db->single("SELECT COUNT(*) FROM $p");$db->bindMore(${${"GLOBALS"}["urabkxwbsp"]});${${"GLOBALS"}["dlfvgvdkiyfm"]}=$db->single("SELECT COUNT(*) FROM $p
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch
	");${"GLOBALS"}["gurcgrjqg"]="sqlarray";$db->bindMore(${${"GLOBALS"}["gurcgrjqg"]});${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT $p.id AS id,$p.name,$p.title,$p.phone,$p.email,$p.address,adate,udate,users.name AS aname FROM $p
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch  ORDER BY $ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["ocpprbdq"]}=array("draw"=>${${"GLOBALS"}["njzrsmqnw"]},"recordsTotal"=>${${"GLOBALS"}["jvnlrcvwrj"]},"recordsFiltered"=>${${"GLOBALS"}["dlfvgvdkiyfm"]},"data"=>array());${${"GLOBALS"}["ffvqvj"]}=array();foreach(${$blwixjlm} as${${"GLOBALS"}["rnolkxckcnx"]}){$ndyredhl="data";${$ndyredhl}[]=array("id"=>"$get->id","name"=>"$get->name","title"=>"$get->title","phone"=>"$get->phone","email"=>"$get->email","address"=>"$get->address","auser"=>"$get->aname","adate"=>"$get->adate","udate"=>"$get->udate");}${$dkwchg}["data"]=${${"GLOBALS"}["oahevqvtz"]};echo json_encode(${${"GLOBALS"}["fyesxkwry"]});}elseif(${${"GLOBALS"}["cyucfo"]}=="addressbook"&&${$rytmiglin}=="deleted"){${"GLOBALS"}["hkpyvgjw"]="p";$dknpuprif="p";$yodahved="draw";${"GLOBALS"}["pwemqumqyb"]="ordertable";${"GLOBALS"}["vmegalxcgreg"]="p";${"GLOBALS"}["yrhnjxhial"]="searchcount";$haxavvutoz="length";$nshzbldhedf="sqlsearch";${"GLOBALS"}["itehsejmlx"]="p";${$yodahved}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";$pfyisbcrprq="p";${"GLOBALS"}["zcvpidemejox"]="searchcount";${$haxavvutoz}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${"GLOBALS"}["czrukijl"]="sqlarray";${${"GLOBALS"}["yvpjlkpq"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";$wlpllqwqbb="ordertable";${${"GLOBALS"}["pwemqumqyb"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";$rfappyrf="output";${"GLOBALS"}["xgqxigl"]="sqlarray";${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${$wlpllqwqbb}]["data"];$fjbgmkak="search";$rxuhdv="p";${${"GLOBALS"}["whfudgpdm"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${$nshzbldhedf}="";${${"GLOBALS"}["czrukijl"]}=array();${"GLOBALS"}["mstezmkfs"]="data";${${"GLOBALS"}["ttiknyszrry"]}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${${"GLOBALS"}["zcvpidemejox"]}=strlen(${${"GLOBALS"}["ttiknyszrry"]});if(${$fjbgmkak}!=""&&${${"GLOBALS"}["yrhnjxhial"]}>2){$fbupqiew="p";${${"GLOBALS"}["hqdnrdjuit"]}.=" WHERE (".${$fbupqiew}."_delete.name LIKE :search1 OR title LIKE :search2 OR phone LIKE :search3 OR address LIKE :search4) ";$mgrironfxfg="sqlarray";${${"GLOBALS"}["ccjlcdgqevb"]}["search1"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search2"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search3"]="%$search%";${$mgrironfxfg}["search4"]="%$search%";}$uieuivtsiti="p";$ybdlzyg="recordcount";${${"GLOBALS"}["jvnlrcvwrj"]}=$db->single("SELECT COUNT(*) FROM ".${${"GLOBALS"}["cyucfo"]}."_delete");$bubwopvc="recordcount";${"GLOBALS"}["jbsnkxxbitp"]="output";$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});$ufhrlfxxvd="p";${$ybdlzyg}=$db->single("SELECT COUNT(*) FROM ".${${"GLOBALS"}["cyucfo"]}."_delete
	LEFT JOIN users AS users1 ON users1.id=".${${"GLOBALS"}["cyucfo"]}."_delete.auser
	LEFT JOIN users AS users2 ON users2.id=".${${"GLOBALS"}["vmegalxcgreg"]}."_delete.duser
	$sqlsearch
	");$db->bindMore(${${"GLOBALS"}["xgqxigl"]});${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT ".${$pfyisbcrprq}."_delete.id AS id,".${$ufhrlfxxvd}."_delete.name,".${${"GLOBALS"}["itehsejmlx"]}."_delete.title,".${$rxuhdv}."_delete.phone,".${${"GLOBALS"}["cyucfo"]}."_delete.email,".${${"GLOBALS"}["hkpyvgjw"]}."_delete.address,".${$dknpuprif}."_delete.adate,".${${"GLOBALS"}["cyucfo"]}."_delete.udate,users1.name AS aname,ddate,users2.name AS dname FROM ".${${"GLOBALS"}["cyucfo"]}."_delete
	LEFT JOIN users AS users1 ON users1.id=".${$uieuivtsiti}."_delete.auser
	LEFT JOIN users AS users2 ON users2.id=".${${"GLOBALS"}["cyucfo"]}."_delete.duser
	$sqlsearch
	ORDER BY $ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["jbsnkxxbitp"]}=array("draw"=>${${"GLOBALS"}["njzrsmqnw"]},"recordsTotal"=>${${"GLOBALS"}["jvnlrcvwrj"]},"recordsFiltered"=>${$bubwopvc},"data"=>array());${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${${"GLOBALS"}["rnolkxckcnx"]}){${"GLOBALS"}["xojigetfq"]="data";${${"GLOBALS"}["xojigetfq"]}[]=array("id"=>"$get->id","name"=>"$get->name","title"=>"$get->title","phone"=>"$get->phone","email"=>"$get->email","address"=>"$get->address","auser"=>"$get->aname","adate"=>"$get->adate","duser"=>"$get->dname","ddate"=>"$get->ddate");}${${"GLOBALS"}["fyesxkwry"]}["data"]=${${"GLOBALS"}["mstezmkfs"]};echo json_encode(${$rfappyrf});}elseif(${${"GLOBALS"}["ofkwltigwipi"]}=="privateschedules"&&${$bfbdhvuydw}==""){$ptneolibqmz="draw";$ondohy="gets";${"GLOBALS"}["cgddeurjuhlj"]="orderfinal";${"GLOBALS"}["ggabwsgcuej"]="draw";${"GLOBALS"}["yhepopmdwn"]="search";$mpetddcj="get";$nmtvnni="datestart";${"GLOBALS"}["rcuhjkwnzwu"]="total";$fixdbwngk="note";${"GLOBALS"}["rlnpcmoskr"]="start";${"GLOBALS"}["lnejdujho"]="i";${"GLOBALS"}["rhqcnmc"]="length";${$ptneolibqmz}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";${${"GLOBALS"}["rhqcnmc"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";$tshekkn="search";$fpirjju="data";$melzpcmhzsc="sqlsearch";${"GLOBALS"}["jnrvyjm"]="notecount";$xqxzgeued="dateend";${${"GLOBALS"}["rlnpcmoskr"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${${"GLOBALS"}["cgddeurjuhlj"]}="";for(${${"GLOBALS"}["lnejdujho"]}=0;${${"GLOBALS"}["hecjsmsbqw"]}<=20;${${"GLOBALS"}["hecjsmsbqw"]}++){${"GLOBALS"}["deqklipenccg"]="ordersort";${"GLOBALS"}["wmmgbje"]="orderfinal";${"GLOBALS"}["rlcopvxph"]="i";${"GLOBALS"}["exuwicvj"]="i";${"GLOBALS"}["xfnjyktqzkq"]="i";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][${${"GLOBALS"}["exuwicvj"]}]["column"]))?$_GET["order"][${${"GLOBALS"}["rlcopvxph"]}]["column"]:"";if(${${"GLOBALS"}["dqostybleq"]}!=""){${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${${"GLOBALS"}["dqostybleq"]}]["data"];}${${"GLOBALS"}["deqklipenccg"]}=htmlspecialchars(isset($_GET["order"][${${"GLOBALS"}["hecjsmsbqw"]}]["dir"]))?$_GET["order"][${${"GLOBALS"}["xfnjyktqzkq"]}]["dir"]:"";if(${${"GLOBALS"}["wmmgbje"]}!=""&&${${"GLOBALS"}["dqostybleq"]}!=""){${"GLOBALS"}["kpogvjpu"]="orderfinal";${${"GLOBALS"}["kpogvjpu"]}.=", ";}${${"GLOBALS"}["nsvkum"]}.="$ordertable $ordersort";}${$melzpcmhzsc}=" WHERE 1";${${"GLOBALS"}["ccjlcdgqevb"]}=array();${"GLOBALS"}["anksyobjsvqs"]="dateend";${"GLOBALS"}["dimwobof"]="total";$fdorpfko="contentcount";${"GLOBALS"}["berojconf"]="searchcount";${"GLOBALS"}["glesvnvcvsol"]="search";$ariysrtub="notify";${$tshekkn}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${"GLOBALS"}["tqhihv"]="dateend";${"GLOBALS"}["hjxswlbox"]="type";${${"GLOBALS"}["berojconf"]}=strlen(${${"GLOBALS"}["glesvnvcvsol"]});${"GLOBALS"}["xrqnxalqncbq"]="address";${"GLOBALS"}["wjmwoeqczso"]="output";${"GLOBALS"}["ovevkgljc"]="output";if(${${"GLOBALS"}["yhepopmdwn"]}!=""&&${${"GLOBALS"}["ekrlomnxft"]}>2){${"GLOBALS"}["lwppjut"]="sqlarray";$_GET["datestart"]="";$_GET["dateend"]="";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND ($p.content LIKE :search1 OR $p.address LIKE :search2 OR $p.note LIKE :search3) ";${"GLOBALS"}["gueuwep"]="sqlarray";${${"GLOBALS"}["ccjlcdgqevb"]}["search1"]="%$search%";${${"GLOBALS"}["lwppjut"]}["search2"]="%$search%";${${"GLOBALS"}["gueuwep"]}["search3"]="%$search%";}${${"GLOBALS"}["vdkgsrxonyb"]}=htmlspecialchars(isset($_GET["datestart"])&&$_GET["dateend"]!="")?$_GET["datestart"]:"01-01-2000";${${"GLOBALS"}["tqhihv"]}=htmlspecialchars(isset($_GET["dateend"])&&$_GET["dateend"]!="")?$_GET["dateend"]:"01-01-2030";${$nmtvnni}=date("Y-m-d",strtotime(${${"GLOBALS"}["vdkgsrxonyb"]}));${$xqxzgeued}=date("Y-m-d",strtotime(${${"GLOBALS"}["aktkbstp"]}));${"GLOBALS"}["umcxrixftq"]="type";${"GLOBALS"}["cnmdzatf"]="sqlarray";if(${${"GLOBALS"}["vdkgsrxonyb"]}==${${"GLOBALS"}["anksyobjsvqs"]}){${"GLOBALS"}["uwbnsdqhlz"]="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND $p.date=:datestart ";${${"GLOBALS"}["uwbnsdqhlz"]}["datestart"]="$datestart";}else{${${"GLOBALS"}["hqdnrdjuit"]}.=" AND ($p.date BETWEEN :datestart AND :dateend) ";${${"GLOBALS"}["ccjlcdgqevb"]}["datestart"]="$datestart";${${"GLOBALS"}["ccjlcdgqevb"]}["dateend"]="$dateend";}${"GLOBALS"}["spusacnobi"]="auser";${"GLOBALS"}["yoipobdfic"]="address";$hytjphl="sqlarray";${"GLOBALS"}["udegcpklhia"]="content";${${"GLOBALS"}["umcxrixftq"]}=htmlspecialchars(isset($_GET["type"]))?$_GET["type"]:"";if(${${"GLOBALS"}["hjxswlbox"]}!=""){${"GLOBALS"}["vblbgzuz"]="sqlsearch";${"GLOBALS"}["fpnvynh"]="sqlarray";${${"GLOBALS"}["vblbgzuz"]}.=" AND $p.type=:type ";${${"GLOBALS"}["fpnvynh"]}["type"]="$type";}${${"GLOBALS"}["udegcpklhia"]}=htmlspecialchars(isset($_GET["content"]))?$_GET["content"]:"";$eeduro="address";${$fdorpfko}=strlen(${${"GLOBALS"}["uhphfkbx"]});if(${${"GLOBALS"}["uhphfkbx"]}!=""&&${${"GLOBALS"}["htieogxunl"]}>2){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND $p.content LIKE :content ";${${"GLOBALS"}["ccjlcdgqevb"]}["content"]="%$content%";}$mqzhojwwrl="addresscount";${$eeduro}=htmlspecialchars(isset($_GET["address"]))?$_GET["address"]:"";${$mqzhojwwrl}=strlen(${${"GLOBALS"}["yoipobdfic"]});if(${${"GLOBALS"}["xrqnxalqncbq"]}!=""&&${${"GLOBALS"}["ngxokz"]}>2){$rdhcqqfk="sqlsearch";${$rdhcqqfk}.=" AND $p.address LIKE :address ";${${"GLOBALS"}["ccjlcdgqevb"]}["address"]="%$address%";}$ubqystrefq="recordcount";${$fixdbwngk}=htmlspecialchars(isset($_GET["note"]))?$_GET["note"]:"";${${"GLOBALS"}["frmicrftq"]}=strlen(${${"GLOBALS"}["otmrsqfgxmjg"]});${"GLOBALS"}["btberaqextt"]="notify";if(${${"GLOBALS"}["otmrsqfgxmjg"]}!=""&&${${"GLOBALS"}["jnrvyjm"]}>2){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND $p.note LIKE :note ";${${"GLOBALS"}["ccjlcdgqevb"]}["note"]="%$note%";}${$ariysrtub}=htmlspecialchars(isset($_GET["notify"]))?$_GET["notify"]:"";if(${${"GLOBALS"}["btberaqextt"]}!=""){${"GLOBALS"}["jwmykzf"]="sqlarray";$obrebpjpqiav="sqlsearch";${$obrebpjpqiav}.=" AND ($p.notify=:notify) ";${${"GLOBALS"}["jwmykzf"]}["notify"]="$notify";}${${"GLOBALS"}["spusacnobi"]}=htmlspecialchars(isset($_GET["auser"]))?$_GET["auser"]:"";if(${${"GLOBALS"}["wyooigqr"]}!=""){$oxgfxurjhi="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND $p.auser=:auser ";${$oxgfxurjhi}["auser"]="$auser";}${${"GLOBALS"}["rcuhjkwnzwu"]}=$db->single("SELECT COUNT(*) FROM $p");$db->bindMore(${${"GLOBALS"}["cnmdzatf"]});${$ubqystrefq}=$db->single("SELECT COUNT(*) FROM $p
	LEFT JOIN types ON types.id=$p.type
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch
	");$db->bindMore(${$hytjphl});${$ondohy}=$db->query("SELECT $p.id AS id,types.name AS type,types.bgcolor AS typebgcolor,types.color AS typecolor,$p.transfer,$p.date,$p.timestart,$p.timeend,$p.content,$p.address,$p.map,$p.notify,$p.note,$p.adate,$p.udate,users.name AS auser FROM $p
	LEFT JOIN types ON types.id=$p.type
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch  ORDER BY $orderfinal LIMIT $start,$length");${${"GLOBALS"}["ovevkgljc"]}=array("draw"=>${${"GLOBALS"}["ggabwsgcuej"]},"recordsTotal"=>${${"GLOBALS"}["dimwobof"]},"recordsFiltered"=>${${"GLOBALS"}["dlfvgvdkiyfm"]},"data"=>array());${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${$mpetddcj}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","type"=>"$get->type","typebgcolor"=>"$get->typebgcolor","typecolor"=>"$get->typecolor","transfer"=>"$get->transfer","date"=>"$get->date","timestart"=>"$get->timestart","timeend"=>"$get->timeend","content"=>"$get->content","address"=>"$get->address","map"=>"$get->map","notify"=>"$get->notify","note"=>"$get->note","auser"=>"$get->auser","adate"=>"$get->adate","udate"=>"$get->udate");}${${"GLOBALS"}["wjmwoeqczso"]}["data"]=${$fpirjju};echo json_encode(${${"GLOBALS"}["fyesxkwry"]});}elseif(${${"GLOBALS"}["cyucfo"]}=="privateschedules"&&${${"GLOBALS"}["xcxrmqvbz"]}=="calendar"){$ymtifxlr="gets";$bdydwlfvgcsu="datestart";${"GLOBALS"}["kbuofcxgywh"]="dateend";$qtemgezh="gets";$tvbboky="dateend";$wvfhlooc="dateend";${${"GLOBALS"}["vdkgsrxonyb"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"01-01-2000";${$tvbboky}=htmlspecialchars(isset($_GET["end"]))?$_GET["end"]:"01-01-2000";${${"GLOBALS"}["vdkgsrxonyb"]}=date("Y-m-d 00:00:00",strtotime(${$bdydwlfvgcsu}));${$wvfhlooc}=date("Y-m-d 23:59:59",strtotime(${${"GLOBALS"}["kbuofcxgywh"]}));${$ymtifxlr}=$db->query("SELECT id,CONCAT(date,'T',timestart) AS datestart,CONCAT(date,'T',timeend) AS dateend,content FROM $p WHERE (date BETWEEN '$datestart' AND '$dateend')");${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${$qtemgezh} as${${"GLOBALS"}["rnolkxckcnx"]}){${"GLOBALS"}["rxolhzrvskg"]="data";${${"GLOBALS"}["rxolhzrvskg"]}[]=array("id"=>"$get->id","start"=>"$get->datestart","end"=>"$get->dateend","title"=>"$get->content");}echo json_encode(${${"GLOBALS"}["oahevqvtz"]});}elseif(${${"GLOBALS"}["cyucfo"]}=="privateschedules"&&${${"GLOBALS"}["xcxrmqvbz"]}=="deleted"){${"GLOBALS"}["nektqttba"]="draw";${"GLOBALS"}["pkftvdyml"]="output";$ptioblfgwmq="sqlarray";$uwluetnxh="sqlsearch";${"GLOBALS"}["ritqlnojzh"]="data";${"GLOBALS"}["nybrqfegcej"]="length";${"GLOBALS"}["iqxodedchq"]="recordcount";$ketocchs="p";${${"GLOBALS"}["nektqttba"]}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";${"GLOBALS"}["qiloawzllyns"]="p";$hatewfnc="ordertable";${"GLOBALS"}["ptstnhxb"]="search";${${"GLOBALS"}["nybrqfegcej"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${${"GLOBALS"}["yvpjlkpq"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";${$hatewfnc}=$_GET["columns"][${${"GLOBALS"}["dqostybleq"]}]["data"];${${"GLOBALS"}["whfudgpdm"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";$oaxenoaiciz="data";${$uwluetnxh}="";${${"GLOBALS"}["ccjlcdgqevb"]}=array();${${"GLOBALS"}["ttiknyszrry"]}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${"GLOBALS"}["paucdubx"]="total";${"GLOBALS"}["mkvhavi"]="p";${"GLOBALS"}["eitmfcn"]="p";${"GLOBALS"}["ylojdxqbjcb"]="p";${${"GLOBALS"}["ekrlomnxft"]}=strlen(${${"GLOBALS"}["ptstnhxb"]});${"GLOBALS"}["jcthwymj"]="p";$bdqumxjvxxz="output";${"GLOBALS"}["rcnost"]="p";$aeqhjstzat="p";if(${${"GLOBALS"}["ttiknyszrry"]}!=""&&${${"GLOBALS"}["ekrlomnxft"]}>2){${"GLOBALS"}["fhsxldft"]="sqlarray";$xsebesfmcenm="p";${"GLOBALS"}["qniilsbht"]="sqlarray";$lbvyqqwrhr="sqlsearch";${$lbvyqqwrhr}.=" WHERE (".${$xsebesfmcenm}."_delete.content LIKE :search1 OR ".${${"GLOBALS"}["cyucfo"]}."_delete.address LIKE :search2 OR ".${${"GLOBALS"}["cyucfo"]}."_delete.note LIKE :search3) ";${${"GLOBALS"}["qniilsbht"]}["search1"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search2"]="%$search%";${${"GLOBALS"}["fhsxldft"]}["search3"]="%$search%";}${${"GLOBALS"}["paucdubx"]}=$db->single("SELECT COUNT(*) FROM ".${${"GLOBALS"}["rcnost"]}."_delete");${"GLOBALS"}["uysmsmxhfl"]="p";$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${"GLOBALS"}["gssqjtwbtdf"]="p";${${"GLOBALS"}["iqxodedchq"]}=$db->single("SELECT COUNT(*) FROM ".${$ketocchs}."_delete
	LEFT JOIN types ON types.id=".${${"GLOBALS"}["ylojdxqbjcb"]}."_delete.type
	LEFT JOIN users AS users1 ON users1.id=".${${"GLOBALS"}["gssqjtwbtdf"]}."_delete.auser
	LEFT JOIN users AS users2 ON users2.id=".${${"GLOBALS"}["cyucfo"]}."_delete.duser
	$sqlsearch
	");$txywtxlphe="output";$db->bindMore(${$ptioblfgwmq});${"GLOBALS"}["xbjfydb"]="p";$rlatovjiyc="p";${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT ".${$aeqhjstzat}."_delete.id AS id,types.name AS type,".${${"GLOBALS"}["cyucfo"]}."_delete.date,".${${"GLOBALS"}["cyucfo"]}."_delete.timestart,".${$rlatovjiyc}."_delete.timeend,".${${"GLOBALS"}["cyucfo"]}."_delete.content,".${${"GLOBALS"}["qiloawzllyns"]}."_delete.address,".${${"GLOBALS"}["jcthwymj"]}."_delete.map,".${${"GLOBALS"}["cyucfo"]}."_delete.notify,".${${"GLOBALS"}["xbjfydb"]}."_delete.note,".${${"GLOBALS"}["cyucfo"]}."_delete.adate,users1.name AS aname,ddate,users2.name AS dname FROM ".${${"GLOBALS"}["cyucfo"]}."_delete
	LEFT JOIN types ON types.id=".${${"GLOBALS"}["eitmfcn"]}."_delete.type
	LEFT JOIN users AS users1 ON users1.id=".${${"GLOBALS"}["mkvhavi"]}."_delete.auser
	LEFT JOIN users AS users2 ON users2.id=".${${"GLOBALS"}["uysmsmxhfl"]}."_delete.duser
	$sqlsearch
	ORDER BY $ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["pkftvdyml"]}=array("draw"=>${${"GLOBALS"}["njzrsmqnw"]},"recordsTotal"=>${${"GLOBALS"}["jvnlrcvwrj"]},"recordsFiltered"=>${${"GLOBALS"}["dlfvgvdkiyfm"]},"data"=>array());${${"GLOBALS"}["ritqlnojzh"]}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${${"GLOBALS"}["rnolkxckcnx"]}){$zlcwlqj="data";${$zlcwlqj}[]=array("id"=>"$get->id","type"=>"$get->type","date"=>"$get->date","timestart"=>"$get->timestart","timeend"=>"$get->timeend","content"=>"$get->content","address"=>"$get->address","map"=>"$get->map","notify"=>"$get->notify","note"=>"$get->note","auser"=>"$get->aname","adate"=>"$get->adate","duser"=>"$get->dname","ddate"=>"$get->ddate");}${$txywtxlphe}["data"]=${$oaxenoaiciz};echo json_encode(${$bdqumxjvxxz});}elseif(${${"GLOBALS"}["cyucfo"]}=="privateschedules"&&${${"GLOBALS"}["nvrrsrvxd"]}=="address"){${${"GLOBALS"}["uxehnnfrcp"]}=htmlspecialchars(isset($_GET["query"]))?$_GET["query"]:"";${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT DISTINCT $m FROM $p WHERE $m LIKE :add ORDER BY id DESC  LIMIT 10",array("add"=>"%$query%"));${${"GLOBALS"}["htcglx"]}=count(${${"GLOBALS"}["fkxzsdyfycfe"]});foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${${"GLOBALS"}["rnolkxckcnx"]}){${${"GLOBALS"}["oahevqvtz"]}["suggestions"][]=$get->address;}if(${${"GLOBALS"}["htcglx"]}!="0"){echo json_encode(${${"GLOBALS"}["oahevqvtz"]});}}elseif(${${"GLOBALS"}["cyucfo"]}=="inventory"&&${${"GLOBALS"}["xcxrmqvbz"]}==""){$pkacgqpxuw="length";${"GLOBALS"}["szxbihkk"]="total";${"GLOBALS"}["bbpsnfbrma"]="ordertable";${${"GLOBALS"}["njzrsmqnw"]}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";${"GLOBALS"}["wlcfymgov"]="output";$txgyudovjbbo="ordertable";${"GLOBALS"}["kqucks"]="data";$kfrcbfyi="gets";${$pkacgqpxuw}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${${"GLOBALS"}["yvpjlkpq"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${"GLOBALS"}["olfjfqrvlw"]="ordersort";${"GLOBALS"}["vspjvuswq"]="data";${"GLOBALS"}["mevlgljgkax"]="search";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";${${"GLOBALS"}["bbpsnfbrma"]}=$_GET["columns"][${$txgyudovjbbo}]["data"];${${"GLOBALS"}["olfjfqrvlw"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";$xetsrpos="searchcount";${"GLOBALS"}["tonrupehbgl"]="search";$ihygsiquu="search";${${"GLOBALS"}["hqdnrdjuit"]}=" WHERE 1 ";${${"GLOBALS"}["ccjlcdgqevb"]}=array();${$ihygsiquu}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${$xetsrpos}=strlen(${${"GLOBALS"}["tonrupehbgl"]});$oziprstgryo="output";if(${${"GLOBALS"}["mevlgljgkax"]}!=""&&${${"GLOBALS"}["ekrlomnxft"]}>2){${"GLOBALS"}["wjnflopjj"]="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND ($p.name LIKE :search1) OR users.name LIKE :search2 ";${${"GLOBALS"}["ccjlcdgqevb"]}["search1"]="%$search%";${${"GLOBALS"}["wjnflopjj"]}["search2"]="%$search%";}${"GLOBALS"}["wpfhlz"]="sqlarray";${${"GLOBALS"}["szxbihkk"]}=$db->single("SELECT COUNT(*) FROM $p");$db->bindMore(${${"GLOBALS"}["wpfhlz"]});${${"GLOBALS"}["dlfvgvdkiyfm"]}=$db->single("SELECT COUNT(*) FROM $p
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch
	");$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT $p.id AS id,$p.name,$p.quantity,$p.adate,$p.udate,users.name AS aname FROM $p
	LEFT JOIN users ON users.id=$p.auser
	$sqlsearch  ORDER BY $ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["wlcfymgov"]}=array("draw"=>${${"GLOBALS"}["njzrsmqnw"]},"recordsTotal"=>${${"GLOBALS"}["jvnlrcvwrj"]},"recordsFiltered"=>${${"GLOBALS"}["dlfvgvdkiyfm"]},"data"=>array());${${"GLOBALS"}["vspjvuswq"]}=array();foreach(${$kfrcbfyi} as${${"GLOBALS"}["rnolkxckcnx"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","name"=>"$get->name","quantity"=>"$get->quantity","auser"=>"$get->aname","adate"=>"$get->adate","udate"=>"$get->udate");}${${"GLOBALS"}["fyesxkwry"]}["data"]=${${"GLOBALS"}["kqucks"]};echo json_encode(${$oziprstgryo});}elseif(${${"GLOBALS"}["cyucfo"]}=="inventory"&&${$vihyvsrbzhy}=="processlist"){$enwtwwvdk="output";$iurkmy="draw";${"GLOBALS"}["gvkgklyqsor"]="length";$ecenqytse="recordcount";${"GLOBALS"}["idfpmfgfe"]="start";${"GLOBALS"}["njzcxs"]="data";${"GLOBALS"}["qpxseut"]="sqlarray";${$iurkmy}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";${"GLOBALS"}["laesncniti"]="ordertable";${${"GLOBALS"}["gvkgklyqsor"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${${"GLOBALS"}["idfpmfgfe"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";${${"GLOBALS"}["laesncniti"]}=$_GET["columns"][${${"GLOBALS"}["dqostybleq"]}]["data"];$lafymxx="sqlarray";${"GLOBALS"}["qymsdswenlt"]="total";${"GLOBALS"}["hwhccji"]="search";${${"GLOBALS"}["whfudgpdm"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${${"GLOBALS"}["hqdnrdjuit"]}=" WHERE 1 ";${"GLOBALS"}["pzhlmso"]="draw";${"GLOBALS"}["feoefatdv"]="search";${$lafymxx}=array();${${"GLOBALS"}["wmcfmnur"]}=htmlspecialchars(isset($_GET["rid"]))?$_GET["rid"]:"";if(${${"GLOBALS"}["wmcfmnur"]}!=""){$gzuejvkwh="sqlsearch";${$gzuejvkwh}.=" AND inventory_process.rid=:rid ";${${"GLOBALS"}["ccjlcdgqevb"]}["rid"]="$rid";}${${"GLOBALS"}["hwhccji"]}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";$ymtelekl="output";${${"GLOBALS"}["ekrlomnxft"]}=strlen(${${"GLOBALS"}["ttiknyszrry"]});$sovieddpovii="recordcount";if(${${"GLOBALS"}["feoefatdv"]}!=""&&${${"GLOBALS"}["ekrlomnxft"]}>2){${${"GLOBALS"}["hqdnrdjuit"]}.=" AND inventory_process.name LIKE :search1 ";${${"GLOBALS"}["ccjlcdgqevb"]}["search1"]="%$search%";}${"GLOBALS"}["uxqbmlxdmnr"]="get";${${"GLOBALS"}["jvnlrcvwrj"]}=$db->single("SELECT COUNT(*) FROM inventory_process WHERE rid=:rid",array("rid"=>"$rid"));$db->bindMore(${${"GLOBALS"}["qpxseut"]});$yfdofbm="gets";${$sovieddpovii}=$db->single("SELECT COUNT(*) FROM inventory_process
	LEFT JOIN users ON users.id=inventory_process.auser
	$sqlsearch
	");${"GLOBALS"}["awxsepvxvd"]="sqlarray";$db->bindMore(${${"GLOBALS"}["awxsepvxvd"]});${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT inventory_process.id AS id,inventory_process.process,inventory_process.name,inventory_process.quantity,inventory_process.adate,inventory_process.udate,users.name AS aname FROM inventory_process
	LEFT JOIN users ON users.id=inventory_process.auser
	$sqlsearch  ORDER BY $ordertable $ordersort LIMIT $start,$length");${$enwtwwvdk}=array("draw"=>${${"GLOBALS"}["pzhlmso"]},"recordsTotal"=>${${"GLOBALS"}["qymsdswenlt"]},"recordsFiltered"=>${$ecenqytse},"data"=>array());${${"GLOBALS"}["njzcxs"]}=array();foreach(${$yfdofbm} as${${"GLOBALS"}["uxqbmlxdmnr"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","process"=>"$get->process","name"=>"$get->name","quantity"=>"$get->quantity","auser"=>"$get->aname","adate"=>"$get->adate","udate"=>"$get->udate");}${${"GLOBALS"}["fyesxkwry"]}["data"]=${${"GLOBALS"}["oahevqvtz"]};echo json_encode(${$ymtelekl});}elseif(${${"GLOBALS"}["wdjsav"]}=="inventory"&&${${"GLOBALS"}["xcxrmqvbz"]}=="deleted"){${"GLOBALS"}["byphpdkl"]="ordertable";${"GLOBALS"}["dlmjfflrmkkl"]="sqlarray";$mjjpgduq="p";$mohymcdeqq="ordersort";$desdnzf="output";${"GLOBALS"}["ijiplznz"]="draw";${${"GLOBALS"}["njzrsmqnw"]}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";${"GLOBALS"}["uwvkqkpepd"]="search";$cspopliet="total";$osigtfei="output";$bkmkrtbdirq="sqlarray";${${"GLOBALS"}["trnnikimudp"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${${"GLOBALS"}["yvpjlkpq"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";$igxcnhvjqbd="p";${"GLOBALS"}["wzhlbraksr"]="p";${"GLOBALS"}["xrauat"]="searchcount";$jgsgbto="p";${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${${"GLOBALS"}["byphpdkl"]}]["data"];${$mohymcdeqq}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${${"GLOBALS"}["hqdnrdjuit"]}="";$usmilave="search";${$bkmkrtbdirq}=array();${${"GLOBALS"}["uwvkqkpepd"]}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${${"GLOBALS"}["xrauat"]}=strlen(${${"GLOBALS"}["ttiknyszrry"]});${"GLOBALS"}["chzfbae"]="recordcount";${"GLOBALS"}["uxchibk"]="p";if(${$usmilave}!=""&&${${"GLOBALS"}["ekrlomnxft"]}>2){$dewecdejin="p";${"GLOBALS"}["gitnsfiybfg"]="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" WHERE (".${$dewecdejin}."_delete.name LIKE :search1) ";${${"GLOBALS"}["gitnsfiybfg"]}["search1"]="%$search%";}${${"GLOBALS"}["jvnlrcvwrj"]}=$db->single("SELECT COUNT(*) FROM ".${${"GLOBALS"}["cyucfo"]}."_delete");$db->bindMore(${${"GLOBALS"}["dlmjfflrmkkl"]});${"GLOBALS"}["utxjtqdfw"]="p";${${"GLOBALS"}["chzfbae"]}=$db->single("SELECT COUNT(*) FROM ".${$mjjpgduq}."_delete
	LEFT JOIN users AS users1 ON users1.id=".${${"GLOBALS"}["cyucfo"]}."_delete.auser
	LEFT JOIN users AS users2 ON users2.id=".${$jgsgbto}."_delete.duser
	$sqlsearch
	");$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT ".${${"GLOBALS"}["cyucfo"]}."_delete.id AS id,".${$igxcnhvjqbd}."_delete.name,".${${"GLOBALS"}["wzhlbraksr"]}."_delete.quantity,".${${"GLOBALS"}["cyucfo"]}."_delete.adate,users1.name AS aname,ddate,users2.name AS dname  FROM ".${${"GLOBALS"}["utxjtqdfw"]}."_delete
	LEFT JOIN users AS users1 ON users1.id=".${${"GLOBALS"}["cyucfo"]}."_delete.auser
	LEFT JOIN users AS users2 ON users2.id=".${${"GLOBALS"}["uxchibk"]}."_delete.duser
	$sqlsearch
	ORDER BY $ordertable $ordersort LIMIT $start,$length");${$osigtfei}=array("draw"=>${${"GLOBALS"}["ijiplznz"]},"recordsTotal"=>${$cspopliet},"recordsFiltered"=>${${"GLOBALS"}["dlfvgvdkiyfm"]},"data"=>array());${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${${"GLOBALS"}["rnolkxckcnx"]}){$eqtrigtsj="data";${$eqtrigtsj}[]=array("id"=>"$get->id","name"=>"$get->name","quantity"=>"$get->quantity","auser"=>"$get->aname","adate"=>"$get->adate","duser"=>"$get->dname","ddate"=>"$get->ddate");}${${"GLOBALS"}["fyesxkwry"]}["data"]=${${"GLOBALS"}["oahevqvtz"]};echo json_encode(${$desdnzf});}elseif(${${"GLOBALS"}["lyvydtkxfwm"]}=="privateschedules"&&${${"GLOBALS"}["twbowjxb"]}=="content"){${${"GLOBALS"}["uxehnnfrcp"]}=htmlspecialchars(isset($_GET["query"]))?$_GET["query"]:"";$cfdivsynjiub="gets";${"GLOBALS"}["luqnpjydpw"]="data";${$cfdivsynjiub}=$db->query("SELECT content,address FROM $p WHERE $m LIKE :search1 GROUP BY content ORDER BY id DESC  LIMIT 10",array("search1"=>"%$query%"));foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${${"GLOBALS"}["rnolkxckcnx"]}){{${"GLOBALS"}["exfnrwbm"]="data";${${"GLOBALS"}["exfnrwbm"]}["suggestions"][]=array("value"=>"$get->content","address"=>"$get->address");}}echo json_encode(${${"GLOBALS"}["luqnpjydpw"]});}elseif(${${"GLOBALS"}["cyucfo"]}=="privateschedules"&&${${"GLOBALS"}["xcxrmqvbz"]}=="address"){$whxzlrshgzd="query";$ufkkymwzly="gets";$qqihtrudke="get";${"GLOBALS"}["xouhasx"]="gets";${$whxzlrshgzd}=htmlspecialchars(isset($_GET["query"]))?$_GET["query"]:"";$ihtwxufgk="count";${$ufkkymwzly}=$db->query("SELECT DISTINCT $m FROM $p WHERE $m LIKE :add ORDER BY id DESC  LIMIT 10",array("add"=>"%$query%"));${$ihtwxufgk}=count(${${"GLOBALS"}["xouhasx"]});foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${$qqihtrudke}){${"GLOBALS"}["umngrpjlq"]="data";${${"GLOBALS"}["umngrpjlq"]}["suggestions"][]=$get->address;}if(${${"GLOBALS"}["htcglx"]}!="0"){${"GLOBALS"}["znkvovpfr"]="data";echo json_encode(${${"GLOBALS"}["znkvovpfr"]});}}elseif(${${"GLOBALS"}["cyucfo"]}=="changelog"&&${${"GLOBALS"}["ohelmgn"]}==""){${"GLOBALS"}["dowxciyx"]="draw";$xdkxwwkibnd="gets";$hllrcceui="sqlsearch";$mzfuiniwlur="ordersort";${${"GLOBALS"}["dowxciyx"]}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";$mnnqwue="start";$lpqqnlgu="get";$shmmxxeof="ordertable";${${"GLOBALS"}["trnnikimudp"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${"GLOBALS"}["bdvwtvtyqpv"]="output";${$mnnqwue}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";$vyflwjwfor="output";${$shmmxxeof}=$_GET["columns"][${${"GLOBALS"}["dqostybleq"]}]["data"];${$mzfuiniwlur}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${$hllrcceui}="";if(in_array("10",explode(",",$user->pageper))){${"GLOBALS"}["nowkbefnz"]="sqlsearch";${${"GLOBALS"}["nowkbefnz"]}.="SELECT users_log.rid AS id,users_log.process,users_log.ip,users_log.hostname,users_log.date,'Detay i??in t??klay??n??z' AS changelog,users.name AS name, 'Kullan??c??lar' AS pagename, 'users' AS module FROM users_log
	LEFT JOIN users ON users.id=users_log.user ";}$bbwuottx="data";if(in_array("20",explode(",",$user->pageper))){${"GLOBALS"}["kfmguojbg"]="sqlsearch";if(${${"GLOBALS"}["hqdnrdjuit"]}!=""){$zuwnmlckm="sqlsearch";${$zuwnmlckm}.=" UNION ALL ";}${${"GLOBALS"}["kfmguojbg"]}.="SELECT schedules_log.rid AS id,schedules_log.process,schedules_log.ip,schedules_log.hostname,schedules_log.date,schedules_log.changelog,users.name AS name, 'G??nl??k Program' AS pagename, 'schedules' AS module FROM schedules_log
	LEFT JOIN users ON users.id=schedules_log.user ";}if(in_array("30",explode(",",$user->pageper))){${"GLOBALS"}["fgpqplzwgwq"]="sqlsearch";if(${${"GLOBALS"}["hqdnrdjuit"]}!=""){${${"GLOBALS"}["hqdnrdjuit"]}.=" UNION ALL ";}${${"GLOBALS"}["fgpqplzwgwq"]}.="SELECT calls_log.rid AS id,calls_log.process,calls_log.ip,calls_log.hostname,calls_log.date,calls_log.changelog,users.name AS name, 'Aramalar' AS pagename, 'calls' AS module FROM calls_log
	LEFT JOIN users ON users.id=calls_log.user ";}if(in_array("40",explode(",",$user->pageper))){$kuwyfqdmrq="sqlsearch";${"GLOBALS"}["sbllvbtrqbr"]="sqlsearch";if(${${"GLOBALS"}["sbllvbtrqbr"]}!=""){${"GLOBALS"}["xegodcvoljs"]="sqlsearch";${${"GLOBALS"}["xegodcvoljs"]}.=" UNION ALL ";}${$kuwyfqdmrq}.="SELECT appointments_log.rid AS id,appointments_log.process,appointments_log.ip,appointments_log.hostname,appointments_log.date,appointments_log.changelog,users.name AS name, 'Randevular' AS pagename, 'appointments' AS module FROM appointments_log
	LEFT JOIN users ON users.id=appointments_log.user ";}if(in_array("50",explode(",",$user->pageper))){${"GLOBALS"}["bzsydhdhi"]="sqlsearch";$vexpljsyzn="sqlsearch";if(${$vexpljsyzn}!=""){$mirydvcwow="sqlsearch";${$mirydvcwow}.=" UNION ALL ";}${${"GLOBALS"}["bzsydhdhi"]}.="SELECT invitations_log.rid AS id,invitations_log.process,invitations_log.ip,invitations_log.hostname,invitations_log.date,invitations_log.changelog,users.name AS name, 'Davetler' AS pagename, 'invitations' AS module FROM invitations_log
	LEFT JOIN users ON users.id=invitations_log.user ";}if(in_array("60",explode(",",$user->pageper))){$slecwiout="sqlsearch";if(${${"GLOBALS"}["hqdnrdjuit"]}!=""){${${"GLOBALS"}["hqdnrdjuit"]}.=" UNION ALL ";}${$slecwiout}.="SELECT visits_log.rid AS id,visits_log.process,visits_log.ip,visits_log.hostname,visits_log.date,visits_log.changelog,users.name AS name, 'Ziyaretler' AS pagename, 'visits' AS module FROM visits_log
	LEFT JOIN users ON users.id=visits_log.user ";}if(in_array("70",explode(",",$user->pageper))){$pkllekonwim="sqlsearch";if(${$pkllekonwim}!=""){${"GLOBALS"}["znsumnwm"]="sqlsearch";${${"GLOBALS"}["znsumnwm"]}.=" UNION ALL ";}$bzmrbgy="sqlsearch";${$bzmrbgy}.="SELECT funerals_log.rid AS id,funerals_log.process,funerals_log.ip,funerals_log.hostname,funerals_log.date,funerals_log.changelog,users.name AS name, 'Cenazeler' AS pagename, 'funerals' AS module FROM funerals_log
	LEFT JOIN users ON users.id=funerals_log.user ";}if(in_array("80",explode(",",$user->pageper))){$bceaoephpy="sqlsearch";if(${$bceaoephpy}!=""){${"GLOBALS"}["oubcfwtru"]="sqlsearch";${${"GLOBALS"}["oubcfwtru"]}.=" UNION ALL ";}${${"GLOBALS"}["hqdnrdjuit"]}.="SELECT anniversaries_log.rid AS id,anniversaries_log.process,anniversaries_log.ip,anniversaries_log.hostname,anniversaries_log.date,anniversaries_log.changelog,users.name AS name, 'Y??l D??n??mleri' AS pagename, 'anniversaries' AS module FROM anniversaries_log
	LEFT JOIN users ON users.id=anniversaries_log.user ";}if(in_array("90",explode(",",$user->pageper))){${"GLOBALS"}["fihtgitjhnm"]="sqlsearch";if(${${"GLOBALS"}["hqdnrdjuit"]}!=""){${${"GLOBALS"}["hqdnrdjuit"]}.=" UNION ALL ";}${${"GLOBALS"}["fihtgitjhnm"]}.="SELECT waitschedules_log.rid AS id,waitschedules_log.process,waitschedules_log.ip,waitschedules_log.hostname,waitschedules_log.date,waitschedules_log.changelog,users.name AS name, 'Bekleyen Programlar' AS pagename, 'waitschedules' AS module FROM waitschedules_log
	LEFT JOIN users ON users.id=waitschedules_log.user ";}if(in_array("100",explode(",",$user->pageper))){if(${${"GLOBALS"}["hqdnrdjuit"]}!=""){${${"GLOBALS"}["hqdnrdjuit"]}.=" UNION ALL ";}${"GLOBALS"}["xmxennbpshhv"]="sqlsearch";${${"GLOBALS"}["xmxennbpshhv"]}.="SELECT addressbook_log.rid AS id,addressbook_log.process,addressbook_log.ip,addressbook_log.hostname,addressbook_log.date,addressbook_log.changelog,users.name AS name, 'Adres Defteri' AS pagename, 'addressbook' AS module FROM addressbook_log
	LEFT JOIN users ON users.id=addressbook_log.user ";}if(in_array("110",explode(",",$user->pageper))){if(${${"GLOBALS"}["hqdnrdjuit"]}!=""){${${"GLOBALS"}["hqdnrdjuit"]}.=" UNION ALL ";}${${"GLOBALS"}["hqdnrdjuit"]}.="SELECT privateschedules_log.rid AS id,privateschedules_log.process,privateschedules_log.ip,privateschedules_log.hostname,privateschedules_log.date,privateschedules_log.changelog,users.name AS name, '??zel Program' AS pagename, 'privateschedules' AS module FROM privateschedules_log
	LEFT JOIN users ON users.id=privateschedules_log.user ";}$lgickzyind="output";if(in_array("120",explode(",",$user->pageper))){${"GLOBALS"}["akeiwtxq"]="sqlsearch";$vuqkpevpcpij="sqlsearch";if(${$vuqkpevpcpij}!=""){${${"GLOBALS"}["hqdnrdjuit"]}.=" UNION ALL ";}${${"GLOBALS"}["akeiwtxq"]}.="SELECT inventory_log.rid AS id,inventory_log.process,inventory_log.ip,inventory_log.hostname,inventory_log.date,inventory_log.changelog,users.name AS name, 'Envanter' AS pagename, 'inventory' AS module FROM inventory_log
	LEFT JOIN users ON users.id=inventory_log.user ";}if(in_array("140",explode(",",$user->pageper))){${${"GLOBALS"}["hqdnrdjuit"]}.="";}${${"GLOBALS"}["jvnlrcvwrj"]}="1000";${$xdkxwwkibnd}=$db->query("$sqlsearch
	ORDER BY $ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["bdvwtvtyqpv"]}=array("draw"=>${${"GLOBALS"}["njzrsmqnw"]},"recordsTotal"=>${${"GLOBALS"}["jvnlrcvwrj"]},"recordsFiltered"=>${${"GLOBALS"}["jvnlrcvwrj"]},"data"=>array());${$bbwuottx}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${$lpqqnlgu}){$exhuyns="data";${$exhuyns}[]=array("id"=>"$get->id","module"=>"$get->module","pagename"=>"$get->pagename","date"=>"$get->date","process"=>"$get->process","name"=>"$get->name","ip"=>"$get->ip","hostname"=>"$get->hostname","changelog"=>"$get->changelog");}${$vyflwjwfor}["data"]=${${"GLOBALS"}["oahevqvtz"]};echo json_encode(${$lgickzyind});}elseif(${${"GLOBALS"}["cyucfo"]}=="labels"&&${${"GLOBALS"}["xcxrmqvbz"]}==""){$owepzhouzm="draw";$pgpogiada="output";$oqkghpbpc="search";${$owepzhouzm}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";$rlxxcvz="rid";${${"GLOBALS"}["trnnikimudp"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${"GLOBALS"}["ybcfgvae"]="sqlarray";${"GLOBALS"}["ttvypyd"]="total";${${"GLOBALS"}["yvpjlkpq"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${"GLOBALS"}["uukvivjkn"]="get";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${${"GLOBALS"}["dqostybleq"]}]["data"];${"GLOBALS"}["jgbxbtu"]="ordersort";${"GLOBALS"}["hzpvatfeo"]="sqlarray";$bykmyfduqug="search";$keqrcvrszpk="data";${${"GLOBALS"}["jgbxbtu"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";$mlyttqdgwl="p";${"GLOBALS"}["lnvcvwi"]="total";$jbzsdbrhks="data";$mwmrxycxrqwi="sqlarray";$ieqjtvqgccse="output";${${"GLOBALS"}["hqdnrdjuit"]}="WHERE 1  ";$swemrjsxk="searchcount";${${"GLOBALS"}["ybcfgvae"]}=array();$nctlljwm="searchcount";${$bykmyfduqug}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${$swemrjsxk}=strlen(${$oqkghpbpc});if(${${"GLOBALS"}["ttiknyszrry"]}!=""&&${$nctlljwm}>2){$xrdiqujn="sqlarray";${${"GLOBALS"}["hqdnrdjuit"]}.=" AND (labels.name LIKE :search1 OR labels.title LIKE :search2) ";${$xrdiqujn}["search1"]="%$search%";${${"GLOBALS"}["ccjlcdgqevb"]}["search2"]="%$search%";}$ghkgfvwht="gets";${${"GLOBALS"}["wmcfmnur"]}=htmlspecialchars(isset($_GET["rid"]))?$_GET["rid"]:"";if(${$rlxxcvz}!=""){$hcvcptwpugwc="sqlsearch";${$hcvcptwpugwc}.=" AND $p.rid=:rid ";${${"GLOBALS"}["ccjlcdgqevb"]}["rid"]="$rid";}${${"GLOBALS"}["lnvcvwi"]}=$db->single("SELECT COUNT(*) FROM labels");$db->bindMore(${$mwmrxycxrqwi});${${"GLOBALS"}["dlfvgvdkiyfm"]}=$db->single("SELECT COUNT(*) FROM labels
	$sqlsearch
	");$db->bindMore(${${"GLOBALS"}["hzpvatfeo"]});$ycryoiyqe="recordcount";${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("
	SELECT $p.id AS id,$p.name AS name,$p.title AS title,".${$mlyttqdgwl}."_group.name AS groupname FROM $p
	LEFT JOIN ".${${"GLOBALS"}["cyucfo"]}."_group ON ".${${"GLOBALS"}["cyucfo"]}."_group.id=$p.rid
	$sqlsearch
	ORDER BY $ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["fyesxkwry"]}=array("draw"=>${${"GLOBALS"}["njzrsmqnw"]},"recordsTotal"=>${${"GLOBALS"}["ttvypyd"]},"recordsFiltered"=>${$ycryoiyqe},"data"=>array());${$jbzsdbrhks}=array();foreach(${$ghkgfvwht} as${${"GLOBALS"}["uukvivjkn"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","name"=>"$get->name","title"=>"$get->title","groupname"=>"$get->groupname");}${$pgpogiada}["data"]=${$keqrcvrszpk};echo json_encode(${$ieqjtvqgccse});}elseif(${${"GLOBALS"}["cyucfo"]}=="labels"&&${$qwjdfegjq}=="deleted"){$inplgr="draw";${$inplgr}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";${"GLOBALS"}["kcueswxe"]="ordersort";${${"GLOBALS"}["trnnikimudp"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${${"GLOBALS"}["yvpjlkpq"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${"GLOBALS"}["woiwdrnubck"]="searchcount";$cptysokjondq="sqlsearch";$nwofjguayot="output";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${${"GLOBALS"}["dqostybleq"]}]["data"];${${"GLOBALS"}["kcueswxe"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";$rsrwsdw="gets";${"GLOBALS"}["fuiundkkpuw"]="sqlarray";${$cptysokjondq}="WHERE 1  ";${"GLOBALS"}["xandnutmx"]="recordcount";${${"GLOBALS"}["ccjlcdgqevb"]}=array();${"GLOBALS"}["yaypimly"]="search";${${"GLOBALS"}["yaypimly"]}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${"GLOBALS"}["kvyvjtl"]="recordcount";${${"GLOBALS"}["woiwdrnubck"]}=strlen(${${"GLOBALS"}["ttiknyszrry"]});if(${${"GLOBALS"}["ttiknyszrry"]}!=""&&${${"GLOBALS"}["ekrlomnxft"]}>2){${"GLOBALS"}["dqvldmxjpld"]="sqlsearch";$kyxnitxhjhnc="sqlarray";${${"GLOBALS"}["dqvldmxjpld"]}.=" AND (labels_delete.name LIKE :search1 OR labels_delete.title LIKE :search2) ";${${"GLOBALS"}["ccjlcdgqevb"]}["search1"]="%$search%";${$kyxnitxhjhnc}["search2"]="%$search%";}${${"GLOBALS"}["jvnlrcvwrj"]}=$db->single("SELECT COUNT(*) FROM labels_delete");$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${${"GLOBALS"}["kvyvjtl"]}=$db->single("SELECT COUNT(*) FROM labels_delete
	$sqlsearch
	");$db->bindMore(${${"GLOBALS"}["fuiundkkpuw"]});${"GLOBALS"}["nolbdsa"]="output";${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("
	SELECT labels_delete.id AS id,labels_delete.name AS name,labels_delete.title AS title,".${${"GLOBALS"}["cyucfo"]}."_group.name AS groupname,users.name AS dname,ddate FROM labels_delete
	LEFT JOIN ".${${"GLOBALS"}["cyucfo"]}."_group ON ".${${"GLOBALS"}["cyucfo"]}."_group.id=labels_delete.rid
	LEFT JOIN users ON users.id=labels_delete.duser
	$sqlsearch
	ORDER BY $ordertable $ordersort LIMIT $start,$length");${"GLOBALS"}["ekvojy"]="data";${${"GLOBALS"}["fyesxkwry"]}=array("draw"=>${${"GLOBALS"}["njzrsmqnw"]},"recordsTotal"=>${${"GLOBALS"}["jvnlrcvwrj"]},"recordsFiltered"=>${${"GLOBALS"}["xandnutmx"]},"data"=>array());${${"GLOBALS"}["ekvojy"]}=array();foreach(${$rsrwsdw} as${${"GLOBALS"}["rnolkxckcnx"]}){${"GLOBALS"}["pmcprn"]="data";${${"GLOBALS"}["pmcprn"]}[]=array("id"=>"$get->id","name"=>"$get->name","title"=>"$get->title","groupname"=>"$get->groupname","duser"=>"$get->dname","ddate"=>"$get->ddate");}${${"GLOBALS"}["nolbdsa"]}["data"]=${${"GLOBALS"}["oahevqvtz"]};echo json_encode(${$nwofjguayot});}elseif(${${"GLOBALS"}["qpxtfdssxkx"]}=="labels"&&${${"GLOBALS"}["xcxrmqvbz"]}=="group"){$qumrppt="ordertable";$mbixsyrcl="search";$vvnwmm="get";${"GLOBALS"}["gtibhvpq"]="p";${${"GLOBALS"}["njzrsmqnw"]}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";${${"GLOBALS"}["trnnikimudp"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${"GLOBALS"}["bwalqeerqq"]="start";${"GLOBALS"}["nodxogaugf"]="m";${${"GLOBALS"}["bwalqeerqq"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";${"GLOBALS"}["ruksrpp"]="sqlsearch";${$qumrppt}=$_GET["columns"][${${"GLOBALS"}["dqostybleq"]}]["data"];${"GLOBALS"}["puflqmzuxbl"]="search";$ajjrescygp="gets";${${"GLOBALS"}["whfudgpdm"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";$yerurgivu="p";${${"GLOBALS"}["ruksrpp"]}="WHERE 1  ";${${"GLOBALS"}["ccjlcdgqevb"]}=array();${"GLOBALS"}["ohnoiydrbhtb"]="m";${$mbixsyrcl}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${${"GLOBALS"}["ekrlomnxft"]}=strlen(${${"GLOBALS"}["ttiknyszrry"]});if(${${"GLOBALS"}["puflqmzuxbl"]}!=""&&${${"GLOBALS"}["ekrlomnxft"]}>2){${"GLOBALS"}["nxvregublkf"]="p";$jvicjdmxcrn="sqlarray";$sncrusphg="sqlsearch";${$sncrusphg}.=" AND ".${${"GLOBALS"}["nxvregublkf"]}."_".${${"GLOBALS"}["xcxrmqvbz"]}.".name LIKE :search1 ";${$jvicjdmxcrn}["search1"]="%$search%";}$hdybfprrs="p";${${"GLOBALS"}["jvnlrcvwrj"]}=$db->single("SELECT COUNT(*) FROM ".${${"GLOBALS"}["cyucfo"]}."_".${${"GLOBALS"}["xcxrmqvbz"]}."");$ngubryuwtk="output";$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${"GLOBALS"}["nczedkdevoo"]="p";${${"GLOBALS"}["dlfvgvdkiyfm"]}=$db->single("SELECT COUNT(*) FROM ".${${"GLOBALS"}["cyucfo"]}."_".${${"GLOBALS"}["ohnoiydrbhtb"]}."
	$sqlsearch
	");$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});${"GLOBALS"}["vbdljbuhog"]="m";${"GLOBALS"}["gctidcnm"]="total";${"GLOBALS"}["fmcudabr"]="gets";${"GLOBALS"}["nczcnjseov"]="recordcount";${"GLOBALS"}["rbmqcvh"]="m";$cojerkgy="data";${${"GLOBALS"}["fmcudabr"]}=$db->query("
	SELECT ".${$yerurgivu}."_".${${"GLOBALS"}["xcxrmqvbz"]}.".id AS id,".${${"GLOBALS"}["nczedkdevoo"]}."_".${${"GLOBALS"}["vbdljbuhog"]}.".name AS name, ".${${"GLOBALS"}["gtibhvpq"]}."_".${${"GLOBALS"}["xcxrmqvbz"]}.".adate,".${${"GLOBALS"}["cyucfo"]}."_".${${"GLOBALS"}["nodxogaugf"]}.".udate,users.name AS auser FROM ".${${"GLOBALS"}["cyucfo"]}."_".${${"GLOBALS"}["xcxrmqvbz"]}."
	LEFT JOIN users ON users.id=".${$hdybfprrs}."_".${${"GLOBALS"}["rbmqcvh"]}.".auser
	$sqlsearch
	ORDER BY $ordertable $ordersort LIMIT $start,$length");${$ngubryuwtk}=array("draw"=>${${"GLOBALS"}["njzrsmqnw"]},"recordsTotal"=>${${"GLOBALS"}["gctidcnm"]},"recordsFiltered"=>${${"GLOBALS"}["nczcnjseov"]},"data"=>array());${$cojerkgy}=array();foreach(${$ajjrescygp} as${$vvnwmm}){${"GLOBALS"}["dwpxjebqg"]="data";${${"GLOBALS"}["dwpxjebqg"]}[]=array("id"=>"$get->id","name"=>"$get->name","auser"=>"$get->auser","adate"=>"$get->adate","udate"=>"$get->udate");}${${"GLOBALS"}["fyesxkwry"]}["data"]=${${"GLOBALS"}["oahevqvtz"]};echo json_encode(${${"GLOBALS"}["fyesxkwry"]});}elseif(${$jnedhy}=="search"){$gsclql="draw";$jkbjmjtb="sqlarray";${"GLOBALS"}["yyavsquzlx"]="search";$gohjwzzpjgod="length";${"GLOBALS"}["sjvexinhx"]="start";${"GLOBALS"}["xbhegifuxgp"]="searchcount";${$gsclql}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";${$gohjwzzpjgod}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";${${"GLOBALS"}["sjvexinhx"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";${"GLOBALS"}["cnitpspw"]="searchcount";${${"GLOBALS"}["dqostybleq"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${${"GLOBALS"}["dqostybleq"]}]["data"];${${"GLOBALS"}["whfudgpdm"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${${"GLOBALS"}["hqdnrdjuit"]}="WHERE 1  ";${$jkbjmjtb}=array();${${"GLOBALS"}["yyavsquzlx"]}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${${"GLOBALS"}["xbhegifuxgp"]}=strlen(${${"GLOBALS"}["ttiknyszrry"]});if(${${"GLOBALS"}["ttiknyszrry"]}==""&&${${"GLOBALS"}["cnitpspw"]}<3){echo"{"draw":"\$draw\","recordsTotal\":\"0","recordsFiltered\":0,"data\":[]}";}else{${"GLOBALS"}["xhqlpplvltq"]="recordcount";$krhsrwbn="searchtype";${${"GLOBALS"}["asgabcnq"]}=htmlspecialchars(isset($_GET["searchtype"]))?$_GET["searchtype"]:"1";if(${$krhsrwbn}=="1"){${"GLOBALS"}["qlmudugwv"]="search";${${"GLOBALS"}["qlmudugwv"]}=str_replace(" ","%",${${"GLOBALS"}["ttiknyszrry"]});}${${"GLOBALS"}["jvnlrcvwrj"]}="0";$btabfvtse="data";${${"GLOBALS"}["dlfvgvdkiyfm"]}="0";$lhddsqef="total";$bqqkfqxs="output";${"GLOBALS"}["tjbqvgl"]="output";${$bqqkfqxs}=array("draw"=>${${"GLOBALS"}["njzrsmqnw"]},"recordsTotal"=>${$lhddsqef},"recordsFiltered"=>${${"GLOBALS"}["xhqlpplvltq"]},"data"=>array());${$btabfvtse}=array();if(in_array("20",explode(",",$user->pageper))){$ptvyvwutfy="get";${${"GLOBALS"}["grppesbwjb"]}=$db->query("SELECT id,date,CONCAT_WS(' ~~~ ',content,note) as content,'schedules' AS types,'G??nl??k Program' AS type FROM schedules WHERE content LIKE :search1 OR REPLACE(content, ' ', '') LIKE :search2 OR note LIKE :search3 ORDER BY id DESC LIMIT 100",array("search1"=>"%$search%","search2"=>"%$search%","search3"=>"%$search%"));foreach(${${"GLOBALS"}["grppesbwjb"]} as${$ptvyvwutfy}){${"GLOBALS"}["gxxymjoua"]="data";${${"GLOBALS"}["gxxymjoua"]}[]=array("id"=>"$get->id","date"=>"$get->date","content"=>"$get->content","types"=>"$get->types","type"=>"$get->type");}}if(in_array("30",explode(",",$user->pageper))){${"GLOBALS"}["egpevpgghsck"]="gets2";${${"GLOBALS"}["gtdgvxqwo"]}=$db->query("SELECT id,date,CONCAT_WS(' ~~~ ',name,title,subject,phone) as content,'calls' AS types,'Aramalar' AS type FROM calls WHERE name LIKE :search1 OR title LIKE :search2 OR phone LIKE :search3 OR REPLACE(phone, ' ', '') LIKE :search4 ORDER BY id DESC LIMIT 100",array("search1"=>"%$search%","search2"=>"%$search%","search3"=>"%$search%","search4"=>"%$search%"));foreach(${${"GLOBALS"}["egpevpgghsck"]} as${${"GLOBALS"}["rnolkxckcnx"]}){${"GLOBALS"}["mrudtyzkirzh"]="data";${${"GLOBALS"}["mrudtyzkirzh"]}[]=array("id"=>"$get->id","date"=>"$get->date","content"=>"$get->content","types"=>"$get->types","type"=>"$get->type");}}if(in_array("40",explode(",",$user->pageper))){$xfhhsntqu="gets3";${${"GLOBALS"}["iftgpex"]}=$db->query("SELECT id,date,CONCAT_WS(' ~~~ ',name,title,subject,phone) as content,'appointments' AS types,'Randevular' AS type FROM appointments WHERE name LIKE :search1 OR title LIKE :search2 OR phone LIKE :search3 OR REPLACE(phone, ' ', '') LIKE :search4 ORDER BY id DESC LIMIT 100",array("search1"=>"%$search%","search2"=>"%$search%","search3"=>"%$search%","search4"=>"%$search%"));foreach(${$xfhhsntqu} as${${"GLOBALS"}["rnolkxckcnx"]}){${"GLOBALS"}["pjqiphgxpwd"]="data";${${"GLOBALS"}["pjqiphgxpwd"]}[]=array("id"=>"$get->id","date"=>"$get->date","content"=>"$get->content","types"=>"$get->types","type"=>"$get->type");}}if(in_array("50",explode(",",$user->pageper))){${"GLOBALS"}["pddunefmvt"]="get";${${"GLOBALS"}["oijvmfot"]}=$db->query("SELECT id,datestart as date,CONCAT_WS(' ~~~ ',name,subject,phone) as content,'invitations' AS types,'Davetler' AS type FROM invitations WHERE name LIKE :search1 OR phone LIKE :search2 OR REPLACE(phone, ' ', '') LIKE :search3 ORDER BY id DESC LIMIT 100",array("search1"=>"%$search%","search2"=>"%$search%","search3"=>"%$search%"));foreach(${${"GLOBALS"}["oijvmfot"]} as${${"GLOBALS"}["pddunefmvt"]}){${"GLOBALS"}["ekonrssx"]="data";${${"GLOBALS"}["ekonrssx"]}[]=array("id"=>"$get->id","date"=>"$get->date","content"=>"$get->content","types"=>"$get->types","type"=>"$get->type");}}if(in_array("60",explode(",",$user->pageper))){${${"GLOBALS"}["nhgjden"]}=$db->query("SELECT id,date,CONCAT_WS(' ~~~ ',name,title,subject,phone) as content,'visits' AS types,'Ziyaretler' AS type FROM visits WHERE name LIKE :search1 OR title LIKE :search2 OR phone LIKE :search3 OR REPLACE(phone, ' ', '') LIKE :search4 ORDER BY id DESC LIMIT 100",array("search1"=>"%$search%","search2"=>"%$search%","search3"=>"%$search%","search4"=>"%$search%"));${"GLOBALS"}["hdhuieb"]="get";foreach(${${"GLOBALS"}["nhgjden"]} as${${"GLOBALS"}["hdhuieb"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","date"=>"$get->date","content"=>"$get->content","types"=>"$get->types","type"=>"$get->type");}}if(in_array("70",explode(",",$user->pageper))){${${"GLOBALS"}["nhgjden"]}=$db->query("SELECT id,date,CONCAT_WS(' ~~~ ',name,relative,phone) as content,'funerals' AS types,'Cenazeler' AS type FROM funerals WHERE name LIKE :search1 OR relative LIKE :search2 OR phone LIKE :search3 OR REPLACE(phone, ' ', '') LIKE :search4 ORDER BY id DESC LIMIT 100",array("search1"=>"%$search%","search2"=>"%$search%","search3"=>"%$search%","search4"=>"%$search%"));foreach(${${"GLOBALS"}["nhgjden"]} as${${"GLOBALS"}["rnolkxckcnx"]}){${"GLOBALS"}["lostomsr"]="data";${${"GLOBALS"}["lostomsr"]}[]=array("id"=>"$get->id","date"=>"$get->date","content"=>"$get->content","types"=>"$get->types","type"=>"$get->type");}}if(in_array("80",explode(",",$user->pageper))){${"GLOBALS"}["ornbkhsbmj"]="gets5";${${"GLOBALS"}["ornbkhsbmj"]}=$db->query("SELECT id,date,CONCAT_WS(' ~~~ ',name,nametwo,phone) as content,'anniversaries' AS types,'Y??l D??n??mleri' AS type FROM anniversaries WHERE name LIKE :search1 OR nametwo LIKE :search2 OR phone LIKE :search3 OR REPLACE(phone, ' ', '') LIKE :search4 ORDER BY id DESC LIMIT 100",array("search1"=>"%$search%","search2"=>"%$search%","search3"=>"%$search%","search4"=>"%$search%"));foreach(${${"GLOBALS"}["nhgjden"]} as${${"GLOBALS"}["rnolkxckcnx"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","date"=>"$get->date","content"=>"$get->content","types"=>"$get->types","type"=>"$get->type");}}if(in_array("90",explode(",",$user->pageper))){$sljrcx="gets6";$dkbipf="gets6";${$dkbipf}=$db->query("SELECT id,date,CONCAT_WS(' ~~~ ',content,note) as content,'waitschedules' AS types,'Bekleyen Programlar' AS type FROM waitschedules WHERE content LIKE :search1 OR REPLACE(content, ' ', '') LIKE :search2 OR note LIKE :search3 ORDER BY id DESC LIMIT 100",array("search1"=>"%$search%","search2"=>"%$search%","search3"=>"%$search%"));foreach(${$sljrcx} as${${"GLOBALS"}["rnolkxckcnx"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","date"=>"$get->date","content"=>"$get->content","types"=>"$get->types","type"=>"$get->type");}}if(in_array("110",explode(",",$user->pageper))){${"GLOBALS"}["sqqjgwp"]="get";${"GLOBALS"}["qapdthyam"]="gets7";${${"GLOBALS"}["htrkcmg"]}=$db->query("SELECT id,date,CONCAT_WS(' ~~~ ',content,note) as content,'privateschedules' AS types,'??zel Program' AS type FROM privateschedules WHERE content LIKE :search1 OR REPLACE(content, ' ', '') LIKE :search2 OR note LIKE :search3 ORDER BY id DESC LIMIT 100",array("search1"=>"%$search%","search2"=>"%$search%","search3"=>"%$search%"));foreach(${${"GLOBALS"}["qapdthyam"]} as${${"GLOBALS"}["sqqjgwp"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","date"=>"$get->date","content"=>"$get->content","types"=>"$get->types","type"=>"$get->type");}}${${"GLOBALS"}["tjbqvgl"]}["data"]=${${"GLOBALS"}["oahevqvtz"]};echo json_encode(${${"GLOBALS"}["fyesxkwry"]});}}elseif((${${"GLOBALS"}["cknnrflst"]}=="users"||${$levqjkjej}=="schedules"||${${"GLOBALS"}["cyucfo"]}=="calls"||${${"GLOBALS"}["cyucfo"]}=="appointments"||${$yqwphefgmsx}=="invitations"||${${"GLOBALS"}["cyucfo"]}=="visits"||${${"GLOBALS"}["cyucfo"]}=="funerals"||${${"GLOBALS"}["sxmmyemdsgje"]}=="anniversaries"||${$lzufnsxyxgi}=="waitschedules"||${${"GLOBALS"}["cyucfo"]}=="addressbook"||${${"GLOBALS"}["cyucfo"]}=="privateschedules"||${${"GLOBALS"}["cyucfo"]}=="inventory"||${${"GLOBALS"}["xfcjlfquao"]}=="labels")&&${${"GLOBALS"}["xcxrmqvbz"]}=="log"){$sgygemywwq="gets";$xwjskjtq="p";${"GLOBALS"}["hwlijjl"]="p";${"GLOBALS"}["hriwdndk"]="p";$utepznocox="p";$kxpkhi="p";$jiwchcd="gets";${$sgygemywwq}=$db->query("SELECT ".${$kxpkhi}."_log.ip,".${$utepznocox}."_log.hostname,DATE_FORMAT(".${${"GLOBALS"}["hwlijjl"]}."_log.date,'%d-%m-%Y %H:%i:%s') AS date,".${${"GLOBALS"}["cyucfo"]}."_log.changelog,users.name,CASE process WHEN '1' THEN 'Ekleme' WHEN '2' THEN 'De??i??tirme' WHEN '3' THEN 'Silme' END AS process FROM ".${$xwjskjtq}."_log LEFT JOIN users ON users.id=".${${"GLOBALS"}["hriwdndk"]}."_log.user WHERE rid='$id' ORDER BY ".${${"GLOBALS"}["cyucfo"]}."_log.id DESC");echo"<strong class="text-primary\">De??i??iklik Detaylar??</strong><br><br>";${"GLOBALS"}["szixsq"]="get";foreach(${$jiwchcd} as${${"GLOBALS"}["szixsq"]}){echo"<strong>????lem</strong>: $get->process , <strong>Kullan??c??</strong>: $get->name , <strong>Bilgisayar</strong>: $get->hostname , <strong>IP:</strong> $get->ip , <strong>Tarih</strong>: $get->date , <strong>Degi??iklikler</strong>: $get->changelog <hr>";}}elseif(${${"GLOBALS"}["lqfrpww"]}=="senders"){$cpdgeb="draw";$ppcryy="search";${$cpdgeb}=htmlspecialchars(isset($_GET["draw"]))?$_GET["draw"]:"0";${${"GLOBALS"}["trnnikimudp"]}=htmlspecialchars(isset($_GET["length"]))?$_GET["length"]:"10";$blxepuvjjzom="ordertable";${"GLOBALS"}["pekdjvxm"]="recordcount";$lmqlnld="data";${"GLOBALS"}["wuwuqes"]="ordersort";${"GLOBALS"}["wjlorfo"]="gets";${"GLOBALS"}["czbtvdqepe"]="sqlarray";${${"GLOBALS"}["yvpjlkpq"]}=htmlspecialchars(isset($_GET["start"]))?$_GET["start"]:"1";$bssoquv="draw";${$blxepuvjjzom}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";$irtiyiw="output";$qqixmlh="searchcount";${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${${"GLOBALS"}["dqostybleq"]}]["data"];${${"GLOBALS"}["wuwuqes"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${${"GLOBALS"}["hqdnrdjuit"]}="";${${"GLOBALS"}["czbtvdqepe"]}=array();${"GLOBALS"}["tcxaqgadatg"]="get";${$ppcryy}=htmlspecialchars(isset($_GET["search"]["value"]))?$_GET["search"]["value"]:"";${"GLOBALS"}["fdnwykhxugx"]="sqlarray";${${"GLOBALS"}["ekrlomnxft"]}=strlen(${${"GLOBALS"}["ttiknyszrry"]});${"GLOBALS"}["buoesfo"]="total";if(${${"GLOBALS"}["ttiknyszrry"]}!=""&&${$qqixmlh}>2){$gwrddqyhlu="sqlsearch";${$gwrddqyhlu}.=" WHERE ($p.name LIKE :search1 OR $p.email LIKE :search2 OR $p.phone LIKE :search3) ";${${"GLOBALS"}["ccjlcdgqevb"]}["search1"]="%$search%";${"GLOBALS"}["niqiolvo"]="sqlarray";${${"GLOBALS"}["ccjlcdgqevb"]}["search2"]="%$search%";${${"GLOBALS"}["niqiolvo"]}["search3"]="%$search%";}${${"GLOBALS"}["buoesfo"]}=$db->single("SELECT COUNT(*) FROM $p");$db->bindMore(${${"GLOBALS"}["fdnwykhxugx"]});${${"GLOBALS"}["dlfvgvdkiyfm"]}=$db->single("SELECT COUNT(*) FROM $p
	$sqlsearch
	");$db->bindMore(${${"GLOBALS"}["ccjlcdgqevb"]});$wbeebuk="gets";$japwihtder="data";${${"GLOBALS"}["wjlorfo"]}=$db->query("SELECT $p.id AS id,$p.name,$p.phone,$p.pstatus,$p.email,$p.estatus  FROM $p
	$sqlsearch
	ORDER BY $ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["fyesxkwry"]}=array("draw"=>${$bssoquv},"recordsTotal"=>${${"GLOBALS"}["jvnlrcvwrj"]},"recordsFiltered"=>${${"GLOBALS"}["pekdjvxm"]},"data"=>array());${$lmqlnld}=array();foreach(${$wbeebuk} as${${"GLOBALS"}["tcxaqgadatg"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","name"=>"$get->name","phone"=>"$get->phone","pstatus"=>"$get->pstatus","email"=>"$get->email","estatus"=>"$get->estatus");}${${"GLOBALS"}["fyesxkwry"]}["data"]=${$japwihtder};echo json_encode(${$irtiyiw});}elseif(${${"GLOBALS"}["fbimpshbwvun"]}=="assigns"){${"GLOBALS"}["fkytqxo"]="draw";${"GLOBALS"}["nfubtmo"]="gets";$hokhtisnxv="length";$hmhhnrywm="ordertable";${"GLOBALS"}["hfovfudu"]="start";${${"GLOBALS"}["njzrsmqnw"]}=$_GET["draw"];if(${${"GLOBALS"}["fkytqxo"]}==""){${${"GLOBALS"}["njzrsmqnw"]}="0";}$cxecnpstusnn="ordertable";${$hokhtisnxv}=$_GET["length"];$fydosbqnd="data";${"GLOBALS"}["iotgshlkilz"]="start";$kfxnmyf="output";${"GLOBALS"}["avvemo"]="total";if(${${"GLOBALS"}["trnnikimudp"]}==""){$nutrnil="length";${$nutrnil}="10";}$gisvmskv="output";$bdtwfpdsygj="searchcount";$odqpppxi="search";${"GLOBALS"}["swpoxrnbzma"]="get";${${"GLOBALS"}["hfovfudu"]}=$_GET["start"];${"GLOBALS"}["yarypcxkcx"]="output";if(${${"GLOBALS"}["iotgshlkilz"]}==""){${"GLOBALS"}["hqkowmxg"]="start";${${"GLOBALS"}["hqkowmxg"]}="1";}${$hmhhnrywm}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";${$cxecnpstusnn}=$_GET["columns"][${${"GLOBALS"}["dqostybleq"]}]["data"];${${"GLOBALS"}["whfudgpdm"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${${"GLOBALS"}["ttiknyszrry"]}=htmlspecialchars($_GET["search"]["value"]);${$bdtwfpdsygj}=strlen(${${"GLOBALS"}["ttiknyszrry"]});if(${$odqpppxi}!=""&&${${"GLOBALS"}["ekrlomnxft"]}>2){${${"GLOBALS"}["nbyhwisciey"]}=" WHERE (name LIKE '%$search%')";}else{${${"GLOBALS"}["nbyhwisciey"]}="";}${${"GLOBALS"}["avvemo"]}=$db->single("SELECT COUNT(*) FROM $p");${${"GLOBALS"}["dlfvgvdkiyfm"]}=$db->single("SELECT COUNT(*) FROM $p
	$searchsql");${${"GLOBALS"}["nfubtmo"]}=$db->query("SELECT * FROM $p
	$searchsql ORDER BY status DESC,$ordertable $ordersort LIMIT $start,$length");${$kfxnmyf}=array("draw"=>${${"GLOBALS"}["njzrsmqnw"]},"recordsTotal"=>${${"GLOBALS"}["jvnlrcvwrj"]},"recordsFiltered"=>${${"GLOBALS"}["dlfvgvdkiyfm"]},"data"=>array());${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${${"GLOBALS"}["fkxzsdyfycfe"]} as${${"GLOBALS"}["swpoxrnbzma"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","name"=>"$get->name","email"=>"$get->email","status"=>"$get->status");}${$gisvmskv}["data"]=${$fydosbqnd};echo json_encode(${${"GLOBALS"}["yarypcxkcx"]});}elseif(${$wwzosek}=="types"){${${"GLOBALS"}["njzrsmqnw"]}=$_GET["draw"];$yjkvgmgs="length";$cncagkciz="draw";if(${$cncagkciz}==""){${${"GLOBALS"}["njzrsmqnw"]}="0";}${"GLOBALS"}["elqkzjhew"]="length";${"GLOBALS"}["kfocppupih"]="start";$uabwjlqk="search";${${"GLOBALS"}["elqkzjhew"]}=$_GET["length"];$louxokop="search";if(${$yjkvgmgs}==""){$jniidxah="length";${$jniidxah}="10";}${${"GLOBALS"}["kfocppupih"]}=$_GET["start"];$fpxobirkzpk="ordersort";if(${${"GLOBALS"}["yvpjlkpq"]}==""){${"GLOBALS"}["sawheqjyr"]="start";${${"GLOBALS"}["sawheqjyr"]}="1";}${"GLOBALS"}["qbxhyyqosu"]="ordertable";${"GLOBALS"}["uxmgcctt"]="data";${"GLOBALS"}["rksejfyb"]="gets";${"GLOBALS"}["taqvwsy"]="output";$czpzrtmzsw="recordcount";${"GLOBALS"}["bbtjsgpi"]="ordertable";${${"GLOBALS"}["qbxhyyqosu"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";${${"GLOBALS"}["dqostybleq"]}=$_GET["columns"][${${"GLOBALS"}["bbtjsgpi"]}]["data"];${$fpxobirkzpk}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${$uabwjlqk}=htmlspecialchars($_GET["search"]["value"]);${${"GLOBALS"}["ekrlomnxft"]}=strlen(${$louxokop});$hfiuycw="draw";if(${${"GLOBALS"}["ttiknyszrry"]}!=""&&${${"GLOBALS"}["ekrlomnxft"]}>2){$qkvnmoxdub="searchsql";${$qkvnmoxdub}=" WHERE (name LIKE '%$search%')";}else{${${"GLOBALS"}["nbyhwisciey"]}="";}$mijslobdvzm="recordcount";${${"GLOBALS"}["jvnlrcvwrj"]}=$db->single("SELECT COUNT(*) FROM $p");${$mijslobdvzm}=$db->single("SELECT COUNT(*) FROM $p
	$searchsql");${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT * FROM $p
	$searchsql ORDER BY status DESC,$ordertable $ordersort LIMIT $start,$length");${${"GLOBALS"}["taqvwsy"]}=array("draw"=>${$hfiuycw},"recordsTotal"=>${${"GLOBALS"}["jvnlrcvwrj"]},"recordsFiltered"=>${$czpzrtmzsw},"data"=>array());${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${${"GLOBALS"}["rksejfyb"]} as${${"GLOBALS"}["rnolkxckcnx"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","name"=>"$get->name","typebgcolor"=>"$get->bgcolor","typecolor"=>"$get->color","status"=>"$get->status");}${${"GLOBALS"}["fyesxkwry"]}["data"]=${${"GLOBALS"}["uxmgcctt"]};echo json_encode(${${"GLOBALS"}["fyesxkwry"]});}elseif((${${"GLOBALS"}["cyucfo"]}=="invitations"&&${${"GLOBALS"}["zfajgindbn"]}=="type")||(${${"GLOBALS"}["cyucfo"]}=="visits"&&${$prytsebqmmk}=="type")){$dlfklsjhtus="length";${${"GLOBALS"}["njzrsmqnw"]}=$_GET["draw"];$ulvrfqeab="gets";$kwmnkvu="searchcount";${"GLOBALS"}["buuijkcmfend"]="ordertable";${"GLOBALS"}["eqffpqe"]="p";${"GLOBALS"}["qguwymann"]="total";$gzhsmpuql="start";$ukmhcqpccjs="data";${"GLOBALS"}["ggwbiwjxkan"]="p";if(${${"GLOBALS"}["njzrsmqnw"]}==""){${"GLOBALS"}["qjaenkpyclnu"]="draw";${${"GLOBALS"}["qjaenkpyclnu"]}="0";}${"GLOBALS"}["szxmyqkqwhhq"]="ordertable";$nhpjitrab="recordcount";$yhlcnzmyxxpo="m";${$dlfklsjhtus}=$_GET["length"];if(${${"GLOBALS"}["trnnikimudp"]}==""){${${"GLOBALS"}["trnnikimudp"]}="10";}${"GLOBALS"}["pbflfrcemk"]="ordertable";$uiofjxhpa="m";${$gzhsmpuql}=$_GET["start"];if(${${"GLOBALS"}["yvpjlkpq"]}==""){${${"GLOBALS"}["yvpjlkpq"]}="1";}$exuhxckt="output";${"GLOBALS"}["urtxvtierk"]="draw";${"GLOBALS"}["ekclxiizv"]="p";${"GLOBALS"}["bgiwipekwwd"]="search";$mpfojkswggt="total";${"GLOBALS"}["crfrasy"]="get";${${"GLOBALS"}["buuijkcmfend"]}=htmlspecialchars(isset($_GET["order"][0]["column"]))?$_GET["order"][0]["column"]:"";${${"GLOBALS"}["pbflfrcemk"]}=$_GET["columns"][${${"GLOBALS"}["szxmyqkqwhhq"]}]["data"];${${"GLOBALS"}["whfudgpdm"]}=htmlspecialchars(isset($_GET["order"][0]["dir"]))?$_GET["order"][0]["dir"]:"ASC";${${"GLOBALS"}["ttiknyszrry"]}=htmlspecialchars($_GET["search"]["value"]);${$kwmnkvu}=strlen(${${"GLOBALS"}["ttiknyszrry"]});if(${${"GLOBALS"}["bgiwipekwwd"]}!=""&&${${"GLOBALS"}["ekrlomnxft"]}>2){${"GLOBALS"}["inpdvlkdwap"]="searchsql";${${"GLOBALS"}["inpdvlkdwap"]}=" WHERE (name LIKE '%$search%')";}else{${"GLOBALS"}["gpvucqjjooe"]="searchsql";${${"GLOBALS"}["gpvucqjjooe"]}="";}${${"GLOBALS"}["qguwymann"]}=$db->single("SELECT COUNT(*) FROM ".${${"GLOBALS"}["ggwbiwjxkan"]}."_".${${"GLOBALS"}["xcxrmqvbz"]}."");${"GLOBALS"}["dqmmdtkm"]="gets";${$nhpjitrab}=$db->single("SELECT COUNT(*) FROM ".${${"GLOBALS"}["eqffpqe"]}."_".${$yhlcnzmyxxpo}."
	$searchsql");${${"GLOBALS"}["dqmmdtkm"]}=$db->query("SELECT * FROM ".${${"GLOBALS"}["ekclxiizv"]}."_".${$uiofjxhpa}."
	$searchsql ORDER BY status DESC,$ordertable $ordersort LIMIT $start,$length");${$exuhxckt}=array("draw"=>${${"GLOBALS"}["urtxvtierk"]},"recordsTotal"=>${$mpfojkswggt},"recordsFiltered"=>${${"GLOBALS"}["dlfvgvdkiyfm"]},"data"=>array());${${"GLOBALS"}["oahevqvtz"]}=array();foreach(${$ulvrfqeab} as${${"GLOBALS"}["crfrasy"]}){${${"GLOBALS"}["oahevqvtz"]}[]=array("id"=>"$get->id","name"=>"$get->name","status"=>"$get->status");}${${"GLOBALS"}["fyesxkwry"]}["data"]=${$ukmhcqpccjs};echo json_encode(${${"GLOBALS"}["fyesxkwry"]});}elseif(${${"GLOBALS"}["mdpltsq"]}=="emails"){}elseif(${${"GLOBALS"}["cyucfo"]}=="addressbook"&&${${"GLOBALS"}["xcxrmqvbz"]}=="search"){${"GLOBALS"}["qqgprfroat"]="query";$lobinau="gets";$yfdmruxumevl="gets";${${"GLOBALS"}["qqgprfroat"]}=htmlspecialchars(isset($_GET["query"]))?$_GET["query"]:"";${${"GLOBALS"}["fkxzsdyfycfe"]}=$db->query("SELECT * FROM addressbook WHERE name LIKE :search1 OR title LIKE :search2 OR phone LIKE :search3 OR REPLACE(phone, ' ', '') LIKE :search4 OR email LIKE :search5  OR address LIKE :search6 ORDER BY id DESC  LIMIT 10",array("search1"=>"%$query%","search2"=>"%$query%","search3"=>"%$query%","search4"=>"%$query%","search5"=>"%$query%","search6"=>"%$query%"));${${"GLOBALS"}["htcglx"]}=count(${$lobinau});foreach(${$yfdmruxumevl} as${${"GLOBALS"}["rnolkxckcnx"]}){{${"GLOBALS"}["msfvjzts"]="data";${${"GLOBALS"}["msfvjzts"]}["suggestions"][]=array("value"=>"$get->name","title"=>"$get->title","email"=>"$get->email","phone"=>"$get->phone","address"=>"$get->address");}}if(${${"GLOBALS"}["htcglx"]}!="0"){echo json_encode(${${"GLOBALS"}["oahevqvtz"]});}} ?>