while ($row = $result->fetch_assoc()) { $team = $row['team']; if ($team != 'test') { echo '<h2>' . $team . '</h2>'; $sql2 = "SELECT * FROM users WHERE team ='" . $team . "' ORDER BY name "; $result2 = $sql_mysqli_conn->query($sql2); while ($row2 = $result2->fetch_assoc()) { echo '<a href="temp.php?user='******'code'] . '">' . $row2['name'] . '</a><br />'; } } } $result->free(); $result2->free(); } else { $timetohighlight = get_form_var('timetohighlight', 'int'); $this_user_name = get_area_name($user); echo "<div id=\"dwm\">\n"; echo "<h2>" . htmlspecialchars("{$this_user_name}") . "</h2>\n"; echo "</div>\n"; $i = mktime(12, 0, 0, $month, $day - 7, $year); $yy = date("Y", $i); $ym = date("m", $i); $yd = date("d", $i); $i = mktime(12, 0, 0, $month, $day + 7, $year); $ty = date("Y", $i); $tm = date("m", $i); $td = date("d", $i); // Show Go to week before and after links $before_after_links_html = "\n<div class=\"screenonly\">\n <div class=\"date_nav\">\n <div class=\"date_before\">\n <a href=\"temp.php?year={$yy}&month={$ym}&day={$yd}&user={$user}\">\n << " . get_vocab("weekbefore") . "\n </a>\n </div>\n <div class=\"date_now\">\n <a href=\"temp.php?user={$user}\">\n " . get_vocab("gotothisweek") . "\n </a>\n </div>\n <div class=\"date_after\">\n <a href=\"temp.php?year={$ty}&month={$tm}&day={$td}&user={$user}\">\n " . get_vocab("weekafter") . " >>\n </a>\n </div>\n </div>\n</div>\n"; print $before_after_links_html; $inner_html = week_table_innerhtml($day, $month, $year, $user, $timetohighlight);
function print_customer_details_listing() { global $path_to_root; $from = $_POST['PARAM_0']; $area = $_POST['PARAM_1']; $folk = $_POST['PARAM_2']; $more = $_POST['PARAM_3']; $less = $_POST['PARAM_4']; $comments = $_POST['PARAM_5']; $orientation = $_POST['PARAM_6']; $destination = $_POST['PARAM_7']; if ($destination) { include_once $path_to_root . "/reporting/includes/excel_report.inc"; } else { include_once $path_to_root . "/reporting/includes/pdf_report.inc"; } $orientation = $orientation ? 'L' : 'P'; $dec = 0; if ($area == ALL_NUMERIC) { $area = 0; } if ($folk == ALL_NUMERIC) { $folk = 0; } if ($area == 0) { $sarea = _('All Areas'); } else { $sarea = get_area_name($area); } if ($folk == 0) { $salesfolk = _('All Sales Folk'); } else { $salesfolk = get_salesman_name($folk); } if ($more != '') { $morestr = _('Greater than ') . number_format2($more, $dec); } else { $morestr = ''; } if ($less != '') { $lessstr = _('Less than ') . number_format2($less, $dec); } else { $lessstr = ''; } $more = (double) $more; $less = (double) $less; $cols = array(0, 150, 300, 425, 550); $headers = array(_('Customer Postal Address'), _('Price/Turnover'), _('Branch Contact Information'), _('Branch Delivery Address')); $aligns = array('left', 'left', 'left', 'left'); $params = array(0 => $comments, 1 => array('text' => _('Activity Since'), 'from' => $from, 'to' => ''), 2 => array('text' => _('Sales Areas'), 'from' => $sarea, 'to' => ''), 3 => array('text' => _('Sales Folk'), 'from' => $salesfolk, 'to' => ''), 4 => array('text' => _('Activity'), 'from' => $morestr, 'to' => $lessstr . " " . get_company_pref("curr_default"))); $rep = new FrontReport(_('Customer Details Listing'), "CustomerDetailsListing", user_pagesize(), 9, $orientation); if ($orientation == 'L') { recalculate_cols($cols); } $rep->Font(); $rep->Info($params, $cols, $headers, $aligns); $rep->NewPage(); $result = get_customer_details_for_report($area, $folk); $carea = ''; $sman = ''; while ($myrow = db_fetch($result)) { $printcustomer = true; if ($more != '' || $less != '') { $turnover = getTransactions($myrow['debtor_no'], $myrow['branch_code'], $from); if ($more != 0.0 && $turnover <= (double) $more) { $printcustomer = false; } if ($less != 0.0 && $turnover >= (double) $less) { $printcustomer = false; } } if ($printcustomer) { if ($carea != $myrow['description']) { $rep->fontSize += 2; $rep->NewLine(2, 7); $rep->Font('bold'); $rep->TextCol(0, 3, _('Customers in') . " " . $myrow['description']); $carea = $myrow['description']; $rep->fontSize -= 2; $rep->Font(); $rep->NewLine(); } if ($sman != $myrow['salesman_name']) { $rep->fontSize += 2; $rep->NewLine(1, 7); $rep->Font('bold'); $rep->TextCol(0, 3, $myrow['salesman_name']); $sman = $myrow['salesman_name']; $rep->fontSize -= 2; $rep->Font(); $rep->NewLine(); } $rep->NewLine(); // Here starts the new report lines 2010-11-02 Joe Hunt $contacts = get_contacts_for_branch($myrow['branch_code']); $rep->TextCol(0, 1, $myrow['name']); $rep->TextCol(1, 2, _('Price List') . ": " . $myrow['sales_type']); $rep->TextCol(2, 3, $myrow['br_name']); $rep->NewLine(); $adr = Explode("\n", $myrow['address']); if ($myrow['br_post_address'] == '') { $adr2 = Explode("\n", $myrow['br_address']); } else { $adr2 = Explode("\n", $myrow['br_post_address']); } $count1 = count($adr); $count2 = count($adr2); $count1 = max($count1, $count2); $count1 = max($count1, 4); if (isset($adr[0])) { $rep->TextCol(0, 1, $adr[0]); } $rep->TextCol(1, 2, _('Currency') . ": " . $myrow['curr_code']); if (isset($contacts[0])) { $rep->TextCol(2, 3, $contacts[0]['name'] . " " . $contacts[0]['name2']); } if (isset($adr2[0])) { $rep->TextCol(3, 4, $adr2[0]); } $rep->NewLine(); if (isset($adr[1])) { $rep->TextCol(0, 1, $adr[1]); } if ($myrow['dimension_id'] != 0) { $dim = get_dimension($myrow['dimension_id']); $rep->TextCol(1, 2, _('Dimension') . ": " . $dim['name']); } if (isset($contacts[0])) { $rep->TextCol(2, 3, _('Ph') . ": " . $contacts[0]['phone']); } if (isset($adr2[1])) { $rep->TextCol(3, 4, $adr2[1]); } $rep->NewLine(); if (isset($adr[2])) { $rep->TextCol(0, 1, $adr[2]); } if ($myrow['dimension2_id'] != 0) { $dim = get_dimension($myrow['dimension2_id']); $rep->TextCol(1, 2, _('Dimension') . " 2: " . $dim['name']); } if (isset($contacts[0])) { $rep->TextCol(2, 3, _('Fax') . ": " . $contacts[0]['fax']); } if (isset($adr2[2])) { $rep->TextCol(3, 4, $adr2[2]); } if ($more != 0.0 || $less != 0.0) { $rep->TextCol(1, 2, _('Turnover') . ": " . number_format2($turnover, $dec)); } for ($i = 3; $i < $count1; $i++) { $rep->NewLine(); if (isset($adr[$i])) { $rep->TextCol(0, 1, $adr[$i]); } if ($i == 3 && isset($contacts[0]) && isset($contacts[0]['email'])) { $rep->TextCol(2, 3, _('Email') . ": " . $contacts[0]['email']); } if (isset($adr2[$i])) { $rep->TextCol(3, 4, $adr2[$i]); } } $rep->NewLine(); /* $rep->TextCol(0, 1, $myrow['name']); $adr = Explode("\n", $myrow['address']); $count1 = count($adr); for ($i = 0; $i < $count1; $i++) $rep->TextCol(0, 1, $adr[$i], 0, ($i + 1) * $rep->lineHeight); $count1++; $rep->TextCol(1, 2, _('Price List') . ": " . $myrow['sales_type']); if ($more != 0.0 || $less != 0.0) $rep->TextCol(1, 2, _('Turnover') . ": " . number_format2($turnover, $dec), 0, $rep->lineHeight); $rep->TextCol(2, 3, $myrow['br_name']); $contacts = get_branch_contacts($myrow['branch_code']); if (isset($contacts[0])) { $rep->TextCol(2, 3, $contacts[0]['name'], 0, $rep->lineHeight); $rep->TextCol(2, 3, _('Ph') . ": " . $contacts[0]['phone'], 0, 2 * $rep->lineHeight); $rep->TextCol(2, 3, _('Fax') . ": " . $contacts[0]['fax'], 0, 3 * $rep->lineHeight); } $adr = Explode("\n", $myrow['br_address']); $count2 = count($adr); for ($i = 0; $i < $count2; $i++) $rep->TextCol(3, 4, $adr[$i], 0, ($i + 1) * $rep->lineHeight); //$rep->TextCol(3, 4, $myrow['email'], 0, ($count2 + 1) * $rep->lineHeight); $count2++; $count1 = Max($count1, $count2); $count1 = Max($count1, 4); $rep->NewLine($count3); */ $rep->Line($rep->row + 8); $rep->NewLine(0, 3); } } $rep->End(); }
// print the page header print_header($day, $month, $year, $area, isset($room) ? $room : ""); // Section with areas, rooms, minicals. echo "<div id=\"dwm_header\" class=\"screenonly\">\n"; // Show all available areas echo make_area_select_html('week.php', $area, $year, $month, $day); // Show all available rooms in the current area: echo make_room_select_html('week.php', $area, $room, $year, $month, $day); // Draw the three month calendars if (!$display_calendar_bottom) { minicals($year, $month, $day, $area, $room, 'week'); } echo "</div>\n"; // Show area and room: // Get the area and room names $this_area_name = get_area_name($area); $this_room_name = get_room_name($room); // The room is invalid if it doesn't exist, or else it has been disabled, either explicitly // or implicitly because the area has been disabled if (!isset($this_area_name) || $this_area_name === FALSE) { $this_area_name = ''; } if (!isset($this_room_name) || $this_room_name === FALSE) { $this_room_name = ''; } echo "<div id=\"dwm\">\n"; echo "<h2>" . htmlspecialchars("{$this_area_name} - {$this_room_name}") . "</h2>\n"; echo "</div>\n"; //y? are year, month and day of the previous week. //t? are year, month and day of the next week. $i = mktime(12, 0, 0, $month, $day - 7, $year);
$smarty->assign('tui_info', $tui_info); $smarty->assign('favourable', favourable_info(1));//促销活动 墙壁 地板 厨房 浴室卫生间 $smarty->assign('p_num', get_p_num()); $smarty->assign('zhonghe', get_area_name('')); $smarty->assign('pengding', get_area_name('棚顶')); $smarty->assign('qiangbi', get_area_name('墙壁')); $smarty->assign('diban', get_area_name('地板')); $smarty->assign('chufang', get_area_name('厨房')); $smarty->assign('yushi', get_area_name('浴室')); $smarty->assign('weishengjian', get_area_name('卫生间')); $arr2['id'] ='223'; $arr2['num'] ='1'; $smarty->assign('ads_btm',insert_ads12($arr2)); //$smarty->assign('best_goods1', get_recommend_goods2('best',1)); /*echo "<pre>"; print_r(get_recommend_goods('hot',"1")); echo "</pre>";
function print_customer_details_listing() { global $path_to_root; include_once $path_to_root . "reporting/includes/pdf_report.inc"; $from = $_REQUEST['PARAM_0']; $area = $_REQUEST['PARAM_1']; $folk = $_REQUEST['PARAM_2']; $more = $_REQUEST['PARAM_3']; $less = $_REQUEST['PARAM_4']; $comments = $_REQUEST['PARAM_5']; $dec = 0; if ($area == reserved_words::get_all_numeric()) { $area = 0; } if ($folk == reserved_words::get_all_numeric()) { $folk = 0; } if ($area == 0) { $sarea = tr('All Areas'); } else { $sarea = get_area_name($area); } if ($folk == 0) { $salesfolk = tr('All Sales Folk'); } else { $salesfolk = get_salesman_name($folk); } if ($more != '') { $morestr = tr('Greater than ') . number_format2($more, $dec); } else { $morestr = ''; } if ($less != '') { $lessstr = tr('Less than ') . number_format2($less, $dec); } else { $lessstr = ''; } $more = (double) $more; $less = (double) $less; $cols = array(0, 150, 300, 400, 550); $headers = array(tr('Customer Postal Address'), tr('Price/Turnover'), tr('Branch Contact Information'), tr('Branch Delivery Address')); $aligns = array('left', 'left', 'left', 'left'); $params = array(0 => $comments, 1 => array('text' => tr('Activity Since'), 'from' => $from, 'to' => ''), 2 => array('text' => tr('Sales Areas'), 'from' => $sarea, 'to' => ''), 3 => array('text' => tr('Sales Folk'), 'from' => $salesfolk, 'to' => ''), 4 => array('text' => tr('Activity'), 'from' => $morestr, 'to' => $lessstr)); $rep = new FrontReport(tr('Customer Details Listing'), "CustomerDetailsListing.pdf", user_pagesize()); $rep->Font(); $rep->Info($params, $cols, $headers, $aligns); $rep->Header(); $result = get_customer_details_for_report($area, $folk); $carea = ''; $sman = ''; while ($myrow = db_fetch($result)) { $printcustomer = true; if ($more != '' || $less != '') { $turnover = getTransactions($myrow['debtor_no'], $myrow['branch_code'], $from); if ($more != 0.0 && $turnover <= (double) $more) { $printcustomer = false; } if ($less != 0.0 && $turnover >= (double) $less) { $printcustomer = false; } } if ($printcustomer) { if ($carea != $myrow['description']) { $rep->fontSize += 2; $rep->NewLine(2, 7); $rep->Font('bold'); $rep->TextCol(0, 3, tr('Customers in') . " " . $myrow['description']); $carea = $myrow['description']; $rep->fontSize -= 2; $rep->Font(); $rep->NewLine(); } if ($sman != $myrow['salesman_name']) { $rep->fontSize += 2; $rep->NewLine(1, 7); $rep->Font('bold'); $rep->TextCol(0, 3, $myrow['salesman_name']); $sman = $myrow['salesman_name']; $rep->fontSize -= 2; $rep->Font(); $rep->NewLine(); } $rep->NewLine(); $rep->TextCol(0, 1, $myrow['name']); $adr = Explode("\n", $myrow['address']); $count1 = count($adr); for ($i = 0; $i < $count1; $i++) { $rep->TextCol(0, 1, $adr[$i], 0, ($i + 1) * $rep->lineHeight); } $count1++; $rep->TextCol(1, 2, tr('Price List') . ": " . $myrow['sales_type']); if ($more != 0.0 || $less != 0.0) { $rep->TextCol(1, 2, tr('Turnover') . ": " . number_format2($turnover, $dec), 0, $rep->lineHeight); } $rep->TextCol(2, 3, $myrow['br_name']); $rep->TextCol(2, 3, $myrow['contact_name'], 0, $rep->lineHeight); $rep->TextCol(2, 3, tr('Ph') . ": " . $myrow['phone'], 0, 2 * $rep->lineHeight); $rep->TextCol(2, 3, tr('Fax') . ": " . $myrow['fax'], 0, 3 * $rep->lineHeight); $adr = Explode("\n", $myrow['br_address']); $count2 = count($adr); for ($i = 0; $i < $count2; $i++) { $rep->TextCol(3, 4, $adr[$i], 0, ($i + 1) * $rep->lineHeight); } $rep->TextCol(3, 4, $myrow['email'], 0, ($count2 + 1) * $rep->lineHeight); $count2++; $count1 = Max($count1, $count2); $count1 = Max($count1, 4); $rep->NewLine($count1); $rep->Line($rep->row + 8); $rep->NewLine(0, 3); } } $rep->End(); }