Example #1
0
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) {
Example #2
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);
}
Example #3
0
$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' => '订单明细');
// 输出
Example #4
0
//
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;