$campaign->column_fields["expectedrevenue"] = $expected_revenue[$i]; $campaign->column_fields["budgetcost"] = $budget_cost[$i]; $campaign->column_fields["actualcost"] = $actual_cost[$i]; $campaign->column_fields["closingdate"] = $clo_date[$i]; $campaign->column_fields["expectedresponse"] = $expected_response[$i]; $campaign->column_fields["assigned_user_id"] = $assigned_user_id; $campaign->column_fields["expectedresponsecount"] = $expected_response_count[$i]; $campaign->column_fields["expectedsalescount"] = $expected_sales_count[$i]; $campaign->column_fields["expectedroi"] = $expected_roi[$i]; $campaign->column_fields["actualresponsecount"] = $actual_response_count[$i]; $campaign->column_fields["actualsalescount"] = $actual_sales_count[$i]; $campaign->column_fields["actualroi"] = $actual_roi[$i]; $campaign->column_fields["sponsor"] = $sponsor[$i]; $campaign->column_fields["targetsize"] = $targetsize[$i]; $campaign->column_fields["targetaudience"] = $targetaudience[$i]; $campaign->save("Campaigns"); } //Populate My Sites Data $portalname = array("Võ Trần Quân", "Võ Trần Quân Blogs", "Võ Trần Quân Facebook", "Võ Trần Quân Google +", "|"); $portalurl = array("#", "http://quansolid@blogspot.com", "https://www.facebook.com/qz.vo1", "https://plus.google.com/u/0/", "#"); for ($i = 0; $i < 5; $i++) { $portalid = $adb->getUniqueId('vtiger_portal'); $portal_qry = "insert into vtiger_portal values (?,?,?,?,?)"; $portal_params = array($portalid, $portalname[$i], $portalurl[$i], 0, 0); $result_qry = $adb->pquery($portal_qry, $portal_params); } for ($i = 0; $i < 2; $i++) { $rssid = $adb->getUniqueId('vtiger_rss'); $rss_qry = "insert into vtiger_rss values (?,?,?,?,?)"; $rss_params = array($rssid, $rssurl[$i], $rssname[$i], 0, 0); $result_qry = $adb->pquery($rss_qry, $rss_params);