public function testGettask()
{
$ligne = gettask();
$this->assertEquals("1;:!:;Test;:!:;23-01-2016;:!:;This is a test\n", $ligne[0]);
$this->assertEquals("1;:!:;tache et plus;:!:;23/25/2016\n", $ligne[1]);
$this->assertEquals("1;:!:;Test3;:!:;23/25/2016\n", $ligne[2]);
}
function displaytask($var)
{
$arraytask = gettask();
foreach ($arraytask as $task) {
if (substr_count($task, ';:!:;') == 2) {
list($code, $nom, $deadline) = explode(';:!:;', $task);
if ($var == $code) {
echo "<div class = \"task\"><p class=\"desctask-admin\">";
echo TXT_TACHE;
echo " : {$nom} </br>";
echo TXT_FIN;
echo " : {$deadline}</p>\n\t\t\t\t\t<form class=\"suptask\" method=\"post\" action=\"gestion_task.php\">\n\t\t\t\t\t<input type=\"hidden\" value=\"{$nom}\" name=\"del\">\n\t\t\t\t\t<button class=\"btn btnup\" type=\"submit\"><b>x</b></button> </form>\n\t\t\t\t\t<form class=\"edittask\" method = \"post\" action = \"gestion_task.php\">\n\t\t\t\t\t<input type=\"hidden\" value=\"{$nom}\" name=\"edit\">\n\t\t\t\t\t<button class=\"btn btnup\" type=\"submit\"><b>Edit</b></button> </form>\n";
if ($code != 3) {
echo "<form class=\"uptask\" method = \"post\" action = \"gestion_task.php\">\n\t\t\t\t\t\t<input type=\"hidden\" value=\"{$nom}\" name=\"nom\">\n\t\t\t\t\t\t<button class=\"btn btnup\" type=\"submit\"><b>></b></button></form>";
}
echo "</div>";
}
} elseif (substr_count($task, ';:!:;') > 2) {
list($code, $nom, $deadline, $content) = explode(';:!:;', $task, 4);
$content = unescapetohtml($content);
if ($var == $code) {
if ($code != 3) {
echo "<div class=\"task\"><p class=\"desctask-admin\">";
echo TXT_TACHE;
echo " : {$nom} </br>";
echo TXT_FIN;
echo " : {$deadline}</p>\n\t\t\t\t\t\t<form class=\"suptask\" method = \"post\" action = \"gestion_task.php\">\n\t\t\t\t\t\t<input type=\"hidden\" value=\"{$nom}\" name=\"del\">\n\t\t\t\t\t\t<button class=\"btn btnup\" type=\"submit\"><b>x</b></button> </form>\n\t\t\t\t\t\t<form class=\"edittask\" method = \"post\" action = \"gestion_task.php\">\n\t\t\t\t\t\t<input type=\"hidden\" value=\"{$nom}\" name=\"edit\">\n\t\t\t\t\t\t<button class=\"btn btnup\" type=\"submit\"><b>Edit</b></button> </form>\n\t\t\t\t\t\t<form class=\"uptask\" method = \"post\" action = \"gestion_task.php\">\n\t\t\t\t\t\t<input type=\"hidden\" value=\"{$nom}\" name=\"nom\">\n\t\t\t\t\t\t<button class=\"btn btnup\" type=\"submit\"><b>></b></button> </form>\n\t\t\t\t\t\t<p class=\"content\">";
echo TXT_DESCRIPTION;
echo " : {$content}</p></div>";
} else {
echo "<div class = \"task\"><p class=\"desctask-admin\">";
echo TXT_TACHE;
echo " : {$nom} </br>";
echo TXT_FIN;
echo " : {$deadline}</p>\n\t\t\t\t\t\t<form class=\"suptask\" method = \"post\" action = \"gestion_task.php\">\n\t\t\t\t\t\t<input type=\"hidden\" value=\"{$nom}\" name=\"del\">\n\t\t\t\t\t\t<button class=\"btn btnup\" type=\"submit\"><b>x</b></button> </form>\n\t\t\t\t\t\t<form class=\"edittask\" method = \"post\" action = \"gestion_task.php\">\n\t\t\t\t\t\t<input type=\"hidden\" value=\"{$nom}\" name=\"edit\">\n\t\t\t\t\t\t<button class=\"btn btnup\" type=\"submit\"><b>Edit</b></button> </form>\n\t\t\t\t\t\t<p class=\"content\">";
echo TXT_DESCRIPTION;
echo " : {$content}</p></div>";
}
}
}
}
}
//我的好友
$query = $_SGLOBAL['db']->query("SELECT fuid AS uid, fusername AS username, num FROM " . tname('friend') . " WHERE uid='{$space['uid']}' AND status='1' ORDER BY num DESC, dateline DESC LIMIT 0,30");
while ($value = $_SGLOBAL['db']->fetch_array($query)) {
if (empty($oluids[$value['uid']])) {
realname_set($value['uid'], $value['username']);
$olfriendlist[] = $value;
$olfcount++;
if ($olfcount == 15) {
break;
}
}
}
}
//获取任务
include_once S_ROOT . './source/function_space.php';
$task = gettask();
//好友生日
if ($space['feedfriend']) {
list($s_month, $s_day) = explode('-', sgmdate('n-j', $_SGLOBAL['timestamp'] - 3600 * 24 * 3));
//过期3天
list($n_month, $n_day) = explode('-', sgmdate('n-j', $_SGLOBAL['timestamp']));
list($e_month, $e_day) = explode('-', sgmdate('n-j', $_SGLOBAL['timestamp'] + 3600 * 24 * 7));
if ($e_month == $s_month) {
$wheresql = "sf.birthmonth='{$s_month}' AND sf.birthday>='{$s_day}' AND sf.birthday<='{$e_day}'";
} else {
$wheresql = "(sf.birthmonth='{$s_month}' AND sf.birthday>='{$s_day}') OR (sf.birthmonth='{$e_month}' AND sf.birthday<='{$e_day}' AND sf.birthday>'0')";
}
$query = $_SGLOBAL['db']->query("SELECT s.uid,s.username,s.name,s.namestatus,s.groupid,sf.birthyear,sf.birthmonth,sf.birthday\r\n\t\t\tFROM " . tname('spacefield') . " sf\r\n\t\t\tLEFT JOIN " . tname('space') . " s ON s.uid=sf.uid\r\n\t\t\tWHERE (sf.uid IN ({$space['feedfriend']})) AND ({$wheresql})");
while ($value = $_SGLOBAL['db']->fetch_array($query)) {
realname_set($value['uid'], $value['username'], $value['name'], $value['namestatus']);
$value['istoday'] = 0;
$netcache['SN'] = $_SN;
//写缓存操作
if ($writestate) {
include_once S_ROOT . './source/function_cache.php';
cache_write('network', "netcache", $netcache);
@unlink($lockfile);
}
}
if ($netcache['mtaglist']) {
@(include_once S_ROOT . './data/data_profield.php');
}
$_SN = $netcache['SN'];
//任务
@(include_once S_ROOT . './data/data_task.php');
include_once S_ROOT . './source/function_space.php';
if ($task = gettask()) {
$task['note'] = getstr($task['note'], 100, 0, 0, 0, 0, -1);
}
//大家的最新动态
$feedlist = array();
$query = $_SGLOBAL['db']->query("SELECT * FROM " . tname('feed') . " WHERE friend='0' ORDER BY dateline DESC LIMIT 0,10");
while ($value = $_SGLOBAL['db']->fetch_array($query)) {
realname_set($value['uid'], $value['username']);
$feedlist[] = $value;
}
//当前在线
$onlinelist = array();
$query = $_SGLOBAL['db']->query("SELECT * FROM " . tname('session') . " ORDER BY lastactivity DESC LIMIT 0,42");
while ($value = $_SGLOBAL['db']->fetch_array($query)) {
realname_set($value['uid'], $value['username']);
$onlinelist[] = $value;
function deletetask($nom)
{
$ligne = searchtask($nom);
$arraytask = gettask();
$fichier = fopen('db_task.txt', "w");
if ($fichier) {
foreach ($arraytask as $task) {
if ($ligne != $task) {
fputs($fichier, $task);
}
}
fclose($fichier);
}
}
$persons_id = $_REQUEST['persons_id'];
$phone = $_REQUEST['phone'];
$problem_comment = htmlspecialchars($_REQUEST['problem_comment'], ENT_QUOTES);
$client_name = $_REQUEST['client_name'];
$comment = htmlspecialchars($_REQUEST['comment'], ENT_QUOTES);
$hidden_inc = $_REQUEST['hidden_inc'];
$ast_incomming_id = $_REQUEST['ast_incomming_id'];
switch ($action) {
case 'get_add_page':
$user = $_SESSION['USERID'];
$number = $_REQUEST['number'];
$key = md5($user . $number);
$data = array('key' => $key, 'user' => $user);
break;
case 'get_edit_page':
$page = GetPage(gettask($task_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$user_id = $_SESSION['USERID'];
$user = $_SESSION['USERID'];
$group = checkgroup($user);
$filter = '';
if ($group != 1) {
$res_row = mysql_fetch_assoc(mysql_query("SELECT users.id as person_id\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t FROM \t`users`\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t WHERE `users`.`id` = {$user_id}"));
$filter = 'AND (task.responsible_user_id =' . $res_row[person_id] . ')';
}
$rResult = mysql_query("SELECT task.id,\r\n \t\t\t\t\t\t\t\t\tIF(task.incomming_call_id=0,task.date,incomming_call.date) AS date,\r\n \t\t\t\t\t\t\t\t\tIF(task.incomming_call_id!=0,incomming_call.phone, task.phone),\r\n \t\t\t\t\t\t\t\t\tIF(task.incomming_call_id!=0,incomming_call.`name`,task.`name`),\r\n \t\t\t\t\t\t\t\t\tpersons.`name` AS responsible,\r\n \t\t\t\t\t\t\t\t\tpersons1.`name` as gamcemi,\r\n \t\t\t\t\t\t\t\t\t`status`.`call_status` AS task_status,\r\n \t\t\t\t\t\t\t\t\ttime_format(SEC_TO_TIME(asterisk_incomming.duration), '%i:%s') as time,\r\n \t\t\t\t\t\t\t\t\tconcat('<button class=\\'download\\' str=',DATE_FORMAT(asterisk_incomming.call_datetime, '%Y/%m/%d/'),`asterisk_incomming`.`file_name`,'>მოსმენა</button>') as qmedeba\r\n \t\t\t\t\t\t\tFROM task\r\n \t\t\t\t\t\t\tLEFT JOIN incomming_call ON incomming_call.id=task.incomming_call_id\r\n \t\t\t\t\t\t\tLEFT JOIN asterisk_incomming ON asterisk_incomming.id=incomming_call.asterisk_incomming_id\r\n \t\t\t\t\t\t\tLEFT JOIN `status` ON `status`.id=task.`status`\r\n \t\t\t\t\t\t\tLEFT JOIN users ON task.responsible_user_id=users.id\r\n \t\t\t\t\t\t\tLEFT JOIN users AS users1 ON users1.id = task.user_id\r\n \t\t\t\t\t\t\tLEFT JOIN persons ON persons.id=users.person_id\r\n \t\t\t\t\t\t\tLEFT JOIN persons AS persons1 ON persons1.id=users1.person_id\r\n \t\t\t\t\t\t\tWHERE task.actived=1 and task.`status`= 1 AND task.task_type_id = 10 {$filter}\r\n\t \r\n\t\t\t\t\t\t\t\t\t");
$data = array("aaData" => array());
