function getManagedEntity($ppcEntityId, $idField, $increaseStart, $decreaseStart, $end) { $query = "SELECT SUM(b1.cost) AS total_cost, SUM(b1.revenue)-SUM(b1.cost) AS total_profit, COALESCE(increase.profit,0) AS increase_profit, COALESCE(decrease.profit,0) AS decrease_profit\n FROM bid_management_data b1 LEFT JOIN\n (SELECT b2.{$idField}, SUM(b2.revenue)-SUM(b2.cost) AS profit\n FROM bid_management_data b2\n WHERE b2.{$idField} = {$ppcEntityId} AND b2.data_date BETWEEN '{$increaseStart}' AND '{$end}'\n GROUP BY b2.{$idField}) AS increase ON increase.{$idField} = b1.{$idField} LEFT JOIN\n (SELECT b3.{$idField}, SUM(b3.revenue)-SUM(b3.cost) AS profit\n FROM bid_management_data b3\n WHERE b3.{$idField} = {$ppcEntityId} AND b3.data_date BETWEEN '{$decreaseStart}' AND '{$end}'\n GROUP BY b3.{$idField}) AS decrease ON decrease.{$idField} = b1.{$idField} "; $conn = get_conn(); $result = mysql_query($query, $conn) or die(__CLASS__ . __FUNCTION__ . 'I cannot execute the query because: ' . mysql_error()); $row = mysql_fetch_array($result); $managedEntity = $this->instantiateManagedEntity($row); close_conn($conn); return $managedEntity; }
function save($rule) { $conn = get_conn(); $cost_threshold = mysql_real_escape_string($rule->cost_threshold); $increase_percent = mysql_real_escape_string($rule->increase_percent); $increase_days = mysql_real_escape_string($rule->increase_days); $decrease_percent = mysql_real_escape_string($rule->decrease_percent); $decrease_days = mysql_real_escape_string($rule->decrease_days); $apply = $rule->apply ? 1 : 0; $query = "\n INSERT INTO bid_rule (\n id,\n ppc_entity_id,\n ppc_entity_type,\n rule_type,\n cost_threshold,\n increase_percent,\n increase_days,\n decrease_percent,\n decrease_days,\n apply\n )\n VALUES (\n {$rule->id},\n {$rule->entityId},\n {$rule->entityType},\n {$rule->ruleType},\n {$cost_threshold},\n {$increase_percent},\n {$increase_days},\n {$decrease_percent},\n {$decrease_days},\n {$apply}\n )\n ON DUPLICATE KEY UPDATE\n id=LAST_INSERT_ID(id),\n ppc_entity_id = VALUES(ppc_entity_id),\n ppc_entity_type = VALUES(ppc_entity_type),\n rule_type = VALUES(rule_type),\n cost_threshold = VALUES(cost_threshold),\n increase_percent = VALUES(increase_percent),\n increase_days = VALUES(increase_days),\n decrease_percent = VALUES(decrease_percent),\n decrease_days = VALUES(decrease_days),\n apply = VALUES(apply)\n "; mysql_query($query, $conn) or die(__CLASS__ . __FUNCTION__ . 'I cannot execute the query because: ' . mysql_error()); $rule->id = mysql_insert_id(); close_conn($conn); return $rule; }
function generate_order($body_arr) { if ($body_arr['amount'] < 1) { //金额小于1,代表小于1分钱,不允许 $resp['status'] = 1047; return $resp; exit; } $resp = exec_procedure($body_arr, 'p_order_generate'); if ($resp['status'] != 0) { return $resp; exit; } $order_no = $resp['out_data']['order_no']; //生成的orderno $goods = $body_arr['goods']; //用户传过来的商品信息,json格式 //建立一个数据库连接 $mysqli = create_conn(); //解析商品数据 $body['order_no'] = $order_no; foreach ($goods as $key => $value) { $body['good_id'] = isset($value['good_id']) ? $value['good_id'] : ''; $body['number'] = isset($value['number']) ? $value['number'] : ''; if (!$body['good_id']) { continue; } $respgood = exec_procedure($body, 'p_order_add_goods', 2, $mysqli); } //关闭句柄 close_conn($mysqli); //为了配合移动端的代码,把端口号、支付渠道移到上一层 $resp['order_no'] = isset($resp['out_data']['order_no']) ? $resp['out_data']['order_no'] : ''; $resp['pay_channel'] = isset($resp['out_data']['pay_channel']) ? $resp['out_data']['pay_channel'] : ''; return $resp; }
function saveAds($ads) { if (count($ads) > 0) { $chunks = array_chunk($ads, MAX_INSERT_ROWS); foreach ($chunks as $chunk) { $query = "INSERT INTO ppc_ads (\n id,\n ad_id,\n adgroup_id,\n ad_name,\n current_url\n ) VALUES"; foreach ($chunk as $ad) { $conn = get_conn(); $name = mysql_real_escape_string($ad->name, $conn); $query .= "(\n {$ad->id},\n '{$ad->adId}',\n {$ad->adgroup->id},\n '{$name}',\n '{$ad->currentUrl}'\n ),"; } $query = substr($query, 0, strlen($query) - 1); $query .= " ON DUPLICATE KEY UPDATE\n id = VALUES(id),\n ad_id = VALUES(ad_id),\n adgroup_id = VALUES(adgroup_id),\n ad_name = VALUES(ad_name),\n current_url = VALUES(current_url)\n "; mysql_query($query, $conn) or die(__CLASS__ . __FUNCTION__ . 'I cannot execute the query because: ' . mysql_error()); close_conn($conn); } } }
include '../library.php'; $db = connect(); $branches = $db->query("SELECT * from branch_name"); while ($branch = $branches->fetch_array()) { ?> <option val="<?php echo $branch['id']; ?> "><?php echo $branch['branch']; ?> </option> <?php echo "<br>"; } close_conn($db); ?> </select><br> </div> <p> <?php if (!isset($_SESSION['info'])) { echo $_SESSION['info']; } ?> </p> <input type="submit" class="btn btn-primary"></formsm><br>