function processingPaymentRequest() { //calulate previous month $date = date('Y-m', strtotime("0 month")); //get list publishers $pids = getAllIdPublishers(); //get list websites if (!empty($pids)) { foreach ($pids as $pid) { //checking if (!checkExistPaymentRequest($pid, $date)) { //get list website id $wids = getAllIdWebsites($pid); $data = sumEarnPerCampaign($wids, $date); $campaigns = $data['campaign']; $prid = insertPaymentRequest($pid, $date, $data['total']); //payment request id if (!empty($campaigns)) { foreach ($campaigns as $cpid => $campaign) { $amount = $campaign['cost']; $impression = $campaign['impression']; $click = $campaign['click']; if ($click != 0 && $impression != 0) { $ctr = $click / $impression; } else { $ctr = 0; } insertPaymentRequestDetail($pid, $cpid, $prid, $amount, $impression, $click, $ctr, $date); } } } } } }
function excuteSumPayment($pid, $date) { if (!checkExistPaymentRequest($pid, $date)) { //get list website id $wids = getAllIdWebsites($pid); $data = sumEarnPerCampaign($wids, $date); $campaigns = $data['campaign']; $prid = insertPaymentRequest($pid, $date, $data['total']); //payment request id if (!empty($campaigns)) { foreach ($campaigns as $cpid => $campaign) { $amount = $campaign['cost'] != '' ? $campaign['cost'] : 0; $impression = $campaign['impression']; $click = $campaign['click']; if ($click != 0 && $impression != 0) { $ctr = $click / $impression; } else { $ctr = 0; } insertPaymentRequestDetail($pid, $cpid, $prid, $amount, $impression, $click, $ctr, $date); } } } }