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>
