/**
* @param $attr
*/
private function translate($attr)
{
$ad = new AD();
$types = $ad->get_all_labels(PDO::FETCH_KEY_PAIR);
$attr['code'] = md5($attr['id'] . BAOBEI_SALT);
$attr['quote_rmb'] = number_format($attr['quote_rmb'] / 100, 2);
$attr['ad_type'] = $types[$attr['ad_type']];
$attr['cate'] = ADModel::$CATE[$attr['cate']];
$permissions = $ad->get_permissions(['ad_id' => $attr['id']]);
$permissions = array_values($permissions);
$attr['permissions'] = implode("\n<br>", $permissions);
$attr['feedback'] = ADModel::$FEEDBACK[$attr['feedback']];
$attr['ad_desc'] = preg_replace('/<span style="color: rgb\\(255, 0, 0\\);">(.*?)<\\/span>/', '', $attr['ad_desc']);
// 过滤掉标红文字
if (is_numeric($attr['channel'])) {
$channel = new Channel();
$attr['channel'] = $channel->get_channel(array('id' => $attr['channel']))[$attr['channel']];
}
if ($attr['agreement_id']) {
$agreement = new Agreement();
$agreements = $agreement->get_agreements_basic(['id' => $attr['agreement_id']]);
$agreement = $agreements[$attr['agreement_id']];
$attr['agreement'] = $agreement['company_short'] ? $agreement['company_short'] : $agreement['company'];
}
return $attr;
}
public function save(array $attr = null)
{
$DB = $this->get_write_pdo();
// 取发票ID或者渠道ID
$agreement_service = new Agreement();
$agreement = $agreement_service->get_agreement_by_id(array('agreement_id' => $attr['agreement_number']));
$attr = array_merge(array('agreement_id' => $agreement['id']), $attr);
unset($attr['agreement_number']);
$attr = $attr ? $attr : $this->attributes;
$new_attr = $this->judge_status($attr, $attr['comment']);
// 关联的广告信息
$invoice_ads = $attr['products'];
unset($attr['products']);
$incomes = $this->multi_100(Utils::array_pick($attr, self::$INVOICE_INCOMES));
$attr = array_merge($attr, $new_attr, $incomes, array('apply_time' => date('Y-m-d')));
// 插入发票表
$this->save_invoice_info($DB, $attr);
// 核减发送通知给相应的运营
if ($attr['income'] != $attr['income_first']) {
// 查找商务对应的运营
$admin_service = new Admin();
$operation_id = $admin_service->get_sale_operation($_SESSION['id']);
// 记录到通知表
$notice = new Notification();
$notice->send(array('uid' => SQLHelper::$lastInsertId, 'admin_id' => $operation_id, 'alarm_type' => Notification::$NEW_INVOICE, 'create_time' => date('Y-m-d H:i:s')));
}
$invoice_id = SQLHelper::$lastInsertId;
$this->attributes = array_merge(array('id' => $invoice_id), $this->attributes);
$invoice_ad_arr = array();
if (is_array($invoice_ads)) {
$invoice_ad_arr = $this->construct_invoice_ads($invoice_ads, $invoice_id);
}
// 插入到发票广告关联表
$this->save_invoice_ad_info($DB, $invoice_ad_arr);
}
public function renew($id)
{
$mailer = new Mailer();
$service = new Agreement();
$admin = new Admin();
$me = $_SESSION['id'];
$managers = [4 => '*****@*****.**', 23 => '*****@*****.**', 45 => '*****@*****.**', 129 => '*****@*****.**'];
$attr = $this->get_post_data();
$attr['fullname'] = $_SESSION['fullname'];
$agreement = $service->get_agreement_by_id(['id' => $id]);
if (!$agreement) {
$this->exit_with_error(11, '参数错误', 400);
}
if ($agreement['owner'] != $me) {
$this->exit_with_error(10, '你不能对别人的合同进行操作', 403);
}
$agreement['company_type'] = Agreement::$TYPE[$agreement['company_type']];
$content = $mailer->create('agreement-renew', $agreement, $attr);
$manager = $admin->get_my_manager($me);
$to = ['*****@*****.**', $managers[$manager]];
$cc = ['*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**', $_SESSION['user'] . '@dianjoy.com'];
$check = $mailer->send($to, '商务申请合同续期', $content, $cc);
if ($check) {
$this->output(['code' => 0, 'msg' => '发送成功']);
} else {
$this->exit_with_error(20, '发送邮件失败', 400, $check);
}
}
public function get_notice($admin_id, $role, $latest)
{
$DB = $this->get_read_pdo();
$m = new Mustache_Engine();
$ad_service = new AD();
$sql = "SELECT `type`\n FROM `t_alarm_group`\n WHERE `group`={$role}";
$types = $DB->query($sql)->fetchAll(PDO::FETCH_COLUMN);
$types = implode(',', $types);
$type_sql = $types ? " OR `alarm_type` IN ({$types})" : '';
// 只取最近一周，再早的估计也没啥处理的必要了
$date = date('Y-m-d', time() - 86400 * 6);
$sql = "SELECT a.`id`, `uid`, `user_id`, `app_id`, `ad_id`, a.`status`,\n `create_time`, `op_time`, `description`, `handler`\n FROM `t_admin_alarm_log` a LEFT JOIN `t_alarm_type` t ON a.alarm_type=t.id\n WHERE (`admin_id`='{$admin_id}' {$type_sql})\n AND `create_time`>'{$date}' AND a.`status`=0 AND a.`id`>{$latest}\n ORDER BY `id` DESC";
$alarms = $DB->query($sql)->fetchAll(PDO::FETCH_ASSOC);
foreach ($alarms as &$alarm) {
$alarm['id'] = (int) $alarm['id'];
if ($alarm['ad_id']) {
if (strlen($alarm['ad_id']) == 32) {
$ad = $ad_service->get_ad_info(array('id' => $alarm['ad_id']), 0, 1);
$alarm['name'] = $ad['ad_name'];
}
} else {
if ($alarm['uid']) {
// 发票通知提醒
$invoice_id = $alarm['uid'];
$invoice_service = new Invoice();
$agreement_service = new Agreement();
$invoice = $invoice_service->get_invoice_by_id($invoice_id);
$agreement = $agreement_service->get_agreement_by_id(array('id' => $invoice['agreement_id']));
$alarm['channel'] = $agreement['company_short'];
$admin_service = new Admin();
$sale = $admin_service->get_sales_info($alarm['user_id']);
$alarm['sale'] = $sale['NAME'];
}
}
$alarm['status'] = (int) $alarm['status'];
$alarm['handler'] = $m->render($alarm['handler'], $alarm);
}
return $alarms;
}
/**
* 取新建广告的表单项，修改广告时当前内容
* @author Meathill
* @since 0.1.0
* @param $id
*/
public function init($id)
{
$CM = $this->get_cm();
$service = new AD();
$admin = new Admin();
$labels = $service->get_all_labels();
$permissions = $service->get_all_permissions();
$me = $_SESSION['id'];
$im_cp = $_SESSION['role'] == Auth::$CP_PERMISSION;
$init = array('ad_app_type' => $im_cp ? 2 : 1, 'ad_type' => 0, 'cate' => 1, 'cpc_cpa' => 'cpa', 'put_level' => 3, 'imsi' => 0, 'put_net' => 0, 'net_type' => 0, 'put_jb' => 0, 'put_ipad' => 0, 'salt' => substr(md5(time()), 0, 8), 'url_type' => '', 'province_type' => 0, 'share_text' => '', 'down_type' => 0);
$options = array('cates' => array('试用', '注册'), 'net_types' => array('全部', '移动', '联通', '电信'), 'channel_types' => ChannelModel::$TYPE, 'ad_types' => $labels, 'permissions' => $permissions, 'provinces' => $CM->provinces, 'sales' => false, 'cp' => $im_cp);
$agreement = new Agreement();
if (!$im_cp) {
$init = array_merge($init, array('ratio' => 1, 'feedback' => 0, 'cycle' => 0));
$relative_sales = $options['sales'] = $admin->get_sales_by_me($me);
if ($relative_sales) {
$relative = array();
foreach ($relative_sales as $key => $value) {
$relative[] = array('key' => $key, 'value' => $value);
}
$options["relativeSales"] = $relative;
}
$options['agreements'] = $agreement->get_my_agreement(['today' => date('Y-m-d')]);
}
if ($id === 'init') {
$this->output(array('code' => 0, 'msg' => 'init', 'ad' => $init, 'options' => $options));
}
// 广告内容
if (!$service->check_ad_owner($id)) {
$this->exit_with_error(20, '您无法查询此广告的详细信息', 401);
}
$res = $service->get_ad_info(array('id' => $id), 0, 1);
$res['id'] = $id;
$ad_shoot = preg_replace('/^,|,$/', '', $res['ad_shoot']);
$ad_shoots = preg_split('/,+/', $ad_shoot);
if (is_array($ad_shoots)) {
foreach ($ad_shoots as $key => $ad_shoot) {
$ad_shoots[$key] = $this->createCompletePath($ad_shoot);
}
$res['ad_shoot'] = $ad_shoots;
}
$res['ad_url'] = $this->createCompletePath($res['ad_url']);
$res['pic_path'] = $this->createCompletePath($res['pic_path']);
// 取计划任务，得投放量
$job_service = new Job();
$job = $job_service->get_ad_daily_job($id);
$job = (array) $job[$id];
// 省份
if ($res['province_type'] == 1) {
$location = new Location();
$provinces = $location->get_provinces_by_ad($id);
$res['put_provinces'] = array_values(array_unique($provinces));
}
// 被据广告读原因
if ($res['status'] == 4) {
$op_log = new ADOperationLogger();
$log = $op_log->get_log(array('adid' => $id, 'type' => 'ad', 'action' => 'decline'));
$res['decline'] = $log;
}
// 点评
$res['comments'] = $service->get_comments(array('ad_id' => $id));
// 今天的投放情况
$stat = new Stat();
$today = date('Y-m-d');
$filter = [':ad_id' => $id, ':date' => $today];
$clicks = $stat->get_ad_click_by_hour($filter);
$transfer = $stat->get_ad_transfer_by_hour($filter);
$today_stat = [];
for ($hour = 0; $hour < 24; $hour++) {
$item = array('hour' => $today . ' ' . $hour);
if (isset($clicks[$hour])) {
$item['click'] = (int) $clicks[$hour];
}
if (isset($transfer[$hour])) {
$item['transfer'] = (int) $transfer[$hour];
}
$today_stat[] = $item;
}
if (in_array($res['status'], array(0, 1))) {
// 备注
$comments = $service->get_ad_comments(array($id));
$res = array_merge($res, array('cm_others' => $comments[$id]));
}
$result = array_merge($init, $res, $job);
$result['today_stat'] = $today_stat;
$this->output(array('code' => 0, 'msg' => 'fetched', 'ad' => $result, 'options' => $options));
}
private function get_ad_agreements(array $list)
{
$agreements = array();
foreach ($list as $ad) {
if ($ad['agreement_id']) {
$agreements[] = $ad['agreement_id'];
}
}
if ($agreements) {
$service = new Agreement();
$agreements = $service->get_agreements_basic(['id' => $agreements]);
foreach ($list as $key => $ad) {
if ($ad['agreement_id']) {
$list[$key]['agreement'] = $agreements[$ad['agreement_id']]['company_short'];
$list[$key]['company'] = $agreements[$ad['agreement_id']]['company'];
}
}
}
return $list;
}
public function get_transfer_ad($ad_id)
{
$me = $_SESSION['id'];
$start = $_REQUEST['start'];
$end = $_REQUEST['end'];
$ad_service = new AD();
$channel = $ad_service->get_ad_channel_by_id($ad_id);
$agreement_service = new Agreement();
$agreement = $agreement_service->get_agreement_by_adid($ad_id);
$agreement_id = $agreement['id'];
$filters = array('salesman' => $me, 'channel' => $channel);
// 取出用户在该渠道下的所有广告
$ads = $ad_service->get_all_ad_info($filters);
// 取出这段期间内有量的广告
$quote_service = new Quote();
$quote_ads = $quote_service->get_all_quote_ad($start, $end);
$ids = array_unique(array_intersect(array_keys($ads), array_keys($quote_ads)));
$list = array();
$invoice_service = new Invoice();
foreach ($ids as $id) {
// 剔除该段时间内已经开过票的广告
$nums = $invoice_service->is_invoice($id, $start, $end);
if ($nums > 0) {
continue;
}
// 剔除没有关联合同的广告
if (!isset($ads[$id]['agreement_id'])) {
continue;
}
$ad = array('ad_id' => $id, 'ad_name' => $ads[$id]['ad_name'], 'channel_id' => $ads[$id]['cid'], 'channel' => $agreement_id, 'alias' => $ads[$id]['channel']);
$list[] = $ad;
}
$this->output(array('code' => 0, 'msg' => "get", 'list' => $list));
}