''){ $sqltext=sprintf(" AND order_check = '%s' ",$_POST['s1']); } if($_POST['s2']<>''){ $sqltext.=sprintf(" AND mem_name = '%s' ",$_POST['s2']); } if($_POST['s3']<>''){ $sqltext.=sprintf(" AND order_num = '%s' ",$_POST['s3']); } } */ $currentPage = "mysale1.html";//$_SERVER["PHP_SELF"]; $maxRows_Rt2 = 10; $pageNum_Rt2 = 0; if (isset($_GET['pageNum_Rt2'])) { $pageNum_Rt2 = $_GET['pageNum_Rt2']; } $startRow_Rt2 = $pageNum_Rt2 * $maxRows_Rt2; $colname_Rt2 = "-1"; if (isset( $_SESSION['login_memid'] )) { $colname_Rt2 = $_SESSION['login_memid'] ; } $colname_Rt2=-1; mysql_select_db($database_BE2, $BE2); $query_Rt2 = sprintf("SELECT a.*,b.p_count,b.p_money,b.p_percent,c.p_title,c.p_num,d.scode as dscode,d.mem_name as dname FROM order_datam as a,order_datas as b,product_data as c,member as d WHERE a.dcode=b.dcode AND b.mem_auto=c.mem_auto AND c.company_num='%s' AND a.duser=d.mem_auto %s ORDER BY a.dcode DESC",$_SESSION['login_memid'],$sqltext); ;//,$colname_Rt2 //$query_Rt2 = sprintf("SELECT * FROM product_order_data WHERE company_num='%s' %s ORDER BY mem_auto DESC",$_SESSION['login_memid'],$sqltext);//,$colname_Rt2 $query_limit_Rt2 = sprintf("%s LIMIT %d, %d", $query_Rt2, $startRow_Rt2, $maxRows_Rt2); $Rt2 = mysql_query($query_limit_Rt2, $BE2) or die(mysql_error()); $row_Rt2 = mysql_fetch_assoc($Rt2); echo $query_Rt2; if (isset($_GET['totalRows_Rt2'])) { $totalRows_Rt2 = $_GET['totalRows_Rt2']; } else { $all_Rt2 = mysql_query($query_Rt2); $totalRows_Rt2 = mysql_num_rows($all_Rt2); } $totalPages_Rt2 = ceil($totalRows_Rt2/$maxRows_Rt2)-1; $queryString_Rt2 = ""; if (!empty($_SERVER['QUERY_STRING'])) { $params = explode("&", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_Rt2") == false && // stristr($param, "act") == false && stristr($param, "totalRows_Rt2") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_Rt2 = "&" . htmlentities(implode("&", $newParams)); } } $queryString_Rt2 = sprintf("&totalRows_Rt2=%d%s", $totalRows_Rt2, $queryString_Rt2); ?>
產品資訊

新增產品資訊 商品進銷存
訂單狀態 訂購人姓名 訂單編號
0){ do { ?>
訂單日期 訂購人 訂單編號 商品名稱 商品貨號 數量 單價 金額 物流 總金額 結存 交易完成 入帳日 入帳銀行 付款模式 金流費用 回饋金 抽成獎金 匯費 人帳金額 物流費用 單筆利潤 管理
會員編號 會員姓名
              訂單明細 編輯訂 刪除