/** * 获取返钱队列actType id * //todo 由于项目时间太紧,未创建对应的BLL * @return array */ public function getTypeId() { $date = APF::get_instance()->get_request()->get_parameter('date'); $actType = $this->cmsBackQueueActType; //先查询当天的记录 $sqlResult = Model_Broker_AjkPpccoinType::data_access()->filter_by_op('acttype', '=', $actType)->filter_by_op('typedate', '=', $date)->find_only(); //没有对应的记录,插入一条新记录 if (empty($sqlResult)) { $mysqlAccessor = new Model_Broker_AjkPpccoinType(); $mysqlAccessor->acttype = $this->cmsBackQueueActType; $mysqlAccessor->detail = 'CMS返钱工具化队列'; $mysqlAccessor->addtime = time(); $mysqlAccessor->typedate = $date; $mysqlAccessor->save(); $result = array('status' => 'success', 'info' => $mysqlAccessor->id); } else { $result = array('status' => 'success', 'info' => $sqlResult->id); } return $result; }
/** * 获取返现队列里面的唯一typeid * * @param int $cashBackType * @param int $date * @return int */ public static function getCashBackTypeId($cashBackType, $date) { static $tmpCashBackTypeId; if (isset($tmpCashBackTypeId[$cashBackType . '_' . $date])) { return $tmpCashBackTypeId[$cashBackType . '_' . $date]; } //查询类型是否创建 $cashBackTypeInfo = Model_Broker_AjkPpccoinType::getType($cashBackType, $date); if (!empty($cashBackTypeInfo)) { $tmpCashBackTypeId[$cashBackType . '_' . $date] = $cashBackTypeInfo['id']; return $cashBackTypeInfo['id']; } //不存在添加 $data = array('acttype' => $cashBackType, 'detail' => self::$detail[$cashBackType], 'addtime' => time(), 'typedate' => $date); $CashBackTypeId = Model_Broker_AjkPpccoinType::addType($data); //写入成功,加到cache里面 if (!empty($CashBackTypeId)) { $tmpCashBackTypeId[$cashBackType . '_' . $date] = $CashBackTypeId; } return $CashBackTypeId; }
/** * 获取经纪人返现队列ID * * @param int $cashBackType * @param int $date * @return int */ private function getCashBackTypeId($cashBackType, $date) { $cashBackTypeInfo = Model_Broker_AjkPpccoinType::getType($cashBackType, $date); if (!empty($cashBackTypeInfo)) { return $cashBackTypeInfo['id']; } try { $data = array('acttype' => $cashBackType, 'detail' => sprintf('精选消费返现%d安币', $cashBackType - 2015031900), 'addtime' => time(), 'typedate' => $date); $cashBackTypeObject = new Model_Broker_AjkPpccoinType(); $cashBackTypeObject->save($data); return $cashBackTypeObject->id; } catch (Exception $e) { $this->logMsg(sprintf('添加精选消费返现%d安币类型异常, %s', $cashBackType, $e->getMessage())); return 0; } }