</td>
<td><?php
echo $row["mobile"];
?>
</td>
<td><?php
echo $row["dept"];
?>
</td>
<td><?php
echo $row["cardno"];
?>
</td>
<td>
<?php
echo getmidstr(CFG_SUBSCRIBLE_MODE, $row["fellow"]);
?>
</td>
<td><?php
echo $row["cdt"];
?>
</td>
<td>
<input type="checkbox" class="setmaster" <?php
echo $row["master"] == 1 ? "checked" : "";
?>
value="<?php
echo $row["master"];
?>
" alt="<?php
echo $uids;
echo '</a>';
echo '<div class="foodcon floatl" onclick="selectedFood(\'' . $row["kid"] . '\', \'' . $row["mid"] . '\')">';
echo '<p class="price"><label>单价(元)：</label><label id="food_price' . $row["mid"] . '">' . sprintf("%0.2f", $row["price"]) . '</label></p>';
echo '<p class="num" style="border:0px solid red;"><label>数量(' . $row["unit"] . ')：</label><label id="food_num' . $row["mid"] . '">' . intval($amount) . '</label> </p>';
echo '<p><label>总价(元)：</label><label id="food_total_price' . $row["mid"] . '">' . sprintf("%0.2f", $t_price) . '</label></p>';
echo '</div>';
echo '</div>';
if (strlen($row["noteinfo"]) > 0) {
echo '<p style="text-align:center; padding:0 5px 5px 5px;">' . $row["noteinfo"] . '</p>';
}
echo '<p class="fcomment clearfix">';
echo '<span class="floatl" onclick="change_food_num(\'' . $row["mid"] . '\',\'+\',\'' . $row["kid"] . '\')"><a href="javascript:;"><i class="icon-plus"></i>加一份<em></em></a></span>';
echo '<span class="floatl" onclick="change_food_num(\'' . $row["mid"] . '\',\'-\',\'' . $row["kid"] . '\')"><a href="javascript:;"><i class="icon-minus"></i>减一份<em></em></a></span> ';
echo '<span class="floatl" onclick="userDianZan(this, \'' . $row["mid"] . '\')" style="border-right:0; border-right:none;"><i class="icon-thumbs-up"></i>赞' . $row["uptimes"] . '</span> ';
echo '</p>';
echo '<em class="lt" style="background-image:url(images/' . getmidstr(CFG_MENU_FLAG_PIC, $row["flagid"]) . ')">';
$flagname = $row["flagname"];
echo mb_substr($flagname, 0, 2, 'utf-8') . "<br>" . mb_substr($flagname, 2, strlen($flagname), 'utf-8');
echo '</em>';
echo '</li>';
$haveline = true;
}
//
$row_head = null;
}
}
if ($haveline) {
echo '</ul></div>';
$haveline = false;
}
?>
<?php
$nid = null;
$params = array(array($nid, SQLSRV_PARAM_IN));
$sp = "{call web_get_news_list(?)}";
$rs = sp_execute($sp, $params);
//
foreach ($rs as $row) {
?>
<tr>
<td width="4%;"><?php
echo $row["newsid"];
?>
</td>
<td width="6%;">
<?php
echo getmidstr(CFG_NEWS_TYPE, $row["kind"]);
?>
</td>
<td>
<div class="news_div_content News_Title underline"><b>标题：</b><?php
echo $row["title"];
?>
</div>
<div class="news_div_content News_Picurl underline"><b>图片链接：</b><?php
echo $row["picurl"];
?>
</div>
<div class="news_div_content News_Describle underline"><b>内容：</b><?php
echo $row["describle"];
?>
</div>
echo $rs[0]["mname"];
?>
" maxlength="20" class="form-control"/>
</div>
</div>
<div class="form-group" style="margin-bottom:10px">
<label class="control-label col-sm-3" for="title">标签图案</label>
<div class="col-sm-8">
<ul class="biaoqianul">
<?php
$s = str_replace("<br>", "", CFG_MENU_FLAG_TXT);
$a = str2array($s);
$i = 0;
foreach ($a as $row) {
echo '<li>';
echo '<img src="../images/' . getmidstr(CFG_MENU_FLAG_PIC, $i) . '" width="30" height="25" alt="' . $row . '" title="' . $row . '">';
echo '<input type="radio" name="flagid" value="' . $i . '" class="menu-flag" alt="' . $row . '" ' . ($rs[0]["flagid"] == $i ? "checked" : "") . '>';
echo '</li>';
$i++;
}
?>
</ul>
</div>
</div>
<div class="form-group" style="margin-bottom:10px">
<label class="control-label col-sm-3" for="title">标签文字</label>
<div class="col-sm-5">
<input type="text" id="flagname" name="flagname" value="<?php
echo $rs[0]["flagname"];
?>
" class="form-control" maxlength="4" />
">
<img src="<?php
echo strlen($row["headurl"]) > 0 ? $row["headurl"] : CFG_HTTP . CFG_USER_DEFAULT;
?>
" width="16" height="16">
</td>
<td><?php
echo $row["nickname"];
?>
</td>
<td><?php
echo getmidstr(CFG_SUBSCRIBLE_MODE, $row["fellow"]);
?>
</td>
<td><?php
echo getmidstr(CFG_YESNO, $row["master"]);
?>
</td>
<td><?php
echo $row["mobile"];
?>
</td>
<td>
<button class="emptyall btn btn-xs filter-submit margin-bottom">清空全部餐厅</button>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
$objPHPExcel->getActiveSheet()->mergeCells('B' . ($i - 1) . ':B' . $i);
$objPHPExcel->getActiveSheet()->mergeCells('C' . ($i - 1) . ':C' . $i);
$objPHPExcel->getActiveSheet()->mergeCells('D' . ($i - 1) . ':D' . $i);
$objPHPExcel->getActiveSheet()->mergeCells('E' . ($i - 1) . ':E' . $i);
$objPHPExcel->getActiveSheet()->mergeCells('J' . ($i - 1) . ':J' . $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["arrdt"]);
$objPHPExcel->getActiveSheet(0)->setCellValue('E' . $i, $row["uname"]);
$objPHPExcel->getActiveSheet(0)->setCellValue('E' . $i, $row["Company"]);
$objPHPExcel->getActiveSheet(0)->setCellValue('F' . $i, $row["mname"]);
$objPHPExcel->getActiveSheet(0)->setCellValue('G' . $i, sprintf("%0.2f", $row["price"]));
$objPHPExcel->getActiveSheet(0)->setCellValue('H' . $i, $row["amount"]);
$objPHPExcel->getActiveSheet(0)->setCellValue('I' . $i, sprintf("%0.2f", $row["pay_t"]));
$objPHPExcel->getActiveSheet(0)->setCellValue('J' . $i, getmidstr(CFG_ORDER_STATE, $row["state"]));
$i++;
}
// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle($mode_str . '订单明细');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
$data = array('examTitle' => $mode_str . '订单明细');
// 输出
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="' . $data['examTitle'] . '.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
echo $row["account"];
?>
</td>
<td>
<?php
echo '<img src="' . CFG_HTTP . (strlen($row["picurl"]) > 0 ? CFG_SHOP_PATH . $row["picurl"] : CFG_SHOP_DEFAULT) . '" width="24px" height="24px;">';
?>
</td>
<td width="4%">
<?php
echo getmidstr(CFG_YESNO, $row["show"]);
?>
</td>
<td>
<?php
echo getmidstr(CFG_MENU_SHOW_MODE, $row["menumode"]);
?>
</td>
<td><?php
echo $row["cdt"];
?>
</td>
<td>
<?php
$addr = $row["addr"];
if (strlen($row["px"]) > 0 && strlen($row["py"]) && strlen($addr) == 0) {
$addr = get_location_bdapi(CFG_BDAPI_AK, $row["px"], $row["py"]);
//to update tb_canteen
$params = array(array($row["cid"], SQLSRV_PARAM_IN), array("" . $addr, SQLSRV_PARAM_IN));
sp_execute("{call web_set_canteen_addr(?,?)}", $params);
}
<div class="orderline">
<div class="floatl destxt fw">就餐</div>
<div class="floatl desval <?php
echo $stateColor;
?>
fw"><?php
echo $row["arrdt"];
?>
</div>
<div class="floatl destxtm fw">方式</div>
<div class="floatl destxtfr <?php
echo $stateColor;
?>
fw">
<?php
echo getmidstr(CFG_DISTRIBUTION_MODE, $row["sam"]);
?>
</div>
</div>
<div class="orderline">
<div class="floatl destxt fw">数量</div>
<div class="floatl desval <?php
echo $stateColor;
?>
fw"><?php
echo $row["amount"];
?>
份</div>
<div class="floatl destxtm fw">总价</div>
<div class="floatl destxtfr <?php
echo $stateColor;
</td>
<td width="60px;">
<?php
echo '<img src="' . CFG_HTTP . (strlen($row["picurl"]) > 0 ? CFG_MENU_PATH . $row["picurl"] : CFG_MENU_DEFAULT) . '" width="24px" height="24px;">';
?>
</td>
<td width="40px;">
<?php
echo getmidstr(CFG_YESNO, $row["show"]);
?>
</td>
<td width="80px;">
<div style="width:40px; height:30px; position:relative;">
<div style="position:absolute; left:0; top:0">
<img src="images/<?php
echo getmidstr(CFG_MENU_FLAG_PIC, $row["flagid"]);
?>
" width="38" height="30">
</div>
<div style="position:absolute; left:4px; top:3px; height:30px; line-height:12px; color:#fff; font-size:12px;">
<?php
$flagname = $row["flagname"];
echo mb_substr($flagname, 0, 2, 'utf-8') . "<br>" . mb_substr($flagname, 2, strlen($flagname), 'utf-8');
?>
</div>
</div>
</td>
<td width="110px;"><?php
echo $row["cdt"];
?>
</td>
<td><?php
echo $row["unit"];
?>
</td>
<td><?php
echo floatval($row["price"]);
?>
</td>
<td>
<?php
echo '<img src="' . CFG_HTTP . (strlen($row["picurl"]) > 0 ? CFG_MENU_PATH . $row["picurl"] : CFG_MENU_DEFAULT) . '" width="24px" height="24px;">';
?>
</td>
<td>
<?php
echo getmidstr(CFG_YESNO, $row["show"]);
?>
</td>
<td><?php
echo $row["flagname"];
?>
</td>
<td><?php
echo $row["cdt"];
?>
</td>
<td>
<button class="edit btn btn-xs filter-submit margin-bottom" value="<?php
echo $row["flagid"];
?>
">修改</button>
if ($merglines > 0) {
$htmlStr .= str_replace('#YY#', $merglines, $str_line);
}
$str_line = sprintf('<tr style=" background:%s" class="OD_%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 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>
<td rowspan="#YY#" style="vertical-align:middle;">%s</td>
%s
</tr>', $even % 2 ? "#DFF0D8" : "#FCF8E3", num2str_x(orderid_content_x, $row["oid"]), num2str_x(orderid_content_x, $row["oid"]), $row["cdt"], $row["arrdt"], $row["uname"], $row["Company"], $row["mname"], $row["price"], $row["amount"], $row["pay_t"], getmidstr(CFG_ORDER_STATE, $row["state"]), $td_btn_str);
$merglines = 1;
$curOid = $row["oid"];
} else {
//append
$str_line = sprintf('%s<tr style=" background:%s" class="OD_%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", num2str_x(orderid_content_x, $row["oid"]), $row["mname"], $row["price"], $row["amount"], $row["pay_t"]);
$merglines++;
}
}
//
if ($merglines > 0) {