require_once '../classes/Keyword.php'; $db = new DBAdapter2(array('host' => KWDB_HOST, 'username' => KWDB_USERNAME, 'password' => KWDB_PASSWORD, 'schema' => KWDB_SCHEMA)); $campaign = new GoogleCampaign($db); $campaign->ga_campaign_name = CAMPAIGN_NAME_BASE . " " . date("Y-m-d H i"); $campaign->save(); $db->executeSQL("SELECT keyword_id, keyword, occurs, word_count, source_keyword_id , c.l_image, c.l_make, c.l_color, c.l_model\n\t\t\t\t\tFROM m2m_keywords_to_niches a \n\t\t\t\t\tleft join keywords b using(keyword_id)\n\t\t\t\t\tLEFT JOIN {$table} c USING(keyword_id)\nWHERE c.l_image!= '' and niche_id = " . NICHE . " and occurs > " . GROUP_SIZE . " and word_count > 2 order by word_count desc, occurs desc", $resultArry, $rowsAffected); $total = $rowsAffected; $left = $total; echo $total . " keywords\r\n"; $start_time = date('U'); $kws = array(); $keyword = new Keyword($db); $fp = fopen("../output/" . str_replace(" ", "_", $campaign->ga_campaign_name) . ".csv", "w+"); fputs($fp, "Campaign,Daily Budget,Language,Location,Proximity Targets,Ad Schedule,Ad Group,Max CPC,Keyword Type,Keyword,Image,Ad Name,Image Size,Display URL,Destination URL\r\n"); foreach ($resultArry as $val) { $adgroup = new GoogleImageAdGroup($db); $adgroup->giag_campaign_id = $campaign->ga_campaign_id; $adgroup->giag_display_url = DISPLAY_URL; $adgroup->buildDestinationUrl($val); $adgroup->save(); $adgroup->giag_name = "Ad " . $adgroup->giag_id . " " . $val['keyword']; $adgroup->save(); $ad = $adgroup->buildAds("http://images.kabel.co.il/photo/?url=" . $val['l_image'] . "§ion=realestate"); fputs($fp, "{$campaign->ga_campaign_name},20,iw,IL,,,{$adgroup}," . MAX_CPC . "\r\n"); foreach ($adgroup->ads as $add) { fputs($fp, "{$campaign->ga_campaign_name},,,,,,{$adgroup},,,," . $add->gia_image . "," . $add->gia_name . "," . $add->gia_size . "," . $adgroup->giag_display_url . ",\"" . $adgroup->giag_destination_url . "\"\r\n"); } $tmp = explode(" ", $val['keyword']); $search = ""; foreach ($tmp as $t) { $search .= " and (keyword LIKE '% " . addslashes($t) . " %' or keyword LIKE '% " . addslashes($t) . "' or keyword LIKE '" . addslashes($t) . " %')";
function testBuildDestinationUrl() { $this->assertTrue($this->item->buildDestinationUrl(array('l_model' => 3, 'l_make' => 'Mazda', 'l_color' => 'white'))); $this->assertEqual("http://vehicles.kabel.co.il/search/Mazda%203?&price=1000-&color=white", $this->item->giag_destination_url); }