PageRenderTime 68ms CodeModel.GetById 13ms RepoModel.GetById 0ms app.codeStats 1ms

/lms_debug/protected/controllers/LeadsController_11dec2014.php

https://gitlab.com/badelal143/lms_debug
PHP | 3727 lines | 3051 code | 372 blank | 304 comment | 554 complexity | b2aaec71b70908335013c40e0a8879c4 MD5 | raw file
Possible License(s): LGPL-2.1, LGPL-3.0, LGPL-2.0 
    

  1. <?php

    2. 

  2. class LeadsController 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 actionlead_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. 		$this->render('lead_list');

    57. 

  57. 	}

    58. 

  58. 	

    59. 

  59. 	/**

    60. 

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

    61. 

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

    62. 

  62. 	 */

    63. 

  63. 	public function actionlead_list_allocator()

    64. 

  64. 	{

    65. 

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

    66. 

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

    67. 

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

    68. 

  68. 	}

    69. 

  69. 	/**

    70. 

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

    71. 

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

    72. 

  72. 	 */

    73. 

  73. 	public function actionfollowup_lead_list()

    74. 

  74. 	{

    75. 

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

    76. 

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

    77. 

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

    78. 

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

    79. 

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

    80. 

  80. 		} else {	

    81. 

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

    82. 

  82. 		}	

    83. 

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

    84. 

  84. 

    85. 

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

    86. 

  86. 	}

    87. 

  87. 	public function actionfollowup_overall_lead_list()

    88. 

  88. 	{

    89. 

  89. 	

    90. 

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

    91. 

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

    92. 

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

    93. 

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

    94. 

  94. 		} else {	

    95. 

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

    96. 

  96. 		}	

    97. 

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

    98. 

  98. 

    99. 

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

    100. 

  100. 	}

    101. 

  101. 	

    102. 

  102. 	/**

    103. 

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

    104. 

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

    105. 

  105. 	 */

    106. 

  106. 	public function actionlead_list_tc()

    107. 

  107. 	{

    108. 

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

    109. 

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

    110. 

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

    111. 

  111. 	}

    112. 

  112. 	/**

    113. 

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

    114. 

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

    115. 

  115. 	 */

    116. 

  116. 	public function actionjunk_lead_list()

    117. 

  117. 	{

    118. 

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

    119. 

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

    120. 

  120. 	}

    121. 

  121. 	/**

    122. 

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

    123. 

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

    124. 

  124. 	 */

    125. 

  125. 	public function actionduplicate_lead_list()

    126. 

  126. 	{

    127. 

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

    128. 

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

    129. 

  129. 	}

    130. 

  130. 	public function actionclose_lead_list()

    131. 

  131. 	{

    132. 

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

    133. 

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

    134. 

  134. 	}

    135. 

  135. 	/**

    136. 

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

    137. 

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

    138. 

  138. 	 */

    139. 

  139. 	public function actionallocated_lead_list()

    140. 

  140. 	{

    141. 

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

    142. 

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

    143. 

  143. 		

    144. 

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

    145. 

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

    146. 

  146. 		} else {	

    147. 

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

    148. 

  148. 		}

    149. 

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

    150. 

  150. 		$this->render('allocated_lead_list');

    151. 

  151. 	}

    152. 

  152. 	/**

    153. 

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

    154. 

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

    155. 

  155. 	 */

    156. 

  156. 	public function actionleads_details()

    157. 

  157. 	{

    158. 

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

    159. 

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

    160. 

  160. 		

    161. 

  161. 		//for follow up

    162. 

  162. 		$parser = new CHtmlPurifier();

    163. 

  163. 		if(isset($_POST['LeadFollowup'])){

    164. 

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

    165. 

  165. 		 $res = $this->actionlead_followup(@$_POST['LeadFollowup'],$parser->purify(intval(@$_POST['Lead']['leadStatusId'])));

    166. 

  166. 		 $decodeRes = json_decode($res);

    167. 

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

    168. 

  168. 			echo CJSON::encode(array(

    169. 

  169.                                   'status'=>'success'

    170. 

  170.                              ));

    171. 

  171. 			} else {

    172. 

  172. 			echo $res;

    173. 

  173. 			 

    174. 

  174. 			}

    175. 

  175. 		 }

    176. 

  176. 		}

    177. 

  177. 		

    178. 

  178. 		$leadFollDesc = @$_POST['LeadFollowup']['description'];

    179. 

  179. 		// end of for follow ups	

    180. 

  180. 		$leadId	=	$parser->purify(intval(@$_GET['leadId'])); 

    181. 

  181. 		$actionId = $parser->purify(intval(@$_REQUEST['actionId']));

    182. 

  182. 		$actionmodel=LeadFollowup::model()->findByPk($actionId);

    183. 

  183. 		$model	=	new Lead();	

    184. 

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

    185. 

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

    186. 

  186. 		

    187. 

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

    188. 

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

    189. 

  189. 		$allocatedArr=array();

    190. 

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

    191. 

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

    192. 

  192. 		}

    193. 

  193. 		//print_r($allocatedArr);

    194. 

  194. 		//die;

    195. 

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

    196. 

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

    197. 

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

    198. 

  198. 			}

    199. 

  199. 		}*/

    200. 

  200. 		

    201. 

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

    202. 

  202. 			$model=Lead::model()->findByPk($leadId);		

    203. 

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

    204. 

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

    205. 

  205. 					$recentlyViewed = new recentlyViewed;

    206. 

  206. 					  $recentlyViewed->setAttributes(array(

    207. 

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

    208. 

  208. 							'leadId' => $leadId, 

    209. 

  209. 							'moduleId' => 0, 

    210. 

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

    211. 

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

    212. 

  212. 					));

    213. 

  213. 					

    214. 

  214. 					$recentlyViewed->save(false);

    215. 

  215. 				}

    216. 

  216. 		}

    217. 

  217. 		if(isset($_POST['Lead']))

    218. 

  218. 			{	

    219. 

  219. 			

    220. 

  220. 			if($_POST['LeadFollowup']['startDate']!='') {

    221. 

  221. 					$finalLeadDesc = @$leadFollDesc;

    222. 

  222. 				} else {

    223. 

  223. 					$finalLeadDesc = @$_POST['Lead']['leadDescription'];

    224. 

  224. 				}	

    225. 

  225. 				$model->setAttributes(array(

    226. 

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

    227. 

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

    228. 

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

    229. 

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

    230. 

  230.         		));	

    231. 

  231. 				$prevLeadStatusId=$model->leadStatusId;	

    232. 

  232. 				

    233. 

  233. 				foreach($_POST['Lead'] as $name=>$value)

    234. 

  234. 				{  

    235. 

  235. 				

    236. 

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

    237. 

  237. 						$model->leadStatusId=$model->leadStatusParentId;			

    238. 

  238. 					}

    239. 

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

    240. 

  240. 						$model->email='';			

    241. 

  241. 					}

    242. 

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

    243. 

  243. 						$model->name='';			

    244. 

  244. 					}

    245. 

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

    246. 

  246. 						$model->address='';			

    247. 

  247. 					}

    248. 

  248. 					if($model->ws_proposalid=='Proposal No.'){

    249. 

  249. 						$model->ws_proposalid='';			

    250. 

  250. 					}

    251. 

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

    252. 

  252. 					 $model->children='';

    253. 

  253. 					} 

    254. 

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

    255. 

  255. 					 $model->ageGroup='';

    256. 

  256. 					} 

    257. 

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

    258. 

  258. 					 $model->leadDescription='';

    259. 

  259. 					} 

    260. 

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

    261. 

  261. 					 $model->leadStatusId=$prevLeadStatusId;

    262. 

  262. 					}

    263. 

  263. 						

    264. 

  264. 					

    265. 

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

    266. 

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

    267. 

  267. 					}

    268. 

  268. 					

    269. 

  269. 

    270. 

  270. 					if(is_array($value)){

    271. 

  271. 					 $value = '';

    272. 

  272. 					} else {

    273. 

  273. 					 $value = $value;

    274. 

  274. 					}

    275. 

  275. 					$model->$name=$parser->purify($value);

    276. 

  276. 				}

    277. 

  277. 								if($model->leadStatusParentId=='1'){

    278. 

  278. 					 $model->salesClosedUpdatedOn=time();

    279. 

  279. 					}

    280. 

  280. 

    281. 

  281. 						$fetchAgentDetails=LeadSourceMaster::model()->findByPk($model->leadSourceId);

    282. 

  282. 				

    283. 

  283. 				$model->agentId = @$fetchAgentDetails->leadSourceCode;

    284. 

  284. 				$model->ws_agentid = @$fetchAgentDetails->leadSourceCode;

    285. 

  285. 	

    286. 

  286. 			

    287. 

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

    288. 

  288. 				

    289. 

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

    290. 

  290. 				}

    291. 

  291. 				

    292. 

  292. 								$chkStatusMandatoryOrNot = leadStatus::model()->findByAttributes(array('leadStatusId'=>$model->leadStatusId));

    293. 

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

    294. 

  294. 						$model->scenario = 'salesclosed';

    295. 

  295. 						}

    296. 

  296. 					

    297. 

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

    298. 

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

    299. 

  299. 					

    300. 

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

    301. 

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

    302. 

  302. 						

    303. 

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

    304. 

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

    305. 

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

    306. 

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

    307. 

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

    308. 

  308. 									

    309. 

  309. 						

    310. 

  310. 					$modelHistory	=	new LeadHistory();	

    311. 

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

    312. 

  312. 						

    313. 

  313. 					$modelHistory->setAttributes(array(

    314. 

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

    315. 

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

    316. 

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

    317. 

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

    318. 

  318. 							'leadDescription' => @$finalLeadDesc, 

    319. 

  319. 							

    320. 

  320. 					));			

    321. 

  321. 					foreach($_POST['Lead'] as $name1=>$value1)

    322. 

  322. 					{  

    323. 

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

    324. 

  324. 							$modelHistory->leadStatusId=$modelHistory->leadStatusParentId;			

    325. 

  325. 						}

    326. 

  326. 						if(@$_POST['LeadFollowup']['description']=='Description'){

    327. 

  327. 							$activitydesc = '';

    328. 

  328. 						} else {

    329. 

  329. 							$activitydesc = @$_POST['LeadFollowup']['description'];

    330. 

  330. 						}

    331. 

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

    332. 

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

    333. 

  333. 						 $model->leadStatusId=2;

    334. 

  334. 						}

    335. 

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

    336. 

  336. 							$modelHistory->email='';			

    337. 

  337. 						}

    338. 

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

    339. 

  339. 							$modelHistory->name='';			

    340. 

  340. 						}

    341. 

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

    342. 

  342. 							$modelHistory->address='';			

    343. 

  343. 						}

    344. 

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

    345. 

  345. 						 $modelHistory->leadDescription='';

    346. 

  346. 						} 

    347. 

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

    348. 

  348. 						 $modelHistory->children='';

    349. 

  349. 						} 

    350. 

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

    351. 

  351. 						 $modelHistory->ageGroup='';

    352. 

  352. 						} 

    353. 

  353. 						if(is_array($value1)){

    354. 

  354. 						 $value1 = '';

    355. 

  355. 						} else {

    356. 

  356. 						 $value1 = $value1;

    357. 

  357. 						}

    358. 

  358. 						

    359. 

  359. 						$modelHistory->$name1=$parser->purify($value1);			

    360. 

  360. 					}						

    361. 

  361. 					$model->save(false);

    362. 

  362. 					$modelHistory->save();

    363. 

  363. 					  CJSON::encode(array(

    364. 

  364.                                   'status'=>'success'

    365. 

  365.                              ));

    366. 

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

    367. 

  367. 					  }

    368. 

  368. 					}

    369. 

  369. 				}

    370. 

  370.  				

    371. 

  371. 				$model->save();

    372. 

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

    373. 

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

    374. 

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

    375. 

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

    376. 

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

    377. 

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

    378. 

  378. 									

    379. 

  379. 						

    380. 

  380. 					$modelHistory	=	new LeadHistory();	

    381. 

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

    382. 

  382. 					$modelHistory->setAttributes(array(

    383. 

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

    384. 

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

    385. 

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

    386. 

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

    387. 

  387. 							'leadDescription' => @$finalLeadDesc, 

    388. 

  388. 							

    389. 

  389. 					));			

    390. 

  390. 					foreach($_POST['Lead'] as $name1=>$value1)

    391. 

  391. 					{  

    392. 

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

    393. 

  393. 							$modelHistory->leadStatusId=$modelHistory->leadStatusParentId;			

    394. 

  394. 						}

    395. 

  395. 						$modelHistory->activityDescription=@$_POST['LeadFollowup']['description'];

    396. 

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

    397. 

  397. 						 $model->leadStatusId=2;

    398. 

  398. 						}

    399. 

  399. 						if(is_array($value1)){

    400. 

  400. 						 $value1 = '';

    401. 

  401. 						} else {

    402. 

  402. 						 $value1 = $value1;

    403. 

  403. 						}

    404. 

  404. 						$modelHistory->$name1=$parser->purify($value1);			

    405. 

  405. 					}						

    406. 

  406. 					

    407. 

  407. 					$modelHistory->save();

    408. 

  408. 					 echo CJSON::encode(array(

    409. 

  409.                                   'status'=>'success'

    410. 

  410.                              ));

    411. 

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

    412. 

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

    413. 

  413. 					//die;

    414. 

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

    415. 

  415. 				} else {

    416. 

  416. 				

    417. 

  417. 				

    418. 

  418. 				 @$error = CActiveForm::validate(@$model);

    419. 

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

    420. 

  420.                                     echo @$error;

    421. 

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

    422. 

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

    423. 

  423. 				}

    424. 

  424. 			}	else {

    425. 

  425. 					

    426. 

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

    427. 

  427. 			}	

    428. 

  428. 	}

    429. 

  429. 	protected function performAjaxValidation($models)

    430. 

  430. 	{

    431. 

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

    432. 

  432. 		{

    433. 

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

    434. 

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

    435. 

  435. 		}

    436. 

  436. 	}

    437. 

  437. 	/**

    438. 

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

    439. 

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

    440. 

  440. 	 */

    441. 

  441. 	public function actionlead_followup()

    442. 

  442. 	{

    443. 

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

    444. 

  444. 		$model	=	new LeadFollowup();	

    445. 

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

    446. 

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

    447. 

  447. 		$model=LeadFollowup::model()->findByPk($actionId);	

    448. 

  448. 		} else {

    449. 

  449. 		

    450. 

  450. 		}

    451. 

  451. 	

    452. 

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

    453. 

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

    454. 

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

    455. 

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

    456. 

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

    457. 

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

    458. 

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

    459. 

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

    460. 

  460. 		} 

    461. 

  461. 		$parser = new CHtmlPurifier();

    462. 

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

    463. 

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

    464. 

  464. 			{

    465. 

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

    466. 

  466. 				 $followupstartdatewithtime = strtotime(@$_POST['LeadFollowup']['startDate'])+(@$_POST['LeadFollowup']['hour']*60*60)+(@$_POST['LeadFollowup']['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.         		));

    475. 

  475. 				foreach($_POST['LeadFollowup'] as $name=>$value)

    476. 

  476. 				{

    477. 

  477. 					if(is_array($value)){

    478. 

  478. 					 $value = '';

    479. 

  479. 					} else {

    480. 

  480. 					 $value = $value;

    481. 

  481. 					}

    482. 

  482. 				

    483. 

  483. 					$model->$name=$parser->purify($value);															

    484. 

  484. 				}

    485. 

  485. 				$model->leadStatusId=@$_POST['Lead']['leadStatusId'];;	

    486. 

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

    487. 

  487. 				if(@$_POST['LeadFollowup']['actionType']=='Notes') {

    488. 

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

    489. 

  489. 				 	$folder = 'siteupload/';

    490. 

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

    491. 

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

    492. 

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

    493. 

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

    494. 

  494. 				}				

    495. 

  495. 				if(@$_POST['LeadFollowup']['startDate']!='') { 

    496. 

  496. 					$startDateVal = strtotime($_POST['LeadFollowup']['startDate']); 

    497. 

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

    498. 

  498. 				}

    499. 

  499. 				if(@$_POST['LeadFollowup']['taskDueDate']!='') { 

    500. 

  500. 					$taskDueDateVal = strtotime($_POST['LeadFollowup']['taskDueDate']); 

    501. 

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

    502. 

  502. 				}

    503. 

  503. 				if(@$_POST['LeadFollowup']['taskCompleted']!='') {

    504. 

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

    505. 

  505. 				}	

    506. 

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

    507. 

  507. 				

    508. 

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

    509. 

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

    510. 

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

    511. 

  511. 				}

    512. 

  512. 					$model->save();

    513. 

  513. 					$leadId = $_POST['LeadFollowup']['leadId'];

    514. 

  514. 					return  CJSON::encode(array(

    515. 

  515. 										  'status'=>'success'

    516. 

  516. 									 ));

    517. 

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

    518. 

  518. 				} else {

    519. 

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

    520. 

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

    521. 

  521. 										return $error;

    522. 

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

    523. 

  523. 				}

    524. 

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

    525. 

  525. 		}

    526. 

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

    527. 

  527. 	}

    528. 

  528. 	/**

    529. 

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

    530. 

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

    531. 

  531. 	 */

    532. 

  532. 	public function actionlead_followupcalender()

    533. 

  533. 	{

    534. 

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

    535. 

  535. 		$model	=	new LeadFollowup();	

    536. 

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

    537. 

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

    538. 

  538. 		$model=LeadFollowup::model()->findByPk($actionId);	

    539. 

  539. 		} else {

    540. 

  540. 		

    541. 

  541. 		}

    542. 

  542. 	

    543. 

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

    544. 

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

    545. 

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

    546. 

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

    547. 

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

    548. 

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

    549. 

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

    550. 

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

    551. 

  551. 		} 

    552. 

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

    553. 

  553. 		if(isset($_POST['LeadFollowup']))

    554. 

  554. 			{

    555. 

  555. 				$userId = $_POST['LeadFollowup']['userId'];

    556. 

  556. 				$model->setAttributes(array(

    557. 

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

    558. 

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

    559. 

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

    560. 

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

    561. 

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

    562. 

  562.         		));

    563. 

  563. 				foreach($_POST['LeadFollowup'] as $name=>$value)

    564. 

  564. 				{

    565. 

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

    566. 

  566. 				}

    567. 

  567. 				$model->leadStatusId=@$_POST['Lead']['leadStatusId'];;	

    568. 

  568. 				if(@$_POST['LeadFollowup']['actionType']=='Notes') {

    569. 

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

    570. 

  570. 				 	$folder = 'siteupload/';

    571. 

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

    572. 

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

    573. 

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

    574. 

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

    575. 

  575. 				}				

    576. 

  576. 				if(@$_POST['LeadFollowup']['startDate']!='') { 

    577. 

  577. 					$startDateVal = strtotime($_POST['LeadFollowup']['startDate']); 

    578. 

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

    579. 

  579. 				}

    580. 

  580. 				if(@$_POST['LeadFollowup']['taskDueDate']!='') { 

    581. 

  581. 					$taskDueDateVal = strtotime($_POST['LeadFollowup']['taskDueDate']); 

    582. 

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

    583. 

  583. 				}

    584. 

  584. 				if(@$_POST['LeadFollowup']['taskCompleted']!='') {

    585. 

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

    586. 

  586. 				}	

    587. 

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

    588. 

  588. 					$model->save();

    589. 

  589. 					$leadId = $_POST['LeadFollowup']['leadId'];

    590. 

  590. 					echo  CJSON::encode(array(

    591. 

  591. 										  'status'=>'success'

    592. 

  592. 									 ));

    593. 

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

    594. 

  594. 				} else {

    595. 

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

    596. 

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

    597. 

  597. 										return $error;

    598. 

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

    599. 

  599. 				}

    600. 

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

    601. 

  601. 		}

    602. 

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

    603. 

  603. 	}

    604. 

  604. 

    605. 

  605. 

    606. 

  606. 	public function actionlead_contacts()

    607. 

  607. 	{

    608. 

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

    609. 

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

    610. 

  610. 		$model	=	new LeadContacts();	

    611. 

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

    612. 

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

    613. 

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

    614. 

  614. 		{

    615. 

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

    616. 

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

    617. 

  617. 		}		

    618. 

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

    619. 

  619. 		{

    620. 

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

    621. 

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

    622. 

  622. 		}

    623. 

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

    624. 

  624. 			{

    625. 

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

    626. 

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

    627. 

  627. 				$model->setAttributes(array(

    628. 

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

    629. 

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

    630. 

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

    631. 

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

    632. 

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

    633. 

  633.         		));

    634. 

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

    635. 

  635. 				{

    636. 

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

    637. 

  637. 				}			

    638. 

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

    639. 

  639. 				$model->save();

    640. 

  640. 				 echo CJSON::encode(array(

    641. 

  641. 							  'status'=>'success'

    642. 

  642. 						 ));

    643. 

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

    644. 

  644. 				} else {

    645. 

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

    646. 

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

    647. 

  647. 						echo $error;

    648. 

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

    649. 

  649. 

    650. 

  650. 				}		

    651. 

  651. 			

    652. 

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

    653. 

  653. 		}

    654. 

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

    655. 

  655. 	}

    656. 

  656. 	public function actionChangeContactStatus()

    657. 

  657. 	{

    658. 

  658. 	 

    659. 

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

    660. 

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

    661. 

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

    662. 

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

    663. 

  663. 		$status="Active";

    664. 

  664. 		} else {

    665. 

  665. 			$status="Inactive";

    666. 

  666. 		}

    667. 

  667. 		if(!empty($Id))

    668. 

  668. 		{

    669. 

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

    670. 

  670. 		}

    671. 

  671. 		else

    672. 

  672. 		{

    673. 

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

    674. 

  674. 		}

    675. 

  675. 		$model->status=$status;

    676. 

  676. 		$model->save();

    677. 

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

    678. 

  678. 	}	

    679. 

  679. 	/**

    680. 

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

    681. 

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

    682. 

  682. 	 */

    683. 

  683. 	public function actioncreate_lead()

    684. 

  684. 	{

    685. 

  685. 			$model=new Lead();

    686. 

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

    687. 

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

    688. 

  688. 			{

    689. 

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

    690. 

  690. 				$model=Lead::model()->findByPk($leadId);

    691. 

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

    692. 

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

    693. 

  693. 					$recentlyViewed = new recentlyViewed;

    694. 

  694. 					  $recentlyViewed->setAttributes(array(

    695. 

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

    696. 

  696. 							'leadId' => $leadId, 

    697. 

  697. 							'moduleId' => 0, 

    698. 

  698. 							'createdOn' => time(), 

    699. 

  699. 							'updatedOn' => time(), 

    700. 

  700. 							'updatedBy' => time(), 

    701. 

  701. 							'createdBy' => time(),						

    702. 

  702. 					));

    703. 

  703. 					

    704. 

  704. 					$recentlyViewed->save(false);

    705. 

  705. 				}

    706. 

  706. 			}

    707. 

  707. 			if(!empty($_POST['Lead']['leadId']))

    708. 

  708. 			{

    709. 

  709. 				$leadId=$_POST['Lead']['leadId'];

    710. 

  710. 				$model=Lead::model()->findByPk($leadId);

    711. 

  711. 			}		

    712. 

  712. 			if(isset($_POST['Lead']))

    713. 

  713. 			{	

    714. 

  714. 			

    715. 

  715. 				  $model->setAttributes(array(

    716. 

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

    717. 

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

    718. 

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

    719. 

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

    720. 

  720.         		));

    721. 

  721. 				foreach($_POST['Lead'] as $name=>$value)

    722. 

  722. 				{ 

    723. 

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

    724. 

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

    725. 

  725. 						 $model->leadStatusId=$model->leadStatusParentId;			

    726. 

  726. 					}

    727. 

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

    728. 

  728. 					 $model->leadStatusId=34;

    729. 

  729. 					}

    730. 

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

    731. 

  731. 						$model->mobile='';			

    732. 

  732. 					}

    733. 

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

    734. 

  734. 						$model->email='';			

    735. 

  735. 					}

    736. 

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

    737. 

  737. 						$model->name='';			

    738. 

  738. 					}

    739. 

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

    740. 

  740. 						$model->address='';			

    741. 

  741. 					}

    742. 

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

    743. 

  743. 					 $model->children='';

    744. 

  744. 					} 

    745. 

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

    746. 

  746. 					 $model->ageGroup='';

    747. 

  747. 					} 

    748. 

  748. 				}

    749. 

  749. 					if($model->leadStatusParentId=='1'){

    750. 

  750. 					 $model->salesClosedUpdatedOn=time();

    751. 

  751. 					}

    752. 

  752. 				

    753. 

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

    754. 

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

    755. 

  755. 				}

    756. 

  756. 				$fetchAgentDetails=LeadSourceMaster::model()->findByPk($model->leadSourceId);

    757. 

  757. 				

    758. 

  758. 				$model->agentId = @$fetchAgentDetails->leadSourceCode;

    759. 

  759. 				$model->ws_agentid = @$fetchAgentDetails->leadSourceCode;

    760. 

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

    761. 

  761. 						 @$model->leadStatusId=35;

    762. 

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

    763. 

  763. 					}

    764. 

  764. 

    765. 

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

    766. 

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

    767. 

  767. 				}

    768. 

  768. 

    769. 

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

    770. 

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

    771. 

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

    772. 

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

    773. 

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

    774. 

  774. 				$chkStatusMandatoryOrNot = leadStatus::model()->findByAttributes(array('leadStatusId'=>$model->leadStatusId));

    775. 

  775. 				

    776. 

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

    777. 

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

    778. 

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

    779. 

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

    780. 

  780. 								

    781. 

  781. 					$mobileNumber	=	@$_POST['Lead']['mobile'];				

    782. 

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

    783. 

  783. 					if(empty($checkJunkNumber)){

    784. 

  784. 						$beforethreemonth = time()-7776000;

    785. 

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

    786. 

  786. 						if(empty($checkDuplicateNumber)){

    787. 

  787. 						

    788. 

  788. 							$model->save(false);

    789. 

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

    790. 

  790. 						} else {

    791. 

  791. 							$duplicateLeadId = $checkDuplicateNumber->leadId;

    792. 

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

    793. 

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

    794. 

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

    795. 

  795. 							$model->save(false);

    796. 

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

    797. 

  797. 						}

    798. 

  798. 					} else {

    799. 

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

    800. 

  800. 						$model->save(false);

    801. 

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

    802. 

  802. 					}

    803. 

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

    804. 

  804. 				

    805. 

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

    806. 

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

    807. 

  807. 					  }

    808. 

  808. 					}

    809. 

  809. 				}

    810. 

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

    811. 

  811. 			 $model->save(false);

    812. 

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

    813. 

  813. 			 } else {

    814. 

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

    815. 

  815. 					$mobileNumber	=	$_POST['Lead']['mobile'];				

    816. 

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

    817. 

  817. 					if(empty($checkJunkNumber)){

    818. 

  818. 						$beforethreemonth = time()-7776000;

    819. 

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

    820. 

  820. 						if(empty($checkDuplicateNumber)){

    821. 

  821. 						

    822. 

  822. 							$model->save();

    823. 

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

    824. 

  824. 						} else {

    825. 

  825. 							$duplicateLeadId = $checkDuplicateNumber->leadId;

    826. 

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

    827. 

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

    828. 

  828. 							$model->save();

    829. 

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

    830. 

  830. 						}

    831. 

  831. 					} else {

    832. 

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

    833. 

  833. 						$model->save();

    834. 

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

    835. 

  835. 					}

    836. 

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

    837. 

  837. 				}	else {

    838. 

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

    839. 

  839. 				}	

    840. 

  840. 			 }		

    841. 

  841. 			}	else {

    842. 

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

    843. 

  843. 			}	

    844. 

  844. 	}

    845. 

  845. 	public function actionAllocateLeads()

    846. 

  846. 	{

    847. 

  847. 	          

    848. 

  848. 

    849. 

  849.         $Id                                  = $_REQUEST['userids'];

    850. 

  850. 

    851. 

  851.         $teamId                       = @$_REQUEST['Team']['teamId'];

    852. 

  852. 

    853. 

  853.         $userId                         = $_REQUEST['Team']['teamMemberId'];

    854. 

  854. 

    855. 

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

    856. 

  856. 

    857. 

  857.         $updatedOn  = time();

    858. 

  858. 

    859. 

  859.         

    860. 

  860. 

    861. 

  861.         $teamIdString = '';

    862. 

  862. 

    863. 

  863.         if($teamId)

    864. 

  864. 

    865. 

  865.         {

    866. 

  866. 

    867. 

  867.             $teamIdString = ',teamId = ' . $teamId . ', ';

    868. 

  868. 

    869. 

  869.         }

    870. 

  870. 

    871. 

  871.         foreach($Id as $key => $value)

    872. 

  872. 

    873. 

  873.         {

    874. 

  874. 

    875. 

  875.             $commonQueryString    = ", updatedBy = $updatedBy, updatedOn = $updatedOn where leadId = $value";            

    876. 

  876. 

    877. 

  877.             $updateLead           = "update lead set currentAllocatedId = $userId, leadStatusId = 35, currentAllocatedDate = $updatedOn $commonQueryString";

    878. 

  878. 

    879. 

  879.             Yii::app()->db->createCommand($updateLead)->execute();

    880. 

  880. 

    881. 

  881.         }

    882. 

  882. 

    883. 

  883.         

    884. 

  884. 

    885. 

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

    886. 

  886. 

    887. 

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

    888. 

  888. 

    889. 

  889.         {

    890. 

  890. 

    891. 

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

    892. 

  892. 

    893. 

  893.         }

    894. 

  894. 

    895. 

  895.         $this->redirect(array('leads/fresh_leads'));

    896. 

  896. 

    897. 

  897.     

    898. 

  898. }

    899. 

  899. 	public function actionAllocateLeads_17nov2014()

    900. 

  900. 	{		

    901. 

  901. 		$Id			=	$_REQUEST['userids'];

    902. 

  902. 		$teamId		=	@$_REQUEST['Team']['teamId'];

    903. 

  903. 		$userId		=	$_REQUEST['Team']['teamMemberId'];

    904. 

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

    905. 

  905. 		

    906. 

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

    907. 

  907. 			$model	=	new AllocatedLeads();

    908. 

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

    909. 

  909. 			$model->setAttributes(array(

    910. 

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

    911. 

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

    912. 

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

    913. 

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

    914. 

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

    915. 

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

    916. 

  916. 			));				

    917. 

  917. 			$leadId = @$value;

    918. 

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

    919. 

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

    920. 

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

    921. 

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

    922. 

  922. 			$model->allocatedId = null;

    923. 

  923. 			$model->isNewRecord = true;

    924. 

  924. 			$model->save();			

    925. 

  925. 			$model=new Lead();

    926. 

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

    927. 

  927. 			$updatedOn		=	time();

    928. 

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

    929. 

  929. 			}

    930. 

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

    931. 

  931. 			

    932. 

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

    933. 

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

    934. 

  934. 			} else {

    935. 

  935. 				$this->redirect(array('leads/fresh_leads'));

    936. 

  936. 			}

    937. 

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

    938. 

  938. 	}

    939. 

  939. 	

    940. 

  940. 	public function actionAllocateLeadswithcount()

    941. 

  941. 	{		

    942. 

  942. 		$Id			=	$_REQUEST['userids'];

    943. 

  943. 		$teamId		=	@$_REQUEST['Team']['teamId'];

    944. 

  944. 		$userId		=	$_REQUEST['Team']['teamMemberId'];

    945. 

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

    946. 

  946. 		

    947. 

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

    948. 

  948. 			$model	=	new AllocatedLeads();

    949. 

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

    950. 

  950. 			$model->setAttributes(array(

    951. 

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

    952. 

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

    953. 

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

    954. 

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

    955. 

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

    956. 

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

    957. 

  957. 			));				

    958. 

  958. 			$leadId = @$value;

    959. 

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

    960. 

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

    961. 

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

    962. 

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

    963. 

  963. 			$model->allocatedId = null;

    964. 

  964. 			$model->isNewRecord = true;

    965. 

  965. 			$model->save();			

    966. 

  966. 			

    967. 

  967. 			

    968. 

  968. 			

    969. 

  969. 			

    970. 

  970. 			

    971. 

  971. 			$model=new Lead();

    972. 

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

    973. 

  973. 			$updatedOn		=	time();

    974. 

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

    975. 

  975. 			}

    976. 

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

    977. 

  977. 			

    978. 

  978. 			$chkleadAllocatedOrNot = Lead::model()->findByPk($leadId);

    979. 

  979. 			$oldallocatedid = $chkleadAllocatedOrNot['currentAllocatedId'];	

    980. 

  980. 			if(isset($oldallocatedid) && !empty($oldallocatedid)){

    981. 

  981. 					 

    982. 

  982. 				$checkLeadExistorNot=Leadallcount::model()->findByAttributes(array('userid'=>$oldallocatedid,'key'=>'2014'));	

    983. 

  983. 				

    984. 

  984. 				if(count($checkLeadExistorNot) > 0){

    985. 

  985. 					

    986. 

  986. 				Leadallcount::model()->updateByPk(@$checkLeadExistorNot['id'], array('userid'=>@$oldallocatedid,'key'=>'2014','value'=>'35','updatedBy'=>@$updatedBy,'updatedOn'=>@$updatedOn,'currentAllocatedDate'=>@$updatedOn));	

    987. 

  987. 						

    988. 

  988. 				} else {

    989. 

  989. 				$leadcount = new Leadallcount();

    990. 

  990. 			 $leadcount->setAttributes(array(

    991. 

  991.             			'userid' => $oldallocatedid, //additional data you want to insert

    992. 

  992.             			'key' => 2014, //additional data you want to insert

    993. 

  993.             			'value' => 1, //additional data you want to insert

    994. 

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

    995. 

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

    996. 

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

    997. 

  997. 			  			'createdBy' => time(), //additional //additional

    998. 

  998. 

    999. 

  999.         		));

    1000. 

  1000. 				$leadcount->save(false);

    1001. 

  1001. 				

    1002. 

  1002. 				}

    1003. 

  1003. 				

    1004. 

  1004. 			

    1005. 

  1005. 			}

    1006. 

  1006. 			

    1007. 

  1007. 			 /*$leadcount->setAttributes(array(

    1008. 

  1008.             			'userid' => time(), //additional data you want to insert

    1009. 

  1009.             			'key' => 2014, //additional data you want to insert

    1010. 

  1010.             			'value' => 1, //additional data you want to insert

    1011. 

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

    1012. 

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

    1013. 

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

    1014. 

  1014. 			  			'createdBy' => time(), //additional //additional

    1015. 

  1015. 

    1016. 

  1016.         		));

    1017. 

  1017. 				$leadcount->save(false);*/

    1018. 

  1018.  die;

    1019. 

  1019. 			

    1020. 

  1020. 			

    1021. 

  1021. 			

    1022. 

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

    1023. 

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

    1024. 

  1024. 			} else {

    1025. 

  1025. 				$this->redirect(array('leads/fresh_leads'));

    1026. 

  1026. 			}

    1027. 

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

    1028. 

  1028. 	}

    1029. 

  1029. 	/**

    1030. 

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

    1031. 

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

    1032. 

  1032. 	 */

    1033. 

  1033. 	public function actionlead_assign()

    1034. 

  1034. 	{

    1035. 

  1035. 		$model	=	new Lead();

    1036. 

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

    1037. 

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

    1038. 

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

    1039. 

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

    1040. 

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

    1041. 

  1041. 		$updatedOn		=	time();	

    1042. 

  1042. 		$chkleadStatus = Lead::model()->findByPk($leadId);

    1043. 

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

    1044. 

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

    1045. 

  1045. 		if($leadStatusIdUpdate == 34){

    1046. 

  1046. 		 $leadStatusIdUpdate = 35;

    1047. 

  1047. 		} else {

    1048. 

  1048. 		 $leadStatusIdUpdate = $leadStatusIdUpdate;

    1049. 

  1049. 		}

    1050. 

  1050. 		

    1051. 

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

    1052. 

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

    1053. 

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

    1054. 

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

    1055. 

  1055. 		} else {

    1056. 

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

    1057. 

  1057. 		}	

    1058. 

  1058. 							 echo CJSON::encode(array(

    1059. 

  1059.                                   'status'=>'success'

    1060. 

  1060.                              ));

    1061. 

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

    1062. 

  1062. 			

    1063. 

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

    1064. 

  1064. 		} else {

    1065. 

  1065. 		

    1066. 

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

    1067. 

  1067. 		}

    1068. 

  1068. 	}

    1069. 

  1069. 	/**

    1070. 

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

    1071. 

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

    1072. 

  1072. 	 */

    1073. 

  1073. 	public function actionarchive_leads()

    1074. 

  1074. 	{

    1075. 

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

    1076. 

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

    1077. 

  1077. 			$model=new Lead();

    1078. 

  1078. 			//$model=Lead::model()->findAll();

    1079. 

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

    1080. 

  1080. 	}

    1081. 

  1081. 	

    1082. 

  1082. 		/**

    1083. 

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

    1084. 

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

    1085. 

  1085. 	 */

    1086. 

  1086. 	public function actionbulk_import_leads()

    1087. 

  1087. 	{

    1088. 

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

    1089. 

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

    1090. 

  1090. 		$model=new Lead();

    1091. 

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

    1092. 

  1092. 	}

    1093. 

  1093. 	

    1094. 

  1094. 	/**

    1095. 

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

    1096. 

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

    1097. 

  1097. 	 */

    1098. 

  1098. 	public function actionjunk_leads()

    1099. 

  1099. 	{

    1100. 

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

    1101. 

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

    1102. 

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

    1103. 

  1103. 	}	

    1104. 

  1104. 	/**

    1105. 

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

    1106. 

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

    1107. 

  1107. 	 */

    1108. 

  1108. 	public function actionmodule_master()

    1109. 

  1109. 	{

    1110. 

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

    1111. 

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

    1112. 

  1112. 		

    1113. 

  1113. 			$model=new ModuleMaster();

    1114. 

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

    1115. 

  1115. 			

    1116. 

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

    1117. 

  1117. 			{

    1118. 

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

    1119. 

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

    1120. 

  1120. 				

    1121. 

  1121. 			}

    1122. 

  1122. 			

    1123. 

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

    1124. 

  1124. 			{

    1125. 

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

    1126. 

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

    1127. 

  1127. 			}			

    1128. 

  1128. 			

    1129. 

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

    1130. 

  1130. 			{			

    1131. 

  1131. 				 $model->setAttributes(array(

    1132. 

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

    1133. 

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

    1134. 

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

    1135. 

  1135. 			  			'createdBy' => time(),

    1136. 

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

    1137. 

  1137. 

    1138. 

  1138.         		));			

    1139. 

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

    1140. 

  1140. 				{  

    1141. 

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

    1142. 

  1142. 				}

    1143. 

  1143. 	

    1144. 

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

    1145. 

  1145. 					$model->save();

    1146. 

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

    1147. 

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

    1148. 

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

    1149. 

  1149. 				}	else			{

    1150. 

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

    1151. 

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

    1152. 

  1152. 					

    1153. 

  1153. 				}			

    1154. 

  1154. 			}	else {

    1155. 

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

    1156. 

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

    1157. 

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

    1158. 

  1158. 			}	

    1159. 

  1159. 	}

    1160. 

  1160. 	/**

    1161. 

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

    1162. 

  1162. 	 */

    1163. 

  1163. 	public function actionError()

    1164. 

  1164. 	{

    1165. 

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

    1166. 

  1166. 		{

    1167. 

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

    1168. 

  1168. 				echo $error['message'];

    1169. 

  1169. 			else

    1170. 

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

    1171. 

  1171. 		}

    1172. 

  1172. 	}

    1173. 

  1173. 

    1174. 

  1174. 	/**

    1175. 

  1175. 	 * Displays the contact page

    1176. 

  1176. 	 */

    1177. 

  1177. 	public function actionContact()

    1178. 

  1178. 	{

    1179. 

  1179. 		$model=new ContactForm;

    1180. 

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

    1181. 

  1181. 		{

    1182. 

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

    1183. 

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

    1184. 

  1184. 			{

    1185. 

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

    1186. 

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

    1187. 

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

    1188. 

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

    1189. 

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

    1190. 

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

    1191. 

  1191. 

    1192. 

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

    1193. 

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

    1194. 

  1194. 				$this->refresh();

    1195. 

  1195. 			}

    1196. 

  1196. 		}

    1197. 

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

    1198. 

  1198. 	}

    1199. 

  1199. 

    1200. 

  1200. 	/**

    1201. 

  1201. 	 * Displays the login page

    1202. 

  1202. 	 */

    1203. 

  1203. 	public function actionLogin()

    1204. 

  1204. 	{

    1205. 

  1205. 		$model=new User;

    1206. 

  1206. 

    1207. 

  1207. 		// if it is ajax validation request

    1208. 

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

    1209. 

  1209. 		{

    1210. 

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

    1211. 

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

    1212. 

  1212. 		}

    1213. 

  1213. 

    1214. 

  1214. 		// collect user input data

    1215. 

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

    1216. 

  1216. 		{

    1217. 

  1217. 		

    1218. 

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

    1219. 

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

    1220. 

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

    1221. 

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

    1222. 

  1222. 				} else {

    1223. 

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

    1224. 

  1224. 				}

    1225. 

  1225. 		}

    1226. 

  1226. 		// display the login form

    1227. 

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

    1228. 

  1228. 	}

    1229. 

  1229. 

    1230. 

  1230. 	/**

    1231. 

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

    1232. 

  1232. 	 */

    1233. 

  1233. 	public function actionLogout()

    1234. 

  1234. 	{

    1235. 

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

    1236. 

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

    1237. 

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

    1238. 

  1238. 	}

    1239. 

  1239. 	public function getPageType()

    1240. 

  1240. 	{

    1241. 

  1241. 		return "Leads";

    1242. 

  1242. 	}

    1243. 

  1243. 	public function init(){

    1244. 

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

    1245. 

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

    1246. 

  1246. 		$moduleArray=array();

    1247. 

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

    1248. 

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

    1249. 

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

    1250. 

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

    1251. 

  1251. 		}else{

    1252. 

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

    1253. 

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

    1254. 

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

    1255. 

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

    1256. 

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

    1257. 

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

    1258. 

  1258. 			 }

    1259. 

  1259. 			 }

    1260. 

  1260. 		}

    1261. 

  1261. 		

    1262. 

  1262. 		return $moduleArray;

    1263. 

  1263. 

    1264. 

  1264. 	}

    1265. 

  1265. 	

    1266. 

  1266. 	public function getNameFromNumber($num) {

    1267. 

  1267. 		$numeric = $num % 26;

    1268. 

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

    1269. 

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

    1270. 

  1270. 		if ($num2 > 0) {

    1271. 

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

    1272. 

  1272. 		} else {

    1273. 

  1273. 			return $letter;

    1274. 

  1274. 		}

    1275. 

  1275. 	}

    1276. 

  1276. 	/*function actionexportArchiveList()

    1277. 

  1277. 	{

    1278. 

  1278. 		// generate a resultset

    1279. 

  1279. 		$model=new User;

    1280. 

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

    1281. 

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

    1282. 

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

    1283. 

  1283. 	}*/

    1284. 

  1284. 	

    1285. 

  1285. 	public function actionDownloadLeadTemp(){

    1286. 

  1286. 	

    1287. 

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

    1288. 

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

    1289. 

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

    1290. 

  1290. 								 ->setLastModifiedBy("LeadTemplate")

    1291. 

  1291. 								 ->setTitle("LeadTemplate")

    1292. 

  1292. 								 ->setSubject("LeadTemplate")

    1293. 

  1293. 								 ->setDescription("LeadTemplate.")

    1294. 

  1294. 								 ->setKeywords("LeadTemplate")

    1295. 

  1295. 								 ->setCategory("LeadTemplate");

    1296. 

  1296. 	 

    1297. 

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

    1298. 

  1298. 	$total_excelColumns='I'; 

    1299. 

  1299. 	// Rename worksheet

    1300. 

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

    1301. 

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

    1302. 

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

    1303. 

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

    1304. 

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

    1305. 

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

    1306. 

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

    1307. 

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

    1308. 

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

    1309. 

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

    1310. 

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

    1311. 

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

    1312. 

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

    1313. 

  1313. 	array(

    1314. 

  1314. 	'font' => array(

    1315. 

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

    1316. 

  1316. 	'bold'         => true,

    1317. 

  1317. 	'italic'    => false,

    1318. 

  1318. 	'size'        => 12

    1319. 

  1319. 	),

    1320. 

  1320. 	'borders' => array(

    1321. 

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

    1322. 

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

    1323. 

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

    1324. 

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

    1325. 

  1325. 	),

    1326. 

  1326. 	'alignment' => array(

    1327. 

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

    1328. 

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

    1329. 

  1329. 	'wrap'       => true

    1330. 

  1330. 	)

    1331. 

  1331. 	),

    1332. 

  1332. 	'A1:'.$total_excelColumns.'1'

    1333. 

  1333. 	);

    1334. 

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

    1335. 

  1335. 	

    1336. 

  1336. 	// Add some data

    1337. 

  1337. 	$objPHPExcel->setActiveSheetIndex(0)

    1338. 

  1338. 				->setCellValue('A1', 'Name')

    1339. 

  1339. 				->setCellValue('B1', 'City')

    1340. 

  1340. 				->setCellValue('C1', 'Email')

    1341. 

  1341. 				->setCellValue('D1', 'Mobile')

    1342. 

  1342. 				->setCellValue('E1', 'Suminsured')

    1343. 

  1343. 				->setCellValue('F1', 'Age')

    1344. 

  1344. 				->setCellValue('G1', 'No. Of Members')

    1345. 

  1345. 				->setCellValue('H1', 'Date on submit')

    1346. 

  1346. 				->setCellValue('I1', 'Lead Source');

    1347. 

  1347. 	 

    1348. 

  1348. 	// Miscellaneous glyphs, UTF-8

    1349. 

  1349. 	$objPHPExcel->setActiveSheetIndex(0)

    1350. 

  1350. 				->setCellValue('A2', 'Lead Name')

    1351. 

  1351. 				->setCellValue('B2', 'city')

    1352. 

  1352. 				->setCellValue('C2', 'test@yesk.com')

    1353. 

  1353. 				->setCellValue('D2', '9999999999')

    1354. 

  1354. 				->setCellValue('E2', '56')

    1355. 

  1355. 				->setCellValue('F2', '23')

    1356. 

  1356. 				->setCellValue('G2', 'test')

    1357. 

  1357. 				->setCellValue('H2', '07-Sep-2013')

    1358. 

  1358. 				->setCellValue('I2', 'test');

    1359. 

  1359. 	

    1360. 

  1360. 	//To create new sheet in current file 

    1361. 

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

    1362. 

  1362. 	$objPHPExcel->setActiveSheetIndex(1);

    1363. 

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

    1364. 

  1364. 	*/

    1365. 

  1365. 		

    1366. 

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

    1367. 

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

    1368. 

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

    1369. 

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

    1370. 

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

    1371. 

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

    1372. 

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

    1373. 

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

    1374. 

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

    1375. 

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

    1376. 

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

    1377. 

  1377. 	 

    1378. 

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

    1379. 

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

    1380. 

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

    1381. 

  1381. 	}

    1382. 

  1382. 	public function actionImportLeadTemplate(){

    1383. 

  1383. 		$model=new lead();

    1384. 

  1384. 		$data='';

    1385. 

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

    1386. 

  1386. 		

    1387. 

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

    1388. 

  1388. 		

    1389. 

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

    1390. 

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

    1391. 

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

    1392. 

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

    1393. 

  1393. 			$folder = '/tempdata';

    1394. 

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

    1395. 

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

    1396. 

  1396. 		

    1397. 

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

    1398. 

  1398. 			

    1399. 

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

    1400. 

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

    1401. 

  1401. 		}

    1402. 

  1402. 		

    1403. 

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

    1404. 

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

    1405. 

  1405. 		$dateTime=time();

    1406. 

  1406. 		/*echo '<pre>';

    1407. 

  1407. 		print_r($final_arr);*/

    1408. 

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

    1409. 

  1409. 				{	

    1410. 

  1410. 					$leadStatusId  		= '0';

    1411. 

  1411. 					$duplicateLeadId 	= '0';

    1412. 

  1412. 					$currentAllocatedId	= '0';

    1413. 

  1413. 					

    1414. 

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

    1415. 

  1415. 					$junkNumberResult = $junkNumberQuery;

    1416. 

  1416. 		

    1417. 

  1417. 		

    1418. 

  1418. 					$fetchAgentDetails=LeadSourceMaster::model()->findByPk($final_arr[$i]['leadSourceId']);

    1419. 

  1419. 				

    1420. 

  1420. 					

    1421. 

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

    1422. 

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

    1423. 

  1423. 					$duplicateResult = ($duplicateQuery);

    1424. 

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

    1425. 

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

    1426. 

  1426. 					$leadStatusId  = '36';

    1427. 

  1427. 					$duplicateLeadId = '';

    1428. 

  1428. 					$currentAllocatedId	= '';

    1429. 

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

    1430. 

  1430. 					$leadStatusId  = '10';

    1431. 

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

    1432. 

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

    1433. 

  1433. 					} else {

    1434. 

  1434. 					$leadStatusId  = '34';

    1435. 

  1435. 					$duplicateLeadId = '';

    1436. 

  1436. 					$currentAllocatedId	= '';

    1437. 

  1437. 					}

    1438. 

  1438. 					/*echo '<br>leadStatusId---'.$leadStatusId;

    1439. 

  1439. 					echo '<br>duplicateLeadId---'.$duplicateLeadId;

    1440. 

  1440. 					echo '<br>currentAllocatedId---'.$currentAllocatedId;*/

    1441. 

  1441. 				

    1442. 

  1442. 					$model=new lead();

    1443. 

  1443. 					$model->name=$final_arr[$i]['name'];

    1444. 

  1444. 					$model->cityId=$final_arr[$i]['cityId'];

    1445. 

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

    1446. 

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

    1447. 

  1447. 					$model->si=$final_arr[$i]['suminsured'];

    1448. 

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

    1449. 

  1449. 					$model->members=$final_arr[$i]['noofmembers'];

    1450. 

  1450. 					$model->dateonSubmit=$final_arr[$i]['dateonsubmit'];

    1451. 

  1451. 					$model->leadSourceId=$final_arr[$i]['leadSourceId'];

    1452. 

  1452. 					$model->leadStatusId=$leadStatusId;

    1453. 

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

    1454. 

  1454. 					$model->currentAllocatedId=@$currentAllocatedId;

    1455. 

  1455. 					$model->productId='1';

    1456. 

  1456. 					$model->status='Active';

    1457. 

  1457. 					$model->createdOn=$dateTime;

    1458. 

  1458. 					$model->createdBy=Yii::app()->session->get('id');

    1459. 

  1459. 					$model->updatedOn=$dateTime;

    1460. 

  1460. 					$model->updatedBy=Yii::app()->session->get('id');

    1461. 

  1461. 					$model->isBulkImport='YES';

    1462. 

  1462. 					$model->agentId = @$fetchAgentDetails->leadSourceCode;

    1463. 

  1463. 					$model->ws_agentid = @$fetchAgentDetails->leadSourceCode;

    1464. 

  1464. 					$model->isNewRecord = true;

    1465. 

  1465. 					$model->save(false);

    1466. 

  1466. 					

    1467. 

  1467. 				}

    1468. 

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

    1469. 

  1469. 		}

    1470. 

  1470. 		 if(isset($_POST['ImportLeads']) && empty($final_arr) && empty($_FILES['Lead']['name']['import'])){

    1471. 

  1471. 			$model->validate();

    1472. 

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

    1473. 

  1473. 		}

    1474. 

  1474. 	}

    1475. 

  1475. 	public function actionleadSearch()

    1476. 

  1476. 		{

    1477. 

  1477. 			$searched	=	new Lead();			

    1478. 

  1478. 			if(@$_REQUEST['lead']['leadSearchBox']=='' && @$_REQUEST['mob']=='') {

    1479. 

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

    1480. 

  1480. 			} else {

    1481. 

  1481. 				$this->render('lead_search',array('searched'=>@$searched));

    1482. 

  1482. 			}

    1483. 

  1483. 		}

    1484. 

  1484. 

    1485. 

  1485. public function actionExportExcel()

    1486. 

  1486. 	{

    1487. 

  1487. 		// It calls the actionCreateExcel to generates excel reports'

    1488. 

  1488. 		$this->actionCreateExcel();

    1489. 

  1489. 		

    1490. 

  1490. 		

    1491. 

  1491. 	}

    1492. 

  1492. 	

    1493. 

  1493. public function actionCreateExcel(){

    1494. 

  1494. 

    1495. 

  1495. //Here is the code to set conditions for fetch records from database

    1496. 

  1496. $criteria = new CDbCriteria;

    1497. 

  1497.         $criteria->select = 't.*,`city`.`city`, `state`.`state`, `leadSourceMaster`.`leadSourceTitle`,`leadSourceMaster`.`leadSourceCode`,`leadStageMaster`.`leadStage`,`leadStatus`.`leadStatus`, `customerTypeMaster`.`customerType`,`productMaster`.`productName`,`policyTypeMaster`.`policyType`,`planTypeMaster`.`planType`,`campaign`.`campaignName`';

    1498. 

  1498.         $criteria->join ='LEFT JOIN city ON (city.cityId = t.cityId) LEFT JOIN state ON (state.stateId = t.stateId) LEFT JOIN leadSourceMaster ON (leadSourceMaster.leadSourceId = t.leadSourceId) LEFT JOIN leadStageMaster ON (leadStageMaster.leadStageId = t.leadStageId)LEFT JOIN leadStatus ON (leadStatus.leadStatusId  = t.leadStatusId)LEFT JOIN customerTypeMaster ON (customerTypeMaster.customerTypeId  = t.customerTypeId)LEFT JOIN productMaster ON (productMaster.productId  = t.productId)LEFT JOIN policyTypeMaster ON (policyTypeMaster.policyTypeId  = t.policyTypeId)LEFT JOIN planTypeMaster ON (planTypeMaster.planTypeId  = t.planTypeId)LEFT JOIN campaign ON (campaign.campaignId  = t.campaignId)';	

    1499. 

  1499. 		$criteria->condition='t.status != "Allocated" AND t.leadStatusId != "25" AND t.leadStatusId != "26" ';

    1500. 

  1500. 		$criteria->order='leadId DESC';	

    1501. 

  1501. 		

    1502. 

  1502. $model=new LeadReport();

    1503. 

  1503. $model->scenario = 'LeadReport';		

    1504. 

  1504. $reportmodel=LeadReport::model()->findAll($criteria);	

    1505. 

  1505. 		$data=array();

    1506. 

  1506. 		$datas = $reportmodel;				

    1507. 

  1507. foreach($datas as $key=>$value){

    1508. 

  1508.          $data[$key]=$value;

    1509. 

  1509. 		}

    1510. 

  1510. if(count($data)>0){			

    1511. 

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

    1512. 

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

    1513. 

  1513.       $objPHPExcel->getProperties()->setCreator("ReligareLMS")

    1514. 

  1514.                              ->setLastModifiedBy("ReligareLMS")

    1515. 

  1515.                              ->setTitle("Office 2007 XLSX Test Document")

    1516. 

  1516.                              ->setSubject("Office 2007 XLSX Test Document")

    1517. 

  1517.                              ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")

    1518. 

  1518.                              ->setKeywords("office 2007 openxml php")

    1519. 

  1519.                              ->setCategory("Test result file");

    1520. 

  1520. $total_excelColumns=$this->getNameFromNumber(8); 

    1521. 

  1521. // Rename worksheet

    1522. 

  1522. $objPHPExcel->getActiveSheet()->setTitle('Sample Excel');

    1523. 

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

    1524. 

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

    1525. 

  1525. $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(6);

    1526. 

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

    1527. 

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

    1528. 

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

    1529. 

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

    1530. 

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

    1531. 

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

    1532. 

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

    1533. 

  1533. 

    1534. 

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

    1535. 

  1535. array(

    1536. 

  1536. 'font' => array(

    1537. 

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

    1538. 

  1538. 'bold'         => true,

    1539. 

  1539. 'italic'    => false,

    1540. 

  1540. 'size'        => 12

    1541. 

  1541. ),

    1542. 

  1542. 'borders' => array(

    1543. 

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

    1544. 

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

    1545. 

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

    1546. 

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

    1547. 

  1547. ),

    1548. 

  1548. 'alignment' => array(

    1549. 

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

    1550. 

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

    1551. 

  1551. 'wrap'       => true

    1552. 

  1552. )

    1553. 

  1553. ),

    1554. 

  1554. 'A1:'.$total_excelColumns.'1'

    1555. 

  1555. );

    1556. 

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

    1557. 

  1557. 

    1558. 

  1558. // Add some data

    1559. 

  1559. $objPHPExcel->setActiveSheetIndex(0)

    1560. 

  1560.             ->setCellValue('A1', 'SNO.')

    1561. 

  1561.             ->setCellValue('B1', 'Name')

    1562. 

  1562.             ->setCellValue('C1', 'Mobile')

    1563. 

  1563.             ->setCellValue('D1', 'Email')

    1564. 

  1564. 			->setCellValue('E1', 'Lead Stage')

    1565. 

  1565. 			->setCellValue('F1', 'Date and Time')

    1566. 

  1566. 			->setCellValue('G1', 'UTM Code')

    1567. 

  1567. 			->setCellValue('H1', 'status');

    1568. 

  1568.  

    1569. 

  1569. // Miscellaneous glyphs, UTF-8

    1570. 

  1570. $i=0;

    1571. 

  1571. $k=2;

    1572. 

  1572. $sn=1;

    1573. 

  1573. while($i<count($data)){ 

    1574. 

  1574. $objPHPExcel->setActiveSheetIndex(0)

    1575. 

  1575. 			->setCellValue('A'.$k,$sn)

    1576. 

  1576.             ->setCellValue('B'.$k,$data[$i]['name'])

    1577. 

  1577.             ->setCellValue('C'.$k,$data[$i]['mobile'])

    1578. 

  1578. 			->setCellValue('D'.$k,$data[$i]['email'])

    1579. 

  1579.             ->setCellValue('E'.$k,$data[$i]['leadStage'])

    1580. 

  1580. 			->setCellValue('F'.$k,date("d/m/y h:i A",$data[$i]['createdOn']))

    1581. 

  1581. 			->setCellValue('G'.$k,$data[$i]['leadSourceCode'])

    1582. 

  1582. 			->setCellValue('H'.$k,$data[$i]['status']);

    1583. 

  1583. 			

    1584. 

  1584. $i++;$k++;$sn++;}

    1585. 

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

    1586. 

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

    1587. 

  1587. header('Content-Disposition: attachment;filename="lead_report.xls"');

    1588. 

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

    1589. 

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

    1590. 

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

    1591. 

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

    1592. 

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

    1593. 

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

    1594. 

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

    1595. 

  1595.  

    1596. 

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

    1597. 

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

    1598. 

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

    1599. 

  1599. }

    1600. 

  1600. else{

    1601. 

  1601. 		$model	=	new Lead();

    1602. 

  1602. 		$model	=	Lead::model()->findAll("status = 'Active'");

    1603. 

  1603. 		$this->render('lead_list',array('model'=>$model));

    1604. 

  1604. }

    1605. 

  1605. }

    1606. 

  1606. 

    1607. 

  1607. public function actiongetSourceResults(){

    1608. 

  1608. 		$models=new Lead();

    1609. 

  1609. 		$type=@$_REQUEST['type'];

    1610. 

  1610. 		$searchTxt=@$_REQUEST['searchTxt'];

    1611. 

  1611. 		if(isset($searchTxt) && !empty($searchTxt)){

    1612. 

  1612. 		$this->renderPartial('searchSourceLeads',array('searchTxt'=>$searchTxt,'type'=>@$type));

    1613. 

  1613. 		} else {

    1614. 

  1614. 			if($type=='fresh'){

    1615. 

  1615. 				$functs="fresh_leads";

    1616. 

  1616. 			}

    1617. 

  1617. 			if($type=='new'){

    1618. 

  1618. 				$functs="lead_list";

    1619. 

  1619. 			}

    1620. 

  1620. 			if($type=='duplicate'){

    1621. 

  1621. 				$functs="duplicate_lead_list";

    1622. 

  1622. 			}

    1623. 

  1623. 			if($type=='junk'){

    1624. 

  1624. 				$functs="junk_lead_list";

    1625. 

  1625. 			}

    1626. 

  1626. 			if($type=='allocated'){

    1627. 

  1627. 				$functs="allocated_lead_list";

    1628. 

  1628. 			}

    1629. 

  1629. 			if($type=='cip'){

    1630. 

  1630. 				$functs="cip_lead_list";

    1631. 

  1631. 			}

    1632. 

  1632. 			if($type=='plc'){

    1633. 

  1633. 				$functs="plc_lead_list";

    1634. 

  1634. 			}

    1635. 

  1635. 			if($type=='closed'){

    1636. 

  1636. 				$functs="close_lead_list";

    1637. 

  1637. 			}

    1638. 

  1638. 			if($type==''){

    1639. 

  1639. 				$functs="lead_list";

    1640. 

  1640. 			}

    1641. 

  1641. 		echo Yii::app()->createUrl('leads/'.@$functs);

    1642. 

  1642. 		exit;

    1643. 

  1643. 		}

    1644. 

  1644. }

    1645. 

  1645. 	public function actionAutocompleteSearch(){

    1646. 

  1646. 		$models=new Lead();

    1647. 

  1647. 		$term=@$_REQUEST['term'];

    1648. 

  1648. 		$type=@$_REQUEST['type'];

    1649. 

  1649. 		if($type=="fresh"){

    1650. 

  1650. 		$models=Lead::model()->findAll(array("condition"=>"leadStatusId = '34' AND currentAllocatedId<1 and concat(name,mobile,email) like '%$term%'","order"=>"leadId desc"));

    1651. 

  1651. 		}

    1652. 

  1652. 		if($type=="new"){

    1653. 

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

    1654. 

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

    1655. 

  1655. 		

    1656. 

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

    1657. 

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

    1658. 

  1658. 				} else {

    1659. 

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

    1660. 

  1660. 				}

    1661. 

  1661. 				$models	=	Lead::model()->findAll("  $querycondition and concat(name,mobile,email) like '%$term%'");	

    1662. 

  1662. 				

    1663. 

  1663. 		//$models=Lead::model()->findAll(array("condition"=>"leadStatusId = '34' AND currentAllocatedId<1 and name like '%$term%'","order"=>"leadId desc"));

    1664. 

  1664. 		}

    1665. 

  1665. 		if($type=="duplicate"){

    1666. 

  1666. 		 $models=Lead::model()->findAll(array("condition"=>"leadStatusId = '10' and concat(name,mobile,email) like '%$term%'","order"=>"leadId desc"));

    1667. 

  1667. 		}

    1668. 

  1668. 		if($type=="dupforday"){

    1669. 

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

    1670. 

  1670. 		 $models=Lead::model()->findAll(array("condition"=>"leadStatusId = '10' AND createdOn > '".@$today12PM."' and concat(name,mobile,email) like '%$term%'","order"=>"leadId desc"));

    1671. 

  1671. 		}

    1672. 

  1672. 		if($type=="junk"){

    1673. 

  1673. 		 $models=Lead::model()->findAll(array("condition"=>"leadStatusId = '36' and concat(name,mobile,email) like '%$term%'","order"=>"leadId desc"));

    1674. 

  1674. 		}

    1675. 

  1675. 		if($type=="allocated"){

    1676. 

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

    1677. 

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

    1678. 

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

    1679. 

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

    1680. 

  1680. 			} else {	

    1681. 

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

    1682. 

  1682. 			}

    1683. 

  1683. 			$models	=	Lead::model()->findAll("  $querycondition and concat(name,mobile,email) like '%$term%'");	

    1684. 

  1684. 		}

    1685. 

  1685. 		if($type=="followup"){

    1686. 

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

    1687. 

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

    1688. 

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

    1689. 

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

    1690. 

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

    1691. 

  1691. 			} else {	

    1692. 

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

    1693. 

  1693. 			}	

    1694. 

  1694. 			$models	=	LeadFollowup::model()->findAll("  $querycondition and description like '%$term%'");	

    1695. 

  1695. 		}

    1696. 

  1696. 		if($type=="allfollowup"){

    1697. 

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

    1698. 

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

    1699. 

  1699. 			$currentDate=date('d-m-Y',time());

    1700. 

  1700. 			$starttimestamp=strtotime($currentDate);

    1701. 

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

    1702. 

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

    1703. 

  1703. 			} else {	

    1704. 

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

    1705. 

  1705. 			}	

    1706. 

  1706. 			$models	=	LeadFollowup::model()->findAll("  $querycondition and description like '%$term%'");	

    1707. 

  1707. 		}

    1708. 

  1708. 		if($type=="closed"){

    1709. 

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

    1710. 

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

    1711. 

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

    1712. 

  1712. 				$querycondition 	= 	"leadStatusId = '7'";

    1713. 

  1713. 			} else {	

    1714. 

  1714. 				$querycondition 	= 	" leadStatusId = '7'  AND currentAllocatedId IN (".@$managerMemberId.") ";

    1715. 

  1715. 			}	

    1716. 

  1716. 			$models	=	Lead::model()->with("leadSourceDetails")->findAll("  $querycondition and concat(name,mobile,email) like '%$term%' ");	

    1717. 

  1717. 		}

    1718. 

  1718. 		if($type=="cip"){

    1719. 

  1719. 			$contactInProgList=Yii::app()->db->createCommand("select leadStatus.leadStatus,leadStatusId from leadStatus where parentId=3")->queryAll();

    1720. 

  1720. 			$CIPids = array();

    1721. 

  1721. 				if(count($contactInProgList) > 0){

    1722. 

  1722. 					for($w=0;$w<count($contactInProgList);$w++){

    1723. 

  1723. 					@$CIPids[] = 	@$contactInProgList[$w]['leadStatusId'];

    1724. 

  1724. 					}

    1725. 

  1725. 				} else {

    1726. 

  1726. 					@$CIPids[] = '';

    1727. 

  1727. 				} 

    1728. 

  1728. 				

    1729. 

  1729. 				@$CIPids = implode(",",@$CIPids);

    1730. 

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

    1731. 

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

    1732. 

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

    1733. 

  1733. 			$querycondition 	= 	" leadStatusId IN ( ".@$CIPids." ) ";

    1734. 

  1734. 			} else {	

    1735. 

  1735. 			$querycondition 	= 	" leadStatusId IN ( ".@$CIPids." )  AND currentAllocatedId IN (".@$managerMemberId.") ";

    1736. 

  1736. 			}

    1737. 

  1737. 			$models	=	Lead::model()->findAll("  $querycondition and concat(name,mobile,email) like '%$term%'");	

    1738. 

  1738. 		}

    1739. 

  1739. 		if($type=="plc"){

    1740. 

  1740. 			$contactInProgList=Yii::app()->db->createCommand("select leadStatus.leadStatus,leadStatusId from leadStatus where parentId=41")->queryAll();

    1741. 

  1741. 			$CIPids = array();

    1742. 

  1742. 				if(count($contactInProgList) > 0){

    1743. 

  1743. 					for($w=0;$w<count($contactInProgList);$w++){

    1744. 

  1744. 					@$CIPids[] = 	@$contactInProgList[$w]['leadStatusId'];

    1745. 

  1745. 					}

    1746. 

  1746. 				} else {

    1747. 

  1747. 					@$CIPids[] = '';

    1748. 

  1748. 				} 

    1749. 

  1749. 				

    1750. 

  1750. 				@$CIPids = implode(",",@$CIPids);

    1751. 

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

    1752. 

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

    1753. 

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

    1754. 

  1754. 			$querycondition 	= 	" leadStatusId IN ( ".@$CIPids." ) ";

    1755. 

  1755. 			} else {	

    1756. 

  1756. 			$querycondition 	= 	" leadStatusId IN ( ".@$CIPids." )  AND currentAllocatedId IN (".@$managerMemberId.") ";

    1757. 

  1757. 			}

    1758. 

  1758. 			$models	=	Lead::model()->findAll("  $querycondition and concat(name,mobile,email) like '%$term%'");	

    1759. 

  1759. 		}

    1760. 

  1760. 		if($type=="cld"){

    1761. 

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

    1762. 

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

    1763. 

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

    1764. 

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

    1765. 

  1765. 				$querycondition 	= 	'leadStatusId = 12  AND startDate = "'.@$today12PM.'" ';

    1766. 

  1766. 			} else {	

    1767. 

  1767. 				$querycondition 	= 	"leadStatusId = 12  AND startDate = '".@$today12PM."' AND userId IN (".@$managerMemberId.") ";

    1768. 

  1768. 			}	

    1769. 

  1769. 			$models	=	LeadFollowup::model()->findAll("  $querycondition and description like '%$term%'");	

    1770. 

  1770. 		}

    1771. 

  1771. 		if($type=="followup" or $type=="allfollowup" or $type=="cld"){

    1772. 

  1772. 				$arr = array();

    1773. 

  1773. 				foreach($models as $model) {

    1774. 

  1774. 					$arr[] = array(

    1775. 

  1775. 						'label'=>substr($model->description,0,10),  // label for dropdown list          

    1776. 

  1776. 						'value'=>substr($model->description,0,10),  // value for input field          

    1777. 

  1777. 						'id'=>$model->leadFollowupId,            // return value from autocomplete

    1778. 

  1778. 						);      

    1779. 

  1779. 				}

    1780. 

  1780. 				if(count($models) > 0){

    1781. 

  1781. 					$arr['totalRecords'] = array(

    1782. 

  1782. 					'totalRecords'=>count($models),            // return value from autocomplete

    1783. 

  1783. 					);   

    1784. 

  1784. 				}  

    1785. 

  1785. 		}else {

    1786. 

  1786. 				$arr = array();

    1787. 

  1787. 				foreach($models as $model) {

    1788. 

  1788. 					$arr[] = array(

    1789. 

  1789. 						'label'=>$model->mobile?$model->mobile.($model->name?'/'.$model->name:'').($model->email?'/'.$model->email:''):'',  // label for dropdown list          

    1790. 

  1790. 						'value'=>$model->mobile?$model->mobile:$model->name,  // value for input field          

    1791. 

  1791. 						'id'=>$model->leadId,            // return value from autocomplete

    1792. 

  1792. 						);      

    1793. 

  1793. 				}

    1794. 

  1794. 				if(count($models) > 0){

    1795. 

  1795. 					$arr['totalRecords'] = array(

    1796. 

  1796. 					'totalRecords'=>count($models),            // return value from autocomplete

    1797. 

  1797. 					);   

    1798. 

  1798. 				}  

    1799. 

  1799. 		} 

    1800. 

  1800. 	echo CJSON::encode($arr);

    1801. 

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

    1802. 

  1802. 		//$this->renderPartial('searchLeads');

    1803. 

  1803. 	}

    1804. 

  1804. 	public function actionAutocompleteSearchSource(){

    1805. 

  1805. 		$models=new Lead();

    1806. 

  1806. 		$term=@$_REQUEST['term'];

    1807. 

  1807. 		$type=@$_REQUEST['type'];

    1808. 

  1808. 		if($type=="fresh"){

    1809. 

  1809. 		$models=Lead::model()->with("leadSourceDetails")->findAll(array("condition"=>"leadStatusId = '34' AND currentAllocatedId<1 and concat(leadSourceTitle) like '%$term%'","order"=>"leadId desc"));

    1810. 

  1810. 		}

    1811. 

  1811. 		if($type=="new"){

    1812. 

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

    1813. 

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

    1814. 

  1814. 		

    1815. 

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

    1816. 

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

    1817. 

  1817. 				} else {

    1818. 

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

    1819. 

  1819. 				}

    1820. 

  1820. 				$models	=	Lead::model()->with("leadSourceDetails")->findAll("  $querycondition and leadSourceTitle like '%$term%'");	

    1821. 

  1821. 				

    1822. 

  1822. 		//$models=Lead::model()->findAll(array("condition"=>"leadStatusId = '34' AND currentAllocatedId<1 and name like '%$term%'","order"=>"leadId desc"));

    1823. 

  1823. 		}

    1824. 

  1824. 		if($type=="duplicate"){

    1825. 

  1825. 		 $models=Lead::model()->with("leadSourceDetails")->findAll(array("condition"=>"leadStatusId = '10' and leadSourceTitle like '%$term%'","order"=>"leadId desc"));

    1826. 

  1826. 		}

    1827. 

  1827. 		if($type=="junk"){

    1828. 

  1828. 		 $models=Lead::model()->with("leadSourceDetails")->findAll(array("condition"=>"leadStatusId = '36' and leadSourceTitle like '%$term%'","order"=>"leadId desc"));

    1829. 

  1829. 		}

    1830. 

  1830. 		if($type=="allocated"){

    1831. 

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

    1832. 

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

    1833. 

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

    1834. 

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

    1835. 

  1835. 			} else {	

    1836. 

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

    1837. 

  1837. 			}

    1838. 

  1838. 			$models	=	Lead::model()->with("leadSourceDetails")->findAll("  $querycondition and leadSourceTitle like '%$term%'");	

    1839. 

  1839. 		}

    1840. 

  1840. 		if($type=="followup"){

    1841. 

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

    1842. 

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

    1843. 

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

    1844. 

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

    1845. 

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

    1846. 

  1846. 			} else {	

    1847. 

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

    1848. 

  1848. 			}	

    1849. 

  1849. 			$models	=	LeadFollowup::model()->findAll("  $querycondition and description leadSourceTitle '%$term%'");	

    1850. 

  1850. 		}

    1851. 

  1851. 		if($type=="closed"){

    1852. 

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

    1853. 

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

    1854. 

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

    1855. 

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

    1856. 

  1856. 				$querycondition 	= 	"leadStatusId = '7'";

    1857. 

  1857. 			} else {	

    1858. 

  1858. 				$querycondition 	= 	" leadStatusId = '7'  AND currentAllocatedId IN (".@$managerMemberId.") ";

    1859. 

  1859. 			}	

    1860. 

  1860. 			$models	=	Lead::model()->with("leadSourceDetails")->findAll("  $querycondition and leadSourceTitle like '%$term%' ");	

    1861. 

  1861. 		}

    1862. 

  1862. 

    1863. 

  1863. 

    1864. 

  1864. 		if($type=="followup"){

    1865. 

  1865. 				$arr = array();

    1866. 

  1866. 				foreach($models as $model) {

    1867. 

  1867. 					$arr[] = array(

    1868. 

  1868. 						'label'=>substr($model->description,0,10),  // label for dropdown list          

    1869. 

  1869. 						'value'=>substr($model->description,0,10),  // value for input field          

    1870. 

  1870. 						'id'=>$model->leadFollowupId,            // return value from autocomplete

    1871. 

  1871. 						);      

    1872. 

  1872. 				}

    1873. 

  1873. 				if(count($models) > 0){

    1874. 

  1874. 					$arr['totalRecords'] = array(

    1875. 

  1875. 					'totalRecords'=>count($models),            // return value from autocomplete

    1876. 

  1876. 					);   

    1877. 

  1877. 				}  

    1878. 

  1878. 		}else {

    1879. 

  1879. 				$arr = array();

    1880. 

  1880. 				foreach($models as $model) {

    1881. 

  1881. 					$arr[] = array(

    1882. 

  1882. 						'label'=>$model->mobile?$model->mobile:$model->name,  // label for dropdown list          

    1883. 

  1883. 						'value'=>$model->mobile?$model->mobile:$model->name,  // value for input field          

    1884. 

  1884. 						'id'=>$model->leadId,            // return value from autocomplete

    1885. 

  1885. 						);      

    1886. 

  1886. 				}

    1887. 

  1887. 				if(count($models) > 0){

    1888. 

  1888. 					$arr['totalRecords'] = array(

    1889. 

  1889. 					'totalRecords'=>count($models),            // return value from autocomplete

    1890. 

  1890. 					);   

    1891. 

  1891. 				}  

    1892. 

  1892. 		} 

    1893. 

  1893. 	echo CJSON::encode($arr);

    1894. 

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

    1895. 

  1895. 		//$this->renderPartial('searchLeads');

    1896. 

  1896. 	}

    1897. 

  1897. 	public function actionAutocompleteSearchRes(){

    1898. 

  1898. 		$models=new Lead();

    1899. 

  1899. 		$term=@$_REQUEST['id'];

    1900. 

  1900. 		$type=@$_REQUEST['type'];

    1901. 

  1901. 		$models=Lead::model()->findAll(array("condition"=>"leadStatusId = '34' AND currentAllocatedId<1 and name like '%$term%'","order"=>"leadId desc"));

    1902. 

  1902. 		$arr = array();

    1903. 

  1903. 		$this->renderPartial('searchLeads',array('name'=>$term));

    1904. 

  1904. 	}

    1905. 

  1905. 	public function actionexportArchiveList(){

    1906. 

  1906. 		$Leadname = @$_REQUEST['name'];	

    1907. 

  1907. 		$Leadstatus = @$_REQUEST['status'];	

    1908. 

  1908. 		$leadStage = @$_REQUEST['statge'];	

    1909. 

  1909. 		$cond ='';

    1910. 

  1910. 		if(isset($Leadname) && !empty($Leadname)){

    1911. 

  1911. 			$cond .=" AND name like '%".@$Leadname."%'";

    1912. 

  1912. 		}

    1913. 

  1913. 		if(isset($Leadstatus) && !empty($Leadstatus)){

    1914. 

  1914. 			$cond .=" AND leadStatusId = '".@$Leadstatus."'";

    1915. 

  1915. 		}

    1916. 

  1916. 		if(isset($leadStage) && !empty($leadStage)){

    1917. 

  1917. 			$cond .=" AND leadStageId = '".@$leadStage."'";

    1918. 

  1918. 		}

    1919. 

  1919. 

    1920. 

  1920. 				$dataProvider = new CActiveDataProvider('Lead', array('criteria'=>array(

    1921. 

  1921. 	 	'condition'=>' FROM_UNIXTIME(updatedOn) >= DATE_SUB(CURDATE(), INTERVAL 120 DAY) '.@$cond.' and leadStatusId NOT IN (12,8,1,4) ',

    1922. 

  1922.         'order'=>'',

    1923. 

  1923.         )));

    1924. 

  1924. 	$iterator = new CDataProviderIterator($dataProvider);

    1925. 

  1925. 		$data=array();

    1926. 

  1926. 		$datas = $iterator;

    1927. 

  1927. 		foreach($datas as $key=>$value){

    1928. 

  1928.           $data[$key]=$value;

    1929. 

  1929. 		}

    1930. 

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

    1931. 

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

    1932. 

  1932. 		  $objPHPExcel->getProperties()->setCreator("ReligareLMS")

    1933. 

  1933. 								 ->setLastModifiedBy("ReligareLMS")

    1934. 

  1934. 								 ->setTitle("Office 2007 XLSX Leads Document")

    1935. 

  1935. 								 ->setSubject("Office 2007 XLSX Leads Document")

    1936. 

  1936. 								 ->setDescription("Archive Leads.")

    1937. 

  1937. 								 ->setKeywords("Archive Leads")

    1938. 

  1938. 								 ->setCategory("Archive Leads");

    1939. 

  1939. 		// Rename worksheet

    1940. 

  1940. $objPHPExcel->getActiveSheet()->setTitle('Sample Excel');

    1941. 

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

    1942. 

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

    1943. 

  1943. $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(6);

    1944. 

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

    1945. 

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

    1946. 

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

    1947. 

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

    1948. 

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

    1949. 

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

    1950. 

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

    1951. 

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

    1952. 

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

    1953. 

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

    1954. 

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

    1955. 

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

    1956. 

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

    1957. 

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

    1958. 

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

    1959. 

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

    1960. 

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

    1961. 

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

    1962. 

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

    1963. 

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

    1964. 

  1964. $objPHPExcel->getActiveSheet()->getColumnDimension('V')->setWidth(30);

    1965. 

  1965. $objPHPExcel->getActiveSheet()->getColumnDimension('W')->setWidth(30);

    1966. 

  1966. $objPHPExcel->getActiveSheet()->getColumnDimension('X')->setWidth(30);

    1967. 

  1967. $objPHPExcel->getActiveSheet()->getColumnDimension('y')->setWidth(30);

    1968. 

  1968. 		

    1969. 

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

    1970. 

  1970. 		array(

    1971. 

  1971. 		'font' => array(

    1972. 

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

    1973. 

  1973. 		'bold'         => true,

    1974. 

  1974. 		'italic'    => false,

    1975. 

  1975. 		'size'        => 12

    1976. 

  1976. 		),

    1977. 

  1977. 		'borders' => array(

    1978. 

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

    1979. 

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

    1980. 

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

    1981. 

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

    1982. 

  1982. 		),

    1983. 

  1983. 		'alignment' => array(

    1984. 

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

    1985. 

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

    1986. 

  1986. 		'wrap'       => true

    1987. 

  1987. 		)

    1988. 

  1988. 		),

    1989. 

  1989. 		'A1:Y1'

    1990. 

  1990. 		);

    1991. 

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

    1992. 

  1992. 		

    1993. 

  1993. 		// Add some data

    1994. 

  1994. 		$objPHPExcel->setActiveSheetIndex(0)

    1995. 

  1995.             ->setCellValue('A1', 'SNO.')

    1996. 

  1996.             ->setCellValue('B1', 'Name')

    1997. 

  1997. 			->setCellValue('C1', 'Mobile Number')

    1998. 

  1998. 			->setCellValue('D1', 'Email Id')

    1999. 

  1999. 			->setCellValue('E1', 'Address')

    2000. 

  2000. 			->setCellValue('F1', 'City')

    2001. 

  2001. 			->setCellValue('G1', 'State')

    2002. 

  2002. 			->setCellValue('H1', 'Members')

    2003. 

  2003. 			->setCellValue('I1', 'Premium')

    2004. 

  2004. 			->setCellValue('J1', 'Product Details')

    2005. 

  2005. 			->setCellValue('K1', 'Lead Status')

    2006. 

  2006. 			->setCellValue('L1', 'Status')

    2007. 

  2007. 			->setCellValue('M1', 'isJunk')

    2008. 

  2008.             ->setCellValue('N1', 'Lead Source')

    2009. 

  2009.             ->setCellValue('O1', 'Lead Stage')

    2010. 

  2010.             ->setCellValue('P1', 'Lead Description')

    2011. 

  2011.             ->setCellValue('Q1', 'Activity Description')

    2012. 

  2012. 			->setCellValue('R1', 'Customer Type')

    2013. 

  2013. 			->setCellValue('S1', 'Product Name')

    2014. 

  2014. 			->setCellValue('T1', 'Policy Type')

    2015. 

  2015. 			->setCellValue('U1', 'Plan Type')

    2016. 

  2016. 			->setCellValue('V1', 'Campaign Name')

    2017. 

  2017. 			->setCellValue('W1', 'UTM Code')

    2018. 

  2018. 			->setCellValue('X1', 'Owner')

    2019. 

  2019. 			->setCellValue('Y1', 'Last Modified Date');

    2020. 

  2020. 			

    2021. 

  2021. 		

    2022. 

  2022. 		// Miscellaneous glyphs, UTF-8

    2023. 

  2023. $i=0;

    2024. 

  2024. $k=2;

    2025. 

  2025. $sn=1;

    2026. 

  2026. while($i<count($data)){

    2027. 

  2027. $str = preg_replace('/\s\s+/', ' ', $data[$i]['address']);

    2028. 

  2028. 

    2029. 

  2029. if($data[$i]['currentAllocatedId']==$data[$i]['createdBy']){

    2030. 

  2030. $owner = $data[$i]['ownerDetails']['firstName']." ".$data[$i]['ownerDetails']['lastName']."(C)";

    2031. 

  2031. } else {

    2032. 

  2032. 		if(isset($data[$i]['ownerDetails']['firstName']) && !empty($data[$i]['ownerDetails']['firstName'])){

    2033. 

  2033. 		$owner = $data[$i]['ownerDetails']['firstName']." ".$data[$i]['ownerDetails']['lastName'];

    2034. 

  2034. 		} else {

    2035. 

  2035. 		$owner = "NA";

    2036. 

  2036. 		}

    2037. 

  2037. }

    2038. 

  2038. 

    2039. 

  2039. $descrecords=Yii::app()->db->createCommand("select leadDescription  from lead where leadId='".@$data[$i]['leadId']."' ")->queryAll();

    2040. 

  2040. 

    2041. 

  2041. 

    2042. 

  2042. 

    2043. 

  2043. 		$records=Yii::app()->db->createCommand("select description from leadFollowup where leadId='".@$data[$i]['leadId']."' ")->queryAll();

    2044. 

  2044. 		$ActivityRes = '';

    2045. 

  2045. 		for($j=0;$j<count($records);$j++){ 

    2046. 

  2046. 		 	@$ActivityRes .= @$records[0]['description'].",";

    2047. 

  2047. 		 }

    2048. 

  2048. $lastModifieddate = date("d M Y  H:i:s A",$data[$i]['updatedOn']);

    2049. 

  2049. 

    2050. 

  2050. //ReportsController::getLeadDescription(@$data->leadId);

    2051. 

  2051. //$data[$i]['ownerDetails']['firstName'];

    2052. 

  2052. $objPHPExcel->setActiveSheetIndex(0)

    2053. 

  2053. 			->setCellValue('A'.$k,$sn)

    2054. 

  2054.             ->setCellValue('B'.$k,$data[$i]['name'])

    2055. 

  2055.             ->setCellValue('C'.$k,$data[$i]['mobile'])

    2056. 

  2056. 			->setCellValue('D'.$k,$data[$i]['email'])

    2057. 

  2057.             ->setCellValue('E'.$k,$str)

    2058. 

  2058. 			->setCellValue('F'.$k,$data[$i]['city'])

    2059. 

  2059.             ->setCellValue('G'.$k,$data[$i]['state'])

    2060. 

  2060. 			->setCellValue('H'.$k,$data[$i]['members'])

    2061. 

  2061.             ->setCellValue('I'.$k,$data[$i]['premium'])

    2062. 

  2062. 			->setCellValue('J'.$k,$data[$i]['productDetails'])

    2063. 

  2063.             ->setCellValue('K'.$k,$data[$i]['leadStatusDetails']['leadStatus'])

    2064. 

  2064. 			->setCellValue('L'.$k,$data[$i]['status'])

    2065. 

  2065.             ->setCellValue('M'.$k,$data[$i]['isJunk'])

    2066. 

  2066. 			->setCellValue('N'.$k,$data[$i]['leadSourceTitle'])

    2067. 

  2067.             ->setCellValue('O'.$k,$data[$i]['leadStage'])

    2068. 

  2068.             ->setCellValue('P'.$k,@$descrecords[0]['leadDescription'])

    2069. 

  2069.             ->setCellValue('Q'.$k,@$ActivityRes)

    2070. 

  2070. 			->setCellValue('R'.$k,$data[$i]['customerType'])

    2071. 

  2071.             ->setCellValue('S'.$k,$data[$i]['productName'])

    2072. 

  2072. 			->setCellValue('T'.$k,$data[$i]['policyType'])

    2073. 

  2073.             ->setCellValue('U'.$k,$data[$i]['planType'])

    2074. 

  2074. 			->setCellValue('V'.$k,$data[$i]['campaignName'])

    2075. 

  2075.             ->setCellValue('W'.$k,$data[$i]['leadSourceCode'])

    2076. 

  2076.             ->setCellValue('X'.$k,$owner)

    2077. 

  2077.             ->setCellValue('Y'.$k,$lastModifieddate);

    2078. 

  2078. $i++;$k++;$sn++;}

    2079. 

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

    2080. 

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

    2081. 

  2081. 		header('Content-Disposition: attachment;filename="lead_report.xls"');

    2082. 

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

    2083. 

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

    2084. 

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

    2085. 

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

    2086. 

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

    2087. 

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

    2088. 

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

    2089. 

  2089. 		

    2090. 

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

    2091. 

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

    2092. 

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

    2093. 

  2093. 		

    2094. 

  2094. 	}

    2095. 

  2095. 	public function actiongetCityList()

    2096. 

  2096. 	{

    2097. 

  2097. 		$data=City::model()->findAll(array('condition'=>'stateId=:stateId and status=:status','params'=>array(':stateId'=>(int) $_POST['stateId'],'status'=>'Active')));

    2098. 

  2098. 			$data=CHtml::listData($data,'cityId','city');

    2099. 

  2099. 			echo '<select class="styled" name="Lead[cityId]" style="position: absolute; opacity: 0; font-size: 12px; height: 25px;" onchange="changeText();">';

    2100. 

  2100. 			echo '<option value="" selected="selected">Select City</option>';	

    2101. 

  2101. 			foreach($data as $value=>$name)

    2102. 

  2102. 			{

    2103. 

  2103. 				echo CHtml::tag('option',array('value'=>$value),CHtml::encode($name));

    2104. 

  2104. 			}

    2105. 

  2105. 			echo '</select>';

    2106. 

  2106. 			echo '<span id="changeText" class="customStyleSelectBox" style="display: block;width:97px;"><span class="customStyleSelectBoxInner" style="width: 81px; display: block;">Select City</span></span>';

    2107. 

  2107. 	}

    2108. 

  2108. 	public function actiongetLeadStatus()

    2109. 

  2109. 	{

    2110. 

  2110. 		if(isset($_POST['parentId']) && !empty($_POST['parentId'])){

    2111. 

  2111. 		$data=LeadStatus::model()->findAll(array('condition'=>'parentId=:parentId and status=:status','params'=>array(':parentId'=>(int) @$_POST['parentId'],'status'=>'Active')));

    2112. 

  2112. 			$data=CHtml::listData($data,'leadStatusId','leadStatus');

    2113. 

  2113. 			echo '<select class="styled" name="Lead[leadStatusId]" style="position: absolute; opacity: 0; font-size: 12px; height: 25px;" id="leadprimarystatus" onchange="changeStatusText();getActionRes(this.value);">';

    2114. 

  2114. 			echo '<option value="" selected="selected">Select lead Status</option>';	

    2115. 

  2115. 			foreach($data as $value=>$name)

    2116. 

  2116. 			{

    2117. 

  2117. 				echo CHtml::tag('option',array('value'=>$value),CHtml::encode($name));

    2118. 

  2118. 			}

    2119. 

  2119. 			echo '</select>';

    2120. 

  2120. 		} else {

    2121. 

  2121. 			echo '<select class="styled" name="Lead[leadStatusId]" style="position: absolute; opacity: 0; font-size: 12px; height: 25px;" id="leadprimarystatus" onchange="changeStatusText();getActionRes(this.value);">';

    2122. 

  2122. 			echo '<option value="" selected="selected">Select lead Status</option>';	

    2123. 

  2123. 			echo '</select>';

    2124. 

  2124. 		}

    2125. 

  2125. 			echo '<span id="changeStatusText" class="customStyleSelectBox" style="display: block;min-width:142px;"><span class="customStyleSelectBoxInner" style="width: 81px; display: block;">Select lead Status</span></span>';

    2126. 

  2126. 	}

    2127. 

  2127. 	public function actionexportLeads(){

    2128. 

  2128. 	

    2129. 

  2129. 			$model=new Lead();

    2130. 

  2130. 			$type=@$_REQUEST['type'];

    2131. 

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

    2132. 

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

    2133. 

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

    2134. 

  2134. 

    2135. 

  2135. 			if($type=="freshLeads"){

    2136. 

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

    2137. 

  2137. 				$querycondition = " leadStatusId = '34' AND currentAllocatedId<1";

    2138. 

  2138. 			} else {

    2139. 

  2139. 				$querycondition = " leadStatusId = '34' AND currentAllocatedId<1";

    2140. 

  2140. 			}

    2141. 

  2141. 				$dataProvider=new CActiveDataProvider('Lead', array('criteria'=>array(

    2142. 

  2142. 					'condition'=>@$querycondition,

    2143. 

  2143. 					'order'=>'leadId DESC',

    2144. 

  2144. 					),

    2145. 

  2145. 					'pagination'=>false,

    2146. 

  2146. 					));

    2147. 

  2147. 			}

    2148. 

  2148. 			if($type=="newLeads"){

    2149. 

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

    2150. 

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

    2151. 

  2151. 			} else {

    2152. 

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

    2153. 

  2153. 			}

    2154. 

  2154. 			

    2155. 

  2155. 				$dataProvider=new CActiveDataProvider('Lead', array('criteria'=>array(

    2156. 

  2156. 					'condition'=>@$querycondition,

    2157. 

  2157. 					'order'=>'leadId DESC',

    2158. 

  2158. 					),

    2159. 

  2159. 					'pagination'=>array(

    2160. 

  2160.                         'pageSize'=> 10,

    2161. 

  2161.                 ),

    2162. 

  2162. 					));

    2163. 

  2163. 			}

    2164. 

  2164. 		

    2165. 

  2165. 			if($type=="allocatedLeads"){

    2166. 

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

    2167. 

  2167. 					$queryCondition 	= 	" currentAllocatedId>0 AND isRead = 'yes' ";

    2168. 

  2168. 				} else {	

    2169. 

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

    2170. 

  2170. 				}

    2171. 

  2171. 				$dataProvider=new CActiveDataProvider('Lead', array('criteria'=>array(

    2172. 

  2172. 					'condition'=>@$queryCondition,

    2173. 

  2173. 					'order'=>'leadId DESC',

    2174. 

  2174. 					)));

    2175. 

  2175. 			}

    2176. 

  2176. 			if($type=="Allfollowup"){

    2177. 

  2177. 			

    2178. 

  2178. 				$currentDate=date('d-m-Y',time());

    2179. 

  2179. 				$starttimestamp=strtotime($currentDate);

    2180. 

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

    2181. 

  2181. 					$queryCondition 	= 	'  status="Pending" and userId = "'.@$_SESSION['id'].'" ';

    2182. 

  2182. 				} else {	

    2183. 

  2183. 					$queryCondition 	= 	"  status = 'Pending' AND userId IN (".@$managerMemberId.") ";

    2184. 

  2184. 				}	

    2185. 

  2185. 				$dataProvider=new CActiveDataProvider('LeadFollowup', array('criteria'=>array(

    2186. 

  2186. 					'condition'=>@$queryCondition,

    2187. 

  2187. 					'order'=>'leadFollowupId DESC',

    2188. 

  2188. 					)));

    2189. 

  2189. 			}

    2190. 

  2190. 			if($type=="followupLeads"){

    2191. 

  2191. 			

    2192. 

  2192. 				$currentDate=date('d-m-Y',time());

    2193. 

  2193. 				$starttimestamp=strtotime($currentDate);

    2194. 

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

    2195. 

  2195. 					$queryCondition 	= 	' startDate = "'.@$starttimestamp.'" and status="Pending" and userId = "'.@$_SESSION['id'].'" ';

    2196. 

  2196. 				} else {	

    2197. 

  2197. 					$queryCondition 	= 	" startDate = '".@$starttimestamp."' AND status = 'Pending' AND userId IN (".@$managerMemberId.") ";

    2198. 

  2198. 				}	

    2199. 

  2199. 				$dataProvider=new CActiveDataProvider('LeadFollowup', array('criteria'=>array(

    2200. 

  2200. 					'condition'=>@$queryCondition,

    2201. 

  2201. 					'order'=>'leadFollowupId DESC',

    2202. 

  2202. 					)));

    2203. 

  2203. 			}

    2204. 

  2204. 			if($type=="duplicateLeads"){

    2205. 

  2205. 				$dataProvider=new CActiveDataProvider('Lead', array('criteria'=>array(

    2206. 

  2206. 					'condition'=>' leadStatusId = "10" ',

    2207. 

  2207. 					'order'=>'leadId DESC',

    2208. 

  2208. 					)));

    2209. 

  2209. 			}

    2210. 

  2210. 			if($type=="dupforday"){

    2211. 

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

    2212. 

  2212. 				$dataProvider=new CActiveDataProvider('Lead', array('criteria'=>array(

    2213. 

  2213. 					'condition'=>' leadStatusId = "10" AND createdOn > "'.@$today12PM.'" ',

    2214. 

  2214. 					'order'=>'leadId DESC',

    2215. 

  2215. 					)));

    2216. 

  2216. 			}

    2217. 

  2217. 			if($type=="junkLeads"){

    2218. 

  2218. 				$dataProvider=new CActiveDataProvider('Lead', array('criteria'=>array(

    2219. 

  2219. 					'condition'=>' leadStatusId = "36" ',

    2220. 

  2220. 					'order'=>'leadId DESC',

    2221. 

  2221. 					)));

    2222. 

  2222. 			}

    2223. 

  2223. 			if($type=="closeLeads"){

    2224. 

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

    2225. 

  2225. 					$querycondition 	= 	"leadStatusId = '7' ";

    2226. 

  2226. 				} else {	

    2227. 

  2227. 					$querycondition 	= 	" leadStatusId = '7' AND currentAllocatedId IN (".@$managerMemberId.") ";

    2228. 

  2228. 				}

    2229. 

  2229. 				$dataProvider=new CActiveDataProvider('Lead', array('criteria'=>array(

    2230. 

  2230. 					'condition'=>@$querycondition,

    2231. 

  2231. 					'order'=>'leadId desc',

    2232. 

  2232. 					),

    2233. 

  2233. 					));

    2234. 

  2234. 			}

    2235. 

  2235. 			if($type=="cip"){

    2236. 

  2236. 			$contactInProgList=Yii::app()->db->createCommand("select leadStatus.leadStatus,leadStatusId from leadStatus where parentId=3")->queryAll();

    2237. 

  2237. 				$CIPids = array();

    2238. 

  2238. 					if(count($contactInProgList) > 0){

    2239. 

  2239. 						for($w=0;$w<count($contactInProgList);$w++){

    2240. 

  2240. 						@$CIPids[] = 	@$contactInProgList[$w]['leadStatusId'];

    2241. 

  2241. 						}

    2242. 

  2242. 					} else {

    2243. 

  2243. 						@$CIPids[] = '';

    2244. 

  2244. 					} 

    2245. 

  2245. 					@$CIPids = implode(",",@$CIPids);

    2246. 

  2246. 					

    2247. 

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

    2248. 

  2248. 					$querycondition 	= 	"leadStatusId IN ( ".@$CIPids." ) ";

    2249. 

  2249. 				} else {	

    2250. 

  2250. 					$querycondition 	= 	" leadStatusId IN ( ".@$CIPids." ) AND currentAllocatedId IN (".@$managerMemberId.") ";

    2251. 

  2251. 				}

    2252. 

  2252. 				$dataProvider=new CActiveDataProvider('Lead', array('criteria'=>array(

    2253. 

  2253. 					'condition'=>@$querycondition,

    2254. 

  2254. 					'order'=>'leadId desc',

    2255. 

  2255. 					),

    2256. 

  2256. 					'pagination'=>false,

    2257. 

  2257. 					));

    2258. 

  2258. 			}

    2259. 

  2259. 			if($type=="plc"){

    2260. 

  2260. 			$contactInProgList=Yii::app()->db->createCommand("select leadStatus.leadStatus,leadStatusId from leadStatus where parentId=41")->queryAll();

    2261. 

  2261. 				$CIPids = array();

    2262. 

  2262. 					if(count($contactInProgList) > 0){

    2263. 

  2263. 						for($w=0;$w<count($contactInProgList);$w++){

    2264. 

  2264. 						@$CIPids[] = 	@$contactInProgList[$w]['leadStatusId'];

    2265. 

  2265. 						}

    2266. 

  2266. 					} else {

    2267. 

  2267. 						@$CIPids[] = '';

    2268. 

  2268. 					} 

    2269. 

  2269. 					@$CIPids = implode(",",@$CIPids);

    2270. 

  2270. 					

    2271. 

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

    2272. 

  2272. 					$querycondition 	= 	"leadStatusId IN ( ".@$CIPids." )";

    2273. 

  2273. 				} else {	

    2274. 

  2274. 					$querycondition 	= 	" leadStatusId IN ( ".@$CIPids." ) AND currentAllocatedId IN (".@$managerMemberId.") ";

    2275. 

  2275. 				}

    2276. 

  2276. 				

    2277. 

  2277. 				$dataProvider=new CActiveDataProvider('Lead', array('criteria'=>array(

    2278. 

  2278. 					'condition'=>@$querycondition,

    2279. 

  2279. 					'order'=>'leadId desc',

    2280. 

  2280. 					),

    2281. 

  2281. 					'pagination'=>false,

    2282. 

  2282. 					));

    2283. 

  2283. 			}

    2284. 

  2284. 		 $dataProvider->getTotalItemCount($dataProvider);

    2285. 

  2285. 		

    2286. 

  2286. 

    2287. 

  2287. 			

    2288. 

  2288. 			if($type=="followupLeads" or $type=="Allfollowup"){

    2289. 

  2289. 				$iterator = new CDataProviderIterator($dataProvider);

    2290. 

  2290. 				$file_name = "lms" . "_" . date("Y-m-d_H-i", time()) . ".csv";

    2291. 

  2291. 				header('Content-Type: text/html; charset=utf-8');

    2292. 

  2292. 				header("Content-type: application/octet-stream");

    2293. 

  2293. 				header("Content-Disposition: attachment; filename=\"$file_name\"");

    2294. 

  2294. 				header("Cache-Control: cache, must-revalidate");

    2295. 

  2295. 				header("Pragma: public");

    2296. 

  2296. 				$col = array(

    2297. 

  2297. 				'SNO.','Name','Mobile','AgentId','Lead Desciption','Activity Desciption','Email','Action Type','Date and Time','Description','Owner');

    2298. 

  2298. 				

    2299. 

  2299. 				foreach ($col as $key => $value) {

    2300. 

  2300. 				echo $value . ",";

    2301. 

  2301. 				}

    2302. 

  2302. 				echo "\n";

    2303. 

  2303. 				$i=1;

    2304. 

  2304. 				foreach($iterator as $data) {

    2305. 

  2305. 					echo $i++ . ",";

    2306. 

  2306. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ", @$data->leadDetails->name)) . ",";

    2307. 

  2307. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ", @$data->leadDetails->mobile)) . ",";

    2308. 

  2308. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ", @$data->leadDetails->ws_agentid)) . ",";

    2309. 

  2309. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ", @$data->leadDetails->leadDescription)) . ",";

    2310. 

  2310. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ", @$data->description)) . ",";

    2311. 

  2311. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ", @$data->leadDetails->email)) . ",";

    2312. 

  2312. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ", @$data->actionType)) . ",";

    2313. 

  2313. 					echo date("d/m/y h:i A",$data->createdOn) . ",";

    2314. 

  2314. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ", @$data->description)) . ",";

    2315. 

  2315. 					echo (@$data->userId==@$data->leadDetails->createdBy)?@$data->ownerDetails->firstName." ".@$data->ownerDetails->lastName."(C)":(@$data->ownerDetails->firstName?@$data->ownerDetails->firstName." ".@$data->ownerDetails->lastName:"NA") . ",";

    2316. 

  2316. 				echo "\n";

    2317. 

  2317. 				}

    2318. 

  2318. 	} else {

    2319. 

  2319. 				$iterator = new CDataProviderIterator($dataProvider);

    2320. 

  2320. 				$file_name = "lms" . "_" . date("Y-m-d_H-i", time()) . ".csv";

    2321. 

  2321. 				header('Content-Type: text/html; charset=utf-8');

    2322. 

  2322. 				header("Content-type: application/octet-stream");

    2323. 

  2323. 				header("Content-Disposition: attachment; filename=\"$file_name\"");

    2324. 

  2324. 				header("Cache-Control: cache, must-revalidate");

    2325. 

  2325. 				header("Pragma: public");

    2326. 

  2326. 				$col = array(

    2327. 

  2327. 				'SNO.','Name','Mobile','AgentId','Lead Desciption','Activity Desciption','Email','Lead Stage','Date and Time','Lead Status','Owner','status');

    2328. 

  2328. 				

    2329. 

  2329. 				foreach ($col as $key => $value) {

    2330. 

  2330. 				echo $value . ",";

    2331. 

  2331. 				}

    2332. 

  2332. 				

    2333. 

  2333. 				echo "\n";

    2334. 

  2334. 				$i=1;

    2335. 

  2335. 				foreach($iterator as $data) {

    2336. 

  2336. 				

    2337. 

  2337. 			$sqlDesc = "select group_concat(description) as ActivityDescription from leadFollowup where leadId=".@$data->leadId." "; 

    2338. 

  2338. 			$dataDesc=Yii::app()->db->createCommand($sqlDesc)->queryAll();

    2339. 

  2339. 			

    2340. 

  2340. 			$leadActivity = @$dataDesc[0]['ActivityDescription']?@$dataDesc[0]['ActivityDescription']:'';

    2341. 

  2341. 

    2342. 

  2342. 				

    2343. 

  2343. 					echo $i++ . ",";

    2344. 

  2344. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ", @$data->name)) . ",";

    2345. 

  2345. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ", @$data->mobile)) . ",";

    2346. 

  2346. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ", @$data->ws_agentid)) . ",";

    2347. 

  2347. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ", @$data->leadDescription)) . ",";

    2348. 

  2348. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ", @$leadActivity)) . ",";

    2349. 

  2349. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ", @$data->email)) . ",";

    2350. 

  2350. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ", @$data['leadStageDetails']['leadStage'])) . ",";

    2351. 

  2351. 					echo date("d/m/y h:i A",$data->createdOn) . ",";

    2352. 

  2352. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ", @$data->leadStatusDetails->leadStatus)) . ",";

    2353. 

  2353. 					echo (@$data->currentAllocatedId==@$data->createdBy)?@$data->ownerDetails->firstName." ".@$data->ownerDetails->lastName."(C)":(@$data->ownerDetails->firstName?@$data->ownerDetails->firstName." ".@$data->ownerDetails->lastName:"NA") . ",";

    2354. 

  2354. 				echo "\n";

    2355. 

  2355. 				}

    2356. 

  2356. 	}

    2357. 

  2357. }	

    2358. 

  2358. 	public function actionapiPremimum()

    2359. 

  2359. 		{

    2360. 

  2360. 			$model	=	new Lead();

    2361. 

  2361. 			global $INDIVIDUAL,$FAMILYFLOATER,$GroupCareArray;

    2362. 

  2362. 

    2363. 

  2363. 			$INDIVIDUAL = array(

    2364. 

  2364. 							"200000" => "001",

    2365. 

  2365. 							"300000" => "003",

    2366. 

  2366. 							"400000" => "005",

    2367. 

  2367. 							"500000" => "007",

    2368. 

  2368. 							"700000" => "009",

    2369. 

  2369. 							"1000000" => "011",

    2370. 

  2370. 							"1500000" => "013",

    2371. 

  2371. 							"2000000" => "015",

    2372. 

  2372. 							"2500000" => "017",

    2373. 

  2373. 							"5000000" => "019",

    2374. 

  2374. 							"6000000" => "021"

    2375. 

  2375. 							);

    2376. 

  2376. 			$FAMILYFLOATER = array(

    2377. 

  2377. 				"200000" => "002",

    2378. 

  2378. 				"300000" => "004",

    2379. 

  2379. 							"400000" => "006",

    2380. 

  2380. 							"500000" => "008",

    2381. 

  2381. 							"700000" => "010",

    2382. 

  2382. 							"1000000" => "012",

    2383. 

  2383. 							"1500000" => "014",

    2384. 

  2384. 							"2000000" => "016",

    2385. 

  2385. 							"2500000" => "018",

    2386. 

  2386. 							"5000000" => "020",

    2387. 

  2387. 							"6000000" => "022"

    2388. 

  2388. 							);

    2389. 

  2389. 			$res = new MySanitizeClass;

    2390. 

  2390. 			$parser = new CHtmlPurifier();

    2391. 

  2391. 					if(is_array(@$_REQUEST['ageGroupOfEldestMember'])){

    2392. 

  2392. 					 @$_REQUEST['ageGroupOfEldestMember'] = '';

    2393. 

  2393. 					} else {

    2394. 

  2394. 					 @$_REQUEST['ageGroupOfEldestMember'] = @$_REQUEST['ageGroupOfEldestMember'];

    2395. 

  2395. 					}

    2396. 

  2396. 

    2397. 

  2397. 

    2398. 

  2398. 					if(is_array(@$_REQUEST['numberOfAdult'])){

    2399. 

  2399. 					@$_REQUEST['numberOfAdult'] = '';

    2400. 

  2400. 					} else {

    2401. 

  2401. 					 @$_REQUEST['numberOfAdult'] = @$_REQUEST['numberOfAdult'];

    2402. 

  2402. 					}

    2403. 

  2403. 

    2404. 

  2404. 

    2405. 

  2405. 					if(is_array(@$_REQUEST['coverTypeCd'])){

    2406. 

  2406. 					 @$_REQUEST['coverTypeCd'] = '';

    2407. 

  2407. 					} else {

    2408. 

  2408. 					 @$_REQUEST['coverTypeCd'] = @$_REQUEST['coverTypeCd'];

    2409. 

  2409. 					}

    2410. 

  2410. 

    2411. 

  2411. 					if(is_array(@$_REQUEST['numberOfChildren'])){

    2412. 

  2412. 					 @$_REQUEST['numberOfChildren'] = '';

    2413. 

  2413. 					} else {

    2414. 

  2414. 					 @$_REQUEST['numberOfChildren'] = @$_REQUEST['numberOfChildren'];

    2415. 

  2415. 					}

    2416. 

  2416. 

    2417. 

  2417. 

    2418. 

  2418. 					if(is_array(@$_REQUEST['productId'])){

    2419. 

  2419. 					 @$_REQUEST['productId'] = '';

    2420. 

  2420. 					} else {

    2421. 

  2421. 					 @$_REQUEST['productId'] = @$_REQUEST['productId'];

    2422. 

  2422. 					}

    2423. 

  2423. 

    2424. 

  2424. 

    2425. 

  2425. 					if(is_array(@$_REQUEST['productTerm'])){

    2426. 

  2426. 					 @$_REQUEST['productTerm'] = '';

    2427. 

  2427. 					} else {

    2428. 

  2428. 					 @$_REQUEST['productTerm'] = @$_REQUEST['productTerm'];

    2429. 

  2429. 					}

    2430. 

  2430. 

    2431. 

  2431. 					if(is_array(@$_REQUEST['sumInsured'])){

    2432. 

  2432. 					 @$_REQUEST['sumInsured'] = '';

    2433. 

  2433. 					} else {

    2434. 

  2434. 					 @$_REQUEST['sumInsured'] = @$_REQUEST['sumInsured'];

    2435. 

  2435. 					}

    2436. 

  2436. 					if(is_array(@$_REQUEST['tenure'])){

    2437. 

  2437. 					 @$_REQUEST['tenure'] = '';

    2438. 

  2438. 					} else {

    2439. 

  2439. 					 @$_REQUEST['tenure'] = @$_REQUEST['tenure'];

    2440. 

  2440. 					}

    2441. 

  2441. 			 $query['ageGroupOfEldestMember']=$parser->purify(@$_REQUEST['ageGroupOfEldestMember']);

    2442. 

  2442.                 $query['coverTypeCd']=$parser->purify(@$_REQUEST['coverTypeCd']);

    2443. 

  2443.                 $query['productId']=$parser->purify(@$productId1);

    2444. 

  2444.                 $query['productTerm']=$parser->purify(@$_REQUEST['productTerm']);

    2445. 

  2445.                 $query['sumInsured']=$parser->purify(@$_REQUEST['sumInsured']);

    2446. 

  2446.                 if(@$_REQUEST['coverTypeCd']=="INDIVIDUAL"){

    2447. 

  2447.                 $sumInsured=$parser->purify(intval(@$_REQUEST['sumInsured']));

    2448. 

  2448. 					if(@$sumInsured>0){

    2449. 

  2449. 								$sumInsured1=@$INDIVIDUAL[@$sumInsured];

    2450. 

  2450. 					}

    2451. 

  2451. 					$query['numberOfAdult']=$parser->purify(@$_REQUEST['numberOfAdult']);

    2452. 

  2452. 					$query['numberOfChildren']=0;                                                

    2453. 

  2453. 					}else{

    2454. 

  2454. 					$sumInsured=$parser->purify(intval(@$_REQUEST['sumInsured']));

    2455. 

  2455. 					if(@$sumInsured>0){

    2456. 

  2456. 								$sumInsured1=@$FAMILYFLOATER[@$sumInsured];

    2457. 

  2457. 					}

    2458. 

  2458.                 $query['numberOfAdult']=$parser->purify(@$_REQUEST['numberOfAdult']);

    2459. 

  2459.                 $query['numberOfChildren']=$parser->purify(@$_REQUEST['numberOfChildren']);

    2460. 

  2460.                                                 }

    2461. 

  2461.                 $query['sumInsured1']=@$sumInsured1;

    2462. 

  2462.                 

    2463. 

  2463.                 /*$_SESSION['ageGroupOfEldestMember']=@$query['ageGroupOfEldestMember'];// assign value to session for product tab

    2464. 

  2464.                 $_SESSION['coverTypeCd']                             =@$query['coverTypeCd'];// assign value to session for product tab

    2465. 

  2465.                 $_SESSION['numberOfAdult']                       =@$query['numberOfAdult']+$query['numberOfChildren'];// assign value to session for product tab

    2466. 

  2466.                 $_SESSION['numberOfChildren']                 =@$query['numberOfChildren'];// assign value to session for product tab

    2467. 

  2467.                 $_SESSION['sumInsured']                               =@$sumInsured;// assign value to session for product tab*/

    2468. 

  2468.                 

    2469. 

  2469.                 $premiumArray=$this->csvToArray('tempdata/care_premium.csv');

    2470. 

  2470.                 $totalMember=$query['numberOfAdult']+$query['numberOfChildren'];

    2471. 

  2471.                 $planKey=$query['coverTypeCd'].":".$query['ageGroupOfEldestMember'].":".@$totalMember.":".$query['numberOfChildren'].":".$query['sumInsured1'];

    2472. 

  2472.                 $exactPremiumArray=$this->search(@$premiumArray,'Plan',@$planKey);

    2473. 

  2473. 

    2474. 

  2474. 				$exactCarePremiumArray=explode(":",@$exactPremiumArray[0]['Premium']);

    2475. 

  2475. 				$tenureidx = @$_REQUEST['tenure']-1;

    2476. 

  2476. 				$carePremium	=	@$exactCarePremiumArray[@$tenureidx];

    2477. 

  2477. 				//print_r($exactCarePremiumArray);

    2478. 

  2478. 				

    2479. 

  2479. 				$ncppremiumArray=$this->csvToArray('tempdata/ncb_premium.csv');

    2480. 

  2480. 				$ncbtotalMember=$query['numberOfAdult']+$query['numberOfChildren'];

    2481. 

  2481. 				$ncbplanKey=$query['coverTypeCd'].":".$query['ageGroupOfEldestMember'].":".@$ncbtotalMember.":".$query['numberOfChildren'].":".$query['sumInsured1'];

    2482. 

  2482. 				$ncbexactPremiumArray=$this->search(@$ncppremiumArray,'Plan',@$ncbplanKey);

    2483. 

  2483. 				$exactNCBPremiumArray=explode(":",@$ncbexactPremiumArray[0]['Premium']);

    2484. 

  2484. 				//$tenureidx = $_REQUEST['tenure']-1;

    2485. 

  2485. 				$ncbPremium	=	@$exactNCBPremiumArray[@$tenureidx];

    2486. 

  2486. 				$addCarePremium = str_replace(',','',@$carePremium);

    2487. 

  2487. 				$addNCBPremium = str_replace(',','',@$ncbPremium);

    2488. 

  2488. 				$finalNcbPremium	= number_format($addNCBPremium+$addCarePremium);

    2489. 

  2489. 							

    2490. 

  2490. 				//print_r($premiumArray);

    2491. 

  2491. 				echo  trim(@$carePremium).':'.trim(@$finalNcbPremium);

    2492. 

  2492.                // echo  @$exactPremiumArray[0]['Premium'];

    2493. 

  2493. 			//$this->render('lead_search',array('searched'=>$searched));

    2494. 

  2494. 		}

    2495. 

  2495. 	function csvToArray($csvFileName){

    2496. 

  2496. 											$row = 1;

    2497. 

  2497. 											$dataArray=array();

    2498. 

  2498. 											$columnArray=array();

    2499. 

  2499. 											$k=0;

    2500. 

  2500. 											$i=0;

    2501. 

  2501. 											if (($handle = fopen($csvFileName, "r")) !== FALSE) {

    2502. 

  2502. 															while (($data = fgetcsv($handle, 10000, ",")) !== FALSE) {

    2503. 

  2503. 																			$num = count($data);

    2504. 

  2504. 																			if($k==0){

    2505. 

  2505. 																							 for ($c=0; $c < $num; $c++) {

    2506. 

  2506. 																											$columnArray[$c]=@$data[$c];

    2507. 

  2507. 																							}

    2508. 

  2508. 																			}else{    

    2509. 

  2509. 																							 for ($c=0; $c < $num; $c++) {

    2510. 

  2510. 																											$columnName=$columnArray[$c];

    2511. 

  2511. 																											$dataArray[$i][$columnName]=@$data[$c];

    2512. 

  2512. 																							}

    2513. 

  2513. 																							$i++;                                                                      

    2514. 

  2514. 																			}

    2515. 

  2515. 																			$k++;     

    2516. 

  2516. 																			 $row++;

    2517. 

  2517. 															}

    2518. 

  2518. 															fclose($handle);

    2519. 

  2519. 											}

    2520. 

  2520. 							return $dataArray;

    2521. 

  2521. 			}

    2522. 

  2522. 	function search($array, $key, $value){

    2523. 

  2523. 			$results = array();

    2524. 

  2524. 

    2525. 

  2525. 			if (is_array($array))

    2526. 

  2526. 			{

    2527. 

  2527. 							if (isset($array[$key]) && $array[$key] == $value)

    2528. 

  2528. 											$results[] = $array;

    2529. 

  2529. 

    2530. 

  2530. 							foreach ($array as $subarray){

    2531. 

  2531. 											$results = array_merge($results, $this->search($subarray, $key, $value));

    2532. 

  2532. 										}

    2533. 

  2533. 			}

    2534. 

  2534. 

    2535. 

  2535. 			return $results;

    2536. 

  2536. 	}

    2537. 

  2537. 	function quotesResults(){

    2538. 

  2538.                

    2539. 

  2539. 		

    2540. 

  2540. 		}

    2541. 

  2541. 	public function actiongetPlanDetails(){

    2542. 

  2542. 	

    2543. 

  2543. 	}

    2544. 

  2544. 	public function actionleadCreation(){

    2545. 

  2545. 	include_once("api/api.php");

    2546. 

  2546. 

    2547. 

  2547. 		$pageList =  $this->xml2array(@file_get_contents(ADMINURL.'resource/product_subcategory.xml'),'1','');	

    2548. 

  2548. 		$pageListArray = @$pageList['ProductSubCategory'];	

    2549. 

  2549. 		$subcategoryList  = $this->subcategory_page_array($pageListArray);	

    2550. 

  2550. 		if(sanitize_data(@$_REQUEST['productId'])>0){		

    2551. 

  2551. 				  for($i=0; $i<count($subcategoryList); $i++){    

    2552. 

  2552. 				  if($subcategoryList[$i]["subCategoryId"]==sanitize_data($_REQUEST['productId']))

    2553. 

  2553. 						{

    2554. 

  2554. 							 @$productId1="Care";

    2555. 

  2555. 						   }

    2556. 

  2556. 			  }

    2557. 

  2557. 		}else{

    2558. 

  2558. 			@$productId1="";

    2559. 

  2559. 		}

    2560. 

  2560. 		$query['coverTypeCd']=(@$_REQUEST['coverTypeCd']);

    2561. 

  2561. 		$query['productId']=@$productId1;

    2562. 

  2562. 		$query['sumInsured']=(@$_REQUEST['sumInsured']);

    2563. 

  2563. 	//	if(@$_REQUEST['coverTypeCd']=="INDIVIDUAL"){

    2564. 

  2564. 	//			switch(@$_REQUEST['sumInsured']){

    2565. 

  2565. 	//				case '200000': $sumInsured1="001";

    2566. 

  2566. 	//							   break;

    2567. 

  2567. 	//				case '300000': $sumInsured1="003";

    2568. 

  2568. 	//							   break;

    2569. 

  2569. 	//				case '500000': $sumInsured1="005";

    2570. 

  2570. 	//							   break;

    2571. 

  2571. 	//				case '1000000': $sumInsured1="007";

    2572. 

  2572. 	//							   break;

    2573. 

  2573. 	//				default:	  $sumInsured1="007";

    2574. 

  2574. 	//									   break;

    2575. 

  2575. 	//			}		

    2576. 

  2576. 	//		}else{

    2577. 

  2577. 	//					switch(@$_REQUEST['sumInsured']){

    2578. 

  2578. 	//						case '200000': $sumInsured1="002";

    2579. 

  2579. 	//									   break;

    2580. 

  2580. 	//						case '300000': $sumInsured1="004";

    2581. 

  2581. 	//									   break;

    2582. 

  2582. 	//						case '500000': $sumInsured1="006";

    2583. 

  2583. 	//									   break;

    2584. 

  2584. 	//						case '1000000': $sumInsured1="008";

    2585. 

  2585. 	//									   break;

    2586. 

  2586. 	//						default:	  $sumInsured1="008";

    2587. 

  2587. 	//									   break;

    2588. 

  2588. 	//					}

    2589. 

  2589. 	//			}

    2590. 

  2590. 		$tenure=(@$_REQUEST['tenure']);

    2591. 

  2591. 		$leadstage=(@$_POST['leadstage']);

    2592. 

  2592. 		$subject=(@$_POST['subject']);

    2593. 

  2593. 		$query['sumInsured1']=(@$_REQUEST['sumInsured']);

    2594. 

  2594. 		$query['firstname']=(@$_REQUEST["firstname"]);

    2595. 

  2595. 		$query['lastname']="";

    2596. 

  2596. 		$query['emailaddress1']=(@$_REQUEST["emailaddress1"]);

    2597. 

  2597. 		$query['telephone1']=(@$_REQUEST["telephone1"]);

    2598. 

  2598. 		$query['mobilephone']=(@$_REQUEST["mobilephone"]);

    2599. 

  2599. 		$query['premium']=(@$_REQUEST["premium".@$tenure]);

    2600. 

  2600. 		if(@$_SESSION['agentId']!=''){

    2601. 

  2601. 			$query['agentid']=@$_SESSION['agentId'];

    2602. 

  2602. 		}else{

    2603. 

  2603. 			$query['agentid']=AGENTID;

    2604. 

  2604. 		}

    2605. 

  2605. 		$query['noofyears']=@$tenure;

    2606. 

  2606. 		$query['quoteid']=time();

    2607. 

  2607. 		if(@$leadstage!=''){

    2608. 

  2608. 			$query['leadstage']=@$leadstage;

    2609. 

  2609. 		}else{

    2610. 

  2610. 			$query['leadstage']="SendQuotation";

    2611. 

  2611. 		}

    2612. 

  2612. 		if(@$subject!=''){

    2613. 

  2613. 			$query['subject']=@$subject." - ".(@$_REQUEST["mobilephone"]);

    2614. 

  2614. 		}else{

    2615. 

  2615. 			$query['subject']="Web-".(@$_REQUEST["mobilephone"]);

    2616. 

  2616. 		}

    2617. 

  2617. 		

    2618. 

  2618. 		$dataArray= $this->LeadCreation($query);

    2619. 

  2619. 		$_SESSION["quotationReferenceNum"]=$query['quoteid'];

    2620. 

  2620. 		$_SESSION['mobileSend']="2";

    2621. 

  2621. 		$_SESSION['mobilephone']=(@$_REQUEST["mobilephone"]);

    2622. 

  2622. 		

    2623. 

  2623. 	}

    2624. 

  2624. 	public function actionportalProposal(){

    2625. 

  2625. 	 define("_SITEURL", "http://" . @$_SERVER['SERVER_NAME']. '/religare') ;

    2626. 

  2626. 	 define("ADMINURL", "../", true);

    2627. 

  2627. global $INDIVIDUAL,$FAMILYFLOATER,$GroupCareArray;

    2628. 

  2628. $GroupCareArray = array("200000" => "2 Lac + 2 Lac",    "300000" => "3 Lac + 3 Lac",	"400000" => "4 Lac + 4 Lac",	"500000" => "5 Lac + 5 Lac",	"700000" => "7 Lac + 7 Lac",	"1000000" => "10 Lac + 10 Lac",	"1500000" => "15 Lac + 10 Lac",	"2000000" => "20 Lac + 10 Lac",	"2500000" => "25 Lac + 10 Lac",	"5000000" => "50 Lac + 10 Lac",	"6000000" => "60 Lac + 10 Lac");

    2629. 

  2629. $INDIVIDUAL = array(

    2630. 

  2630.     "200000" => "001",

    2631. 

  2631.     "300000" => "003",

    2632. 

  2632. 	"400000" => "005",

    2633. 

  2633. 	"500000" => "007",

    2634. 

  2634. 	"700000" => "009",

    2635. 

  2635. 	"1000000" => "011",

    2636. 

  2636. 	"1500000" => "013",

    2637. 

  2637. 	"2000000" => "015",

    2638. 

  2638. 	"2500000" => "017",

    2639. 

  2639. 	"5000000" => "019",

    2640. 

  2640. 	"6000000" => "021"

    2641. 

  2641. 	);

    2642. 

  2642. $FAMILYFLOATER = array(

    2643. 

  2643.     "200000" => "002",

    2644. 

  2644.     "300000" => "004",

    2645. 

  2645. 	"400000" => "006",

    2646. 

  2646. 	"500000" => "008",

    2647. 

  2647. 	"700000" => "010",

    2648. 

  2648. 	"1000000" => "012",

    2649. 

  2649. 	"1500000" => "014",

    2650. 

  2650. 	"2000000" => "016",

    2651. 

  2651. 	"2500000" => "018",

    2652. 

  2652. 	"5000000" => "020",

    2653. 

  2653. 	"6000000" => "022"

    2654. 

  2654. 	);

    2655. 

  2655. $WEBSUMINSURED = array(

    2656. 

  2656. 	"200000" => "1",

    2657. 

  2657.     "300000" => "2",

    2658. 

  2658. 	"400000" => "3",

    2659. 

  2659. 	"500000" => "4",

    2660. 

  2660. 	"700000" => "5",

    2661. 

  2661. 	"1000000" => "6",

    2662. 

  2662. 	"1500000" => "7",

    2663. 

  2663. 	"2000000" => "8",

    2664. 

  2664. 	"2500000" => "9",

    2665. 

  2665. 	"5000000" => "10",

    2666. 

  2666. 	"6000000" => "11"

    2667. 

  2667. );

    2668. 

  2668. $WEBSUMINSURED1 = array(

    2669. 

  2669. 	"1" => "200000",

    2670. 

  2670.     "2" => "300000",

    2671. 

  2671. 	"3" => "400000",

    2672. 

  2672. 	"4" => "500000",

    2673. 

  2673. 	"5" => "700000",

    2674. 

  2674. 	"6" => "1000000",

    2675. 

  2675. 	"7" => "1500000",

    2676. 

  2676. 	"8" => "2000000",

    2677. 

  2677. 	"9" => "2500000",

    2678. 

  2678. 	"10" => "5000000",

    2679. 

  2679. 	"11" => "6000000"

    2680. 

  2680. );

    2681. 

  2681. $proposalURL="https://rhicluat.religare.com/portalui/PortalExtProposal.run";	 

    2682. 

  2682. 	 

    2683. 

  2683. 	 

    2684. 

  2684. 			$pageList =  $this->xml2array(@file_get_contents('resource/product_subcategory.xml'),'1','');	

    2685. 

  2685. 			$pageListArray = @$pageList['ProductSubCategory'];	

    2686. 

  2686. 			$subcategoryList  = $this->subcategory_page_array($pageListArray);	

    2687. 

  2687. 			$productId=(@$_POST['productId']);

    2688. 

  2688. 			$sumInsured=(@$_POST['sumInsured']);

    2689. 

  2689. 			$tenure=(@$_POST['premium']);

    2690. 

  2690. 			$totalAdults=(@$_POST['numberOfAdult']);

    2691. 

  2691. 			$numberOfChildren=(@$_POST['numberOfChildren']);

    2692. 

  2692. 			$numberOfAdult=$totalAdults-$numberOfChildren;

    2693. 

  2693. 			$mobileNumber=(@$_POST['mobile']);

    2694. 

  2694. 			$_SESSION['mobilephone']=$mobileNumber;

    2695. 

  2695. 			if($productId>0){		

    2696. 

  2696. 					  for($i=0; $i<count($subcategoryList); $i++){    

    2697. 

  2697. 					  if($subcategoryList[$i]["subCategoryId"]==$productId)

    2698. 

  2698. 							{

    2699. 

  2699. 								 @$productId1=$subcategoryList[$i]["productCode"];

    2700. 

  2700. 							   }

    2701. 

  2701. 				  }

    2702. 

  2702. 			}else{

    2703. 

  2703. 				@$productId1="";

    2704. 

  2704. 			}

    2705. 

  2705. 			

    2706. 

  2706. 			if(($tenure==1) || ($tenure==2)  || ($tenure==3)){}else{header("Location: "._SITEURL);exit;}

    2707. 

  2707. 			if($productId1==""){header("Location: "._SITEURL);exit;}else{}

    2708. 

  2708. 			if(($numberOfChildren==0) || ($numberOfChildren==1) || ($numberOfChildren==2) || ($numberOfChildren==3) || ($numberOfChildren==4)){}else{ header("Location: "._SITEURL);exit;} 

    2709. 

  2709. 			if($totalAdults>1){

    2710. 

  2710. 			

    2711. 

  2711. 				 $ageGroupOfEldestMember=(@$_POST['ageGroupOfEldestMember']);

    2712. 

  2712. 							switch($ageGroupOfEldestMember){

    2713. 

  2713. 											case '18 - 24': $ageGroupOfEldestMember="18 - 24";

    2714. 

  2714. 												   break;

    2715. 

  2715. 											case '25 - 35': $ageGroupOfEldestMember="25 - 35";

    2716. 

  2716. 												   break;

    2717. 

  2717. 											case '36 - 40': $ageGroupOfEldestMember="36 - 40";

    2718. 

  2718. 												   break;

    2719. 

  2719. 											case '41 - 45': $ageGroupOfEldestMember="41 - 45";

    2720. 

  2720. 												   break;

    2721. 

  2721. 											case '46 - 50': $ageGroupOfEldestMember="46 - 50";

    2722. 

  2722. 												   break;

    2723. 

  2723. 											case '51 - 55': $ageGroupOfEldestMember="51 - 55";

    2724. 

  2724. 												   break;

    2725. 

  2725. 											case '56 - 60': $ageGroupOfEldestMember="56 - 60";

    2726. 

  2726. 												   break;

    2727. 

  2727. 											case '61 - 65': $ageGroupOfEldestMember="61 - 65";

    2728. 

  2728. 												   break;

    2729. 

  2729. 											case '66 - 70': $ageGroupOfEldestMember="66 - 70";

    2730. 

  2730. 												   break;

    2731. 

  2731. 											case '71 - 75': $ageGroupOfEldestMember="71 - 75";

    2732. 

  2732. 												   break;

    2733. 

  2733. 											case '76 - 99': $ageGroupOfEldestMember="76 - 99";

    2734. 

  2734. 												   break;

    2735. 

  2735. 											default: $ageGroupOfEldestMember="";

    2736. 

  2736. 												   break;

    2737. 

  2737. 						}

    2738. 

  2738. 						

    2739. 

  2739. 				if($ageGroupOfEldestMember==""){header("Location: "._SITEURL);exit;}else{}

    2740. 

  2740. 				$coverType="FAMILYFLOATER";

    2741. 

  2741. 						if(@$sumInsured>0){

    2742. 

  2742. 								$sumInsured1=$FAMILYFLOATER[@$sumInsured];

    2743. 

  2743. 							}

    2744. 

  2744. 					if($sumInsured1==""){header("Location: "._SITEURL);exit;}else{}

    2745. 

  2745. 					//$url1="&numberOfAdult=".@$numberOfAdult."&numberOfChildren=".@$numberOfChildren;

    2746. 

  2746. 				//	$url="Location: ".@$proposalURL."?productFamily=HEALTH&pCode=".@$productId1."&coverType=FAMILYFLOATER&ageGroupOfEldestMember=".@$ageGroupOfEldestMember."&sumInsured=".@$sumInsured1."&tenure=".@$tenure.$url1."&mobileNum=".@$_POST['mobile'];				

    2747. 

  2747. 			}else if($totalAdults=="1"){ 

    2748. 

  2748. 							 $ageGroupOfEldestMember=@$_POST['ageGroupOfEldestMember'];

    2749. 

  2749. 							

    2750. 

  2750. 							switch($ageGroupOfEldestMember){

    2751. 

  2751. 											case '5 - 24': $ageGroupOfEldestMember="5 - 24";

    2752. 

  2752. 												   break;

    2753. 

  2753. 											case '25 - 35': $ageGroupOfEldestMember="25 - 35";

    2754. 

  2754. 												   break;

    2755. 

  2755. 											case '36 - 40': $ageGroupOfEldestMember="36 - 40";

    2756. 

  2756. 												   break;

    2757. 

  2757. 											case '41 - 45': $ageGroupOfEldestMember="41 - 45";

    2758. 

  2758. 												   break;

    2759. 

  2759. 											case '46 - 50': $ageGroupOfEldestMember="46 - 50";

    2760. 

  2760. 												   break;

    2761. 

  2761. 											case '51 - 55': $ageGroupOfEldestMember="51 - 55";

    2762. 

  2762. 												   break;

    2763. 

  2763. 											case '56 - 60': $ageGroupOfEldestMember="56 - 60";

    2764. 

  2764. 												   break;

    2765. 

  2765. 											case '61 - 65': $ageGroupOfEldestMember="61 - 65";

    2766. 

  2766. 												   break;

    2767. 

  2767. 											case '66 - 70': $ageGroupOfEldestMember="66 - 70";

    2768. 

  2768. 												   break;

    2769. 

  2769. 											case '71 - 75': $ageGroupOfEldestMember="71 - 75";

    2770. 

  2770. 												   break;

    2771. 

  2771. 											case '76 - 99': $ageGroupOfEldestMember="76 - 99";

    2772. 

  2772. 												   break;

    2773. 

  2773. 											default: $ageGroupOfEldestMember="";

    2774. 

  2774. 												   break;

    2775. 

  2775. 							}

    2776. 

  2776. 							$coverType="INDIVIDUAL";

    2777. 

  2777. 							

    2778. 

  2778. 							if($ageGroupOfEldestMember==""){header("Location: "._SITEURL);exit;}else{}

    2779. 

  2779. 							if(@$sumInsured>0){

    2780. 

  2780. 								$sumInsured1=$INDIVIDUAL[@$sumInsured];

    2781. 

  2781. 							}

    2782. 

  2782. 							

    2783. 

  2783. 						

    2784. 

  2784. 							if($sumInsured1==""){header("Location: "._SITEURL);exit;}else{}

    2785. 

  2785. 							$numberOfAdult=0;

    2786. 

  2786. 							$numberOfChildren=0;

    2787. 

  2787. 							

    2788. 

  2788. 						//	$url1="&numberOfAdult=0&numberOfChildren=0";		

    2789. 

  2789. 							//$url="Location: ".@$proposalURL."?productFamily=HEALTH&pCode=".@$productId1."&coverType=INDIVIDUAL&ageGroupOfEldestMember=".@$ageGroupOfEldestMember."&sumInsured=".@$sumInsured1."&tenure=".@$tenure.$url1."&mobileNum=".@$_SESSION['mobilephone'];	

    2790. 

  2790. 			}else{

    2791. 

  2791. 				header("Location: "._SITEURL);exit;

    2792. 

  2792. 			}

    2793. 

  2793. 			?>

    2794. 

  2794.             <form name="PortalProposal" id="PortalProposal" method="post" action="<?=@$proposalURL;?>">

    2795. 

  2795. 			<input type="hidden" name="productFamily" value="HEALTH" />

    2796. 

  2796. 			<input type="hidden" name="pCode" value="<?=@$productId1;?>" />

    2797. 

  2797. 			<input type="hidden" name="coverType" value="<?=@$coverType;?>" />

    2798. 

  2798. 			<input type="hidden" name="ageGroupOfEldestMember" value="<?=@$ageGroupOfEldestMember;?>" />

    2799. 

  2799. 			<input type="hidden" name="sumInsured" value="<?=@$sumInsured1;?>" />

    2800. 

  2800. 			<input type="hidden" name="tenure" value="<?=@$tenure;?>" />

    2801. 

  2801. 			<input type="hidden" name="numberOfAdult" value="<?=@$numberOfAdult;?>" />

    2802. 

  2802. 			<input type="hidden" name="numberOfChildren" value="<?=@$numberOfChildren;?>" />

    2803. 

  2803. 			<input type="hidden" name="mobileNum" value="<?=@$mobileNumber;?>" />

    2804. 

  2804. 			<input type="hidden" name="quotationReferenceNum" value="<?=@$_SESSION['quotationReferenceNum'];?>" />

    2805. 

  2805. 			<input type="hidden" name="agentId" value="<?=@$_SESSION['agentId'];?>" />

    2806. 

  2806. 			</form>

    2807. 

  2807. 			<script>

    2808. 

  2808. 			document.PortalProposal.submit();

    2809. 

  2809. 			</script>

    2810. 

  2810.             <?php

    2811. 

  2811. 

    2812. 

  2812. 	

    2813. 

  2813. 	}

    2814. 

  2814. 	function xml2array($contents, $get_attributes=1, $priority = 'tag'){

    2815. 

  2815.         if(!$contents) return array();

    2816. 

  2816.    

    2817. 

  2817.         if(!function_exists('xml_parser_create')) {

    2818. 

  2818.             //print "'xml_parser_create()' function not found!";

    2819. 

  2819.             return array();

    2820. 

  2820.         }

    2821. 

  2821.    

    2822. 

  2822.         //Get the XML parser of PHP - PHP must have this module for the parser to work

    2823. 

  2823.         $parser = xml_parser_create('');

    2824. 

  2824.         xml_parser_set_option($parser, XML_OPTION_TARGET_ENCODING, "UTF-8"); # http://minutillo.com/steve/weblog/2004/6/17/php-xml-and-character-encodings-a-tale-of-sadness-rage-and-data-loss

    2825. 

  2825.         xml_parser_set_option($parser, XML_OPTION_CASE_FOLDING, 0);

    2826. 

  2826.         xml_parser_set_option($parser, XML_OPTION_SKIP_WHITE, 1);

    2827. 

  2827.         xml_parse_into_struct($parser, trim($contents), $xml_values);

    2828. 

  2828.         xml_parser_free($parser);

    2829. 

  2829.    

    2830. 

  2830.         if(!$xml_values) return;//Hmm...

    2831. 

  2831.    

    2832. 

  2832.         //Initializations

    2833. 

  2833.         $xml_array = array();

    2834. 

  2834.         $parents = array();

    2835. 

  2835.         $opened_tags = array();

    2836. 

  2836.         $arr = array();

    2837. 

  2837.    

    2838. 

  2838.         $current = &$xml_array; //Refference

    2839. 

  2839.    

    2840. 

  2840.         //Go through the tags.

    2841. 

  2841.         $repeated_tag_index = array();//Multiple tags with same name will be turned into an array

    2842. 

  2842.         foreach($xml_values as $data) {

    2843. 

  2843.             unset($attributes,$value);//Remove existing values, or there will be trouble

    2844. 

  2844.    

    2845. 

  2845.             //This command will extract these variables into the foreach scope

    2846. 

  2846.             // tag(string), type(string), level(int), attributes(array).

    2847. 

  2847.             extract($data);//We could use the array by itself, but this cooler.

    2848. 

  2848.    

    2849. 

  2849.             $result = array();

    2850. 

  2850.             $attributes_data = array();

    2851. 

  2851.            

    2852. 

  2852.             if(isset($value)) {

    2853. 

  2853.                 if($priority == 'tag') $result = $value;

    2854. 

  2854.                 else $result['value'] = $value; //Put the value in a assoc array if we are in the 'Attribute' mode

    2855. 

  2855.             }

    2856. 

  2856.    

    2857. 

  2857.             //Set the attributes too.

    2858. 

  2858.             if(isset($attributes) and $get_attributes) {

    2859. 

  2859.                 foreach($attributes as $attr => $val) {

    2860. 

  2860.                     if($priority == 'tag') $attributes_data[$attr] = $val;

    2861. 

  2861.                     else $result['attr'][$attr] = $val; //Set all the attributes in a array called 'attr'

    2862. 

  2862.                 }

    2863. 

  2863.             }

    2864. 

  2864.    

    2865. 

  2865.             //See tag status and do the needed.

    2866. 

  2866.             if($type == "open") {//The starting of the tag '<tag>'

    2867. 

  2867.                 $parent[$level-1] = &$current;

    2868. 

  2868.                 if(!is_array($current) or (!in_array($tag, array_keys($current)))) { //Insert New tag

    2869. 

  2869.                     $current[$tag] = $result;

    2870. 

  2870.                     if($attributes_data) $current[$tag. '_attr'] = $attributes_data;

    2871. 

  2871.                     $repeated_tag_index[$tag.'_'.$level] = 1;

    2872. 

  2872.    

    2873. 

  2873.                     $current = &$current[$tag];

    2874. 

  2874.    

    2875. 

  2875.                 } else { //There was another element with the same tag name

    2876. 

  2876.    

    2877. 

  2877.                     if(isset($current[$tag][0])) {//If there is a 0th element it is already an array

    2878. 

  2878.                         $current[$tag][$repeated_tag_index[$tag.'_'.$level]] = $result;

    2879. 

  2879.                         $repeated_tag_index[$tag.'_'.$level]++;

    2880. 

  2880.                     } else {//This section will make the value an array if multiple tags with the same name appear together

    2881. 

  2881.                         $current[$tag] = array($current[$tag],$result);//This will combine the existing item and the new item together to make an array

    2882. 

  2882.                         $repeated_tag_index[$tag.'_'.$level] = 2;

    2883. 

  2883.                        

    2884. 

  2884.                         if(isset($current[$tag.'_attr'])) { //The attribute of the last(0th) tag must be moved as well

    2885. 

  2885.                             $current[$tag]['0_attr'] = $current[$tag.'_attr'];

    2886. 

  2886.                             unset($current[$tag.'_attr']);

    2887. 

  2887.                         }

    2888. 

  2888.    

    2889. 

  2889.                     }

    2890. 

  2890.                     $last_item_index = $repeated_tag_index[$tag.'_'.$level]-1;

    2891. 

  2891.                     $current = &$current[$tag][$last_item_index];

    2892. 

  2892.                 }

    2893. 

  2893.    

    2894. 

  2894.             } elseif($type == "complete") { //Tags that ends in 1 line '<tag />'

    2895. 

  2895.                 //See if the key is already taken.

    2896. 

  2896.                 if(!isset($current[$tag])) { //New Key

    2897. 

  2897.                     $current[$tag] = $result;

    2898. 

  2898.                     $repeated_tag_index[$tag.'_'.$level] = 1;

    2899. 

  2899.                     if($priority == 'tag' and $attributes_data) $current[$tag. '_attr'] = $attributes_data;

    2900. 

  2900.    

    2901. 

  2901.                 } else { //If taken, put all things inside a list(array)

    2902. 

  2902.                     if(isset($current[$tag][0]) and is_array($current[$tag])) {//If it is already an array...

    2903. 

  2903.    

    2904. 

  2904.                         // ...push the new element into that array.

    2905. 

  2905.                         $current[$tag][$repeated_tag_index[$tag.'_'.$level]] = $result;

    2906. 

  2906.                        

    2907. 

  2907.                         if($priority == 'tag' and $get_attributes and $attributes_data) {

    2908. 

  2908.                             $current[$tag][$repeated_tag_index[$tag.'_'.$level] . '_attr'] = $attributes_data;

    2909. 

  2909.                         }

    2910. 

  2910.                         $repeated_tag_index[$tag.'_'.$level]++;

    2911. 

  2911.    

    2912. 

  2912.                     } else { //If it is not an array...

    2913. 

  2913.                         $current[$tag] = array($current[$tag],$result); //...Make it an array using using the existing value and the new value

    2914. 

  2914.                         $repeated_tag_index[$tag.'_'.$level] = 1;

    2915. 

  2915.                         if($priority == 'tag' and $get_attributes) {

    2916. 

  2916.                             if(isset($current[$tag.'_attr'])) { //The attribute of the last(0th) tag must be moved as well

    2917. 

  2917.                                

    2918. 

  2918.                                 $current[$tag]['0_attr'] = $current[$tag.'_attr'];

    2919. 

  2919.                                 unset($current[$tag.'_attr']);

    2920. 

  2920.                             }

    2921. 

  2921.                            

    2922. 

  2922.                             if($attributes_data) {

    2923. 

  2923.                                 $current[$tag][$repeated_tag_index[$tag.'_'.$level] . '_attr'] = $attributes_data;

    2924. 

  2924.                             }

    2925. 

  2925.                         }

    2926. 

  2926.                         $repeated_tag_index[$tag.'_'.$level]++; //0 and 1 index is already taken

    2927. 

  2927.                     }

    2928. 

  2928.                 }

    2929. 

  2929.    

    2930. 

  2930.             } elseif($type == 'close') { //End of tag '</tag>'

    2931. 

  2931.                 $current = &$parent[$level-1];

    2932. 

  2932.             }

    2933. 

  2933.         }

    2934. 

  2934. 		

    2935. 

  2935.         return($xml_array);

    2936. 

  2936.     }

    2937. 

  2937. 	function subcategory_page_array($pageListArray1){

    2938. 

  2938. 		$m =0;

    2939. 

  2939. 		$dataArr=array();

    2940. 

  2940. 		if(is_array(@$pageListArray1['subcategory'][0]) )	{		

    2941. 

  2941. 			$pageListArray = $pageListArray1['subcategory'];

    2942. 

  2942. 			for($i=0;$i<sizeof($pageListArray);$i++)			{

    2943. 

  2943. 				if(trim($pageListArray[$i]['isDeleted']['value'])=='no'){

    2944. 

  2944. 						$dataArr[$m]['subCategoryId'] 	  = trim($pageListArray[$i]['subCategoryId']['value']);

    2945. 

  2945. 						$dataArr[$m]['categoryId'] 	  	  =trim(@$pageListArray[$i]['categoryId']['value']);

    2946. 

  2946. 						$dataArr[$m]['subCategoryName']	  = @$pageListArray[$i]['subCategoryName']['value'];

    2947. 

  2947. 						$dataArr[$m]['productCode']	  = @$pageListArray[$i]['productCode']['value'];

    2948. 

  2948. 						$dataArr[$m]['description']	 	 = @$pageListArray[$i]['description']['value'];

    2949. 

  2949. 						$dataArr[$m]['briefDescription'] = @$pageListArray[$i]['briefDescription']['value'];

    2950. 

  2950. 						$dataArr[$m]['metaTitle']	 	 = @$pageListArray[$i]['metaTitle']['value'];

    2951. 

  2951. 						$dataArr[$m]['metaDescription']	 = @$pageListArray[$i]['metaDescription']['value'];

    2952. 

  2952. 						$dataArr[$m]['metaKeywords']	 = @$pageListArray[$i]['metaKeywords']['value'];

    2953. 

  2953. 						$dataArr[$m]['compare']	  		 = @$pageListArray[$i]['compare']['value'];

    2954. 

  2954. 						$dataArr[$m]['exclusions']	 	 =@$pageListArray[$i]['exclusions']['value'];

    2955. 

  2955. 						$dataArr[$m]['policyTerms']	 	 =@$pageListArray[$i]['policyTerms']['value'];

    2956. 

  2956. 						$dataArr[$m]['agentpolicyTerms'] =@$pageListArray[$i]['agentpolicyTerms']['value'];

    2957. 

  2957. 						$dataArr[$m]['claim']	  		 = @$pageListArray[$i]['claim']['value'];

    2958. 

  2958. 						$dataArr[$m]['logo']	  		 = @$pageListArray[$i]['logo']['value'];

    2959. 

  2959. 						$dataArr[$m]['thumbnail']	  	 = @$pageListArray[$i]['thumbnail']['value'];

    2960. 

  2960. 						$dataArr[$m]['isDeleted']        = trim($pageListArray[$i]['isDeleted']['value']);

    2961. 

  2961. 						$m++;

    2962. 

  2962. 				}

    2963. 

  2963. 			}

    2964. 

  2964. 		}else	{

    2965. 

  2965. 				$pageListArray = @$pageListArray1['subcategory'];	

    2966. 

  2966. 				if(trim($pageListArray['isDeleted']['value']) =='no') 	{

    2967. 

  2967. 						$dataArr[$m]['subCategoryId'] 	= trim($pageListArray['subCategoryId']['value']);

    2968. 

  2968. 						$dataArr[$m]['categoryId'] 		= trim($pageListArray['categoryId']['value']);

    2969. 

  2969. 						$dataArr[$m]['subCategoryName'] = $pageListArray['subCategoryName']['value'];

    2970. 

  2970. 						$dataArr[$m]['productCode']	  = @$pageListArray['productCode']['value'];

    2971. 

  2971. 						$dataArr[$m]['description']	  	= $pageListArray['description']['value'];

    2972. 

  2972. 						$dataArr[$m]['briefDescription']= $pageListArray['briefDescription']['value'];

    2973. 

  2973. 						$dataArr[$m]['metaTitle']	  	= $pageListArray['metaTitle']['value'];

    2974. 

  2974. 						$dataArr[$m]['metaDescription']	= $pageListArray['metaDescription']['value'];

    2975. 

  2975. 						$dataArr[$m]['metaKeywords']	 = $pageListArray['metaKeywords']['value'];

    2976. 

  2976. 						$dataArr[$m]['compare']	  		= $pageListArray['compare']['value'];

    2977. 

  2977. 						$dataArr[$m]['exclusions']	  	= $pageListArray['exclusions']['value'];

    2978. 

  2978. 						$dataArr[$m]['claim']	 		= $pageListArray['claim']['value'];

    2979. 

  2979. 						$dataArr[$m]['policyTerms']	 	 =@$pageListArray['policyTerms']['value'];

    2980. 

  2980. 						$dataArr[$m]['agentpolicyTerms']	 	 =@$pageListArray['agentpolicyTerms']['value'];

    2981. 

  2981. 						$dataArr[$m]['logo']	  		= @$pageListArray['logo']['value'];

    2982. 

  2982. 						$dataArr[$m]['thumbnail']	  	= @$pageListArray['thumbnail']['value'];

    2983. 

  2983. 						$dataArr[$m]['isDeleted']		= trim($pageListArray[$i]['isDeleted']['value']);		

    2984. 

  2984. 						$m++;

    2985. 

  2985. 					}

    2986. 

  2986. 		}

    2987. 

  2987. 	//sort by

    2988. 

  2988. 		if (count ($dataArr) > 0) {

    2989. 

  2989. 		foreach ($dataArr as $key => $row) {

    2990. 

  2990. 			@$order_in_category[$key]  = $row[0];//[0] is @$order_in_category

    2991. 

  2991. 		}

    2992. 

  2992. 			@array_multisort(@$order_in_category, SORT_ASC, $dataArr);

    2993. 

  2993. 		}

    2994. 

  2994. 	return $dataArr;

    2995. 

  2995. 	}

    2996. 

  2996. 	public function actiongetWebserviceLeadXMLResponse(){

    2997. 

  2997. 	$data='';

    2998. 

  2998. 	$leadURL=$_SERVER['DOCUMENT_ROOT']."/religarewebservices/data";

    2999. 

  2999. 	$r=0;

    3000. 

  3000. 	

    3001. 

  3001. 	foreach(glob($leadURL . '/*request.xml') as $files){

    3002. 

  3002. 		 $checkLeadExistorNot=Lead::model()->findByAttributes(array('fileName'=>$files));

    3003. 

  3003. 		   if(count($checkLeadExistorNot)==0){

    3004. 

  3004. 		   		$data=file_get_contents($files);

    3005. 

  3005. 				$result=$this->xml2array($data);

    3006. 

  3006. 				 $createdLeadDetails=$result['SOAP:Envelope']['SOAP:Body']['Createlead']['Lead'];

    3007. 

  3007. 				 $OrganizationName=$result['SOAP:Envelope']['SOAP:Body']['Createlead']['OrganizationName'];

    3008. 

  3008. 				 $type='Lead';

    3009. 

  3009. 				 $leadsourceCode=$createdLeadDetails['leadsourcecode'];

    3010. 

  3010. 				 $subject=$createdLeadDetails['subject'];

    3011. 

  3011. 				 $firstname=$createdLeadDetails['firstname'];

    3012. 

  3012. 				 $lastname=$createdLeadDetails['lastname'];

    3013. 

  3013. 				 $emailaddress1=$createdLeadDetails['emailaddress1'];

    3014. 

  3014. 				 $telephone1=$createdLeadDetails['telephone1'];

    3015. 

  3015. 				 $mobilephone=$createdLeadDetails['mobilephone'];

    3016. 

  3016. 				 $product=$createdLeadDetails['rhi_product'];

    3017. 

  3017. 				 $suminsured=$createdLeadDetails['rhi_suminsured'];

    3018. 

  3018. 				 $suminsured=(count($suminsured) > 0)?$suminsured:0;

    3019. 

  3019. 				 $premium=$createdLeadDetails['rhi_premium'];

    3020. 

  3020. 				 $premium=(count($premium) > 0)?$premium:0;

    3021. 

  3021. 				 $quoteid=$createdLeadDetails['rhi_quoteid'];

    3022. 

  3022. 				 $proposalid=$createdLeadDetails['rhi_proposalid'];

    3023. 

  3023. 				 $leadstage=$createdLeadDetails['rhi_leadstage'];

    3024. 

  3024. 				 $agentid=$createdLeadDetails['rhi_agentid'];

    3025. 

  3025. 				 $noofyears=$createdLeadDetails['rhi_noofyears'];

    3026. 

  3026. 				 $ProductMaster=ProductMaster::model()->findByAttributes(array('productName'=>$product));

    3027. 

  3027. 				 $productId=$ProductMaster['productId'];

    3028. 

  3028. 				

    3029. 

  3029. 					if(count($result) > 0){

    3030. 

  3030. 					//echo $files;

    3031. 

  3031. 						$model = new Lead;

    3032. 

  3032. 						  $model->setAttributes(array(

    3033. 

  3033. 								'name' => 'web services', 

    3034. 

  3034. 								'email' => '', 

    3035. 

  3035. 								'mobile' => $mobilephone, 

    3036. 

  3036. 								'productId' => $productId, 

    3037. 

  3037. 								'members' => 0, 

    3038. 

  3038. 								'si' => $suminsured, 

    3039. 

  3039. 								'premium' => $premium, 

    3040. 

  3040. 								'leadStageId' => '', 

    3041. 

  3041. 								'fileName' => addslashes($files), 

    3042. 

  3042. 								'status' => 'Active', 

    3043. 

  3043. 								'createdOn' => time(), 

    3044. 

  3044. 								'updatedOn' => time(), 

    3045. 

  3045. 								'updatedBy' => time(), 

    3046. 

  3046. 								'createdBy' => time(),						

    3047. 

  3047. 						));

    3048. 

  3048. 						//print_r($model); 

    3049. 

  3049. 						$model->isNewRecord = true;

    3050. 

  3050. 						@$model->save(false);

    3051. 

  3051. 						

    3052. 

  3052. 					} $r++;

    3053. 

  3053. 					

    3054. 

  3054. 		}		

    3055. 

  3055. 	}

    3056. 

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

    3057. 

  3057. 	}	

    3058. 

  3058. 	public function actionfresh_leads()

    3059. 

  3059. 	{	

    3060. 

  3060. 		//$modelLead	=	Lead::model()->findAll("leadStatusId = '34' AND currentAllocatedId<1 ");		

    3061. 

  3061. 		$this->render('fresh_lead_list');

    3062. 

  3062. 	}

    3063. 

  3063. 	public function actionviewAllTeams() {

    3064. 

  3064.         if (!Yii::app()->request->isAjaxRequest){

    3065. 

  3065. 		   }

    3066. 

  3066.         else {

    3067. 

  3067.             $this->renderPartial('/leads/partialAllTeamDetails');

    3068. 

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

    3069. 

  3069.         }

    3070. 

  3070.     }

    3071. 

  3071. 	public function actionViewLeadActivity() {

    3072. 

  3072. 		$followupId=@$_REQUEST['id'];

    3073. 

  3073. 			$model=new LeadFollowup;

    3074. 

  3074. 			$model=LeadFollowup::model()->findByPk($followupId);

    3075. 

  3075.         if (!Yii::app()->request->isAjaxRequest){

    3076. 

  3076.            // $this->render('yourView');

    3077. 

  3077. 		   }

    3078. 

  3078.         else {

    3079. 

  3079.             $this->renderPartial('/leads/ViewLeadActivity',array('model'=>$model));

    3080. 

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

    3081. 

  3081.         }

    3082. 

  3082.     }

    3083. 

  3083. 	public function actionViewCalenderActs() {

    3084. 

  3084. 	//$cs = Yii::app()->getClientScript();	$cs->registerCoreScript('jquery');

    3085. 

  3085. 	$this->layout=false;

    3086. 

  3086. 		$startDate=@$_REQUEST['id'];

    3087. 

  3087.  $model = 	LeadFollowup::model()->findAll(array("condition"=>"startDate = '".@$startDate."' AND userId = '".@$_SESSION['id']."' AND STATUS = 'Pending' AND (actionType = 'Meeting' OR actionType = 'Follow Up') ORDER BY hour DESC"));

    3088. 

  3088.  

    3089. 

  3089.         if (!Yii::app()->request->isAjaxRequest){

    3090. 

  3090.            $this->renderPartial('/leads/ViewCalenderActs',array('model'=>$model,'startDate'=>@$startDate));

    3091. 

  3091. 		   }

    3092. 

  3092.         else {

    3093. 

  3093.             $this->renderPartial('/leads/ViewCalenderActs',array('model'=>$model,'startDate'=>@$startDate));

    3094. 

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

    3095. 

  3095.         }

    3096. 

  3096.     }

    3097. 

  3097. 	

    3098. 

  3098. 	public function actionEditCalenderActivity() {

    3099. 

  3099. 	

    3100. 

  3100. 	$this->layout=false;

    3101. 

  3101. 	   $leadId=@$_REQUEST['leadId'];

    3102. 

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

    3103. 

  3103.             $this->renderPartial('EditCalenderActivity',array('leadId'=>$leadId,'actionId'=>$actionId) ,false, true);

    3104. 

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

    3105. 

  3105.            

    3106. 

  3106.     }

    3107. 

  3107. 	

    3108. 

  3108. 	public function actiongetActionRes(){

    3109. 

  3109. 	$statusids = @$_POST['statusids'];

    3110. 

  3110. 	$model = new LeadStatus;

    3111. 

  3111. 		$model=LeadStatus::model()->findByPk($statusids);

    3112. 

  3112. 		echo $result = @$model['actionCompulsary'];

    3113. 

  3113. 	}

    3114. 

  3114. 	public function actioncip_lead_list()

    3115. 

  3115. 	{

    3116. 

  3116. 		//$model = new LeadStatus;

    3117. 

  3117. 		$this->render('contact_in_progress_lead_list');

    3118. 

  3118. 	}

    3119. 

  3119. 	public function actioncld_lead_list()

    3120. 

  3120. 	{

    3121. 

  3121. 		//$model = new Lead;

    3122. 

  3122. 		$this->render('cld_lead_list');

    3123. 

  3123. 	}

    3124. 

  3124. 	public function actionsearchCIP(){

    3125. 

  3125. 		if(Yii::app()->request->isAjaxRequest==1){

    3126. 

  3126. 		

    3127. 

  3127. 		

    3128. 

  3128. 			$models=new Lead();

    3129. 

  3129. 			$searchIDs =@$_REQUEST['searchIDs'];

    3130. 

  3130. 			if(isset($searchIDs) && !empty($searchIDs)){

    3131. 

  3131. 			$this->renderPartial('partialcip',array('searchTxt'=>$searchIDs,'type'=>'cip'));

    3132. 

  3132. 			}

    3133. 

  3133. 		} else {

    3134. 

  3134. 			$redirectUrl = Yii::app()->controller->id."/".$this->action->id;

    3135. 

  3135. 			$this->redirect("index.php?r=leads/cip_lead_list&pageSize=".@$_REQUEST['pageSize']);

    3136. 

  3136. 		}

    3137. 

  3137. 	}

    3138. 

  3138. 	public function actiondup_forthe_day_lead_list()

    3139. 

  3139. 	{

    3140. 

  3140. 		//$modelLead	= new Lead;	

    3141. 

  3141. 		$this->render('duplicate_forthe_daylead_list');

    3142. 

  3142. 	}

    3143. 

  3143. 	public function actionSearchArchiveLeads(){

    3144. 

  3144. 		$model = new Lead;

    3145. 

  3145. 		$teamId = @$_POST['Team']['teamId'];	

    3146. 

  3146. 		$Leadname = @$_POST['Lead']['name'];	

    3147. 

  3147. 		$Leadstatus = @$_POST['Lead']['status'];	

    3148. 

  3148. 		$leadStage = @$_POST['Lead']['leadStage'];	

    3149. 

  3149. 		$leadws_agentid = @$_POST['Lead']['ws_agentid'];	

    3150. 

  3150. 		$leademail = @$_POST['Lead']['email'];	

    3151. 

  3151. 		$leadmobile = @$_POST['Lead']['mobile'];	

    3152. 

  3152. 		$this->render('archive_leads',array('model'=>$model,'teamId'=>$teamId,'Leadname'=>$Leadname,'Leadstatus'=>$Leadstatus,'leadStage'=>$leadStage,'Leadmobile'=>$leadmobile,'Leademail'=>$leademail,'Leadws_agentid'=>$leadws_agentid));

    3153. 

  3153. 		

    3154. 

  3154. 	}

    3155. 

  3155. 	public function actionplc_lead_list()

    3156. 

  3156. 	{

    3157. 

  3157. 		//$model	= new Lead;	

    3158. 

  3158. 		$this->render('plc_lead_list');

    3159. 

  3159. 	}

    3160. 

  3160. 	public function getAgentIds($ws_agentid,$mobile){

    3161. 

  3161. 		$agentIds=Yii::app()->db->createCommand("select group_concat(distinct ws_agentid) as ws_agentid,count(distinct ws_agentid) as total from lead where mobile='".@$mobile."' and ws_agentid!='' order by leadId desc ")->queryAll();

    3162. 

  3162. 		

    3163. 

  3163. 		

    3164. 

  3164. 		if( $agentIds[0]['total'] > 1){

    3165. 

  3165. 			echo "<label class='linkUnderline' title='".@$agentIds[0]['ws_agentid']."'><a href='#'>".$ws_agentid."</a></label>";

    3166. 

  3166. 		

    3167. 

  3167. 		} else if($agentIds[0]['total'] == 1)   {

    3168. 

  3168. 			echo "<label title='".@$agentIds[0]['ws_agentid']."'><a href='#'>".$ws_agentid."</a></label>";

    3169. 

  3169. 		} else {

    3170. 

  3170. 			echo "";

    3171. 

  3171. 		}

    3172. 

  3172. 		

    3173. 

  3173. 		//echo explode(',',$agentId);

    3174. 

  3174. 	}	

    3175. 

  3175. 	public function getLeadStagesIds($leadStageId,$mobile){

    3176. 

  3176. 		$agentIds=Yii::app()->db->createCommand("select distinct leadStageId from lead where mobile='".@$mobile."' and leadStageId!='' order by leadId desc ")->queryAll();

    3177. 

  3177. 		$displayedSyage=Yii::app()->db->createCommand("select leadStage from leadStageMaster where leadStageId='".@$leadStageId."' ")->queryAll();

    3178. 

  3178. 		

    3179. 

  3179. 		if(count($agentIds) > 0) {

    3180. 

  3180. 		 for($i=0;$i<count($agentIds);$i++){ 

    3181. 

  3181. 		 

    3182. 

  3182. 		 $leadstages=Yii::app()->db->createCommand("select leadStage from leadStageMaster where leadStageId='".@$agentIds[$i]['leadStageId']."' ")->queryAll();

    3183. 

  3183. 		 	$agentId[] = @$agentIds[$i]['leadStageId'];

    3184. 

  3184. 		 	$leadstages_new[] = @$leadstages[0]['leadStage'];

    3185. 

  3185. 		 }

    3186. 

  3186. 		} else {

    3187. 

  3187. 		echo "";

    3188. 

  3188. 		}

    3189. 

  3189. 		

    3190. 

  3190. 		if( count(@$leadstages_new) > 1){

    3191. 

  3191. 			echo "<label class='linkUnderline' title='".implode(',',$leadstages_new)."'><a href='#'>".@$displayedSyage[0]['leadStage']."</a></label>";

    3192. 

  3192. 		

    3193. 

  3193. 		} else if( count(@$leadstages_new) == 1)   {

    3194. 

  3194. 			echo "<label title='".implode(',',@$leadstages_new)."'><a href='#'>".@$displayedSyage[0]['leadStage']."</a></label>";

    3195. 

  3195. 		} else {

    3196. 

  3196. 			echo "";

    3197. 

  3197. 		}

    3198. 

  3198. 		

    3199. 

  3199. 		//echo explode(',',$agentId);

    3200. 

  3200. 	}	

    3201. 

  3201. 	public function actioninactive_users_leads()

    3202. 

  3202. 	{

    3203. 

  3203. 		$this->render('inactive_users_leads');

    3204. 

  3204. 	}

    3205. 

  3205. 	public function actionInactiveAllocateLeads()

    3206. 

  3206. 	{		

    3207. 

  3207. 		$Id			=	$_REQUEST['userids'];

    3208. 

  3208. 		$teamId		=	@$_REQUEST['Team']['teamId'];

    3209. 

  3209. 		$userId		=	$_REQUEST['Team']['teamMemberId'];

    3210. 

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

    3211. 

  3211. 		

    3212. 

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

    3213. 

  3213. 			$model	=	new AllocatedLeads();

    3214. 

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

    3215. 

  3215. 			$model->setAttributes(array(

    3216. 

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

    3217. 

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

    3218. 

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

    3219. 

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

    3220. 

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

    3221. 

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

    3222. 

  3222. 			));				

    3223. 

  3223. 			$leadId = @$value;

    3224. 

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

    3225. 

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

    3226. 

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

    3227. 

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

    3228. 

  3228. 			$model->allocatedId = null;

    3229. 

  3229. 			$model->isNewRecord = true;

    3230. 

  3230. 			$model->save();			

    3231. 

  3231. 			$model=new Lead();

    3232. 

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

    3233. 

  3233. 			$updatedOn		=	time();

    3234. 

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

    3235. 

  3235. 			}

    3236. 

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

    3237. 

  3237. 			

    3238. 

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

    3239. 

  3239. 				$this->redirect(array('leads/inactive_users_leads'));

    3240. 

  3240. 			} else {

    3241. 

  3241. 				$this->redirect(array('leads/inactive_users_leads'));

    3242. 

  3242. 			}

    3243. 

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

    3244. 

  3244. 	}

    3245. 

  3245. 	public function getLeadDescription($leadId){

    3246. 

  3246. 		$records=Yii::app()->db->createCommand("select leadDescription  from lead where leadId='".@$leadId."' ")->queryAll();

    3247. 

  3247. 		

    3248. 

  3248. 		if(count($records) > 0) {

    3249. 

  3249. 		 for($i=0;$i<count($records);$i++){ 

    3250. 

  3250. 		 	$record[] = @$records[$i]['leadDescription'];

    3251. 

  3251. 		 }

    3252. 

  3252. 		} else {

    3253. 

  3253. 		echo "";

    3254. 

  3254. 		}

    3255. 

  3255. 		

    3256. 

  3256. 		if( count(@$record) > 1){

    3257. 

  3257. 			echo "<label  title='".implode(',',$record)."'><a href='#'>".substr(implode(',',$record),0,5)."...</a></label>";

    3258. 

  3258. 		

    3259. 

  3259. 		} else if( count(@$record) == 1)   {

    3260. 

  3260. 			echo "<label title='".implode(',',@$record)."'><a href='#'>".implode(',',$record)."</a></label>";

    3261. 

  3261. 		} else {

    3262. 

  3262. 			echo "";

    3263. 

  3263. 		}

    3264. 

  3264. 		//echo explode(',',$agentId);

    3265. 

  3265. 	}	

    3266. 

  3266. 	public function getLeadActivityDescription($leadId){

    3267. 

  3267. 		$records=Yii::app()->db->createCommand("select description from leadFollowup where leadId='".@$leadId."' ")->queryAll();

    3268. 

  3268. 		if(count($records) > 0) {

    3269. 

  3269. 		 for($i=0;$i<count($records);$i++){ 

    3270. 

  3270. 		 	$record[] = @$records[$i]['description'];

    3271. 

  3271. 		 }

    3272. 

  3272. 		} else {

    3273. 

  3273. 		echo "";

    3274. 

  3274. 		}

    3275. 

  3275. 		

    3276. 

  3276. 		if( count(@$record) > 1){

    3277. 

  3277. 			echo "<label  title='".implode(',',$record)."'><a href='#'>".substr(implode(',',$record),0,5)."...</a></label>";

    3278. 

  3278. 		

    3279. 

  3279. 		} else if( count(@$record) == 1)   {

    3280. 

  3280. 			echo "<label title='".implode(',',@$record)."'><a href='#'>".substr(implode(',',$record),0,5)."...</a></label>";

    3281. 

  3281. 		} else {

    3282. 

  3282. 			echo "";

    3283. 

  3283. 		}

    3284. 

  3284. 		

    3285. 

  3285. 		//echo explode(',',$agentId);

    3286. 

  3286. 	}	

    3287. 

  3287. 	public function actionloadleadtabs(){

    3288. 

  3288. 		$this->layout = false;

    3289. 

  3289. 		$this->renderPartial('leadTabs');

    3290. 

  3290. 	}

    3291. 

  3291. 	public function actiondeleted_database_tab()

    3292. 

  3292. 	{

    3293. 

  3293. 		$model=new Lead();

    3294. 

  3294. 		$model->set_period1=@$_POST['Lead']['period1']?@$_POST['Lead']['period1']:@$_REQUEST['period1'];

    3295. 

  3295. 		$model->set_period2=@$_POST['Lead']['period2']?@$_POST['Lead']['period2']:@$_REQUEST['period2'];

    3296. 

  3296. 		

    3297. 

  3297. 		$this->render('deleted_database_tab',array('model'=>$model));

    3298. 

  3298. 	}

    3299. 

  3299. 	public function actiondelete_lead()

    3300. 

  3300. 	{

    3301. 

  3301.         $deleteId=@$_REQUEST['leadId'];

    3302. 

  3302. 		

    3303. 

  3303. 		 if(Yii::app()->request->isAjaxRequest){

    3304. 

  3304. 			if(!empty($deleteId))

    3305. 

  3305. 			{

    3306. 

  3306. 				$model=Lead::model()->findByPk($deleteId);

    3307. 

  3307. 			}

    3308. 

  3308. 			else

    3309. 

  3309. 			{

    3310. 

  3310. 			$model = new Lead();

    3311. 

  3311. 			}

    3312. 

  3312. 			if($model->delete($deleteId)){

    3313. 

  3313. 			echo "Record deleted successfully";

    3314. 

  3314. 			} else {

    3315. 

  3315. 			echo "some error occured please try after some time";

    3316. 

  3316. 			}

    3317. 

  3317. 		} else {

    3318. 

  3318. 		$this->redirect(array('leads/deleted_database_tab'));

    3319. 

  3319. 		}

    3320. 

  3320. 	}

    3321. 

  3321. 	public function actionDeleteAllJunkLeads()

    3322. 

  3322. 	{

    3323. 

  3323. 		$model = new lead;

    3324. 

  3324. 		//print_r($_REQUEST);

    3325. 

  3325. 		$Id=$_REQUEST['leadids'];

    3326. 

  3326. 		

    3327. 

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

    3328. 

  3328. 			$model->deleteByPk($value);

    3329. 

  3329. 		}

    3330. 

  3330. 		$this->redirect(Yii::app()->request->urlReferrer);

    3331. 

  3331. 	}

    3332. 

  3332. 	

    3333. 

  3333. 	public function actionDeleteAllJunkLeadsOneTime()

    3334. 

  3334. 	{

    3335. 

  3335. 		$model = new lead;

    3336. 

  3336. 		

    3337. 

  3337. 		echo $startDate = @$_REQUEST['period1'];

    3338. 

  3338. 		$endDate = @$_REQUEST['period2'];

    3339. 

  3339. 		$alldeletedIds = @$_POST['alldeletedIds'];

    3340. 

  3340. 		$Id=unserialize(urldecode($_POST['alldeletedIds']));

    3341. 

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

    3342. 

  3342. 		//echo $value;

    3343. 

  3343. 			$model->deleteByPk($value);

    3344. 

  3344. 		}

    3345. 

  3345. 			

    3346. 

  3346. 			$modeldel = new leadsdeletedby;

    3347. 

  3347. 			$modeldel->id='';

    3348. 

  3348. 			$modeldel->startdate=@$startDate;

    3349. 

  3349. 			$modeldel->enddate=@$endDate;

    3350. 

  3350. 			$modeldel->data=$alldeletedIds;

    3351. 

  3351. 			$modeldel->deletedOn=time();

    3352. 

  3352. 			$modeldel->deletedBy=Yii::app()->session->get('userName');

    3353. 

  3353. 			$modeldel->deletedById=Yii::app()->session->get('id');

    3354. 

  3354. 		/* $modeldel->setAttributes(array(

    3355. 

  3355. 				'id' => '', //additional data you want to insert

    3356. 

  3356. 				'startdate' => @$startDate, //additional

    3357. 

  3357. 				'enddate' => @$endDate, //additional

    3358. 

  3358. 				'data' => 'sdfsdf', //additional

    3359. 

  3359. 				'deletedOn' => time(), //additional

    3360. 

  3360. 				'deletedBy' => Yii::app()->session->get('userName'), //additional

    3361. 

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

    3362. 

  3362. 		

    3363. 

  3363. 		));*/

    3364. 

  3364. 		

    3365. 

  3365. 		$modeldel->save();

    3366. 

  3366. 		$this->redirect(Yii::app()->request->urlReferrer);

    3367. 

  3367. 	}

    3368. 

  3368. 	

    3369. 

  3369. 	public function actionuser_monthly_report() {

    3370. 

  3370.            $this->render('user_monthly_report');

    3371. 

  3371.     }

    3372. 

  3372. 	public function actionuser_login_report() {

    3373. 

  3373. 	       	$this->render('user_login_report');

    3374. 

  3374.     }

    3375. 

  3375. 	public function actiondownload_login_report() {

    3376. 

  3376.      	$limitvalue = @$_REQUEST['fetchrecordsBydropdown'];

    3377. 

  3377. 		$userid = @$_REQUEST['User']['id'];

    3378. 

  3378. 		

    3379. 

  3379. 			if(isset($limitvalue) && !empty($limitvalue) && isset($userid) && !empty($userid)){

    3380. 

  3380. 					

    3381. 

  3381. 			$paginationExcelValue = @$_POST['fetchrecordsBydropdown'];

    3382. 

  3382. 			

    3383. 

  3383. 			if(isset($paginationExcelValue) && !empty($paginationExcelValue)){

    3384. 

  3384. 				$explodedpaginationValue = explode('-',$paginationExcelValue);

    3385. 

  3385. 				 $startLimit = $explodedpaginationValue[0];

    3386. 

  3386. 				 $endLimit = 10000;

    3387. 

  3387. 			} else {

    3388. 

  3388. 				 $startLimit = '';

    3389. 

  3389. 				 $endLimit = '';

    3390. 

  3390. 			

    3391. 

  3391. 			}

    3392. 

  3392. 			if(isset($startLimit) && isset($endLimit) && !empty($endLimit)){

    3393. 

  3393. 				$limitCond = " limit $startLimit , $endLimit";

    3394. 

  3394. 			} else {

    3395. 

  3395. 				$limitCond = '';

    3396. 

  3396. 			}

    3397. 

  3397. 			//Here is the code to set conditions for fetch records from database

    3398. 

  3398. 			$condfilter = '';

    3399. 

  3399. 			

    3400. 

  3400. 			if(isset($userid) && !empty($userid))

    3401. 

  3401. 					{	

    3402. 

  3402. 					

    3403. 

  3403. 					if(isset($userid) && !empty($userid))

    3404. 

  3404. 					{

    3405. 

  3405. 						$condfilter .= "t.userid = ".$userid." AND ";

    3406. 

  3406. 					}

    3407. 

  3407. 					if(isset($condfilter) && !empty($condfilter)){

    3408. 

  3408. 						$wherecon = "WHERE ";

    3409. 

  3409. 					} else {

    3410. 

  3410. 						$wherecon = "";

    3411. 

  3411. 					}

    3412. 

  3412. 					

    3413. 

  3413. 					$data=Yii::app()->db->createCommand("select t.userId,t.userName,t.loginTime,t.type from userloginlog as t $wherecon $condfilter t.userId > 0 order by t.logId DESC $limitCond")->queryAll();

    3414. 

  3414. 				

    3415. 

  3415. 					}else{

    3416. 

  3416. 					$data=0;

    3417. 

  3417. 					}

    3418. 

  3418. 			

    3419. 

  3419. 					

    3420. 

  3420. 			if(count($data)>0){

    3421. 

  3421. 			 $file_name = "lms" . "_" . date("Y-m-d_H-i", time()) . ".csv";

    3422. 

  3422. 					header('Content-Type: text/html; charset=utf-8');

    3423. 

  3423. 					header("Content-type: application/octet-stream");

    3424. 

  3424. 					header("Content-Disposition: attachment; filename=\"$file_name\"");

    3425. 

  3425. 					header("Cache-Control: cache, must-revalidate");

    3426. 

  3426. 					header("Pragma: public");

    3427. 

  3427. 					 $col = array(

    3428. 

  3428. 					  'SNO.','User Name','loginTime');

    3429. 

  3429. 					  foreach ($col as $key => $value) {

    3430. 

  3430. 						echo $value . ",";

    3431. 

  3431. 					}

    3432. 

  3432. 					echo "\n";

    3433. 

  3433. 						$i=1;

    3434. 

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

    3435. 

  3435. 						$loginTime = date("d M Y  H:i:s A",$value['loginTime']);

    3436. 

  3436. 							echo $i++ . ",";

    3437. 

  3437. 							echo @$value["userName"] . ",";

    3438. 

  3438. 							echo @$loginTime . ",";

    3439. 

  3439. 						echo "\n";

    3440. 

  3440. 					}

    3441. 

  3441. 			

    3442. 

  3442. 			}

    3443. 

  3443. 			else{

    3444. 

  3444. 					$this->redirect('index.php?r=leads/user_login_report');

    3445. 

  3445. 					//$dataProvider=new CActiveDataProvider('LeadReport', array('criteria'=>@$criteria,));	

    3446. 

  3446. 					//$this->render('reports',array('model'=>$model,'dataProvider'=>$dataProvider));

    3447. 

  3447. 			}

    3448. 

  3448. 			} else {

    3449. 

  3449. 	       	$this->render('user_login_report');

    3450. 

  3450. 		   }

    3451. 

  3451.     }

    3452. 

  3452. 	public static function getMTD($leadStatusId){

    3453. 

  3453. 	

    3454. 

  3454. 	

    3455. 

  3455. 		$CurrentMonth_first_minute = mktime(0, 0, 0, date("n"), 1);

    3456. 

  3456. 		$CurrentMonth_last_minute = mktime(23, 59, 0, date("n"), date("t"));

    3457. 

  3457. 		$sql = "select count(leadId) as total from lead l join user u on u.id=l.currentAllocatedId where l.leadStatusId = ".@$leadStatusId."  and (l.updatedOn between '".@$CurrentMonth_first_minute."' and '".@$CurrentMonth_last_minute."') and u.status='Active' limit 1 "; 

    3458. 

  3458. 		$count=Yii::app()->db->createCommand($sql)->queryColumn();

    3459. 

  3459. 		

    3460. 

  3460. 		echo @$count[0];

    3461. 

  3461. 		//echo Lead::model()->count(array("select"=>'leadid',"condition"=>" leadStatusId = ".@$leadStatusId.""));

    3462. 

  3462. 	}

    3463. 

  3463. 	public static function getYTD($leadStatusId){

    3464. 

  3464. 		$CurrentYear_first_minute = mktime(0, 0, 0, 1, 1, date('Y'));

    3465. 

  3465. 		$CurrentYear_last_minute = mktime(0, 0, 0, 13, 0, date('Y'));

    3466. 

  3466. 		$sql = "select count(leadId) as total from lead l join user u on u.id=l.currentAllocatedId where l.leadStatusId = ".@$leadStatusId."  and (l.updatedOn between '".@$CurrentYear_first_minute."' and  '".@$CurrentYear_last_minute."') and u.status='Active' ";

    3467. 

  3467. 		$count=Yii::app()->db->createCommand($sql)->queryColumn();

    3468. 

  3468. 		//echo Lead::model()->count(array("select"=>'leadid',"condition"=>" leadStatusId = ".@$leadStatusId.""));

    3469. 

  3469. 			echo @$count[0];

    3470. 

  3470. 	}

    3471. 

  3471. 	public static function getUniqueMobLeadCountByStatus($leadStatusId){

    3472. 

  3472. 

    3473. 

  3473. 		if(isset($leadStatusId) && !empty($leadStatusId)){

    3474. 

  3474. 		

    3475. 

  3475. 			$todayexpiryDate= date('d-M-Y',time());

    3476. 

  3476. 			$nontydaystime=strtotime("-90 days",strtotime($todayexpiryDate));

    3477. 

  3477. 			

    3478. 

  3478. 			$date1Filer = @$_REQUEST['Lead']['createdOn'];	

    3479. 

  3479. 			$date2Filer = @$_REQUEST['Lead']['createdOn2'];	

    3480. 

  3480. 			

    3481. 

  3481. 			$leadFilter = @$_REQUEST['LeadSourceMaster']['leadSourceId'];	

    3482. 

  3482. 		

    3483. 

  3483. 			$filterCond ='';

    3484. 

  3484. 			if(isset($leadFilter) && !empty($leadFilter)){

    3485. 

  3485. 				$filterCond .= " AND l.leadSourceId = ".$leadFilter."";

    3486. 

  3486. 			}

    3487. 

  3487. 			if(isset($date1Filer) && !empty($date1Filer) && isset($date2Filer) && !empty($date2Filer)){

    3488. 

  3488. 				$date1Filer = strtotime($date1Filer);

    3489. 

  3489. 				$date2Filer = strtotime($date2Filer);

    3490. 

  3490. 				$filterCond .= " AND l.createdOn >= ".$date1Filer." and l.createdOn <= ".$date2Filer."";

    3491. 

  3491. 			}	

    3492. 

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

    3493. 

  3493. 			//$sql = "select mobile  from lead l where l.leadStatusId=".$leadStatusId." $filterCond "; 

    3494. 

  3494. 			$sql = "select count(l.mobile) as totalunique from lead l where l.leadStatusId=".$leadStatusId." and l.leadStatusId != 10 $filterCond group by l.leadStatusId "; 

    3495. 

  3495. 		 } else {

    3496. 

  3496. 		  $impresuser = DashboardController::implodeResult(Yii::app()->session['relationalManager']); 

    3497. 

  3497. 			$sql = "select count(l.mobile) as totalunique from lead l where l.leadStatusId=".$leadStatusId." and l.leadStatusId != 10 and l.currentAllocatedId IN (".@$impresuser.")  $filterCond group by l.leadStatusId "; 

    3498. 

  3498. 		 }

    3499. 

  3499. 		//echo $res = Lead::model()->count(array("select"=>"count(distinct mobile) as totalunique","condition"=>"  leadStatusId=".$leadStatusId." $filterCond "));

    3500. 

  3500. 		//$count=Yii::app()->db->createCommand($sql)->queryScalar();

    3501. 

  3501. 		$count=Yii::app()->db->createCommand($sql)->queryScalar();

    3502. 

  3502. 		/*$criteria = new CDbCriteria();

    3503. 

  3503. 		$criteria->select = "mobile"; 

    3504. 

  3504. 		$criteria->condition = " leadStatusId=".$leadStatusId."";

    3505. 

  3505. 		$count=Lead::model()->findAll($criteria);*/

    3506. 

  3506. 		

    3507. 

  3507. 		//echo count($count);

    3508. 

  3508. 		 

    3509. 

  3509. 		echo @$count?@$count:0;

    3510. 

  3510. 		} else {

    3511. 

  3511. 		echo 0;

    3512. 

  3512. 		}

    3513. 

  3513. 		//echo Lead::model()->count(array("select"=>'leadid',"condition"=>" leadStatusId = ".@$leadStatusId.""));

    3514. 

  3514. 	}

    3515. 

  3515. 	public function actiondownload_monthly_report(){

    3516. 

  3516. 		

    3517. 

  3517. 		$selectedMonth = @$_REQUEST['selectedMonth']; 

    3518. 

  3518. 		if(Yii::app()->session->get('type')=='superadmin' or Yii::app()->session->get('roleId')==4){	

    3519. 

  3519. 		$userId = @$_REQUEST['User']['id'];

    3520. 

  3520. 		} else {

    3521. 

  3521. 		$userId = Yii::app()->session->get('id');

    3522. 

  3522. 		}

    3523. 

  3523. 		$startmonthTime = @$_REQUEST['startTime_'.$selectedMonth]; 

    3524. 

  3524. 		$endMonthTime = @$_REQUEST['endtime_'.$selectedMonth];

    3525. 

  3525. 		

    3526. 

  3526. 		

    3527. 

  3527. 		$wherecon =  "t.updatedOn >= ".$startmonthTime." and t.updatedOn <= ".$endMonthTime." and t.currentAllocatedId=".@$userId." ";

    3528. 

  3528. 	

    3529. 

  3529. 		if(empty($startmonthTime) or empty($endMonthTime)){

    3530. 

  3530. 		$data = array();

    3531. 

  3531. 		} else {

    3532. 

  3532. 		 $sqlquery = "select t.leadId,t.name,t.mobile,t.email,t.address,t.members,t.premium,t.productDetails,t.ws_agentid,t.status,t.isJunk,t.leadDescription,t.currentAllocatedId,t.createdBy,t.updatedOn,`user`.`id`,`user`.`firstName`,`user`.`lastName`,`city`.`city`, `state`.`state`, `leadSourceMaster`.`leadSourceTitle`,`leadSourceMaster`.`leadSourceCode`,`leadStageMaster`.`leadStage`,`leadStatus`.`leadStatus`, `customerTypeMaster`.`customerType`,`productMaster`.`productName`,`policyTypeMaster`.`policyType`,`planTypeMaster`.`planType`,`campaign`.`campaignName`  from lead as t LEFT JOIN city ON (city.cityId = t.cityId) LEFT JOIN state ON (state.stateId = t.stateId) LEFT JOIN leadSourceMaster ON (leadSourceMaster.leadSourceId = t.leadSourceId) LEFT JOIN leadStageMaster ON (leadStageMaster.leadStageId = t.leadStageId)LEFT JOIN leadStatus ON (leadStatus.leadStatusId  = t.leadStatusId)LEFT JOIN customerTypeMaster ON (customerTypeMaster.customerTypeId  = t.customerTypeId)LEFT JOIN productMaster ON (productMaster.productId  = t.productId) LEFT JOIN policyTypeMaster ON (policyTypeMaster.policyTypeId  = t.policyTypeId)LEFT JOIN planTypeMaster ON (planTypeMaster.planTypeId  = t.planTypeId) LEFT JOIN campaign ON (campaign.campaignId  = t.campaignId) LEFT JOIN user ON (user.id=t.currentAllocatedId) where $wherecon and t.leadId > 0 order by t.leadId DESC limit 0,10000";

    3533. 

  3533. 		$data=Yii::app()->db->createCommand($sqlquery)->queryAll();

    3534. 

  3534. 		}

    3535. 

  3535. 		

    3536. 

  3536. 	if(count($data)>0){

    3537. 

  3537. 	 $file_name = "lmsmonthlyreport" . "_" .$userId. date("Y-m-d_H-i", time()) . ".csv";

    3538. 

  3538. 			header('Content-Type: text/html; charset=utf-8');

    3539. 

  3539. 			header("Content-type: application/octet-stream");

    3540. 

  3540. 			header("Content-Disposition: attachment; filename=\"$file_name\"");

    3541. 

  3541. 			header("Cache-Control: cache, must-revalidate");

    3542. 

  3542. 			header("Pragma: public");

    3543. 

  3543. 			 $col = array(

    3544. 

  3544. 			  'SNO.','Name','Mobile Number',' Email Id','Address','City','State','Members','Premium','Product Details','Lead Status','Status','isJunk','Lead Source','Lead Stage','Lead Description','Activity Description','Customer Type','Product Name','Policy Type','Plan Type','Campaign Name','UTM Code','Owner','Last Modified Date','Agent-Id'

    3545. 

  3545. 		);

    3546. 

  3546. 	

    3547. 

  3547. 			  foreach ($col as $key => $value) {

    3548. 

  3548. 				echo $value . ",";

    3549. 

  3549. 			}

    3550. 

  3550. 			echo "\n";

    3551. 

  3551. 				$i=1;

    3552. 

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

    3553. 

  3553. 	

    3554. 

  3554. 				if($value['currentAllocatedId']==$value['createdBy']){

    3555. 

  3555. 				$owner = $value['firstName']." ".$value['lastName']."(C)";

    3556. 

  3556. 				} else {

    3557. 

  3557. 						if(isset($value['firstName']) && !empty($value['firstName'])){

    3558. 

  3558. 						$owner = $value['firstName']." ".$value['lastName'];

    3559. 

  3559. 						} else {

    3560. 

  3560. 						$owner = "NA";

    3561. 

  3561. 						}

    3562. 

  3562. 				}

    3563. 

  3563. 				if(isset($value['updatedOn']) && !empty($value['updatedOn'])){ 

    3564. 

  3564. 				  $strtme = date("d M Y  H:i:s A",$value['updatedOn']);

    3565. 

  3565. 				} else{ $strtme = 'NA'; }

    3566. 

  3566. 				$lastModifieddate = $strtme;

    3567. 

  3567. 

    3568. 

  3568. 				$sqlDesc = "select group_concat(description) as ActivityDescription from leadFollowup where leadId=".@$value["leadId"]." "; 

    3569. 

  3569. 				$dataDesc=Yii::app()->db->createCommand($sqlDesc)->queryAll();

    3570. 

  3570. 				

    3571. 

  3571. 				$leadActivity = @$dataDesc[0]['ActivityDescription']?stripslashes(preg_replace("/^'|[^A-Za-z0-9@._\'-]|'$/", " ",@$dataDesc[0]['ActivityDescription'])):'';

    3572. 

  3572. 

    3573. 

  3573. 				

    3574. 

  3574. 					echo $i++ . ",";

    3575. 

  3575. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ", @$value["name"])) . ",";

    3576. 

  3576. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ",@$value["mobile"])) . ",";

    3577. 

  3577. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9@._\'-]|'$/", " ",@$value["email"])) . ",";

    3578. 

  3578. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9@._\'-]|'$/", " ",@$value["address"])) . ",";

    3579. 

  3579. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ",@$city)) . ",";

    3580. 

  3580. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ",@$state)) . ",";

    3581. 

  3581. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ",@$value["members"])) . ",";

    3582. 

  3582. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ",@$value["premium"])) . ",";

    3583. 

  3583. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ",@$value['productDetails'])) . ",";

    3584. 

  3584. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ",@$value['leadStatus'])) . ",";

    3585. 

  3585. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ",@$value['status'])) . ",";

    3586. 

  3586. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ",@$value['isJunk'])) . ",";

    3587. 

  3587. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ",@$value['leadSourceTitle'])) . ",";

    3588. 

  3588. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9\'-]|'$/", " ",@$value['leadStage'])) . ",";;

    3589. 

  3589. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9@._\'-]|'$/", " ",@$value["leadDescription"])) . ",";

    3590. 

  3590. 					echo @$leadActivity . ",";

    3591. 

  3591. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9@._\'-]|'$/", " ",@$value["customerType"])) . ",";

    3592. 

  3592. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9@._\'-]|'$/", " ",@$value["productName"])) . ",";

    3593. 

  3593. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9@._\'-]|'$/", " ",@$value["policyType"])) . ",";

    3594. 

  3594. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9@._\'-]|'$/", " ",@$value["planType"])) . ",";

    3595. 

  3595. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9@._\'-]|'$/", " ",@$value["campaignName"])) . ",";

    3596. 

  3596. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9@._\'-]|'$/", " ",@$value["leadSourceCode"])) . ",";

    3597. 

  3597. 					echo @$owner . ",";

    3598. 

  3598. 					echo @$lastModifieddate . ",";

    3599. 

  3599. 					echo stripslashes(preg_replace("/^'|[^A-Za-z0-9@._\'-]|'$/", " ",@$value["ws_agentid"])) . ",";

    3600. 

  3600. 				echo "\n";

    3601. 

  3601. 			}

    3602. 

  3602. 	

    3603. 

  3603. 	} else {

    3604. 

  3604. 	Yii::app()->user->setFlash('msg','No Record Found');

    3605. 

  3605. 	$this->render('user_monthly_report');

    3606. 

  3606. 	}

    3607. 

  3607. 

    3608. 

  3608. 

    3609. 

  3609. 

    3610. 

  3610. 	}

    3611. 

  3611. 

    3612. 

  3612. //Lead Assignment without page refresh

    3613. 

  3613. public function actionAllocateLeadsByAjax(){		

    3614. 

  3614. 	

    3615. 

  3615. 		$Id			=	$_REQUEST['userids'];

    3616. 

  3616. 		$teamId		=	@$_REQUEST['Team']['teamId'];

    3617. 

  3617. 		$userId		=	$_REQUEST['Team']['teamMemberId'];

    3618. 

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

    3619. 

  3619. 		$actionurl = @$_REQUEST['actionurl'];

    3620. 

  3620. 		$paginationsize = Yii::app()->user->getState('pageSize',Yii::app()->params['defaultPageSize'])?Yii::app()->user->getState('pageSize',Yii::app()->params['defaultPageSize']):25;

    3621. 

  3621. 		$userdetails=Yii::app()->db->createCommand("select firstName,lastName from user where id=".$userId." ")->queryAll();

    3622. 

  3622. 		$myArray = array();

    3623. 

  3623. 		$responseAll =array();

    3624. 

  3624. 		$t=0;

    3625. 

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

    3626. 

  3626. 					$model	=	new AllocatedLeads();

    3627. 

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

    3628. 

  3628. 					$model->setAttributes(array(

    3629. 

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

    3630. 

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

    3631. 

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

    3632. 

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

    3633. 

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

    3634. 

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

    3635. 

  3635. 					));				

    3636. 

  3636. 					$leadId = @$value;

    3637. 

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

    3638. 

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

    3639. 

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

    3640. 

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

    3641. 

  3641. 					$model->allocatedId = null;

    3642. 

  3642. 					$model->isNewRecord = true;

    3643. 

  3643. 					$model->save();			

    3644. 

  3644. 					$model=new Lead();

    3645. 

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

    3646. 

  3646. 					$updatedOn		=	time();

    3647. 

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

    3648. 

  3648. 					

    3649. 

  3649. 				$responseAll[$t]['ownername'] = $userdetails[0]['firstName']." ".$userdetails[0]['lastName'];

    3650. 

  3650. 				$responseAll[$t]['classname'] = "owner_".@$value;

    3651. 

  3651. 				$responseAll[$t]['rowclass'] = @$value;

    3652. 

  3652. 				$myArray[0][$t]=$responseAll[$t];

    3653. 

  3653. 				$myArray[1]['roleId']=Yii::app()->session->get('roleId');

    3654. 

  3654. 				$myArray[2]['actionurl']=$actionurl;

    3655. 

  3655. 				$myArray[3]['paginationsize']=$paginationsize;

    3656. 

  3656. 				

    3657. 

  3657. 			$t++;

    3658. 

  3658. 					

    3659. 

  3659. 					}	

    3660. 

  3660. 					

    3661. 

  3661. 					

    3662. 

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

    3663. 

  3663.    

    3664. 

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

    3665. 

  3665. 	{	

    3666. 

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

    3667. 

  3667. 			

    3668. 

  3668. 			

    3669. 

  3669. 			//print_r($myArray); die;

    3670. 

  3670. 			//echo "superadmin".$userdetails[0]['firstName'].$userdetails[0]['lastName'];

    3671. 

  3671. 			

    3672. 

  3672. 			echo json_encode($myArray);

    3673. 

  3673. 			

    3674. 

  3674. 		} else if(Yii::app()->session->get('roleId')==4 or Yii::app()->session->get('isAllocator')=='yes') {

    3675. 

  3675. 			echo json_encode($myArray);

    3676. 

  3676. 		} else {

    3677. 

  3677. 		$myArray=array('somethingwrong');

    3678. 

  3678. 			echo json_encode($myArray);

    3679. 

  3679. 		}

    3680. 

  3680. 		exit;

    3681. 

  3681. 	}

    3682. 

  3682. 

    3683. 

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

    3684. 

  3684. 	{

    3685. 

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

    3686. 

  3686. 	}

    3687. 

  3687. 	$this->redirect(array('leads/fresh_leads')); 	

    3688. 

  3688. 		  

    3689. 

  3689. 

    3690. 

  3690.   

    3691. 

  3691. }

    3692. 

  3692. 	public function actiongetLeadStagesIds(){

    3693. 

  3693. 	$leadStageId=@$_REQUEST['leadStageId'];

    3694. 

  3694. 	$mobile=@$_REQUEST['mobile'];

    3695. 

  3695. 	$leadid=@$_REQUEST['leadid'];

    3696. 

  3696. 		$agentIds=Yii::app()->db->createCommand("select group_concat(distinct leadStageMaster.leadStage) as leadStage,count(distinct lead.leadStageId) as total from lead left join leadStageMaster on leadStageMaster.leadStageId=lead.leadStageId where lead.mobile='".@$mobile."' and lead.leadStageId!='' order by lead.leadId desc ")->queryAll();

    3697. 

  3697. 		//$displayedSyage=Yii::app()->db->createCommand("select leadStage from leadStageMaster where leadStageId='".@$leadStageId."' ")->queryAll();

    3698. 

  3698. 		

    3699. 

  3699. 		if( $agentIds[0]['total'] >= 1){

    3700. 

  3700. 			echo @$agentIds[0]['leadStage'];

    3701. 

  3701. 		

    3702. 

  3702. 		} else {

    3703. 

  3703. 			echo "";

    3704. 

  3704. 		}

    3705. 

  3705. 		

    3706. 

  3706. 		//echo explode(',',$agentId);

    3707. 

  3707. 	}	

    3708. 

  3708. 

    3709. 

  3709. 	public function actiongetAgentIds(){

    3710. 

  3710. 	$ws_agentid=@$_REQUEST['ws_agentid'];

    3711. 

  3711. 	$mobile=@$_REQUEST['mobile'];

    3712. 

  3712. 	echo $leadid=@$_REQUEST['leadid'];

    3713. 

  3713. 		$agentIds=Yii::app()->db->createCommand("select group_concat(distinct ws_agentid) as ws_agentid,count(distinct ws_agentid) as total from lead where mobile='".@$mobile."' and ws_agentid!='' order by leadId desc ")->queryAll();

    3714. 

  3714. 		

    3715. 

  3715. 		

    3716. 

  3716. 		if( $agentIds[0]['total'] >= 1){

    3717. 

  3717. 			echo @$agentIds[0]['ws_agentid'];

    3718. 

  3718. 		

    3719. 

  3719. 		} else {

    3720. 

  3720. 			echo "";

    3721. 

  3721. 		}

    3722. 

  3722. 		

    3723. 

  3723. 		//echo explode(',',$agentId);

    3724. 

  3724. 	}	

    3725. 

  3725. 

    3726. 

  3726. 

    3727. 

  3727. }
    3728.