function getPlatformSpecificUsers($tableName, $colName = 'uid') { $db = new Table($tableName); $users = $db->getALL(array($colName)); $db->close(); $pltf_users = array(); foreach ($users as $key => $value) { $pltf_users[] = $value[$colName]; } return $pltf_users; }
$id = $value["id"]; /* 获取当前单元下的所有关键词 */ $keywordArr = getKeyword($value["id"]); if (empty($keywordArr) || !isset($keywordArr["body"]["data"])) { echo "计划[" . $value["jihuaname"] . "],单元[" . $value["groupname"] . "],没有查到关键词\n"; continue; } foreach ($keywordArr["body"]["data"] as $value1) { /* 插入数据库 */ $insertArr = array("id" => $value1["keywordId"], "campaignId" => $value1["campaignId"], "adgroupId" => $value1["adgroupId"], "keyword" => $value1["keyword"], "pcDestinationUrl" => $value1["pcDestinationUrl"]); echo $insertArr["keyword"] . "\n"; writeBeans($insertArr["keyword"]); //file_put_contents("/tmp/keyword.log", $insertArr["keyword"] . "\n", FILE_APPEND); } } $conn->close(); } function writeBeans($id) { global $beanstalk; try { $beanstalk->choose('v3www_prokeyword_jingjia'); echo $beanstalk->put($id, array('priority' => 1024, 'delay' => 0, 'ttr' => 86400)), "\n"; } catch (\Exception $e) { } } function getKeyword($groupid) { $data = array("header" => array("token" => "1f888ce6fb38730a14a6afe7437fc3b4", "username" => "郑州悉知", "password" => "GCWgcd7232275"), "body" => array("wordFields" => array("keywordId", "campaignId", "adgroupId", "keyword", "status", "pcDestinationUrl"), "ids" => array($groupid), "idType" => 5)); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, "https://api.baidu.com/json/sms/service/KeywordService/getWord");
// Register properties $builder->registerPropertyName('id', 'public_id'); $builder->registerPropertyName('name', 'public_name'); $builder->registerPropertyName('score', 'public_score'); /** * Set select order */ // Order by score desc $builder->orderBy(new OrderParameter('score', OrderParameter::DESC)); // Same score? Order by name asc $builder->orderBy(new OrderParameter('name', OrderParameter::ASC)); // Same score and same name? Sort on ID $builder->orderBy(new OrderParameter('id', OrderParameter::ASC)); // Set the request parameters $builder->setRequest($_GET); /** * Select and output data */ // Build the select query $query = $builder->build(); // Load the data $sql = $query->toQuery($pdo, 'entries'); $results = $pdo->query($sql)->fetchAll(); // Post process results. Very important. Don't forget. $results = $builder->processResults($query, $results); // Display the records $table = new Table(['id', 'name', 'score']); $table->open(); $table->data($results); $table->close(); $table->navigation($builder->getNavigation());