PageRenderTime 52ms CodeModel.GetById 22ms RepoModel.GetById 0ms app.codeStats 0ms

/brakes.php

https://github.com/railroadman2k/ccss
PHP | 270 lines | 181 code | 56 blank | 33 comment | 44 complexity | 6c01c98fa4fa61bf685c40ba6ce7a45b MD5 | raw file
    

  1. <?
    2. 

  2. 

  3. 

  4. include "validator.php";
    5. 

  5. if(array_key_exists("selected_ticket_id", $_SESSION)) unset($_SESSION["selected_ticket_id"]);
    6. 

  6.  get_group_operations($xtpl, "#", "form1", (int)$_REQUEST["queue"]);
    7. 

  7.     $parameters = "";
    8. 

  8. if(array_key_exists("select", $_REQUEST))
    9. 

  9. {
    10. 

  10.     $_SESSION["selected_tickets"] = $_REQUEST["select"];
    11. 

  11.     $tmp = new group_operations($act);
    12. 

  12. }
    13. 

  13. 

  14. if($_SESSION['permission'] != "admin")
    15. 

  15. {
    16. 

  16.     header("Location: index.php");
    17. 

  17.     exit;
    18. 

  18. }
    19. 

  19. 

  20. 

  21. 

  22. 

  23. $cfg_sort_fields = array("#"=>array("field"=>"","sort"=>"","def_sort_type"=>"","sort_order"=>"","url_name"=>""),
    24. 

  24.                          "<a href=\"#\" onclick=\"return false\" onmouseup=\"select_all_checkboxs('select[]','form1')\" class=\"table_header_text\">Select</a>"=>array("field"=>"","sort"=>"","def_sort_type"=>"","sort_order"=>"","url_name"=>""),
    25. 

  25.                          "Subject"=>array("field"=>"subject","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"subj"),
    26. 

  26.                          "Queues"=>array("field"=>"group_id","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"queue"),
    27. 

  27.                          "Status"=>array("field"=>"status","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"status"),
    28. 

  28.                          "Owner"=>array("field"=>"user_id","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"owner"),
    29. 

  29.                          "From"=>array("field"=>"","sort"=>"","def_sort_type"=>"desc","sort_order"=>"","url_name"=>""),
    30. 

  30.                          "Complain"=>array("field"=>"complain","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"complain"),
    31. 

  31.                          "Rate"=>array("field"=>"rate","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"rate"),
    32. 

  32.                          "Updated"=>array("field"=>"","sort"=>"","def_sort_type"=>"desc","sort_order"=>"","url_name"=>""),
    33. 

  33.                          "Created"=>array("field"=>"created","sort"=>"default","def_sort_type"=>"desc","sort_order"=>"0","url_name"=>"created"));
    34. 

  34. 

  35. list($query, $queue, $ticket_status) = get_query_for_tickets();
    36. 

  36. 

  37. 

  38. 

  39. $row=array();
    40. 

  40. $data=date("Y-m-d");
    41. 

  41. $z=1;
    42. 

  42. 

  43. 

  44. $xtpl->assign("SECTION_NAME", "Brakes");
    45. 

  45.  
    46. 

  46. 

  47. $query = "SELECT *,(TO_DAYS(now()) - TO_DAYS(created)) as created_days_left,
    48. 

  48. 			(TO_DAYS(now()) - TO_DAYS(updated)) as updated_days_left 
    49. 

  49. 		  FROM " . T_TICKETS . " WHERE (status='new' OR status='opened')";
    50. 

    51. 

  51. 	$i=0;
    52. 

  52. 	
    53. 

  53.     $result = mysql_query($query);
    54. 

  54.     $num=mysql_numrows($result);
    55. 

  55.     
    56. 

  56.   
    57. 

  57.  while($i<$num)
    58. 

  58.  {
    59. 

  59.  	
    60. 

  60.  	$out=mysql_fetch_object($result);
    61. 

  61.  	$id=$out->id;
    62. 

  62.  	$status=$out->status;
    63. 

  63.  	$body_id=$out->body_id;
    64. 

  64.  	$user_id=$out->user_id;
    65. 

  65.  	$created_days_left=$out->created_days_left;
    66. 

  66.  	$subject=StripSlashes(htmlspecialchars($out->subject));
    67. 

  67.  	$group_id=$out->group_id;
    68. 

  68.  	$cc_member_id=$out->cc_member_id;
    69. 

  69.  	$golden=$out->golden;
    70. 

  70.  	$from_email=$out->from_email;
    71. 

  71.  	$cc_fname=$out->cc_fname;
    72. 

  72.  	$cc_lname=$out->cc_lname;
    73. 

  73.  	$status=$out->status;
    74. 

  74.  	$updated_days_left=$out->updated_days_left;
    75. 

  75.  	$complain=$out->complain;
    76. 

  76.  	$rate=$out->rate;
    77. 

  77.  	$user_id=$out->user_id;
    78. 

  78.  
    79. 

  79.  	
    80. 

  80.  	
    81. 

  81.  		
    82. 

  82.  	$query2="SELECT *,(TO_DAYS(now()) - TO_DAYS(created)) as created_days_left
    83. 

  83.  			
    84. 

  84.  		FROM " . T_TICKETS_ACTIONS . " WHERE ticket_id=$id and message_type='outcoming' order by id DESC LIMIT 1";
    85. 

  85.  	$result2=mysql_query($query2) or die ("calll");
    86. 

  86.  	$out2=mysql_fetch_object($result2);
    87. 

  87.  	$num2=1;
    88. 

  88.  	$test=$out2->id;
    89. 

  89.  	
    90. 

  90.  		if (empty($out2) and $updated_days_left>5)
    91. 

  91.  		{
    92. 

  92.  			$z++;
    93. 

  93.  			
    94. 

  94.  			$xtpl->assign("NUM", $z);
    95. 

  95.             	
    96. 

  96.             $xtpl->assign("TICKET_ID", $id);
    97. 

  97.             $xtpl->assign("SELECT", "<input type=\"checkbox\" id=\"" . $i . "\" name=\"select[]\" value=\"" . $id . "\" onclick=\"change_tr_class(this)\">");
    98. 

  98.         	if(strlen(trim($subject)) > 0)
    99. 

  99.             	{
    100. 

  100.             	$subject = trim($subject);
    101. 

  101.             	}else $subject = "No subject";
    102. 

  102.             $xtpl->assign("SUBJECT", "<a href=\"show_ticket.php?ticket_id=" . $id . "\" class=\"ticket\">" . $subject . "</a>");
    103. 

  103.             $query = "SELECT name FROM " . T_GROUPS . " WHERE id=" . $group_id . "";
    104. 

  104.             $row1 = SQL_select($query, 0);
    105. 

  105.             $query = "SELECT login FROM " . T_USERS . " WHERE id=" . $user_id . "";
    106. 

  106.             $rowx = SQL_select($query, 0);
    107. 

  107.             $xtpl->assign("QUEUE", StripSlashes(htmlspecialchars($row1["name"])));
    108. 

  108.             $xtpl->assign("OWNER", $rowx["login"]);
    109. 

  109.             		if($cc_member_id > 0) $member = "<span class=\"grey\">member id:</span> <strong>" . $cc_member_id ."</strong>";
    110. 

  110.             		else $member = "<span class=\"grey\">member id:</span> <strong>none</strong>";
    111. 

  111.             		$golden = ($golden == "true" and (int)$cc_member_id) ? "<br><span class='golden'>[GOLDEN]</span>":"";
    112. 

  112.             		if(strlen($from_email) > 0) $from_email = "<span class=\"grey\">email:</span>&nbsp;<strong>" . $from_email."</strong>";
    113. 

  113.             		else $from_email = "<span class=\"grey\">email:</span> <strong>none</strong>";
    114. 

  114.             		$applicant_name = "";
    115. 

  115.             		if(trim($cc_fname) != "" || trim($cc_lname != "")) $applicant_name = "<br><span class=\"grey\">name:</span>&nbsp;<strong>" . ucwords(htmlspecialchars($cc_fname)) . "&nbsp;" . ucwords(htmlspecialchars($cc_lname))."</strong>";
    116. 

  116.             		$xtpl->assign("FROM", $member . $applicant_name . "<br>" . $from_email . $golden);
    117. 

  117.             		$xtpl->assign("STATUS_CLASS", $status);
    118. 

  118.             		$xtpl->assign("TICKET_STATUS", $status);
    119. 

  119.             		if(!$updated_days_left) $updated_days_left = "<br><strong>Today</strong>";
    120. 

  120.             		else $updated_days_left = "<br><strong>" . $updated_days_left . " days ago</strong>";
    121. 

  121.             		$xtpl->assign("UPDATED", $updated_days_left);
    122. 

  122.             		if(!$created_days_left) $created_days_left = "<br><strong>Today</strong>";
    123. 

  123.             		else $created_days_left = "<br><strong>" . $created_days_left . " days ago</strong>";
    124. 

  124.             			$xtpl->assign("CREATED",  $created_days_left);
    125. 

  125.             			if($complain!='0000-00-00 00:00:00')
    126. 

  126.             				{
    127. 

  127.                 				$xtpl->assign("COMPLAIN", "Complain");
    128. 

  128.                 				$xtpl->assign("COMPLAIN_STATUS", "complain_on");
    129. 

  129.             				}else
    130. 

  130.             						{
    131. 

  131.                 					$xtpl->assign("COMPLAIN", "No");
    132. 

  132.                 					$xtpl->assign("COMPLAIN_STATUS", "complain_off");
    133. 

  133.             						}
    134. 

  134.             					if($rate != "") $xtpl->assign("RATE", $rate);
    135. 

  135.             					else $xtpl->assign("RATE", "No");
    136. 

  136.             						$xtpl->parse("main.tickets.list");
    137. 

  137.  		
    138. 

  138.  		 			
    139. 

  139.  		}
    140. 

  140. 

  141. else
    142. 

  142.  	
    143. 

  143. 	{	
    144. 

  144. 			//$ticket_id=$id;
    145. 

  145.  			
    146. 

  146.  			$days_left=$out2->created_days_left;
    147. 

  147.  			$body_id=$out2->body_id;
    148. 

  148.  			$user_action=$out2->message_type;
    149. 

  149.  			$user_actions2=$out2->user_action;
    150. 

  150.  			$action_id=$out2->id;
    151. 

  151.  			
    152. 

  152.  			
    153. 

  153.  				if ($user_action=="outcoming" && $updated_days_left>5) 
    154. 

  154.  					 
    155. 

  155.  				{
    156. 

  156.  					$query="select * from ".T_TICKETS_ACTIONS." where ticket_id=".$id." 
    157. 

  157.  							   and message_type!='outcoming' 
    158. 

  158.  							   and body_id!=0 and id>".$action_id."";
    159. 

  159.  					
    160. 

  160.  					$res=mysql_query($query);
    161. 

  161.  					$num_kol=mysql_num_rows($res);
    162. 

  162.  					if ($num_kol==0)
    163. 

  163.  					{
    164. 

  164.  						$i++;
    165. 

  165.  						continue;
    166. 

  166.  					}
    167. 

  167.  					
    168. 

  168.  					 
    169. 

  169.             		$xtpl->assign("NUM", $z);
    170. 

  170.             	
    171. 

  171.             		$xtpl->assign("TICKET_ID", $id);
    172. 

  172.             		$xtpl->assign("SELECT", "<input type=\"checkbox\" id=\"" . $i . "\" name=\"select[]\" value=\"" . $id . "\" onclick=\"change_tr_class(this)\">");
    173. 

  173.         		    if(strlen(trim($subject)) > 0)
    174. 

  174.             		{
    175. 

  175.                 		$subject = trim($subject);
    176. 

  176.             		}else $subject = "No subject";
    177. 

  177.             		$xtpl->assign("SUBJECT", "<a href=\"show_ticket.php?ticket_id=" . $id . "\" class=\"ticket\">" . $subject . "</a>");
    178. 

  178.             		$query = "SELECT name FROM " . T_GROUPS . " WHERE id=" . $group_id . "";
    179. 

  179.             		$row1 = SQL_select($query, 0);
    180. 

  180.             		
    181. 

  181.             		$query = "SELECT login FROM " . T_USERS . " WHERE id=" . $user_id . "";
    182. 

  182.             		$rowx = SQL_select($query, 0);
    183. 

  183.             		
    184. 

  184.             		$xtpl->assign("QUEUE", StripSlashes(htmlspecialchars($row1["name"])));
    185. 

  185.             		
    186. 

  186.             		$xtpl->assign("OWNER", $rowx["login"]);
    187. 

  187.             		if($cc_member_id > 0) $member = "<span class=\"grey\">member id:</span> <strong>" . $cc_member_id ."</strong>";
    188. 

  188.             		else $member = "<span class=\"grey\">member id:</span> <strong>none</strong>";
    189. 

  189.             		$golden = ($golden == "true" and (int)$cc_member_id) ? "<br><span class='golden'>[GOLDEN]</span>":"";
    190. 

  190.             		if(strlen($from_email) > 0) $from_email = "<span class=\"grey\">email:</span>&nbsp;<strong>" . $from_email."</strong>";
    191. 

  191.             		else $from_email = "<span class=\"grey\">email:</span> <strong>none</strong>";
    192. 

  192. 

  193.             		$applicant_name = "";
    194. 

  194.             		if(trim($cc_fname) != "" || trim($cc_lname != "")) $applicant_name = "<br><span class=\"grey\">name:</span>&nbsp;<strong>" . ucwords(htmlspecialchars($cc_fname)) . "&nbsp;" . ucwords(htmlspecialchars($cc_lname))."</strong>";
    195. 

  195.             		$xtpl->assign("FROM", $member . $applicant_name . "<br>" . $from_email . $golden);
    196. 

  196.             		$xtpl->assign("STATUS_CLASS", $status);
    197. 

  197.             		$xtpl->assign("TICKET_STATUS", $status);
    198. 

  198.             		if(!$updated_days_left) $updated_days_left = "<br><strong>Today</strong>";
    199. 

  199.             		else $updated_days_left = "<br><strong>" . $updated_days_left . " days ago</strong>";
    200. 

  200.             		$xtpl->assign("UPDATED", $updated_days_left);
    201. 

  201.             		if(!$created_days_left) $created_days_left = "<br><strong>Today</strong>";
    202. 

  202.             		else $created_days_left = "<br><strong>" . $created_days_left . " days ago</strong>";
    203. 

  203.             			$xtpl->assign("CREATED",  $created_days_left);
    204. 

  204.             			if($complain!='0000-00-00 00:00:00')
    205. 

  205.             				{
    206. 

  206.                 				$xtpl->assign("COMPLAIN", "Complain");
    207. 

  207.                 				$xtpl->assign("COMPLAIN_STATUS", "complain_on");
    208. 

  208.             				}else
    209. 

  209.             						{
    210. 

  210.                 					$xtpl->assign("COMPLAIN", "No");
    211. 

  211.                 					$xtpl->assign("COMPLAIN_STATUS", "complain_off");
    212. 

  212.             						}
    213. 

  213.             					if($rate != "") $xtpl->assign("RATE", $rate);
    214. 

  214.             					else $xtpl->assign("RATE", "No");
    215. 

  215.             						$xtpl->parse("main.tickets.list");
    216. 

  216.             						$z++;
    217. 

  217.             					
    218. 

  218.         
    219. 

  219.    				 }
    220. 

  220.  					
    221. 

  221.  		
    222. 

  222.  					
    223. 

  223.  					
    224. 

  224.  	}
    225. 

  225.  	$i++;
    226. 

  226.  
    227. 

  227.  	
    228. 

  228.  }
    229. 

  229.     
    230. 

  230. 

  231. $xtpl->parse("main.tickets");
    232. 

  232. //$xtpl->parse("main.tickets");
    233. 

  233. get_queues_status($xtpl);
    234. 

  234. //get_internal_queues_status($xtpl);
    235. 

  235. 

  236. //get_queues_status($xtpl);
    237. 

  237. $xtpl->parse("main");
    238. 

  238. $xtpl->out("main");
    239. 

  239.     /*$_SESSION["searching_parameters"] = array(
    240. 

    241. 

  241.                                                "owner" => 0,
    242. 

  242.                                                "owner_cond" => "appear",
    243. 

  243.                                                "email" =>"",
    244. 

  244.                                                "email_cond" => "contain",
    245. 

  245.                                                "subject" =>"",
    246. 

  246.                                                "subj_cond" => "contain",
    247. 

  247.                                                "queue" => Array
    248. 

  248.                                                    (
    249. 

  249.                                                    ),
    250. 

  250.                                                "queue_cond" => "appear",
    251. 

  251.                                                "status" => Array
    252. 

  252.                                                    (
    253. 

  253.                                                        "0" => "new",
    254. 

  254.                                                        "1" => "opened"
    255. 

  255.                                                    ),
    256. 

  256.                                                "status_cond" => "appear",
    257. 

  257.                                                "complain" => -1,
    258. 

  258.                                                "rate" => "-",
    259. 

  259.                                                "cc_member_id" =>"",
    260. 

  260.                                                "older_than" => -1,
    261. 

  261.                                                "older_than_d" => 2
    262. 

  262.                                               );*/
    263. 

  263.     
    264. 

  264. //  print "<pre>";
    265. 

  265. //  print "<a href='tickets.php'>see search result</a>";
    266. 

  266. //  print_r($_SESSION["searching_parameters"]);
    267. 

  267. //  print "</pre>";
    268. 

  268.    // header("Location: tickets.php");
    269. 

  269.     exit;
    270. 

  270. ?>
    271.