活动报名 进阶支付版 版本3.3.3

<?php // +---------------------------------------------------------------------- // | Copyright (c) 2015-2020. // +---------------------------------------------------------------------- // | Describe: 活动操作模型类 // +---------------------------------------------------------------------- // | Author: woniu // +---------------------------------------------------------------------- class model_activity { /** * 获取单条活动信息 * * @access static * @name getSingleActivity * @param mixed 参数一的说明 * @return array */ static function getSingleActivity($id,$select,$where=array()){ global $_W,$_GPC; $where['id'] = $id; $activityInfo = Util::getSingelData($select,'fx_activity',$where); if(empty($activityInfo)) return array(); if($activityInfo['merchantid']){ $merchant = pdo_fetch("SELECT name FROM " . tablename('fx_merchant') . " WHERE uniacid = {$_W['uniacid']} and id={$activityInfo['merchantid']}"); $activityInfo['merchantname'] = $merchant['name']; } $activityInfo['storeids'] = unserialize($activityInfo['storeids']); return $activityInfo; } /** * 获取单表单信息 * * @access static * @name getSingleActivityForm * @param mixed 参数一的说明 * @return array */ static function getSingleActivityForm($id){ global $_W; $form = pdo_get('fx_form', array('id' => $id)); return $form; } /** * 获取规格选项 * * @access static * @name getSingleActivityOption * @param mixed 参数一的说明 * @return array */ static function getSingleActivityOption($id){ global $_W; $option = pdo_get('fx_spec_option', array('id' => $id)); return $option; } /** * 获取店铺 * * @access static * @name getNumActivityStore * @param mixed 参数一的说明 * @return array */ static function getNumActivityStore($storeids){ global $_W; if(empty($storeids))return FALSE; foreach($storeids as$key=>$value){ if($value)$stores[$key] = pdo_fetch("select * from".tablename('fx_store')."where id ='{$value}' and uniacid={$_W['uniacid']}"); } return $stores; } /** * 获取表单 * * @access static * @name getNumActivityForm * @param $id 商品ID * @return array */ static function getNumActivityForm($id,$acType = 'web'){ //获取表单条目 Start global $_W; $condition = " uniacid = '{$_W['uniacid']}'"; $allforms = pdo_fetchall("select * from " . tablename('fx_form')." where".$condition." and activityid=:id order by displayorder asc",array(":id"=>$id)); $condition.= $acType == 'app' ? " and `show`=1" : ""; foreach ($allforms as &$s) { $s['items'] = pdo_fetchall("select * from " . tablename('fx_form_item') . " where".$condition." and formid=".$s['id']." order by displayorder asc"); } return array($allforms); } /** * 获取规格 * * @access static * @name getNumActivitySpec * @param $id 商品ID * @return array */ static function getNumActivitySpec($id,$acType = 'web'){ //获取表单条目 Start global $_W; $condition = " uniacid = '{$_W['uniacid']}'"; $allspecs = pdo_fetchall("select * from " . tablename('fx_spec')." where".$condition." and activityid=:id order by displayorder asc",array(":id"=>$id)); $condition.= $acType == 'app' ? " and `show`=1" : ""; foreach ($allspecs as &$s) { $s['items'] = pdo_fetchall("select * from " . tablename('fx_spec_item') . " where".$condition." and specid=".$s['id']." order by displayorder asc"); } $options = pdo_fetchall("select * from " . tablename('fx_spec_option') . " where activityid=:id order by id asc", array(':id' => $id)); $specs = array(); if (count($options) > 0) { $specitemids = explode("_", $options[0]['specs']); foreach ($specitemids as $itemid) { foreach ($allspecs as $ss) { $items = $ss['items']; foreach ($items as $it) { if ($it['id'] == $itemid) { $specs[] = $ss; break; } } } } //获取规格条目 End //获取价格列表 Start $html = ''; $html .= '<table class="table table-bordered table-condensed">'; $html .= '<thead>'; $html .= '<tr class="active">'; $len = count($specs); $newlen = 1; //多少种组合 $h = array(); //显示表格二维数组 $rowspans = array(); //每个列的rowspan //计算每个列的行数 得到$rowspans和$newlen for ($i = 0; $i < $len; $i++) { //表头 $html .= "<th style='width:80px;'>" . $specs[$i]['title'] . "</th>"; //计算多种组合 $itemlen = count($specs[$i]['items']); if ($itemlen <= 0) { $itemlen = 1; } $newlen *= $itemlen; //初始化 二维数组 $h = array(); for ($j = 0; $j < $newlen; $j++) { $h[$i][$j] = array(); } //计算rowspan $l = count($specs[$i]['items']); $rowspans[$i] = 1; for ($j = $i + 1; $j < $len; $j++) { $rowspans[$i] *= count($specs[$j]['items']); } } //价格列表头部 $html .= '<th class="info" style="width:130px;"><div class=""><div style="padding-bottom:10px;text-align:center;font-size:16px;">活动名额</div><div class="input-group"><input type="text" class="form-control option_quota_all" VALUE=""/><span class="input-group-addon"><a href="javascript:;" class="fa fa-hand-o-down" title="批量设置" onclick="setCol(\'option_quota\');"></a></span></div></div></th>'; if ($_W['allow']['activity']['falseinfo'] || !$_W['allow']) { $html .= '<th class="success" style="width:150px;"><div class=""><div style="padding-bottom:10px;text-align:center;font-size:16px;">虚拟名额</div><div class="input-group"><input type="text" class="form-control option_falsenum_all" VALUE=""/><span class="input-group-addon"><a href="javascript:;" class="fa fa-hand-o-down" title="批量设置" onclick="setCol(\'option_falsenum\');"></a></span></div></div></th>'; } $html .= '<th class="warning" style="width:150px;"><div class=""><div style="padding-bottom:10px;text-align:center;font-size:16px;">报名费用</div><div class="input-group"><input type="text" class="form-control option_aprice_all" VALUE=""/><span class="input-group-addon"><a href="javascript:;" class="fa fa-hand-o-down" title="批量设置" onclick="setCol(\'option_aprice\');"></a></span></div></div></th>'; //$html .= '<th class="danger" style="width:150px;"><div class=""><div style="padding-bottom:10px;text-align:center;font-size:16px;">市场价格</div><div class="input-group"><input type="text" class="form-control option_costprice_all" VALUE=""/><span class="input-group-addon"><a href="javascript:;" class="fa fa-hand-o-down" title="批量设置" onclick="setCol(\'option_costprice\');"></a></span></div></div></th>'; $html .= '</tr></thead>'; //获得表格二维数组$h for ($m = 0; $m < $len; $m++) { $k = 0; $kid = 0; $n = 0; for ($j = 0; $j < $newlen; $j++) { $rowspan = $rowspans[$m]; if ($j % $rowspan == 0) { $h[$m][$j] = array("html" => "<td rowspan='" . $rowspan . "'>" . $specs[$m]['items'][$kid]['title'] . "</td>", "id" => $specs[$m]['items'][$kid]['id']); } else { $h[$m][$j] = array("html" => "", "id" => $specs[$m]['items'][$kid]['id']); } $n++; if ($n == $rowspan) { $kid++; if ($kid > count($specs[$m]['items']) - 1) { $kid = 0; } $n = 0; } } } //获得整个价格列表 $hh = ""; for ($i = 0; $i < $newlen; $i++) { $hh .= "<tr>"; $ids = array(); for ($j = 0; $j < $len; $j++) { $hh .= $h[$j][$i]['html']; $ids[] = $h[$j][$i]['id']; } $ids = implode("_", $ids); $val = array("id" => "", "title" => "", "quota" => "", "costprice" => "", "aprice" => "", "falsenum" => "", "weight" => ""); foreach ($options as $o) { if ($ids === $o['specs']