Сообщений в теме: 2

[Supokna]

Использовал стандартный отчет - Производительность.

После обновления на 1.9.5 локал, отчет стал не правильно выводиться.

Выбираю период, менеджера, после того когда формирую и нажимаю на колличество - встреч, звонков, для детализации - выводиться детализация - всех менеджеров. за весь период работы с Клиентской базой. А мне нужен отчет по определенному менеджеру за конкретный период.

[CbCoder]

Если вы не модифицировали ранее код отчета, можете скопировать код из новой конфигурации, там этой ошибки нет.

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);

[Supokna]

Спасибо!