$j = 0;
while ($info = @mysql_fetch_array($sql)) {
$i++;
$j++;
$info['i'] = $i;
$info['j'] = $j;
if ($allagency) {
$info['agency_name'] = htmlspecialchars($info['agency_name'], ENT_COMPAT, 'cp1251');
$info['agency_link'] = ADMIN_URL . "?p=agency&agency_id={$info['agency_id']}";
} elseif ($allcorporate) {
$info['corporate_name'] = htmlspecialchars($info['corporate_name'], ENT_COMPAT, 'cp1251');
$info['corporate_link'] = ADMIN_URL . "?p=corporate&corporate_id={$info['corporate_id']}";
} else {
$info['object_name'] = htmlspecialchars($info['object_name'], ENT_COMPAT, 'cp1251');
$info['object_link'] = ADMIN_URL . "?p=object&object_id={$info['object_id']}";
}
$info['inall_sum'] = $info['inall_sum'];
$info['procent'] = $replace['allsumma'] ? number_format($info['inall_sum'] * 100 / $replace['allsumma'], 2) : 0;
$info['inall_sum'] = separ_float($info['inall_sum']);
$info['p_count'] = (int) $info['p_count'];
$info['komis'] = $info['provider_count'] ? number_format($info['komis'] * 100 / $info['provider_count'], 1) : 0;
$list[] = $info;
}
$replace['list'] = $list;
$replace['allsumma'] = separ_float($replace['allsumma']);
if (@$print) {
echo get_template('templ/objreport_print.htm', $replace);
exit;
} else {
$content = get_template('templ/objreport.htm', $replace);
}
$extra_fields = "count(z.order_id) as o_count, SUM(z.inall) as o_summa, MIN(z.date) as minzdate, MAX(z.date) as maxzdate, \n\t\t\t\t\t\t\tif(YEAR(MAX(z.date))-YEAR(MIN(z.date)) < 1, count(z.order_id), \n\t\t\t\t\t\t\t\tcount(z.order_id)/( YEAR(MAX(z.date))-YEAR(MIN(z.date)) + 1)\n\t\t\t\t\t\t\t\t ) as yearcount, {$pokupka_field} as pokupka, u.name as username";
$extra_table = "\n\t\t\t\tLEFT JOIN " . TABLE_ORDER . " z ON \n\t\t\t(!z.basket AND z.status=1 AND z.card_id=c.card_id AND z.card_vip=c.vip )\n\t\t\t\tLEFT JOIN " . TABLE_USER . " u ON (u.user_id=z.user_id)";
$where = " c.active=1 AND c.ordercount>1 AND z.order_id";
//if(!$admin_config['attention_status']) $where .= " AND FIND_IN_SET('$_SESSION[admin_id]', c.users)";
//if($pokupka) $where .= " AND $pokupka_field";
$sql = mysql_query("SELECT count(c.card_id) FROM " . TABLE_CARD . " c {$extra_table} WHERE {$where}") or Error(1, __FILE__, __LINE__);
$arr = mysql_fetch_array($sql);
$replace['all'] = $arr[0];
list($limit, $replace['pages']) = pages($replace['all'], ADMIN_URL . "?p={$part}&cycle&");
$sql = mysql_query("SELECT c.*, {$extra_fields} FROM " . TABLE_CARD . " c\n\t\t\t\t{$extra_table}\n\t\t\tWHERE {$where} \n\t\t\tGROUP BY c.card_id\n\t\t\tORDER BY {$ord} LIMIT {$limit}") or Error(1, __FILE__, __LINE__);
$cards = array();
$card_name = "";
while ($info = @mysql_fetch_array($sql)) {
$info['fio'] = htmlspecialchars($info['fio'], ENT_COMPAT, 'cp1251');
$info['o_count'] = (int) @$info['o_count'];
$info['o_summa'] = separ_float($info['o_summa']);
$info['order_link'] = "?p={$part}&searchorder=1&card_id={$info['card_id']}&vip={$info['vip']}";
$info['edit_link'] = ADMIN_URL . "?p={$part}&card_id={$info['card_id']}&vip={$info['vip']}";
$info['minzdate'] = sql_to_text_date($info['minzdate']);
$info['maxzdate'] = sql_to_text_date($info['maxzdate']);
$info['yearcount'] = check_int($info['yearcount']) ? $info['yearcount'] : number_format($info['yearcount'], 1);
$info['yearcount'] = str_replace(".0", '', $info['yearcount']);
$cards[] = $info;
}
$replace['cards'] = $cards;
$replace['card_id'] = $card_id;
$replace['admin_cardid'] = $admin_config['cardid'];
$content = get_template('templ/card1_list.htm', $replace);
} else {
$left_menu = '';
$data = @unserialize($_SESSION['card_data']);
}
$info['del_link'] = !$info['inventory_id'] ? '' : ADMIN_URL . "?p={$part}&delinventory={$info['inventory_id']}";
$info['date'] = sql_to_text_date($info['date']);
$list[] = $info;
}
$replace['list'] = $list;
$replace['balance'] = $plus + $minus;
$replace['balance'] = separ_float($replace['balance']);
if ($replace['balance'] > 0) {
$replace['balance'] = "+" . $replace['balance'];
}
$replace['plus'] = separ_float($plus);
if ($replace['plus'] > 0) {
$replace['plus'] = "+" . $replace['plus'];
}
$replace['minus'] = separ_float($minus);
}
$replace['current_page'] = $current_page;
$replace['z'] = isset($z) ? 1 : 0;
$replace['admin'] = 0;
if ($inventory_office == -1) {
$replace['admin'] = 1;
$ofcount = 0;
$url = "?p={$part}";
if (isset($z)) {
$url .= "&z";
}
$replace['office_select'] = mysql_select('office_id', "SELECT office_id, region FROM " . TABLE_OFFICE . " ORDER BY office_id", $office_id, 1, 'onchange="window.location=\'' . $url . '&choffice=\'+this.value"', $ofcount);
}
if (isset($z)) {
if ($office_id) {
