Использовал стандартный отчет - Производительность.
После обновления на 1.9.5 локал, отчет стал не правильно выводиться.
Выбираю период, менеджера, после того когда формирую и нажимаю на колличество - встреч, звонков, для детализации - выводиться детализация - всех менеджеров. за весь период работы с Клиентской базой. А мне нужен отчет по определенному менеджеру за конкретный период.
1
Сообщений в теме: 2
#1
Отправлено 12 Декабрь 2011 - 13:01
#2
Отправлено 12 Декабрь 2011 - 13:29
Если вы не модифицировали ранее код отчета, можете скопировать код из новой конфигурации, там этой ошибки нет.
if (!empty($_REQUEST['_type'])) { unset($_SESSION[$ses_id]['search']); if ($_REQUEST['_type']=="Счета") { $_SESSION[$ses_id]['search'][43][0]['field'] = 436; $_SESSION[$ses_id]['search'][43][0]['term'] = "period"; $_SESSION[$ses_id]['search'][43][0]['value_field'] = form_local_time($_REQUEST['_date1']); $_SESSION[$ses_id]['search'][43][0]['value_field2'] = form_local_time($_REQUEST['_date2']); $_SESSION[$ses_id]['search'][43][0]['union'] = " and "; $_SESSION[$ses_id]['search'][43][1]['field'] = 448; $_SESSION[$ses_id]['search'][43][1]['term'] = "="; $_SESSION[$ses_id]['search'][43][1]['value_field'] = $_REQUEST['_manager']; $_SESSION[$ses_id]['search'][43][1]['union'] = ""; header("Location: ".$config["site_root"]."/fields.php?table=43"); } else { $_SESSION[$ses_id]['search'][62][0]['field'] = 724; $_SESSION[$ses_id]['search'][62][0]['term'] = "period"; $_SESSION[$ses_id]['search'][62][0]['value_field'] = form_local_time($_REQUEST['_date1']); $_SESSION[$ses_id]['search'][62][0]['value_field2'] = form_local_time($_REQUEST['_date2']); $_SESSION[$ses_id]['search'][62][0]['union'] = " and "; $_SESSION[$ses_id]['search'][62][1]['field'] = 727; $_SESSION[$ses_id]['search'][62][1]['term'] = "="; $_SESSION[$ses_id]['search'][62][1]['value_field'] = $_REQUEST['_manager']; $_SESSION[$ses_id]['search'][62][1]['union'] = " and "; $_SESSION[$ses_id]['search'][62][2]['field'] = 773; $_SESSION[$ses_id]['search'][62][2]['term'] = "="; $_SESSION[$ses_id]['search'][62][2]['value_field'] = $_REQUEST['_type']; $_SESSION[$ses_id]['search'][62][2]['union'] = ""; header("Location: ".$config["site_root"]."/fields.php?table=62"); } } if ($_REQUEST['date1']) $date1 = $_REQUEST['date1']; else $date1 = date("d.m.Y", mktime(0,0,0,date("m"),date("d")-7,date("Y"))); if ($_REQUEST['date2']) $date2 = $_REQUEST['date2']; else $date2 = date("d.m.Y"); if ($_REQUEST['manager']) $manager = $_REQUEST['manager']; elseif ($user['group_id']==2) $manager = $user['id']; $sqlQuery = "SELECT * FROM ".USERS_TABLE." WHERE ".($manager?("id='".$manager."'"):"(group_id=1 or group_id=2) and arc=0"); $result = mysql_query($sqlQuery); while ($row = mysql_fetch_array($result)) { $data['id_manager'] = $row['id']; $data['name_manager'] = $row['fio']; $sqlQuery = "SELECT count(*) as cnt FROM ".DATA_TABLE."62 WHERE status=0 and f724>='".form_eng_time($date1." 00:00:00")."' AND f724<='".form_eng_time($date2." 23:59:59")."' AND f727='".$row['id']."' AND f773='Звонок'"; $result2 = mysql_query($sqlQuery); $row2 = mysql_fetch_array($result2); $data['calls'] = $row2['cnt']; $sqlQuery = "SELECT count(*) as cnt FROM ".DATA_TABLE."62 WHERE status=0 and f724>='".form_eng_time($date1." 00:00:00")."' AND f724<='".form_eng_time($date2." 23:59:59")."' AND f727='".$row['id']."' AND f773='Встреча'"; $result2 = mysql_query($sqlQuery); $row2 = mysql_fetch_array($result2); $data['meets'] = $row2['cnt']; $sqlQuery = "SELECT count(*) as cnt FROM ".DATA_TABLE."62 WHERE status=0 and f724>='".form_eng_time($date1." 00:00:00")."' AND f724<='".form_eng_time($date2." 23:59:59")."' AND f727='".$row['id']."' AND f773='Предложение'"; $result2 = mysql_query($sqlQuery); $row2 = mysql_fetch_array($result2); $data['offers'] = $row2['cnt']; $sqlQuery = "SELECT count(*) as cnt FROM ".DATA_TABLE."62 WHERE status=0 and f724>='".form_eng_time($date1." 00:00:00")."' AND f724<='".form_eng_time($date2." 23:59:59")."' AND f727='".$row['id']."' AND f773='Письмо'"; $result2 = mysql_query($sqlQuery); $row2 = mysql_fetch_array($result2); $data['letters'] = $row2['cnt']; $sqlQuery = "SELECT count(*) as cnt FROM ".DATA_TABLE."43 WHERE status=0 and f436>='".form_eng_time($date1." 00:00:00")."' AND f436<='".form_eng_time($date2." 23:59:59")."' AND f448='".$row['id']."'"; $result2 = mysql_query($sqlQuery); $row2 = mysql_fetch_array($result2); $data['accounts'] = $row2['cnt']; $sqlQuery = "SELECT sum(f454) as summa FROM ".DATA_TABLE."43 WHERE status=0 and f436>='".form_eng_time($date1." 00:00:00")."' AND f436<='".form_eng_time($date2." 23:59:59")."' AND f448='".$row['id']."'"; $result2 = mysql_query($sqlQuery); $row2 = mysql_fetch_array($result2); $data['summa'] = number_format($row2['summa'], 2, ',', ''); $lines[] = $data; } if ($user['group_id']!=2) $sel_manager = "<option value=''>Все</option>\r\n"; $sqlQuery = "SELECT * FROM ".USERS_TABLE." WHERE ".(($user['group_id']==2)?("id='".$manager."'"):"(group_id=1 or group_id=2) and arc=0"); $result = mysql_query($sqlQuery); while ($row = mysql_fetch_array($result)) { $sel_manager.= "<option value='".$row['id']."'".(($row['id']==$manager)?" selected":"").">".$row['fio']."</option>\r\n"; } $smarty->assign("date1", $date1); $smarty->assign("date2", $date2); $smarty->assign("lines", $lines); $smarty->assign("manager", $manager); $smarty->assign("sel_manager", $sel_manager);
#3
Отправлено 12 Декабрь 2011 - 13:51
Спасибо!
Количество пользователей, читающих эту тему: 1
0 пользователей, 1 гостей, 0 анонимных