PageRenderTime 63ms CodeModel.GetById 22ms RepoModel.GetById 0ms app.codeStats 1ms

/lms_debug/protected/controllers/RenewalLeadsController.php

https://gitlab.com/badelal143/lms_debug
PHP | 3611 lines | 3049 code | 299 blank | 263 comment | 560 complexity | 2bebe98a0f5f801890c00759cb62a91b MD5 | raw file
Possible License(s): LGPL-2.1, LGPL-3.0, LGPL-2.0

Large files files are truncated, but you can click here to view the full file

    

  1. <?php

    2. 

  2. class RenewalLeadsController extends Controller

    3. 

  3. {

    4. 

  4.   const SHARED_TITLE = "Admin Panel";

    5. 

  5. 	/**

    6. 

  6. 	 * Declares class-based actions.

    7. 

  7. 	 */

    8. 

  8. 	 public function filters()

    9. 

  9. 		{

    10. 

  10. 			return array( 'accessControl',array(

    11. 

  11.            'CHttpCacheFilter + view',

    12. 

  12.            'cacheControl' => " max-age=604800, must-revalidate",

    13. 

  13.           ) ); // perform access control for CRUD operations

    14. 

  14. 		}

    15. 

  15. 	public function actions()

    16. 

  16. 	{ 

    17. 

  17. 		return array(

    18. 

  18. 			// captcha action renders the CAPTCHA image displayed on the contact page 

    19. 

  19. 			'captcha'=>

    20. 

  20. array(

    21. 

  21. 				'class'=>'CCaptchaAction',

    22. 

  22. 				'backColor'=>0xFFFFFF,

    23. 

  23. 			),

    24. 

  24. 			// page action renders "static" pages stored under 'protected/views/site/pages'

    25. 

  25. 			// They can be accessed via: index.php?r=site/page&view=FileName

    26. 

  26. 			'page'=>array(

    27. 

  27. 				'class'=>'CViewAction',

    28. 

  28. 			),

    29. 

  29. 		);

    30. 

  30. 	}

    31. 

  31. 	/**

    32. 

  32. 	 * This is the 'roles' action that is invoked

    33. 

  33. 	 * when an action is not explicitly requested by users.

    34. 

  34. 	 */

    35. 

  35. 	public function actionlead_welcome()

    36. 

  36. 	{

    37. 

  37. 		$model	=	new WelcomeMaster();

    38. 

  38. 		$model	=	WelcomeMaster::model()->find("moduleId = '1' ");

    39. 

  39. 		$this->render('lead_welcome',array('model'=>$model));	

    40. 

  40. 	}

    41. 

  41. 	/**

    42. 

  42. 	 * This is the 'roles' action that is invoked

    43. 

  43. 	 * when an action is not explicitly requested by users.

    44. 

  44. 	 */

    45. 

  45. 	public function actionrenlead_list()

    46. 

  46. 	{

    47. 

  47. 	$relationManager = @$_SESSION['relationalManager'];

    48. 

  48. 	$managerMemberId = implode(",",array_unique(@$relationManager));

    49. 

  49. 

    50. 

  50. 		if(@$_SESSION['isAllocator']=='yes' or Yii::app()->session->get('type')=='superadmin') { 

    51. 

  51. 			$querycondition = " leadStatusId = '35' AND currentAllocatedId > 0 AND isRead='no' ";

    52. 

  52. 		} else {

    53. 

  53. 			$querycondition = " leadStatusId = '35' AND currentAllocatedId > 0 AND isRead='no' AND currentAllocatedId IN (".@$managerMemberId.") ";

    54. 

  54. 		}

    55. 

  55. 		//$modelLead	=	Lead::model()->findAll("  $querycondition ");	

    56. 

  56. 				$modelRenLead = new Renewallead();	

    57. 

  57. 		

    58. 

  58. 

    59. 

  59. 		$this->render('lead_list',array('modelRenLead'=>@$modelRenLead));

    60. 

  60. 	}

    61. 

  61. 	

    62. 

  62. 	/**

    63. 

  63. 	 * This is the 'lead_list_allocator' action that is invoked

    64. 

  64. 	 * when an action is not explicitly requested by users.

    65. 

  65. 	 */

    66. 

  66. 	public function actionlead_list_allocator()

    67. 

  67. 	{

    68. 

  68. 		// renders the view file 'protected/views/site/index.php'

    69. 

  69. 		// using the default layout 'protected/views/layouts/main.php'

    70. 

  70. 		$this->render('lead_list_allocator');

    71. 

  71. 	}

    72. 

  72. 	/**

    73. 

  73. 	 * This is the 'lead_list_allocator' action that is invoked

    74. 

  74. 	 * when an action is not explicitly requested by users.

    75. 

  75. 	 */

    76. 

  76. 	public function actionrenfollowup_lead_list()

    77. 

  77. 	{

    78. 

  78. 		$today12PM			= mktime(0,0,0,date("m"),date("d"),date("Y"));

    79. 

  79. 		$relationManager = $_SESSION['relationalManager'];

    80. 

  80. 		$managerMemberId = implode(",",array_unique(@$relationManager));

    81. 

  81. 		if(@$_SESSION['isAllocator']=='yes' or Yii::app()->session->get('type')=='superadmin') { 

    82. 

  82. 			$querycondition 	= 	' startDate = "'.@$today12PM.'" and status="Pending" ';

    83. 

  83. 		} else {	

    84. 

  84. 			$querycondition 	= 	" startDate = '".@$today12PM."' AND status = 'Pending' AND userId IN (".@$managerMemberId.") ";

    85. 

  85. 		}	

    86. 

  86. 		//$modelLead	=	LeadFollowup::model()->findAll("  $querycondition ");	

    87. 

  87. 

    88. 

  88. 		$this->render('followup_lead_list');

    89. 

  89. 	}

    90. 

  90. 	public function actionrenfollowup_overall_lead_list()

    91. 

  91. 	{

    92. 

  92. 	

    93. 

  93. 		$relationManager = $_SESSION['relationalManager'];

    94. 

  94. 		$managerMemberId = implode(",",array_unique(@$relationManager));

    95. 

  95. 		if(@$_SESSION['isAllocator']=='yes' or Yii::app()->session->get('type')=='superadmin') { 

    96. 

  96. 			$querycondition 	= 	' status="Pending" ';

    97. 

  97. 		} else {	

    98. 

  98. 			$querycondition 	= 	" status = 'Pending' AND userId IN (".@$managerMemberId.") ";

    99. 

  99. 		}	

    100. 

  100. 		//$modelLead	=	LeadFollowup::model()->findAll("  $querycondition ");	

    101. 

  101. 

    102. 

  102. 		$this->render('followup_overall_lead_list');

    103. 

  103. 	}

    104. 

  104. 	

    105. 

  105. 	/**

    106. 

  106. 	 * This is the 'lead_list_allocator' action that is invoked

    107. 

  107. 	 * when an action is not explicitly requested by users.

    108. 

  108. 	 */

    109. 

  109. 	public function actionlead_list_tc()

    110. 

  110. 	{

    111. 

  111. 		// renders the view file 'protected/views/site/index.php'

    112. 

  112. 		// using the default layout 'protected/views/layouts/main.php'

    113. 

  113. 		$this->render('lead_list_tc');

    114. 

  114. 	}

    115. 

  115. 	/**

    116. 

  116. 	 * This is the 'lead_list_allocator' action that is invoked

    117. 

  117. 	 * when an action is not explicitly requested by users.

    118. 

  118. 	 */

    119. 

  119. 	public function actionrenjunk_lead_list()

    120. 

  120. 	{

    121. 

  121. 		//$modelLead	=	Lead::model()->findAll("  leadStatusId = '36' ");	

    122. 

  122. 		$this->render('junk_lead_list');

    123. 

  123. 	}

    124. 

  124. 	/**

    125. 

  125. 	 * This is the 'lead_list_allocator' action that is invoked

    126. 

  126. 	 * when an action is not explicitly requested by users.

    127. 

  127. 	 */

    128. 

  128. 	public function actionrenduplicate_lead_list()

    129. 

  129. 	{

    130. 

  130. 		//$modelLead	=	Lead::model()->findAll("  leadStatusId = '10' ");	

    131. 

  131. 		$this->render('duplicate_lead_list');

    132. 

  132. 	}

    133. 

  133. 	public function actionno_response()

    134. 

  134. 	{

    135. 

  135. 		//$modelLead	=	Lead::model()->findAll("  leadStatusId = '10' ");	

    136. 

  136. 		$this->render('no_response');

    137. 

  137. 	}

    138. 

  138. 	public function actionnot_rechable()

    139. 

  139. 	{

    140. 

  140. 		//$modelLead	=	Lead::model()->findAll("  leadStatusId = '10' ");	

    141. 

  141. 		$this->render('not_rechable');

    142. 

  142. 	}

    143. 

  143. 	public function actionrenclose_lead_list()

    144. 

  144. 	{

    145. 

  145. 		//$modelLead	=	Lead::model()->findAll("  leadStatusId = '7' ");	

    146. 

  146. 		$this->render('close_lead_list');

    147. 

  147. 	}

    148. 

  148. 	/**

    149. 

  149. 	 * This is the 'lead_list_allocator' action that is invoked

    150. 

  150. 	 * when an action is not explicitly requested by users.

    151. 

  151. 	 */

    152. 

  152. 	public function actionrenallocated_lead_list()

    153. 

  153. 	{

    154. 

  154. 		$relationManager = $_SESSION['relationalManager'];

    155. 

  155. 		$managerMemberId = implode(",",array_unique(@$relationManager));

    156. 

  156. 		

    157. 

  157. 		if(@$_SESSION['isAllocator']=='yes' or Yii::app()->session->get('type')=='superadmin') { 

    158. 

  158. 			$querycondition 	= 	" currentAllocatedId>0 AND isRead = 'yes'";

    159. 

  159. 		} else {	

    160. 

  160. 			$querycondition 	= 	" currentAllocatedId >0 AND isRead = 'yes' AND currentAllocatedId IN (".@$managerMemberId.") ";

    161. 

  161. 		}

    162. 

  162. 		//$modelLead	=	Lead::model()->findAll("  $querycondition ");

    163. 

  163. 		$modelRenLead = new Renewallead();	

    164. 

  164. 		$this->render('allocated_lead_list',array('modelRenLead'=>@$modelRenLead));

    165. 

  165. 	}

    166. 

  166. 	/**

    167. 

  167. 	 * This is the 'lead_list_allocator' action that is invoked

    168. 

  168. 	 * when an action is not explicitly requested by users.

    169. 

  169. 	 */

    170. 

  170. 	public function actionrenleads_details()

    171. 

  171. 	{

    172. 

  172. 		// renders the view file 'protected/views/site/index.php'

    173. 

  173. 		// using the default layout 'protected/views/layouts/main.php'	

    174. 

  174. 		

    175. 

  175. 		//for follow up

    176. 

  176. 		if(isset($_POST['RenewalleadFollowup'])){

    177. 

  177. 		 if(isset($_POST['RenewalleadFollowup']['chkActionValid']) && @$_POST['RenewalleadFollowup']['chkActionValid']==1){

    178. 

  178. 		 $res = $this->actionlead_followup(@$_POST['RenewalleadFollowup'],@$_POST['Renewallead']['leadStatusId']);

    179. 

  179. 		 $decodeRes = json_decode($res);

    180. 

  180. 			if(@$decodeRes->status == 'success'){

    181. 

  181. 			echo CJSON::encode(array(

    182. 

  182.                                   'status'=>'success'

    183. 

  183.                              ));

    184. 

  184. 			} else {

    185. 

  185. 			echo $res;

    186. 

  186. 			 

    187. 

  187. 			}

    188. 

  188. 		 }

    189. 

  189. 		}

    190. 

  190. 		$leadFollDesc = @$_POST['RenewalleadFollowup']['description'];

    191. 

  191. 		// end of for follow ups	

    192. 

  192. 		$leadId	=	@$_GET['leadId'];	

    193. 

  193. 		$actionId = @$_REQUEST['actionId'];

    194. 

  194. 		$actionmodel=RenewalleadFollowup::model()->findByPk($actionId);

    195. 

  195. 		$model	=	new Renewallead();	

    196. 

  196. 		$this->performAjaxValidation($model);

    197. 

  197. 		$model->scenario = 'Lead';	

    198. 

  198. 		

    199. 

  199. 		$managerMemberId = implode(",",$_SESSION['relationalManager']);

    200. 

  200. 		$chkAllocatedLeads 	= 	$managerMemberId?Renewallead::model()->findAll(array("select"=>" leadId","condition"=>" leadStatusId != '26' AND leadStatusId != '25' AND currentAllocatedId IN (".@$managerMemberId.") ")):'0';	

    201. 

  201. 		$allocatedArr=array();

    202. 

  202. 		foreach($chkAllocatedLeads as $key=>$value){

    203. 

  203. 		$allocatedArr[]=$chkAllocatedLeads[$key]->leadId;

    204. 

  204. 		}

    205. 

  205. 		//print_r($allocatedArr);

    206. 

  206. 		//die;

    207. 

  207. 		/*if(Yii::app()->session->get('isAllocator')!='yes' and Yii::app()->session->get('type')!='superadmin'){

    208. 

  208. 			if(!in_array($leadId,$allocatedArr)){

    209. 

  209. 			 $this->redirect(array('leads/lead_list'));

    210. 

  210. 			}

    211. 

  211. 		}*/

    212. 

  212. 		

    213. 

  213. 		if(!empty($leadId)){

    214. 

  214. 			$model=Renewallead::model()->findByPk($leadId);		

    215. 

  215. 				$chkrecentlyViewed=recentlyViewed::model()->findByAttributes(array('leadId'=>$leadId,'userId'=>Yii::app()->session->get('id')));

    216. 

  216. 				if(count($chkrecentlyViewed) == 0){

    217. 

  217. 					$recentlyViewed = new recentlyViewed;

    218. 

  218. 					  $recentlyViewed->setAttributes(array(

    219. 

  219. 							'userId' => Yii::app()->session->get('id'), 

    220. 

  220. 							'leadId' => $leadId, 

    221. 

  221. 							'moduleId' => 0, 

    222. 

  222. 							'updatedOn' => $_SESSION['id'], 

    223. 

  223. 							'updatedBy' => $_SESSION['id'], 

    224. 

  224. 					));

    225. 

  225. 					

    226. 

  226. 					$recentlyViewed->save(false);

    227. 

  227. 				}

    228. 

  228. 		}

    229. 

  229. 		if(isset($_POST['Renewallead']))

    230. 

  230. 			{	

    231. 

  231. 			if($_POST['Renewallead']['expiryDate']!='' and strpos($_POST['Renewallead']['expiryDate'],'-') !== false){

    232. 

  232. 						$_POST['Renewallead']['expiryDate']=strtotime($_POST['Renewallead']['expiryDate']);			

    233. 

  233. 					}

    234. 

  234.                     	if($_POST['Renewallead']['dob']!='' and strpos($_POST['Renewallead']['dob'],'-') !== false){

    235. 

  235. 						$_POST['Renewallead']['dob']=strtotime($_POST['Renewallead']['dob']);			

    236. 

  236. 					}

    237. 

  237. 			if($_POST['RenewalleadFollowup']['startDate']!='') {

    238. 

  238. 					$finalLeadDesc = @$leadFollDesc;

    239. 

  239. 				} else {

    240. 

  240. 					$finalLeadDesc = @$_POST['Renewallead']['leadDescription'];

    241. 

  241. 				}	

    242. 

  242. 				$model->setAttributes(array(

    243. 

  243.             			'updatedOn' => time(), 			//additional

    244. 

  244. 			 			'updatedBy' => $_SESSION['id'], //additional

    245. 

  245. 			  			'status' => 'Active', 			//additional //additional

    246. 

  246. 						'leadDescription' => @$finalLeadDesc, 			//additional //additional

    247. 

  247.         		));	

    248. 

  248. 				$prevLeadStatusId=$model->leadStatusId;	

    249. 

  249. 				

    250. 

  250. 				$chkStatusMandatoryOrNot = RenewalleadStatus::model()->findByAttributes(array('leadStatusId'=>$model->leadStatusId));

    251. 

  251. 				

    252. 

  252. 				if(count($chkStatusMandatoryOrNot) > 0){

    253. 

  253. 						$condMandatory = $chkStatusMandatoryOrNot['compulsary'];

    254. 

  254. 						

    255. 

  255. 						if($condMandatory == 'Yes'){

    256. 

  256. 						$model->setScenario('RenewalLeadValid');

    257. 

  257. 						

    258. 

  258. 							if(@$_POST['Renewallead']['children']=="Children (Less than 25 Yrs)"){

    259. 

  259. 							 @$_POST['Renewallead']['children']='';

    260. 

  260. 							} 

    261. 

  261. 							if(@$_POST['Renewallead']['ageGroup']=="Age of eldest member"){

    262. 

  262. 							 @$_POST['Renewallead']['ageGroup']='';

    263. 

  263. 							} 

    264. 

  264. 					} 

    265. 

  265. 				}

    266. 

  266. 				foreach($_POST['Renewallead'] as $name=>$value)

    267. 

  267. 				{  	$model->setScenario('RenewalLeadValid');	

    268. 

  268. 					if($model->leadStatusId==''){

    269. 

  269. 						$model->leadStatusId=$model->renewalleadStatusParentId;			

    270. 

  270. 					}

    271. 

  271. 					if($model->email=='Email'){

    272. 

  272. 						$model->email='';			

    273. 

  273. 					}

    274. 

  274. 					if($model->name=='Name'){

    275. 

  275. 						$model->name='';			

    276. 

  276. 					}

    277. 

  277.                    

    278. 

  278. 					if($model->address=='Address'){

    279. 

  279. 						$model->address='';			

    280. 

  280. 					}

    281. 

  281. 					if($model->children=="Children (Less than 25 Yrs)"){

    282. 

  282. 					 $model->children='';

    283. 

  283. 					} 

    284. 

  284. 					if($model->ageGroup=="Age of eldest member"){

    285. 

  285. 					 $model->ageGroup='';

    286. 

  286. 					} 

    287. 

  287. 					if($model->leadDescription=="Lead Description"){

    288. 

  288. 					 $model->leadDescription='';

    289. 

  289. 					} 

    290. 

  290. 					if($model->leadStatusId==''){

    291. 

  291. 					 $model->leadStatusId=$prevLeadStatusId;

    292. 

  292. 					}

    293. 

  293. 						

    294. 

  294. 					

    295. 

  295. 					if(@$leadId!='' && $model->leadStatusId!='34' && @$model->leadStatusId!='35'){

    296. 

  296. 					 $model->isRead='yes';

    297. 

  297. 					}

    298. 

  298. 					$model->$name=$value;			

    299. 

  299. 				}

    300. 

  300. 			 

    301. 

  301.                     

    302. 

  302. 				if(@$leadId!='' && $model->leadStatusId!='34'){

    303. 

  303. 				

    304. 

  304. 				  $update = Yii::app()->db->createCommand("update `renewallead` set `isRead`='yes' where `leadId`='$leadId' and currentAllocatedId > 0")->query();

    305. 

  305. 				}

    306. 

  306. 				

    307. 

  307. 								$chkStatusMandatoryOrNot = RenewalleadStatus::model()->findByAttributes(array('leadStatusId'=>$model->leadStatusId));

    308. 

  308. 				

    309. 

  309. 				if(count($chkStatusMandatoryOrNot) > 0){

    310. 

  310. 					$condMandatory = $chkStatusMandatoryOrNot['compulsary'];

    311. 

  311. 					

    312. 

  312. 					if($condMandatory == 'No'){

    313. 

  313. 					if($model->validate(array('mobile'))){	

    314. 

  314. 						

    315. 

  315. 					if(@$_POST['Renewallead']['emailOptOut']=='on')		{  $model->emailOptOut='Y'; 	} else {  $model->emailOptOut='N'; 	}

    316. 

  316. 					if(@$_POST['Renewallead']['mobileOptOut']=='on')		{  $model->mobileOptOut='Y'; 	} else {  $model->mobileOptOut='N'; }

    317. 

  317. 					if(@$_POST['Renewallead']['isJunk']=='on')				{  $model->isJunk='yes'; 		} else {  $model->isJunk='no'; 		}

    318. 

  318. 					if(@$_POST['Renewallead']['isDuplicate']=='on')		{  $model->isDuplicate='yes'; 	} else {  $model->isDuplicate='no'; }

    319. 

  319. 					if(@$_POST['Renewallead']['status']=='on')				{  $model->status='Close'; 		} else {  $model->status='Active'; 	}

    320. 

  320. 									

    321. 

  321. 						

    322. 

  322. 					$modelHistory	=	new RenewalleadHistory();	

    323. 

  323. 					$modelHistory->scenario = 'LeadHistory';

    324. 

  324. 						

    325. 

  325. 					$modelHistory->setAttributes(array(

    326. 

  326. 							'leadId' => @$leadId, 			//additional data you want to insert

    327. 

  327. 							'updatedOn' => time(), 			//additional

    328. 

  328. 							'updatedBy' => $_SESSION['id'], //additional

    329. 

  329. 							'status' 	=> 'Active', 		//additional 

    330. 

  330. 							'leadDescription' => @$finalLeadDesc, 

    331. 

  331. 							

    332. 

  332. 					));			

    333. 

  333. 					foreach($_POST['Renewallead'] as $name1=>$value1)

    334. 

  334. 					{  

    335. 

  335. 						if($modelHistory->leadStatusId==''){

    336. 

  336. 							$modelHistory->leadStatusId=$modelHistory->renewalleadStatusParentId;			

    337. 

  337. 						}

    338. 

  338. 						if(@$_POST['RenewalleadFollowup']['description']=='Description'){

    339. 

  339. 							$activitydesc = '';

    340. 

  340. 						} else {

    341. 

  341. 							$activitydesc = @$_POST['RenewalleadFollowup']['description'];

    342. 

  342. 						}

    343. 

  343. 						$modelHistory->activityDescription=@$activitydesc;

    344. 

  344. 						if($model->leadStatusId==''){

    345. 

  345. 						 $model->leadStatusId=2;

    346. 

  346. 						}

    347. 

  347. 						if($modelHistory->email=='Email'){

    348. 

  348. 							$modelHistory->email='';			

    349. 

  349. 						}

    350. 

  350. 						if($modelHistory->name=='Name'){

    351. 

  351. 							$modelHistory->name='';			

    352. 

  352. 						}

    353. 

  353. 						if($modelHistory->address=='Address'){

    354. 

  354. 							$modelHistory->address='';			

    355. 

  355. 						}

    356. 

  356. 						if($modelHistory->leadDescription=="Lead Description"){

    357. 

  357. 						 $modelHistory->leadDescription='';

    358. 

  358. 						} 

    359. 

  359. 						if($modelHistory->children=="Children (Less than 25 Yrs)"){

    360. 

  360. 						 $modelHistory->children='';

    361. 

  361. 						} 

    362. 

  362. 						if($modelHistory->ageGroup=="Age of eldest member"){

    363. 

  363. 						 $modelHistory->ageGroup='';

    364. 

  364. 						} 

    365. 

  365. 						

    366. 

  366. 						$modelHistory->$name1=$value1;			

    367. 

  367. 					}	

    368. 

  368. 								

    369. 

  369. 					$model->save(false);

    370. 

  370. 					$modelHistory->save();

    371. 

  371. 					  CJSON::encode(array(

    372. 

  372.                                   'status'=>'success'

    373. 

  373.                              ));

    374. 

  374.                             Yii::app()->end();

    375. 

  375. 					  }

    376. 

  376. 					} 

    377. 

  377. 				}

    378. 

  378.  				

    379. 

  379. 				$model->save();

    380. 

  380. 				if($model->validate()){	

    381. 

  381. 					if(@$_POST['Renewallead']['emailOptOut']=='on')		{  $model->emailOptOut='Y'; 	} else {  $model->emailOptOut='N'; 	}

    382. 

  382. 					if(@$_POST['Renewallead']['mobileOptOut']=='on')		{  $model->mobileOptOut='Y'; 	} else {  $model->mobileOptOut='N'; }

    383. 

  383. 					if(@$_POST['Renewallead']['isJunk']=='on')				{  $model->isJunk='yes'; 		} else {  $model->isJunk='no'; 		}

    384. 

  384. 					if(@$_POST['Renewallead']['isDuplicate']=='on')		{  $model->isDuplicate='yes'; 	} else {  $model->isDuplicate='no'; }

    385. 

  385. 					if(@$_POST['Renewallead']['status']=='on')				{  $model->status='Close'; 		} else {  $model->status='Active'; 	}

    386. 

  386. 									

    387. 

  387. 						

    388. 

  388. 					$modelHistory	=	new RenewalleadHistory();	

    389. 

  389. 					$modelHistory->scenario = 'LeadHistory';	

    390. 

  390. 					$modelHistory->setAttributes(array(

    391. 

  391. 							'leadId' => @$leadId, 			//additional data you want to insert

    392. 

  392. 							'updatedOn' => time(), 			//additional

    393. 

  393. 							'updatedBy' => $_SESSION['id'], //additional

    394. 

  394. 							'status' 	=> 'Active', 		//additional 

    395. 

  395. 							'leadDescription' => @$finalLeadDesc, 

    396. 

  396. 							

    397. 

  397. 					));			

    398. 

  398. 					foreach($_POST['Renewallead'] as $name1=>$value1)

    399. 

  399. 					{  

    400. 

  400. 						if($modelHistory->leadStatusId==''){

    401. 

  401. 							$modelHistory->leadStatusId=$modelHistory->renewalleadStatusParentId;			

    402. 

  402. 						}

    403. 

  403. 						$modelHistory->activityDescription=@$_POST['RenewalleadFollowup']['description'];

    404. 

  404. 						if($model->leadStatusId==''){

    405. 

  405. 						 $model->leadStatusId=2;

    406. 

  406. 						}

    407. 

  407. 						$modelHistory->$name1=$value1;			

    408. 

  408. 					}						

    409. 

  409. 					

    410. 

  410. 					$modelHistory->save();

    411. 

  411. 					 echo CJSON::encode(array(

    412. 

  412.                                   'status'=>'success'

    413. 

  413.                              ));

    414. 

  414.                             Yii::app()->end();

    415. 

  415. 					//Yii::app()->end();

    416. 

  416. 					//die;

    417. 

  417. 					//$this->redirect(array('leads/leads_details'));

    418. 

  418. 				} else {

    419. 

  419. 				 $error = CActiveForm::validate($model);

    420. 

  420.                                 if($error!='[]')

    421. 

  421.                                     echo $error;

    422. 

  422.                                 Yii::app()->end();

    423. 

  423. 				//$this->render('leads_details',array('model'=>$model));

    424. 

  424. 				}

    425. 

  425. 			}	else {

    426. 

  426. 					

    427. 

  427. 				$this->render('leads_details',array('model'=>@$model,'actionmodel'=>@$actionmodel,'quotesmobile'=>@$model->mobile));

    428. 

  428. 			}	

    429. 

  429. 	}

    430. 

  430. 	protected function performAjaxValidation($models)

    431. 

  431. 	{

    432. 

  432. 		if(isset($_POST['ajax']) && $_POST['ajax']==='user-form')

    433. 

  433. 		{

    434. 

  434. 			echo CActiveForm::validate($models);

    435. 

  435. 			Yii::app()->end();

    436. 

  436. 		}

    437. 

  437. 	}

    438. 

  438. 	/**

    439. 

  439. 	 * This is the 'lead_list_allocator' action that is invoked

    440. 

  440. 	 * when an action is not explicitly requested by users.

    441. 

  441. 	 */

    442. 

  442. 	public function actionlead_followup()

    443. 

  443. 	{

    444. 

  444. 		$actionId = @$_REQUEST['actionId'];

    445. 

  445. 		$model	=	new RenewalleadFollowup();	

    446. 

  446. 		$model->scenario = 'LeadFollowup';

    447. 

  447. 		if(isset($actionId) && !empty($actionId)){

    448. 

  448. 		$model=RenewalleadFollowup::model()->findByPk($actionId);	

    449. 

  449. 		} else {

    450. 

  450. 		

    451. 

  451. 		}

    452. 

  452. 	

    453. 

  453. 		if(isset($_POST['RenewalleadFollowup']['actionType']) && $_POST['LeadFollowup']['actionType']=='Task'){

    454. 

  454. 		$model->scenario = 'LeadFollowupTask';	

    455. 

  455. 		}if(isset($_POST['RenewalleadFollowup']['actionType']) && $_POST['LeadFollowup']['actionType']=='Follow Up'){

    456. 

  456. 		$model->scenario = 'LeadFollowup';	

    457. 

  457. 		}if(isset($_POST['RenewalleadFollowup']['actionType']) && $_POST['LeadFollowup']['actionType']=='Meeting'){

    458. 

  458. 		$model->scenario = 'LeadFollowup';	

    459. 

  459. 		}if(isset($_POST['RenewalleadFollowup']['actionType']) && $_POST['LeadFollowup']['actionType']=='Notes'){

    460. 

  460. 		$model->scenario = 'LeadFollowupNotes';	

    461. 

  461. 		} 

    462. 

  462. 		$this->performAjaxValidation($model);

    463. 

  463. 		if(isset($_POST['RenewalleadFollowup']))

    464. 

  464. 			{

    465. 

  465. 				$userId = $_POST['RenewalleadFollowup']['userId'];

    466. 

  466. 				 $followupstartdatewithtime = strtotime(@$_POST['RenewalleadFollowup']['startDate'])+(@$_POST['RenewalleadFollowup']['hour']*60*60)+(@$_POST['RenewalleadFollowup']['minutes']*60); 

    467. 

  467. 				$model->setAttributes(array(

    468. 

  468.             			'createdOn' => time(), 		//additional data you want to insert

    469. 

  469.             			'updatedOn' => time(), 		//additional

    470. 

  470. 			 			'updatedBy' => @$userId, 	//additional

    471. 

  471. 			  			'createdBy' => @$userId, 	//additional

    472. 

  472. 						'status' 	=> 'Pending', 	//additional

    473. 

  473.         		));

    474. 

  474. 				foreach($_POST['RenewalleadFollowup'] as $name=>$value)

    475. 

  475. 				{

    476. 

  476. 					$model->$name=$value;															

    477. 

  477. 				}

    478. 

  478. 				$model->leadStatusId=@$_POST['Renewallead']['leadStatusId'];;	

    479. 

  479. 				$model->startDateWithTime=@$followupstartdatewithtime;	

    480. 

  480. 				if(@$_POST['RenewalleadFollowup']['actionType']=='Notes') {

    481. 

  481. 					$prefix=substr(time(),0,5);

    482. 

  482. 				 	$folder = 'siteupload/';

    483. 

  483. 				 	$model->notesFile=CUploadedFile::getInstance($model,'notesFile');					

    484. 

  484. 					if($model->notesFile !='')

    485. 

  485. 					 $model->notesFile->saveAs($folder.$prefix.$model->notesFile);	

    486. 

  486. 					 $model->notesFile=$prefix.CUploadedFile::getInstance($model,'notesFile');					 

    487. 

  487. 				}				

    488. 

  488. 				if(@$_POST['RenewalleadFollowup']['startDate']!='') { 

    489. 

  489. 					$startDateVal = strtotime($_POST['RenewalleadFollowup']['startDate']); 

    490. 

  490. 					$model->startDate=@$startDateVal;

    491. 

  491. 				}

    492. 

  492. 				if(@$_POST['RenewalleadFollowup']['taskDueDate']!='') { 

    493. 

  493. 					$taskDueDateVal = strtotime($_POST['RenewalleadFollowup']['taskDueDate']); 

    494. 

  494. 					$model->taskDueDate=@$taskDueDateVal;

    495. 

  495. 				}

    496. 

  496. 				if(@$_POST['RenewalleadFollowup']['taskCompleted']!='') {

    497. 

  497. 					$model->taskCompleted='yes';

    498. 

  498. 				}	

    499. 

  499. 				if($model->validate()){	

    500. 

  500. 				

    501. 

  501. 				$checkForSameDateExistsOrNot=RenewalleadFollowup::model()->findAll(" leadId='".@$_POST['RenewalleadFollowup']['leadId']."' and startDate <= '".$model->startDate."' and userId = '".@$userId."'  and createdBy = '".@$userId."' ");

    502. 

  502. 				if(count(@$checkForSameDateExistsOrNot) > 0){

    503. 

  503. 				$update = Yii::app()->db->createCommand("UPDATE renewalleadFollowup SET taskCompleted = 'yes',status = 'Completed' WHERE  startDate <= '".$model->startDate."' and userId = '".@$userId."'  and createdBy = '".@$userId."'  and leadId='".@$_POST['RenewalleadFollowup']['leadId']."' ")->execute();

    504. 

  504. 				}

    505. 

  505. 					$model->save();

    506. 

  506. 					$leadId = $_POST['RenewalleadFollowup']['leadId'];

    507. 

  507. 					return  CJSON::encode(array(

    508. 

  508. 										  'status'=>'success'

    509. 

  509. 									 ));

    510. 

  510. 									Yii::app()->end();

    511. 

  511. 				} else {

    512. 

  512. 					 $error = CActiveForm::validate($model);

    513. 

  513. 									if($error!='[]')

    514. 

  514. 										return $error;

    515. 

  515. 									Yii::app()->end();

    516. 

  516. 				}

    517. 

  517. 					//$this->redirect(array('leads/leads_details', 'leadId'=>@$leadId));

    518. 

  518. 		}

    519. 

  519. 		$this->redirect(array('renealleads/renlead_list'));

    520. 

  520. 	}

    521. 

  521. 	/**

    522. 

  522. 	 * This is the 'lead_list_allocator' action that is invoked

    523. 

  523. 	 * when an action is not explicitly requested by users.

    524. 

  524. 	 */

    525. 

  525. 	public function actionlead_followupcalender()

    526. 

  526. 	{

    527. 

  527. 		$actionId = @$_REQUEST['actionId'];

    528. 

  528. 		$model	=	new RenewalleadFollowup();	

    529. 

  529. 		$model->scenario = 'LeadFollowup';

    530. 

  530. 		if(isset($actionId) && !empty($actionId)){

    531. 

  531. 		$model=RenewalleadFollowup::model()->findByPk($actionId);	

    532. 

  532. 		} else {

    533. 

  533. 		

    534. 

  534. 		}

    535. 

  535. 	

    536. 

  536. 		if(isset($_POST['RenewalleadFollowup']['actionType']) && $_POST['LeadFollowup']['actionType']=='Task'){

    537. 

  537. 		$model->scenario = 'LeadFollowupTask';	

    538. 

  538. 		}if(isset($_POST['RenewalleadFollowup']['actionType']) && $_POST['LeadFollowup']['actionType']=='Follow Up'){

    539. 

  539. 		$model->scenario = 'LeadFollowup';	

    540. 

  540. 		}if(isset($_POST['RenewalleadFollowup']['actionType']) && $_POST['LeadFollowup']['actionType']=='Meeting'){

    541. 

  541. 		$model->scenario = 'LeadFollowup';	

    542. 

  542. 		}if(isset($_POST['RenewalleadFollowup']['actionType']) && $_POST['LeadFollowup']['actionType']=='Notes'){

    543. 

  543. 		$model->scenario = 'LeadFollowupNotes';	

    544. 

  544. 		} 

    545. 

  545. 		$this->performAjaxValidation($model);

    546. 

  546. 		if(isset($_POST['RenewalleadFollowup']))

    547. 

  547. 			{

    548. 

  548. 				$userId = $_POST['RenewalleadFollowup']['userId'];

    549. 

  549. 				$model->setAttributes(array(

    550. 

  550.             			'createdOn' => time(), 		//additional data you want to insert

    551. 

  551.             			'updatedOn' => time(), 		//additional

    552. 

  552. 			 			'updatedBy' => @$userId, 	//additional

    553. 

  553. 			  			'createdBy' => @$userId, 	//additional

    554. 

  554. 						'status' 	=> 'Pending', 	//additional

    555. 

  555.         		));

    556. 

  556. 				foreach($_POST['RenewalleadFollowup'] as $name=>$value)

    557. 

  557. 				{

    558. 

  558. 					$model->$name=$value;															

    559. 

  559. 				}

    560. 

  560. 				$model->leadStatusId=@$_POST['Renewallead']['leadStatusId'];;	

    561. 

  561. 				if(@$_POST['RenewalleadFollowup']['actionType']=='Notes') {

    562. 

  562. 					$prefix=substr(time(),0,5);

    563. 

  563. 				 	$folder = 'siteupload/';

    564. 

  564. 				 	$model->notesFile=CUploadedFile::getInstance($model,'notesFile');					

    565. 

  565. 					if($model->notesFile !='')

    566. 

  566. 					 $model->notesFile->saveAs($folder.$prefix.$model->notesFile);	

    567. 

  567. 					 $model->notesFile=$prefix.CUploadedFile::getInstance($model,'notesFile');					 

    568. 

  568. 				}				

    569. 

  569. 				if(@$_POST['RenewalleadFollowup']['startDate']!='') { 

    570. 

  570. 					$startDateVal = strtotime($_POST['RenewalleadFollowup']['startDate']); 

    571. 

  571. 					$model->startDate=@$startDateVal;

    572. 

  572. 				}

    573. 

  573. 				if(@$_POST['RenewalleadFollowup']['taskDueDate']!='') { 

    574. 

  574. 					$taskDueDateVal = strtotime($_POST['RenewalleadFollowup']['taskDueDate']); 

    575. 

  575. 					$model->taskDueDate=@$taskDueDateVal;

    576. 

  576. 				}

    577. 

  577. 				if(@$_POST['RenewalleadFollowup']['taskCompleted']!='') {

    578. 

  578. 					$model->taskCompleted='yes';

    579. 

  579. 				}	

    580. 

  580. 				if($model->validate()){				

    581. 

  581. 					$model->save();

    582. 

  582. 					$leadId = $_POST['RenewalleadFollowup']['leadId'];

    583. 

  583. 					echo  CJSON::encode(array(

    584. 

  584. 										  'status'=>'success'

    585. 

  585. 									 ));

    586. 

  586. 									Yii::app()->end();

    587. 

  587. 				} else {

    588. 

  588. 					 $error = CActiveForm::validate($model);

    589. 

  589. 									if($error!='[]')

    590. 

  590. 										return $error;

    591. 

  591. 									Yii::app()->end();

    592. 

  592. 				}

    593. 

  593. 					//$this->redirect(array('leads/leads_details', 'leadId'=>@$leadId));

    594. 

  594. 		}

    595. 

  595. 		$this->redirect(array('renewalleads/renlead_list'));

    596. 

  596. 	}

    597. 

  597. 

    598. 

  598. 

    599. 

  599. 	public function actionlead_contacts()

    600. 

  600. 	{

    601. 

  601. 		// renders the view file 'protected/views/site/index.php'

    602. 

  602. 		// using the default layout 'protected/views/layouts/main.php'

    603. 

  603. 		$model	=	new LeadContacts();	

    604. 

  604. 		$model->scenario = 'LeadContacts';	

    605. 

  605. 		$this->performAjaxValidation($model);

    606. 

  606. 		if(!empty($_GET['contactId']))

    607. 

  607. 		{

    608. 

  608. 			$leadContactId=$_GET['leadContactId'];

    609. 

  609. 			$model=LeadContacts::model()->findByPk($leadContactId);				

    610. 

  610. 		}		

    611. 

  611. 		if(!empty($_POST['LeadContacts']['leadContactId']))

    612. 

  612. 		{

    613. 

  613. 			$leadContactId=$_POST['LeadContacts']['leadContactId'];			

    614. 

  614. 			$model=LeadContacts::model()->findByPk($leadContactId);

    615. 

  615. 		}

    616. 

  616. 		if(isset($_POST['LeadContacts']))

    617. 

  617. 			{

    618. 

  618. 				$userId = $_POST['LeadContacts']['userId'];

    619. 

  619. 				$leadId = $_POST['LeadContacts']['leadId'];

    620. 

  620. 				$model->setAttributes(array(

    621. 

  621.             			'createdOn' => time(), //additional data you want to insert

    622. 

  622.             			'updatedOn' => time(), //additional

    623. 

  623. 			 			'updatedBy' => @$userId, //additional

    624. 

  624. 			  			'createdBy' => @$userId, //additional

    625. 

  625. 						'status' 	=> 'Active', //additional

    626. 

  626.         		));

    627. 

  627. 				foreach($_POST['LeadContacts'] as $name=>$value)

    628. 

  628. 				{

    629. 

  629. 					$model->$name=$value;															

    630. 

  630. 				}			

    631. 

  631. 				if($model->validate()){

    632. 

  632. 				$model->save();

    633. 

  633. 				 echo CJSON::encode(array(

    634. 

  634. 							  'status'=>'success'

    635. 

  635. 						 ));

    636. 

  636. 						Yii::app()->end();

    637. 

  637. 				} else {

    638. 

  638. 					 $error = CActiveForm::validate($model);

    639. 

  639. 					if($error!='[]')

    640. 

  640. 						echo $error;

    641. 

  641. 					Yii::app()->end();

    642. 

  642. 

    643. 

  643. 				}		

    644. 

  644. 			

    645. 

  645. 			//$this->redirect(array('leads/leads_details', 'leadId'=>@$leadId));

    646. 

  646. 		}

    647. 

  647. 		$this->redirect(array('leads/lead_list'));

    648. 

  648. 	}

    649. 

  649. 	public function actionChangeContactStatus()

    650. 

  650. 	{

    651. 

  651. 	 

    652. 

  652.         $Id=$_REQUEST['contactId'];

    653. 

  653. 		$leadId=$_REQUEST['leadId'];

    654. 

  654.         $status=$_REQUEST['status'];

    655. 

  655. 		if(isset($status)&&($status=='Inactive')){

    656. 

  656. 		$status="Active";

    657. 

  657. 		} else {

    658. 

  658. 			$status="Inactive";

    659. 

  659. 		}

    660. 

  660. 		if(!empty($Id))

    661. 

  661. 		{

    662. 

  662. 			$model=LeadContacts::model()->findByPk($Id);

    663. 

  663. 		}

    664. 

  664. 		else

    665. 

  665. 		{

    666. 

  666. 			$model = LeadContacts::model()->findAll();

    667. 

  667. 		}

    668. 

  668. 		$model->status=$status;

    669. 

  669. 		$model->save();

    670. 

  670. 		$this->redirect(array('leads/leads_details', 'leadId'=>@$leadId));

    671. 

  671. 	}	

    672. 

  672. 	/**

    673. 

  673. 	 * This is the 'roles' action that is invoked

    674. 

  674. 	 * when an action is not explicitly requested by users.

    675. 

  675. 	 */

    676. 

  676. 	public function actionrencreate_lead()

    677. 

  677. 	{

    678. 

  678. 			$model=new User();

    679. 

  679. 			$model->scenario = 'Lead';

    680. 

  680. 			if(!empty($_GET['leadId']))

    681. 

  681. 			{

    682. 

  682. 				$leadId=$_GET['leadId'];

    683. 

  683. 				$model=User::model()->findByPk($leadId);

    684. 

  684. 				$chkrecentlyViewed=recentlyViewed::model()->findByAttributes(array('leadId'=>$leadId,'userId'=>Yii::app()->session->get('id')));

    685. 

  685. 				if(count($chkrecentlyViewed) == 0){

    686. 

  686. 					$recentlyViewed = new recentlyViewed;

    687. 

  687. 					  $recentlyViewed->setAttributes(array(

    688. 

  688. 							'userId' => Yii::app()->session->get('id'), 

    689. 

  689. 							'leadId' => $leadId, 

    690. 

  690. 							'moduleId' => 0, 

    691. 

  691. 							'createdOn' => time(), 

    692. 

  692. 							'updatedOn' => time(), 

    693. 

  693. 							'updatedBy' => time(), 

    694. 

  694. 							'createdBy' => time(),						

    695. 

  695. 					));

    696. 

  696. 					

    697. 

  697. 					$recentlyViewed->save(false);

    698. 

  698. 				}

    699. 

  699. 			}

    700. 

  700. 			if(!empty($_POST['Renewallead']['leadId']))

    701. 

  701. 			{

    702. 

  702. 				$leadId=$_POST['Renewallead']['leadId'];

    703. 

  703. 				$model=User::model()->findByPk($leadId);

    704. 

  704. 			}		

    705. 

  705. 			if(isset($_POST['Renewallead']))

    706. 

  706. 			{	

    707. 

  707. 			

    708. 

  708. 				  $model->setAttributes(array(

    709. 

  709.             			'createdOn' => time(), //additional data you want to insert

    710. 

  710.             			'updatedOn' => time(), //additional

    711. 

  711. 			 			'updatedBy' => Yii::app()->session->get('id'), //additional

    712. 

  712. 			  			'createdBy' => Yii::app()->session->get('id'),						

    713. 

  713.         		));

    714. 

  714. 				foreach($_POST['Renewallead'] as $name=>$value)

    715. 

  715. 				{ 

    716. 

  716. 					$model->$name=$value;											

    717. 

  717. 					if($model->leadStatusId==''){

    718. 

  718. 						 $model->leadStatusId=$model->renewalleadStatusParentId;			

    719. 

  719. 					}

    720. 

  720. 					if($model->leadStatusId==''){

    721. 

  721. 					 $model->leadStatusId=34;

    722. 

  722. 					}

    723. 

  723. 					if($model->mobile=='Mobile*'){

    724. 

  724. 						$model->mobile='';			

    725. 

  725. 					}

    726. 

  726. 					if($model->email=='Email'){

    727. 

  727. 						$model->email='';			

    728. 

  728. 					}

    729. 

  729. 					if($model->name=='Name'){

    730. 

  730. 						$model->name='';			

    731. 

  731. 					}

    732. 

  732. 					if($model->address=='Address'){

    733. 

  733. 						$model->address='';			

    734. 

  734. 					}

    735. 

  735. 					if($model->children=="Children (Less than 25 Yrs)"){

    736. 

  736. 					 $model->children='';

    737. 

  737. 					} 

    738. 

  738. 					if($model->ageGroup=="Age of eldest member"){

    739. 

  739. 					 $model->ageGroup='';

    740. 

  740. 					} 

    741. 

  741. 				}

    742. 

  742. 				

    743. 

  743. 				if($model->leadSourceId=='' or empty($model->leadSourceId)){

    744. 

  744. 				$model->leadSourceId = '2';

    745. 

  745. 				}

    746. 

  746. 					if(Yii::app()->session->get('isAllocator')!='yes' and Yii::app()->session->get('type')!='superadmin') { 

    747. 

  747. 						 @$model->leadStatusId=35;

    748. 

  748. 						 @$model->currentAllocatedId=Yii::app()->session->get('id');

    749. 

  749. 					}

    750. 

  750. 

    751. 

  751. 				if(@$leadId!='' && $model->leadStatusId!='34'){

    752. 

  752. 				  $update = Yii::app()->db->createCommand("update `user` set `isRead`='yes' where `leadId`='$leadId' and currentAllocatedId > 0")->query();

    753. 

  753. 				}

    754. 

  754. 

    755. 

  755. 				if(@$_POST['Lead']['emailOptOut']=='on')		{  $model->emailOptOut='Y'; 	} else {  $model->emailOptOut='N'; 	}

    756. 

  756. 				if(@$_POST['Lead']['mobileOptOut']=='on')		{  $model->mobileOptOut='Y'; 	} else {  $model->mobileOptOut='N'; }

    757. 

  757. 				if(@$_POST['Lead']['isJunk']=='on')				{  $model->isJunk='yes'; 		} else {  $model->isJunk='no'; 		}

    758. 

  758. 				if(@$_POST['Lead']['isDuplicate']=='on')		{  $model->isDuplicate='yes'; 	} else {  $model->isDuplicate='no'; }

    759. 

  759. 				if(@$_POST['Lead']['status']=='on')				{  $model->status='Close'; 		} else {  $model->status='Active'; 	}

    760. 

  760. 				$chkStatusMandatoryOrNot = RenewalleadStatus::model()->findByAttributes(array('leadStatusId'=>$model->leadStatusId));

    761. 

  761. 				

    762. 

  762. 				if(count($chkStatusMandatoryOrNot) > 0){

    763. 

  763. 					$condMandatory = $chkStatusMandatoryOrNot['compulsary'];

    764. 

  764. 					if($condMandatory == 'No'){

    765. 

  765. 					if($model->validate(array('mobile'))){	

    766. 

  766. 					 	

    767. 

  767. 						

    768. 

  768. 						

    769. 

  769. 						

    770. 

  770. 								

    771. 

  771. 					$mobileNumber	=	@$_POST['Renewallead']['mobile'];				

    772. 

  772. 					$checkJunkNumber = JunkNumbersMaster::model()->find('junkLeadNumber = "'.@$mobileNumber.'"');

    773. 

  773. 					if(empty($checkJunkNumber)){

    774. 

  774. 						$beforethreemonth = time()-7776000;

    775. 

  775. 						$checkDuplicateNumber = Renewallead::model()->find('mobile = "'.@$mobileNumber.'" AND createdOn > "'.@$beforethreemonth.'" AND status = "Active" AND leadId != "'.@$leadId.'" ');

    776. 

  776. 						if(empty($checkDuplicateNumber)){

    777. 

  777. 						

    778. 

  778. 							$model->save(false);

    779. 

  779. 							Yii::app()->user->setFlash('lead_msg_success','Successfully Inserted');

    780. 

  780. 						} else {

    781. 

  781. 							$duplicateLeadId = $checkDuplicateNumber->leadId;

    782. 

  782. 							$model->leadStatusId='10';

    783. 

  783. 							$model->duplicateLeadId=@$duplicateLeadId;

    784. 

  784. 							$model->currentAllocatedId=$checkDuplicateNumber->currentAllocatedId;

    785. 

  785. 							$model->save(false);

    786. 

  786. 							Yii::app()->user->setFlash('lead_msg_success','Successfully Inserted');

    787. 

  787. 						}

    788. 

  788. 					} else {

    789. 

  789. 						$model->leadStatusId='36';

    790. 

  790. 						$model->save(false);

    791. 

  791. 						Yii::app()->user->setFlash('lead_msg_success','Junk Lead');

    792. 

  792. 					}

    793. 

  793. 					$this->redirect(array('renewalleads/renlead_list'));

    794. 

  794. 				

    795. 

  795. 						// $model->save(false);

    796. 

  796. 					 	// $this->redirect(array('leads/lead_list'));

    797. 

  797. 					  }

    798. 

  798. 					}

    799. 

  799. 				}

    800. 

  800. 			 if($model->leadStatusId==36){

    801. 

  801. 			 $model->save(false);

    802. 

  802. 			 $this->redirect(array('renewalleads/renlead_list'));

    803. 

  803. 			 } else {

    804. 

  804. 				if($model->validate()){		

    805. 

  805. 					$mobileNumber	=	$_POST['Renewallead']['mobile'];				

    806. 

  806. 					$checkJunkNumber = JunkNumbersMaster::model()->find('junkLeadNumber = "'.@$mobileNumber.'"');

    807. 

  807. 					if(empty($checkJunkNumber)){

    808. 

  808. 						$beforethreemonth = time()-7776000;

    809. 

  809. 						$checkDuplicateNumber = Renewallead::model()->find('mobile = "'.@$mobileNumber.'" AND createdOn > "'.@$beforethreemonth.'" AND status = "Active" AND leadId != "'.@$leadId.'" ');

    810. 

  810. 						if(empty($checkDuplicateNumber)){

    811. 

  811. 						

    812. 

  812. 							$model->save();

    813. 

  813. 							Yii::app()->user->setFlash('lead_msg_success','Successfully Inserted');

    814. 

  814. 						} else {

    815. 

  815. 							$duplicateLeadId = $checkDuplicateNumber->leadId;

    816. 

  816. 							$model->leadStatusId='10';

    817. 

  817. 							$model->duplicateLeadId=@$duplicateLeadId;

    818. 

  818. 							$model->save();

    819. 

  819. 							Yii::app()->user->setFlash('lead_msg_success','Successfully Inserted');

    820. 

  820. 						}

    821. 

  821. 					} else {

    822. 

  822. 						$model->leadStatusId='36';

    823. 

  823. 						$model->save();

    824. 

  824. 						Yii::app()->user->setFlash('lead_msg_success','Junk Lead');

    825. 

  825. 					}

    826. 

  826. 					$this->redirect(array('renewalleads/renlead_list'));

    827. 

  827. 				}	else {

    828. 

  828. 					$this->render('create_lead',array('model'=>$model));					

    829. 

  829. 				}	

    830. 

  830. 			 }		

    831. 

  831. 			}	else {

    832. 

  832. 			$this->render('create_lead',array('model'=>$model));

    833. 

  833. 			}	

    834. 

  834. 	}

    835. 

  835. 	public function actionAllocateLeads()

    836. 

  836. 	{		

    837. 

  837. 	

    838. 

  838. 		$Id			=	@$_REQUEST['userids'];

    839. 

  839. 		$teamId		=	@$_REQUEST['Renewalteam']['teamId'];

    840. 

  840. 		$userId		=	@$_REQUEST['Renewalteam']['teamMemberId'];

    841. 

  841. 		$updatedBy	=	@$_SESSION['id'];

    842. 

  842. 		

    843. 

  843. 		foreach($Id as $key=>$value){

    844. 

  844. 			$model	=	new AllocatedLeads();

    845. 

  845. 			$model->scenario = 'AllocatedLeads';

    846. 

  846. 			$model->setAttributes(array(

    847. 

  847. 				'currentAllocatedDate' => time(), //additional data you want to insert

    848. 

  848. 				'createdOn' => time(), //additional data you want to insert

    849. 

  849. 				'updatedOn' => time(), //additional

    850. 

  850. 				'updatedBy' => @$updatedBy, //additional

    851. 

  851. 				'createdBy' => @$updatedBy, //additional

    852. 

  852. 				'leadStatusId' => '35', //additional //additional

    853. 

  853. 			));				

    854. 

  854. 			$leadId = @$value;

    855. 

  855. 			$model->leadId		=	@$value;

    856. 

  856. 			$model->userId		=	@$userId;

    857. 

  857. 			$model->teamId		=	@$teamId;

    858. 

  858. 			//echo @$teamId.' - '.@$userId.' - '.@$leadId;

    859. 

  859. 			$model->allocatedId = null;

    860. 

  860. 			$model->isNewRecord = true;

    861. 

  861. 			$model->save();			

    862. 

  862. 			$model=new Renewallead();

    863. 

  863. 			$model->scenario = 'Lead';

    864. 

  864. 			$updatedOn		=	time();

    865. 

  865. 			

    866. 

  866. 			Renewallead::model()->updateByPk(@$value, array('currentAllocatedId'=>@$userId,'leadStatusId'=>'35','updatedBy'=>@$updatedBy,'updatedOn'=>@$updatedOn,'currentAllocatedDate'=>@$updatedOn));			

    867. 

  867. 			}

    868. 

  868. 			 $red			=	@$_REQUEST['red'];

    869. 

  869. 			if(is_array(@$_REQUEST['subverticalDescription'])){

    870. 

  870. 				$selids = implode(@$_REQUEST['subverticalDescription'],',');

    871. 

  871. 			} else {

    872. 

  872. 				$selids = @$_REQUEST['subverticalDescription'];

    873. 

  873. 			}

    874. 

  874. 			if (Yii::app()->functions->CheckCommaWithNumbers($selids)==true){

    875. 

  875. 				$subId = $selids;

    876. 

  876. 				} else {

    877. 

  877. 				$subId = 0;

    878. 

  878. 				}			

    879. 

  879. 			

    880. 

  880. 			if($this->action->id=='AllocateLeads' && $red == 1) {

    881. 

  881. 				$this->redirect(array('renewalleads/renlead_list&subId='.@$subId.'&period1='.@$_REQUEST['Renewallead']['expiryDate'].'&period2='.@$_REQUEST['Renewallead']['expiryDate2']));

    882. 

  882. 			}	else if($this->action->id=='AllocateLeads' && $red == 2) {

    883. 

  883. 				$this->redirect(array('renewalleads/renduplicate_lead_list'));

    884. 

  884. 			} else {

    885. 

  885. 			

    886. 

  886. 				$this->redirect(array('renewalleads/renfresh_leads&subId='.@$subId.'&period1='.@$_REQUEST['Renewallead']['expiryDate'].'&period2='.@$_REQUEST['Renewallead']['expiryDate2']));

    887. 

  887. 			}

    888. 

  888. 		//$this->redirect(array('leads/lead_list'));

    889. 

  889. 	}

    890. 

  890. 	/**

    891. 

  891. 	 * This is the 'lead_list_allocator' action that is invoked

    892. 

  892. 	 * when an action is not explicitly requested by users.

    893. 

  893. 	 */

    894. 

  894. 	public function actionlead_assign()

    895. 

  895. 	{

    896. 

  896. 		$model	=	new Renewallead();

    897. 

  897. 		$model->scenario = 'Lead';	

    898. 

  898. 		$leadId		=	$_REQUEST['AssignLead']['leadId'];

    899. 

  899. 		$userId		=	$_REQUEST['AssignLead']['userId'];

    900. 

  900. 		$assign		=	$_REQUEST['AssignLead']['assign'];

    901. 

  901. 		if($leadId!='') {

    902. 

  902. 		$updatedOn		=	time();	

    903. 

  903. 		$chkleadStatus = Renewallead::model()->findByPk($leadId);

    904. 

  904. 		$existsOrNot = $chkleadStatus['leadStatusId'];

    905. 

  905. 		$leadStatusIdUpdate = $existsOrNot?$existsOrNot:'34';

    906. 

  906. 		if($leadStatusIdUpdate == 34){

    907. 

  907. 		 $leadStatusIdUpdate = 35;

    908. 

  908. 		} else {

    909. 

  909. 		 $leadStatusIdUpdate = $leadStatusIdUpdate;

    910. 

  910. 		}

    911. 

  911. 		

    912. 

  912. 		if($assign=='open') { 

    913. 

  913. 		Renewallead::model()->updateByPk(@$leadId, array('currentAllocatedId'=>'','status'=>'Active','leadStatusId'=>34,'updatedBy'=>@$userId,'updatedOn'=>@$updatedOn,'currentAllocatedDate'=>''));

    914. 

  914. 		} elseif($assign=='self'){

    915. 

  915. 		Renewallead::model()->updateByPk(@$leadId, array('currentAllocatedId'=>@$userId,'status'=>'Allocated','leadStatusId'=>@$leadStatusIdUpdate,'updatedBy'=>@$userId,'updatedOn'=>@$updatedOn,'currentAllocatedDate'=>@$updatedOn));

    916. 

  916. 		} else {

    917. 

  917. 		Renewallead::model()->updateByPk(@$leadId, array('currentAllocatedId'=>@$assign,'status'=>'Allocated','leadStatusId'=>@$leadStatusIdUpdate,'updatedBy'=>@$userId,'updatedOn'=>@$updatedOn,'currentAllocatedDate'=>@$updatedOn));	

    918. 

  918. 		}	

    919. 

  919. 							 echo CJSON::encode(array(

    920. 

  920.                                   'status'=>'success'

    921. 

  921.                              ));

    922. 

  922.                             Yii::app()->end();

    923. 

  923. 			

    924. 

  924. 		//$this->redirect(array('leads/leads_details', 'leadId'=>@$leadId));

    925. 

  925. 		} else {

    926. 

  926. 		

    927. 

  927. 		$this->redirect(array('renwalleads/renlead_list'));

    928. 

  928. 		}

    929. 

  929. 	}

    930. 

  930. 	/**

    931. 

  931. 	 * This is the 'roles' action that is invoked

    932. 

  932. 	 * when an action is not explicitly requested by users.

    933. 

  933. 	 */

    934. 

  934. 	public function actionrenarchive_leads()

    935. 

  935. 	{

    936. 

  936. 		// renders the view file 'protected/views/site/index.php'

    937. 

  937. 		// using the default layout 'protected/views/layouts/main.php'

    938. 

  938. 			$model=new Renewallead();

    939. 

  939. 			$model=Renewallead::model()->findAll();

    940. 

  940. 		$this->render('archive_leads',array('model'=>$model));

    941. 

  941. 	}

    942. 

  942. 	

    943. 

  943. 		/**

    944. 

  944. 	 * This is the 'roles' action that is invoked

    945. 

  945. 	 * when an action is not explicitly requested by users.

    946. 

  946. 	 */

    947. 

  947. 	public function actionrenbulk_import_leads()

    948. 

  948. 	{

    949. 

  949. 		// renders the view file 'protected/views/site/index.php'

    950. 

  950. 		// using the default layout 'protected/views/layouts/main.php'

    951. 

  951. 		$model=new Renewallead();

    952. 

  952. 		$this->render('bulk_import_lead',array('model'=>$model));

    953. 

  953. 	}

    954. 

  954. 	

    955. 

  955. 	/**

    956. 

  956. 	 * This is the 'roles' action that is invoked

    957. 

  957. 	 * when an action is not explicitly requested by users.

    958. 

  958. 	 */

    959. 

  959. 	public function actionjunk_leads()

    960. 

  960. 	{

    961. 

  961. 		// renders the view file 'protected/views/site/index.php'

    962. 

  962. 		// using the default layout 'protected/views/layouts/main.php'

    963. 

  963. 		$this->render('junk_leads');

    964. 

  964. 	}	

    965. 

  965. 	/**

    966. 

  966. 	 * This is the 'module master' action that is invoked

    967. 

  967. 	 * when an action is not explicitly requested by users.

    968. 

  968. 	 */

    969. 

  969. 	public function actionmodule_master()

    970. 

  970. 	{

    971. 

  971. 		// renders the view file 'protected/views/site/index.php'

    972. 

  972. 		// using the default layout 'protected/views/layouts/main.php'

    973. 

  973. 		

    974. 

  974. 			$model=new ModuleMaster();

    975. 

  975. 			$model->scenario = 'ModuleMaster';

    976. 

  976. 			

    977. 

  977. 			if(!empty($_GET['moduleId']))

    978. 

  978. 			{

    979. 

  979. 				$moduleId=$_GET['moduleId'];

    980. 

  980. 				$model=ModuleMaster::model()->findByPk($moduleId);

    981. 

  981. 				

    982. 

  982. 			}

    983. 

  983. 			

    984. 

  984. 			if(!empty($_POST['ModuleMaster']['moduleId']))

    985. 

  985. 			{

    986. 

  986. 				$moduleId=$_POST['ModuleMaster']['moduleId'];

    987. 

  987. 				$model=ModuleMaster::model()->findByPk($moduleId);

    988. 

  988. 			}			

    989. 

  989. 			

    990. 

  990. 			if(isset($_POST['ModuleMaster']))

    991. 

  991. 			{			

    992. 

  992. 				 $model->setAttributes(array(

    993. 

  993.             			'createdOn' => time(), //additional data you want to insert

    994. 

  994.             			'updatedOn' => time(), //additional

    995. 

  995. 			 			'updatedBy' => time(), //additional

    996. 

  996. 			  			'createdBy' => time(),

    997. 

  997. 			  			'status' => 'Activated', //additional //additional

    998. 

  998. 

    999. 

  999.         		));			

    1000. 

  1000. 				foreach($_POST['ModuleMaster'] as $name=>$value)

    1001. 

  1001. 				{  

    1002. 

  1002. 					$model->$name=$value;			

    1003. 

  1003. 				}

    1004. 

  1004. 	

    1005. 

  1005. 				if($model->validate()){				

    1006. 

  1006. 					$model->save();

    1007. 

  1007. 					$model2=ModuleMaster::model()->findAll();	

    1008. 

  1008. 					$this->render('module_master',array('model'=>$model,'model2'=>$model2));				

    1009. 

  1009. 					Yii::app()->user->setFlash('module_master_msg_success','Successfully Inserted');

    1010. 

  1010. 				}	else			{

    1011. 

  1011. 					Yii::app()->user->setFlash('module_master_msg_error','Please check. error occured');

    1012. 

  1012. 					$this->render('module_master',array('model'=>$model));

    1013. 

  1013. 					

    1014. 

  1014. 				}			

    1015. 

  1015. 			}	else {

    1016. 

  1016. 					$model2=ModuleMaster::model()->findAll();

    1017. 

  1017. 					//Yii::app()->user->setFlash('lead_stage_msg_error','Please check. error occured');

    1018. 

  1018. 					$this->render('module_master',array('model'=>$model,'model2'=>$model2));

    1019. 

  1019. 			}	

    1020. 

  1020. 	}

    1021. 

  1021. 	/**

    1022. 

  1022. 	 * This is the action to handle external exceptions.

    1023. 

  1023. 	 */

    1024. 

  1024. 	public function actionError()

    1025. 

  1025. 	{

    1026. 

  1026. 		if($error=Yii::app()->errorHandler->error)

    1027. 

  1027. 		{

    1028. 

  1028. 			if(Yii::app()->request->isAjaxRequest)

    1029. 

  1029. 				echo $error['message'];

    1030. 

  1030. 			else

    1031. 

  1031. 				$this->render('error', $error);

    1032. 

  1032. 		}

    1033. 

  1033. 	}

    1034. 

  1034. 

    1035. 

  1035. 	/**

    1036. 

  1036. 	 * Displays the contact page

    1037. 

  1037. 	 */

    1038. 

  1038. 	public function actionContact()

    1039. 

  1039. 	{

    1040. 

  1040. 		$model=new ContactForm;

    1041. 

  1041. 		if(isset($_POST['ContactForm']))

    1042. 

  1042. 		{

    1043. 

  1043. 			$model->attributes=$_POST['ContactForm'];

    1044. 

  1044. 			if($model->validate())

    1045. 

  1045. 			{

    1046. 

  1046. 				$name='=?UTF-8?B?'.base64_encode($model->name).'?=';

    1047. 

  1047. 				$subject='=?UTF-8?B?'.base64_encode($model->subject).'?=';

    1048. 

  1048. 				$headers="From: $name <{$model->email}>\r\n".

    1049. 

  1049. 					"Reply-To: {$model->email}\r\n".

    1050. 

  1050. 					"MIME-Version: 1.0\r\n".

    1051. 

  1051. 					"Content-type: text/plain; charset=UTF-8";

    1052. 

  1052. 

    1053. 

  1053. 				mail(Yii::app()->params['adminEmail'],$subject,$model->body,$headers);

    1054. 

  1054. 				Yii::app()->user->setFlash('contact','Thank you for contacting us. We will respond to you as soon as possible.');

    1055. 

  1055. 				$this->refresh();

    1056. 

  1056. 			}

    1057. 

  1057. 		}

    1058. 

  1058. 		$this->render('contact',array('model'=>$model));

    1059. 

  1059. 	}

    1060. 

  1060. 

    1061. 

  1061. 	/**

    1062. 

  1062. 	 * Displays the login page

    1063. 

  1063. 	 */

    1064. 

  1064. 	public function actionLogin()

    1065. 

  1065. 	{

    1066. 

  1066. 		$model=new User;

    1067. 

  1067. 

    1068. 

  1068. 		// if it is ajax validation request

    1069. 

  1069. 		if(isset($_POST['ajax']) && $_POST['ajax']==='login-form')

    1070. 

  1070. 		{

    1071. 

  1071. 			echo CActiveForm::validate($model);

    1072. 

  1072. 			Yii::app()->end();

    1073. 

  1073. 		}

    1074. 

  1074. 

    1075. 

  1075. 		// collect user input data

    1076. 

  1076. 		if(isset($_POST['User']))

    1077. 

  1077. 		{

    1078. 

  1078. 		

    1079. 

  1079. 			$model->attributes=$_POST['User'];

    1080. 

  1080. 			// validate user input and redirect to the previous page if valid

    1081. 

  1081. 			if($model->validate() && $model->login()){

    1082. 

  1082. 				$this->redirect(array('masters/dashboard'));				

    1083. 

  1083. 				} else {

    1084. 

  1084. 				$this->redirect(Yii::app()->user->returnUrl);

    1085. 

  1085. 				}

    1086. 

  1086. 		}

    1087. 

  1087. 		// display the login form

    1088. 

  1088. 		$this->render('login',array('model'=>$model));

    1089. 

  1089. 	}

    1090. 

  1090. 

    1091. 

  1091. 	/**

    1092. 

  1092. 	 * Logs out the current user and redirect to homepage.

    1093. 

  1093. 	 */

    1094. 

  1094. 	public function actionLogout()

    1095. 

  1095. 	{

    1096. 

  1096. 		setcookie ('PHPSESSID', '', time(), '/', '', 0, 0); // Destroy the cookie.

    1097. 

  1097. 		Yii::app()->user->logout();

    1098. 

  1098. 		$this->redirect(Yii::app()->homeUrl);

    1099. 

  1099. 	}

    1100. 

  1100. 	public function getPageType()

    1101. 

  1101. 	{

    1102. 

  1102. 		return "Leads";

    1103. 

  1103. 	}

    1104. 

  1104. 	public function init(){

    1105. 

  1105. 		$obj =new RecentlyViewedController(); // preparing object

    1106. 

  1106. 	   $data=$obj->actionUserRoleAccess();

    1107. 

  1107. 		$moduleArray=array();

    1108. 

  1108. 			if(Yii::app()->session->get('type')=='superadmin'){

    1109. 

  1109. 				 $moduleArray['read']='yes';

    1110. 

  1110. 			 	 $moduleArray['write']='yes';

    1111. 

  1111. 			 	 $moduleArray['delete']='yes';

    1112. 

  1112. 		}else{

    1113. 

  1113. 			foreach($data as $key=>$value){

    1114. 

  1114. 			if($data[$key]->modules->moduleName=='Leads'){

    1115. 

  1115. 			 	 $moduleArray['moduleName']=$data[$key]->modules->moduleName;

    1116. 

  1116. 				 $moduleArray['read']=$data[$key]->read;

    1117. 

  1117. 			 	 $moduleArray['write']=$data[$key]->write;

    1118. 

  1118. 			 	 $moduleArray['delete']=$data[$key]->delete;

    1119. 

  1119. 			 }

    1120. 

  1120. 			 }

    1121. 

  1121. 		}

    1122. 

  1122. 		

    1123. 

  1123. 		return $moduleArray;

    1124. 

  1124. 

    1125. 

  1125. 	}

    1126. 

  1126. 	

    1127. 

  1127. 	public function getNameFromNumber($num) {

    1128. 

  1128. 		$numeric = $num % 26;

    1129. 

  1129. 		$letter = chr(65 + $numeric);

    1130. 

  1130. 		$num2 = intval($num / 26);

    1131. 

  1131. 		if ($num2 > 0) {

    1132. 

  1132. 			return getNameFromNumber($num2 - 1) . $letter;

    1133. 

  1133. 		} else {

    1134. 

  1134. 			return $letter;

    1135. 

  1135. 		}

    1136. 

  1136. 	}

    1137. 

  1137. 	/*function actionexportArchiveList()

    1138. 

  1138. 	{

    1139. 

  1139. 		// generate a resultset

    1140. 

  1140. 		$model=new User;

    1141. 

  1141. 		$model=User::model()->findAll();	

    1142. 

  1142. 		// render data to xlsx format and echo resultant file back to browser.

    1143. 

  1143. 		ExcelExporter::sendAsXLS($model, true, 'closedLeads.xls');

    1144. 

  1144. 	}*/

    1145. 

  1145. 	

    1146. 

  1146. 	public function actionDownloadLeadTemp(){

    1147. 

  1147. 	

    1148. 

  1148. 	  Yii::import('ext.phpexcel.XPHPExcel');    

    1149. 

  1149. 		  $objPHPExcel= XPHPExcel::createPHPExcel();

    1150. 

  1150. 		  $objPHPExcel->getProperties()->setCreator("LeadTemplate")

    1151. 

  1151. 								 ->setLastModifiedBy("LeadTemplate")

    1152. 

  1152. 								 ->setTitle("LeadTemplate")

    1153. 

  1153. 								 ->setSubject("LeadTemplate")

    1154. 

  1154. 								 ->setDescription("LeadTemplate.")

    1155. 

  1155. 								 ->setKeywords("LeadTemplate")

    1156. 

  1156. 								 ->setCategory("LeadTemplate");

    1157. 

  1157. 	 

    1158. 

  1158. 	//echo $total_excelColumns=$this->getNameFromNumber(4); 

    1159. 

  1159. 	$total_excelColumns='I'; 

    1160. 

  1160. 	// Rename worksheet

    1161. 

  1161. 	$objPHPExcel->getActiveSheet()->setTitle('ClosedLeads');

    1162. 

  1162. 	$objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(25);

    1163. 

  1163. 	$objPHPExcel->getActiveSheet()->getRowDimension(2)->setRowHeight(20);

    1164. 

  1164. 	$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(30);

    1165. 

  1165. 	$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(30);

    1166. 

  1166. 	$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(30);

    1167. 

  1167. 	$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(30);

    1168. 

  1168. 	$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(30);

    1169. 

  1169. 	$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(30);

    1170. 

  1170. 	$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(30);

    1171. 

  1171. 	$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(30);

    1172. 

  1172. 	$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(30);

    1173. 

  1173. 	$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(30);

    1174. 

  1174. 	$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(30);

    1175. 

  1175. 	$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(30);

    1176. 

  1176. 	$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(30);

    1177. 

  1177. 	$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(30);

    1178. 

  1178. 	$objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(30);

    1179. 

  1179. 	$objPHPExcel->getActiveSheet()->getColumnDimension('P')->setWidth(30);

    1180. 

  1180. 	$objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setWidth(30);

    1181. 

  1181. 	$objPHPExcel->getActiveSheet()->getColumnDimension('R')->setWidth(30);

    1182. 

  1182. 	$objPHPExcel->getActiveSheet()->getColumnDimension('S')->setWidth(30);

    1183. 

  1183. 	$objPHPExcel->getActiveSheet()->getColumnDimension('T')->setWidth(30);

    1184. 

  1184. 	$objPHPExcel->getActiveSheet()->getColumnDimension('U')->setWidth(30);

    1185. 

  1185. 	$objPHPExcel->getActiveSheet()->duplicateStyleArray(

    1186. 

  1186. 	array(

    1187. 

  1187. 	'font' => array(

    1188. 

  1188. 	'name'         => 'Times New Roman',

    1189. 

  1189. 	'bold'         => true,

    1190. 

  1190. 	'italic'    => false,

    1191. 

  1191. 	'size'        => 12

    1192. 

  1192. 	),

    1193. 

  1193. 	'borders' => array(

    1194. 

  1194. 	'top'        => array('style' => PHPExcel_Style_Border::BORDER_DOUBLE),

    1195. 

  1195. 	'bottom'    => array('style' => PHPExcel_Style_Border::BORDER_DOUBLE),

    1196. 

  1196. 	'left'        => array('style' => PHPExcel_Style_Border::BORDER_DOUBLE),

    1197. 

  1197. 	'right'        => array('style' => PHPExcel_Style_Border::BORDER_DOUBLE)

    1198. 

  1198. 	),

    1199. 

  1199. 	'alignment' => array(

    1200. 

  1200. 	'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,

    1201. 

  1201. 	'vertical'   => PHPExcel_Style_Alignment::VERTICAL_CENTER,

    1202. 

  1202. 	'wrap'       => true

    1203. 

  1203. 	)

    1204. 

  1204. 	),

    1205. 

  1205. 	'A1:U1'

    1206. 

  1206. 	);

    1207. 

  1207. 	// Set active sheet index to the first sheet, so Excel opens this as the first sheet

    1208. 

  1208. 	

    1209. 

  1209. 	// Add some data

    1210. 

  1210. 	$objPHPExcel->setActiveSheetIndex(0)

    1211. 

  1211. 				->setCellValue('A1', 'Renewal status')

    1212. 

  1212. 				->setCellValue('B1', 'NAME')

    1213. 

  1213. 				->setCellValue('C1', 'city')

    1214. 

  1214. 				->setCellValue('D1', 'expiry date')

    1215. 

  1215. 				->setCellValue('E1', 'CLNTNUM')

    1216. 

  1216. 				->setCellValue('F1', 'POLICY NO.')

    1217. 

  1217. 				->setCellValue('G1', 'BRANCH')

    1218. 

  1218. 				->setCellValue('H1', 'AGNTNUM')

    1219. 

  1219. 				->setCellValue('I1', 'AGTNAME')

    1220. 

  1220. 				->setCellValue('J1', 'CLAIMS')

    1221. 

  1221. 				->setCellValue('K1', 'TOTAMNT')

    1222. 

  1222. 				->setCellValue('L1', 'DOB')

    1223. 

  1223. 				->setCellValue('M1', 'GENDER')

    1224. 

  1224. 				->setCellValue('N1', 'AGE')

    1225. 

  1225. 				->setCellValue('O1', 'PLAN NAME')

    1226. 

  1226. 				->setCellValue('P1', 'COVER TYPE')

    1227. 

  1227. 				->setCellValue('Q1', 'RM Name')

    1228. 

  1228. 				->setCellValue('R1', 'SUB_VERTICAL_DESCRIPTION')

    1229. 

  1229. 				->setCellValue('S1', 'cust contact')

    1230. 

  1230. 				->setCellValue('T1', 'EMAIL')

    1231. 

  1231. 				->setCellValue('U1', 'POLICY SI');

    1232. 

  1232. 	 

    1233. 

  1233. 	// Miscellaneous glyphs, UTF-8

    1234. 

  1234. 	

    1235. 

  1235. 	//To create new sheet in current file 

    1236. 

  1236. 	/*$objPHPExcel->createSheet(1);

    1237. 

  1237. 	$objPHPExcel->setActiveSheetIndex(1);

    1238. 

  1238. 	$objPHPExcel->getActiveSheet()->setTitle('Title');

    1239. 

  1239. 	*/

    1240. 

  1240. 		

    1241. 

  1241. 	// Redirect output to a client’s web browser (Excel5)

    1242. 

  1242. 	header('Content-Type: application/vnd.ms-excel');

    1243. 

  1243. 	header('Content-Disposition: attachment;filename="LeadTemplates.xls"');

    1244. 

  1244. 	header('Cache-Control: max-age=0');

    1245. 

  1245. 	// If you're serving to IE 9, then the following may be needed

    1246. 

  1246. 	header('Cache-Control: max-age=1');

    1247. 

  1247. 	// If you're serving to IE over SSL, then the following may be needed

    1248. 

  1248. 	header ('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past

    1249. 

  1249. 	header ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); // always modified

    1250. 

  1250. 	header ('Cache-Control: cache, must-revalidate'); // HTTP/1.1

    1251. 

  1251. 	header ('Pragma: public'); // HTTP/1.0

    1252. 

  1252. 	 

    1253. 

  1253. 	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

    1254. 

  1254. 	$objWriter->save('php://output');

    1255. 

  1255. 		  Yii::app()->end();

    1256. 

  1256. 	}

    1257. 

  1257. 	public function actionrenImportLeadTemplate(){

    1258. 

  1258. 		$model=new Renewallead();

    1259. 

  1259. 		$data='';

    1260. 

  1260. 		$final_arr=@$_POST['final_arr']?@$_POST['final_arr']:'';

    1261. 

  1261. 		

    1262. 

  1262. 		if(isset($_POST['ImportLeads']) && empty($final_arr) && !empty($_FILES['Renewallead']['name']['import'])){

    1263. 

  1263. 		

    1264. 

  1264. 			Yii::import('ext.phpexcelreader.JPhpExcelReader');

    1265. 

  1265. 			$model->attributes='import';

    1266. 

  1266. 			$model->import=CUploadedFile::getInstance($model,'import'); 

    1267. 

  1267. 			$prefix=substr(time(),0,5);

    1268. 

  1268. 			$folder = '/tempdata';

    1269. 

  1269. 			$model->import->saveAs($folder.$prefix.$model->import);

    1270. 

  1270. 			$data=new JPhpExcelReader($folder.$prefix.$model->import);

    1271. 

  1271. 		

    1272. 

  1272. 			//$this->render('bulk_import_lead',array('data'=>$data,'model'=>$model));

    1273. 

  1273. 			

    1274. 

  1274. 			//$this->redirect(Yii::app()->createUrl('leads/bulk_import_leads'),array('data'=>$data,'model'=>$model));		

    1275. 

  1275. 			$this->render('bulk_import_lead',array('data'=>$data,'model'=>$model));

    1276. 

  1276. 		}

    1277. 

  1277. 		

    1278. 

  1278. 		if(isset($_POST['ImportLeads']) && !empty($final_arr) && isset($final_arr) && empty($_FILES['Renewallead']['name']['import'])){

    1279. 

  1279. 		$final_arr 	= unserialize(urldecode($_POST["final_arr"]));

    1280. 

  1280. 		$dateTime=time();

    1281. 

  1281. 			for($i=0;$i<sizeof($final_arr);$i++)

    1282. 

  1282. 				{	

    1283. 

  1283. 					$leadStatusId  		= '0';

    1284. 

  1284. 					$duplicateLeadId 	= '0';

    1285. 

  1285. 					$currentAllocatedId	= '0';

    1286. 

  1286. 					

    1287. 

  1287. 					$junkNumberQuery = Yii::app()->db->createCommand("SELECT `junkLeadNumberId` FROM `junkLeadNumberMaster` WHERE `junkLeadNumber` = '".@$final_arr[$i]['custPhone']."' ")->queryAll();

    1288. 

  1288. 					$junkNumberResult = $junkNumberQuery;

    1289. 

  1289. 					

    1290. 

  1290. 					//$duplicateQuery  = Yii::app()->db->createCommand("SELECT `leadId` FROM `lead` WHERE `mobile`= '".@$final_arr[$i]['mobile']."' ")->queryAll();(Original, changed below by Baljeet)

    1291. 

  1291. 					$duplicateQuery  = Yii::app()->db->createCommand("SELECT `leadId`,`currentAllocatedId` FROM `renewallead` WHERE `policyNumber`= '".@$final_arr[$i]['policyNumber']."'  order by leadId ASC LIMIT 1")->queryAll();

    1292. 

  1292. 					$duplicateResult = ($duplicateQuery);

    1293. 

  1293. 					//echo '<br>duplicateResult----------'.count($duplicateResult);

    1294. 

  1294. 					if(count($junkNumberResult) > 0){

    1295. 

  1295. 					$leadStatusId  = '36';

    1296. 

  1296. 					$duplicateLeadId = '';

    1297. 

  1297. 					$currentAllocatedId	= '';

    1298. 

  1298. 					} elseif(count($duplicateResult)>0){

    1299. 

  1299. 					$leadStatusId  = '10';

    1300. 

  1300. 					$duplicateLeadId	= @$duplicateResult[0]['leadId'];

    1301. 

  1301. 					$currentAllocatedId	= @$duplicateResult[0]['currentAllocatedId'];	//added by baljeet

    1302. 

  1302. 					} else {

    1303. 

  1303. 					$leadStatusId  = '34';

    1304. 

  1304. 					$duplicateLeadId = '';

    1305. 

  1305. 					$currentAllocatedId	= '';

    1306. 

  1306. 					}

    1307. 

  1307. 					$model=new Renewallead();

    1308. 

  1308. 					$model->email=$final_arr[$i]['renEmail'];

    1309. 

  1309. 					$model->mobile=$final_arr[$i]['custPhone'];

    1310. 

  1310. 					$model->age=$final_arr[$i]['age'];

    1311. 

  1311. 					$model->leadStatus…
    1312.

Large files files are truncated, but you can click here to view the full file