foreach ($rs[1] as $row) { if ($curOid != $row["oid"]) { $even++; if ($merglines > 0) { $htmlStr .= str_replace('#YY#', $merglines, $str_line); } $str_line = sprintf('<tr style="background:%s"> <td rowspan="#YY#" style="vertical-align:middle;">%s</td> <td rowspan="#YY#" style="vertical-align:middle;">%s</td> <td rowspan="#YY#" style="vertical-align:middle;">%s</td> <td rowspan="#YY#" style="vertical-align:middle;">%s</td> <td style="vertical-align:middle;">%s</td> <td style="vertical-align:middle;">%0.2f</td> <td style="vertical-align:middle;">%d</td> <td style="vertical-align:middle;">%0.2f</td> </tr>', $even % 2 ? "#DFF0D8" : "#FCF8E3", num2str_x(orderid_content_x, $row["oid"]), $row["cdt"], $row["uname"], $row["Company"], $row["mname"], $row["price"], $row["amount"], $row["pay_t"]); $merglines = 1; $curOid = $row["oid"]; } else { //append $str_line = sprintf('%s<tr style="background:%s"> <td style="vertical-align:middle;">%s</td> <td style="vertical-align:middle;">%0.2f</td> <td style="vertical-align:middle;">%d</td> <td style="vertical-align:middle;">%0.2f</td> </tr>', $str_line, $even % 2 ? "#DFF0D8" : "#FCF8E3", $row["mname"], $row["price"], $row["amount"], $row["pay_t"]); $merglines++; } } // if ($merglines > 0) {
/** * 餐厅管理人员受理订单后,发送消息给用户 * 取餐通知 * 格式: * 商店名称 * 订单编号 * 订单类型 * 付款状态 * @param $cids 餐厅编号 * @param $oid 订单编号 * @param $uname 用户姓名 * @param $cname 餐厅名称 * @param $winname 窗口名称 * @param $paysta 支付状态 * @param $uid 用户编号 * @param $amount 菜品数量 * @param $total 总价 * @param $towid 接收消息的微信号 */ function altermsg_for_sales($cids, $oid, $uname, $cname, $winname, $paysta, $uid, $amount, $total, $towid) { $token = db_get_token_ticket(CFG_APPID, CFG_SECRET)["token"]; $oids = num2str_x(orderid_content_x, $oid); $uids = num2str(userid_content, $uid); $pre_str = '{"first": {"value":"%s,在【%s】取餐","color":"#000000"},"storeName":{"value":"%s","color":"#000000"},"orderId":{"value": "%s","color":"#000000"},"orderType":{"value":"默认","color":"#000000"},"remark":{"value":"订单数量:%s\\r\\n订单金额:¥%0.2f\\r\\n付款状态:%s\\r\\n\\r\\n点击查看订单详情,并完成销售","color":"#000000"}}'; $data = sprintf($pre_str, $uname, $winname, $cname, $oids, $amount, $total, $paysta); send_template_message($token, $towid, CFG_TPMSG_QUCAN, CFG_HTTP . "mobile/admin_order_list.php?act=preuids&cids={$cids}&uids={$uids}", "#7B68EE", $data); }
$objPHPExcel->getActiveSheet()->mergeCells("A2:H2"); $objPHPExcel->getActiveSheet(0)->setCellValue('A2', '查询日期:' . $rs[0][0]["tdt"] . ' 订单总数:' . $rs[0][0]["otn"] . ' 总金额:¥' . sprintf("%0.2f", $rs[0][0]["pay_t"])); $i = 4; //从第几行开始写数据 $curOid = 0; foreach ($rs[1] as $row) { if ($row["oid"] == $curOid) { //合并单元格 $objPHPExcel->getActiveSheet()->mergeCells('A' . ($i - 1) . ':A' . $i); $objPHPExcel->getActiveSheet()->mergeCells('B' . ($i - 1) . ':B' . $i); $objPHPExcel->getActiveSheet()->mergeCells('C' . ($i - 1) . ':C' . $i); $objPHPExcel->getActiveSheet()->mergeCells('D' . ($i - 1) . ':D' . $i); } else { $curOid = $row["oid"]; } $objPHPExcel->getActiveSheet(0)->setCellValue('A' . $i, num2str_x(orderid_content_x, $row["oid"])); $objPHPExcel->getActiveSheet(0)->setCellValue('B' . $i, $row["cdt"]); $objPHPExcel->getActiveSheet(0)->setCellValue('C' . $i, $row["uname"]); $objPHPExcel->getActiveSheet(0)->setCellValue('D' . $i, $row["Company"]); $objPHPExcel->getActiveSheet(0)->setCellValue('E' . $i, $row["mname"]); $objPHPExcel->getActiveSheet(0)->setCellValue('F' . $i, sprintf("%0.2f", $row["price"])); $objPHPExcel->getActiveSheet(0)->setCellValue('G' . $i, $row["amount"]); $objPHPExcel->getActiveSheet(0)->setCellValue('H' . $i, sprintf("%0.2f", $row["pay_t"])); $i++; } // Rename sheet $objPHPExcel->getActiveSheet()->setTitle('订单明细'); // Set active sheet index to the first sheet, so Excel opens this as the first sheet $objPHPExcel->setActiveSheetIndex(0); $data = array('examTitle' => '订单明细'); // 输出
// if (isset($_REQUEST["cids"])) { $_SESSION["cid"] = str2num(canteenid_content, $_REQUEST["cids"]); } //通过cookie中的wid获取uid $sp = "{call app_user_get_myords(?,?)}"; $params = array(array(intval($_SESSION["uid"]), SQLSRV_PARAM_IN), array(intval($_SESSION["cid"]), SQLSRV_PARAM_IN)); $rs = sp_execute($sp, $params); $haveOK = false; if (count($rs) > 0) { foreach ($rs as $row) { if ($oid != 0 && $row["oid"] != $oid) { continue; } $haveOK = true; $oids = num2str_x(orderid_content_x, $row["oid"]); $stateColor = $row["state"] == 1 ? "chengse1" : ($row["state"] == 11 ? "statecolor1" : ($row["state"] == 18 ? "statecolor2" : "statecolor2")); ?> <div class="myOrderWrap" id="Order_Index_<?php echo $row["oid"]; ?> "> <div class="ordertitletime"><?php echo $row["cdt"]; ?> </div> <div class="user-order-wrap"> <div class="orderline"> <div class="floatl destxt fw">状态</div> <div class="floatl desval fw <?php echo $stateColor;