API tools faq
paste
Guest User

Untitled

a guest
Jun 22nd, 2016
91
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.77 KB | None | 0 0
raw download clone embed print report
  1. `id` - `id` в таблице `change_history`
  2. `id_cabinet` - проект к которому относятся изменения
  3. `id_lid` - к каком клиенту относятся изменения
  4. `id_staff` - сотрудник сделавший изменение
  5. `datetime` - дата изменения
  6. `vid_change` - вид изменения
  7. `coment_change` - комментарий изменения
  8. `change_old` - старая информация
  9. `change_new` - новая информация
  10.  
  11. [![<?php
  12. $num = 10;
  13. // Извлекаем из URL текущую страницу
  14. @$page = $_GET['page'];
  15. // Определяем общее число сообщений в базе данных
  16. $result00 = mysql_query("SELECT COUNT(*) FROM change_history WHERE id_lid='".$orders_value['id']."'");
  17. $temp = mysql_fetch_array($result00);
  18. $posts = $temp[0];
  19. // Находим общее число страниц
  20. $total = (($posts - 1) / $num) + 1;
  21. $total = intval($total);
  22. // Определяем начало сообщений для текущей страницы
  23. $page = intval($page);
  24. // Если значение $page меньше единицы или отрицательно
  25. // переходим на первую страницу
  26. // А если слишком большое, то переходим на последнюю
  27. if(empty($page) or $page < 0) $page = 1;
  28. if($page > $total) $page = $total;
  29. // Вычисляем начиная с какого номера
  30. // следует выводить сообщения
  31. $start = $page * $num - $num;
  32. $gt = "yes";
  33. // Выбираем $num сообщений начиная с номера $start
  34. $result = mysql_query("SELECT * FROM change_history WHERE id_lid = '".$orders_value['id']."' ORDER BY id DESC LIMIT $start, $num" ,$db);
  35. if ($result > 0) {
  36.  
  37. ?>
  38.  
  39. <?
  40. $myrow = mysql_fetch_array($result);
  41. do {
  42.  
  43. $resultlaed = mysql_query("SELECT * FROM `lids` WHERE id = '".$myrow['id_lid']."'");
  44. $lead = mysql_fetch_array($resultlaed);
  45.  
  46. $query_staff = mysql_query("SELECT * FROM staff WHERE id_staff = '".$myrow['id_staff']."' LIMIT 1");
  47. $staff = mysql_fetch_assoc($query_staff);
  48.  
  49. if ($myrow['vid_change'] == 'name'){
  50. $vid_icon = "<div class='ucrmicon'>f</div>";
  51. $title_change = "изменил(а) имя:";
  52. $coment_change = '<span class="name_old">'.$myrow['change_old'].'</span> <div class="ucrmicon '.$myrow['vid_change'].'">9</div> <span class="name_new">'.$myrow['change_new'].'</span>';
  53. }
  54. if ($myrow['vid_change'] == 'name' and $myrow['change_old'] == '') {
  55. $vid_icon = "<div class='ucrmicon'>f</div>";
  56. $title_change = "добавил(а) имя:";
  57. $coment_change = ' <span class="name_new">'.$myrow['change_new'].'</span>';
  58. }
  59. if ($myrow['vid_change'] == 'status') {
  60.  
  61. $result_status_old = mysql_query("SELECT title, text_color, background_color FROM status WHERE id = '".$myrow['change_old']."' and id_cabinet = '".$id_cabinet."' ORDER BY drag");
  62. $myrow_status_old = mysql_fetch_array($result_status_old);
  63.  
  64. $result_status_new = mysql_query("SELECT title, text_color, background_color FROM status WHERE id = '".$myrow['change_new']."' and id_cabinet = '".$id_cabinet."' ORDER BY drag");
  65. $myrow_status_new = mysql_fetch_array($result_status_new);
  66.  
  67. if ($myrow['change_old'] !== '') {
  68.  
  69. $vid_icon = "<div class='ucrmicon'>f</div>"; $title_change = "изменил(а) статус:";
  70. $coment_change = '<span class="status-lids" style="background-color:'.$myrow_status_old['background_color'].';color:'.$myrow_status_old['text_color'].'">'.$myrow_status_old['title'].'</span> <div class="ucrmicon '.$myrow['vid_change'].'">9</div> <span class="status-lids" style="background-color:'.$myrow_status_new['background_color'].';color:'.$myrow_status_new['text_color'].'">'.$myrow_status_new['title'].'</span>';
  71. }
  72. if ($myrow['change_old'] == '') {
  73. $vid_icon = "<div class='ucrmicon'>f</div>"; $title_change = "добавил(а) статус:";
  74. $coment_change = '<span class="status-lids" style="background-color:'.$myrow_status_new['background_color'].';color:'.$myrow_status_new['text_color'].'">'.$myrow_status_new['title'].'</span>';
  75. }
  76.  
  77. }
  78. if ($myrow['vid_change'] == 'note') {
  79. $vid_icon = "<div class='ucrmicon'>q</div>";
  80. $title_change = "написал(а) заметку:";
  81. $coment_change = $myrow['coment_change'];
  82. }
  83. if ($myrow['vid_change'] == 'add') {
  84. $vid_icon = "<div class='ucrmicon'>d</div>";
  85. $title_change = "добавил(а) клиента:";
  86. $coment_change = $myrow['coment_change'];
  87. }
  88. if ($myrow['vid_change'] == 'sendsms') {
  89. $vid_icon = "<div class='ucrmicon'>'</div>";
  90. $title_change = "отправил(а) sms:";
  91. $coment_change = $myrow['coment_change'];
  92. }
  93. if ($myrow['vid_change'] == 'phone') {
  94.  
  95. if ($myrow['change_old'] == '') {
  96. $vid_icon = "<div class='ucrmicon'>f</div>";
  97. $title_change = "добавил(а) телефон:";
  98. $coment_change = ' <span class="phone_new">'.$myrow['change_new'].'</span>';
  99. }
  100. if ($myrow['change_old'] !== '' and $myrow['change_new'] !== '') {
  101. $vid_icon = "<div class='ucrmicon'>f</div>";
  102. $title_change = "изменил(а) телефон:";
  103. $coment_change = '<span class="phone_old">'.$myrow['change_old'].'</span> <div class="ucrmicon '.$myrow['vid_change'].'">9</div> <span class="phone_new">'.$myrow['change_new'].'</span>';
  104. }
  105. }
  106. if ($myrow['vid_change'] == 'deleted') {
  107. $vid_icon = "<div class='ucrmicon'>g</div>";
  108. $title_change = "удалил(а) клиента:";
  109. $coment_change = '<span class="deleted">Клиент удален</span>';
  110. }
  111. if ($myrow['vid_change'] == 'regain') {
  112. $vid_icon = "<div class='ucrmicon' style='font-size:20px;margin-left:-5px;'>D</div>";
  113. $title_change = "восстановил(а) клиента:";
  114. $coment_change = '<span class="regain">Клиент восстановлен</span>';
  115. }
  116. //if ($myrow['vid_change'] == 'group' and $myrow['change_old'] == '0') {
  117.  
  118. // $vid_icon = "<div class='ucrmicon'>f</div>";
  119. // $title_change = "добавил(а) клиента в группу:";
  120.  
  121. // $result_type = mysql_query("SELECT type_title, text_color, background_color FROM group_leads WHERE id_type = '".$myrow['change_new']."' and id_cabinet = '".$id_cabinet."' ORDER BY drag");
  122. // $myrow_group = mysql_fetch_array($result_type);
  123.  
  124. // $coment_change = ' <span class="status-lids" style="background-color:'.$myrow_group['background_color'].';color:'.$myrow_group['text_color'].'">'.$myrow_group['type_title'].'</span>';
  125.  
  126. //}
  127. if ($myrow['vid_change'] == 'group') {
  128.  
  129.  
  130. $result_type_old = mysql_query("SELECT type_title, text_color, background_color FROM group_leads WHERE id_type = '".$myrow['change_old']."' and id_cabinet = '".$id_cabinet."' ORDER BY drag");
  131. $myrow_group_old = mysql_fetch_array($result_type_old);
  132.  
  133. $result_type_new = mysql_query("SELECT type_title, text_color, background_color FROM group_leads WHERE id_type = '".$myrow['change_new']."' and id_cabinet = '".$id_cabinet."' ORDER BY drag");
  134. $myrow_group_new = mysql_fetch_array($result_type_new);
  135.  
  136. if ($myrow['change_old'] !== '0' and $myrow['change_old'] !== '') {
  137.  
  138. $vid_icon = "<div class='ucrmicon'>f</div>";
  139. $title_change = "изменил(а) группу клиента:";
  140. $coment_change = ' <span class="status-lids" style="background-color:'.$myrow_group_old['background_color'].';color:'.$myrow_group_old['text_color'].'">'.$myrow_group_old['type_title'].'</span> <div class="ucrmicon '.$myrow['vid_change'].'">9</div> <span class="status-lids" style="background-color:'.$myrow_group_new['background_color'].';color:'.$myrow_group_new['text_color'].'">'.$myrow_group_new['type_title'].'</span> ';
  141.  
  142. }
  143. if ($myrow['change_old'] == '0' and $myrow['change_old'] == '') {
  144.  
  145. $vid_icon = "<div class='ucrmicon'>f</div>";
  146. $title_change = "добавил(а) клиента в группу:";
  147.  
  148. $coment_change = '<span class="status-lids" style="background-color:'.$myrow_group_new['background_color'].';color:'.$myrow_group_new['text_color'].'">'.$myrow_group_new['type_title'].'</span> ';
  149.  
  150. }
  151.  
  152.  
  153. }
  154. if ($myrow['vid_change'] == 'transferlead') {
  155.  
  156. $vid_icon = "<div class='ucrmicon transferlead'>% v %</div>";
  157.  
  158. if ($myrow['change_old'] !== '0' and $myrow['change_new'] !== '0') {
  159. $title_change = "изменил(а) ответственного:";
  160. $result_staff_old = mysql_query("SELECT id_staff,name,lastname,email FROM staff WHERE id_staff = '".$myrow['change_old']."'");
  161. $myrow_staff_old = mysql_fetch_array($result_staff_old);
  162.  
  163. if ($myrow_staff_old['name'] !=='' or $myrow_staff_old['lastname'] !== '') {
  164. $name_staff_old = $myrow_staff_old['name']." ".$myrow_staff_old['lastname'];
  165. } else {
  166. $name_staff_old = $myrow_staff_old['email'];
  167. }
  168.  
  169. $result_staff_new = mysql_query("SELECT id_staff,name,lastname,email FROM staff WHERE id_staff = '".$myrow['change_new']."'");
  170. $myrow_staff_new = mysql_fetch_array($result_staff_new);
  171.  
  172. if ($myrow_staff_new['name'] !=='' or $myrow_staff_new['lastname'] !== '') {
  173. $name_staff_new = $myrow_staff_new['name']." ".$myrow_staff_new['lastname'];
  174. } else {
  175. $name_staff_new = $myrow_staff_new['email'];
  176. }
  177.  
  178. $coment_change = ' с <span class="name_staff_old">'.$name_staff_old.'</span> на <span class="name_staff_new">'.$name_staff_new.'</span> ';
  179.  
  180. }
  181. if ($myrow['change_old'] == '0' and $myrow['change_new'] !== '0') {
  182.  
  183. $title_change = "поставил(а) ответственного:";
  184. $result_staff_old = mysql_query("SELECT id_staff,name,lastname FROM staff WHERE id_staff = '".$myrow['change_old']."'");
  185. $myrow_staff_old = mysql_fetch_array($result_staff_old);
  186.  
  187. $name_staff_old = $myrow_staff_old['name']." ".$myrow_staff_old['lastname'];
  188.  
  189. $result_staff_new = mysql_query("SELECT id_staff,name,lastname FROM staff WHERE id_staff = '".$myrow['change_new']."'");
  190. $myrow_staff_new = mysql_fetch_array($result_staff_new);
  191.  
  192. $name_staff_new = $myrow_staff_new['name']." ".$myrow_staff_new['lastname'];
  193.  
  194. $coment_change = '<span class="name_staff_new">'.$name_staff_new.'</span> ';
  195. }
  196.  
  197. }
  198. if ($myrow['vid_change'] == 'email') {
  199.  
  200. if ($myrow['change_old'] == '' and $myrow['change_new'] !== '') {
  201. $vid_icon = "<div class='ucrmicon'>f</div>";
  202. $title_change = "добавил(а) емайл:";
  203. $coment_change = '<span class="email_new">'.$myrow['change_new'].'</span>';
  204. }
  205. if ($myrow['change_old'] !== '' and $myrow['change_new'] !== '') {
  206. $vid_icon = "<div class='ucrmicon'>f</div>";
  207. $title_change = "изменил(а) емайл:";
  208. $coment_change = '<span class="email_old">'.$myrow['change_old'].'</span> <div class="ucrmicon '.$myrow['vid_change'].'">9</div> <span class="email_new">'.$myrow['change_new'].'</span>';
  209. }
  210.  
  211. }
  212. if ($myrow['vid_change'] == 'comment') {$vid_icon = "<div class='ucrmicon'>7</div>"; $title_change = "добавил(а) комментарий:"; $coment_change = $myrow['coment_change'];}
  213.  
  214. if ($myrow['vid_change'] == 'adress') {
  215.  
  216. if ($myrow['change_old'] !== '' and $myrow['change_new'] !== '') {
  217. $vid_icon = "<div class='ucrmicon'>C</div>";
  218. $title_change = "изменил(а) адресс:";
  219. $coment_change = '<span class="adress_old">'.$myrow['change_old'].'</span> <div class="ucrmicon '.$myrow['vid_change'].'">9</div> <span class="adress_new">'.$myrow['change_new'].'</span>';
  220. }
  221. if ($myrow['change_old'] == '' and $myrow['change_new'] !== '') {
  222. $vid_icon = "<div class='ucrmicon'>C</div>";
  223. $title_change = "добавил(а) адресс:";
  224. $coment_change = '<span class="adress_new">'.$myrow['change_new'].'</span>';
  225. }
  226.  
  227. }
  228. if ($myrow['vid_change'] == 'tasck') {
  229. $vid_icon = "<div class='ucrmicon'>J</div>";
  230. $title_change = "поставил(а) задачу:";
  231. $result_tasck = mysql_query("SELECT id,title,description,result,id_connection,time_rem,time_rem_add,status,start_date,start_time,end_date,end_time,id_staff_contractor FROM tasks WHERE vid_connection = 'lead' and id_connection = '$myrow[id_lid]' and id = '$myrow[id_data]'");
  232. if (mysql_num_rows($result_tasck) > 0) {
  233.  
  234. $myrow_tasck = mysql_fetch_array($result_tasck);
  235.  
  236. $start_datetime = "$myrow_tasck[start_date] $myrow_tasck[start_time]";
  237. $end_datetime = "$myrow_tasck[end_date] $myrow_tasck[end_time]";
  238.  
  239.  
  240. if ($myrow_tasck['status'] == '0') {
  241. $status_tasck = '<div class="o-status-tasck"><div class="text-status">Назначена</div></div>';
  242. }
  243. if ($myrow_tasck['status'] == '1') {
  244. $status_tasck = '<div class="ok-status-tasck"><div class="ucrmicon">Q</div> <div class="text-status">Выполнена</div></div>';
  245. $status_tasck_title = 'Итог';
  246. }
  247. if ($myrow_tasck['status'] == '2') {
  248. $status_tasck = '<div class="reject-status-tasck"><div class="ucrmicon">X</div> <div class="text-status">Не выполнена</div></div>';
  249. $status_tasck_title = 'Почему?';
  250. }
  251. if ($myrow_tasck['result'] !== '') {
  252.  
  253. $itog_tasck = '<div class="tasck-action"><div class="tasck-itog-histori">
  254. <div class="text-tasck-title">'.$status_tasck_title.'</div>
  255. '.$myrow_tasck['result'].'
  256. </div></div>';
  257. }
  258. $coment_change ='<div class="tasck-block-histori">
  259. <div class="tasck-block-title">Задача <div class="tasck-status tasck-status-'.$myrow_tasck['id'].'">'.$status_tasck.'</div></div>
  260. <div class="tasck-content">
  261.  
  262. <div class="tasck-title">Название: <span>'.$myrow_tasck[title].'</span></div>
  263. <div class="tasck-date-end">Дата начала: <span>'.new_time(strtotime($start_datetime)).'</span></div>
  264. <div class="tasck-date-end">Дата окончания: <span>'.new_time(strtotime($end_datetime)).'</span></div>
  265. <div class="tasck-comment">Комментарий: <span>'.$myrow_tasck[description].'</span></div>
  266.  
  267. '.$itog_tasck.'
  268.  
  269. </div>
  270. </div>';
  271. }
  272.  
  273. }
  274.  
  275. ?>
  276. <div class="note-block ">
  277. <?=$vid_icon;?> <div class="note-bloks-datetime <?=$myrow['vid_change']?>"><? echo new_time(strtotime($myrow['datetime'])); ?>, <span><? if ($staff['name'] == '' and $staff['lastname'] == '') {echo $staff['email'];} else { echo "$staff[name] $staff[lastname]";} ?></span>, <?=$title_change;?></div>
  278.  
  279. <div class="note-bloks-vid_change"><?=$coment_change;?></div>
  280.  
  281. </div>
  282.  
  283. <?
  284. }
  285. while ($myrow = mysql_fetch_array($result));
  286. ?>
  287. </ul>
  288. <?
  289. } else {echo "<div class='alert alert-error' style='margin:40px;width:80%;text-align:center;'><b>Пусто!</b> - изменения касающиеся данного лида еще не вносились.</div>";}
  290. ?>
  291. <?php
  292. // Проверяем нужны ли стрелки назад
  293. if ($page != 1) $pervpage = '<a href=/'.$id_cabinet.'/leads/details-'.$_GET['edit'].'/page-1>Первая</a>';
  294. // Проверяем нужны ли стрелки вперед
  295. if ($page != $total) $nextpage = '<a href=/'.$id_cabinet.'/leads/details-'.$_GET['edit'].'/page-' .$total. '>Последняя</a>';
  296.  
  297. // Находим две ближайшие станицы с обоих краев, если они есть
  298. if($page - 1 > 0) $page1left = '<a href=/'.$id_cabinet.'/leads/details-'.$_GET['edit'].'/page-'. ($page - 1) .'>'. ($page - 1) .'</a>';
  299. if($page - 2 > 0) $page2left = ' <a href=/'.$id_cabinet.'/leads/details-'.$_GET['edit'].'/page-'. ($page - 2) .'>'. ($page - 2) .'</a>';
  300. if($page - 3 > 0) $page3left = ' <a href=/'.$id_cabinet.'/leads/details-'.$_GET['edit'].'/page-'. ($page - 3) .'>'. ($page - 3) .'</a>';
  301. if($page - 4 > 0) $page4left = ' <a href=/'.$id_cabinet.'/leads/details-'.$_GET['edit'].'/page-'. ($page - 4) .'>'. ($page - 4) .'</a>';
  302.  
  303.  
  304.  
  305.  
  306. if($page + 1 <= $total) $page1right = ' <a href=/'.$id_cabinet.'/leads/details-'.$_GET['edit'].'/page-'. ($page + 1) .'>'. ($page + 1) .'</a>';
  307. if($page + 2 <= $total) $page2right = ' <a href=/'.$id_cabinet.'/leads/details-'.$_GET['edit'].'/page-'. ($page + 2) .'>'. ($page + 2) .'</a>';
  308. if($page + 3 <= $total) $page3right = ' <a href=/'.$id_cabinet.'/leads/details-'.$_GET['edit'].'/page-'. ($page + 3) .'>'. ($page + 3) .'</a>';
  309. if($page + 4 <= $total) $page4right = ' <a href=/'.$id_cabinet.'/leads/details-'.$_GET['edit'].'/page-'. ($page + 4) .'>'. ($page + 4) .'</a>';
  310.  
  311.  
  312.  
  313.  
  314.  
  315. // Вывод меню если страниц больше одной
  316.  
  317. if ($total > 1)
  318. {
  319. Error_Reporting(E_ALL & ~E_NOTICE);
  320. echo "<div class="pstrnav">";
  321. echo $pervpage.$page4left.$page3left.$page2left.$page1left.'<b class="page">'.$page.'</b>'.$page1right.$page2right.$page3right.$page4right.$nextpage;
  322. echo "</div>";
  323. }
  324. ?>][1]][1]
  325.  
  326. while ($myrow = mysql_fetch_array($result)) {
  327.  
  328. $resultlaed = mysql_query("SELECT * FROM `lids` WHERE id = '".$myrow['id_lid']."'");
  329. $lead = mysql_fetch_array($resultlaed);
  330.  
  331. $query_staff = mysql_query("SELECT * FROM staff WHERE id_staff = '".$myrow['id_staff']."' LIMIT 1");
  332. $staff = mysql_fetch_assoc($query_staff);
  333.  
  334. if ($myrow['vid_change'] == 'name'){
  335. $vid_icon = "<div class='ucrmicon'>f</div>";
  336. $title_change = "изменил(а) имя:";
  337. $coment_change = '<span class="name_old">'.$myrow['change_old'].'</span> <div class="ucrmicon '.$myrow['vid_change'].'">9</div> <span class="name_new">'.$myrow['change_new'].'</span>';
  338. }
  339. if ($myrow['vid_change'] == 'name' and $myrow['change_old'] == '') {
  340. $vid_icon = "<div class='ucrmicon'>f</div>";
  341. $title_change = "добавил(а) имя:";
  342. $coment_change = ' <span class="name_new">'.$myrow['change_new'].'</span>';
  343. }
  344. if ($myrow['vid_change'] == 'status') {
  345.  
  346. $result_status_old = mysql_query("SELECT title, text_color, background_color FROM status WHERE id = '".$myrow['change_old']."' and id_cabinet = '".$id_cabinet."' ORDER BY drag");
  347. $myrow_status_old = mysql_fetch_array($result_status_old);
  348.  
  349. $result_status_new = mysql_query("SELECT title, text_color, background_color FROM status WHERE id = '".$myrow['change_new']."' and id_cabinet = '".$id_cabinet."' ORDER BY drag");
  350. $myrow_status_new = mysql_fetch_array($result_status_new);
  351.  
  352. if ($myrow['change_old'] !== '') {
  353.  
  354. $vid_icon = "<div class='ucrmicon'>f</div>"; $title_change = "изменил(а) статус:";
  355. $coment_change = '<span class="status-lids" style="background-color:'.$myrow_status_old['background_color'].';color:'.$myrow_status_old['text_color'].'">'.$myrow_status_old['title'].'</span> <div class="ucrmicon '.$myrow['vid_change'].'">9</div> <span class="status-lids" style="background-color:'.$myrow_status_new['background_color'].';color:'.$myrow_status_new['text_color'].'">'.$myrow_status_new['title'].'</span>';
  356. }
  357. if ($myrow['change_old'] == '') {
  358. $vid_icon = "<div class='ucrmicon'>f</div>"; $title_change = "добавил(а) статус:";
  359. $coment_change = '<span class="status-lids" style="background-color:'.$myrow_status_new['background_color'].';color:'.$myrow_status_new['text_color'].'">'.$myrow_status_new['title'].'</span>';
  360. }
  361.  
  362. }
  363. if ($myrow['vid_change'] == 'note') {
  364. $vid_icon = "<div class='ucrmicon'>q</div>";
  365. $title_change = "написал(а) заметку:";
  366. $coment_change = $myrow['coment_change'];
  367. }
  368. if ($myrow['vid_change'] == 'add') {
  369. $vid_icon = "<div class='ucrmicon'>d</div>";
  370. $title_change = "добавил(а) клиента:";
  371. $coment_change = $myrow['coment_change'];
  372. }
  373. if ($myrow['vid_change'] == 'sendsms') {
  374. $vid_icon = "<div class='ucrmicon'>'</div>";
  375. $title_change = "отправил(а) sms:";
  376. $coment_change = $myrow['coment_change'];
  377. }
  378. if ($myrow['vid_change'] == 'phone') {
  379.  
  380. if ($myrow['change_old'] == '') {
  381. $vid_icon = "<div class='ucrmicon'>f</div>";
  382. $title_change = "добавил(а) телефон:";
  383. $coment_change = ' <span class="phone_new">'.$myrow['change_new'].'</span>';
  384. }
  385. if ($myrow['change_old'] !== '' and $myrow['change_new'] !== '') {
  386. $vid_icon = "<div class='ucrmicon'>f</div>";
  387. $title_change = "изменил(а) телефон:";
  388. $coment_change = '<span class="phone_old">'.$myrow['change_old'].'</span> <div class="ucrmicon '.$myrow['vid_change'].'">9</div> <span class="phone_new">'.$myrow['change_new'].'</span>';
  389. }
  390. }
  391. if ($myrow['vid_change'] == 'deleted') {
  392. $vid_icon = "<div class='ucrmicon'>g</div>";
  393. $title_change = "удалил(а) клиента:";
  394. $coment_change = '<span class="deleted">Клиент удален</span>';
  395. }
  396. if ($myrow['vid_change'] == 'regain') {
  397. $vid_icon = "<div class='ucrmicon' style='font-size:20px;margin-left:-5px;'>D</div>";
  398. $title_change = "восстановил(а) клиента:";
  399. $coment_change = '<span class="regain">Клиент восстановлен</span>';
  400. }
  401. //if ($myrow['vid_change'] == 'group' and $myrow['change_old'] == '0') {
  402.  
  403. // $vid_icon = "<div class='ucrmicon'>f</div>";
  404. // $title_change = "добавил(а) клиента в группу:";
  405.  
  406. // $result_type = mysql_query("SELECT type_title, text_color, background_color FROM group_leads WHERE id_type = '".$myrow['change_new']."' and id_cabinet = '".$id_cabinet."' ORDER BY drag");
  407. // $myrow_group = mysql_fetch_array($result_type);
  408.  
  409. // $coment_change = ' <span class="status-lids" style="background-color:'.$myrow_group['background_color'].';color:'.$myrow_group['text_color'].'">'.$myrow_group['type_title'].'</span>';
  410.  
  411. //}
  412. if ($myrow['vid_change'] == 'group') {
  413.  
  414.  
  415. $result_type_old = mysql_query("SELECT type_title, text_color, background_color FROM group_leads WHERE id_type = '".$myrow['change_old']."' and id_cabinet = '".$id_cabinet."' ORDER BY drag");
  416. $myrow_group_old = mysql_fetch_array($result_type_old);
  417.  
  418. $result_type_new = mysql_query("SELECT type_title, text_color, background_color FROM group_leads WHERE id_type = '".$myrow['change_new']."' and id_cabinet = '".$id_cabinet."' ORDER BY drag");
  419. $myrow_group_new = mysql_fetch_array($result_type_new);
  420.  
  421. if ($myrow['change_old'] !== '0' and $myrow['change_old'] !== '') {
  422.  
  423. $vid_icon = "<div class='ucrmicon'>f</div>";
  424. $title_change = "изменил(а) группу клиента:";
  425. $coment_change = ' <span class="status-lids" style="background-color:'.$myrow_group_old['background_color'].';color:'.$myrow_group_old['text_color'].'">'.$myrow_group_old['type_title'].'</span> <div class="ucrmicon '.$myrow['vid_change'].'">9</div> <span class="status-lids" style="background-color:'.$myrow_group_new['background_color'].';color:'.$myrow_group_new['text_color'].'">'.$myrow_group_new['type_title'].'</span> ';
  426.  
  427. }
  428. if ($myrow['change_old'] == '0' and $myrow['change_old'] == '') {
  429.  
  430. $vid_icon = "<div class='ucrmicon'>f</div>";
  431. $title_change = "добавил(а) клиента в группу:";
  432.  
  433. $coment_change = '<span class="status-lids" style="background-color:'.$myrow_group_new['background_color'].';color:'.$myrow_group_new['text_color'].'">'.$myrow_group_new['type_title'].'</span> ';
  434.  
  435. }
  436.  
  437.  
  438. }
  439. if ($myrow['vid_change'] == 'transferlead') {
  440.  
  441. $vid_icon = "<div class='ucrmicon transferlead'>% v %</div>";
  442.  
  443. if ($myrow['change_old'] !== '0' and $myrow['change_new'] !== '0') {
  444. $title_change = "изменил(а) ответственного:";
  445. $result_staff_old = mysql_query("SELECT id_staff,name,lastname,email FROM staff WHERE id_staff = '".$myrow['change_old']."'");
  446. $myrow_staff_old = mysql_fetch_array($result_staff_old);
  447.  
  448. if ($myrow_staff_old['name'] !=='' or $myrow_staff_old['lastname'] !== '') {
  449. $name_staff_old = $myrow_staff_old['name']." ".$myrow_staff_old['lastname'];
  450. } else {
  451. $name_staff_old = $myrow_staff_old['email'];
  452. }
  453.  
  454. $result_staff_new = mysql_query("SELECT id_staff,name,lastname,email FROM staff WHERE id_staff = '".$myrow['change_new']."'");
  455. $myrow_staff_new = mysql_fetch_array($result_staff_new);
  456.  
  457. if ($myrow_staff_new['name'] !=='' or $myrow_staff_new['lastname'] !== '') {
  458. $name_staff_new = $myrow_staff_new['name']." ".$myrow_staff_new['lastname'];
  459. } else {
  460. $name_staff_new = $myrow_staff_new['email'];
  461. }
  462.  
  463. $coment_change = ' с <span class="name_staff_old">'.$name_staff_old.'</span> на <span class="name_staff_new">'.$name_staff_new.'</span> ';
  464.  
  465. }
  466. if ($myrow['change_old'] == '0' and $myrow['change_new'] !== '0') {
  467.  
  468. $title_change = "поставил(а) ответственного:";
  469. $result_staff_old = mysql_query("SELECT id_staff,name,lastname FROM staff WHERE id_staff = '".$myrow['change_old']."'");
  470. $myrow_staff_old = mysql_fetch_array($result_staff_old);
  471.  
  472. $name_staff_old = $myrow_staff_old['name']." ".$myrow_staff_old['lastname'];
  473.  
  474. $result_staff_new = mysql_query("SELECT id_staff,name,lastname FROM staff WHERE id_staff = '".$myrow['change_new']."'");
  475. $myrow_staff_new = mysql_fetch_array($result_staff_new);
  476.  
  477. $name_staff_new = $myrow_staff_new['name']." ".$myrow_staff_new['lastname'];
  478.  
  479. $coment_change = '<span class="name_staff_new">'.$name_staff_new.'</span> ';
  480. }
  481.  
  482. }
  483. if ($myrow['vid_change'] == 'email') {
  484.  
  485. if ($myrow['change_old'] == '' and $myrow['change_new'] !== '') {
  486. $vid_icon = "<div class='ucrmicon'>f</div>";
  487. $title_change = "добавил(а) емайл:";
  488. $coment_change = '<span class="email_new">'.$myrow['change_new'].'</span>';
  489. }
  490. if ($myrow['change_old'] !== '' and $myrow['change_new'] !== '') {
  491. $vid_icon = "<div class='ucrmicon'>f</div>";
  492. $title_change = "изменил(а) емайл:";
  493. $coment_change = '<span class="email_old">'.$myrow['change_old'].'</span> <div class="ucrmicon '.$myrow['vid_change'].'">9</div> <span class="email_new">'.$myrow['change_new'].'</span>';
  494. }
  495.  
  496. }
  497. if ($myrow['vid_change'] == 'comment') {$vid_icon = "<div class='ucrmicon'>7</div>"; $title_change = "добавил(а) комментарий:"; $coment_change = $myrow['coment_change'];}
  498.  
  499. if ($myrow['vid_change'] == 'adress') {
  500.  
  501. if ($myrow['change_old'] !== '' and $myrow['change_new'] !== '') {
  502. $vid_icon = "<div class='ucrmicon'>C</div>";
  503. $title_change = "изменил(а) адресс:";
  504. $coment_change = '<span class="adress_old">'.$myrow['change_old'].'</span> <div class="ucrmicon '.$myrow['vid_change'].'">9</div> <span class="adress_new">'.$myrow['change_new'].'</span>';
  505. }
  506. if ($myrow['change_old'] == '' and $myrow['change_new'] !== '') {
  507. $vid_icon = "<div class='ucrmicon'>C</div>";
  508. $title_change = "добавил(а) адресс:";
  509. $coment_change = '<span class="adress_new">'.$myrow['change_new'].'</span>';
  510. }
  511.  
  512. }
  513. if ($myrow['vid_change'] == 'tasck') {
  514. $vid_icon = "<div class='ucrmicon'>J</div>";
  515. $title_change = "поставил(а) задачу:";
  516. $result_tasck = mysql_query("SELECT id,title,description,result,id_connection,time_rem,time_rem_add,status,start_date,start_time,end_date,end_time,id_staff_contractor FROM tasks WHERE vid_connection = 'lead' and id_connection = '$myrow[id_lid]' and id = '$myrow[id_data]'");
  517. if (mysql_num_rows($result_tasck) > 0) {
  518.  
  519. $myrow_tasck = mysql_fetch_array($result_tasck);
  520.  
  521. $start_datetime = "$myrow_tasck[start_date] $myrow_tasck[start_time]";
  522. $end_datetime = "$myrow_tasck[end_date] $myrow_tasck[end_time]";
  523.  
  524.  
  525. if ($myrow_tasck['status'] == '0') {
  526. $status_tasck = '<div class="o-status-tasck"><div class="text-status">Назначена</div></div>';
  527. }
  528. if ($myrow_tasck['status'] == '1') {
  529. $status_tasck = '<div class="ok-status-tasck"><div class="ucrmicon">Q</div> <div class="text-status">Выполнена</div></div>';
  530. $status_tasck_title = 'Итог';
  531. }
  532. if ($myrow_tasck['status'] == '2') {
  533. $status_tasck = '<div class="reject-status-tasck"><div class="ucrmicon">X</div> <div class="text-status">Не выполнена</div></div>';
  534. $status_tasck_title = 'Почему?';
  535. }
  536. if ($myrow_tasck['result'] !== '') {
  537.  
  538. $itog_tasck = '<div class="tasck-action"><div class="tasck-itog-histori">
  539. <div class="text-tasck-title">'.$status_tasck_title.'</div>
  540. '.$myrow_tasck['result'].'
  541. </div></div>';
  542. }
  543. $coment_change ='<div class="tasck-block-histori">
  544. <div class="tasck-block-title">Задача <div class="tasck-status tasck-status-'.$myrow_tasck['id'].'">'.$status_tasck.'</div></div>
  545. <div class="tasck-content">
  546.  
  547. <div class="tasck-title">Название: <span>'.$myrow_tasck[title].'</span></div>
  548. <div class="tasck-date-end">Дата начала: <span>'.new_time(strtotime($start_datetime)).'</span></div>
  549. <div class="tasck-date-end">Дата окончания: <span>'.new_time(strtotime($end_datetime)).'</span></div>
  550. <div class="tasck-comment">Комментарий: <span>'.$myrow_tasck[description].'</span></div>
  551.  
  552. '.$itog_tasck.'
  553.  
  554. </div>
  555. </div>';
  556. }
  557.  
  558. }
  559.  
  560. ?>
  561. <div class="note-block ">
  562. <?=$vid_icon;?> <div class="note-bloks-datetime <?=$myrow['vid_change']?>"><? echo new_time(strtotime($myrow['datetime'])); ?>, <span><? if ($staff['name'] == '' and $staff['lastname'] == '') {echo $staff['email'];} else { echo "$staff[name] $staff[lastname]";} ?></span>, <?=$title_change;?></div>
  563.  
  564. <div class="note-bloks-vid_change"><?=$coment_change;?></div>
  565.  
  566. </div>
  567.  
  568. <?
  569. }
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!