public function actionIndex($fileName)
{
Yii::import("application.models.*");
//get the latest idle cron job
$dataFolderPath = Yii::getPathOfAlias("application.data");
$filePath = $dataFolderPath . DIRECTORY_SEPARATOR . $fileName;
$errorLogFile = $dataFolderPath . DIRECTORY_SEPARATOR . 'RELOAD-LOG.txt';
/*check filename availability*/
if (file_exists($filePath) && is_file($filePath)) {
$contents = file_get_contents($filePath);
/*read each content of file*/
$fp = fopen($filePath, "rb");
while (!feof($fp)) {
$currentLine = fgets($fp);
$currentLine = trim($currentLine);
$currentLine = "0" . $currentLine;
$newBlacklist = new BlackListedMobile();
$newBlacklist->mobile_number = $currentLine;
/*check if current mobile number is valid , 07321654987 */
/*if valid save to database*/
if ($newBlacklist->save()) {
echo $currentLine . ' SAVED!' . PHP_EOL;
} else {
file_put_contents($errorLogFile, "ERROR WITH : {$newBlacklist->mobile_number} : ERROR MESSAGE : " . implode(":", $newBlacklist->getErrors("mobile_number")) . " HAVING value : {$newBlacklist->mobile_number}" . PHP_EOL, FILE_APPEND);
// echo "ERROR WITH : $currentLine : ERROR MESSAGE : ".CHtml::errorSummary($newBlacklist).PHP_EOL;
echo "ERROR WITH : {$newBlacklist->mobile_number} : ERROR MESSAGE : " . implode(":", $newBlacklist->getErrors("mobile_number")) . " HAVING value : {$newBlacklist->mobile_number}" . PHP_EOL;
}
}
}
echo PHP_EOL . "RELOADING..... DONE \n";
}
public function actionIndex()
{
Yii::import("application.models.*");
//get the latest idle cron job
/* @var $latestidle JobQueue*/
$latestidle = JobQueue::model()->findByAttributes(array("status" => JobQueue::$JOBQUEUE_STATUS_IDLE));
if (!$latestidle) {
echo "No file queued";
die;
}
//set status to on-going
$latestidle->status = JobQueue::$JOBQUEUE_STATUS_ON_GOING;
$latestidle->save(false);
//retrieve file
$queueFile = new SplFileObject($latestidle->filename);
//read file
$queueFile->setFlags(SplFileObject::READ_CSV | SplFileObject::READ_AHEAD | SplFileObject::DROP_NEW_LINE | SplFileObject::SKIP_EMPTY);
$queueFile->next();
// Total_records ,
$queueFile->seek(PHP_INT_MAX);
$linesTotal = $queueFile->key();
$latestidle->total_records = $linesTotal;
$latestidle->save(false);
$index = 0;
foreach ($queueFile as $currentLine) {
//iterate content
if ($queueFile->key() === 0) {
continue;
}
//TODO: processed_record
$latestidle->processed_record = ++$index;
$latestidle->save(false);
$currentMobile = $currentLine[0];
$newBlackListedmobile = new BlackListedMobile();
//cleaning time
$currentMobile = trim($currentMobile);
$currentMobile = rtrim($currentMobile);
$currentMobile = ltrim($currentMobile);
$newBlackListedmobile->mobile_number = $currentMobile;
$newBlackListedmobile->queue_id = $latestidle->queue_id;
//set queueid
if ($newBlackListedmobile->save()) {
//save content
echo "{$newBlackListedmobile->mobile_number} : Saved \n";
} else {
echo "{$newBlackListedmobile->mobile_number} : Failed \n";
}
}
//when done
//set status to done
$latestidle->status = JobQueue::$JOBQUEUE_STATUS_DONE;
$latestidle->date_done = date("Y-m-d H:i:s");
//set done datetime to now()
$latestidle->save();
echo "Queue DONE \n";
}
public function actionIndex()
{
$model = new BlackListedMobile('search');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['BlackListedMobile'])) {
$model->attributes = $_GET['BlackListedMobile'];
}
$this->render('list', array('model' => $model));
}
public function actionIndex()
{
if (isset($_GET['queue_id']) && !empty($_GET['queue_id'])) {
$criteria = new CDbCriteria();
$criteria->compare("queue_id", $_GET['queue_id']);
BlackListedMobile::model()->deleteAll($criteria);
Yii::app()->user->setFlash('error', '<strong><i class="fa fa-warning"></i> Black listed mobile numbers deleted!</strong>.Deleted mobile numbers can never be retrieved.');
$this->redirect(Yii::app()->request->baseUrl . "/blacklist/default");
}
}
public function actionIndex()
{
header("Content-Type: application/json");
$jsonMessage = array("status" => "error", "message" => "Incomplete parameter");
if (isset($_GET['mobileNumber']) && !empty($_GET['mobileNumber']) && !empty($_GET['ip_address'])) {
$mobilenumber1 = new BlackListedMobile('create');
$mobilenumber1->mobile_number = $_GET['mobileNumber'];
$mobilenumber1->origin = $_GET['origin'];
$mobilenumber1->ip_address = $_GET['ip_address'];
if ($mobilenumber1->save()) {
$vicidialReport = VicidialReportSend::send($mobilenumber1->mobile_number);
$jsonMessage = array("status" => "success", "message" => "Added to blacklisted", 'vicidialRemoteIncludeStatus' => $vicidialReport);
} else {
$jsonMessage = array("status" => "error", "message" => CHtml::errorSummary($mobilenumber1));
}
} else {
$jsonMessage = array("status" => "error", "message" => "Invalid mobile number");
}
echo json_encode($jsonMessage);
}
public function actionIndex($mobileNumber)
{
header("Content-Type: application/json");
$jsonMessage = array();
$mobileNumber = doubleval($mobileNumber);
$isBlackListed = BlackListedMobile::model()->exists("mobile_number = :mobile_number", array('mobile_number' => $mobileNumber));
if ($isBlackListed) {
$jsonMessage = array("status" => "blacklisted");
} else {
$jsonMessage = array("status" => "clean");
}
echo json_encode($jsonMessage);
}
public function send()
{
$httpParameters = array("source" => "dncadding", "user" => "apiuserwill", "pass" => "mentalapipassword", "function" => "add_mednc", "dnc_check" => "Y", "phone_number" => $this->getPhoneNumber());
$httpParameters = array_merge($httpParameters, $this->getAdditionalParameters());
$res = $this->sendToRemoteServer($httpParameters);
$jsonMessage['vici_res'] = $res;
$mdl = new BlackListedMobile();
$mdl->mobile_number = $this->getPhoneNumber();
$mdl->ip_address = $this->getIpAddress();
$mdl->origin = "public_url";
try {
if ($mdl->save(false)) {
$jsonMessage['dnc.website'] = "saving dnc.website saved";
} else {
$jsonMessage['dnc.website'] = "cant save to dnc.website";
$jsonMessage['dnc.website']['message'] = CHtml::errorSummary($mdl);
}
} catch (Exception $e) {
$jsonMessage['dnc.website'] = "fatal error";
$jsonMessage['dnc.website']['message'] = $e->getMessage();
}
return $jsonMessage;
}
public function actionIndex($count)
{
Yii::import("application.models.*");
echo "Preparing to seed blacklisted mobile . ";
$dates = array(date("Y-m-d H:i:s", strtotime("monday this week")), date("Y-m-d H:i:s", strtotime("tuesday this week")), date("Y-m-d H:i:s", strtotime("wednesday this week")), date("Y-m-d H:i:s", strtotime("thursday this week")), date("Y-m-d H:i:s", strtotime("friday this week")), date("Y-m-d H:i:s", strtotime("saturday this week")), date("Y-m-d H:i:s", strtotime("sunday this week")));
foreach ($dates as $value) {
foreach (range(0, $count) as $value1) {
$bl1 = new BlackListedMobile();
$bl1->mobile_number = sprintf("07%d", rand(111111111, 999999999));
$bl1->date_created = $value;
$bl1->ip_address = "127.0.0.1";
$bl1->origin = "test";
if ($bl1->save()) {
echo "New Mobile number saved:{$value1}" . PHP_EOL;
} else {
echo "Failed to create new blacklisted mobile" . PHP_EOL;
echo CHtml::errorSummary($bl1) . PHP_EOL;
echo $bl1->mobile_number;
die;
}
}
}
}
public function download()
{
$fileName = $this->model->claimAccountName . ' - ' . date("Y-m-d") . '-All-entries';
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private", false);
header("Content-Type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"{$fileName}.csv\";");
header("Content-Transfer-Encoding: binary");
$criteria = new CDbCriteria();
$criteria->compare("account_id", $this->model->account_id);
$criteria->order = "date_created DESC";
$criteria->distinct = true;
$records = Records::model()->findAll($criteria);
$isFirst = true;
foreach ($records as $curRecord) {
$data = json_decode($curRecord->claimData, true);
$rowData = "";
$allowPrint = true;
if ($isFirst) {
//print heads
$headers = "";
$keys = array_keys($data);
$headers = implode(",", $keys) . "\n";
echo $headers;
$isFirst = false;
}
/*check if mobile number exists at blacklist mobile nums*/
$mobileNumMatch = preg_grep('/0?7\\d{9}/', $data);
if (count($mobileNumMatch) > 0) {
$mobileNumContainer = array_values($mobileNumMatch)[0];
$criteria = new CDbCriteria();
$criteria->compare('mobile_number', $mobileNumContainer);
$allowPrint = !BlackListedMobile::model()->exists($criteria);
}
if ($allowPrint) {
foreach ($data as $curRowData) {
$rowData = $rowData . "\"{$curRowData}\",";
}
}
$rowData = str_replace(chr(194), " ", $rowData);
//prepare data
if ($allowPrint) {
echo $rowData . "\n";
}
}
}
public static function extractMultiDimensional($rawMulti)
{
$resultArr = array();
foreach ($rawMulti as $currentMulti) {
if (isset($currentMulti['claimData'])) {
$currentMulti = json_decode($currentMulti['claimData'], true);
$tempContainer = array_values($currentMulti);
$mobileNumContainer = MobileNumberExtractor::extractMobileNumbers($tempContainer);
/*check if present in table blacklist*/
$criteria = new CDbCriteria();
$criteria->compare("mobile_number", $mobileNumContainer);
if (!BlackListedMobile::model()->exists($criteria)) {
$resultArr[] = $mobileNumContainer;
}
}
}
return $resultArr;
}
public function actionIndex()
{
set_time_limit(10 * 60);
// 10 minutes
Yii::import("application.models.*");
$totalCount = BlackListedMobile::model()->count();
$offset = 0;
while ($totalCount >= $offset) {
$criteria = new CDbCriteria();
$criteria->offset = $offset;
$criteria->addCondition('trim(mobile_number) NOT REGEXP \'^0?7[0-9]{9}$\'');
$currentModel = BlackListedMobile::model()->find($criteria);
echo "Evaluating {$currentModel->mobile_number} \n";
$currentModel->mobile_number = trim($currentModel->mobile_number);
if (!preg_match('/^0?7\\d{9}$/', $currentModel->mobile_number)) {
echo "invalid mobile number : deleting {$currentModel->mobile_number} \n";
$currentModel->delete();
}
$offset++;
}
}
public function actionIndex()
{
$fileName = 'blacklisted-mobile-add' . date("Y-m-d");
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private", false);
header("Content-Type: text/plain");
header("Content-Disposition: attachment; filename=\"{$fileName}.txt\";");
header("Content-Transfer-Encoding: binary");
$allBlackLIstedMObilecount = BlackListedMobile::model()->count();
$offset = 0;
$limit = 50000;
do {
$results = Yii::app()->db->createCommand("select mobile_number from black_listed_mobile LIMIT {$limit} OFFSET {$offset}")->queryAll();
foreach ($results as $value) {
echo $value['mobile_number'] . PHP_EOL;
}
$offset = $offset + $limit;
} while ($offset <= $allBlackLIstedMObilecount);
die;
}
public function actionExportAll()
{
$fileName = 'All-blacklisted-records';
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private", false);
header("Content-Type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"{$fileName}.csv\";");
header("Content-Transfer-Encoding: binary");
$criteria1 = new CDbCriteria();
$criteria1->group = "mobile_number";
$totalCount = BlackListedMobile::model()->count($criteria1);
$offset = 0;
$limit = 5000;
do {
$criteria = new CDbCriteria();
$criteria->offset = $offset;
$criteria->limit = $limit;
$models = BlackListedMobile::model()->findAll($criteria);
foreach ($models as $currentModel) {
echo $currentModel->mobile_number . PHP_EOL;
}
$offset = $offset + $limit;
} while ($totalCount > $offset);
}
public function actionMobile()
{
if (isset($_REQUEST['accountID'])) {
$accountMdl = Accounts::model()->findByPk($_REQUEST['accountID']);
$fileName = $accountMdl->claimAccountName . ' - ' . date("Y-m-d") . '-all-mobilenumbers';
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private", false);
header("Content-Type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"{$fileName}.csv\";");
header("Content-Transfer-Encoding: binary");
$criteria = new CDbCriteria();
$criteria->compare("account_id", $_REQUEST['accountID']);
$criteria->order = "date_created DESC";
$records = Records::model()->findAll($criteria);
$isFirst = true;
foreach ($records as $curRecord) {
$data = json_decode($curRecord->claimData, true);
if ($isFirst) {
//print heads
echo "Mobile Number\n";
$isFirst = false;
}
//retrieve mobile number
$arrayVals = array_values($data);
$extractedMobile = MobileNumberExtractor::extractMobileNumbers($arrayVals);
if ($extractedMobile != false) {
/* check if present at blacklist*/
$crt = new CDbCriteria();
$crt->compare('mobile_number', $extractedMobile);
if (!BlackListedMobile::model()->exists($crt)) {
echo $extractedMobile . PHP_EOL;
}
}
}
} else {
throw new CHttpException(404, "Yikes , You forgot to pass in the Account ID");
}
}
<?php
/* @var $this DefaultController */
$this->breadcrumbs = array($this->module->id);
$criteria2 = new CDbCriteria();
$criteria2->compare("origin", "client");
$counttot = BlackListedMobile::model()->count($criteria2);
$label = "<span class=\"badge badge-info pull-right\">{$counttot}</span>";
$this->menu = array(array('label' => 'Mobile Opted from Client ' . $label, 'url' => Yii::app()->getBaseUrl(true) . "/whitelist/default"));
?>
<style type="text/css">
.list-view div.view {
border: none;
border-top: solid 1px #DDDDDD;
border-bottom: solid 1px #DDDDDD;
}
</style>
<h1>
Opt out mobile number <br>
<small>List of mobile numbers who opted out coming from client source.</small>
</h1>
<?php
$this->widget('zii.widgets.CListView', array('id' => "listviewData", 'dataProvider' => $dataProvider, 'itemView' => '_view'));
}
$mondayDt = date("Y-m-d H:i:s", strtotime("monday this week"));
$tuesdayDt = date("Y-m-d H:i:s", strtotime("tuesday this week"));
$wednesdayDt = date("Y-m-d H:i:s", strtotime("wednesday this week"));
$thursdayDt = date("Y-m-d H:i:s", strtotime("thursday this week"));
$fridayDt = date("Y-m-d H:i:s", strtotime("friday this week"));
$saturdayDt = date("Y-m-d H:i:s", strtotime("saturday this week"));
$sundayDt = date("Y-m-d H:i:s", strtotime("sunday this week"));
/* Week count */
$mondayCount = BlackListedMobile::getSubmittedBlackListedMobileCount($mondayDt);
$tuesdayCount = BlackListedMobile::getSubmittedBlackListedMobileCount($tuesdayDt);
$wednesdayCount = BlackListedMobile::getSubmittedBlackListedMobileCount($wednesdayDt);
$thursdayCount = BlackListedMobile::getSubmittedBlackListedMobileCount($thursdayDt);
$fridayCount = BlackListedMobile::getSubmittedBlackListedMobileCount($fridayDt);
$saturdayCount = BlackListedMobile::getSubmittedBlackListedMobileCount($saturdayDt);
$sundayCount = BlackListedMobile::getSubmittedBlackListedMobileCount($sundayDt);
$totalBlackListedCount = 0;
$totalBlackListedCount += intval($mondayCount);
$totalBlackListedCount += intval($tuesdayCount);
$totalBlackListedCount += intval($wednesdayCount);
$totalBlackListedCount += intval($thursdayCount);
$totalBlackListedCount += intval($fridayCount);
$totalBlackListedCount += intval($saturdayCount);
$totalBlackListedCount += intval($sundayCount);
?>
<style type="text/css">
.total-black-listed-count-label {
border-radius: 5px;
text-align: center;
background-color: #f3f3f3;
-moz-box-shadow: 0 0 6px 2px #b0b2ab;
public function actionIndex()
{
$uploadedFile = CUploadedFile::getInstanceByName("blackListedFile");
if (isset($_GET['downloadSampleFile'])) {
$headers = array("Mobilephone");
$contents = array(array("447123456789"), array("447123456455"), array("447123456321"));
$tempFile = new SplTempFileObject();
$tempFile->fputcsv($headers);
foreach ($contents as $currentLine) {
$tempFile->fputcsv($currentLine);
}
$tempFile->rewind();
header("Content-type: text/csv");
header("Content-Disposition: attachment; filename=SampleFile.csv");
header("Pragma: no-cache");
header("Expires: 0");
$tempFile->fpassthru();
die;
}
if (isset($_POST['singleBlackList']) && !empty($_POST['singleBlackList'])) {
$newMobileNum = new BlackListedMobile();
$newMobileNum->mobile_number = $_POST['singleBlackList'];
$newMobileNum->queue_id = 1;
if ($newMobileNum->save()) {
Yii::app()->user->setFlash('success', '<strong>New blacklist mobile numberSaved!</strong>');
} else {
Yii::app()->user->setFlash('error', '<strong>Error!</strong>' . CHtml::errorSummary($newMobileNum));
}
}
if (isset($_POST['massiveTextArea']) && !empty($_POST['massiveTextArea'])) {
/*@TODO get total now , using randomQueue */
$queueName = $_POST['randomQueue'] ? $_POST['randomQueue'] : 'Task : upload - ' . rand(0, 9999);
$criteriaJobQueue = new CDbCriteria();
$criteriaJobQueue->compare("queue_name", $queueName);
$jobQueueModl = JobQueue::model()->find($criteriaJobQueue);
/*@TODO $total_before*/
$total_before = 0;
if (!$jobQueueModl) {
$jobQueueModl = new JobQueue();
//@TODO declare above ,
$jobQueueModl->queue_name = $queueName;
$jobQueueModl->save(false);
//pre save
} else {
$criteriaTotalBefore = new CDbCriteria();
$criteriaTotalBefore->compare("queue_id", $jobQueueModl->queue_id);
$total_before = BlackListedMobile::model()->count($criteriaTotalBefore);
}
/*write posted textarea to file*/
$tp = tempnam(Yii::getPathOfAlias('application.data'), "tempWrite");
$tempName = $tp . '.csv';
$linecount = 0;
$tempContainer2 = explode("\n", $_POST['massiveTextArea']);
$tempContainer2 = array_filter($tempContainer2);
$linecount = count($tempContainer2);
file_put_contents($tempName, implode(PHP_EOL, $tempContainer2));
// $handle = fopen($tempName, "r");
// while(!feof($handle)){
// $line = fgets($handle);
// ++$linecount;
// }
// fclose($handle);
$jobQueueModl->filename = $tempName;
//ignore this
$jobQueueModl->status = JobQueue::$JOBQUEUE_STATUS_PRELOADED;
/*check number files' number of line*/
// Total_records ,
$jobQueueModl->total_records = $linecount;
$jobQueueModl->processed_record = $linecount;
/*update job queue record*/
if ($jobQueueModl->save()) {
$filePath = $tempName;
/*load to database*/
$tempFile2 = tempnam(__DIR__, "tempContainer");
$appendCommand = sprintf('cat "%s" | gawk \'{print $0",0%s"}\' > "%s" ', $filePath, $jobQueueModl->queue_id, $tempFile2);
system($appendCommand);
system("mv \"{$tempFile2}\" \"{$filePath}\"");
$sqlCommand = <<<EOL
LOAD DATA LOCAL INFILE "%s"
INTO TABLE black_listed_mobile
FIELDS TERMINATED BY "%s"
LINES TERMINATED BY "%s"
IGNORE 0 LINES
(mobile_number,queue_id)
EOL;
$sqlCommand = sprintf($sqlCommand, $filePath, ',', '\\n');
$mainCommand = "mysql --user=dncsyste_dnc --password=hitman052529 --database=dncsyste_dnc -e '{$sqlCommand}'";
exec($mainCommand);
$criteriaTotalBefore = new CDbCriteria();
$criteriaTotalBefore->compare("queue_id", $jobQueueModl->queue_id);
/* $total_now*/
$total_now = BlackListedMobile::model()->count($criteriaTotalBefore);
if (Yii::app()->request->isAjaxRequest) {
header("Content-Type: application/json");
$numOfInsertedData = $total_now - $total_before;
$numOfInsertedData = $numOfInsertedData <= 0 ? 0 : $numOfInsertedData;
$numOfDeletedData = $linecount - ($total_now - $total_before);
$numOfDeletedData = $numOfDeletedData <= 0 ? 0 : $numOfDeletedData;
$jsonResult = array("numOfInsertedData" => $numOfInsertedData, "numOfDeletedData" => $numOfDeletedData);
echo json_encode($jsonResult);
die;
} else {
Yii::app()->user->setFlash('success', '<strong>File Imported!</strong>You have successfully imported new blacklisted mobile number. ');
}
} else {
Yii::app()->user->setFlash('error', CHtml::errorSummary($newQueueFile));
}
}
if ($uploadedFile) {
set_time_limit(0);
$newFileLocation = Yii::getPathOfAlias("application.uploaded_files") . DIRECTORY_SEPARATOR . rand(0, 9999) . '-' . $uploadedFile->name;
//save new queue file
$newQueueFile = new JobQueue();
$uploadedFile->saveAs($newFileLocation);
$newQueueFile->queue_name = "Task : " . $uploadedFile->name . ' - ' . rand(0, 9999);
$newQueueFile->filename = $newFileLocation;
$newQueueFile->status = JobQueue::$JOBQUEUE_STATUS_PRELOADED;
/*check number files' number of line*/
$linesTotal = 0;
$handle = fopen($newQueueFile->filename, "r");
while (!feof($handle)) {
$line = fgets($handle);
++$linesTotal;
}
fclose($handle);
$newQueueFile->total_records = $linesTotal;
$newQueueFile->processed_record = $linesTotal;
if ($newQueueFile->save()) {
$filePath = $newQueueFile->filename;
$tempFile2 = tempnam(__DIR__, "tempContainer");
$appendCommand = sprintf('gawk \'{print $0",0%s"}\' "%s" > "%s"', $newQueueFile->queue_id, $filePath, $tempFile2);
system($appendCommand);
system("mv \"{$tempFile2}\" \"{$filePath}\"");
/*append queue identification for blacklist*/
$rawContents = file_get_contents($filePath);
// print_r( explode("\n",$rawContents) );
// die();
$sqlCommand = <<<EOL
LOAD DATA LOCAL INFILE "%s"
INTO TABLE black_listed_mobile
FIELDS TERMINATED BY "%s"
LINES TERMINATED BY "%s"
IGNORE 0 LINES
(mobile_number,queue_id)
EOL;
$sqlCommand = sprintf($sqlCommand, $filePath, ',', '\\n');
$mainCommand = "mysql --user=dncsyste_dnc --password=hitman052529 --database=dncsyste_dnc -e '{$sqlCommand}'";
exec($mainCommand);
$undoLink = "<a href='" . Yii::app()->getBaseUrl(true) . "/blacklist/delete?queue_id={$newQueueFile->queue_id}' onClick='return confirm(\"Are you sure you want to delete this ?\")'> Undo Action </a>";
Yii::app()->user->setFlash('success', '<strong>File Imported!</strong>You have successfully imported new blacklisted mobile number. ' . $undoLink);
} else {
Yii::app()->user->setFlash('error', CHtml::errorSummary($newQueueFile));
}
}
$this->render('index');
}
<?php
$totalDncRecords = BlackListedMobile::model()->count();
?>
<div class="navbar navbar-inverse navbar-fixed-top">
<div class="navbar-inner">
<div class="container">
<a class="btn btn-navbar" data-toggle="collapse" data-target=".nav-collapse">
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</a>
<!-- Be sure to leave the brand out there if you want it shown -->
<a class="brand" href="/"><?php
echo Yii::app()->name;
?>
</a>
<div class="nav-collapse">
<?php
$this->widget('zii.widgets.CMenu', array('htmlOptions' => array('class' => 'pull-right nav'), 'submenuHtmlOptions' => array('class' => 'dropdown-menu'), 'itemCssClass' => 'item-test', 'encodeLabel' => false, 'items' => array(array('label' => 'Dashboard', 'url' => array('/site/index'), 'visible' => Yii::app()->user->getId() === 'administrator'), array('label' => 'DNC Records ' . '<span class="label label-info">' . $totalDncRecords . '</span>', 'url' => array('/blackListedMobile/admin'), 'visible' => Yii::app()->user->getId() === 'administrator'), array('label' => 'Client Portal', 'url' => array('/client_portal/default'), 'visible' => !Yii::app()->user->isGuest), array('label' => 'De-dup Records ' . '<span class="label label-success">' . WhitelistJobQueue::model()->count() . '</span>', 'url' => array('/de-dupe'), 'visible' => Yii::app()->user->getId() === 'administrator'), array('label' => 'IP Firewall', 'url' => "http://ip.dncsystem.website/", 'visible' => Yii::app()->user->getId() === 'administrator'), array('label' => 'Message board', 'url' => array('/messageBoard/updateStatus'), 'visible' => Yii::app()->user->getId() === 'administrator'), array('label' => 'Login', 'url' => array('/site/login'), 'visible' => Yii::app()->user->isGuest), array('label' => 'Logout (' . Yii::app()->user->name . ')', 'url' => array('/site/logout'), 'visible' => !Yii::app()->user->isGuest))));
?>
</div>
</div>
</div>
</div>
<div class="subnav navbar navbar-fixed-top">
<div class="navbar-inner">
<div class="container">
<?php
/* @var $this DefaultController */
/* @var $model JobQueue */
$model = JobQueue::model();
$model->unsetAttributes();
$this->breadcrumbs = array($this->module->id);
$this->breadcrumbs = array(ucwords($this->module->id), 'Job Queues');
$this->menu = array(array('label' => 'View Uploaded DNC Files', 'url' => array('/dnc')), array('label' => 'List Blacklisted Mobilenumbers <span class="label label-info pull-right">' . number_format(BlackListedMobile::getTotalBlacklistedCount()) . '</span>', 'url' => array('/blacklist/list')));
$dataprovider = $model->search();
$dataprovider->pagination = false;
Yii::app()->user->setFlash('sideBarEtc', $this->renderPartial('sideBar', null, true));
/*register submit event listener*/
$registerSubmitListener = <<<EOL
jQuery("form:first").submit(function(event) {
if ( \$("#massiveTextArea").val().length > 0 ) {
submitPartition()
event.preventDefault();
return false;
}
});
EOL;
Yii::app()->clientScript->registerScript('registerSubmitListener', $registerSubmitListener, CClientScript::POS_READY);
/*end of register submit*/
/*begin partition upload of from texterea*/
$partitionUploadCode = <<<EOL
var tempTotalInsertedContainer = 0;
var tempTotalDuplicateFound = 0;
/**
* Todo attach this before submit . make sure to change submit text
* @return
public function actionIndex()
{
$dncFile = CUploadedFile::getInstanceByName("dncFile");
if (isset($_POST['manualCheck']) && !empty($_POST['manualCheck'])) {
//write the massive input to a csv file . process it like a whitelistjobqueue
$criteria = new CDbCriteria();
$criteria->compare("mobile_number", $_POST['manualCheck']);
// $criteria->addSearchCondition("mobile_number", $_POST['manualCheck']);
$mobileIsWhiteListed = BlackListedMobile::model()->exists($criteria);
if ($mobileIsWhiteListed) {
Yii::app()->user->setFlash('error', '<strong>Mobile Number opted out!</strong> The mobile number opted out before.');
} else {
Yii::app()->user->setFlash('success', '<strong>Mobile Number is Clean!</strong> The mobile number has not been opted yet.');
}
} else {
if (isset($_POST['massiveTextArea'])) {
//write the posted manual file to a CSV file
$tempName = tempnam(Yii::getPathOfAlias('application.tempWrite'), "tempWrite");
$tempName = $tempName . '.csv';
$mobileNumsArr = explode("\n", $_POST['massiveTextArea']);
$mobileNumsArr = array_filter($mobileNumsArr);
//
$tempNumsContainer = implode("\n", $mobileNumsArr);
file_put_contents($tempName, $tempNumsContainer);
$linecount = count($mobileNumsArr);
$criteria = new CDbCriteria();
$criteria->compare("queue_name", $_POST['copyPasteFileName']);
$whiteListjob = WhitelistJobQueue::model()->find($criteria);
if (!$whiteListjob) {
$whiteListjob = new WhitelistJobQueue();
$whiteListjob->filename = $tempName;
if (isset($_POST['copyPasteFileName'])) {
$whiteListjob->queue_name = $_POST['copyPasteFileName'];
} else {
$whiteListjob->queue_name = 'Uploaded-' . date("Y.m.d.H.i.s");
}
}
$whiteListjob->status = WhitelistJobQueue::$JOBQUEUE_STATUS_IDLE;
//Add scan total
$whiteListjob->total_records = intval($whiteListjob->total_records) + intval($linecount);
$whiteListjob->processed_record = intval($whiteListjob->processed_record) + $linecount;
$whiteListjob->status = WhitelistJobQueue::$JOBQUEUE_STATUS_DONE;
//status to done
if ($whiteListjob->save()) {
//insert queueid sa file firstColumn,
$tempDump = tempnam(sys_get_temp_dir(), "temp");
$insertQueueidColCommand = "gawk '{print \"{$whiteListjob->queue_id},0\"\$0}' {$tempName} > {$tempDump}";
exec($insertQueueidColCommand);
exec("mv \"{$tempDump}\" \"{$tempName}\" ");
//insert the whitelisted data to database;
$filePath = $tempName;
$sqlCommand = <<<EOL
LOAD DATA LOCAL INFILE "%s"
INTO TABLE white_listed_mobile
FIELDS TERMINATED BY "%s"
LINES TERMINATED BY "%s"
IGNORE 0 LINES
(queue_id,mobile_number)
EOL;
$sqlCommand = sprintf($sqlCommand, $filePath, ',', '\\n');
$mainCommand = "mysql --user=dncsyste_dnc --password=hitman052529 --database=dncsyste_dnc -e '{$sqlCommand}'";
exec($mainCommand);
$referenceLink = Yii::app()->getBaseUrl(true) . "/dnc/" . $whiteListjob->queue_id;
Yii::app()->user->setFlash('success', '<strong>File Uploaded!</strong> Please click the link to download your cleaned mobile numbers . ' . CHtml::link('Reference Link', $referenceLink));
} else {
Yii::app()->user->setFlash('error', CHtml::errorSummary($whiteListjob));
}
} else {
if ($dncFile) {
$newFileLocation = Yii::getPathOfAlias("application.uploaded_files") . DIRECTORY_SEPARATOR . uniqid();
$whileListjob = new WhitelistJobQueue();
$dncFile->saveAs($newFileLocation);
$whileListjob->queue_name = $dncFile->name;
$whileListjob->filename = $newFileLocation;
$whileListjob->status = WhitelistJobQueue::$JOBQUEUE_STATUS_IDLE;
//add scan total
$queueFile = new SplFileObject($whileListjob->filename);
//read file
$queueFile->setFlags(SplFileObject::READ_CSV | SplFileObject::READ_AHEAD | SplFileObject::DROP_NEW_LINE | SplFileObject::SKIP_EMPTY);
$queueFile->seek(PHP_INT_MAX);
$linesTotal = $queueFile->key();
$whileListjob->total_records = $linesTotal;
$whileListjob->processed_record = $linesTotal;
$whileListjob->status = WhitelistJobQueue::$JOBQUEUE_STATUS_DONE;
//status to done
if ($whileListjob->save()) {
//insert queueid sa file firstColumn,
$tempDump = tempnam(sys_get_temp_dir(), "temp");
exec("head -1500000 {$newFileLocation} > {$tempDump}");
//cut first 1m 500 k
exec("gawk '{print \"{$whileListjob->queue_id},0\"\$0}' {$tempDump} > {$newFileLocation}");
//insert queueid
$queueFile = null;
$queueFile = new SplFileObject($newFileLocation);
//read file
$queueFile->seek(PHP_INT_MAX);
$linesTotal = $queueFile->key();
$whileListjob->filename = $newFileLocation;
$whileListjob->total_records = $linesTotal;
$whileListjob->processed_record = $linesTotal;
$whileListjob->save();
$sqlCommand = <<<EOL
LOAD DATA LOCAL INFILE "%s"
INTO TABLE white_listed_mobile
FIELDS TERMINATED BY "%s"
LINES TERMINATED BY "%s"
IGNORE 0 LINES
(queue_id,mobile_number)
EOL;
$sqlCommand = sprintf($sqlCommand, $newFileLocation, ',', '\\n');
$mainCommand = "mysql --user=dncsyste_dnc --password=hitman052529 --database=dncsyste_dnc -e '{$sqlCommand}'";
$result = exec($mainCommand);
//unlink($tempDump);
$referenceLink = Yii::app()->getBaseUrl(true) . "/dnc/" . $whileListjob->queue_id;
Yii::app()->user->setFlash('success', '<strong>File Uploaded!</strong> Please click the link to download your cleaned mobile numbers . ' . CHtml::link('Reference Link', $referenceLink));
} else {
Yii::app()->user->setFlash('error', CHtml::errorSummary($whileListjob));
}
}
}
}
Yii::app()->user->setFlash('info', '<strong><i class="fa fa-info-circle"></i></strong> Please use the following format : 07#########.');
$this->render('index');
}
public function actionIndex()
{
Yii::import("application.models.*");
//get a queued file
$criteria = new CDbCriteria();
$criteria->addInCondition("status", array("IDLE", "REQUEUE"));
/* @var $currentQueue WhitelistJobQueue*/
$currentQueue = WhitelistJobQueue::model()->find($criteria);
//if no queued file die()
if (!$currentQueue) {
echo "No files in queue";
die;
}
// else continue as usuall
$currentQueue->status = WhitelistJobQueue::$JOBQUEUE_STATUS_ON_GOING;
$currentQueue->save(false);
//get contents
$currentCsvFile = new SplFileObject($currentQueue->filename);
$currentCsvFile->setFlags(SplFileObject::READ_CSV | SplFileObject::READ_AHEAD | SplFileObject::DROP_NEW_LINE | SplFileObject::SKIP_EMPTY);
//get total number of lines
$currentCsvFile->seek(PHP_INT_MAX);
$linesTotal = $currentCsvFile->key();
$currentQueue->total_records = $linesTotal;
$currentQueue->save(false);
$currentCsvFile->rewind();
$currentCsvFile->next();
//foreach content , lookup in the blacklist record
$index = 0;
foreach ($currentCsvFile as $content) {
if ($currentCsvFile->key() === 0) {
continue;
}
$currentQueue->processed_record = ++$index;
$currentQueue->save(false);
$currentMobileNumber = $content[0];
$curMobileObj = new WhiteListedMobile();
//cleaning time
$currentMobileNumber = trim($currentMobileNumber);
$currentMobileNumber = rtrim($currentMobileNumber);
$currentMobileNumber = ltrim($currentMobileNumber);
$curMobileObj->mobile_number = $currentMobileNumber;
$curMobileObj->queue_id = $currentQueue->queue_id;
$criteria2 = new CDbCriteria();
$criteria2->addSearchCondition("mobile_number", $currentMobileNumber);
$isOpted = BlackListedMobile::model()->exists($criteria2);
//if opted , set status error
if ($isOpted) {
$curMobileObj->status = WhiteListedMobile::$WHITELISTEDMOBILE_STATUS_ERROR;
} else {
//else status ok
$curMobileObj->status = WhiteListedMobile::$WHITELISTEDMOBILE_STATUS_OK;
}
$curMobileObj->save();
echo "{$curMobileObj->mobile_number} : {$curMobileObj->status} \n";
}
//done
$currentQueue->status = WhitelistJobQueue::$JOBQUEUE_STATUS_DONE;
$currentQueue->date_done = date("Y-m-d H:i:s");
//set done datetime to now()
$currentQueue->save();
}
public function download()
{
$fileName = $this->model->claimAccountName . ' - ' . date("Y-m-d") . '-All-entries';
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private", false);
header("Content-Type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"{$fileName}.csv\";");
header("Content-Transfer-Encoding: binary");
// $criteria = new CDbCriteria();
// $criteria->compare("account_id",$this->model->account_id );
// $criteria->order = "date_created DESC";
// $criteria->distinct = true;
// $records = Records::model()->findAll($criteria);
$records = $this->retrieveDataRecords();
$isFirst = true;
$tempfile = tempnam(sys_get_temp_dir(), "tempDownload");
$filehandle = fopen($tempfile, "r+");
foreach ($records as $curRecord) {
$data = json_decode($curRecord->claimData, true);
$firstname = "";
if (isset($data['First name'])) {
$firstname = $data['First name'];
} else {
if (isset($data['First Name'])) {
$firstname = @$data['First Name'];
} else {
if (isset($data['Firstname'])) {
$firstname = @$data['Firstname'];
}
}
}
$otherPassengerNames = "";
if (isset($data['Other Passenger name'])) {
$otherPassengerNames = $data['Other Passenger name'];
} else {
if (isset($data['Other Passenger'])) {
$otherPassengerNames = $data['Other Passenger'];
} else {
if (isset($data['Other Passenger Name'])) {
$otherPassengerNames = $data['Other Passenger Name'];
}
}
}
$emailAddress = "";
if (isset($data['Email'])) {
$emailAddress = $data['Email'];
} else {
if (isset($data['email'])) {
$emailAddress = $data['email'];
}
}
$airline = "";
if (isset($data["Airline"])) {
$airline = $data["Airline"];
}
$address1 = "";
if (isset($data['address1'])) {
$address1 = $data['address1'];
}
$reasonForDelay = "";
if (isset($data['Reason of delay'])) {
$reasonForDelay = $data['Reason of delay'];
} else {
if (isset($data['Reason for Delay'])) {
$reasonForDelay = $data['Reason for Delay'];
}
}
$mobileNumber = "";
if (isset($data['Mobile No.'])) {
$mobileNumber = $_data['Mobile No.'];
} else {
if (isset($data['Mobile Number'])) {
$mobileNumber = $data['Mobile Number'];
}
}
$flightDate = "";
if (isset($data["Flight Date"])) {
$flightDate = $data["Flight Date"];
} else {
if (isset($data["Flight date"])) {
$flightDate = $data["Flight Date"];
}
}
$reArrangedData = array($data['Date Submitted'], $data['Title'], $firstname, $data['Surname'], intval($data['address1']), $data['address1'], $data['address2'], $data['city'], $data['zip'], $data['Date of Birth'], $emailAddress, $mobileNumber, OtherPassengerUtility::computeTotalNumOfPassenger($otherPassengerNames), OtherPassengerUtility::getAdditionalPassengerNames($otherPassengerNames), OtherPassengerUtility::getAdditionalPassengerEmails($otherPassengerNames), $data['Hours'], $data['Minutes'], $data["Flight Number"], $flightDate, $airline, $data["Departure Airport"], $data["Arrival Airport"], $data["Actual Arrival"], $data["Actual Departure"], $data["Flight Distance"], $data["Scheduled Arrival"], $data["Scheduled Departure"], $data["Flight Status (km)"], $reasonForDelay);
$rowData = "";
$allowPrint = true;
if ($isFirst) {
//print heads
$headers = "";
$keys = array("Date Submitted", "Title", "First Name", "Surname", "House Number/Name", "Address 1", "Address 2", "Town/City", "Postcode", "DOB", "Email", "Mobile Number", "Total Number Passengers", "Additional Passenger Names", "Additional Passenger Emails", "Length of Delay (Hours)", "Length of Delay (Minutes)", "Flight Number", "Flight Date", "Airline", "Departure Airport", "Arrival Airport", "Actual Arrival Date/Time", "Actual Departure Date/Time", "Flight Distance", "Scheduled Arrival Date/Time", "Scheduled Departure Date/Time", "Delayed/Cancelled", "Reason For Failure");
$headers = implode(",", $keys) . "\n";
echo $headers;
$isFirst = false;
}
/*check if mobile number exists at blacklist mobile nums*/
$mobileNumMatch = preg_grep('/0?7\\d{9}/', $reArrangedData);
if (count($mobileNumMatch) > 0) {
$mobileNumContainer = array_values($mobileNumMatch)[0];
$criteria = new CDbCriteria();
$criteria->compare('mobile_number', $mobileNumContainer);
$allowPrint = !BlackListedMobile::model()->exists($criteria);
}
if ($allowPrint) {
$tempVals = array_values($reArrangedData);
if ($this->model->account_id == 4 && !empty($tempVals[1]) && !empty($tempVals[2])) {
/*check if title , firstname and lastname contains data*/
fputcsv($filehandle, $reArrangedData);
}
if ($this->model->account_id != 4) {
fputcsv($filehandle, $reArrangedData);
}
}
}
rewind($filehandle);
fpassthru($filehandle);
unlink($tempfile);
die;
}
