Example #1
0
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;
}
Example #2
0
        $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());