業績分紅 · PHP應用開發記錄

``` ALTER TABLE `ims_ewei_shop_commission_level` ADD COLUMN `fhbi` decimal(11,2) NULL DEFAULT 0 , ADD COLUMN `tmshopprice` decimal(11,2) NULL DEFAULT 0 , ADD COLUMN `tmshopprices` decimal(11,2) NULL DEFAULT 0 AFTER `tmshopprice`, ADD COLUMN `fftime` int(11) NULL DEFAULT 0 AFTER `tmshopprices`; //頁面設置 $dataset = m("common")->getPluginset("commission"); <div class="form-group"> <label class="col-lg control-label">全球業績分紅比例</label> <div class="col-sm-9 col-xs-12"> <div class="input-group fixmore-input-group"> <input type="text" name="data[fhbi]" class="form-control" value="{$data['fhbi']}" /> <div class="input-group-addon">%</div> </div> <span class="help-block">按全部業績的N%分紅</span> </div> </div> //agent.html <a class="btn-default btn-sm btn-op " style="color:balck;" type="button" data-toggle='batch-batch' data-confirm="昨日商城總銷售額為{php echo empty($totalprice) ? 0 : $totalprice}元，獎金池為{php echo $totalbouns}元，確認要發放分紅?" data-href="{php echo webUrl('commission/agent/ffbouns')}"> <i class='icow icow-shenhetongguo'></i> 發放昨日分紅 </a> //列表操作 <a class="btn btn-op btn-operation" data-toggle='ajaxPost' href="{php echo webUrl('commission/agent/uptm',array('id' => $row['id']));}" target='_blank'> <span data-toggle="tooltip" data-placement="top" title="" data-original-title="更新團隊人數"> <i class='icow icow-bianji2'></i> </span> </a> //level.heml <div class="page-toolbar"> <a class="btn-primary btn-sm btn-op " type="button" data-toggle='batch-batch' data-confirm="確認要發放分紅?" data-href="{php echo webUrl('commission/level/ffbouns')}"> <i class='icow icow-shenhetongguo'></i> 發放商城分紅 </a> 當前平臺可發放銷售額為{$others[0]['tmshopprice']}元，上次發放時間為{php echo date("Y-m-d H:i", $others[0]["fftime"])}。 </div> //團隊分紅 $tmprice = $agentuser['tmprice']+$orderprice; pdo_update('ewei_shop_member', array('tmprice'=>$tmprice), array('id' => $member['id'])); public function ffbouns() { global $_W; global $_GPC; $members = pdo_fetchall("SELECT * FROM " . tablename("ewei_shop_member") . " WHERE status = 1 and isagent = 1 and agentlevel>0 and tmshopprice>0 and uniacid=" . $_W["uniacid"]); if(empty($members)){ show_json(0, '暫無代理商需要分紅！'); } $bounsdata = array( 'addtime' => time(), 'status' => 1, 'type' => 1, 'note' => '團隊分紅', ); foreach( $members as $member ) { $bounsdata['totalprice'] = $member['tmshopprice']; $bounsdata['memberid'] = $member['id']; $level = $this->model->getLevel($member['openid']); $bounsdata['mcommission'] = round($member['tmshopprice']*$level['tmbi']/100,2); if($bounsdata['mcommission']>0){ pdo_insert("ewei_shop_agentbouns", $bounsdata); pdo_update('ewei_shop_member', array('tmshopprice'=>0,'tmshopprices'=>$member['tmshopprices']+$member['tmshopprice']), array('id' => $member['id'])); } } show_json(1, '所有分紅已成功發放！'); } //獎金池分紅 public function ffbouns() { global $_W; global $_GPC; global $_S; $set = $_S['commission']; $fhbi = (int)$set['fhbi']; $level = pdo_fetch("select * from " . tablename("ewei_shop_commission_level") . " where id=1"); if($level['tmshopprice']<=0){ show_json(0, '可發放金額為空！'); } $members = pdo_fetchall("SELECT id FROM " . tablename("ewei_shop_member") . " WHERE status = 1 and isagent = 1 and agentlevel=4 and uniacid=" . $_W["uniacid"]); $mcount = count($members); if($mcount>0){ $bounsdata = array( 'addtime' => time(), 'status' => 1, 'type' => 3, 'note' => '全球業績分紅', ); $bounsdata['mcommission'] = round($level['tmshopprice']*$fhbi/$mcount/100,2); if($bounsdata['mcommission']>0){ foreach( $members as $member ) { $bounsdata['memberid'] = $member['id']; pdo_insert("ewei_shop_agentbouns", $bounsdata); } } }else{ show_json(0, '暫無分銷商需要發放！'); } pdo_update('ewei_shop_commission_level', array('tmshopprice'=>0,'fftime'=>time()), array('id' => 1)); show_json(1, '成功發放！本次發放人數為'.$mcount.'人'); } ```