public function getOrderTicketSn($order_id)
{
$tbTicketSn = \Wechat\Model\TicketSnModel::TICKET_SN;
//需要数据表
$tbTicketOrderDetail = \Wechat\Model\TicketOrderDetailModel::TICKET_ORDER_DETAIL;
//药品各种参数
$result = $this->table(self::TICKET_ORDER . ' a')->join('left join ' . $tbTicketOrderDetail . ' b ON a.id=b.order_id')->join('left join ' . $tbTicketSn . ' c ON b.did=c.did')->field('a.id,b.price,c.*')->where(array('a.id' => $order_id))->select();
foreach ($result as $k => $v) {
if ($v['qrcode']) {
$result[$k]['qrurl'] = $v['qrcode'];
} else {
$qrcode = createQr($v['ticket_sn']);
$result[$k]['qrurl'] = $qrcode;
$cond['ticket_sn'] = $v['ticket_sn'];
$cond['did'] = $v['did'];
D('TicketSn')->where($cond)->save(array('qrcode' => $qrcode));
}
$result[$k]['statusName'] = $this->orderStatus[$v['status']];
//过期修改状态为已使用
if ($v['status'] == 0 && $v['expiry_date'] && $v['expiry_date'] < time()) {
$result[$k]['statusName'] = '已过期';
$this->where(array('ticket_sn' => $v['ticket_sn']))->save(array('status' => 2));
$result[$k]['status'] = 2;
}
$result[$k]['expiry_date'] = $v['expiry_date'] ? date('Y-m-d H:i:s', $v['expiry_date']) : '';
}
return $result;
}
public function testqrAct()
{
echo createQr("123456");
}
/**
* 支付成功，获取票序列号入库
* @param string $order_sn
*/
private function addTicketSn($order_sn)
{
recordLog('调取weixinbuy接口开始', 'wechatPay');
$orderInfo = D('TicketOrder')->orderAllInfo($order_sn);
recordLog($orderInfo, 'wechatPay');
$result = R('Api/weixinbuy', array($orderInfo));
if ($result['data']) {
recordLog($result['data'], 'wechatPay');
foreach ($result['data'] as $k => $v) {
if ($v['ticketNo']) {
D('TicketSn')->addTicketSn($orderInfo['did'], $v['ticketNo'], createQr($v['ticketNo']), $v['expiryDate'], $v['price'], $v['ticketTypeId'], $v['ticketTypeName']);
}
}
$snResult = D('TicketOrder')->ticketPriceUseCoupon($order_sn);
$this->returnPrice($snResult);
//返回价格
} else {
recordLog('返回票sn失败', 'wechatPay');
}
recordLog('调取weixinbuy接口结束', 'wechatPay');
return true;
}
