/**
* 获取认筹单不同模板类型的打印原始数据
* @param $chips
* @param $templateType
* @return array
*/
function biz_Print_getChipsData($chips, $templateType)
{
$user = $chips['user'];
if (!is_array($user)) {
}
$data = array('客户名称' => $chips['cname'], '二维码' => $chips['qrcode'], '客户性别' => $user['Gender'], '证件号码' => $user['CardID'], '手机号码' => $user['MobileTel'], '通讯地址' => $user['Address'], '邮编' => $user['PostCode'], '家庭电话' => $user['HomeTel'], '证件类型' => $user['CardType'], '国籍' => $user['Country'], '空' => '', '零' => '0');
if (empty($data['国籍'])) {
$data['国籍'] = '中国';
}
$res = biz_getChipsCustomerInfo($chips, true);
$data['权益人'] = $res['name'];
$data['权益人证件'] = $res['card'];
$project = biz_getProject($chips['projguid']);
$data['项目名称'] = $project['projname'];
$printDate = TIMESTAMP;
if ($templateType > 2) {
$room = db_getRoomByGUID($chips['roomguid']);
$build = db_getBuildingById($room['BldGUID']);
$data['楼栋名称'] = $build['BldName'];
$data['预售证号'] = $build['PreSaleNo'];
$data['预售证日期大写'] = Date2Cn($build['PreSaleDate']);
$data['房间名'] = $room['ShowCode'];
$data['房间号'] = $room['Room'];
$data['定金'] = number_format($chips['premoney'] + $chips['ordermoney'], 2);
$data['定金大写'] = Num2Cny($chips['premoney'] + $chips['ordermoney']);
}
$data['代理公司'] = $chips['agency'];
$data['业务员'] = $chips['salesman'];
switch ($templateType) {
case 1:
$data['认筹书编号'] = $chips['ChipsNo'];
$data['辅助代理'] = $chips['agencychild'];
$intend = explode(',', $chips['intendroom']);
$data['具体意向1'] = empty($intend[0]) ? '' : $intend[0];
$data['具体意向2'] = empty($intend[1]) ? '' : $intend[1];
$data['具体意向3'] = empty($intend[2]) ? '' : $intend[2];
$data['备注'] = $chips['remark'];
$printDate = $chips['printdate'];
break;
case 2:
//只打印最后一次
$item = biz_getBill($chips['qrcode'], 1, 1);
$data['诚意金'] = number_format($item['Money'], 2);
$data['诚意金大写'] = Num2Cny($item['Money']);
$data['交款人'] = $item['Jkr'];
$data['收款人'] = $item['Kpr'];
$data['票据批次号'] = $item['BatchNo'];
$data['票据编号'] = $item['InvoNo'];
$printDate = $item['createtime'];
break;
case 3:
$item = biz_getBill($chips['qrcode'], 2, 1);
$data['交款人'] = $item['Jkr'];
$data['收款人'] = $item['Kpr'];
$data['票据批次号'] = $item['BatchNo'];
$data['票据编号'] = $item['InvoNo'];
$printDate = $item['createtime'];
break;
case 4:
$data['建筑面积'] = $room['BldArea'];
$data['套内面积'] = $room['TnArea'];
$data['建筑单价'] = number_format($room['Price'], 2);
$data['套内单价'] = number_format($room['TnPrice'], 2);
$data['价格'] = number_format($room['Total'], 2);
$data['成交价'] = number_format($room['RoomTotal'], 2);
$data['成交价大写'] = Num2Cny($room['RoomTotal']);
$data['折扣'] = $room['DiscntValue'];
$data['认购书编号'] = $chips['ProtocolNO'];
$pay = biz_unserializer($project, 'payform');
$data['付款方式'] = $pay['Payform']['PayformName'];
$sql = " select * from " . tablename('s_Fee') . " where TradeGUID =:qrcode ";
$fees = pdo_fetchall($sql, array(':qrcode' => $chips['qrcode']), 'ItemName');
if (isset($fees['首期'])) {
$data['首期房款日期'] = date('Y年m月d日', strtotime($fees['首期']['lastDate']));
$data['首期房款金额'] = number_format($fees['首期']['Amount'], 2);
$data['首期房款百分比'] = $fees['首期']['Rate'];
$data['定金+首期'] = number_format($fees['首期']['Amount'] + $chips['shouldpay'], 2);
}
if (isset($fees['银行按揭'])) {
$data['按揭金额'] = number_format($fees['银行按揭']['Amount'], 2);
$data['按揭百分比'] = $fees['银行按揭']['Rate'];
}
if (isset($fees['维修基金'])) {
$data['维修基金'] = number_format($fees['维修基金']['Amount'], 2);
}
$data['备注'] = $chips['remark'];
$printDate = $chips['QSDate'];
break;
}
$date = getdate($printDate);
$data['打印日期'] = date('Y年m月d日', $printDate);
$data['打印日期-年'] = $date['year'];
$data['打印日期-月'] = $date['mon'];
$data['打印日期-日'] = $date['mday'];
return $data;
}
}
// 显示认购书信息
if ($op == 'disp') {
$id = intval($_GPC['id']);
$chips = biz_getChips($id, true);
$this->CheckDataRight($chips);
if (!biz_checkChipsStatus($chips, 7)) {
message('未打印订金不能确认！', $this->createWebUrl($do), 'info');
}
//定单是否已确认
$confirmed = biz_checkChipsStatus($chips, 8);
$user_info = $chips['user'];
if (checksubmit() && !$confirmed) {
//定单没有确认，
load()->web('app');
$room = db_getRoomByGUID($chips['roomguid']);
if (!empty($room)) {
if ($room['Status'] == '交款') {
$room['NewStatus'] = '认购';
//4强制更新状态？
APP_updateRoomStatus($room, $chips, 2);
}
if (empty($chips['ProtocolNO'])) {
load()->web('print');
biz_updateChipsProtocolNo($chips);
}
if (biz_insertFee($chips, $room)) {
//更新状态为确认
db_updateChipsStatus($chips['id'], 8);
message('认购确定，生成供款明细成功！', $this->createWebUrl($do));
} else {
function erp_Write_Order($chips, $payform)
{
$write = false;
$projGUID = $chips['projguid'];
$room = db_getRoomByGUID($chips['roomguid']);
$AjTotal = AjTotal($chips['projguid'], $chips['qrcode']);
$OrderGUID = GUID();
$order = array('OrderGUID' => $OrderGUID, 'TradeGUID' => $chips['qrcode'], 'ProjGuid' => $chips['projguid'], 'Ywy' => $chips['salesman'], 'CreatedBy' => $chips['creator'], 'BUGUID' => $room['BUGUID'], 'RoomGUID' => $chips['roomguid'], 'DiscntValue' => $room['DiscntValue'], 'BldCjPrice' => $room['BldCjPrice'], 'BldArea' => $room['BldArea'], 'Price' => $room['Price'], 'TnArea' => $room['TnArea'], 'TnPrice' => $room['TnPrice'], 'Total' => $room['Total'], 'CjTotal' => $room['RoomTotal'], 'RmbCjTotal' => $room['RoomTotal'], 'DiscntRemark' => $payform['calc']['remark'], 'PayFormName' => $payform['Payform']['PayformName'], 'RoomTotal' => $room['RoomTotal'], 'TnCjPrice' => $room['TnCjPrice'], 'Bz' => '人民币', 'OrderType' => '认购', 'Status' => '激活', 'AreaStatus' => '预售', 'ExRate' => 1.0, 'PotocolNO' => $chips['ProtocolNO'], 'QSDate' => date("Y-m-d", $chips['QSDate']), 'EndDate' => date("Y-m-d", strtotime("+10 days ", $chips['QSDate'])), 'CreatedOn' => date("Y-m-d", $chips['QSDate']), 'ModiDate' => date("Y-m-d", $chips['QSDate']), 'YwblDate' => date("Y-m-d", $chips['QSDate']), 'DLGS' => $chips['agency'], 'CreatedByGUID' => $chips['createid'], 'IsCreatorUse' => 1, 'SpState' => 0, 'NewZsAmount' => 0, 'Xzdlgs' => $chips['agencychild'], 'IsJjx' => 0, 'IsZx' => 0, 'TjrRoomBldArea' => 0, 'TjrDiscnt' => 100, 'XyTotal' => $room['RoomTotal'], 'CjSum' => 0, 'CalMode' => $room['CalcRentMode'], 'Earnest' => $chips['shouldpay'], 'UserGUIDList' => $chips['salesmanGUID'], 'fjcsdj' => $room['CsDjTotal'], 'AjTotal' => $AjTotal['Amount'], 'signguid' => $projGUID);
$write = MsSql()->insertObject('s_Order', $order);
if (!$write) {
logging('写入s_Order出错', $chips['qrcode']);
}
if ($write) {
$oc2sale = array('OC2SaleGUID' => GUID(), 'SaleGUID' => $OrderGUID, 'SaleType' => '定单', 'UserGUID' => $chips['salesmanGUID'], 'FTRate' => 100, 'signguid' => $projGUID);
$write = MsSql()->insertObject('s_OC2Sale', $oc2sale);
if (!$write) {
logging('写入s_OC2Sale出错', $chips['qrcode']);
}
}
if ($write) {
$discount[] = array('DiscntGUID' => $payform['Payform']['PayFormGUID'], 'SaleType' => '定单', 'DiscntName' => $payform['Payform']['PayformName'], 'DisCntType' => '付款方式', 'CalMethod' => '打折', 'DiscntValue' => $payform['Payform']['DisCount'], 'PreferentialPrice' => '0.00', 'Remark' => '付款方式定义的折扣');
$keys = array_keys($discount[0]);
foreach ($payform['disc_Details'] as $p) {
$discount[] = array_elements($keys, $p);
}
$i = 1;
foreach ($discount as $d) {
$d['OCDiscountGUID'] = GUID();
$d['SaleGUID'] = $OrderGUID;
$d['OCDiscountGUID'] = GUID();
$d['signguid'] = $projGUID;
$d['Sequence'] = $i++;
if (MsSql()->insertObject('s_OCDiscount', $d) === false) {
logging('写入s_OCDiscount出错', $d['Sequence']);
}
}
}
if ($write) {
// 更新房间状态信息，
$customers = biz_getChipsCustomerInfo($chips);
$update = array('Status' => $room['Status'], 'CstGUIDList' => $customers['guid'], 'CstName' => $customers['name'], 'ChooseRoomDate' => $room['ChooseRoomDate'], 'Status' => $room['Status'], 'ChooseRoomCstName' => $customers['name']);
// $sql = "update p_Room set Status='{$room['Status']}',CstGUIDList='{$update['CstGUIDList']}',ChooseRoomCstName='{$update['CstName']}',ChooseRoomDate='{$update['ChooseRoomDate']}' where RoomGUID='{$chips['roomguid']}' ";
if (MsSql()->update('p_Room', $update, array('RoomGUID' => $chips['roomguid'])) === false) {
logging('写入p_Room出错', $chips['roomguid']);
$write = false;
}
}
return $write;
}
