$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) {