PageRenderTime 176ms CodeModel.GetById 15ms RepoModel.GetById 1ms app.codeStats 1ms

/app/controllers/creativezones_controller_bakup.php

https://bitbucket.org/fxrialab/spsp_editor
PHP | 3851 lines | 2536 code | 783 blank | 532 comment | 396 complexity | 4a890db0242573c7d2df323b93eae2e4 MD5 | raw file
Possible License(s): LGPL-2.1, AGPL-1.0 
    

  1. <?

    2. 

  2. class CreativezonesController extends AppController {

    3. 

  3.     var $name='Creativezones';

    4. 

  4.     var $helpers = array('Html','javascript','error','Ajax','Friendsurl','Common');

    5. 

  5.     var $uses=array('Creativezone','User','Creative_favorites','Creative_favorite_tags','Creative_tickets','Transaction_creatives');

    6. 

  6.     var $components = array('Newdir','Thumbnail','Thumbnailc','Zipfile','Download','Cartmail','Creative','Sendmail');

    7. 

  7. 

    8. 

  8. 

    9. 

  9. //ok

    10. 

  10.     function index() {

    11. 

  11.         //$this->checkSession();

    12. 

  12.         $this->pageTitle = 'ScrapFOTO&trade; Home';

    13. 

  13.         //$this->layout = 'creativehome';

    14. 

  14.         $this->layout = 'creativedetail';

    15. 

  15.         $this->homepageslideInfo('ScrapFOTO');

    16. 

  16. 

    17. 

  17.         //Initializing all the bradcamp back again so that it all starts all over again

    18. 

  18.         unset($_SESSION['bradcamp_creative']);

    19. 

  19.         $this->set("filename","index");	//filename should contain the name of the file that should be selected

    20. 

  20. 

    21. 

  21.         //_________________________________________________________________________________________________

    22. 

  22. 

    23. 

  23.         unset($_SESSION['buyTemplate']);

    24. 

  24.         //check  creative_carts

    25. 

  25.         if(isset($_SESSION['UserId'])) {

    26. 

  26.             $sql = "SELECT Cart.id FROM creative_carts as Cart

    27. 

  27.                     LEFT JOIN creative_cart_details CartDetail ON Cart.id = CartDetail.creative_cart_id

    28. 

  28.                     LEFT JOIN creative_favorites Favorite ON Favorite.id = CartDetail.creative_favorite_id

    29. 

  29.                     WHERE Cart.user_id ='".$_SESSION['UserId']."' AND  Cart.pay_status='0' AND Favorite.is_republished ='0' AND Favorite.is_temp='1'   ";

    30. 

  30. 

    31. 

  31.             $result = mysql_query($sql) or die(mysql_error());

    32. 

  32.             if(mysql_num_rows($result)>0) {

    33. 

  33.                 //delete cart

    34. 

  34.                 while($row=mysql_fetch_array($result)) {

    35. 

  35.                     mysql_query("DELETE FROM creative_carts WHERE id='".$row['id']."' ") or die(mysql_error());

    36. 

  36.                 }

    37. 

  37.             }

    38. 

  38. 

    39. 

  39.             //check delete favorite

    40. 

  40.             //mysql_query("DELETE FROM creative_favorites WHERE user_id='".$_SESSION['UserId']."' AND is_republished ='0' AND is_temp='1' ") or die(mysql_error());

    41. 

  41.         }

    42. 

  42. 

    43. 

  43.         $this->creativeType();

    44. 

  44.         $this->countFavCart();

    45. 

  45.         $this->getRankScrap();

    46. 

  46.         $this->getFeaturedScrap();

    47. 

  47.         $this->getPublicScrap();

    48. 

  48. 

    49. 

  49.         $this->render('index');

    50. 

  50.     }

    51. 

  51. 

    52. 

  52.     //ok ajax call get scrap in tab "Featured","Hight Rated","Recent"

    53. 

  53.     function featuredscrap($catlisttype=null) {

    54. 

  54.         $this->layout = 'profile_blank';

    55. 

  55.         ///////////////////////////////////////////////////// SQL FOR FEATURED SCRAP

    56. 

  56.         /* Pagination and PHOTO listing */

    57. 

  57.         $select = " Select  X.is_featured,X.fileThumb2 as template_img,X.price,X.viewed,X.ssn_id,X.price,X.width,X.height,X.id,X.creation,X.user_id,X.title,XCreativetype.creative_name ,XCreativetype.id as creativetypeid,  X.description,Xuser.username ,COUNT(Xcomment.id) as photoreview ,  Xuserdetail.user_profile_img , IFNULL(ROUND(AVG(Xrating.vote),0),0) as photorat";

    58. 

  58. 

    59. 

  59.         $from=" FROM creative_favorites X

    60. 

  60. 

    61. 

  61. 				LEFT JOIN creative_favorites_details XCreativetypeDetail ON X.id = XCreativetypeDetail.creative_favorite_id				

    62. 

  62. 				LEFT JOIN creative_type XCreativetype ON X.creative_type_id = XCreativetype.id

    63. 

  63. 

    64. 

  64. 				LEFT JOIN creative_favorite_comments Xcomment ON X.id = Xcomment.creative_favorite_id

    65. 

  65. 				LEFT JOIN users Xuser ON  X.user_id = Xuser.id

    66. 

  66. 				LEFT JOIN user_details Xuserdetail ON X.user_id = Xuserdetail.user_id

    67. 

  67. 				LEFT JOIN creative_favorite_voting Xrating ON X.id = Xrating.creative_favorite_id";

    68. 

  68. 

    69. 

  69.         $where=" WHERE  X.is_blocked='0' AND X.is_temp='0' AND X.type='0' AND X.is_approved='1'  AND X.is_stop_sell='0' ";

    70. 

  70. 

    71. 

  71. 

    72. 

  72.         if($catlisttype=='featured') {

    73. 

  73.             $where.=" AND X.is_featured='1' ";

    74. 

  74.             $morelink=$this->webroot.'creativezones/scrapxonglisting?listtype=featured';

    75. 

  75.         }

    76. 

  76. 

    77. 

  77.         $others=" group by X.id ";

    78. 

  78. 

    79. 

  79.         if($catlisttype=='mostvoted') {

    80. 

  80.             $others .=" order by photorat desc ";

    81. 

  81.             $morelink=$this->webroot.'creativezones/scrapxonglisting?listtype=mostvoted';

    82. 

  82. 

    83. 

  83.         }

    84. 

  84. 

    85. 

  85.         if(!$catlisttype) {

    86. 

  86.             $others.=" order by X.id desc";

    87. 

  87.             $morelink=$this->webroot.'creativezones/scrapxonglisting?listtype=recent';

    88. 

  88. 

    89. 

  89.         }

    90. 

  90. 

    91. 

  91.         $tabsql = $select.$from.$where. $others . ' LIMIT 12';

    92. 

  92.         $tabsql_res = mysql_query($tabsql);

    93. 

  93.         $this->set('query',$tabsql_res) ;

    94. 

  94.         $this->set('tabsql',$tabsql) ;

    95. 

  95.         $this->set('morelink',$morelink);

    96. 

  96. /////////////////////////////////////////////////////////////////

    97. 

  97.     }

    98. 

  98. 

    99. 

  99.     //ok scrap listing

    100. 

  100.     function scrapxonglisting() {

    101. 

  101.         $this->layout = 'creativeinner';

    102. 

  102. 

    103. 

  103.         $catlisttype = '';

    104. 

  104.         if(isset($_REQUEST['listtype']) && $_REQUEST['listtype']!='')

    105. 

  105.             $catlisttype = $_REQUEST['listtype'];

    106. 

  106. 

    107. 

  107.         //this section is used to check whether to show the list based on the category given in the header section

    108. 

  108.         $scrapType=0;

    109. 

  109.         if(isset($this->params['url']['cat'])) {

    110. 

  110.             $scrapType=base64_decode($this->params['url']['cat']);

    111. 

  111.             $this->set("selTab",$scrapType);

    112. 

  112.         }

    113. 

  113. 

    114. 

  114.         ############################### Page Title  & Head ############################

    115. 

  115. 

    116. 

  116.         $pageheadArr = array();

    117. 

  117.         $pageheadArr['featured'] = 'Featured';

    118. 

  118.         $pageheadArr['recent'] = 'Recent';

    119. 

  119.         $pageheadArr['mostvoted'] = 'Most Voted';

    120. 

  120.         $pageheadArr['mostcomment'] = 'Most Discussed';

    121. 

  121.         $pageheadArr['random'] = 'Random';

    122. 

  122.         $pageheadArr['favorite'] = 'Most Favorited ';

    123. 

  123.         $pageheadArr['tag'] = 'Tagged ';

    124. 

  124.         $pageheadArr['search'] = 'Search Result';

    125. 

  125.         $pageheadArr['mostviewed'] = 'Most Viewed';

    126. 

  126.         $pageheadArr['albumview'] = 'Album';

    127. 

  127.         $pageheadArr['seller'] = 'Seller';

    128. 

  128.         $pageheadArr['popular'] = 'Popular';

    129. 

  129.         if (array_key_exists($catlisttype, $pageheadArr)) {

    130. 

  130.             if($catlisttype=='albumview') {

    131. 

  131.                 /* Album Name*/

    132. 

  132.                 $albumNameSql = "Select IFNULL(creative_name,'') as albumName from creative_type where id='".base64_decode($_REQUEST['albumid'])."'";

    133. 

  133.                 $albumNameSql_res = mysql_fetch_array(mysql_query($albumNameSql));

    134. 

  134.                 $albumName = stripslashes($albumNameSql_res['albumName']) ;

    135. 

  135.                 /**/

    136. 

  136.                 $this->pageTitle = $pageheadArr[$catlisttype]. $albumName.' ScrapFOTO&trade;';

    137. 

  137.                 $this->set('pagehead',$pageheadArr[$catlisttype].' : '. $albumName. ' ScrapFOTO&trade;');

    138. 

  138. 

    139. 

  139.             }

    140. 

  140.             else {

    141. 

  141.                 if($catlisttype=='tag') {

    142. 

  142.                     $this->pageTitle = $pageheadArr[$catlisttype].' ScrapFOTO&trade; : '. $_REQUEST['sortby'];

    143. 

  143.                     $this->set('pagehead',$pageheadArr[$catlisttype].' ScrapFOTO&trade; : '.$_REQUEST['sortby']);

    144. 

  144.                 }

    145. 

  145.                 else {

    146. 

  146.                     if($catlisttype=='seller') {

    147. 

  147.                         /* SELLER INFO */

    148. 

  148.                         $sellinfo  = " SELECT username from users where id='".base64_decode($_REQUEST['resaleby'])."'";

    149. 

  149.                         $sellinfo_res = mysql_query($sellinfo);

    150. 

  150.                         $sellinfo_arr = mysql_fetch_array($sellinfo_res);

    151. 

  151. 

    152. 

  152.                         $this->pageTitle = 'ScrapFOTO&trade; '.$pageheadArr[$catlisttype] .' : '.$sellinfo_arr['username'];

    153. 

  153.                         $this->set('pagehead','ScrapFOTO&trade; '.$pageheadArr[$catlisttype].' : '.$sellinfo_arr['username']);

    154. 

  154. 

    155. 

  155.                     }

    156. 

  156.                     else {

    157. 

  157.                         $this->pageTitle = $pageheadArr[$catlisttype].' ScrapFOTO&trade;';

    158. 

  158.                         $this->set('pagehead',$pageheadArr[$catlisttype].' ScrapFOTO&trade;');

    159. 

  159.                     }

    160. 

  160.                 }

    161. 

  161.             }

    162. 

  162.         }

    163. 

  163.         else {

    164. 

  164.             if($catlisttype=='category') {

    165. 

  165.                 $scrapDetail=$this->getCreativeType($scrapType);

    166. 

  166.                 $this->pageTitle = $scrapDetail['creative_name'];

    167. 

  167.                 $this->set('pagehead',$scrapDetail['creative_name']);

    168. 

  168.             }

    169. 

  169.             else {

    170. 

  170.                 $this->pageTitle = 'ScrapFOTO&trade;';

    171. 

  171.                 $this->set('pagehead','ScrapFOTO&trade;');

    172. 

  172.             }

    173. 

  173.         }

    174. 

  174. ############################### Page Title  & Head ############################

    175. 

  175.         /* Pagination and PHOTO listing */

    176. 

  176.         $select = " Select X.is_featured,X.fileThumb2 as template_img,X.price,X.viewed,X.ssn_id,X.width,X.height,X.id,X.creation,X.user_id,X.title,XCreativetype.creative_name ,XCreativetype.id as creativetypeid,  X.description,Xuser.username ,COUNT(Xcomment.id) as photoreview ,  Xuserdetail.user_profile_img , IFNULL(ROUND(AVG(Xrating.vote),0),0) as photorat";

    177. 

  177. 

    178. 

  178.         $from=" FROM creative_favorites X

    179. 

  179. 				LEFT JOIN creative_type XCreativetype ON X.creative_type_id = XCreativetype.id

    180. 

  180. 

    181. 

  181. 				LEFT JOIN creative_favorite_comments Xcomment ON X.id = Xcomment.creative_favorite_id

    182. 

  182. 				LEFT JOIN users Xuser ON  X.user_id = Xuser.id

    183. 

  183. 				LEFT JOIN user_details Xuserdetail ON X.user_id = Xuserdetail.user_id

    184. 

  184. 				LEFT JOIN creative_favorite_voting Xrating ON X.id = Xrating.creative_favorite_id";

    185. 

  185. 

    186. 

  186.         $where=" WHERE  X.is_blocked='0' AND X.is_temp='0' AND X.type='0' AND X.is_approved='1'  AND X.is_stop_sell='0'";

    187. 

  187. 

    188. 

  188. 

    189. 

  189.         if($catlisttype=='featured')

    190. 

  190.             $where.=" AND X.is_featured='1' ";

    191. 

  191.         if( $catlisttype=='albumview' && isset($_REQUEST['albumid']) && base64_decode($_REQUEST['albumid'])>0)

    192. 

  192.             $where.=" AND XCreativetype.id='".base64_decode($_REQUEST['albumid'])."' ";

    193. 

  193.         if($catlisttype=='tag')

    194. 

  194.             $where.=" AND X.id IN (Select creative_favorite_id from creative_favorite_tags where tagname Like '%".$_REQUEST['sortby']."%')";

    195. 

  195.         if($catlisttype=='search')

    196. 

  196.             $where.=" AND X.title LIKE '%".$_REQUEST['srchtxt']."%' OR X.id IN (Select creative_favorite_id from creative_favorite_tags where tagname Like '%".$_REQUEST['srchtxt']."%') ";

    197. 

  197.         if($catlisttype=='seller')

    198. 

  198.             $where.=" AND X.user_id='".base64_decode($_REQUEST['resaleby'])."' ";

    199. 

  199. 

    200. 

  200.         if($catlisttype=='category')

    201. 

  201.             $where.=" AND XCreativetype.id='".$scrapType."' ";

    202. 

  202. 

    203. 

  203. 

    204. 

  204.         $others=" group by X.id ";

    205. 

  205. 

    206. 

  206.         if($catlisttype=='mostvoted')

    207. 

  207.             $others .=" order by photorat desc ";

    208. 

  208. 

    209. 

  209.         if($catlisttype=='mostcomment')

    210. 

  210.             $others .=" order by photoreview desc ";

    211. 

  211. 

    212. 

  212.         if($catlisttype=='mostviewed')

    213. 

  213.             $others .=" order by X.viewed desc ";

    214. 

  214.         if($catlisttype=='random')

    215. 

  215.             $others .=" order by X.id desc , rand()";

    216. 

  216. 

    217. 

  217.         if($catlisttype=='favorite')

    218. 

  218.             $others .=" order by photofavored desc ";

    219. 

  219. 

    220. 

  220.         if($catlisttype=='')

    221. 

  221.             $others.=" order by X.id desc";

    222. 

  222. 

    223. 

  223. 

    224. 

  224.         if(isset($_REQUEST['sortby']) && $_REQUEST['sortby']!='')

    225. 

  225.             $PassParameter="listtype=".$catlisttype."&sortby=".$_REQUEST['sortby'];

    226. 

  226.         else {

    227. 

  227.             if(isset($catlisttype) && $catlisttype=='albumview')

    228. 

  228.                 $PassParameter="listtype=".$catlisttype."&albumid=".$_REQUEST['albumid'];

    229. 

  229.             else {

    230. 

  230.                 if(isset($_REQUEST['srchtxt']) && $_REQUEST['srchtxt']!='')

    231. 

  231.                     $PassParameter="listtype=".$catlisttype."&srchtxt=".$_REQUEST['srchtxt'];

    232. 

  232.                 else {

    233. 

  233.                     if(isset($_REQUEST['resaleby']) && base64_decode($_REQUEST['resaleby'])>0)

    234. 

  234.                         $PassParameter="listtype=".$catlisttype."&resaleby=".$_REQUEST['resaleby'];

    235. 

  235.                     else {

    236. 

  236.                         if($catlisttype=='category')

    237. 

  237.                             $PassParameter="listtype=".$catlisttype.'&cat='.base64_encode($scrapType) ;

    238. 

  238.                         else

    239. 

  239.                             $PassParameter="listtype=".$catlisttype;

    240. 

  240.                     }

    241. 

  241.                 }

    242. 

  242.             }

    243. 

  243.         }

    244. 

  244. 

    245. 

  245. 

    246. 

  246. 

    247. 

  247.         $fltr='';

    248. 

  248.         $CountField="X.id";

    249. 

  249.         $this->set("controller","creativezones");

    250. 

  250.         $this->set("action","scrapxonglisting");

    251. 

  251.         $this->set("parameter",$PassParameter);

    252. 

  252.         $this->set("fltr",$fltr);

    253. 

  253. 

    254. 

  254.         $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);

    255. 

  255.         if(isset($this->params['url']['Page']) || (isset($fltr) && $fltr!="") ) {

    256. 

  256.             $this->set('pagehead','Most Recent');

    257. 

  257.             $this->render("scrapxonglisting2","ajax");

    258. 

  258.         }

    259. 

  259. 

    260. 

  260.         /**/

    261. 

  261.         $this->creativeType();

    262. 

  262.         $this->countFavCart();

    263. 

  263.         $this->getPublicScrap();

    264. 

  264.     }

    265. 

  265. 

    266. 

  266. //ok scrap detail

    267. 

  267.     function scrapxong() {

    268. 

  268.         //$this->verifyserverUrl($_SERVER['REQUEST_URI']);

    269. 

  269.         $this->pageTitle = 'ScrapFOTO&trade;';

    270. 

  270.         $this->layout = 'creativedetail';

    271. 

  271. 

    272. 

  272. ############################################ SCRAP XONG DETAILS

    273. 

  273.         $this->creativeType();

    274. 

  274.         $this->countFavCart();

    275. 

  275.         $this->getPublicScrap();

    276. 

  276. 

    277. 

  277.         $this->set('photoid',$_REQUEST['sxid']);

    278. 

  278. 

    279. 

  279. //update viewed

    280. 

  280.         $select = "UPDATE creative_favorites SET viewed=viewed+1 WHERE id='".base64_decode($_REQUEST['sxid'])."' ";

    281. 

  281.         mysql_query($select);

    282. 

  282. 

    283. 

  283.         $select = " Select X.fileThumb2 as template_img,X.price,X.viewed,X.ssn_id,X.width,X.height,X.id,X.user_id,X.title,X.description,Xuser.username ,COUNT(Xcomment.id) as photoreview ,  Xuserdetail.user_profile_img , IFNULL(ROUND(AVG(Xrating.vote),0),0) as photorat";

    284. 

  284. 

    285. 

  285.         $from=" FROM creative_favorites X

    286. 

  286. 					LEFT JOIN creative_type XCreativetype ON X.creative_type_id = XCreativetype.id

    287. 

  287. 

    288. 

  288. 					LEFT JOIN creative_favorite_comments Xcomment ON X.id = Xcomment.creative_favorite_id

    289. 

  289. 					LEFT JOIN users Xuser ON  X.user_id = Xuser.id

    290. 

  290. 					LEFT JOIN user_details Xuserdetail ON X.user_id = Xuserdetail.user_id

    291. 

  291. 					LEFT JOIN creative_favorite_voting Xrating ON X.id = Xrating.creative_favorite_id";

    292. 

  292. 

    293. 

  293.         $where=" WHERE  X.is_blocked='0' AND X.is_temp='0' AND X.id='".base64_decode($_REQUEST['sxid'])."' AND X.type='0'  AND X.is_stop_sell='0' group by X.id";

    294. 

  294. 

    295. 

  295.         $photo_sql = $select . $from .$where;

    296. 

  296.         $photo_res = mysql_query($photo_sql);

    297. 

  297.         $photores_arr = mysql_fetch_array($photo_res);

    298. 

  298.         $photoUrl = FULL_BASE_URL.$this->webroot."creativezones/scrapxong?sxid=".$_REQUEST['sxid'];//DOMAIN

    299. 

  299.         $this->set('photoUrl',$photoUrl);

    300. 

  300. 

    301. 

  301.         $this->set('photoArr', $photores_arr);

    302. 

  302.         $this->set('photoTitle', $photores_arr['title']);

    303. 

  303.         $this->set('photoDesc', $photores_arr['description']);

    304. 

  304.         $this->set('photoImage', $photores_arr['template_img']);

    305. 

  305.         $this->set('photoImageId', $photores_arr['id']);

    306. 

  306.         $this->set('photoUsername', $photores_arr['username']);

    307. 

  307.         $this->set('photototalRating', $photores_arr['photorat']);

    308. 

  308.         $this->set('photototalReview', $photores_arr['photoreview']);

    309. 

  309.         $this->set('photoPrice', number_format($photores_arr['price'],2,'.',','));

    310. 

  310. 

    311. 

  311.         $checklover = "Select * from creative_favorite_lovers where creative_favorite_id='".base64_decode($_REQUEST['sxid'])."'" ;

    312. 

  312.         $checklover_res = mysql_query($checklover);

    313. 

  313.         $checklover_res_num = mysql_num_rows($checklover_res);

    314. 

  314.         $this->set('nooflover', $checklover_res_num);

    315. 

  315. 

    316. 

  316. ##### Check for the review already posted or not

    317. 

  317.         $numberpreview=0;

    318. 

  318.         if(isset($_SESSION['UserId'])) {

    319. 

  319.             $checkbackdropreview = "SELECT * FROM creative_favorite_comments where creative_favorite_id='".base64_decode($_REQUEST['sxid'])."' and user_id='".$_SESSION['UserId']."'";

    320. 

  320.             $checkbackdropreview_res = mysql_query($checkbackdropreview);

    321. 

  321.             $numberpreview = mysql_num_rows($checkbackdropreview_res);

    322. 

  322.         }

    323. 

  323.         $this->set('reviewposted', $numberpreview);

    324. 

  324. #####

    325. 

  325. 

    326. 

  326. ################################################### FOR NEXT AND PREVIOUS #######################

    327. 

  327. 

    328. 

  328.         $Imgselect="

    329. 

  329. 				SELECT CF.id,title,template_img

    330. 

  330. 				FROM creative_favorites CF,creative_favorites_details CFDTL

    331. 

  331. 				WHERE CF.id=CFDTL.creative_favorite_id AND CF.type='0'

    332. 

  332. 				GROUP BY CF.id ORDER BY CF.id DESC

    333. 

  333. 				" ;

    334. 

  334. 

    335. 

  335. 

    336. 

  336.         $Imgselect_res = mysql_query($Imgselect);

    337. 

  337.         $Imgarray = array();

    338. 

  338. 

    339. 

  339.         while($Imgselect_arr = mysql_fetch_array($Imgselect_res)) {

    340. 

  340. //$Imgarray['image'.$Imgselect_arr['id']] = $Imgselect_arr['id'] ;

    341. 

  341.             $Imgarray[] = $Imgselect_arr['id'] ;

    342. 

  342.         }

    343. 

  343. //pr($Imgarray);

    344. 

  344. //echo base64_decode($_REQUEST['pid']) ;

    345. 

  345.         $searchKey = array_search(base64_decode($_REQUEST['sxid']),$Imgarray) ;

    346. 

  346. // Next

    347. 

  347.         $searchKeyNext = ($searchKey + 1);

    348. 

  348.         $searchKeyPrev = ($searchKey - 1);

    349. 

  349. 

    350. 

  350.         if (array_key_exists($searchKeyNext, $Imgarray)) {

    351. 

  351.             $this->set('nxtImage',$Imgarray[$searchKeyNext]);

    352. 

  352.         }

    353. 

  353. // Prev

    354. 

  354.         if (array_key_exists($searchKeyPrev, $Imgarray)) {

    355. 

  355.             $this->set('prevImage',$Imgarray[$searchKeyPrev]);

    356. 

  356.         }

    357. 

  357. 

    358. 

  358. ################################################### FOR NEXT AND PREVIOUS #######################

    359. 

  359. 

    360. 

  360. ########

    361. 

  361.     }

    362. 

  362. 

    363. 

  363.     //checking

    364. 

  364.     function creativetemplate() {

    365. 

  365. 

    366. 

  366.         //$this->checkSession();

    367. 

  367.         $this->pageTitle = 'ScrapFOTO&trade; - Create Template';

    368. 

  368.         $this->layout = 'creativehome';

    369. 

  369.         $this->creativeType();

    370. 

  370. 

    371. 

  371. //This ct variable comes from INDEX page and CREATIVETEMPLATE page

    372. 

  372. //This variable contains the category Id

    373. 

  373.         if(isset($this->params['url']['ct']))

    374. 

  374.             $id=base64_decode($this->params['url']['ct']);

    375. 

  375. 

    376. 

  376. //This ct variable comes from CREATIVETEMPLATE page

    377. 

  377.         $tmpImg=0;

    378. 

  378.         if(isset($this->params['url']['pg']))

    379. 

  379.             $tmpImg=base64_decode($this->params['url']['pg']);

    380. 

  380. 

    381. 

  381.         $themeId=0;

    382. 

  382.         if(isset($this->params['url']['tmplate']))

    383. 

  383.             $themeId=base64_decode($this->params['url']['tmplate']);

    384. 

  384. 

    385. 

  385. //this variable is used to show the selected section in the accordian tag

    386. 

  386. 

    387. 

  387.         $this->set("cType",$id);

    388. 

  388.         $this->set("cTemplate",$tmpImg);

    389. 

  389.         $this->set("themeId",$themeId);

    390. 

  390. 

    391. 

  391. //Initializing all the bradcamp back again so that it all starts all over again

    392. 

  392.         $this->set("filename","creativetemplate");          //filename should contain the name of the file that should be selected

    393. 

  393.         $_SESSION['bradcamp_creative'][20]=$this->params['action']; //we are passing the name of the file to keep track which step is visited

    394. 

  394.         $this->set("nextpage","creativezone");

    395. 

  395. 

    396. 

  396. //_________________________________________________________________________________________________

    397. 

  397. 

    398. 

  398.         $this->countFavCart();

    399. 

  399.         /*

    400. 

  400.         // getting out the template name under the type

    401. 

  401.         if(isset($id)) {

    402. 

  402. 

    403. 

  403.             $templateName =  array();

    404. 

  404.             $tempname="

    405. 

  405. 						SELECT CP.*

    406. 

  406. 						FROM creative_type CT,creative_template_pages CP

    407. 

  407. 						WHERE CT.id=CP.creative_type_id AND CT.id='".$id."' AND block='0'

    408. 

  408. 						ORDER BY CP.template_type ASC,CP.title ASC

    409. 

  409. 						";

    410. 

  410.             $tempname_res = mysql_query($tempname) or die('Line number '.__LINE__. mysql_error());

    411. 

  411.             $tempNum =  mysql_num_rows($tempname_res);

    412. 

  412.             if($tempNum > 0) {

    413. 

  413.                 $i=0;

    414. 

  414.                 while($rwTmp = mysql_fetch_assoc($tempname_res)) {

    415. 

  415.                     if($i==0) {

    416. 

  416.                         $defaultTmpId=$rwTmp['id'];

    417. 

  417.                         $this->set("defaultTemplateId",$defaultTmpId);

    418. 

  418.                     }

    419. 

  419. 

    420. 

  420.                     $i++;

    421. 

  421.                     $templateName[$rwTmp['id']]=array($rwTmp['title'],$rwTmp['template_img'],$rwTmp['price'],$rwTmp['template_type']);

    422. 

  422.                 }

    423. 

  423. 

    424. 

  424.             }

    425. 

  425. 

    426. 

  426.         }

    427. 

  427. 

    428. 

  428.         $this->set('templateImg',$templateName);

    429. 

  429. 

    430. 

  430.         //Getting the large thimbnail image

    431. 

  431.         if(isset($tmpImg) && $tmpImg!=0) {

    432. 

  432.             $this->templateDetail($tmpImg);

    433. 

  433.             $this->render("template","ajax");

    434. 

  434.         }

    435. 

  435. 

    436. 

  436. 

    437. 

  437.         if(isset($this->params['url']['tpage'])) {

    438. 

  438.             //print "test";

    439. 

  439.             $tPage=base64_decode($this->params['url']['tpage']);

    440. 

  440.             $this->templateDetail($tPage);

    441. 

  441.             //exit;

    442. 

  442.             $this->render("template","ajax");

    443. 

  443.         }         

    444. 

  444.         */

    445. 

  445.     }

    446. 

  446.     //checking

    447. 

  447.     function creativetemplatezone() {

    448. 

  448.         $this->checkSession();

    449. 

  449.         $this->pageTitle = 'ScrapFOTO&trade; - Creative Zone';

    450. 

  450.         $this->layout = 'creativehome';

    451. 

  451.         $this->creativeType();

    452. 

  452. 

    453. 

  453.         //Initializing all the bradcamp back again so that it all starts all over again

    454. 

  454.         $this->set("filename","creativetemplatezone");	//filename should contain the name of the file that should be selected

    455. 

  455.         $this->set("nextpage","creative_favorite");

    456. 

  456. 

    457. 

  457.         //_________________________________________________________________________________________________

    458. 

  458. 

    459. 

  459. 

    460. 

  460. 

    461. 

  461.         if(isset($this->params['url']['tmp'])) {

    462. 

  462.             $tmpImg=base64_decode($this->params['url']['tmp']);

    463. 

  463.             $tmpImg = $this->templateDetail($tmpImg);

    464. 

  464. 

    465. 

  465.             if($tmpImg==0) {

    466. 

  466.                 $this->redirect('/creativezones/index');

    467. 

  467.             }else {

    468. 

  468.                 //emty cart current

    469. 

  469.                 $sql ="SELECT id FROM creative_carts WHERE pay_status='0' ";

    470. 

  470.                 $result = mysql_query($sql) or die(mysql_error());

    471. 

  471.                 if(mysql_num_rows($result)>0) {

    472. 

  472.                     while($row=mysql_fetch_array($result)) {

    473. 

  473.                         $sql ="DELETE FROM creative_cart_details WHERE creative_cart_id='".$row['id']."' ";

    474. 

  474.                         mysql_query($sql) or die(mysql_error());

    475. 

  475.                     }

    476. 

  476.                 }

    477. 

  477.                 //add favorite

    478. 

  478.                 if(!isset($_SESSION['buyTemplate']['tmpId'])) {

    479. 

  479.                     $_SESSION['buyTemplate']['tmpId'] = $tmpImg;

    480. 

  480.                     //add to favorite

    481. 

  481.                     $fav = $this->Creative_favorites->findById($tmpImg);

    482. 

  482. 

    483. 

  483.                     $fav['Creative_favorites']['id'] = null;

    484. 

  484.                     $fav['Creative_favorites']['user_id'] = $_SESSION['UserId'];

    485. 

  485.                     $fav['Creative_favorites']['is_temp'] = 1;

    486. 

  486.                     $fav['Creative_favorites']['type'] = 1;

    487. 

  487.                     $fav['Creative_favorites']['is_featured'] = 0;

    488. 

  488.                     $fav['Creative_favorites']['is_republished'] = 0;

    489. 

  489. 

    490. 

  490.                     $this->Creative_favorites->create();

    491. 

  491.                     $this->Creative_favorites->save($fav);

    492. 

  492. 

    493. 

  493.                     $idNew = $this->Creative_favorites->id;

    494. 

  494.                     $_SESSION['buyTemplate']['idNew'] = $idNew;

    495. 

  495.                 }

    496. 

  496.             }

    497. 

  497.         }

    498. 

  498. 

    499. 

  499.         $this->countFavCart();

    500. 

  500. 

    501. 

  501.         //case create form header

    502. 

  502.         if(isset($_POST['widthScrap'])) {

    503. 

  503.             $this->set('widthScrap',$_POST['widthScrap']);

    504. 

  504.             $this->set('heightScrap',$_POST['heightScrap']);

    505. 

  505.             $this->set('titleScrap',$_POST['titleScrap']);

    506. 

  506.         }

    507. 

  507. 

    508. 

  508.     }

    509. 

  509.     //checking

    510. 

  510.     function creative_favorite() {

    511. 

  511.         $this->checkSession();

    512. 

  512.         $this->pageTitle = 'ScrapFOTO&trade; - My Favorite';

    513. 

  513.         $this->layout = 'creativehome';

    514. 

  514.         $this->creativeType();

    515. 

  515. 

    516. 

  516.         //This ct variable comes from INDEX page and CREATIVETEMPLATE page

    517. 

  517. 

    518. 

  518.         $tmpImg=0;

    519. 

  519.         if(isset($this->params['url']['tmp'])) {

    520. 

  520.             $tmpImg=base64_decode($this->params['url']['tmp']);

    521. 

  521.             $tmpImg = $this->templateDetail($tmpImg);

    522. 

  522.         }else if(isset($_SESSION['buyTemplate']['tmpId'])) {

    523. 

  523.             $tmpImg = $_SESSION['buyTemplate']['tmpId'];

    524. 

  524.             $tmpImg = $this->templateDetail($tmpImg);

    525. 

  525.         }

    526. 

  526. 

    527. 

  527. 

    528. 

  528.         if(isset($_POST['ssn_id'])) {

    529. 

  529.             $ssn_id = $_POST['ssn_id'];

    530. 

  530.             $fav = $this->Creative_favorites->findBySsn_id(base64_decode($_POST['ssn_id']));

    531. 

  531. 

    532. 

  532.             if(!$fav) {//create

    533. 

  533.                 $this->Creative_favorites->create();

    534. 

  534.             }

    535. 

  535.             else {//update

    536. 

  536.                 $this->Creative_favorites->id = $fav['Creative_favorites']['id'];

    537. 

  537.             }

    538. 

  538.             $fav['Creative_favorites']['ssn_id'] = base64_decode($_POST['ssn_id']);

    539. 

  539.             $fav['Creative_favorites']['user_id'] = $_SESSION['UserId'];

    540. 

  540.             $fav['Creative_favorites']['title'] = base64_decode($_POST['title']);

    541. 

  541.             $fav['Creative_favorites']['description'] = $_POST['description'];

    542. 

  542.             $fav['Creative_favorites']['price'] = $_POST['price'];

    543. 

  543.             $fav['Creative_favorites']['width'] = $_POST['width'];

    544. 

  544.             $fav['Creative_favorites']['height'] = $_POST['height'];

    545. 

  545.             $fav['Creative_favorites']['fileThumb'] = base64_decode($_POST['fileThumb']);

    546. 

  546.             $fav['Creative_favorites']['fileThumb2'] = base64_decode($_POST['fileThumb2']);

    547. 

  547.             $fav['Creative_favorites']['fileThumb3'] = base64_decode($_POST['fileThumb3']);

    548. 

  548.             $fav['Creative_favorites']['fileData'] = base64_decode($_POST['fileData']);

    549. 

  549.             $fav['Creative_favorites']['fileZip'] = base64_decode($_POST['fileZip']);

    550. 

  550.             $fav['Creative_favorites']['is_temp'] = 0;

    551. 

  551. 

    552. 

  552.             $fav['Creative_favorites']['creative_type_id'] = $_POST['creative_type_id'];

    553. 

  553.             $fav['Creative_favorites']['type'] = $_POST['type'];

    554. 

  554.             $fav['Creative_favorites']['is_featured'] = $_POST['is_featured'];

    555. 

  555. 

    556. 

  556.             $fav['Creative_favorites']['is_temp'] = $fav['Creative_favorites']['is_featured'];

    557. 

  557. 

    558. 

  558.             if($fav['Creative_favorites']['type']==0) {//public

    559. 

  559.                 $featuredAmount=$this->getConfigAmount('creative artist price');

    560. 

  560.                 $fav['Creative_favorites']['price'] = $featuredAmount['config_value'];

    561. 

  561.             }

    562. 

  562. 

    563. 

  563.             $resultSave = $this->Creative_favorites->save($fav);//return 1/null

    564. 

  564. 

    565. 

  565. 

    566. 

  566.             //insert tag

    567. 

  567.             if($resultSave && $_POST['tag']!='') {

    568. 

  568.                 $tag['Creative_favorite_tags']['creative_favorite_id'] = $this->Creative_favorites->id;

    569. 

  569.                 $tag['Creative_favorite_tags']['user_id'] = $_SESSION['UserId'];

    570. 

  570.                 $tag['Creative_favorite_tags']['tagname'] = $_POST['tag'];

    571. 

  571.                 $this->Creative_favorite_tags->create();

    572. 

  572.                 $this->Creative_favorite_tags->save($tag);

    573. 

  573.             }

    574. 

  574. 

    575. 

  575.             if($fav['Creative_favorites']['type']==0) {

    576. 

  576.                 if($resultSave && $fav['Creative_favorites']['is_featured']==1) {

    577. 

  577.                     $this->redirect("creativezones/creative_featured?lid=".base64_encode($this->Creative_favorites->id));

    578. 

  578.                     exit();

    579. 

  579.                 }else {

    580. 

  580.                     $this->redirect("creativezones/featuredsuccess?lid=".base64_encode($this->Creative_favorites->id));

    581. 

  581.                 }

    582. 

  582.             }

    583. 

  583. 

    584. 

  584.         }

    585. 

  585. 

    586. 

  586.         if(isset($_POST['actionCall']) && $_POST['actionCall']=='exit') {

    587. 

  587.             $this->redirect('/creativezones/index');

    588. 

  588.         }

    589. 

  589. 

    590. 

  590.         if($tmpImg==0) {

    591. 

  591.             unset($_SESSION['buyTemplate']);

    592. 

  592.             $favs = null;

    593. 

  593.             $result = mysql_query("SELECT * FROM creative_favorites WHERE user_id='".$_SESSION['UserId']."' AND is_temp='0' AND is_republished='1' ") or die("Error on line :".__LINE__.mysql_error());

    594. 

  594.             if(mysql_num_rows($result)>0) {

    595. 

  595.                 $favs = $result;

    596. 

  596.             }

    597. 

  597.             $this->set("favs",$favs);

    598. 

  598.         }else if(isset($_SESSION['buyTemplate']['idNew'])) {

    599. 

  599.             $favs = null;

    600. 

  600.             $result = mysql_query("SELECT * FROM creative_favorites WHERE user_id='".$_SESSION['UserId']."' AND id='".$_SESSION['buyTemplate']['idNew']."' ") or die("Error on line :".__LINE__.mysql_error());

    601. 

  601.             if(mysql_num_rows($result)>0) {

    602. 

  602.                 $favs = $result;

    603. 

  603.             }

    604. 

  604.             $this->set("favs",$favs);

    605. 

  605.         }

    606. 

  606. 

    607. 

  607.         $this->countFavCart();

    608. 

  608. 

    609. 

  609.         //Initializing all the bradcamp back again so that it all starts all over again

    610. 

  610.         $this->set("filename","creative_favorite");

    611. 

  611.         $this->set("nextpage","mycart");

    612. 

  612. 

    613. 

  613.         //_________________________________________________________________________________________________

    614. 

  614. 

    615. 

  615.         $this->set("recenttype","creative_favorite");

    616. 

  616.         $this->getCartDetails();

    617. 

  617.     }

    618. 

  618.     //ok

    619. 

  619.     function creative_favorite_ajax() {

    620. 

  620.         if(isset($_POST['ssn_id'])) {

    621. 

  621.             $ssn_id = $_POST['ssn_id'];

    622. 

  622.             $fav = $this->Creative_favorites->findBySsn_id(base64_decode($_POST['ssn_id']));

    623. 

  623. 

    624. 

  624.             if(!$fav) {

    625. 

  625.                 $fav['Creative_favorites']['ssn_id'] = base64_decode($_POST['ssn_id']);

    626. 

  626.                 $fav['Creative_favorites']['user_id'] = $_SESSION['UserId'];

    627. 

  627.                 $fav['Creative_favorites']['title'] = base64_decode($_POST['title']);

    628. 

  628.                 $fav['Creative_favorites']['description'] = $_POST['description'];

    629. 

  629.                 $fav['Creative_favorites']['price'] = $_POST['price'];

    630. 

  630.                 $fav['Creative_favorites']['width'] = $_POST['width'];

    631. 

  631.                 $fav['Creative_favorites']['height'] = $_POST['height'];

    632. 

  632.                 $fav['Creative_favorites']['fileThumb'] = base64_decode($_POST['fileThumb']);

    633. 

  633.                 $fav['Creative_favorites']['fileThumb2'] = base64_decode($_POST['fileThumb2']);

    634. 

  634.                 $fav['Creative_favorites']['fileThumb3'] = base64_decode($_POST['fileThumb3']);

    635. 

  635.                 $fav['Creative_favorites']['fileData'] = base64_decode($_POST['fileData']);

    636. 

  636.                 $fav['Creative_favorites']['fileZip'] = base64_decode($_POST['fileZip']);

    637. 

  637.                 $fav['Creative_favorites']['is_temp'] = 0;

    638. 

  638. 

    639. 

  639.                 $fav['Creative_favorites']['creative_type_id'] = $_POST['creative_type_id'];

    640. 

  640.                 $fav['Creative_favorites']['type'] = $_POST['type'];

    641. 

  641.                 $fav['Creative_favorites']['is_featured'] = $_POST['is_featured'];

    642. 

  642. 

    643. 

  643.                 $this->Creative_favorites->create();

    644. 

  644.                 $resultSave = $this->Creative_favorites->save($fav);//return 1/null

    645. 

  645. 

    646. 

  646. 

    647. 

  647.                 //insert tag

    648. 

  648.                 if($resultSave && $_POST['tag']!='') {

    649. 

  649.                     $tag['Creative_favorite_tags']['creative_favorite_id'] = $this->Creative_favorites->id;

    650. 

  650.                     $tag['Creative_favorite_tags']['user_id'] = $_SESSION['UserId'];

    651. 

  651.                     $tag['Creative_favorite_tags']['tagname'] = $_POST['tag'];

    652. 

  652.                     $this->Creative_favorite_tags->create();

    653. 

  653.                     $this->Creative_favorite_tags->save($tag);

    654. 

  654.                 }

    655. 

  655.             }

    656. 

  656.         }

    657. 

  657. 

    658. 

  658.         $this->countFavCart();

    659. 

  659.         $this->render("creative_favorite_ajax","ajax");

    660. 

  660. 

    661. 

  661.     }

    662. 

  662. 

    663. 

  663.     function creativeType() {

    664. 

  664.         $q1=mysql_query("SELECT * FROM creative_type WHERE is_delete='0' ORDER BY sequence ASC");

    665. 

  665.         $i=0;

    666. 

  666.         while($rwCr=mysql_fetch_array($q1)) {

    667. 

  667.             if($i==0)

    668. 

  668.                 $defaultCat[$rwCr['id']]=array($rwCr['creative_name'],$rwCr['creative_description'],$rwCr['creative_image']);

    669. 

  669.             $i++;

    670. 

  670. 

    671. 

  671.             $creativeType[$rwCr['id']]=array($rwCr['creative_name'],$rwCr['creative_description'],$rwCr['creative_image']);

    672. 

  672.         }

    673. 

  673. 

    674. 

  674.         $this->set("defaultType",$defaultCat);

    675. 

  675.         $this->set("creativeType",$creativeType);

    676. 

  676. 

    677. 

  677.         $type = 0;

    678. 

  678.         foreach($defaultCat as $key=>$value) {

    679. 

  679.             $type = $key;

    680. 

  680.             break;

    681. 

  681.         }

    682. 

  682. 

    683. 

  683.         if(isset($this->params['url']['cat'])) {

    684. 

  684.             $scrapType=base64_decode($this->params['url']['cat']);

    685. 

  685.             $detail = $this->getCreativeType($scrapType);

    686. 

  686.             if($detail) {

    687. 

  687.                 $type = $detail['id'];

    688. 

  688.             }

    689. 

  689.         }

    690. 

  690. 

    691. 

  691.         $this->set('defaultCate',$type);

    692. 

  692.     }

    693. 

  693.     //checking

    694. 

  694. 

    695. 

  695.     function templateDetail($tmpImg) {

    696. 

  696.         $q1=mysql_query("SELECT * FROM creative_favorites WHERE id='".$tmpImg."' AND is_blocked='0' AND is_temp='0' AND is_approved='1' AND type='0' ") or die(mysql_error());

    697. 

  697.         if(mysql_num_rows($q1)>0) {

    698. 

  698.             $rwTmpImg=mysql_fetch_assoc($q1);

    699. 

  699.             $this->set("tmpid",base64_encode($rwTmpImg['ssn_id']));

    700. 

  700.             $this->set("tmp",base64_encode($tmpImg));

    701. 

  701.             return $tmpImg;

    702. 

  702.         }

    703. 

  703.         return 0;

    704. 

  704.     }

    705. 

  705.     //ok

    706. 

  706.     function getPublicScrap() {

    707. 

  707. 

    708. 

  708.         $select = " Select X.price,X.fileThumb2 as imagename,X.id,X.creation,X.user_id,X.title,XCreativetype.creative_name ,XCreativetype.id as creativetypeid,  X.description,Xuser.username ,COUNT(Xcomment.id) as photoreview ,  Xuserdetail.user_profile_img , IFNULL(ROUND(AVG(Xrating.vote),0),0) as photorat";

    709. 

  709. 

    710. 

  710.         $from=" FROM creative_favorites X

    711. 

  711. 						LEFT JOIN creative_type XCreativetype ON X.creative_type_id = XCreativetype.id

    712. 

  712. 						

    713. 

  713. 						LEFT JOIN creative_favorite_comments Xcomment ON X.id = Xcomment.creative_favorite_id	

    714. 

  714. 						LEFT JOIN users Xuser ON  X.user_id = Xuser.id

    715. 

  715. 						LEFT JOIN user_details Xuserdetail ON X.user_id = Xuserdetail.user_id

    716. 

  716. 						LEFT JOIN creative_favorite_voting Xrating ON X.id = Xrating.creative_favorite_id";

    717. 

  717. 

    718. 

  718.         $where=" WHERE  X.is_blocked='0' AND X.is_temp='0' AND X.type='0' AND X.is_approved='1' AND X.is_stop_sell='0'";

    719. 

  719.         $others=" group by X.id ";

    720. 

  720.         $others .=" order by photorat desc ";

    721. 

  721. 

    722. 

  722.         $queryCreative = $select . $from .  $where .$others ;

    723. 

  723. 

    724. 

  724.         $queryCreativeFavorites=mysql_query($queryCreative) or die("Error on line :".__LINE__.mysql_error());

    725. 

  725. 

    726. 

  726. 

    727. 

  727. 

    728. 

  728. 

    729. 

  729. 

    730. 

  730. 

    731. 

  731.         $queryCreativeFavorites=mysql_query($queryCreative) or die("Error on line :".__LINE__.mysql_error());

    732. 

  732. 

    733. 

  733.         $this->set("publicScrap",$queryCreativeFavorites);

    734. 

  734.         $this->set("publicScrapSql",$queryCreative);

    735. 

  735. 

    736. 

  736.     }

    737. 

  737.     //ok

    738. 

  738.     function getRankScrap() {

    739. 

  739.         /*$select = " Select X.fileThumb2 as template_img,X.price,X.id,X.creation,X.user_id,X.title,XCreativetype.creative_name ,XCreativetype.id as creativetypeid,  X.description,Xuser.username ,COUNT(Xcomment.id) as photoreview ,  Xuserdetail.user_profile_img , IFNULL(ROUND(AVG(Xrating.vote),0),0) as photorat";

    740. 

  740. 

    741. 

  741.         $from=" FROM creative_favorites X

    742. 

  742. 						LEFT JOIN creative_type XCreativetype ON X.creative_type_id = XCreativetype.id

    743. 

  743. 						

    744. 

  744. 						LEFT JOIN creative_favorite_comments Xcomment ON X.id = Xcomment.creative_favorite_id	

    745. 

  745. 						LEFT JOIN users Xuser ON  X.user_id = Xuser.id

    746. 

  746. 						LEFT JOIN user_details Xuserdetail ON X.user_id = Xuserdetail.user_id

    747. 

  747. 						LEFT JOIN creative_favorite_voting Xrating ON X.id = Xrating.creative_favorite_id";

    748. 

  748. 

    749. 

  749.         $where=" WHERE  X.is_blocked='0' AND X.is_temp='0' AND X.type='0' AND X.is_approved='1' ";

    750. 

  750.         $others=" group by X.id ";

    751. 

  751.         $others .=" order by photorat desc LIMIT 21";

    752. 

  752. 

    753. 

  753.         $queryCreative = $select . $from .  $where .$others ;

    754. 

  754. 

    755. 

  755.         $queryCreativeFavorites=mysql_query($queryCreative) or die("Error on line :".__LINE__.mysql_error());

    756. 

  756. 

    757. 

  757.         $this->set("publicRank",$queryCreativeFavorites);

    758. 

  758.         $this->set("publicRankSql",$queryCreative);

    759. 

  759.         */

    760. 

  760.     }

    761. 

  761.     //ok

    762. 

  762.     function getFeaturedScrap() {

    763. 

  763.         /*$select = " Select X.width, X.height, X.price, X.id,X.creation,X.user_id,X.title,XCreativetype.creative_name ,XCreativetype.id as creativetypeid,  X.description,XCreativetypeDetail.template_img,Xuser.username ,COUNT(Xcomment.id) as photoreview ,  Xuserdetail.user_profile_img , IFNULL(ROUND(AVG(Xrating.vote),0),0) as photorat,Xalbum.price";

    764. 

  764. 

    765. 

  765.         $from=" FROM creative_favorites X

    766. 

  766. 						

    767. 

  767. 						LEFT JOIN creative_favorites_details XCreativetypeDetail ON X.id = XCreativetypeDetail.creative_favorite_id

    768. 

  768. 						LEFT JOIN creative_template_pages Xalbum ON X.creative_template_page_id = Xalbum.id

    769. 

  769. 						LEFT JOIN creative_type XCreativetype ON Xalbum.creative_type_id = XCreativetype.id

    770. 

  770. 						

    771. 

  771. 						LEFT JOIN creative_favorite_comments Xcomment ON X.id = Xcomment.creative_favorite_id	

    772. 

  772. 						LEFT JOIN users Xuser ON  X.user_id = Xuser.id

    773. 

  773. 						LEFT JOIN user_details Xuserdetail ON X.user_id = Xuserdetail.user_id

    774. 

  774. 						LEFT JOIN creative_favorite_voting Xrating ON X.id = Xrating.creative_favorite_id";

    775. 

  775. 

    776. 

  776.         $where=" WHERE  X.is_blocked='0' AND X.is_temp='0' AND X.type='0' AND X.is_featured='1' AND X.is_approved='1' ";

    777. 

  777.         $others=" group by X.id ";

    778. 

  778.         $others .=" order by photorat desc LIMIT 21";

    779. 

  779. 

    780. 

  780.         $queryCreative = $select . $from .  $where .$others ;

    781. 

  781. 

    782. 

  782.         $queryCreativeFavorites=mysql_query($queryCreative) or die("Error on line :".__LINE__.mysql_error());

    783. 

  783. 

    784. 

  784.         $this->set("publicFeatured",$queryCreativeFavorites);

    785. 

  785.         $this->set("publicFeaturedSql",$queryCreative);

    786. 

  786.         */

    787. 

  787.     }

    788. 

  788.     //ok

    789. 

  789.     function viewalltag() {

    790. 

  790.         $this->pageTitle = 'ScrapFOTO&trade; - View Tag';

    791. 

  791.         $this->layout = 'creativedetail';

    792. 

  792.         $this->creativeType();

    793. 

  793.         $this->getPublicScrap();

    794. 

  794. 

    795. 

  795.     }

    796. 

  796.     //ok

    797. 

  797.     function searchtag($alphasearch=null) {

    798. 

  798. 

    799. 

  799.         if($alphasearch)

    800. 

  800.             $searchtxt = "'".strtolower($alphasearch)."%'" ;

    801. 

  801.         else {

    802. 

  802.             if(isset($_REQUEST['txttagsearch']) && $_REQUEST['txttagsearch']!='')

    803. 

  803.                 $searchtxt = "'%". strip_html_tags($_REQUEST['txttagsearch'])."%'";

    804. 

  804.             else

    805. 

  805.                 $searchtxt='a%';

    806. 

  806.         }

    807. 

  807. 

    808. 

  808.         $tagarray = array();

    809. 

  809.         $tagsearchsql =  "SELECT DISTINCT(tagname) FROM creative_favorite_tags where tagname!='' and tagname like ". $searchtxt ."";

    810. 

  810.         $tagsearchsql_res = mysql_query($tagsearchsql);

    811. 

  811.         while($tagsearchsql_arr = mysql_fetch_array($tagsearchsql_res)) {

    812. 

  812.             $tagarray[] = $tagsearchsql_arr['tagname'];

    813. 

  813.         }

    814. 

  814.         $this->set('tagsql',$tagsearchsql);

    815. 

  815.         $this->set('tagarray',$tagarray);

    816. 

  816.         $this->set('Numtagarray',mysql_num_rows($tagsearchsql_res));

    817. 

  817.         $this->set('searchtxt',$alphasearch);

    818. 

  818.         $this->render('searchtaglist', 'ajax');

    819. 

  819. 

    820. 

  820.     }

    821. 

  821.     //ok

    822. 

  822.     function scrapaddtocart($scrapxongid=null) {

    823. 

  823. 

    824. 

  824.         $queryCreativeFavorites=mysql_query("

    825. 

  825. 				SELECT CF.title,CTP.price

    826. 

  826. 				FROM creative_favorites CF,creative_template_pages CTP

    827. 

  827. 				WHERE CF.id='".base64_decode($scrapxongid)."' AND CF.creative_template_page_id=CTP.id AND CF.type='0'");

    828. 

  828.         $fetchCreativeFavorites=mysql_fetch_assoc($queryCreativeFavorites);

    829. 

  829.         $productName=$fetchCreativeFavorites['title'];

    830. 

  830.         $price=$fetchCreativeFavorites['price'];

    831. 

  831. 

    832. 

  832.         if(isset($_SESSION['UserId'])) {

    833. 

  833.             $creativecartsql = "SELECT * from creative_carts WHERE user_id='".$_SESSION['UserId']."' and product_name='".$productName."' and ssn_id='".session_id()."' and pay_status='0'";

    834. 

  834.             $creativecartsql_res = mysql_query($creativecartsql);

    835. 

  835.             if(mysql_num_rows($creativecartsql_res)==0) {

    836. 

  836.                 mysql_query("INSERT INTO

    837. 

  837. 						creative_carts(user_id,product_name,price,qty,transaction_creative_id,pay_status,ssn_id) 

    838. 

  838. 						VALUES('".$_SESSION['UserId']."','".$productName."','".$price."','1','0','0','".session_id()."')") or die("Error on line : ".__LINE__.mysql_error());

    839. 

  839. 

    840. 

  840.                 $lastId=mysql_insert_id();

    841. 

  841. 

    842. 

  842.                 $queryCreativeFavoritesDetails=mysql_query("SELECT template_img FROM creative_favorites_details WHERE creative_favorite_id='".base64_decode($scrapxongid)."'");

    843. 

  843.                 while($fetchCreativeFavoritesDetails=mysql_fetch_assoc($queryCreativeFavoritesDetails)) {

    844. 

  844.                     mysql_query("INSERT INTO creative_cart_details(creative_cart_id,imagename) VALUES('".$lastId."','".$fetchCreativeFavoritesDetails['template_img']."')");

    845. 

  845.                 }

    846. 

  846.             }

    847. 

  847.         }

    848. 

  848. 

    849. 

  849. 

    850. 

  850.         $this->countFavCart();

    851. 

  851.         $this->set('photoImageId',$scrapxongid);

    852. 

  852.         $this->render('cartitem', 'ajax');

    853. 

  853.     }

    854. 

  854. 

    855. 

  855.     function creative_login() {

    856. 

  856.         $uName=base64_decode($this->params['url']['u']);

    857. 

  857.         $password=$this->params['url']['p'];

    858. 

  858. 

    859. 

  859.         $id=0;

    860. 

  860.         if(isset($this->params['url']['ct']))

    861. 

  861.             $id=base64_decode($this->params['url']['ct']);

    862. 

  862. 

    863. 

  863. //This ct variable comes from CREATIVETEMPLATE page

    864. 

  864.         $tmpImg=0;

    865. 

  865.         if(isset($this->params['url']['tmp']))

    866. 

  866.             $tmpImg=base64_decode($this->params['url']['tmp']);

    867. 

  867. 

    868. 

  868. 

    869. 

  869. //This is the last iserted id in the favorite table

    870. 

  870.         $lastId=0;

    871. 

  871.         if(isset($this->params['url']['lid']))

    872. 

  872.             $lastId=base64_decode($this->params['url']['lid']);

    873. 

  873. 

    874. 

  874.         $someone=$this->userLogin($uName,$password);

    875. 

  875.         if(!empty($someone))

    876. 

  876.             $this->redirect("creativezones/creative_favorite?ct=".base64_encode($id)."&tmp=".base64_encode($tmpImg)."&lid=".base64_encode($lastId));

    877. 

  877. 

    878. 

  878.     }

    879. 

  879. 

    880. 

  880.     function featuredpayment() {

    881. 

  881.         /*

    882. 

  882.         $this->checkSession();

    883. 

  883.         $this->layout = 'previewpaymemnt';

    884. 

  884.         $this->render("paymentback");

    885. 

  885. 

    886. 

  886.         //This ct variable comes from INDEX page and CREATIVETEMPLATE page

    887. 

  887.         $id=0;

    888. 

  888.         if(isset($this->params['url']['ct']))

    889. 

  889.             $id=base64_decode($this->params['url']['ct']);

    890. 

  890. 

    891. 

  891.         //This ct variable comes from CREATIVETEMPLATE page

    892. 

  892.         $tmpImg=0;

    893. 

  893.         if(isset($this->params['url']['tmp']))

    894. 

  894.             $tmpImg=base64_decode($this->params['url']['tmp']);

    895. 

  895. 

    896. 

  896.         //This is the last iserted id in the favorite table

    897. 

  897.         //If lid means user comes to this page after saving the scrapbook

    898. 

  898.         //We are checking whether the user features the scrapblog or not if yes then ask for the payment

    899. 

  899.         $lastId=0;

    900. 

  900.         if(isset($this->params['url']['lid']))

    901. 

  901.             $lastId=base64_decode($this->params['url']['lid']);

    902. 

  902. 

    903. 

  903. 

    904. 

  904.         $this->set("cType",$id);

    905. 

  905.         $this->set("cTemplate",$tmpImg);

    906. 

  906.         $this->set("lastId",$lastId);

    907. 

  907. 

    908. 

  908.         if(!empty($this->data)) {

    909. 

  909.             $fetchAdminPaymentSetup=$this->getPaymentMethods(1);	// that means payment will go to the admin paymenbt id

    910. 

  910.             $featuredAmount=$this->getConfigAmount('creative featured');

    911. 

  911. 

    912. 

  912.             $amountCharge=$this->data['creative']['amount'];

    913. 

  913.             if(isset($this->data['Event']['radiobutton'])) {

    914. 

  914.                 if($this->data['Event']['radiobutton']=="paypal") {

    915. 

  915.                     $this->itemName="ScrapFOTO&trade; fetaured";

    916. 

  916.                     $this->amountPay=$amountCharge;

    917. 

  917.                     $this->returnUrl=FULL_BASE_URL.$this->webroot."creativezones/creative_favorite";

    918. 

  918.                     $this->notifyUrl=FULL_BASE_URL.$this->webroot."creativezones/featuredsuccess";

    919. 

  919.                     $this->merchantEmail=$fetchAdminPaymentSetup['paypal_email'];

    920. 

  920.                     $this->custom=$_SESSION['UserId']."^".$id."^".$tmpImg."^".$lastId;

    921. 

  921.                     $this->paypal();

    922. 

  922.                 }

    923. 

  923. 

    924. 

  924.                 if($this->data['Event']['radiobutton']=="google") {

    925. 

  925.                     $adminPayment=$fetchAdminPaymentSetup['gcheckout_email'];

    926. 

  926.                     $adminPaymentDetails=explode("break",$adminPayment);

    927. 

  927.                     $this->Gcheckout->gMerchantId=$adminPaymentDetails['0'];

    928. 

  928.                     $this->Gcheckout->gMerchantKey=$adminPaymentDetails['1'];

    929. 

  929.                     $this->Gcheckout->gItemName="ScrapFOTO&trade; Featured";

    930. 

  930.                     $this->Gcheckout->gItemDesc="ScrapFOTO&trade; Featured";

    931. 

  931.                     $this->Gcheckout->gQuantity=1;

    932. 

  932.                     $this->Gcheckout->gPrice=$amountCharge;

    933. 

  933.                     $this->Gcheckout->gReturnUrl=FULL_BASE_URL.$this->webroot."creativezones/creative_favorite";

    934. 

  934.                     $this->Gcheckout->gNotifyUrl=FULL_BASE_URL.$this->webroot."creativezones/featuredsuccess";

    935. 

  935.                     $this->Gcheckout->customData=$_SESSION['UserId']."^".$id."^".$tmpImg."^".$lastId."^".$amountCharge;

    936. 

  936.                     $this->Gcheckout->google();

    937. 

  937. 

    938. 

  938.                 }

    939. 

  939.             }

    940. 

  940. 

    941. 

  941.         }*/

    942. 

  942. 

    943. 

  943.     }

    944. 

  944. 

    945. 

  945.     function creative_featured() {

    946. 

  946.         $this->checkSession();

    947. 

  947.         $this->pageTitle = 'ScrapFOTO&trade; - Featured ScrapFOTO&trade;';

    948. 

  948.         $this->layout = 'creativehome';

    949. 

  949.         $this->creativeType();

    950. 

  950.         $this->getPublicScrap();

    951. 

  951.         $cartCount=$this->countFavCart();

    952. 

  952. 

    953. 

  953.         $tmpImg =0;

    954. 

  954.         $id =0;

    955. 

  955. 

    956. 

  956.         $lastId=0;

    957. 

  957.         if(isset($this->params['url']['lid']))

    958. 

  958.             $lastId=base64_decode($this->params['url']['lid']);

    959. 

  959. 

    960. 

  960.         $this->set("lastId",$lastId);

    961. 

  961. 

    962. 

  962.         $this->set("filename","creative_cart");

    963. 

  963.         $this->set("recenttype","creative_favorite");

    964. 

  964. 

    965. 

  965.         $featuredAmount=$this->getConfigAmount('creative featured');

    966. 

  966.         $this->set("featuredAmount",$featuredAmount);

    967. 

  967. 

    968. 

  968.         //getCartDetails;

    969. 

  969.         $sql = "SELECT *,CF.fileThumb2 as imagename FROM creative_favorites as CF WHERE CF.id='".$lastId."' LIMIT 1";

    970. 

  970.         $queryCreativeCarts=mysql_query($sql);

    971. 

  971.         $this->set("queryCreativeCarts",$queryCreativeCarts);

    972. 

  972. 

    973. 

  973.         $this->getUserDetails();

    974. 

  974. 

    975. 

  975. 

    976. 

  976. 

    977. 

  977.         $fetchAdminPaymentSetup=$this->getPaymentMethods(1);	// that means payment will go to the admin paymenbt id

    978. 

  978.         $this->set("paymentMethods",$fetchAdminPaymentSetup);

    979. 

  979.     }

    980. 

  980.     //checking

    981. 

  981.     function featured_payment_notify() {

    982. 

  982.         /*

    983. 

  983.         $this->Paypal->paypal_class();

    984. 

  984.         $this->Paypal->paypal_url = $this->paypalUrl;   // testing paypal url

    985. 

  985. 

    986. 

  986.         //_______________________________________________IPN data received from PAYPAL and GOOGLE payment methods

    987. 

  987.         $paypal=0;

    988. 

  988.         if ($this->Paypal->validate_ipn()) {

    989. 

  989.             $paypal=1;

    990. 

  990.             if(isset($this->Paypal->ipn_data['payment_gross']) && ($this->Paypal->ipn_data['payment_gross'])!="") {

    991. 

  991.                 $totalPay=$this->Paypal->ipn_data['payment_gross'];

    992. 

  992.                 $custom=explode("^",$this->Paypal->ipn_data['custom']);

    993. 

  993.                 $userId=$custom['0'];

    994. 

  994.                 $lastId=$custom['1'];

    995. 

  995.                 $invoice=$_POST['invoice'];

    996. 

  996.                 $ticket=$custom['3'];

    997. 

  997. 

    998. 

  998.             }

    999. 

  999.         }

    1000. 

  1000. 

    1001. 

  1001.         //This section is used to catch from GOOGLE IPN data

    1002. 

  1002.         if(!$paypal) {

    1003. 

  1003.             //this section is used to update from google IPN data

    1004. 

  1004.             $xml_response = isset($HTTP_RAW_POST_DATA)?$HTTP_RAW_POST_DATA:file_get_contents("php://input");

    1005. 

  1005.             if($xml_response) {

    1006. 

  1006.                 $gCustom=$this->parseXmlArray($xml_response);

    1007. 

  1007.                 $cData=$gCustom['http://checkout.google.com/schema/2']['SHOPPING-CART']['ITEMS']['ITEM']['MERCHANT-PRIVATE-ITEM-DATA'];

    1008. 

  1008.                 $ipnData=explode("^",$cData);

    1009. 

  1009.                 $userId=$ipnData['0'];

    1010. 

  1010.                 $lastId=$ipnData['1'];

    1011. 

  1011.                 $invoice=$ipnData['2'];

    1012. 

  1012.                 $ticket=$ipnData['3'];

    1013. 

  1013.                 $totalPay=$ipnData['4'];

    1014. 

  1014.             }

    1015. 

  1015. 

    1016. 

  1016.         }

    1017. 

  1017.         */

    1018. 

  1018.     }

    1019. 

  1019.     //checking

    1020. 

  1020.     function featuredsuccess() {

    1021. 

  1021. 

    1022. 

  1022.         $is_featured = 1;

    1023. 

  1023.         $productId=0;

    1024. 

  1024.         if(isset($this->params['url']['lid']))

    1025. 

  1025.             $productId=base64_decode($this->params['url']['lid']);

    1026. 

  1026. 

    1027. 

  1027.         if($productId==0) {

    1028. 

  1028.             //_______________________________________________IPN data received from PAYPAL and GOOGLE payment methods

    1029. 

  1029.             $paypal=0;

    1030. 

  1030.             if (isset($_POST['payment_gross']) && ($_POST['payment_gross'])!="") {

    1031. 

  1031.                 $paypal=1;

    1032. 

  1032. 

    1033. 

  1033.                 $totalPay=$_POST['payment_gross'];

    1034. 

  1034.                 $custom=explode("^",$_POST['custom']);

    1035. 

  1035. 

    1036. 

  1036.                 $userId=$custom['0'];

    1037. 

  1037.                 $sellerId=$custom['1'];

    1038. 

  1038.                 $isAdmin=$custom['2'];

    1039. 

  1039.                 $rdPage=$custom['3'];

    1040. 

  1040.                 $invoice=$custom['4'];

    1041. 

  1041.                 $transactionId=$custom['5'];

    1042. 

  1042.                 $ticket=$custom['6'];

    1043. 

  1043.                 $productId=$custom['7'];

    1044. 

  1044.             }

    1045. 

  1045. 

    1046. 

  1046.             //This section is used to catch from GOOGLE IPN data

    1047. 

  1047.             if(!$paypal) {

    1048. 

  1048.                 //this section is used to update from google IPN data

    1049. 

  1049.                 $xml_response = isset($HTTP_RAW_POST_DATA)?$HTTP_RAW_POST_DATA:file_get_contents("php://input");

    1050. 

  1050.                 if($xml_response) {

    1051. 

  1051.                     $gCustom=$this->parseXmlArray($xml_response);

    1052. 

  1052.                     $cData=$gCustom['http://checkout.google.com/schema/2']['SHOPPING-CART']['ITEMS']['ITEM']['MERCHANT-PRIVATE-ITEM-DATA'];

    1053. 

  1053.                     $ipnData=explode("^",$cData);

    1054. 

  1054. 

    1055. 

  1055.                     $userId=$ipnData['0'];

    1056. 

  1056.                     $sellerId=$ipnData['1'];

    1057. 

  1057.                     $isAdmin=$ipnData['2'];

    1058. 

  1058.                     $rdPage=$ipnData['3'];

    1059. 

  1059.                     $invoice=$ipnData['4'];

    1060. 

  1060.                     $transactionId=$ipnData['5'];

    1061. 

  1061.                     $totalPay=$ipnData['6'];

    1062. 

  1062.                     $ticket=$ipnData['7'];

    1063. 

  1063.                     $productId=$ipnData['8'];

    1064. 

  1064.                 }

    1065. 

  1065.             }

    1066. 

  1066.         }else {

    1067. 

  1067.             $userId = $_SESSION['UserId'];

    1068. 

  1068.             $totalPay = 0;

    1069. 

  1069.             $ticket = $this->createTransactionNumber('SPTT');

    1070. 

  1070.             $is_featured = 0;

    1071. 

  1071.         }

    1072. 

  1072. 

    1073. 

  1073.         //________________________________________________XOIMAGE DATABASE UPDATION SECTION

    1074. 

  1074. 

    1075. 

  1075.         //update featured_time

    1076. 

  1076.         $featured_time = NULL;

    1077. 

  1077.         if($is_featured==1){

    1078. 

  1078.             $result = $this->getConfigAmount('creative featured days');

    1079. 

  1079.             $featureddays = $result['config_value'];

    1080. 

  1080.             $featured_time = date('Y-m-d G:i:s', strtotime("+".$featureddays." day"));

    1081. 

  1081.         }

    1082. 

  1082. 

    1083. 

  1083.         $queryCreativeFavorites=mysql_query("

    1084. 

  1084. 					UPDATE creative_favorites

    1085. 

  1085. 					SET is_featured='$is_featured',is_temp='0', featured_time='".$featured_time."'

    1086. 

  1086. 					WHERE user_id='".$userId."' AND id='".$productId."'") or die("Error on line : ".__LINE__.mysql_error());

    1087. 

  1087.         

    1088. 

  1088. 

    1089. 

  1089.         if(isset($transactionId)) {

    1090. 

  1090.             //UPDATE date on TRANSACTION_CREATIVE TABLE

    1091. 

  1091.             $queryUpdateTransactionCreative="

    1092. 

  1092.                                     UPDATE transaction_creatives

    1093. 

  1093.                                     SET pay_status='1',invoice='".$invoice."'

    1094. 

  1094.                                     WHERE id='".$transactionId."' AND user_id='".$userId."'";

    1095. 

  1095.             mysql_query($queryUpdateTransactionCreative) or die("Error on line : ".__LINE__.mysql_error());

    1096. 

  1096. 

    1097. 

  1097.             //UPDATE data to the CREATIVE_CARTS TABLE after successful transaction

    1098. 

  1098.             $queryUpdateCreativeCart="

    1099. 

  1099.                                     UPDATE creative_carts

    1100. 

  1100.                                     SET pay_status='1', total_price='".$totalPay."'

    1101. 

  1101.                                     WHERE user_id='".$userId."' AND pay_status='0' AND transaction_creative_id='".$transactionId."' ";

    1102. 

  1102.             mysql_query($queryUpdateCreativeCart) or die("Error on line : ".__LINE__.mysql_error());

    1103. 

  1103.         }

    1104. 

  1104. 

    1105. 

  1105.         //____________________________________________________TRANSACTION LOG MANAGEMENT_____________________________________

    1106. 

  1106. 

    1107. 

  1107.         $userDetails=$this->getUserDetails($userId);

    1108. 

  1108.         $scrapDetails=$this->scrapDetails($productId);

    1109. 

  1109. 

    1110. 

  1110.         if(isset($invoice))

    1111. 

  1111.             $this->set('invoice',$invoice);

    1112. 

  1112. 

    1113. 

  1113.         $this->set('ticket',$ticket);

    1114. 

  1114.         $this->set('totalPay',$totalPay);

    1115. 

  1115. 

    1116. 

  1116.         //ticket

    1117. 

  1117.         $ticketData = $this->Creative_tickets->findByCreative_favorites_id($productId);

    1118. 

  1118. 

    1119. 

  1119.         if(!$ticketData) {

    1120. 

  1120.             $ticketData['Creative_tickets']['user_id'] = $userId;

    1121. 

  1121.             $ticketData['Creative_tickets']['creative_favorites_id'] = $productId;

    1122. 

  1122.             $ticketData['Creative_tickets']['ticket_number'] = $ticket;

    1123. 

  1123.             $ticketData['Creative_tickets']['status'] = 'awaiting';

    1124. 

  1124. 

    1125. 

  1125.             $this->Creative_tickets->create();

    1126. 

  1126.             $this->Creative_tickets->save($ticketData);

    1127. 

  1127. 

    1128. 

  1128. 

    1129. 

  1129. 

    1130. 

  1130. 

    1131. 

  1131.             //____________________________________________________MAIL MANAGEMENT________________________________________________

    1132. 

  1132.             //this mailing code is here so that it fires just once.

    1133. 

  1133. 

    1134. 

  1134.             //mail sent to the user personal account

    1135. 

  1135.             $this->Sendmail->Mail();

    1136. 

  1136.             $this->Sendmail->From(FROMMAIL);

    1137. 

  1137. 

    1138. 

  1138.             if(isset($userDetails['email'])) {

    1139. 

  1139.                 $this->Sendmail->To($userDetails['email']);

    1140. 

  1140. 

    1141. 

  1141.                 //$this->Sendmail->Cc("sujoy@navsoft.in");

    1142. 

  1142.                 //$this->Sendmail->Cc("amarjit@navsoft.in");

    1143. 

  1143.                 //$this->Sendmail->Bcc( "someoneelse@somewhere.fr");

    1144. 

  1144. 

    1145. 

  1145.                 $subject="XOimages - Scrapfoto Ticket ".$ticket;

    1146. 

  1146.                 $this->Sendmail->Subject($subject);

    1147. 

  1147. 

    1148. 

  1148.                 $this->set("ticket_number",$ticket);

    1149. 

  1149.                 if(isset($invoice)) {

    1150. 

  1150.                     $featuredAmount=$this->getConfigAmount('creative featured');

    1151. 

  1151.                     $this->set('featurefee', $featuredAmount['config_value']);

    1152. 

  1152.                 }

    1153. 

  1153. 

    1154. 

  1154.                 $this->Sendmail->layout='email';

    1155. 

  1155.                 $this->Sendmail->view='mail_ticket';

    1156. 

  1156.                 $this->Sendmail->startup($this);

    1157. 

  1157.                 $messageBody=$this->Sendmail->bodyText();

    1158. 

  1158. 

    1159. 

  1159.                 $this->Sendmail->Body($messageBody);        // set the body

    1160. 

  1160.                 $this->Sendmail->Priority(1) ;        // set the priority to Low

    1161. 

  1161.                 $this->Sendmail->Send();        // send the mail

    1162. 

  1162. 

    1163. 

  1163. 

    1164. 

  1164.                 //mail sent to the user mail account in the system

    1165. 

  1165. 

    1166. 

  1166.                 $sender=1;

    1167. 

  1167.                 $receiver=$userId;

    1168. 

  1168.                 $this->senderMail($sender,$receiver,$subject,$messageBody);

    1169. 

  1169.                 $this->receiverMail($receiver,$sender,$subject,$messageBody);

    1170. 

  1170.             }

    1171. 

  1171. 

    1172. 

  1172.         }else {

    1173. 

  1173.             $ticket = $ticketData['Creative_tickets']['ticket_number'];

    1174. 

  1174.         }

    1175. 

  1175. 

    1176. 

  1176.         //invoice

    1177. 

  1177.         if(isset($invoice)) {

    1178. 

  1178.             $downloadimg=$this->getCartImages($userId,$transactionId);

    1179. 

  1179.             $zipfilename = 'scrapblogimg'.$transactionId.$userId.'.zip';

    1180. 

  1180. 

    1181. 

  1181.             //UPDATE transaction_creatives with the scrapfoto filename$zipfilename

    1182. 

  1182.             mysql_query("

    1183. 

  1183.                                     UPDATE transaction_creatives

    1184. 

  1184.                                     SET scrapfoto_file='".$zipfilename."'

    1185. 

  1185.                                     WHERE id='".$transactionId."' AND user_id='".$userId."'") or die("Error on line - ".__LINE__.mysql_error());

    1186. 

  1186.             ;

    1187. 

  1187.             $downloadimgs = array();

    1188. 

  1188.             $Imgdestination='';

    1189. 

  1189.             foreach($downloadimg as $img) {

    1190. 

  1190.                 $arr = explode('/', $img);

    1191. 

  1191.                 $downloadimgs[] = $arr[count($arr)-1];

    1192. 

  1192.                 $Imgdestination = '../'.substr($img, 0, - strlen($arr[count($arr)-1]));

    1193. 

  1193.             }

    1194. 

  1194. 

    1195. 

  1195.             $Imgdestination = realpath($Imgdestination).'/';

    1196. 

  1196.             $zipdestination = realpath('../app/webroot/creativezone/downloadscraps/').'/';

    1197. 

  1197.             $this->Zipfile->addFiles($downloadimgs,$Imgdestination);  //array of files

    1198. 

  1198.             $this->Zipfile->output($zipfilename,$zipdestination);

    1199. 

  1199. 

    1200. 

  1200.             $queryXouserTransactions=mysql_query("SELECT * FROM xouser_transactions WHERE transaction_head='scrapfoto' AND transaction_title='feature' AND invoice_id='".$transactionId."'");

    1201. 

  1201.             if(mysql_num_rows($queryXouserTransactions)<=0) {

    1202. 

  1202.                 $transactionDesc="ScrapFOTO - scraps featured";

    1203. 

  1203.                 $transactionHead="scrapfoto";

    1204. 

  1204.                 $transactionTitle="feature";

    1205. 

  1205.                 $invoiceId=$transactionId;

    1206. 

  1206. 

    1207. 

  1207.                 $statusoffee = "nontransactionfee";

    1208. 

  1208. 

    1209. 

  1209.                 $lastInsertId=$this->transactionMaster($transactionDesc,$transactionHead,$transactionTitle,$invoice,$invoiceId);

    1210. 

  1210. 

    1211. 

  1211.                 $this->transactionDetail($userId,$totalPay,'-1',$lastInsertId,1,$statusoffee,0,'finished');	//charged//this code is changed on 7th January 2010(statusfee added as well as paymentstatus value 'finished' added---finished is not in used now.)

    1212. 

  1212.                 //$this->transactionDetail($userId,$totalPay,'+1',$lastInsertId,1);	//paid//this code is blocked on 7th January 2010

    1213. 

  1213. 

    1214. 

  1214. 

    1215. 

  1215.                 //____________________________________________________MAIL MANAGEMENT________________________________________________

    1216. 

  1216.                 //this mailing code is here so that it fires just once.

    1217. 

  1217. 

    1218. 

  1218.                 //mail sent to the user personal account

    1219. 

  1219.                 if(isset($userDetails['email'])) {

    1220. 

  1220.                     $this->Sendmail->Mail();

    1221. 

  1221.                     $this->Sendmail->From(FROMMAIL);

    1222. 

  1222.                     $this->Sendmail->To($userDetails['email']);

    1223. 

  1223. 

    1224. 

  1224.                     //$this->Sendmail->Cc("sujoy@navsoft.in");

    1225. 

  1225.                     //$this->Sendmail->Cc("amarjit@navsoft.in");

    1226. 

  1226.                     //$this->Sendmail->Bcc( "someoneelse@somewhere.fr");

    1227. 

  1227. 

    1228. 

  1228.                     $subject="XOimages - ScrapFoto Invoice ".$invoice;

    1229. 

  1229.                     $this->Sendmail->Subject($subject);

    1230. 

  1230. 

    1231. 

  1231.                     $this->set('tranId', $invoiceId);

    1232. 

  1232.                     $featuredAmount=$this->getConfigAmount('creative featured');

    1233. 

  1233.                     $this->set('featurefee', $featuredAmount['config_value']);

    1234. 

  1234. 

    1235. 

  1235.                     $this->Sendmail->layout='email';

    1236. 

  1236.                     $this->Sendmail->view='mail_scrapfeature';

    1237. 

  1237.                     $this->Sendmail->startup($this);

    1238. 

  1238.                     $messageBody=$this->Sendmail->bodyText();

    1239. 

  1239. 

    1240. 

  1240.                     $this->Sendmail->Body($messageBody);        // set the body

    1241. 

  1241.                     $this->Sendmail->Priority(1) ;        // set the priority to Low

    1242. 

  1242.                     $this->Sendmail->Send();        // send the mail

    1243. 

  1243. 

    1244. 

  1244. 

    1245. 

  1245.                     //mail sent to the user mail account in the system

    1246. 

  1246. 

    1247. 

  1247.                     $sender=1;

    1248. 

  1248.                     $receiver=$userId;

    1249. 

  1249.                     $this->senderMail($sender,$receiver,$subject,$messageBody);

    1250. 

  1250.                     $this->receiverMail($receiver,$sender,$subject,$messageBody);

    1251. 

  1251.                 }

    1252. 

  1252.             }

    1253. 

  1253.         }

    1254. 

  1254. 

    1255. 

  1255. 

    1256. 

  1256.         $this->layout = 'creativedetail';

    1257. 

  1257.         $this->creativeType();

    1258. 

  1258.         $this->countFavCart();

    1259. 

  1259.         $this->getRankScrap();

    1260. 

  1260.         $this->getFeaturedScrap();

    1261. 

  1261.         $this->getPublicScrap();

    1262. 

  1262.         $this->render('featuredsuccess','creativedetail');

    1263. 

  1263. 

    1264. 

  1264.     }

    1265. 

  1265.     //test

    1266. 

  1266.     function mail_ticket($ticket) {

    1267. 

  1267.         $this->layout = 'email';

    1268. 

  1268.         $this->set("ticket_number",$ticket);

    1269. 

  1269.         $featuredAmount=$this->getConfigAmount('creative featured');

    1270. 

  1270.         $this->set('featurefee', $featuredAmount['config_value']);

    1271. 

  1271.     }

    1272. 

  1272.     //test

    1273. 

  1273.     function mail_scrapfeature($tranId) {

    1274. 

  1274.         $this->layout = 'email';

    1275. 

  1275.         $this->set("tranId",$tranId);

    1276. 

  1276.         $featuredAmount=$this->getConfigAmount('creative featured');

    1277. 

  1277.         $this->set('featurefee', $featuredAmount['config_value']);

    1278. 

  1278.     }

    1279. 

  1279. 

    1280. 

  1280.     function scrapDetails($id) {

    1281. 

  1281.         $queryCreativeFavorites=mysql_query("SELECT * FROM creative_favorites WHERE id='".$id."'");

    1282. 

  1282.         return $fetchCreativeFavorites=mysql_fetch_assoc($queryCreativeFavorites);

    1283. 

  1283.     }

    1284. 

  1284. 

    1285. 

  1285.     function getUserCreativeSalesTax($stateId) {

    1286. 

  1286.         $queryCreativeSaletax=mysql_query("

    1287. 

  1287. 				SELECT tax 

    1288. 

  1288. 				FROM creative_saletax CS WHERE CS.state_id='".$stateId."'") or die("Error on line ".__LINE__.mysql_error());

    1289. 

  1289.         $fetchCreativeSaletax=mysql_fetch_assoc($queryCreativeSaletax);

    1290. 

  1290. 

    1291. 

  1291.         return $fetchCreativeSaletax['tax'];

    1292. 

  1292. 

    1293. 

  1293.     }

    1294. 

  1294.     //checking

    1295. 

  1295.     function chargecouponcode() {

    1296. 

  1296.         //cart deatils

    1297. 

  1297.         $this->getCartDetails();

    1298. 

  1298. 

    1299. 

  1299.         //sale tax

    1300. 

  1300.         $stateId=0;

    1301. 

  1301.         $saleTax=0;

    1302. 

  1302.         if(isset($this->params['url']['orderBy']))

    1303. 

  1303.             $stateId=$this->params['url']['orderBy'];

    1304. 

  1304. 

    1305. 

  1305.         if(isset($this->params['pass']['0']))

    1306. 

  1306.             $stateId=$this->params['pass']['0'];

    1307. 

  1307. 

    1308. 

  1308.         $saleTax=$this->getUserCreativeSalesTax($stateId);

    1309. 

  1309.         $this->set("saleTax",$saleTax);

    1310. 

  1310.         $this->set("stateId",$stateId);

    1311. 

  1311.         //Coupon code

    1312. 

  1312.         $couponCode=$this->params['pass']['1'];

    1313. 

  1313.         $this->set("coupon",$couponCode);

    1314. 

  1314. 

    1315. 

  1315.         $curDate=date("Y-m-d");

    1316. 

  1316.         $couponValue=0;

    1317. 

  1317.         $qry="SELECT coupon_value FROM creative_coupon

    1318. 

  1318. 				WHERE coupon_code='".$couponCode."' AND '$curDate' BETWEEN coupon_from AND coupon_to AND blocked='0'";

    1319. 

  1319.         $q1=mysql_query($qry);

    1320. 

  1320.         if(mysql_num_rows($q1)>0) {

    1321. 

  1321.             $rw=mysql_fetch_assoc($q1);

    1322. 

  1322.             $couponValue=$rw['coupon_value'];

    1323. 

  1323.         }

    1324. 

  1324. 

    1325. 

  1325.         //payment details

    1326. 

  1326.         //check if buy template then get payment of user create artist

    1327. 

  1327.         $tmpImg=0;

    1328. 

  1328.         if(isset($_SESSION['buyTemplate']['tmpId']))

    1329. 

  1329.             $tmpImg= $this->templateDetail($_SESSION['buyTemplate']['tmpId']);

    1330. 

  1330.         if($tmpImg>0) {

    1331. 

  1331.             $fav = $this->Creative_favorites->findById($tmpImg);

    1332. 

  1332.             $fetchAdminPaymentSetup=$this->getPaymentMethodsUsers($fav['Creative_favorites']['user_id']);	// that means payment will go to the user paymenbt id

    1333. 

  1333.             $this->set('sellerId',$fav['Creative_favorites']['user_id']);

    1334. 

  1334.         }else {

    1335. 

  1335.             $fetchAdminPaymentSetup=$this->getPaymentMethods(1);	// that means payment will go to the admin paymenbt id

    1336. 

  1336.             $this->set('sellerId',1);

    1337. 

  1337.         }

    1338. 

  1338. 

    1339. 

  1339.         $this->set("paymentMethods",$fetchAdminPaymentSetup);

    1340. 

  1340. 

    1341. 

  1341.         $this->set("couponValue",$couponValue);

    1342. 

  1342.         $this->set("saleTax",$saleTax);

    1343. 

  1343. 

    1344. 

  1344. 

    1345. 

  1345.         $this->render("couponcharge","ajax");

    1346. 

  1346.     }

    1347. 

  1347. 

    1348. 

  1348.     function feature_chargecouponcode() {

    1349. 

  1349. 

    1350. 

  1350.         $featuredAmount=$this->getConfigAmount('creative featured');

    1351. 

  1351.         $totalAmount = $featuredAmount['config_value'];

    1352. 

  1352. 

    1353. 

  1353.         //sale tax

    1354. 

  1354.         $stateId=0;

    1355. 

  1355.         $saleTax=0;

    1356. 

  1356.         if(isset($this->params['url']['orderBy']))

    1357. 

  1357.             $stateId=$this->params['url']['orderBy'];

    1358. 

  1358. 

    1359. 

  1359.         if(isset($this->params['pass']['0']))

    1360. 

  1360.             $stateId=$this->params['pass']['0'];

    1361. 

  1361. 

    1362. 

  1362.         $saleTax=$this->getUserCreativeSalesTax($stateId);

    1363. 

  1363.         $this->set("saleTax",$saleTax);

    1364. 

  1364.         $this->set("stateId",$stateId);

    1365. 

  1365.         //Coupon code

    1366. 

  1366.         $couponCode=$this->params['pass']['1'];

    1367. 

  1367.         $this->set("coupon",$couponCode);

    1368. 

  1368. 

    1369. 

  1369.         $curDate=date("Y-m-d");

    1370. 

  1370.         $couponValue=0;

    1371. 

  1371.         $qry="SELECT coupon_value FROM creative_coupon

    1372. 

  1372. 				WHERE coupon_code='".$couponCode."' AND '$curDate' BETWEEN coupon_from AND coupon_to AND blocked='0'";

    1373. 

  1373.         $q1=mysql_query($qry);

    1374. 

  1374.         if(mysql_num_rows($q1)>0) {

    1375. 

  1375.             $rw=mysql_fetch_assoc($q1);

    1376. 

  1376.             $couponValue=$rw['coupon_value'];

    1377. 

  1377.         }

    1378. 

  1378. 

    1379. 

  1379.         //payment details

    1380. 

  1380.         $fetchAdminPaymentSetup=$this->getPaymentMethods(1);	// that means payment will go to the admin paymenbt id

    1381. 

  1381.         $this->set("paymentMethods",$fetchAdminPaymentSetup);

    1382. 

  1382. 

    1383. 

  1383.         $this->set("couponValue",$couponValue);

    1384. 

  1384.         $this->set("saleTax",$saleTax);

    1385. 

  1385.         

    1386. 

  1386.         $this->set("totalAmount",$totalAmount);

    1387. 

  1387.         $this->render("feature_chargecouponcode","ajax");

    1388. 

  1388.     }

    1389. 

  1389. 

    1390. 

  1390.     function getcheckoutcity() {

    1391. 

  1391.         $this->checkSession();

    1392. 

  1392.         $usrDetail=$this->getUserDetails($_SESSION['UserId']);

    1393. 

  1393.         $this->set("UserDtl",$usrDetail);

    1394. 

  1394. 

    1395. 

  1395.         //$this->set("arg",$this->params['url']);

    1396. 

  1396.         $city=$this->getCityList($this->params['url']['orderBy']);

    1397. 

  1397.         $this->set("billingCity",$city);

    1398. 

  1398.         $this->set("divType",$this->params['url']['s']);

    1399. 

  1399. 

    1400. 

  1400.         $this->getCartDetails();

    1401. 

  1401. 

    1402. 

  1402.         //sale tax

    1403. 

  1403.         $stateId=0;

    1404. 

  1404.         $saleTax=0;

    1405. 

  1405.         if(isset($this->params['url']['orderBy']))

    1406. 

  1406.             $stateId=$this->params['url']['orderBy'];

    1407. 

  1407. 

    1408. 

  1408.         if(isset($this->params['pass']['0']))

    1409. 

  1409.             $stateId=$this->params['pass']['0'];

    1410. 

  1410. 

    1411. 

  1411.         $saleTax=$this->getUserCreativeSalesTax($stateId);

    1412. 

  1412.         $this->set("saleTax",$saleTax);

    1413. 

  1413.         $this->set("stateId",$stateId);

    1414. 

  1414.         //Coupon code

    1415. 

  1415.         $couponCode=$this->params['pass']['1'];

    1416. 

  1416.         $this->set("coupon",$couponCode);

    1417. 

  1417. 

    1418. 

  1418.         $curDate=date("Y-m-d");

    1419. 

  1419.         $couponValue=0;

    1420. 

  1420.         $qry="SELECT coupon_value FROM creative_coupon

    1421. 

  1421. 				WHERE coupon_code='".$couponCode."' AND '$curDate' BETWEEN coupon_from AND coupon_to AND blocked='0'";

    1422. 

  1422.         $q1=mysql_query($qry);

    1423. 

  1423.         if(mysql_num_rows($q1)>0) {

    1424. 

  1424.             $rw=mysql_fetch_assoc($q1);

    1425. 

  1425.             $couponValue=$rw['coupon_value'];

    1426. 

  1426.         }

    1427. 

  1427. 

    1428. 

  1428. 

    1429. 

  1429.         //payment details

    1430. 

  1430.         $fetchAdminPaymentSetup=$this->getPaymentMethods(1);	// that means payment will go to the admin paymenbt id

    1431. 

  1431.         $this->set("paymentMethods",$fetchAdminPaymentSetup);

    1432. 

  1432. 

    1433. 

  1433.         $this->set("couponValue",$couponValue);

    1434. 

  1434.         $this->set("saleTax",$saleTax);

    1435. 

  1435. 

    1436. 

  1436.         $this->render("checkoutcitylist","ajax");

    1437. 

  1437. 

    1438. 

  1438.     }

    1439. 

  1439. 

    1440. 

  1440.     function getcheckoutstate() {

    1441. 

  1441.         $this->checkSession();

    1442. 

  1442.         $usrDetail=$this->getUserDetails($_SESSION['UserId']);

    1443. 

  1443.         $this->set("UserDtl",$usrDetail);

    1444. 

  1444. 

    1445. 

  1445.         //$this->set("arg",$this->params['url']);

    1446. 

  1446.         $state=$this->getStateList($this->params['url']['orderBy']);

    1447. 

  1447.         $this->set("stateBList",$state);

    1448. 

  1448.         $this->set("divType",$this->params['url']['c']);

    1449. 

  1449. 

    1450. 

  1450.         $this->render("checkoutstatelist","ajax");

    1451. 

  1451. 

    1452. 

  1452.     }

    1453. 

  1453. 

    1454. 

  1454.     function getUserDetails($user_id=null) {

    1455. 

  1455.         if($user_id==null)

    1456. 

  1456.             $user_id = $_SESSION['UserId'];

    1457. 

  1457.         $coutryList=array();

    1458. 

  1458.         $countryList['0']="Select a country";

    1459. 

  1459.         $qry = mysql_query("SELECT * FROM countries");

    1460. 

  1460.         while($country = mysql_fetch_array($qry)) {

    1461. 

  1461.             $countryList[$country['id']]=$country['country_name'];

    1462. 

  1462.         }

    1463. 

  1463. 

    1464. 

  1464.         $qry2=mysql_query("SELECT * FROM user_details WHERE user_id=".$user_id);

    1465. 

  1465.         $rowQry=mysql_fetch_assoc($qry2);

    1466. 

  1466.         $this->set("UserDtl",$rowQry);

    1467. 

  1467. 

    1468. 

  1468.         $saleTax=$this->getUserCreativeSalesTax($rowQry['state']);

    1469. 

  1469.         $this->set("saleTax",$saleTax);

    1470. 

  1470. 

    1471. 

  1471.         $countryList=$this->getCountryList();

    1472. 

  1472.         $bList=$this->getStateList($rowQry['c_id']);

    1473. 

  1473.         $SList=$this->getStateList($rowQry['shipc_id']);

    1474. 

  1474.         $billingCity=$this->getCityList($rowQry['state']);

    1475. 

  1475. 

    1476. 

  1476.         $this->set("billingCity",$billingCity);

    1477. 

  1477.         $this->set("stateBList",$bList);

    1478. 

  1478.         $this->set("stateSList",$SList);

    1479. 

  1479.         $this->set("countryList",$countryList);

    1480. 

  1480. 

    1481. 

  1481.         return $rowQry;

    1482. 

  1482.     }

    1483. 

  1483. 

    1484. 

  1484.     function getCreativeState($conId) {

    1485. 

  1485.         $stateSList=array("0"=>"Select State");

    1486. 

  1486.         $qry3 = mysql_query("SELECT * FROM state WHERE c_id='".$conId."'");

    1487. 

  1487.         while($state = mysql_fetch_array($qry3)) {

    1488. 

  1488.             $stateSList[$state['id']]=$state['Name'];

    1489. 

  1489.         }

    1490. 

  1490. 

    1491. 

  1491.         $this->set("stateBList",$stateSList);

    1492. 

  1492.     }

    1493. 

  1493. 

    1494. 

  1494.     function getstate() {

    1495. 

  1495.         $this->getCreativeState($this->params['url']['orderBy']);

    1496. 

  1496.         $this->render("creativestate","ajax");

    1497. 

  1497.     }

    1498. 

  1498. 

    1499. 

  1499.     function creative_cart() {

    1500. 

  1500.         $this->checkSession();

    1501. 

  1501.         $this->pageTitle = 'ScrapFOTO&trade; - My Cart';

    1502. 

  1502.         $this->layout = 'creativehome';

    1503. 

  1503.         $this->creativeType();

    1504. 

  1504.         $this->getPublicScrap();

    1505. 

  1505.         $cartCount=$this->countFavCart();

    1506. 

  1506.         if($cartCount<=0) {

    1507. 

  1507.             $this->redirect("/creativezones/creative_favorite");

    1508. 

  1508.             die();

    1509. 

  1509.         }

    1510. 

  1510. 

    1511. 

  1511.         $tmpImg=0;

    1512. 

  1512.         if(isset($_SESSION['buyTemplate']['tmpId']))

    1513. 

  1513.             $tmpImg= $this->templateDetail($_SESSION['buyTemplate']['tmpId']);

    1514. 

  1514. 

    1515. 

  1515. 

    1516. 

  1516.         //Initializing all the bradcamp back again so that it all starts all over again

    1517. 

  1517.         $this->set("filename","creative_cart");	//filename should contain the name of the file that should be selected

    1518. 

  1518.         $this->set("nextpage","checkout");

    1519. 

  1519. 

    1520. 

  1520.         //_________________________________________________________________________________________________

    1521. 

  1521. 

    1522. 

  1522.         $this->set("recenttype","creative_favorite");

    1523. 

  1523. 

    1524. 

  1524.         $this->getCartDetails();

    1525. 

  1525.         $this->getUserDetails();

    1526. 

  1526. 

    1527. 

  1527. 

    1528. 

  1528.         //$this->getUserCreativeSalesTax($_SESSION['UserId']);

    1529. 

  1529. 

    1530. 

  1530.         ############################################## CART CODE #################################

    1531. 

  1531. 

    1532. 

  1532.         if(isset($this->params['url']['act']) && $this->params['url']['act']=="update") {

    1533. 

  1533.             $cartsql2 ="

    1534. 

  1534. 						SELECT SUM(CM.price*CM.qty) as totValue

    1535. 

  1535. 						FROM creative_carts CM,creative_cart_details CD

    1536. 

  1536. 						WHERE CM.id=CD.creative_cart_id AND CM.pay_status='0' AND CM.user_id='".$_SESSION['UserId']."' AND CM.ssn_id='".session_id()."'";

    1537. 

  1537. 

    1538. 

  1538.             $rec=mysql_query($cartsql2);

    1539. 

  1539.             $resultSet=mysql_fetch_assoc($rec);

    1540. 

  1540.             $this->set("totalValue",$resultSet['totValue']);

    1541. 

  1541. 

    1542. 

  1542. 

    1543. 

  1543.             $this->set("arg",$this->params['url']);

    1544. 

  1544.             $this->render("mycart2","ajax");

    1545. 

  1545.         }

    1546. 

  1546. 

    1547. 

  1547.         if(isset($this->params['url']['act']) && $this->params['url']['act']=="saveupdate") {

    1548. 

  1548.             $cartId=$this->params['url']['cid'];

    1549. 

  1549.             $i=$this->params['url']['i'];

    1550. 

  1550.             //mysql_query("UPDATE backdrop_cart SET quantity='".$this->data['Backdrop']['qty'.$i]."' WHERE id='".$cartId."'");

    1551. 

  1551.             $cartsql2 ="

    1552. 

  1552. 					SELECT SUM(CM.price*CM.qty) as totValue

    1553. 

  1553. 					FROM creative_carts CM,creative_cart_details CD

    1554. 

  1554. 					WHERE CM.id=CD.creative_cart_id AND CM.pay_status='0' AND CM.user_id='".$_SESSION['UserId']."' AND CM.ssn_id='".session_id()."'";

    1555. 

  1555. 

    1556. 

  1556.             $rec=mysql_query($cartsql2);

    1557. 

  1557.             $resultSet=mysql_fetch_assoc($rec);

    1558. 

  1558.             $this->set("totalValue",$resultSet['totValue']);

    1559. 

  1559. 

    1560. 

  1560.             $this->set("qty",$this->data['Creativezone']['qty'.$i]);

    1561. 

  1561.             $this->set("arg",$this->params['url']);

    1562. 

  1562.             $this->set("argForm",$this->params['form']);

    1563. 

  1563.             $this->render("mycart2","ajax");

    1564. 

  1564.         }

    1565. 

  1565. 

    1566. 

  1566.         if(isset($this->params['url']['action']) && $this->params['url']['action']=="deleteCartitem") {

    1567. 

  1567. 

    1568. 

  1568.             if(isset($this->params['url']['cartid'])) {

    1569. 

  1569.                 $cartId=base64_decode($this->params['url']['cartid']);

    1570. 

  1570.                 $delCartItem = "DELETE from creative_carts where id='".$cartId."' AND ssn_id='".session_id()."' AND pay_status='0' AND user_id='".$_SESSION['UserId']."'";

    1571. 

  1571.                 mysql_query($delCartItem);

    1572. 

  1572.             }

    1573. 

  1573.             else {

    1574. 

  1574.                 if(isset($this->params['url']['cartuserid'])) {

    1575. 

  1575.                     $cartBlockuser=base64_decode($this->params['url']['cartuserid']);

    1576. 

  1576.                     $delCartItem = "DELETE FROM creative_carts WHERE ssn_id='".session_id()."' AND pay_status='0' AND user_id='".$_SESSION['UserId']."' AND product_name IN (SELECT title FROM creative_favorites WHERE user_id='".$cartBlockuser."' AND is_temp='0' AND is_blocked='0')";

    1577. 

  1577.                     mysql_query($delCartItem) or die("Error on line - ".__LINE__.mysql_error());

    1578. 

  1578.                 }

    1579. 

  1579.             }

    1580. 

  1580. 

    1581. 

  1581.         }

    1582. 

  1582. 

    1583. 

  1583.         if(isset($this->params['url']['action']) && $this->params['url']['action']=="deleteCartitem") {

    1584. 

  1584.             $this->render("myupdatedcart","ajax");

    1585. 

  1585.         }

    1586. 

  1586. 

    1587. 

  1587.         ###########################################

    1588. 

  1588.         //check if buy template then get payment of user create artist

    1589. 

  1589.         if($tmpImg>0) {

    1590. 

  1590.             $fav = $this->Creative_favorites->findById($tmpImg);

    1591. 

  1591.             $fetchAdminPaymentSetup=$this->getPaymentMethodsUsers($fav['Creative_favorites']['user_id']);	// that means payment will go to the user paymenbt id

    1592. 

  1592.             $this->set('sellerId',$fav['Creative_favorites']['user_id']);

    1593. 

  1593.         }else {

    1594. 

  1594.             $fetchAdminPaymentSetup=$this->getPaymentMethods(1);	// that means payment will go to the admin paymenbt id

    1595. 

  1595.             $this->set('sellerId',1);

    1596. 

  1596.         }

    1597. 

  1597.         $this->set("paymentMethods",$fetchAdminPaymentSetup);

    1598. 

  1598. 

    1599. 

  1599.     }

    1600. 

  1600. 

    1601. 

  1601.     function pcreative_cart() {

    1602. 

  1602.         $this->checkSession();

    1603. 

  1603.         $this->pageTitle = 'Creative - My Cart';

    1604. 

  1604.         $this->layout = 'creativedetail';

    1605. 

  1605.         $this->creativeType();

    1606. 

  1606.         $this->getPublicScrap();

    1607. 

  1607. 

    1608. 

  1608.         //This ct variable comes from INDEX page and CREATIVETEMPLATE page

    1609. 

  1609.         $id=0;

    1610. 

  1610.         if(isset($this->params['url']['ct']))

    1611. 

  1611.             $id=base64_decode($this->params['url']['ct']);

    1612. 

  1612. 

    1613. 

  1613.         //This ct variable comes from CREATIVETEMPLATE page

    1614. 

  1614.         $tmpImg=0;

    1615. 

  1615.         if(isset($this->params['url']['tmp']))

    1616. 

  1616.             $tmpImg=base64_decode($this->params['url']['tmp']);

    1617. 

  1617. 

    1618. 

  1618.         $this->set("cType",$id);

    1619. 

  1619.         $this->set("cTemplate",$tmpImg);

    1620. 

  1620. 

    1621. 

  1621.         $this->countFavCart();

    1622. 

  1622. 

    1623. 

  1623.         //Initializing all the bradcamp back again so that it all starts all over again

    1624. 

  1624.         $this->set("filename","creative_cart");							//filename should contain the name of the file that should be selected

    1625. 

  1625.         $_SESSION['bradcamp_creative'][80]=$this->params['action'];			//we are passing the name of the file to keep track which step is visited

    1626. 

  1626.         $this->set("nextpage","checkout");

    1627. 

  1627. 

    1628. 

  1628.         //_________________________________________________________________________________________________

    1629. 

  1629. 

    1630. 

  1630.         $this->set("recenttype","creative_favorite");

    1631. 

  1631. 

    1632. 

  1632.         $this->getCartDetails();

    1633. 

  1633. 

    1634. 

  1634. 

    1635. 

  1635.         ############################################## CART CODE #################################

    1636. 

  1636.         $queryCreativeCarts=mysql_query("

    1637. 

  1637. 				SELECT CM.id,CM.product_name,CM.price,CM.qty,CD.imagename,(CM.price*CM.qty) as subTotal

    1638. 

  1638. 				FROM creative_carts CM,creative_cart_details CD

    1639. 

  1639. 				WHERE CM.id=CD.creative_cart_id AND CM.pay_status='0' AND CM.user_id='".$_SESSION['UserId']."' AND CM.ssn_id='".session_id()."'

    1640. 

  1640. 				GROUP BY CM.id");

    1641. 

  1641. 

    1642. 

  1642. 

    1643. 

  1643.         if(isset($this->params['url']['act']) && $this->params['url']['act']=="update") {

    1644. 

  1644.             $cartsql2 ="

    1645. 

  1645. 					SELECT SUM(CM.price*CM.qty) as totValue

    1646. 

  1646. 					FROM creative_carts CM,creative_cart_details CD

    1647. 

  1647. 					WHERE CM.id=CD.creative_cart_id AND CM.pay_status='0' AND CM.user_id='".$_SESSION['UserId']."' AND CM.ssn_id='".session_id()."'";

    1648. 

  1648. 

    1649. 

  1649.             $rec=mysql_query($cartsql2);

    1650. 

  1650.             $resultSet=mysql_fetch_assoc($rec);

    1651. 

  1651.             $this->set("totalValue",$resultSet['totValue']);

    1652. 

  1652. 

    1653. 

  1653. 

    1654. 

  1654.             $this->set("arg",$this->params['url']);

    1655. 

  1655.             $this->render("mycart2","ajax");

    1656. 

  1656.         }

    1657. 

  1657. 

    1658. 

  1658.         if(isset($this->params['url']['act']) && $this->params['url']['act']=="saveupdate") {

    1659. 

  1659.             $cartId=$this->params['url']['cid'];

    1660. 

  1660.             $i=$this->params['url']['i'];

    1661. 

  1661.             //mysql_query("UPDATE backdrop_cart SET quantity='".$this->data['Backdrop']['qty'.$i]."' WHERE id='".$cartId."'");

    1662. 

  1662.             $cartsql2 ="

    1663. 

  1663. 					SELECT SUM(CM.price*CM.qty) as totValue

    1664. 

  1664. 					FROM creative_carts CM,creative_cart_details CD

    1665. 

  1665. 					WHERE CM.id=CD.creative_cart_id AND CM.pay_status='0' AND CM.user_id='".$_SESSION['UserId']."' AND CM.ssn_id='".session_id()."'";

    1666. 

  1666. 

    1667. 

  1667.             $rec=mysql_query($cartsql2);

    1668. 

  1668.             $resultSet=mysql_fetch_assoc($rec);

    1669. 

  1669.             $this->set("totalValue",$resultSet['totValue']);

    1670. 

  1670. 

    1671. 

  1671.             $this->set("qty",$this->data['Creativezone']['qty'.$i]);

    1672. 

  1672.             $this->set("arg",$this->params['url']);

    1673. 

  1673.             $this->set("argForm",$this->params['form']);

    1674. 

  1674.             $this->render("mycart2","ajax");

    1675. 

  1675.         }

    1676. 

  1676. 

    1677. 

  1677.         if(isset($this->params['url']['action']) && $this->params['url']['action']=="deleteCartitem") {

    1678. 

  1678. 

    1679. 

  1679.             if(isset($this->params['url']['cartid'])) {

    1680. 

  1680.                 $cartId=base64_decode($this->params['url']['cartid']);

    1681. 

  1681.                 $delCartItem = "DELETE from creative_carts where id='".$cartId."' AND ssn_id='".session_id()."' AND pay_status='0' AND user_id='".$_SESSION['UserId']."'";

    1682. 

  1682.                 mysql_query($delCartItem);

    1683. 

  1683.             }

    1684. 

  1684.             else {

    1685. 

  1685.                 if(isset($this->params['url']['cartuserid'])) {

    1686. 

  1686.                     $cartBlockuser=base64_decode($this->params['url']['cartuserid']);

    1687. 

  1687.                     $delCartItem = "DELETE FROM creative_carts WHERE ssn_id='".session_id()."' AND pay_status='0' AND user_id='".$_SESSION['UserId']."' AND product_name IN (SELECT title FROM creative_favorites WHERE user_id='".$cartBlockuser."' AND is_temp='0' AND is_blocked='0')";

    1688. 

  1688.                     mysql_query($delCartItem) or die("Error on line - ".__LINE__.mysql_error());

    1689. 

  1689.                 }

    1690. 

  1690.             }

    1691. 

  1691. 

    1692. 

  1692.         }

    1693. 

  1693. 

    1694. 

  1694.         if(isset($_SESSION['UserId'])) {

    1695. 

  1695. 

    1696. 

  1696.             $cartsql = "

    1697. 

  1697. 							SELECT CM.id,Cfav.id as favid,CM.product_name,Creativedetail.imagename,

    1698. 

  1698. 							CM.qty,CM.price ,(CM.price*CM.qty) as subtotal  

    1699. 

  1699. 							from creative_carts CM 

    1700. 

  1700. 							LEFT JOIN creative_cart_details Creativedetail ON CM.id =Creativedetail.creative_cart_id

    1701. 

  1701. 							LEFT JOIN creative_favorites Cfav ON CM.product_name = Cfav.title

    1702. 

  1702. 							LEFT JOIN creative_template_pages ctemppage ON Cfav.id=ctemppage.id

    1703. 

  1703. 							where 

    1704. 

  1704. 							CM.user_id='".$_SESSION['UserId']."' AND CM.ssn_id='".session_id()."'and CM.pay_status='0'   ";

    1705. 

  1705. 

    1706. 

  1706. 

    1707. 

  1707. 

    1708. 

  1708.             $this->set('mycartsql',$cartsql);

    1709. 

  1709. 

    1710. 

  1710. 

    1711. 

  1711.             $newcartsql ="

    1712. 

  1712. 				SELECT ifnull( Buser.username, 'NA') AS username,

    1713. 

  1713. 				Cfav.id , Cfav.user_id,

    1714. 

  1714. 				COUNT( Cfav.title) as creative_count

    1715. 

  1715. 				FROM creative_carts Creativecart

    1716. 

  1716. 				LEFT JOIN creative_favorites Cfav ON Creativecart.product_name = Cfav.title

    1717. 

  1717. 				

    1718. 

  1718. 				LEFT JOIN users Buser ON ( Cfav.user_id = Buser.id )

    1719. 

  1719. 				

    1720. 

  1720. 				WHERE Creativecart.user_id = '".$_SESSION['UserId']."'

    1721. 

  1721. 				AND Creativecart.ssn_id = '".session_id()."'

    1722. 

  1722. 				AND Creativecart.pay_status = '0'

    1723. 

  1723. 				GROUP BY Cfav.user_id

    1724. 

  1724. 				";

    1725. 

  1725. 

    1726. 

  1726. 

    1727. 

  1727.             $this->set('newmycartsql',$newcartsql);

    1728. 

  1728. 

    1729. 

  1729.         }

    1730. 

  1730. 

    1731. 

  1731.         if(isset($this->params['url']['action']) && $this->params['url']['action']=="deleteCartitem") {

    1732. 

  1732.             $this->render("myupdatedcart","ajax");

    1733. 

  1733.         }

    1734. 

  1734. 

    1735. 

  1735. 

    1736. 

  1736. 

    1737. 

  1737.         ###########################################

    1738. 

  1738. 

    1739. 

  1739.         $fetchAdminPaymentSetup=$this->getPaymentMethods(1);	// that means payment will go to the admin paymenbt id

    1740. 

  1740.         $this->set("paymentMethods",$fetchAdminPaymentSetup);

    1741. 

  1741. 

    1742. 

  1742.     }

    1743. 

  1743.     //checking

    1744. 

  1744.     function getCartImages($userId,$tranId,$isThumb=false) {

    1745. 

  1745. 

    1746. 

  1746.         $downloadimg=array();

    1747. 

  1747.         $getYearBookImg=mysql_query("

    1748. 

  1748. 					SELECT CF.fileZip, CF.fileThumb2

    1749. 

  1749. 					FROM creative_carts C,creative_cart_details CD, creative_favorites as CF

    1750. 

  1750. 					WHERE C.id=CD.creative_cart_id AND CF.id=CD.creative_favorite_id AND C.user_id='".$userId."' AND C.pay_status='1' AND transaction_creative_id='".$tranId."'

    1751. 

  1751. 					") or die(mysql_error());

    1752. 

  1752. 

    1753. 

  1753.         while($rwYearbookImg=mysql_fetch_assoc($getYearBookImg)) {

    1754. 

  1754.             if($isThumb)

    1755. 

  1755.                 array_push($downloadimg,$rwYearbookImg['fileThumb2']);

    1756. 

  1756.             else

    1757. 

  1757.                 array_push($downloadimg,$rwYearbookImg['fileZip']);

    1758. 

  1758.         }

    1759. 

  1759. 

    1760. 

  1760.         return $downloadimg;

    1761. 

  1761. 

    1762. 

  1762.     }

    1763. 

  1763.     //checking

    1764. 

  1764.     function checkout() {

    1765. 

  1765.         $this->checkSession();

    1766. 

  1766.         $this->countFavCart();

    1767. 

  1767.         $this->layout = 'previewpaymemnt';

    1768. 

  1768.         $this->render("paymentback");

    1769. 

  1769.         $totalAmount=$this->data['creative']['totalAmount'];

    1770. 

  1770.         $sellerId=$this->data['creative']['sellerId'];

    1771. 

  1771.         //$rdPage refers to function success

    1772. 

  1772.         $rdPage=$this->data['creative']['rdpage'];

    1773. 

  1773. 

    1774. 

  1774.         $isAdmin=1;

    1775. 

  1775.         //If user purchases his own scraps then the payment will go to admin

    1776. 

  1776.         //If the user purchases scraps of other users then the payment will go to that other users

    1777. 

  1777.         if($sellerId==1) {

    1778. 

  1778.             $fetchAdminPaymentSetup=$this->getPaymentMethods(1);	// that means payment will go to the admin paymenbt id

    1779. 

  1779.         }

    1780. 

  1780.         else {

    1781. 

  1781.             $isAdmin=0;

    1782. 

  1782.             $fetchAdminPaymentSetup=$this->getPaymentMethodsUsers($sellerId);

    1783. 

  1783.         }

    1784. 

  1784. 

    1785. 

  1785.         //UPDATE USERS ADDRESS

    1786. 

  1786.         if(!empty($this->data)) {

    1787. 

  1787.             if(isset($this->data['creativezones']['B']) && ($this->data['creativezones']['B'])!="") {

    1788. 

  1788. 

    1789. 

  1789.                 $updateUser="

    1790. 

  1790. 								UPDATE user_details

    1791. 

  1791. 								SET

    1792. 

  1792. 								address='".$this->data['creativezones']['Baddress']."',city='".$this->data['creativezones']['Bcity']."',

    1793. 

  1793. 								zip='".$this->data['creativezones']['Bzip']."',c_id='".$this->params['form']['creativezonesBcountry']."'

    1794. 

  1794. 								,state='".$this->params['form']['creativezonesBstate']."'

    1795. 

  1795. 								WHERE user_id=".$_SESSION['UserId'];

    1796. 

  1796.                 mysql_query($updateUser);

    1797. 

  1797.             }

    1798. 

  1798.         }

    1799. 

  1799. 

    1800. 

  1800.         $feature = isset($this->data['creativezones']['feature']);

    1801. 

  1801. 

    1802. 

  1802.         if($feature) {

    1803. 

  1803.             //create creative_carts

    1804. 

  1804.             mysql_query("DELETE FROM creative_carts WHERE pay_status='0' AND user_id='".$_SESSION['UserId']."'");

    1805. 

  1805.             mysql_query("INSERT INTO

    1806. 

  1806.                                     creative_carts(user_id,cart_name,transaction_creative_id,pay_status)

    1807. 

  1807.                                     VALUES('".$_SESSION['UserId']."','Feature fee','0','0')") or die("Error on line : ".__LINE__.mysql_error());

    1808. 

  1808. 

    1809. 

  1809.             $cart_id=mysql_insert_id();

    1810. 

  1810.             $productId = $this->data['creativezones']['lastId'];

    1811. 

  1811. 

    1812. 

  1812.             $featuredAmount=$this->getConfigAmount('creative featured');

    1813. 

  1813.             $price = $featuredAmount['config_value'];

    1814. 

  1814. 

    1815. 

  1815.             mysql_query("INSERT INTO creative_cart_details SET creative_cart_id='$cart_id' ,creative_favorite_id='$productId', product_name='Feature fee',price='$price',qty='1'");

    1816. 

  1816.         }

    1817. 

  1817. 

    1818. 

  1818.         $transactionfee = isset($this->data['creativezones']['transactionfee']);

    1819. 

  1819.         if(!$transactionfee) {

    1820. 

  1820.             //insert data to the TRANSACTION_CREATIVES TABLE after successful transaction

    1821. 

  1821.             mysql_query("INSERT INTO

    1822. 

  1822.                                         transaction_creatives(user_id,seller_id,total_amount,is_admin)

    1823. 

  1823.                                         VALUES('".$_SESSION['UserId']."','".$sellerId."','".$totalAmount."','".$isAdmin."')") or die("Error on line : ".__LINE__.mysql_error());

    1824. 

  1824. 

    1825. 

  1825.             $lastTransactionId=mysql_insert_id();

    1826. 

  1826. 

    1827. 

  1827.             //UPDATE CART

    1828. 

  1828.             mysql_query("

    1829. 

  1829.                                         UPDATE creative_carts

    1830. 

  1830.                                         SET

    1831. 

  1831.                                         coupon='".$this->data['creativezones']['couponprice']."',

    1832. 

  1832.                                         saletax='".$this->data['creativezones']['saletax']."',

    1833. 

  1833.                                         transaction_creative_id='".$lastTransactionId."'

    1834. 

  1834.                                         WHERE pay_status='0' AND user_id='".$_SESSION['UserId']."'");

    1835. 

  1835. 

    1836. 

  1836.             $invoice = $this->createTransactionNumber('SP');

    1837. 

  1837.             $ticket = $this->createTransactionNumber('SPTT');

    1838. 

  1838.         }else {

    1839. 

  1839.             $invoice = $this->data['creativezones']['lastId'];

    1840. 

  1840.         }

    1841. 

  1841. 

    1842. 

  1842.         $zero =str_repeat('0',(5-strlen($_SESSION['UserId'])));

    1843. 

  1843.         $userId=$zero.$_SESSION['UserId'];

    1844. 

  1844. 

    1845. 

  1845. 

    1846. 

  1846. 

    1847. 

  1847.         if(isset($this->data['Event']['radiobutton'])) {

    1848. 

  1848.             if($this->data['Event']['radiobutton']=="paypal") {

    1849. 

  1849.                 $this->invoice=$invoice;

    1850. 

  1850.                 $this->amountPay=$totalAmount;

    1851. 

  1851.                 $this->merchantEmail=$fetchAdminPaymentSetup['paypal_email'];

    1852. 

  1852. 

    1853. 

  1853.                 if($transactionfee) {

    1854. 

  1854.                     $this->invoice='TF'.$invoice;

    1855. 

  1855.                     $this->itemName="ScrapFOTO&trade; Transaction Fee";

    1856. 

  1856.                     $this->returnUrl=FULL_BASE_URL.$this->webroot."creativezones/transactionfee_success";

    1857. 

  1857.                     $this->notifyUrl=FULL_BASE_URL.$this->webroot."creativezones/transactionfee_payment_notify";

    1858. 

  1858.                     $this->custom=$_SESSION['UserId']."^".$sellerId."^".$isAdmin."^".$rdPage."^".$invoice;

    1859. 

  1859.                 }else if($feature) {

    1860. 

  1860.                     $this->itemName="ScrapFOTO&trade; Featured";

    1861. 

  1861.                     $this->returnUrl=FULL_BASE_URL.$this->webroot."creativezones/featuredsuccess";

    1862. 

  1862.                     $this->notifyUrl=FULL_BASE_URL.$this->webroot."creativezones/featured_payment_notify";

    1863. 

  1863.                     $this->custom=$_SESSION['UserId']."^".$sellerId."^".$isAdmin."^".$rdPage."^".$invoice."^".$lastTransactionId."^".$ticket."^".$productId;

    1864. 

  1864.                 }else {

    1865. 

  1865.                     $this->itemName="ScrapFOTO&trade; Image download";

    1866. 

  1866.                     $this->returnUrl=FULL_BASE_URL.$this->webroot."creativezones/".$rdPage."?tr=".base64_encode($lastTransactionId);//DOMAIN

    1867. 

  1867.                     $this->notifyUrl=FULL_BASE_URL.$this->webroot."creativezones/checkout_notify";

    1868. 

  1868.                     $this->custom=$_SESSION['UserId']."^".$sellerId."^".$isAdmin."^".$rdPage."^".$invoice."^".$lastTransactionId;

    1869. 

  1869.                 }

    1870. 

  1870. 

    1871. 

  1871.                 $this->paypal();

    1872. 

  1872.             }

    1873. 

  1873. 

    1874. 

  1874.             if($this->data['Event']['radiobutton']=="google") {

    1875. 

  1875. 

    1876. 

  1876.                 $adminPayment=$fetchAdminPaymentSetup['gcheckout_email'];

    1877. 

  1877.                 $adminPaymentDetails=explode("break",$adminPayment);

    1878. 

  1878.                 $this->Gcheckout->gMerchantId=$adminPaymentDetails['0'];

    1879. 

  1879.                 $this->Gcheckout->gMerchantKey=$adminPaymentDetails['1'];

    1880. 

  1880.                 $this->Gcheckout->gQuantity=1;

    1881. 

  1881.                 $this->Gcheckout->gPrice=$totalAmount;

    1882. 

  1882.                 if($feature) {

    1883. 

  1883.                     $this->Gcheckout->gItemName="ScrapFOTO&trade; Featured";

    1884. 

  1884.                     $this->Gcheckout->gItemDesc="ScrapFOTO&trade; Featured";

    1885. 

  1885.                     $this->Gcheckout->gReturnUrl=FULL_BASE_URL.$this->webroot."creativezones/featuredsuccess";

    1886. 

  1886.                     $this->Gcheckout->gNotifyUrl=FULL_BASE_URL.$this->webroot."creativezones/featured_payment_notify";

    1887. 

  1887.                     $this->Gcheckout->customData=$_SESSION['UserId']."^".$sellerId."^".$isAdmin."^".$rdPage."^".$invoice."^".$lastTransactionId."^".$totalAmount."^".$ticket."^".$productId;

    1888. 

  1888.                 }else if($transactionfee) {

    1889. 

  1889.                     $this->Gcheckout->gItemName="ScrapFOTO&trade; Transaction Fee";

    1890. 

  1890.                     $this->Gcheckout->gItemDesc="ScrapFOTO&trade; Transaction Fee";

    1891. 

  1891.                     $this->Gcheckout->gReturnUrl=FULL_BASE_URL.$this->webroot."creativezones/transactionfee_success";

    1892. 

  1892.                     $this->Gcheckout->gNotifyUrl=FULL_BASE_URL.$this->webroot."creativezones/transactionfee_payment_notify";

    1893. 

  1893.                     $this->Gcheckout->customData=$_SESSION['UserId']."^".$sellerId."^".$isAdmin."^".$rdPage."^".$invoice."^".$totalAmount;

    1894. 

  1894.                 }

    1895. 

  1895.                 else {

    1896. 

  1896.                     $this->Gcheckout->gItemName="ScrapFOTO&trade; Image download";

    1897. 

  1897.                     $this->Gcheckout->gItemDesc="ScrapFOTO&trade; Image download";

    1898. 

  1898.                     $this->Gcheckout->gReturnUrl=FULL_BASE_URL.$this->webroot."creativezones/".$rdPage."?tr=".base64_encode($lastTransactionId);

    1899. 

  1899.                     $this->Gcheckout->gNotifyUrl=FULL_BASE_URL.$this->webroot."creativezones/checkout_notify";

    1900. 

  1900.                     $this->Gcheckout->customData=$_SESSION['UserId']."^".$sellerId."^".$isAdmin."^".$rdPage."^".$invoice."^".$lastTransactionId."^".$totalAmount;

    1901. 

  1901.                 }

    1902. 

  1902. 

    1903. 

  1903.                 $this->Gcheckout->google();

    1904. 

  1904.             }

    1905. 

  1905.         }

    1906. 

  1906. 

    1907. 

  1907.     }

    1908. 

  1908.     //checking

    1909. 

  1909.     function checkout_notify() {

    1910. 

  1910. 

    1911. 

  1911.         /*

    1912. 

  1912.         $this->Paypal->paypal_class();

    1913. 

  1913.         $this->Paypal->paypal_url = $this->paypalUrl;

    1914. 

  1914.         $paypal=0;

    1915. 

  1915.         //____________________________________________________IPN DATA SECTION______________________________________________

    1916. 

  1916. 

    1917. 

  1917.         //This section is used to catch from PAYPAL IPN data

    1918. 

  1918.         if ($this->Paypal->validate_ipn()) {

    1919. 

  1919.             $paypal=1;

    1920. 

  1920.             if(isset($this->Paypal->ipn_data['payment_gross']) && ($this->Paypal->ipn_data['payment_gross'])!="") {

    1921. 

  1921.                 $totalPay=$this->Paypal->ipn_data['payment_gross'];

    1922. 

  1922.                 $custom=explode("^",$this->Paypal->ipn_data['custom']);

    1923. 

  1923.                 $userId=$custom['0'];

    1924. 

  1924.                 $sellerId=$custom['1'];

    1925. 

  1925.                 $isAdmin=$custom['2'];

    1926. 

  1926.                 $rdPage=$custom['3'];

    1927. 

  1927.                 $ssnId=$custom['4'];

    1928. 

  1928.                 $transactionId=$custom['5'];

    1929. 

  1929.                 $invoice=$this->Paypal->ipn_data['invoice'];

    1930. 

  1930. 

    1931. 

  1931.             }

    1932. 

  1932.         }

    1933. 

  1933. 

    1934. 

  1934.         //This section is used to catch from GOOGLE IPN data

    1935. 

  1935.         if(!$paypal) {

    1936. 

  1936. 

    1937. 

  1937.         //this section is used to update from google IPN data

    1938. 

  1938.             $xml_response = isset($HTTP_RAW_POST_DATA)?$HTTP_RAW_POST_DATA:file_get_contents("php://input");

    1939. 

  1939.             if($xml_response) {

    1940. 

  1940.                 $gCustom=$this->parseXmlArray($xml_response);

    1941. 

  1941.                 $cData=$gCustom['http://checkout.google.com/schema/2']['SHOPPING-CART']['ITEMS']['ITEM']['MERCHANT-PRIVATE-ITEM-DATA'];

    1942. 

  1942.                 $ipnData=explode("^",$cData);

    1943. 

  1943. 

    1944. 

  1944.                 $userId=$ipnData['0'];

    1945. 

  1945.                 $sellerId=$ipnData['1'];

    1946. 

  1946.                 $isAdmin=$ipnData['2'];

    1947. 

  1947.                 $rdPage=$ipnData['3'];

    1948. 

  1948.                 $ssnId=$ipnData['4'];

    1949. 

  1949.                 $transactionId=$ipnData['5'];

    1950. 

  1950.                 $invoice=$ipnData['6'];

    1951. 

  1951.                 $totalPay=$ipnData['7'];

    1952. 

  1952.             }

    1953. 

  1953.         }

    1954. 

  1954. 

    1955. 

  1955.         

    1956. 

  1956.          * 

    1957. 

  1957.         */

    1958. 

  1958. 

    1959. 

  1959.     }

    1960. 

  1960.     //checking

    1961. 

  1961.     function success() {

    1962. 

  1962.         $this->checkSession();

    1963. 

  1963.         //

    1964. 

  1964.         $paypal=0;

    1965. 

  1965.         //____________________________________________________IPN DATA SECTION______________________________________________

    1966. 

  1966. 

    1967. 

  1967.         //This section is used to catch from PAYPAL IPN data

    1968. 

  1968.         if (isset($_POST['payment_gross']) && ($_POST['payment_gross'])!="") {

    1969. 

  1969.             $paypal=1;

    1970. 

  1970. 

    1971. 

  1971.             $totalPay=$_POST['payment_gross'];

    1972. 

  1972.             $custom=explode("^",$_POST['custom']);

    1973. 

  1973. 

    1974. 

  1974.             $userId=$custom['0'];

    1975. 

  1975.             $sellerId=$custom['1'];

    1976. 

  1976.             $isAdmin=$custom['2'];

    1977. 

  1977.             $rdPage=$custom['3'];

    1978. 

  1978.             $invoice=$custom['4'];

    1979. 

  1979.             $transactionId=$custom['5'];

    1980. 

  1980.         }

    1981. 

  1981. 

    1982. 

  1982.         //This section is used to catch from GOOGLE IPN data

    1983. 

  1983.         if(!$paypal) {

    1984. 

  1984. 

    1985. 

  1985.             //this section is used to update from google IPN data

    1986. 

  1986.             $xml_response = isset($HTTP_RAW_POST_DATA)?$HTTP_RAW_POST_DATA:file_get_contents("php://input");

    1987. 

  1987.             if($xml_response) {

    1988. 

  1988.                 $gCustom=$this->parseXmlArray($xml_response);

    1989. 

  1989.                 $cData=$gCustom['http://checkout.google.com/schema/2']['SHOPPING-CART']['ITEMS']['ITEM']['MERCHANT-PRIVATE-ITEM-DATA'];

    1990. 

  1990.                 $ipnData=explode("^",$cData);

    1991. 

  1991. 

    1992. 

  1992.                 $userId=$ipnData['0'];

    1993. 

  1993.                 $sellerId=$ipnData['1'];

    1994. 

  1994.                 $isAdmin=$ipnData['2'];

    1995. 

  1995.                 $rdPage=$ipnData['3'];

    1996. 

  1996.                 $invoice=$ipnData['4'];

    1997. 

  1997.                 $transactionId=$ipnData['5'];

    1998. 

  1998.                 $totalPay=$ipnData['6'];

    1999. 

  1999.             }

    2000. 

  2000.         }

    2001. 

  2001. 

    2002. 

  2002.         //____________________________________________________XOIMAGE DATABASE UPDATION_____________________________________

    2003. 

  2003. 

    2004. 

  2004.         //UPDATE date on TRANSACTION_CREATIVE TABLE

    2005. 

  2005.         $queryUpdateTransactionCreative="

    2006. 

  2006. 				UPDATE transaction_creatives

    2007. 

  2007. 				SET pay_status='1',invoice='".$invoice."'

    2008. 

  2008. 				WHERE id='".$transactionId."' AND user_id='".$userId."'";

    2009. 

  2009.         mysql_query($queryUpdateTransactionCreative) or die("Error on line : ".__LINE__.mysql_error());

    2010. 

  2010. 

    2011. 

  2011.         //UPDATE data to the CREATIVE_CARTS TABLE after successful transaction

    2012. 

  2012.         $queryUpdateCreativeCart="

    2013. 

  2013. 				UPDATE creative_carts

    2014. 

  2014. 				SET pay_status='1', total_price='".$totalPay."'

    2015. 

  2015. 				WHERE user_id='".$userId."' AND pay_status='0' AND transaction_creative_id='".$transactionId."' ";

    2016. 

  2016.         mysql_query($queryUpdateCreativeCart) or die("Error on line : ".__LINE__.mysql_error());

    2017. 

  2017. 

    2018. 

  2018. 

    2019. 

  2019. 

    2020. 

  2020.         //generating the downloadable file

    2021. 

  2021.         //Get the list of the downloaded images

    2022. 

  2022.         $downloadimg=$this->getCartImages($userId,$transactionId);

    2023. 

  2023.         $zipfilename = 'scrapblogimg'.$transactionId.$userId.'.zip';

    2024. 

  2024. 

    2025. 

  2025.         //UPDATE transaction_creatives with the scrapfoto filename$zipfilename

    2026. 

  2026.         mysql_query("

    2027. 

  2027. 				UPDATE transaction_creatives

    2028. 

  2028. 				SET scrapfoto_file='".$zipfilename."'

    2029. 

  2029. 				WHERE id='".$transactionId."' AND user_id='".$userId."'") or die("Error on line - ".__LINE__.mysql_error());

    2030. 

  2030.         ;

    2031. 

  2031.         $downloadimgs = array();

    2032. 

  2032.         $Imgdestination='';

    2033. 

  2033.         foreach($downloadimg as $img) {

    2034. 

  2034.             $arr = explode('/', $img);

    2035. 

  2035.             $downloadimgs[] = $arr[count($arr)-1];

    2036. 

  2036.             $Imgdestination = '../'.substr($img, 0, - strlen($arr[count($arr)-1]));

    2037. 

  2037.         }

    2038. 

  2038. 

    2039. 

  2039.         $Imgdestination = realpath($Imgdestination).'/';

    2040. 

  2040.         $zipdestination = realpath('../app/webroot/creativezone/downloadscraps/').'/';

    2041. 

  2041.         $this->Zipfile->addFiles($downloadimgs,$Imgdestination);  //array of files

    2042. 

  2042.         $this->Zipfile->output($zipfilename,$zipdestination);

    2043. 

  2043. 

    2044. 

  2044.         //____________________________________________________TRANSACTION LOG MANAGEMENT_____________________________________

    2045. 

  2045. 

    2046. 

  2046.         $userDetails=$this->getUserDetails($userId);

    2047. 

  2047.         $queryXouserTransactions=mysql_query("SELECT * FROM xouser_transactions WHERE transaction_head='scrapfoto' AND transaction_title='download' AND invoice_id='".$transactionId."'");

    2048. 

  2048.         if(mysql_num_rows($queryXouserTransactions)<=0) {

    2049. 

  2049.             $transactionDesc="ScrapFOTO - scraps purchase and download";

    2050. 

  2050.             $transactionHead="scrapfoto";

    2051. 

  2051.             $transactionTitle="download";

    2052. 

  2052.             $invoice=$invoice;

    2053. 

  2053.             $invoiceId=$transactionId;

    2054. 

  2054. 

    2055. 

  2055.             $statusoffee="nontransactionfee";

    2056. 

  2056.             $lastInsetID=$this->transactionMaster($transactionDesc,$transactionHead,$transactionTitle,$invoice,$invoiceId);

    2057. 

  2057.             if(!isset($_SESSION['buyTemplate']))

    2058. 

  2058.                 $this->transactionDetail($userId,$totalPay,'-1',$lastInsetID,1,$statusoffee,0,'finished');	//charged//this code is changed on 7th January 2010(statusfee added as well as paymentstatus value 'finished' added---finished is not in used now.)

    2059. 

  2059.             

    2060. 

  2060. 

    2061. 

  2061. 

    2062. 

  2062.             //____________________________________________________MAIL MANAGEMENT________________________________________________

    2063. 

  2063.             //this mailing code is here so that it fires just once.

    2064. 

  2064. 

    2065. 

  2065. 

    2066. 

  2066.             //check buy template

    2067. 

  2067.             if(isset($_SESSION['buyTemplate'])) {

    2068. 

  2068.                 //update transaction_fee for transaction_creatives    

    2069. 

  2069.                 $tranfee = $this->getConfigAmount('creative commission');

    2070. 

  2070.                 $tranfee = $tranfee['config_value']/100*$totalPay;

    2071. 

  2071.                 mysql_query("

    2072. 

  2072. 				UPDATE transaction_creatives

    2073. 

  2073. 				SET transaction_fee='".$tranfee."'

    2074. 

  2074. 				WHERE id='".$transactionId."' AND user_id='".$userId."'") or die("Error on line - ".__LINE__.mysql_error());

    2075. 

  2075.                 ;

    2076. 

  2076. 

    2077. 

  2077.                 // “notification of sale” (E7) will be send to User Artist

    2078. 

  2078.                 $fav = $this->Creative_favorites->findById($_SESSION['buyTemplate']['tmpId']);

    2079. 

  2079. 

    2080. 

  2080.                 $fav['Creative_favorites']['num_sell']++;

    2081. 

  2081.                 $this->Creative_favorites->save($fav);

    2082. 

  2082. 

    2083. 

  2083.                 //save transaction of seller

    2084. 

  2084.                 $transactionDesc="ScrapFOTO - scraps template purchase and download";

    2085. 

  2085.                 $this->transactionDetail($userId,$totalPay,'-1',$lastInsetID,$fav['Creative_favorites']['user_id'],$statusoffee,0,'finished1');	//charged//this code is changed on 7th January 2010(statusfee added as well as paymentstatus value 'finished' added---finished is not in used now.)

    2086. 

  2086.                 //$this->transactionDetail($fav['Creative_favorites']['user_id'],$totalPay,'+1',$lastInsetID,$userId);	//paid

    2087. 

  2087.                 //send mail seller

    2088. 

  2088.                 $sellDetails=$this->getUserDetails($fav['Creative_favorites']['user_id']);

    2089. 

  2089.                 if(isset($sellDetails['email'])) {

    2090. 

  2090. 

    2091. 

  2091.                     $receiver=$fav['Creative_favorites']['user_id'];

    2092. 

  2092. 

    2093. 

  2093.                     $this->Sendmail->Mail();

    2094. 

  2094.                     $this->Sendmail->From(FROMMAIL);

    2095. 

  2095.                     $this->Sendmail->To($sellDetails['email']);

    2096. 

  2096. 

    2097. 

  2097.                     //$this->Sendmail->Cc($sellDetails['email']);

    2098. 

  2098.                     //$this->Sendmail->Cc("amarjit@navsoft.in");

    2099. 

  2099.                     //$this->Sendmail->Bcc( "someoneelse@somewhere.fr");

    2100. 

  2100. 

    2101. 

  2101.                     $subject="XOimages - Notification of sales";

    2102. 

  2102.                     $this->Sendmail->Subject($subject);

    2103. 

  2103. 

    2104. 

  2104.                     $this->set("tranId",$transactionId);

    2105. 

  2105.                     $this->set("sellerId",$receiver);

    2106. 

  2106.                     $this->Sendmail->layout='email';

    2107. 

  2107.                     $this->Sendmail->view= 'mail_notification_sales';

    2108. 

  2108.                     $this->Sendmail->startup($this);

    2109. 

  2109.                     $messageBody=$this->Sendmail->bodyText();

    2110. 

  2110. 

    2111. 

  2111.                     $this->Sendmail->Body($messageBody);        // set the body

    2112. 

  2112.                     $this->Sendmail->Priority(1) ;        // set the priority to Low

    2113. 

  2113.                     $this->Sendmail->Send();        // send the mail

    2114. 

  2114. 

    2115. 

  2115.                     //mail sent to the user mail account in the system

    2116. 

  2116. 

    2117. 

  2117.                     $sender=1;

    2118. 

  2118.                     $this->senderMail($sender,$receiver,$subject,$messageBody);

    2119. 

  2119.                     $this->receiverMail($receiver,$sender,$subject,$messageBody);

    2120. 

  2120.                     $this->Sendmail->__destruct();

    2121. 

  2121. 

    2122. 

  2122.                     //check creative quantity sold

    2123. 

  2123.                     $quantitysold = $this->getConfigAmount('creative quantity sold');

    2124. 

  2124.                     if($quantitysold['config_value']==$fav['Creative_favorites']['num_sell']){

    2125. 

  2125.                         $this->Sendmail->Mail();

    2126. 

  2126.                         $this->Sendmail->From(FROMMAIL);

    2127. 

  2127.                         $this->Sendmail->To($sellDetails['email']);

    2128. 

  2128. 

    2129. 

  2129.                         //$this->Sendmail->Cc($sellDetails['email']);

    2130. 

  2130.                         //$this->Sendmail->Cc("amarjit@navsoft.in");

    2131. 

  2131.                         //$this->Sendmail->Bcc( "someoneelse@somewhere.fr");

    2132. 

  2132. 

    2133. 

  2133.                         $subject="XOimages - Notification of user set price";

    2134. 

  2134.                         $this->Sendmail->Subject($subject);

    2135. 

  2135. 

    2136. 

  2136.                         $this->set("tranId",$transactionId);

    2137. 

  2137.                         $this->set("sellerId",$receiver);

    2138. 

  2138.                         $this->set('num_sell',$fav['Creative_favorites']['num_sell']);

    2139. 

  2139.                         $this->Sendmail->layout='email';

    2140. 

  2140.                         $this->Sendmail->view= 'mail_notification_set_price';

    2141. 

  2141.                         $this->Sendmail->startup($this);

    2142. 

  2142.                         $messageBody=$this->Sendmail->bodyText();

    2143. 

  2143. 

    2144. 

  2144.                         $this->Sendmail->Body($messageBody);        // set the body

    2145. 

  2145.                         $this->Sendmail->Priority(1) ;        // set the priority to Low

    2146. 

  2146.                         $this->Sendmail->Send();        // send the mail

    2147. 

  2147. 

    2148. 

  2148.                         //mail sent to the user mail account in the system

    2149. 

  2149. 

    2150. 

  2150.                         $sender=1;

    2151. 

  2151.                         $this->senderMail($sender,$receiver,$subject,$messageBody);

    2152. 

  2152.                         $this->receiverMail($receiver,$sender,$subject,$messageBody);

    2153. 

  2153.                         $this->Sendmail->__destruct();

    2154. 

  2154.                         //$this->redirect('creativezones/mail_notification_set_price/'.$transactionId.'/'.$receiver);

    2155. 

  2155.                     }

    2156. 

  2156. 

    2157. 

  2157.                 }

    2158. 

  2158.             }

    2159. 

  2159. 

    2160. 

  2160.             //mail sent to the user personal account

    2161. 

  2161.             if(isset($userDetails['email'])) {

    2162. 

  2162.                 $this->Sendmail->Mail();

    2163. 

  2163.                 $this->Sendmail->From(FROMMAIL);

    2164. 

  2164.                 $this->Sendmail->To($userDetails['email']);

    2165. 

  2165. 

    2166. 

  2166.                 //$this->Sendmail->Cc($userDetails['email']);

    2167. 

  2167.                 //$this->Sendmail->Cc("amarjit@navsoft.in");

    2168. 

  2168.                 //$this->Sendmail->Bcc( "someoneelse@somewhere.fr");

    2169. 

  2169. 

    2170. 

  2170.                 $subject="XOimages - Scrapfoto Invoice ".$invoice;

    2171. 

  2171.                 $this->Sendmail->Subject($subject);

    2172. 

  2172. 

    2173. 

  2173.                 $this->set("tranId",$transactionId);

    2174. 

  2174.                 $this->set('amountPaid', $totalPay);

    2175. 

  2175.                 $this->Sendmail->layout='email';

    2176. 

  2176.                 $this->Sendmail->view= 'mail_scrapdownload';

    2177. 

  2177.                 $this->Sendmail->startup($this);

    2178. 

  2178.                 $messageBody=$this->Sendmail->bodyText();

    2179. 

  2179. 

    2180. 

  2180.                 $this->Sendmail->Body($messageBody);        // set the body

    2181. 

  2181.                 $this->Sendmail->Priority(1) ;        // set the priority to Low

    2182. 

  2182.                 $this->Sendmail->Attach($zipdestination.$zipfilename, "image/jpeg" ) ;        // attach a file of type image/gif

    2183. 

  2183.                 $this->Sendmail->Send();        // send the mail

    2184. 

  2184. 

    2185. 

  2185.                 //mail sent to the user mail account in the system

    2186. 

  2186. 

    2187. 

  2187.                 $sender=1;

    2188. 

  2188.                 $receiver=$userId;

    2189. 

  2189.                 $this->senderMail($sender,$receiver,$subject,$messageBody);

    2190. 

  2190.                 $this->receiverMail($receiver,$sender,$subject,$messageBody);

    2191. 

  2191.                 $this->Sendmail->__destruct();

    2192. 

  2192.             }

    2193. 

  2193.         }

    2194. 

  2194. 

    2195. 

  2195. 

    2196. 

  2196. 

    2197. 

  2197.         $sql = "SELECT Favorite.id FROM creative_carts as Cart

    2198. 

  2198.                 LEFT JOIN creative_cart_details CartDetail ON Cart.id = CartDetail.creative_cart_id 

    2199. 

  2199.                 LEFT JOIN creative_favorites Favorite ON Favorite.id = CartDetail.creative_favorite_id 

    2200. 

  2200.                 WHERE Cart.transaction_creative_id='".$transactionId."'  ";

    2201. 

  2201. 

    2202. 

  2202.         $result = mysql_query($sql);

    2203. 

  2203.         if(mysql_num_rows($result)>0) {

    2204. 

  2204.             while($row=mysql_fetch_array($result)) {

    2205. 

  2205.                 mysql_query("UPDATE creative_favorites SET is_temp='0' WHERE id='".$row['id']."' ");

    2206. 

  2206.             }

    2207. 

  2207.         }

    2208. 

  2208. 

    2209. 

  2209.         if(isset($_SESSION['buyTemplate'])) {

    2210. 

  2210.             $_SESSION['buyTemplate']['pay'] = 1;

    2211. 

  2211.         }

    2212. 

  2212. 

    2213. 

  2213.         //

    2214. 

  2214. 

    2215. 

  2215.         $this->pageTitle = 'ScrapFOTO&trade; - success';

    2216. 

  2216.         $this->layout = 'creativehome';

    2217. 

  2217.         $this->creativeType();

    2218. 

  2218.         $this->getPublicScrap();

    2219. 

  2219. 

    2220. 

  2220. 

    2221. 

  2221.         $this->countFavCart();

    2222. 

  2222. 

    2223. 

  2223.         //Initializing all the bradcamp back again so that it all starts all over again

    2224. 

  2224.         $this->set("filename","success");//filename should contain the name of the file that should be selected

    2225. 

  2225.         $this->set("nextpage","success");

    2226. 

  2226. 

    2227. 

  2227.         //_________________________________________________________________________________________________

    2228. 

  2228. 

    2229. 

  2229.         $userId=$_SESSION['UserId'];

    2230. 

  2230. 

    2231. 

  2231. 

    2232. 

  2232.         $transactionId=base64_decode($this->params['url']['tr']);

    2233. 

  2233.         $queryTransactionCreatives=mysql_query("SELECT invoice,scrapfoto_file FROM transaction_creatives WHERE id='".$transactionId."'");

    2234. 

  2234.         $fetchTransactionCreatives=mysql_fetch_assoc($queryTransactionCreatives);

    2235. 

  2235. 

    2236. 

  2236.         $this->set("transactionInv",$fetchTransactionCreatives['invoice']);

    2237. 

  2237.         $this->set('scrapbookfilename',$fetchTransactionCreatives['scrapfoto_file']);

    2238. 

  2238. 

    2239. 

  2239.         $downloadimg=$this->getCartImages($_SESSION['UserId'],$transactionId,true);

    2240. 

  2240.         $this->set("downloadImage",$downloadimg);

    2241. 

  2241. 

    2242. 

  2242.         $this->render('success','creativehome');

    2243. 

  2243.     }

    2244. 

  2244. 

    2245. 

  2245.     function transactionfee_payment_notify() {

    2246. 

  2246. 

    2247. 

  2247.     }

    2248. 

  2248. 

    2249. 

  2249.     function transactionfee_success() {

    2250. 

  2250.         $this->checkSession();

    2251. 

  2251.         //

    2252. 

  2252.         $paypal=0;

    2253. 

  2253.         //____________________________________________________IPN DATA SECTION______________________________________________

    2254. 

  2254. 

    2255. 

  2255.         //This section is used to catch from PAYPAL IPN data

    2256. 

  2256.         if (isset($_POST['payment_gross']) && ($_POST['payment_gross'])!="") {

    2257. 

  2257.             $paypal=1;

    2258. 

  2258. 

    2259. 

  2259.             $totalPay=$_POST['payment_gross'];

    2260. 

  2260.             $custom=explode("^",$_POST['custom']);

    2261. 

  2261. 

    2262. 

  2262.             $userId=$custom['0'];

    2263. 

  2263.             $sellerId=$custom['1'];

    2264. 

  2264.             $isAdmin=$custom['2'];

    2265. 

  2265.             $rdPage=$custom['3'];

    2266. 

  2266.             $invoice=$custom['4'];

    2267. 

  2267.         }

    2268. 

  2268. 

    2269. 

  2269.         //This section is used to catch from GOOGLE IPN data

    2270. 

  2270.         if(!$paypal) {

    2271. 

  2271. 

    2272. 

  2272.             //this section is used to update from google IPN data

    2273. 

  2273.             $xml_response = isset($HTTP_RAW_POST_DATA)?$HTTP_RAW_POST_DATA:file_get_contents("php://input");

    2274. 

  2274.             if($xml_response) {

    2275. 

  2275.                 $gCustom=$this->parseXmlArray($xml_response);

    2276. 

  2276.                 $cData=$gCustom['http://checkout.google.com/schema/2']['SHOPPING-CART']['ITEMS']['ITEM']['MERCHANT-PRIVATE-ITEM-DATA'];

    2277. 

  2277.                 $ipnData=explode("^",$cData);

    2278. 

  2278. 

    2279. 

  2279.                 $userId=$ipnData['0'];

    2280. 

  2280.                 $sellerId=$ipnData['1'];

    2281. 

  2281.                 $isAdmin=$ipnData['2'];

    2282. 

  2282.                 $rdPage=$ipnData['3'];

    2283. 

  2283.                 $invoice=$ipnData['4'];

    2284. 

  2284.                 $totalPay=$ipnData['5'];

    2285. 

  2285.             }

    2286. 

  2286.         }

    2287. 

  2287.         //____________________________________________________XOIMAGE DATABASE UPDATION_____________________________________

    2288. 

  2288. 

    2289. 

  2289.         $tf = $this->Transaction_creatives->findByInvoice($invoice);

    2290. 

  2290.         if($tf) {

    2291. 

  2291.             $tf['Transaction_creatives']['is_pay_transaction_fee'] = '1';

    2292. 

  2292.             $this->Transaction_creatives->save($tf);

    2293. 

  2293. 

    2294. 

  2294.             $sql = "SELECT FX .id

    2295. 

  2295.                     FROM transaction_creatives TC

    2296. 

  2296.                     RIGHT JOIN creative_carts C ON ( C.transaction_creative_id = TC.id )

    2297. 

  2297.                     RIGHT JOIN creative_cart_details CDT ON ( CDT.creative_cart_id = C.id )

    2298. 

  2298.                     RIGHT JOIN creative_favorites F ON ( F.id = CDT.creative_favorite_id )

    2299. 

  2299.                     RIGHT JOIN creative_favorites FX ON ( FX.ssn_id = F.ssn_id     AND FX.is_republished = '1' )

    2300. 

  2300.                     WHERE TC.invoice = '".$invoice."'

    2301. 

  2301.                     LIMIT 1 ";

    2302. 

  2302.             $result = mysql_query($sql);

    2303. 

  2303.             if(mysql_num_rows($result)>0){

    2304. 

  2304.                 $row = mysql_fetch_assoc($result);

    2305. 

  2305.                 $sql = "UPDATE creative_favorites SET is_blocked='0' WHERE id='".$row['id']."'";

    2306. 

  2306.                 mysql_query($sql);

    2307. 

  2307.             }

    2308. 

  2308.             $this->set('sql',$sql);

    2309. 

  2309. 

    2310. 

  2310.             //check unblock user

    2311. 

  2311. 

    2312. 

  2312.             $result = mysql_query("SELECT * FROM creative_favorites WHERE user_id ='".$userId."' and is_blocked='1' LIMIT 1");

    2313. 

  2313.             if(mysql_num_rows($result)<=0){

    2314. 

  2314.                 mysql_query("UPDATE user_payment_setup SET is_blocked='0' WHERE user_id ='".$userId."' ");

    2315. 

  2315.             }

    2316. 

  2316. 

    2317. 

  2317.         }

    2318. 

  2318. 

    2319. 

  2319.         $userDetails=$this->getUserDetails($userId);

    2320. 

  2320.         $queryXouserTransactions=mysql_query("SELECT * FROM xouser_transactions WHERE transaction_head='scrapfoto' AND transaction_title='comission paid' AND invoice='".$invoice."'");

    2321. 

  2321.         if(mysql_num_rows($queryXouserTransactions)<=0) {

    2322. 

  2322.             $transactionDesc="ScrapFOTO - scraps transaction fee";

    2323. 

  2323.             $transactionHead="scrapfoto";

    2324. 

  2324.             $transactionTitle="comission paid";

    2325. 

  2325.             $invoice=$invoice;

    2326. 

  2326.             $invoiceId=0;

    2327. 

  2327. 

    2328. 

  2328.             $statusoffee="projectfee";

    2329. 

  2329.             $lastInsetID=$this->transactionMaster($transactionDesc,$transactionHead,$transactionTitle,$invoice,$invoiceId);

    2330. 

  2330. 

    2331. 

  2331.             $this->transactionDetail($userId,$totalPay,'+1',$lastInsetID,1,$statusoffee,0,'finished');	//charged//this code is changed on 7th January 2010(statusfee added as well as paymentstatus value 'finished' added---finished is not in used now.)

    2332. 

  2332.             //$this->transactionDetail($userId,$totalPay,'+1',$lastInsertId,1);	//paid//this code is blocked on 7th January 2010

    2333. 

  2333. 

    2334. 

  2334. 

    2335. 

  2335.             //____________________________________________________MAIL MANAGEMENT________________________________________________

    2336. 

  2336.             //this mailing code is here so that it fires just once.

    2337. 

  2337. 

    2338. 

  2338. 

    2339. 

  2339.             /*if(isset($userDetails['email'])) {

    2340. 

  2340.                     

    2341. 

  2341. 

    2342. 

  2342.                     $this->Sendmail->Mail();

    2343. 

  2343.                     $this->Sendmail->From(FROMMAIL);

    2344. 

  2344.                     $this->Sendmail->To($userDetails['email']);

    2345. 

  2345. 

    2346. 

  2346.                     //$this->Sendmail->Cc($sellDetails['email']);

    2347. 

  2347.                     //$this->Sendmail->Cc("amarjit@navsoft.in");

    2348. 

  2348.                     //$this->Sendmail->Bcc( "someoneelse@somewhere.fr");

    2349. 

  2349. 

    2350. 

  2350.                     $subject="XOimages Notification of sales";

    2351. 

  2351.                     $this->Sendmail->Subject($subject);

    2352. 

  2352. 

    2353. 

  2353.                     $this->set("tranId",$transactionId);

    2354. 

  2354.                     

    2355. 

  2355.                     $this->Sendmail->layout='email';

    2356. 

  2356.                     $this->Sendmail->view= 'mail_notification_sales';

    2357. 

  2357.                     $this->Sendmail->startup($this);

    2358. 

  2358.                     $messageBody=$this->Sendmail->bodyText();

    2359. 

  2359. 

    2360. 

  2360.                     $this->Sendmail->Body($messageBody);        // set the body

    2361. 

  2361.                     $this->Sendmail->Priority(1) ;        // set the priority to Low

    2362. 

  2362.                     $this->Sendmail->Send();        // send the mail

    2363. 

  2363. 

    2364. 

  2364.                     //mail sent to the user mail account in the system

    2365. 

  2365. 

    2366. 

  2366.                     $sender=1;

    2367. 

  2367.                     $receiver=$userId;

    2368. 

  2368.                     $this->senderMail($sender,$receiver,$subject,$messageBody);

    2369. 

  2369.                     $this->receiverMail($receiver,$sender,$subject,$messageBody);

    2370. 

  2370.                     $this->Sendmail->__destruct();

    2371. 

  2371.                 }*/

    2372. 

  2372. 

    2373. 

  2373.         }

    2374. 

  2374. 

    2375. 

  2375.         $this->pageTitle = 'ScrapFOTO&trade; - transaction fee success';

    2376. 

  2376.         $this->layout = 'creativemysales';

    2377. 

  2377.         $this->creativeType();

    2378. 

  2378.         $this->countFavCart();

    2379. 

  2379.         $this->getPublicScrap();

    2380. 

  2380. 

    2381. 

  2381.         $this->set('transactionInv',$invoice);

    2382. 

  2382. 

    2383. 

  2383.     }

    2384. 

  2384.     //test

    2385. 

  2385.     function mail_scrapdownload($tranId) {

    2386. 

  2386.         $this->layout = 'email';

    2387. 

  2387.         $this->set("tranId",$tranId);

    2388. 

  2388.     }

    2389. 

  2389.     function mail_notification_set_price($tranId,$receiver) {

    2390. 

  2390.         $this->layout = 'email';

    2391. 

  2391.         $this->set('num_sell',2);

    2392. 

  2392.         $this->set("tranId",$tranId);

    2393. 

  2393.         $this->set("sellerId",$receiver);

    2394. 

  2394.     }

    2395. 

  2395. 

    2396. 

  2396.     function setpriceproduct($ssn_id){

    2397. 

  2397.         $this->checkSession();

    2398. 

  2398.         $this->layout = 'creativedetail';

    2399. 

  2399.         $this->creativeType();

    2400. 

  2400.         $this->countFavCart();

    2401. 

  2401.         $this->getRankScrap();

    2402. 

  2402.         $this->getFeaturedScrap();

    2403. 

  2403.         $this->getPublicScrap();

    2404. 

  2404.         

    2405. 

  2405.         $this->set('id',$ssn_id);

    2406. 

  2406. 

    2407. 

  2407.         if($ssn_id!=null) {

    2408. 

  2408.             $query = "SELECT * FROM creative_favorites WHERE ssn_id='".$ssn_id."' AND user_id='".$_SESSION['UserId']."' and is_republished='1' LIMIT 1 ";

    2409. 

  2409.             $favs = mysql_query($query);

    2410. 

  2410.             if($favs && mysql_num_rows($favs)>0){

    2411. 

  2411.                 $fav = mysql_fetch_array($favs);

    2412. 

  2412.                 $fav = $this->Creative_favorites->findById($fav['id']);

    2413. 

  2413.                 if($this->data) {

    2414. 

  2414.                     $fav['Creative_favorites']['price'] = $this->data['creativezones']['price'];

    2415. 

  2415.                     $this->Creative_favorites->save($fav);

    2416. 

  2416.                 }

    2417. 

  2417.                 $this->set('price',$fav['Creative_favorites']['price']);                

    2418. 

  2418.             }

    2419. 

  2419.         }

    2420. 

  2420.     }

    2421. 

  2421. 

    2422. 

  2422. 

    2423. 

  2423.     function downloadscraps() {

    2424. 

  2424.         $fileName=$this->params['url']['f'];

    2425. 

  2425.         $basePath='../app/webroot/creativezone/downloadscraps/';

    2426. 

  2426.         $this->Download->downloadFile($basePath,$fileName);

    2427. 

  2427.     }

    2428. 

  2428. 

    2429. 

  2429.     function getUserLastTransaction($userId) {

    2430. 

  2430.         $queryTransactionCreatives=mysql_query("SELECT id FROM transaction_creatives WHERE user_id='".$userId."' ORDER BY id DESC") or die("Error on line - ".__LINE__.mysql_error());

    2431. 

  2431.         if(mysql_num_rows($queryTransactionCreatives)>0) {

    2432. 

  2432.             $fetchTransactionCreatives=mysql_fetch_assoc($queryTransactionCreatives);

    2433. 

  2433.             return $fetchTransactionCreatives;

    2434. 

  2434.         }

    2435. 

  2435. 

    2436. 

  2436.     }

    2437. 

  2437. 

    2438. 

  2438.     function psuccess() {

    2439. 

  2439.         $this->checkSession();

    2440. 

  2440.         $this->pageTitle = 'ScrapFOTO&trade; - success';

    2441. 

  2441.         $this->layout = 'creativedetail';

    2442. 

  2442.         $this->getPublicScrap();

    2443. 

  2443. 

    2444. 

  2444.         //This ct variable comes from INDEX page and CREATIVETEMPLATE page

    2445. 

  2445.         $id=0;

    2446. 

  2446.         if(isset($this->params['url']['ct']))

    2447. 

  2447.             $id=base64_decode($this->params['url']['ct']);

    2448. 

  2448. 

    2449. 

  2449.         //This ct variable comes from CREATIVETEMPLATE page

    2450. 

  2450.         $tmpImg=0;

    2451. 

  2451.         if(isset($this->params['url']['tmp']))

    2452. 

  2452.             $tmpImg=base64_decode($this->params['url']['tmp']);

    2453. 

  2453. 

    2454. 

  2454.         $this->set("cType",$id);

    2455. 

  2455.         $this->set("cTemplate",$tmpImg);

    2456. 

  2456. 

    2457. 

  2457.         $this->countFavCart();

    2458. 

  2458. 

    2459. 

  2459.         //Initializing all the bradcamp back again so that it all starts all over again

    2460. 

  2460.         $this->set("filename","success");							//filename should contain the name of the file that should be selected

    2461. 

  2461.         $_SESSION['bradcamp_creative'][100]=$this->params['action'];			//we are passing the name of the file to keep track which step is visited

    2462. 

  2462.         $this->set("nextpage","success");

    2463. 

  2463. 

    2464. 

  2464.         //_________________________________________________________________________________________________

    2465. 

  2465. 

    2466. 

  2466. 

    2467. 

  2467.         $transactionId=0;

    2468. 

  2468.         if(isset($this->params['url']['tid']))

    2469. 

  2469.             $transactionId= base64_decode($this->params['url']['tid']);

    2470. 

  2470. 

    2471. 

  2471.         $queryTransactionCreatives=mysql_query("SELECT invoice FROM transaction_creatives WHERE id='".$transactionId."'");

    2472. 

  2472.         $fetchTransactionCreatives=mysql_fetch_assoc($queryTransactionCreatives);

    2473. 

  2473. 

    2474. 

  2474.         $this->set("transactionInv",$fetchTransactionCreatives['invoice']);

    2475. 

  2475. 

    2476. 

  2476.         $zipfilename = 'scrapblogimg'.$transactionId.$_SESSION['UserId'].'.zip';

    2477. 

  2477.         $this->set('scrapbookfilename',$zipfilename);

    2478. 

  2478. 

    2479. 

  2479.         $downloadimg=$this->getCartImages($_SESSION['UserId'],$transactionId);

    2480. 

  2480.         $this->set("downloadImage",$downloadimg);

    2481. 

  2481. 

    2482. 

  2482.     }

    2483. 

  2483. 

    2484. 

  2484.     function scrapsbuynow() {

    2485. 

  2485.         $this->checkSession();

    2486. 

  2486.         $this->pageTitle = 'ScrapFOTO&trade; - Payment';

    2487. 

  2487.         $this->layout = 'creativedetail';

    2488. 

  2488.         $this->getPublicScrap();

    2489. 

  2489. 

    2490. 

  2490.         if(isset($this->params['url']['seller'])) {

    2491. 

  2491.             $sellerId=base64_decode($this->params['url']['seller']);

    2492. 

  2492. 

    2493. 

  2493. 

    2494. 

  2494.             $cartsql = "

    2495. 

  2495. 									SELECT CM.id,Cfav.id as favid,CM.product_name,Creativedetail.imagename,

    2496. 

  2496. 									CM.qty,CM.price ,(CM.price*CM.qty) as subtotal  

    2497. 

  2497. 									from creative_carts CM 

    2498. 

  2498. 									LEFT JOIN creative_cart_details Creativedetail ON CM.id =Creativedetail.creative_cart_id

    2499. 

  2499. 									LEFT JOIN creative_favorites Cfav ON CM.product_name = Cfav.title

    2500. 

  2500. 									LEFT JOIN creative_template_pages ctemppage ON Cfav.id=ctemppage.id

    2501. 

  2501. 									where 

    2502. 

  2502. 									CM.user_id='".$_SESSION['UserId']."' AND CM.ssn_id='".session_id()."'and CM.pay_status='0'   ";

    2503. 

  2503. 

    2504. 

  2504. 

    2505. 

  2505. 

    2506. 

  2506.             $this->set('mycartsql',$cartsql);

    2507. 

  2507. 

    2508. 

  2508.             $newcartsql ="

    2509. 

  2509. 						SELECT ifnull( Buser.username, 'NA') AS username,

    2510. 

  2510. 						Cfav.id , Cfav.user_id,

    2511. 

  2511. 						COUNT( Cfav.title) as creative_count

    2512. 

  2512. 						FROM creative_carts Creativecart

    2513. 

  2513. 						LEFT JOIN creative_favorites Cfav ON Creativecart.product_name = Cfav.title

    2514. 

  2514. 						

    2515. 

  2515. 						LEFT JOIN users Buser ON ( Cfav.user_id = Buser.id )

    2516. 

  2516. 						

    2517. 

  2517. 						WHERE Creativecart.user_id = '".$_SESSION['UserId']."'

    2518. 

  2518. 						AND Creativecart.ssn_id = '".session_id()."'

    2519. 

  2519. 						AND Creativecart.pay_status = '0' AND Cfav.user_id='".$sellerId."'

    2520. 

  2520. 						GROUP BY Cfav.user_id

    2521. 

  2521. 						";

    2522. 

  2522. 

    2523. 

  2523. 

    2524. 

  2524.             $this->set('newmycartsql',$newcartsql);

    2525. 

  2525.             if($sellerId==$_SESSION['UserId']) {

    2526. 

  2526.                 $this->set("sellerId",1);

    2527. 

  2527.                 $paymentMethods=$this->getPaymentMethods(1);	// that means payment will go to the admin paymenbt id

    2528. 

  2528.             }

    2529. 

  2529.             else {

    2530. 

  2530.                 $this->set("sellerId",$sellerId);

    2531. 

  2531.                 $paymentMethods=$this->getPaymentMethodsUsers($sellerId);

    2532. 

  2532.             }

    2533. 

  2533. 

    2534. 

  2534.             $this->set("paymentMethods",$paymentMethods);

    2535. 

  2535.         }

    2536. 

  2536. 

    2537. 

  2537.     }

    2538. 

  2538. 

    2539. 

  2539.     //checking

    2540. 

  2540.     function countFavCart() {

    2541. 

  2541.         //get creativeFavCount

    2542. 

  2542.         $creativeFavCount=0;

    2543. 

  2543.         if(isset($_SESSION['UserId'])) {

    2544. 

  2544.             if(isset($_SESSION['buyTemplate']['idNew'])) {

    2545. 

  2545.                 $favQry = mysql_query("SELECT * FROM creative_favorites WHERE user_id ='".$_SESSION['UserId']."' AND id='".$_SESSION['buyTemplate']['idNew']."'") or die("Error on line :".__LINE__.mysql_error());

    2546. 

  2546.             }else {

    2547. 

  2547.                 $favQry = mysql_query("SELECT * FROM creative_favorites WHERE user_id ='".$_SESSION['UserId']."' AND is_temp='0' AND is_republished='1' ") or die("Error on line :".__LINE__.mysql_error());

    2548. 

  2548.             }

    2549. 

  2549.             $creativeFavCount = mysql_num_rows($favQry);

    2550. 

  2550.         }

    2551. 

  2551.         $this->set("creativeFavCount",$creativeFavCount);

    2552. 

  2552. 

    2553. 

  2553.         //get creativeCart Count

    2554. 

  2554.         $creativeCart=0;

    2555. 

  2555.         if(isset($_SESSION['UserId'])) {

    2556. 

  2556.             $creativeCart = @mysql_num_rows(mysql_query("SELECT * FROM creative_carts as CC, creative_cart_details as CD, creative_favorites as CF  WHERE CC.user_id=".$_SESSION['UserId']." AND CC.pay_status='0' AND CC.id=CD.creative_cart_id AND CD.creative_favorite_id=CF.id AND CD.creative_favorite_id>0"));

    2557. 

  2557.         }

    2558. 

  2558. 

    2559. 

  2559.         $this->set("creativeCart",$creativeCart);

    2560. 

  2560.         //get config payment

    2561. 

  2561.         $result = $this->getConfigAmount('creative price');

    2562. 

  2562.         $this->set("creative_price",number_format($result['config_value'],2));

    2563. 

  2563. 

    2564. 

  2564.         return $creativeCart;

    2565. 

  2565.     }

    2566. 

  2566.     //ok

    2567. 

  2567.     function getCartDetails() {

    2568. 

  2568.         $queryCreativeCarts=mysql_query("

    2569. 

  2569. 				SELECT CM.id,CM.cart_name,(CD.price*CD.qty) as subTotal,CD.product_name,CD.qty,CD.id as cart_detail_id,CF.fileThumb2 as imagename

    2570. 

  2570. 				FROM creative_carts CM,creative_cart_details CD,  creative_favorites as CF

    2571. 

  2571. 				WHERE CM.id=CD.creative_cart_id AND CD.creative_favorite_id=CF.id AND CM.pay_status='0' AND CM.user_id='".$_SESSION['UserId']."'

    2572. 

  2572. 				") or die("Error on line : ".__LINE__.mysql_error());

    2573. 

  2573. 

    2574. 

  2574.         $this->set("queryCreativeCarts",$queryCreativeCarts);

    2575. 

  2575. 

    2576. 

  2576.     }

    2577. 

  2577.     //ok

    2578. 

  2578.     function removefromcart() {

    2579. 

  2579.         $cartId =0;

    2580. 

  2580. 

    2581. 

  2581.         if(isset($this->params['url']['cartid']) && isset($this->params['url']['cartdtid']) && isset($this->params['url']['act']) && $this->params['url']['act']=='del' ) {

    2582. 

  2582.             $cartId=base64_decode($this->params['url']['cartid']);

    2583. 

  2583.             $cartdtId=base64_decode($this->params['url']['cartdtid']);

    2584. 

  2584.             mysql_query("DELETE FROM creative_cart_details WHERE creative_cart_id='".$cartId."' AND id ='".$cartdtId."'");

    2585. 

  2585.             $this->set("action",strtoupper($this->params['url']['act']));

    2586. 

  2586.         }

    2587. 

  2587. 

    2588. 

  2588.         $this->set("cartId",$cartId);

    2589. 

  2589. 

    2590. 

  2590.         if(isset($this->params['url']['act']) && $this->params['url']['act']=='edit') {

    2591. 

  2591.             $this->set("action",strtoupper($this->params['url']['act']));

    2592. 

  2592.         }

    2593. 

  2593. 

    2594. 

  2594.         //this is to check whther the delete method is called from CREATIVE_FAVORITE function or CREATIVE_CART

    2595. 

  2595.         if(isset($this->params['url']['f']))

    2596. 

  2596.             $this->set("f",$this->params['url']['f']);

    2597. 

  2597. 

    2598. 

  2598.         $this->getCartDetails();

    2599. 

  2599.         $this->getUserDetails();

    2600. 

  2600.         $this->countFavCart();

    2601. 

  2601. 

    2602. 

  2602.         $fetchAdminPaymentSetup=$this->getPaymentMethods(1);	// that means payment will go to the admin paymenbt id

    2603. 

  2603.         $this->set("paymentMethods",$fetchAdminPaymentSetup);

    2604. 

  2604. 

    2605. 

  2605.         $this->render("cartlist","ajax");

    2606. 

  2606.     }

    2607. 

  2607.     //checking

    2608. 

  2608.     function delfavorite() {

    2609. 

  2609.         $this->checkSession();

    2610. 

  2610.         if(isset($this->params['url']['fid'])) {

    2611. 

  2611.             $favId=base64_decode($this->params['url']['fid']);

    2612. 

  2612. 

    2613. 

  2613.             $sql = "SELECT * FROM creative_favorites WHERE id='".$favId."' AND user_id='".$_SESSION['UserId']."'";

    2614. 

  2614.             $result = mysql_query($sql) or die("Error on line : ".__LINE__.mysql_error());

    2615. 

  2615.             if(mysql_num_rows($result)>0) {

    2616. 

  2616.                 $sql="UPDATE creative_favorites SET is_temp='1' WHERE id='".$favId."' AND user_id='".$_SESSION['UserId']."'";

    2617. 

  2617.                 mysql_query($sql) or die("Error on line : ".__LINE__.mysql_error());

    2618. 

  2618. 

    2619. 

  2619.                 /*$sql="DELETE FROM creative_favorites_details WHERE creative_favorite_id='".$favId."'";

    2620. 

  2620.                 mysql_query($sql) or die("Error on line : ".__LINE__.mysql_error());

    2621. 

  2621. 

    2622. 

  2622.                 $sql="DELETE FROM creative_favorite_comments WHERE creative_favorite_id='".$favId."'";

    2623. 

  2623.                 mysql_query($sql) or die("Error on line : ".__LINE__.mysql_error());

    2624. 

  2624. 

    2625. 

  2625.                 $sql="DELETE FROM creative_favorite_lovers WHERE creative_favorite_id='".$favId."'";

    2626. 

  2626.                 mysql_query($sql) or die("Error on line : ".__LINE__.mysql_error());

    2627. 

  2627. 

    2628. 

  2628.                 $sql="DELETE FROM creative_favorite_tags WHERE creative_favorite_id='".$favId."'";

    2629. 

  2629.                 mysql_query($sql) or die("Error on line : ".__LINE__.mysql_error());

    2630. 

  2630. 

    2631. 

  2631.                 $sql="DELETE FROM creative_favorite_voting WHERE creative_favorite_id='".$favId."'";

    2632. 

  2632.                 mysql_query($sql) or die("Error on line : ".__LINE__.mysql_error());

    2633. 

  2633.                 */

    2634. 

  2634.                 //note check delete item in cart

    2635. 

  2635.                 //get cart not pay

    2636. 

  2636.                 $sql = "SELECT * FROM creative_carts WHERE pay_status='0'";

    2637. 

  2637.                 $result = mysql_query($sql) or die("Error on line : ".__LINE__.mysql_error());

    2638. 

  2638.                 while ($row = mysql_fetch_array($result)) {

    2639. 

  2639.                     $sql="DELETE FROM creative_cart_details  WHERE creative_cart_id='".$row['id']."' AND creative_favorite_id='".$favId."'";

    2640. 

  2640.                     mysql_query($sql) or die("Error on line : ".__LINE__.mysql_error());

    2641. 

  2641.                 }

    2642. 

  2642.             }

    2643. 

  2643. 

    2644. 

  2644.         }

    2645. 

  2645.         if(isset($_SESSION['buyTemplate']['idNew'])) {

    2646. 

  2646.             unset($_SESSION['buyTemplate']);

    2647. 

  2647.             $this->redirect("/creativezones/index");

    2648. 

  2648.         }else {

    2649. 

  2649.             $this->redirect("/creativezones/creative_favorite");

    2650. 

  2650.         }

    2651. 

  2651. 

    2652. 

  2652.     }

    2653. 

  2653.     //checking

    2654. 

  2654.     function addtocart() {

    2655. 

  2655.         $favId=base64_decode($this->data['xoevent']['favoriteId']);

    2656. 

  2656. 

    2657. 

  2657.         $result=mysql_query("	SELECT *

    2658. 

  2658. 				FROM creative_favorites 

    2659. 

  2659. 				WHERE id='".$favId."' AND user_id='".$_SESSION['UserId']."'");

    2660. 

  2660.         if(mysql_num_rows($result)>0) {

    2661. 

  2661.             $fav=mysql_fetch_assoc($result);

    2662. 

  2662.             $productId=$fav['id'];

    2663. 

  2663.             $cart_name="Scrap";

    2664. 

  2664.             $price=$fav['price'];

    2665. 

  2665.             $productName=$fav['title'];

    2666. 

  2666. 

    2667. 

  2667.            if(!isset($_SESSION['buyTemplate']) || !isset($_SESSION['buyTemplate']['tmpId'])){

    2668. 

  2668.                $creative_price=$this->getConfigAmount('creative price');

    2669. 

  2669.                $price = $creative_price['config_value'];

    2670. 

  2670.            }

    2671. 

  2671. 

    2672. 

  2672.             $result = mysql_query("SELECT * FROM creative_carts WHERE user_id='".$_SESSION['UserId']."' AND pay_status='0' LIMIT 1");

    2673. 

  2673.             if(mysql_num_rows($result)>0) {

    2674. 

  2674.                 $cart = mysql_fetch_assoc($result);

    2675. 

  2675.                 $cart_id = $cart['id'];

    2676. 

  2676.             }else {

    2677. 

  2677.                 mysql_query("INSERT INTO

    2678. 

  2678.                                     creative_carts(user_id,cart_name,transaction_creative_id,pay_status)

    2679. 

  2679.                                     VALUES('".$_SESSION['UserId']."','".$cart_name."','0','0')") or die("Error on line : ".__LINE__.mysql_error());

    2680. 

  2680. 

    2681. 

  2681.                 $cart_id=mysql_insert_id();

    2682. 

  2682.             }

    2683. 

  2683. 

    2684. 

  2684. 

    2685. 

  2685.             $result = mysql_query("SELECT * FROM creative_cart_details WHERE creative_cart_id='".$cart_id."' AND creative_favorite_id='$productId' LIMIT 1");

    2686. 

  2686.             if(mysql_num_rows($result)>0) {

    2687. 

  2687.                 $cartdetail = mysql_fetch_assoc($result);

    2688. 

  2688.                 mysql_query("UPDATE FROM creative_cart_details SET product_name='".$productName."' price='$price',qty='1' WHERE id='".$cartdetail['id']."' ");

    2689. 

  2689.             }else {

    2690. 

  2690.                 mysql_query("INSERT INTO creative_cart_details SET creative_cart_id='$cart_id' ,creative_favorite_id='$productId', product_name='".$productName."',price='$price',qty='1'");

    2691. 

  2691.             }

    2692. 

  2692.         }

    2693. 

  2693.         $this->getCartDetails();

    2694. 

  2694.         $this->countFavCart();

    2695. 

  2695.         $this->render("addtocart","ajax");

    2696. 

  2696.     }

    2697. 

  2697. 

    2698. 

  2698.     function photolover($id=null) {

    2699. 

  2699.         if(isset($_SESSION['UserId'])&& $id) {

    2700. 

  2700.             $checklover = "Select * from creative_favorite_lovers where user_id='".$_SESSION['UserId']."' and creative_favorite_id='".$id."'" ;

    2701. 

  2701.             $checklover_res = mysql_query($checklover);

    2702. 

  2702.             $checklover_res_num = mysql_num_rows($checklover_res);

    2703. 

  2703.             if($checklover_res_num==0) {

    2704. 

  2704.                 $insertlover = "INSERT INTO creative_favorite_lovers SET user_id='".$_SESSION['UserId']."', creative_favorite_id='".$id."' ";

    2705. 

  2705.                 $insertlover=mysql_query($insertlover);

    2706. 

  2706.             }

    2707. 

  2707. 

    2708. 

  2708. 

    2709. 

  2709.         }

    2710. 

  2710.         $checklover = "Select * from creative_favorite_lovers where creative_favorite_id='".$id."'" ;

    2711. 

  2711.         $checklover_res = mysql_query($checklover);

    2712. 

  2712.         $checklover_res_num = mysql_num_rows($checklover_res);

    2713. 

  2713.         $this->set('nooflover', $checklover_res_num);

    2714. 

  2714.         $this->set('photoId', $id);

    2715. 

  2715. 

    2716. 

  2716.         $this->render('photolover', 'ajax');

    2717. 

  2717. 

    2718. 

  2718.     }

    2719. 

  2719. 

    2720. 

  2720.     function addtag($photoId=null) {

    2721. 

  2721.         /* */

    2722. 

  2722.         $this->set('photoImageId',$_REQUEST['hfphotopid']);

    2723. 

  2723.         if(isset($_REQUEST['hfphotopid']) && $_REQUEST['hfphotopid']>0 && isset($_SESSION['UserId']) && addslashes($_REQUEST['phototag'])!='Enter Tag') {

    2724. 

  2724.             /* INSERT INTO TAGE TABLE */

    2725. 

  2725.             $insersql = "INSERT INTO creative_favorite_tags SET user_id='".$_SESSION['UserId']."',creative_favorite_id='".$_REQUEST['hfphotopid']."',tagname='".addslashes($_REQUEST['phototag'])."' ";

    2726. 

  2726.             $insersql_res = mysql_query($insersql);

    2727. 

  2727.         }

    2728. 

  2728.         $this->set('photoImageId', $_REQUEST['hfphotopid']);

    2729. 

  2729.         $this->render('taglist', 'ajax');

    2730. 

  2730.     }

    2731. 

  2731. 

    2732. 

  2732.     function Postreview() {

    2733. 

  2733.         if(isset($_REQUEST['hfphotoid']) && $_REQUEST['hfphotoid']>0 && isset($_SESSION['UserId'])) {

    2734. 

  2734.             /* Getting out the review*/

    2735. 

  2735.             $selectRec= "Select * from creative_favorite_comments where user_id='".$_SESSION['UserId']."' and  creative_favorite_id='".$_REQUEST['hfphotoid']."'" ;

    2736. 

  2736.             $selectRec_res = mysql_query($selectRec);

    2737. 

  2737.             if(mysql_num_rows($selectRec_res)==0) {

    2738. 

  2738.                 $insertIntoreview = "Insert into creative_favorite_comments SET user_id='".$_SESSION['UserId']."',creative_favorite_id='".$_REQUEST['hfphotoid']."',comment_desc='".addslashes($_REQUEST['reviewdesc'])."' ";

    2739. 

  2739.                 mysql_query($insertIntoreview);

    2740. 

  2740. 

    2741. 

  2741.             }

    2742. 

  2742.         }

    2743. 

  2743.         $this->set('photoId', $_REQUEST['hfphotoid']);

    2744. 

  2744.         $this->render('reviewlist', 'ajax');

    2745. 

  2745.     }

    2746. 

  2746. 

    2747. 

  2747.     function getCreativeType($scrapId) {

    2748. 

  2748.         $queryCreativeType=mysql_query("SELECT * FROM creative_type WHERE id='".$scrapId."'");

    2749. 

  2749.         $fetchCreativeType=mysql_fetch_assoc($queryCreativeType);

    2750. 

  2750.         return $fetchCreativeType;

    2751. 

  2751.     }

    2752. 

  2752. 

    2753. 

  2753.     function myscrapxing($idDelete=null) {

    2754. 

  2754.         $this->checksession();

    2755. 

  2755.         $this->layout = 'creativeinner';

    2756. 

  2756.         ############################### Page Title  & Head ############################

    2757. 

  2757.         $this->pageTitle = 'My ScrapFOTO - My Favorite';

    2758. 

  2758.         $this->set('pagehead','My Favorite');

    2759. 

  2759. 

    2760. 

  2760.         if($idDelete!=null) {

    2761. 

  2761.             $delquery ="UPDATE creative_favorites SET is_temp='1' where user_id='".$_SESSION['UserId']."' AND id='".base64_decode($idDelete)."' ";

    2762. 

  2762.             mysql_query($delquery);

    2763. 

  2763.         }

    2764. 

  2764.         ############################### Page Title  & Head ############################

    2765. 

  2765.         /* Pagination and PHOTO listing */

    2766. 

  2766.         $select = " Select X.fileThumb2 as template_img,X.price,X.id,X1.user_id,X.title,XCreativetype.creative_name ,XCreativetype.id as creativetypeid,  X.description,Xuser.username ,COUNT(Xcomment.id) as photoreview ,  Xuserdetail.user_profile_img , IFNULL(ROUND(AVG(Xrating.vote),0),0) as photorat";

    2767. 

  2767. 

    2768. 

  2768.         $from=" FROM creative_favorites X

    2769. 

  2769.                     RIGHT JOIN creative_favorites X1 ON ( X1.ssn_id = X.ssn_id AND X1.is_republished ='1' )

    2770. 

  2770.                     LEFT JOIN creative_type XCreativetype ON X.creative_type_id = XCreativetype.id

    2771. 

  2771.                     LEFT JOIN creative_favorite_comments Xcomment ON X.id = Xcomment.creative_favorite_id

    2772. 

  2772.                     LEFT JOIN users Xuser ON  X1.user_id = Xuser.id

    2773. 

  2773.                     LEFT JOIN user_details Xuserdetail ON X1.user_id = Xuserdetail.user_id

    2774. 

  2774.                     LEFT JOIN creative_favorite_voting Xrating ON X.id = Xrating.creative_favorite_id";

    2775. 

  2775. 

    2776. 

  2776.         $where=" WHERE  X.is_blocked='0' AND X.is_temp='0' ";

    2777. 

  2777.         $where.=" AND X.user_id='".$_SESSION['UserId']."' ";

    2778. 

  2778. 

    2779. 

  2779.         $others=" group by X.id ";

    2780. 

  2780.         $others.=" order by X.id desc";

    2781. 

  2781.         $PassParameter='';

    2782. 

  2782.         $fltr='';

    2783. 

  2783.         $CountField="X.id";

    2784. 

  2784.         $this->set("controller","creativezones");

    2785. 

  2785.         $this->set("action","myscrapxing");

    2786. 

  2786.         $this->set("parameter",$PassParameter);

    2787. 

  2787.         $this->set("fltr",$fltr);

    2788. 

  2788. 

    2789. 

  2789.         $this->set('sql',$select.$from.$where.$others);

    2790. 

  2790.         $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);

    2791. 

  2791.         if(isset($this->params['url']['Page']) || (isset($fltr) && $fltr!="") || $idDelete!=null) {

    2792. 

  2792.             $this->render("myscrapxing2","ajax");

    2793. 

  2793.         }

    2794. 

  2794. 

    2795. 

  2795.         /**/

    2796. 

  2796.         $this->creativeType();

    2797. 

  2797.         $this->countFavCart();

    2798. 

  2798.         $this->getPublicScrap();

    2799. 

  2799. //echo $select;echo $from;echo $where;echo $others; echo $CountField;

    2800. 

  2800. 

    2801. 

  2801.     }

    2802. 

  2802. 

    2803. 

  2803.     function approve() {

    2804. 

  2804.         $this->checkSession();

    2805. 

  2805.         $this->layout = 'creativeinner';

    2806. 

  2806. 

    2807. 

  2807.         $viewSearchType = '';

    2808. 

  2808. 

    2809. 

  2809.         if((isset($this->params['url']['hfsearch']) && $this->params['url']['hfsearch']!='') || isset($_REQUEST['hfsearch']) )

    2810. 

  2810.             $viewSearchType=$_REQUEST['hfsearch'];

    2811. 

  2811. 

    2812. 

  2812. 

    2813. 

  2813. 

    2814. 

  2814.         ############################### Page Title  & Head ############################

    2815. 

  2815.         $this->pageTitle = 'ScrapFOTO&trade; '.'Approve';

    2816. 

  2816.         $this->set('pagehead','Approve');

    2817. 

  2817. 

    2818. 

  2818.         ############################### Page Title  & Head ############################

    2819. 

  2819.         /* Pagination and PHOTO listing */

    2820. 

  2820.         $select = " Select X.is_featured,X.fileThumb2 as template_img,X.price,X.viewed,X.ssn_id,X.width,X.height,X.id,X.creation,X.user_id,X.title,XCreativetype.creative_name ,XCreativetype.id as creativetypeid,  X.description,Xuser.username ,COUNT(Xcomment.id) as photoreview ,  Xuserdetail.user_profile_img , IFNULL(ROUND(AVG(Xrating.vote),0),0) as photorat

    2821. 

  2821.                     , X.creation, X.is_stop_sell,Ticket.msg_to_user,X.num_sell,X.is_approved";

    2822. 

  2822. 

    2823. 

  2823.         $from=" FROM creative_favorites X

    2824. 

  2824.                                 LEFT JOIN creative_tickets Ticket ON X.id = Ticket.creative_favorites_id

    2825. 

  2825. 				LEFT JOIN creative_type XCreativetype ON X.creative_type_id = XCreativetype.id

    2826. 

  2826. 

    2827. 

  2827. 				LEFT JOIN creative_favorite_comments Xcomment ON X.id = Xcomment.creative_favorite_id

    2828. 

  2828. 				LEFT JOIN users Xuser ON  X.user_id = Xuser.id

    2829. 

  2829. 				LEFT JOIN user_details Xuserdetail ON X.user_id = Xuserdetail.user_id

    2830. 

  2830. 				LEFT JOIN creative_favorite_voting Xrating ON X.id = Xrating.creative_favorite_id";

    2831. 

  2831. 

    2832. 

  2832.         $where=" WHERE X.user_id='".$_SESSION['UserId']."' AND  X.is_blocked='0' AND X.is_temp='0' AND X.type='0' AND X.is_approved='1' ";

    2833. 

  2833. 

    2834. 

  2834. 

    2835. 

  2835.         $searchpass='';

    2836. 

  2836.         if($viewSearchType=='title' && isset($_REQUEST['txtsrch']) && $_REQUEST['txtsrch']!='') {

    2837. 

  2837.             $where.="  AND X.title like '%".$_REQUEST['txtsrch']."%' ";

    2838. 

  2838.             $searchpass = "&txtsrch=".$_REQUEST['txtsrch'] ;

    2839. 

  2839.         }

    2840. 

  2840. 

    2841. 

  2841.         if($viewSearchType=='prodid') {

    2842. 

  2842.             $where.="  AND X.ssn_id like '%".$_REQUEST['txtsrch']."%'";

    2843. 

  2843.             $searchpass = "&txtsrch=".$_REQUEST['txtsrch'] ;

    2844. 

  2844.         }

    2845. 

  2845. 

    2846. 

  2846.         if($viewSearchType=='daterange') {

    2847. 

  2847.             if($_REQUEST['inpdatefrom'] && $_REQUEST['inpdatefrom']!='mm/dd/YY') {

    2848. 

  2848.                 $eventFromDate=date("Y-m-d",strtotime($_REQUEST['inpdatefrom']));

    2849. 

  2849.                 $urlfromdate  = $_REQUEST['inpdatefrom'];

    2850. 

  2850.             }

    2851. 

  2851.             else {

    2852. 

  2852.                 $eventFromDate=date("Y-m-d");

    2853. 

  2853.                 $urlfromdate  = $_REQUEST['inpdatefrom'];

    2854. 

  2854.             }

    2855. 

  2855. 

    2856. 

  2856.             if($_REQUEST['inpdateto'] && $_REQUEST['inpdateto']!='mm/dd/YY') {

    2857. 

  2857.                 $eventToDate=date("Y-m-d",strtotime($_REQUEST['inpdateto']));

    2858. 

  2858.                 $urltodate  = $_REQUEST['inpdateto'];

    2859. 

  2859.             }

    2860. 

  2860.             else {

    2861. 

  2861.                 $eventToDate=date("Y-m-d");

    2862. 

  2862.                 $urltodate  = $_REQUEST['inpdateto'];

    2863. 

  2863. 

    2864. 

  2864.             }

    2865. 

  2865. 

    2866. 

  2866.             $where.="  AND X.creation between '".$eventFromDate."' and '".$eventToDate."' ";

    2867. 

  2867.             $searchpass = "&inpdatefrom=".$urlfromdate."&inpdateto=".$urltodate ;

    2868. 

  2868.         }

    2869. 

  2869. 

    2870. 

  2870.         $this->set('searchpass',$where);

    2871. 

  2871. 

    2872. 

  2872. 

    2873. 

  2873. 

    2874. 

  2874.         $others=" group by X.id ";

    2875. 

  2875. 

    2876. 

  2876.         if($viewSearchType=='title')

    2877. 

  2877.             $others .=" order by X.title desc ";

    2878. 

  2878. 

    2879. 

  2879.         if($viewSearchType=='prodid')

    2880. 

  2880.             $others .=" order by X.ssn_id  desc ";

    2881. 

  2881. 

    2882. 

  2882.         if($viewSearchType=='daterange')

    2883. 

  2883.             $others .=" order by X.creation desc ";

    2884. 

  2884. 

    2885. 

  2885.         $PassParameter ='';

    2886. 

  2886.         if($viewSearchType!='') {

    2887. 

  2887.             $PassParameter="hfsearch=".$viewSearchType.$searchpass;

    2888. 

  2888.         }

    2889. 

  2889. 

    2890. 

  2890. 

    2891. 

  2891.         $CountField="X.id";

    2892. 

  2892.         $this->set("controller","creativezones");

    2893. 

  2893.         $this->set("action","approve");

    2894. 

  2894.         $this->set("parameter",$PassParameter);

    2895. 

  2895. 

    2896. 

  2896.         $quantityAllowSell = $this->getConfigAmount('creative quantity sold');

    2897. 

  2897.         $this->set('quantityAllowSell',$quantityAllowSell['config_value']);

    2898. 

  2898. 

    2899. 

  2899.         $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);

    2900. 

  2900.         if(isset($this->params['url']['Page']) || $viewSearchType!='') {

    2901. 

  2901.             $this->render("approve_search","ajax");

    2902. 

  2902.         }

    2903. 

  2903. 

    2904. 

  2904.         /**/

    2905. 

  2905. 

    2906. 

  2906. 

    2907. 

  2907.         $this->creativeType();

    2908. 

  2908.         $this->countFavCart();

    2909. 

  2909.         $this->getPublicScrap();

    2910. 

  2910.     }

    2911. 

  2911. 

    2912. 

  2912.     function reject() {

    2913. 

  2913.         $this->checkSession();

    2914. 

  2914.         $this->layout = 'creativeinner';

    2915. 

  2915. 

    2916. 

  2916.         $viewSearchType = '';

    2917. 

  2917. 

    2918. 

  2918.         if((isset($this->params['url']['hfsearch']) && $this->params['url']['hfsearch']!='') || isset($_REQUEST['hfsearch']) )

    2919. 

  2919.             $viewSearchType=$_REQUEST['hfsearch'];

    2920. 

  2920. 

    2921. 

  2921. 

    2922. 

  2922. 

    2923. 

  2923.         ############################### Page Title  & Head ############################

    2924. 

  2924.         $this->pageTitle = 'ScrapFOTO&trade; '.'Reject';

    2925. 

  2925.         $this->set('pagehead','Reject');

    2926. 

  2926. 

    2927. 

  2927.         ############################### Page Title  & Head ############################

    2928. 

  2928.         /* Pagination and PHOTO listing */

    2929. 

  2929.         $select = " Select X.is_featured,X.fileThumb2 as template_img,X.price,X.viewed,X.ssn_id,X.width,X.height,X.id,X.creation,X.user_id,X.title,XCreativetype.creative_name ,XCreativetype.id as creativetypeid,  X.description,Xuser.username ,COUNT(Xcomment.id) as photoreview ,  Xuserdetail.user_profile_img , IFNULL(ROUND(AVG(Xrating.vote),0),0) as photorat

    2930. 

  2930.                     , X.creation, X.is_stop_sell,Ticket.msg_to_user,X.num_sell,X.is_approved,Ticket.ticket_number";

    2931. 

  2931. 

    2932. 

  2932.         $from=" FROM creative_favorites X

    2933. 

  2933.                                 LEFT JOIN creative_tickets Ticket ON X.id = Ticket.creative_favorites_id

    2934. 

  2934. 				LEFT JOIN creative_type XCreativetype ON X.creative_type_id = XCreativetype.id

    2935. 

  2935. 

    2936. 

  2936. 				LEFT JOIN creative_favorite_comments Xcomment ON X.id = Xcomment.creative_favorite_id

    2937. 

  2937. 				LEFT JOIN users Xuser ON  X.user_id = Xuser.id

    2938. 

  2938. 				LEFT JOIN user_details Xuserdetail ON X.user_id = Xuserdetail.user_id

    2939. 

  2939. 				LEFT JOIN creative_favorite_voting Xrating ON X.id = Xrating.creative_favorite_id";

    2940. 

  2940. 

    2941. 

  2941.         $where=" WHERE X.user_id='".$_SESSION['UserId']."' AND  X.is_blocked='0' AND X.is_temp='0' AND X.type='0' AND X.is_approved='-1' ";

    2942. 

  2942. 

    2943. 

  2943. 

    2944. 

  2944.         $searchpass='';

    2945. 

  2945.         if($viewSearchType=='title' && isset($_REQUEST['txtsrch']) && $_REQUEST['txtsrch']!='') {

    2946. 

  2946.             $where.="  AND X.title like '%".$_REQUEST['txtsrch']."%' ";

    2947. 

  2947.             $searchpass = "&txtsrch=".$_REQUEST['txtsrch'] ;

    2948. 

  2948.         }

    2949. 

  2949. 

    2950. 

  2950.         if($viewSearchType=='prodid') {

    2951. 

  2951.             $where.="  AND X.ssn_id like '%".$_REQUEST['txtsrch']."%'";

    2952. 

  2952.             $searchpass = "&txtsrch=".$_REQUEST['txtsrch'] ;

    2953. 

  2953.         }

    2954. 

  2954. 

    2955. 

  2955.         if($viewSearchType=='ticket') {

    2956. 

  2956.             $where.="  AND Ticket.ticket_number like '%".$_REQUEST['txtsrch']."%'";

    2957. 

  2957.             $searchpass = "&txtsrch=".$_REQUEST['txtsrch'] ;

    2958. 

  2958.         }

    2959. 

  2959. 

    2960. 

  2960.         if($viewSearchType=='daterange') {

    2961. 

  2961.             if($_REQUEST['inpdatefrom'] && $_REQUEST['inpdatefrom']!='mm/dd/YY') {

    2962. 

  2962.                 $eventFromDate=date("Y-m-d",strtotime($_REQUEST['inpdatefrom']));

    2963. 

  2963.                 $urlfromdate  = $_REQUEST['inpdatefrom'];

    2964. 

  2964.             }

    2965. 

  2965.             else {

    2966. 

  2966.                 $eventFromDate=date("Y-m-d");

    2967. 

  2967.                 $urlfromdate  = $_REQUEST['inpdatefrom'];

    2968. 

  2968.             }

    2969. 

  2969. 

    2970. 

  2970.             if($_REQUEST['inpdateto'] && $_REQUEST['inpdateto']!='mm/dd/YY') {

    2971. 

  2971.                 $eventToDate=date("Y-m-d",strtotime($_REQUEST['inpdateto']));

    2972. 

  2972.                 $urltodate  = $_REQUEST['inpdateto'];

    2973. 

  2973.             }

    2974. 

  2974.             else {

    2975. 

  2975.                 $eventToDate=date("Y-m-d");

    2976. 

  2976.                 $urltodate  = $_REQUEST['inpdateto'];

    2977. 

  2977. 

    2978. 

  2978.             }

    2979. 

  2979. 

    2980. 

  2980.             $where.="  AND X.creation between '".$eventFromDate."' and '".$eventToDate."' ";

    2981. 

  2981.             $searchpass = "&inpdatefrom=".$urlfromdate."&inpdateto=".$urltodate ;

    2982. 

  2982.         }

    2983. 

  2983. 

    2984. 

  2984.         $this->set('searchpass',$where);

    2985. 

  2985. 

    2986. 

  2986. 

    2987. 

  2987. 

    2988. 

  2988.         $others=" group by X.id ";

    2989. 

  2989. 

    2990. 

  2990.         if($viewSearchType=='title')

    2991. 

  2991.             $others .=" order by X.title desc ";

    2992. 

  2992. 

    2993. 

  2993.         if($viewSearchType=='prodid')

    2994. 

  2994.             $others .=" order by X.ssn_id  desc ";

    2995. 

  2995. 

    2996. 

  2996.         if($viewSearchType=='daterange')

    2997. 

  2997.             $others .=" order by X.creation desc ";

    2998. 

  2998. 

    2999. 

  2999.         if($viewSearchType=='ticket')

    3000. 

  3000.             $others .=" order by Ticket.ticket_number desc ";

    3001. 

  3001. 

    3002. 

  3002.         $PassParameter ='';

    3003. 

  3003.         if($viewSearchType!='') {

    3004. 

  3004.             $PassParameter="hfsearch=".$viewSearchType.$searchpass;

    3005. 

  3005.         }

    3006. 

  3006. 

    3007. 

  3007. 

    3008. 

  3008.         $CountField="X.id";

    3009. 

  3009.         $this->set("controller","creativezones");

    3010. 

  3010.         $this->set("action","reject");

    3011. 

  3011.         $this->set("parameter",$PassParameter);

    3012. 

  3012. 

    3013. 

  3013.         $quantityAllowSell = $this->getConfigAmount('creative quantity sold');

    3014. 

  3014.         $this->set('quantityAllowSell',$quantityAllowSell['config_value']);

    3015. 

  3015. 

    3016. 

  3016.         $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);

    3017. 

  3017.         if(isset($this->params['url']['Page']) || $viewSearchType!='') {

    3018. 

  3018.             $this->render("approve_search","ajax");

    3019. 

  3019.         }

    3020. 

  3020. 

    3021. 

  3021.         /**/

    3022. 

  3022. 

    3023. 

  3023. 

    3024. 

  3024.         $this->creativeType();

    3025. 

  3025.         $this->countFavCart();

    3026. 

  3026.         $this->getPublicScrap();

    3027. 

  3027.     }

    3028. 

  3028. 

    3029. 

  3029.     function submission() {

    3030. 

  3030.         $this->checkSession();

    3031. 

  3031.         $this->layout = 'creativeinner';

    3032. 

  3032. 

    3033. 

  3033.         $viewSearchType = '';

    3034. 

  3034. 

    3035. 

  3035.         if((isset($this->params['url']['hfsearch']) && $this->params['url']['hfsearch']!='') || isset($_REQUEST['hfsearch']) )

    3036. 

  3036.             $viewSearchType=$_REQUEST['hfsearch'];

    3037. 

  3037. 

    3038. 

  3038. 

    3039. 

  3039. 

    3040. 

  3040.         ############################### Page Title  & Head ############################

    3041. 

  3041.         $this->pageTitle = 'ScrapFOTO&trade; '.'Submisson';

    3042. 

  3042.         $this->set('pagehead','Submisson');

    3043. 

  3043. 

    3044. 

  3044.         ############################### Page Title  & Head ############################

    3045. 

  3045.         /* Pagination and PHOTO listing */

    3046. 

  3046.         $select = " Select X.is_featured,X.fileThumb2 as template_img,X.price,X.viewed,X.ssn_id,X.width,X.height,X.id,X.creation,X.user_id,X.title,XCreativetype.creative_name ,XCreativetype.id as creativetypeid,  X.description,Xuser.username ,COUNT(Xcomment.id) as photoreview ,  Xuserdetail.user_profile_img , IFNULL(ROUND(AVG(Xrating.vote),0),0) as photorat

    3047. 

  3047.                     , X.creation, X.is_stop_sell,Ticket.msg_to_user,X.num_sell,X.is_approved,Ticket.ticket_number";

    3048. 

  3048. 

    3049. 

  3049.         $from=" FROM creative_favorites X

    3050. 

  3050.                                 LEFT JOIN creative_tickets Ticket ON X.id = Ticket.creative_favorites_id

    3051. 

  3051. 				LEFT JOIN creative_type XCreativetype ON X.creative_type_id = XCreativetype.id

    3052. 

  3052. 

    3053. 

  3053. 				LEFT JOIN creative_favorite_comments Xcomment ON X.id = Xcomment.creative_favorite_id

    3054. 

  3054. 				LEFT JOIN users Xuser ON  X.user_id = Xuser.id

    3055. 

  3055. 				LEFT JOIN user_details Xuserdetail ON X.user_id = Xuserdetail.user_id

    3056. 

  3056. 				LEFT JOIN creative_favorite_voting Xrating ON X.id = Xrating.creative_favorite_id";

    3057. 

  3057. 

    3058. 

  3058.         $where=" WHERE X.user_id='".$_SESSION['UserId']."' AND  X.is_blocked='0' AND X.is_temp='0' AND X.type='0' AND X.is_approved='0' ";

    3059. 

  3059. 

    3060. 

  3060. 

    3061. 

  3061.         $searchpass='';

    3062. 

  3062.         if($viewSearchType=='title' && isset($_REQUEST['txtsrch']) && $_REQUEST['txtsrch']!='') {

    3063. 

  3063.             $where.="  AND X.title like '%".$_REQUEST['txtsrch']."%' ";

    3064. 

  3064.             $searchpass = "&txtsrch=".$_REQUEST['txtsrch'] ;

    3065. 

  3065.         }

    3066. 

  3066. 

    3067. 

  3067.         if($viewSearchType=='prodid') {

    3068. 

  3068.             $where.="  AND X.ssn_id like '%".$_REQUEST['txtsrch']."%'";

    3069. 

  3069.             $searchpass = "&txtsrch=".$_REQUEST['txtsrch'] ;

    3070. 

  3070.         }

    3071. 

  3071. 

    3072. 

  3072.         if($viewSearchType=='ticket') {

    3073. 

  3073.             $where.="  AND Ticket.ticket_number like '%".$_REQUEST['txtsrch']."%'";

    3074. 

  3074.             $searchpass = "&txtsrch=".$_REQUEST['txtsrch'] ;

    3075. 

  3075.         }

    3076. 

  3076. 

    3077. 

  3077.         if($viewSearchType=='daterange') {

    3078. 

  3078.             if($_REQUEST['inpdatefrom'] && $_REQUEST['inpdatefrom']!='mm/dd/YY') {

    3079. 

  3079.                 $eventFromDate=date("Y-m-d",strtotime($_REQUEST['inpdatefrom']));

    3080. 

  3080.                 $urlfromdate  = $_REQUEST['inpdatefrom'];

    3081. 

  3081.             }

    3082. 

  3082.             else {

    3083. 

  3083.                 $eventFromDate=date("Y-m-d");

    3084. 

  3084.                 $urlfromdate  = $_REQUEST['inpdatefrom'];

    3085. 

  3085.             }

    3086. 

  3086. 

    3087. 

  3087.             if($_REQUEST['inpdateto'] && $_REQUEST['inpdateto']!='mm/dd/YY') {

    3088. 

  3088.                 $eventToDate=date("Y-m-d",strtotime($_REQUEST['inpdateto']));

    3089. 

  3089.                 $urltodate  = $_REQUEST['inpdateto'];

    3090. 

  3090.             }

    3091. 

  3091.             else {

    3092. 

  3092.                 $eventToDate=date("Y-m-d");

    3093. 

  3093.                 $urltodate  = $_REQUEST['inpdateto'];

    3094. 

  3094. 

    3095. 

  3095.             }

    3096. 

  3096. 

    3097. 

  3097.             $where.="  AND X.creation between '".$eventFromDate."' and '".$eventToDate."' ";

    3098. 

  3098.             $searchpass = "&inpdatefrom=".$urlfromdate."&inpdateto=".$urltodate ;

    3099. 

  3099.         }

    3100. 

  3100. 

    3101. 

  3101.         $this->set('searchpass',$where);

    3102. 

  3102. 

    3103. 

  3103. 

    3104. 

  3104. 

    3105. 

  3105.         $others=" group by X.id ";

    3106. 

  3106. 

    3107. 

  3107.         if($viewSearchType=='title')

    3108. 

  3108.             $others .=" order by X.title desc ";

    3109. 

  3109. 

    3110. 

  3110.         if($viewSearchType=='prodid')

    3111. 

  3111.             $others .=" order by X.ssn_id  desc ";

    3112. 

  3112. 

    3113. 

  3113.         if($viewSearchType=='daterange')

    3114. 

  3114.             $others .=" order by X.creation desc ";

    3115. 

  3115. 

    3116. 

  3116.         if($viewSearchType=='ticket')

    3117. 

  3117.             $others .=" order by Ticket.ticket_number desc ";

    3118. 

  3118. 

    3119. 

  3119.         $PassParameter ='';

    3120. 

  3120.         if($viewSearchType!='') {

    3121. 

  3121.             $PassParameter="hfsearch=".$viewSearchType.$searchpass;

    3122. 

  3122.         }

    3123. 

  3123. 

    3124. 

  3124. 

    3125. 

  3125.         $CountField="X.id";

    3126. 

  3126.         $this->set("controller","creativezones");

    3127. 

  3127.         $this->set("action","submission");

    3128. 

  3128.         $this->set("parameter",$PassParameter);

    3129. 

  3129. 

    3130. 

  3130.         $quantityAllowSell = $this->getConfigAmount('creative quantity sold');

    3131. 

  3131.         $this->set('quantityAllowSell',$quantityAllowSell['config_value']);

    3132. 

  3132. 

    3133. 

  3133.         $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);

    3134. 

  3134.         if(isset($this->params['url']['Page']) || $viewSearchType!='') {

    3135. 

  3135.             $this->render("approve_search","ajax");

    3136. 

  3136.         }

    3137. 

  3137. 

    3138. 

  3138.         /**/

    3139. 

  3139. 

    3140. 

  3140. 

    3141. 

  3141.         $this->creativeType();

    3142. 

  3142.         $this->countFavCart();

    3143. 

  3143.         $this->getPublicScrap();

    3144. 

  3144.     }

    3145. 

  3145. 

    3146. 

  3146.     function approve_msg($id,$is_cancel=null) {

    3147. 

  3147.         $this->set('id',$id);

    3148. 

  3148.         $this->set('is_cancel',$is_cancel);

    3149. 

  3149.         if($is_cancel==null) {

    3150. 

  3150.             $tt = $this->Creative_tickets->findByCreative_favorites_id($id);

    3151. 

  3151.             $this->set('msg',$tt['Creative_tickets']['msg_to_user']);

    3152. 

  3152.         }

    3153. 

  3153. 

    3154. 

  3154.     }

    3155. 

  3155.     function approve_stop_sell($id,$is_stop_sell) {

    3156. 

  3156.         $fav = $this->Creative_favorites->findById($id);

    3157. 

  3157.         if($fav) {

    3158. 

  3158.             $fav['is_stop_sell'] = $is_stop_sell;

    3159. 

  3159.             $this->Creative_favorites->save();

    3160. 

  3160.         }

    3161. 

  3161. 

    3162. 

  3162.         $this->set('id',$id);

    3163. 

  3163.         $this->set('is_stop_sell',$is_stop_sell);

    3164. 

  3164. 

    3165. 

  3165.         $this->render("approve_stop_sell","ajax");

    3166. 

  3166.     }

    3167. 

  3167.     function approve_feature($id,$is_cancel=null) {

    3168. 

  3168.         $this->set('id',$id);

    3169. 

  3169.         $this->set('is_cancel',$is_cancel);

    3170. 

  3170.         if($is_cancel==null) {

    3171. 

  3171.             $featuredAmount=$this->getConfigAmount('creative featured');

    3172. 

  3172.             $this->set('totalAmount',$featuredAmount['config_value']);

    3173. 

  3173. 

    3174. 

  3174.             $featuredDay=$this->getConfigAmount('creative featured days');

    3175. 

  3175.             $this->set('featuredDay',$featuredDay['config_value']);

    3176. 

  3176. 

    3177. 

  3177.             //payment details

    3178. 

  3178.             $sellerId = 1;// that means payment will go to the admin paymenbt id

    3179. 

  3179.             $fetchAdminPaymentSetup=$this->getPaymentMethods($sellerId);

    3180. 

  3180.             $this->set("paymentMethods",$fetchAdminPaymentSetup);

    3181. 

  3181.             $this->set("sellerId",$sellerId);

    3182. 

  3182.         }

    3183. 

  3183.     }

    3184. 

  3184. 

    3185. 

  3185.     function approve_set_price($id,$is_cancel=null) {

    3186. 

  3186.         $this->set('id',$id);

    3187. 

  3187.         $this->set('is_cancel',$is_cancel);

    3188. 

  3188.         if($is_cancel==null) {

    3189. 

  3189.             if($this->data) {

    3190. 

  3190.                 $fav = $this->Creative_favorites->findById($id);

    3191. 

  3191.                 $fav['Creative_favorites']['price'] = $this->data['creativezones']['price'];

    3192. 

  3192.                 $this->Creative_favorites->save($fav);

    3193. 

  3193.             }else {

    3194. 

  3194.                 $fav = $this->Creative_favorites->findById($id);

    3195. 

  3195.             }

    3196. 

  3196.             $this->set('price',$fav['Creative_favorites']['price']);

    3197. 

  3197. 

    3198. 

  3198.         }

    3199. 

  3199.     }

    3200. 

  3200. 

    3201. 

  3201.     function mysales() {

    3202. 

  3202.         $this->checkSession();

    3203. 

  3203.         $this->layout = 'creativemysales';

    3204. 

  3204. 

    3205. 

  3205.         $viewSearchType = '';

    3206. 

  3206. 

    3207. 

  3207.         if((isset($this->params['url']['hfsearch']) && $this->params['url']['hfsearch']!='') || isset($_REQUEST['hfsearch']) )

    3208. 

  3208.             $viewSearchType=$_REQUEST['hfsearch'];

    3209. 

  3209. 

    3210. 

  3210. 

    3211. 

  3211. 

    3212. 

  3212.         ############################### Page Title  & Head ############################

    3213. 

  3213.         $this->pageTitle = 'ScrapFOTO&trade; '.'My Sales';

    3214. 

  3214.         $this->set('pagehead','My Sales');

    3215. 

  3215. 

    3216. 

  3216. 

    3217. 

  3217. 

    3218. 

  3218.         /* Pagination and PHOTO listing */

    3219. 

  3219.         $select = "SELECT X.id, X.ssn_id, X.title, X.creative_type_id, X.width, X.height, X.fileThumb2, X.viewed,X1.user_id AS buyer_id, X1.id AS creative_favorite_buyer, DT.creative_cart_id, TC.total_amount, TC.invoice, TC.trandate, 

    3220. 

  3220.                         TC.transaction_fee,TC.is_pay_transaction_fee

    3221. 

  3221.                     ";

    3222. 

  3222. 

    3223. 

  3223.         $from=" FROM creative_favorites X

    3224. 

  3224.                     RIGHT JOIN creative_favorites X1 ON ( X.ssn_id = X1.ssn_id AND X1.is_republished = '0')

    3225. 

  3225.                     RIGHT JOIN creative_cart_details DT ON ( X1.id = DT.creative_favorite_id )

    3226. 

  3226.                     RIGHT JOIN creative_carts C ON ( C.id = DT.creative_cart_id  AND C.pay_status = '1' )

    3227. 

  3227.                     RIGHT JOIN transaction_creatives TC ON ( C.transaction_creative_id = TC.id AND TC.pay_status='1' )

    3228. 

  3228.                     ";

    3229. 

  3229. 

    3230. 

  3230.         $where=" WHERE X.user_id='".$_SESSION['UserId']."' AND X.is_temp='0' AND X.type='0' AND X.is_republished = '1' ";

    3231. 

  3231. 

    3232. 

  3232. 

    3233. 

  3233. 

    3234. 

  3234.         $searchpass='';

    3235. 

  3235.         if($viewSearchType=='within' && (isset($_REQUEST['within']) && $_REQUEST['within']!='' )  ) {

    3236. 

  3236.             $withinType=$_REQUEST['within'];

    3237. 

  3237.             $week=date("Y-m-d G:i:s",mktime(date("G"),date("i"),date("s"),date("m"),(date("d")-7),date("Y")));

    3238. 

  3238.             $month=date("Y-m-d G:i:s",mktime(date("G"),date("i"),date("s"),(date("m")-1),date("d"),date("Y")));

    3239. 

  3239.             $year=date("Y-m-d G:i:s",mktime(date("G"),date("i"),date("s"),date("m"),date("d"),(date("Y")-1)));

    3240. 

  3240.             $date=date("Y-m-d G:i:s");

    3241. 

  3241. 

    3242. 

  3242.             if($withinType=="past") {

    3243. 

  3243.                 $curDate=$date;

    3244. 

  3244.             }

    3245. 

  3245. 

    3246. 

  3246.             if($withinType=="week") {

    3247. 

  3247.                 $past=$week;

    3248. 

  3248.                 $curDate=$date;

    3249. 

  3249.             }

    3250. 

  3250. 

    3251. 

  3251.             if($withinType=="month") {

    3252. 

  3252.                 $past=$month;

    3253. 

  3253.                 $curDate=$date;

    3254. 

  3254.             }

    3255. 

  3255. 

    3256. 

  3256.             if($withinType=="year") {

    3257. 

  3257.                 $past=$year;

    3258. 

  3258.                 $curDate=$date;

    3259. 

  3259.             }

    3260. 

  3260.             

    3261. 

  3261.             if($withinType=="past")

    3262. 

  3262.                 $where.=" AND TC.trandate<'".$curDate."'";

    3263. 

  3263.             else

    3264. 

  3264.                 $where.=" AND TC.trandate BETWEEN '".$past."' AND '".$curDate."'";

    3265. 

  3265.             

    3266. 

  3266.             $searchpass = "&within=".$withinType ;

    3267. 

  3267.         }

    3268. 

  3268. 

    3269. 

  3269.         if($viewSearchType=='daterange') {

    3270. 

  3270.             if(isset($_REQUEST['sdatefrom']) && $_REQUEST['sdatefrom']!='mm/dd/YY') {

    3271. 

  3271.                 $eventFromDate=date("Y-m-d",strtotime($_REQUEST['sdatefrom']));

    3272. 

  3272.                 $urlfromdate  = $_REQUEST['sdatefrom'];

    3273. 

  3273.             }

    3274. 

  3274.             else {

    3275. 

  3275.                 $eventFromDate=date("Y-m-d");

    3276. 

  3276.                 $urlfromdate  = $_REQUEST['sdatefrom'];

    3277. 

  3277.             }

    3278. 

  3278. 

    3279. 

  3279.             if(isset($_REQUEST['sdateto']) && $_REQUEST['sdateto']!='mm/dd/YY') {

    3280. 

  3280.                 $eventToDate=date("Y-m-d",strtotime($_REQUEST['sdateto']));

    3281. 

  3281.                 $urltodate  = $_REQUEST['sdateto'].' 23:59:59';

    3282. 

  3282.             }

    3283. 

  3283.             else {

    3284. 

  3284.                 $eventToDate=date("Y-m-d");

    3285. 

  3285.                 $urltodate  = $_REQUEST['sdateto'].' 23:59:59';

    3286. 

  3286.             }

    3287. 

  3287. 

    3288. 

  3288.             $where.="  AND TC.trandate BETWEEN '".$eventFromDate."' AND '".$eventToDate."' ";

    3289. 

  3289.             $searchpass = "&sdatefrom=".$urlfromdate."&sdateto=".$urltodate ;

    3290. 

  3290.         }

    3291. 

  3291. 

    3292. 

  3292.         if($viewSearchType=='advance') {

    3293. 

  3293.             if(isset($_REQUEST['prodid']) && $_REQUEST['prodid']!='') {

    3294. 

  3294.                 $where.="  AND X.ssn_id like '%".$_REQUEST['prodid']."%' ";

    3295. 

  3295.                 $searchpass .= "&prodid=".$_REQUEST['prodid'] ;

    3296. 

  3296.             }

    3297. 

  3297.             if(isset($_REQUEST['invoice']) && $_REQUEST['invoice']!='') {

    3298. 

  3298.                 $where.="  AND TC.invoice like '%".$_REQUEST['invoice']."%' ";

    3299. 

  3299.                 $searchpass .= "&invoice=".$_REQUEST['invoice'] ;

    3300. 

  3300.             }            

    3301. 

  3301. 

    3302. 

  3302.             if(isset($_REQUEST['adatefrom']) && $_REQUEST['adatefrom']!='mm/dd/YY') {

    3303. 

  3303.                 $eventFromDate=date("Y-m-d",strtotime($_REQUEST['adatefrom']));

    3304. 

  3304.                 $urlfromdate  = $_REQUEST['adatefrom'];

    3305. 

  3305.             }

    3306. 

  3306.             else {

    3307. 

  3307.                 $eventFromDate=date("Y-m-d");

    3308. 

  3308.                 $urlfromdate  = $_REQUEST['adatefrom'];

    3309. 

  3309.             }

    3310. 

  3310. 

    3311. 

  3311.             if(isset($_REQUEST['adateto']) && $_REQUEST['adateto']!='mm/dd/YY') {

    3312. 

  3312.                 $eventToDate=date("Y-m-d",strtotime($_REQUEST['adateto']));

    3313. 

  3313.                 $urltodate  = $_REQUEST['adateto'].' 23:59:59';

    3314. 

  3314.             }

    3315. 

  3315.             else {

    3316. 

  3316.                 $eventToDate=date("Y-m-d");

    3317. 

  3317.                 $urltodate  = $_REQUEST['adateto'].' 23:59:59';

    3318. 

  3318.             }

    3319. 

  3319. 

    3320. 

  3320.             if(isset($_REQUEST['adatefrom']) && isset($_REQUEST['adateto']) && $_REQUEST['adatefrom']!='mm/dd/YY' && $_REQUEST['adateto']!='mm/dd/YY'){

    3321. 

  3321.                 $where.="  AND TC.trandate BETWEEN '".$eventFromDate."' AND '".$eventToDate."' ";

    3322. 

  3322.                 $searchpass .= "&adatefrom=".$urlfromdate."&adateto=".$urltodate ;

    3323. 

  3323.             }

    3324. 

  3324.              

    3325. 

  3325.             

    3326. 

  3326.         }

    3327. 

  3327. 

    3328. 

  3328.         $this->set('searchpass',$where);

    3329. 

  3329. 

    3330. 

  3330.         //calculator total sell

    3331. 

  3331.         $sqltotal= 'SELECT SUM(TC.total_amount) as total_sell '.$from.$where.'';

    3332. 

  3332.         $result = mysql_query($sqltotal);

    3333. 

  3333.         $row = mysql_fetch_array($result);

    3334. 

  3334.         $this->set('total_sell',$row['total_sell']);

    3335. 

  3335. 

    3336. 

  3336.         $others=" order by TC.trandate desc ";       

    3337. 

  3337.         

    3338. 

  3338.         $PassParameter ='';

    3339. 

  3339.         if($viewSearchType!='') {

    3340. 

  3340.             $PassParameter="hfsearch=".$viewSearchType.$searchpass;

    3341. 

  3341.         }

    3342. 

  3342. 

    3343. 

  3343. 

    3344. 

  3344.         $CountField="X.id";

    3345. 

  3345.         $this->set("controller","creativezones");

    3346. 

  3346.         $this->set("action","mysales");

    3347. 

  3347.         $this->set("parameter",$PassParameter);

    3348. 

  3348. 

    3349. 

  3349.         $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);

    3350. 

  3350.         if(isset($this->params['url']['Page']) || $viewSearchType!='') {

    3351. 

  3351.             $this->render("mysales_search","ajax");

    3352. 

  3352.         }

    3353. 

  3353. 

    3354. 

  3354.         /**/

    3355. 

  3355. 

    3356. 

  3356. 

    3357. 

  3357.         $this->creativeType();

    3358. 

  3358.         $this->countFavCart();

    3359. 

  3359.         $this->getPublicScrap();

    3360. 

  3360.     }

    3361. 

  3361. 

    3362. 

  3362.     function mysales_transaction_fee($invoice,$is_cancel=null) {

    3363. 

  3363.         $this->set('id',$invoice);

    3364. 

  3364.         $this->set('is_cancel',$is_cancel);

    3365. 

  3365.         if($is_cancel==null) {

    3366. 

  3366.             $tc = $this->Transaction_creatives->findByInvoice($invoice);

    3367. 

  3367.             $this->set('totalAmount',$tc['Transaction_creatives']['transaction_fee']);

    3368. 

  3368. 

    3369. 

  3369.             //payment details

    3370. 

  3370.             $sellerId = 1;// that means payment will go to the admin paymenbt id

    3371. 

  3371.             $fetchAdminPaymentSetup=$this->getPaymentMethods($sellerId);

    3372. 

  3372.             $this->set("paymentMethods",$fetchAdminPaymentSetup);

    3373. 

  3373.             $this->set("sellerId",$sellerId);

    3374. 

  3374.         }

    3375. 

  3375.     }

    3376. 

  3376. 

    3377. 

  3377.     function mysales_product_detail($invoice,$ssn_id,$is_cancel=null) {

    3378. 

  3378.         $this->set('id',$invoice);

    3379. 

  3379.         $this->set('is_cancel',$is_cancel);

    3380. 

  3380.         $this->set('ssn_id',$ssn_id);

    3381. 

  3381.         if($is_cancel==null) {

    3382. 

  3382.             $fav = $this->Creative_favorites->findBySsn_id($ssn_id);

    3383. 

  3383.             $this->set('fav',$fav['Creative_favorites']);

    3384. 

  3384.         }

    3385. 

  3385.     }

    3386. 

  3386. 

    3387. 

  3387.     function pagination($select,$from,$where,$others,$CountField,$arg,$PassParameter) {

    3388. 

  3388.         if(isset($arg['Page']))

    3389. 

  3389.             $pageFlag=$arg['Page'];

    3390. 

  3390.         $this->set("PassParameter",$PassParameter);

    3391. 

  3391.         $SetUserNumberOfVpsPerPage=SHOW_REC; /* Defined in config->paths.php*/

    3392. 

  3392. 

    3393. 

  3393.         $this->set("BackgroundClass",'pagination');

    3394. 

  3394.         $this->set("SelectedPage",'pagination_over');

    3395. 

  3395.         $this->set("Linkpage",'pagination_over');

    3396. 

  3396.         $this->set("FirstImage",'fdd.gif');

    3397. 

  3397.         $this->set("PreviousImage",'previous.gif');

    3398. 

  3398.         $this->set("NextImage",'next.gif');

    3399. 

  3399.         $this->set("LastImage",'rewd.gif');

    3400. 

  3400. 

    3401. 

  3401.         $UserNumberOfVpsPerPage=4; /* Defined in config->paths.php*/

    3402. 

  3402.         if(!is_numeric($UserNumberOfVpsPerPage)|| (intval($UserNumberOfVpsPerPage)!=$UserNumberOfVpsPerPage)||($UserNumberOfVpsPerPage<=0))

    3403. 

  3403.             $UserNumberOfVpsPerPage = $SetUserNumberOfVpsPerPage;

    3404. 

  3404. 

    3405. 

  3405.         if(!isset($arg['Page'])) $arg['Page']=1;

    3406. 

  3406.         if(!isset($arg['Offset'])) $arg['Offset']=0;

    3407. 

  3407.         $Query_ForNumber_Records=mysql_query("$select $from $where $others") or die('Line no 120' . mysql_error());

    3408. 

  3408.         //$Result_Query_ForNumber_Records=mysql_fetch_object($Query_ForNumber_Records);

    3409. 

  3409. 

    3410. 

  3410.         //$NoOfVps=$Result_Query_ForNumber_Records->NoOfVps;

    3411. 

  3411.         $NoOfVps=mysql_num_rows($Query_ForNumber_Records);

    3412. 

  3412. 

    3413. 

  3413.         $NumberOfVpsPerPage=$UserNumberOfVpsPerPage;

    3414. 

  3414.         $NoOfPages=ceil($NoOfVps/$NumberOfVpsPerPage);	//3

    3415. 

  3415.         if($arg['Offset']==$NoOfVps) {

    3416. 

  3416.             if(isset($Offset)) {

    3417. 

  3417.                 $Offset=$Offset-$NumberOfVpsPerPage;

    3418. 

  3418.                 $Page--;

    3419. 

  3419.                 if($Offset<0) {

    3420. 

  3420.                     $Offset=0;

    3421. 

  3421.                     $Page=1;

    3422. 

  3422.                 }

    3423. 

  3423.             }else {

    3424. 

  3424.                 $Offset=0;

    3425. 

  3425.                 $Page=1;

    3426. 

  3426.             }

    3427. 

  3427.         }

    3428. 

  3428. 

    3429. 

  3429.         $this->set("Page",$arg['Page']);

    3430. 

  3430.         $this->set("Offset",$arg['Offset']);

    3431. 

  3431.         $this->set("NumberOfVpsPerPage",$NumberOfVpsPerPage);

    3432. 

  3432.         $this->set("NoOfPages",$NoOfPages);

    3433. 

  3433.         $this->set("UserNumberOfVpsPerPage",$UserNumberOfVpsPerPage);

    3434. 

  3434. 

    3435. 

  3435.         //print "$select $from $where $others";

    3436. 

  3436.         $this->set("qryOthr","$select $from $where $others");

    3437. 

  3437. 

    3438. 

  3438.         $SelectRecord = mysql_query("$select $from $where $others LIMIT ".$arg['Offset'].",$NumberOfVpsPerPage") or die('Line no '.__LINE__ . mysql_error());

    3439. 

  3439.         $this->set("query",$SelectRecord);

    3440. 

  3440. 

    3441. 

  3441.     }

    3442. 

  3442. 

    3443. 

  3443.     function sales() {

    3444. 

  3444.         $this->checkSession();

    3445. 

  3445.         $this->pageTitle = 'ScrapFOTO&trade; '.'Order History';

    3446. 

  3446.         $this->layout = 'creativemysales';

    3447. 

  3447.         $this->set('pagehead','Order History');

    3448. 

  3448. 

    3449. 

  3449.         $this->creativeType();

    3450. 

  3450.         $this->getRankScrap();

    3451. 

  3451.         $this->getFeaturedScrap();

    3452. 

  3452.         $this->getPublicScrap();

    3453. 

  3453.         $this->countFavCart();

    3454. 

  3454. 

    3455. 

  3455.         $viewSearchType = '';

    3456. 

  3456. 

    3457. 

  3457.         if((isset($this->params['url']['hfsearch']) && $this->params['url']['hfsearch']!='') || isset($_REQUEST['hfsearch']) )

    3458. 

  3458.             $viewSearchType=$_REQUEST['hfsearch'];

    3459. 

  3459. 

    3460. 

  3460.         $select="SELECT TC. * ,TC.id tranId, C. * , GROUP_CONCAT( DISTINCT CONCAT_WS( '-', C.cart_name) ) AS scrapName";

    3461. 

  3461.         $from=" FROM transaction_creatives TC

    3462. 

  3462. 			LEFT JOIN creative_carts C ON ( C.transaction_creative_id = TC.id )";

    3463. 

  3463. 

    3464. 

  3464.         $where=" WHERE TC.user_id = '".$_SESSION['UserId']."' AND TC.pay_status='1' ";

    3465. 

  3465. 

    3466. 

  3466.         $searchpass='';

    3467. 

  3467.         if($viewSearchType=='within' && (isset($_REQUEST['within']) && $_REQUEST['within']!='' )  ) {

    3468. 

  3468.             $withinType=$_REQUEST['within'];

    3469. 

  3469.             $week=date("Y-m-d G:i:s",mktime(date("G"),date("i"),date("s"),date("m"),(date("d")-7),date("Y")));

    3470. 

  3470.             $month=date("Y-m-d G:i:s",mktime(date("G"),date("i"),date("s"),(date("m")-1),date("d"),date("Y")));

    3471. 

  3471.             $year=date("Y-m-d G:i:s",mktime(date("G"),date("i"),date("s"),date("m"),date("d"),(date("Y")-1)));

    3472. 

  3472.             $date=date("Y-m-d G:i:s");

    3473. 

  3473. 

    3474. 

  3474.             if($withinType=="past") {

    3475. 

  3475.                 $curDate=$date;

    3476. 

  3476.             }

    3477. 

  3477. 

    3478. 

  3478.             if($withinType=="week") {

    3479. 

  3479.                 $past=$week;

    3480. 

  3480.                 $curDate=$date;

    3481. 

  3481.             }

    3482. 

  3482. 

    3483. 

  3483.             if($withinType=="month") {

    3484. 

  3484.                 $past=$month;

    3485. 

  3485.                 $curDate=$date;

    3486. 

  3486.             }

    3487. 

  3487. 

    3488. 

  3488.             if($withinType=="year") {

    3489. 

  3489.                 $past=$year;

    3490. 

  3490.                 $curDate=$date;

    3491. 

  3491.             }

    3492. 

  3492. 

    3493. 

  3493.             if($withinType=="past")

    3494. 

  3494.                 $where.=" AND TC.trandate<'".$curDate."'";

    3495. 

  3495.             else

    3496. 

  3496.                 $where.=" AND TC.trandate BETWEEN '".$past."' AND '".$curDate."'";

    3497. 

  3497. 

    3498. 

  3498.             $searchpass = "&within=".$withinType ;

    3499. 

  3499.         }

    3500. 

  3500. 

    3501. 

  3501.         if($viewSearchType=='daterange') {

    3502. 

  3502.             if(isset($_REQUEST['sdatefrom']) && $_REQUEST['sdatefrom']!='mm/dd/YY') {

    3503. 

  3503.                 $eventFromDate=date("Y-m-d",strtotime($_REQUEST['sdatefrom']));

    3504. 

  3504.                 $urlfromdate  = $_REQUEST['sdatefrom'];

    3505. 

  3505.             }

    3506. 

  3506.             else {

    3507. 

  3507.                 $eventFromDate=date("Y-m-d");

    3508. 

  3508.                 $urlfromdate  = $_REQUEST['sdatefrom'];

    3509. 

  3509.             }

    3510. 

  3510. 

    3511. 

  3511.             if(isset($_REQUEST['sdateto']) && $_REQUEST['sdateto']!='mm/dd/YY') {

    3512. 

  3512.                 $eventToDate=date("Y-m-d",strtotime($_REQUEST['sdateto']));

    3513. 

  3513.                 $urltodate  = $_REQUEST['sdateto'].' 23:59:59';

    3514. 

  3514.             }

    3515. 

  3515.             else {

    3516. 

  3516.                 $eventToDate=date("Y-m-d");

    3517. 

  3517.                 $urltodate  = $_REQUEST['sdateto'].' 23:59:59';

    3518. 

  3518.             }

    3519. 

  3519. 

    3520. 

  3520.             $where.="  AND TC.trandate BETWEEN '".$eventFromDate."' AND '".$eventToDate."' ";

    3521. 

  3521.             $searchpass = "&sdatefrom=".$urlfromdate."&sdateto=".$urltodate ;

    3522. 

  3522.         }

    3523. 

  3523. 

    3524. 

  3524.         if($viewSearchType=='advance') {

    3525. 

  3525.             if(isset($_REQUEST['cartname']) && $_REQUEST['cartname']!='') {

    3526. 

  3526.                 $where.="  AND C.cart_name like '%".$_REQUEST['cartname']."%' ";

    3527. 

  3527.                 $searchpass .= "&cartname=".$_REQUEST['cartname'] ;

    3528. 

  3528.             }

    3529. 

  3529.             if(isset($_REQUEST['invoice']) && $_REQUEST['invoice']!='') {

    3530. 

  3530.                 $where.="  AND TC.invoice like '%".$_REQUEST['invoice']."%' ";

    3531. 

  3531.                 $searchpass .= "&invoice=".$_REQUEST['invoice'] ;

    3532. 

  3532.             }

    3533. 

  3533. 

    3534. 

  3534.             if(isset($_REQUEST['adatefrom']) && $_REQUEST['adatefrom']!='mm/dd/YY') {

    3535. 

  3535.                 $eventFromDate=date("Y-m-d",strtotime($_REQUEST['adatefrom']));

    3536. 

  3536.                 $urlfromdate  = $_REQUEST['adatefrom'];

    3537. 

  3537.             }

    3538. 

  3538.             else {

    3539. 

  3539.                 $eventFromDate=date("Y-m-d");

    3540. 

  3540.                 $urlfromdate  = $_REQUEST['adatefrom'];

    3541. 

  3541.             }

    3542. 

  3542. 

    3543. 

  3543.             if(isset($_REQUEST['adateto']) && $_REQUEST['adateto']!='mm/dd/YY') {

    3544. 

  3544.                 $eventToDate=date("Y-m-d",strtotime($_REQUEST['adateto']));

    3545. 

  3545.                 $urltodate  = $_REQUEST['adateto'].' 23:59:59';

    3546. 

  3546.             }

    3547. 

  3547.             else {

    3548. 

  3548.                 $eventToDate=date("Y-m-d");

    3549. 

  3549.                 $urltodate  = $_REQUEST['adateto'].' 23:59:59';

    3550. 

  3550.             }

    3551. 

  3551. 

    3552. 

  3552.             if(isset($_REQUEST['adatefrom']) && isset($_REQUEST['adateto']) && $_REQUEST['adatefrom']!='mm/dd/YY' && $_REQUEST['adateto']!='mm/dd/YY'){

    3553. 

  3553.                 $where.="  AND TC.trandate BETWEEN '".$eventFromDate."' AND '".$eventToDate."' ";

    3554. 

  3554.                 $searchpass .= "&adatefrom=".$urlfromdate."&adateto=".$urltodate ;

    3555. 

  3555.             }

    3556. 

  3556.         }

    3557. 

  3557. 

    3558. 

  3558.         $this->set('searchpass',$where);

    3559. 

  3559.         //calculator total sell

    3560. 

  3560.         $sqltotal= 'SELECT SUM(TC.total_amount) as total_sell '.$from.$where.'';

    3561. 

  3561.         $result = mysql_query($sqltotal);

    3562. 

  3562.         $row = mysql_fetch_array($result);

    3563. 

  3563.         $this->set('total_sell',$row['total_sell']);

    3564. 

  3564. 

    3565. 

  3565.         $others=" GROUP BY TC.id ORDER BY TC.id DESC";

    3566. 

  3566. 

    3567. 

  3567.         $PassParameter ='';

    3568. 

  3568.         if($viewSearchType!='') {

    3569. 

  3569.             $PassParameter="hfsearch=".$viewSearchType.$searchpass;

    3570. 

  3570.         }

    3571. 

  3571. 

    3572. 

  3572. 

    3573. 

  3573.         $CountField="tranId";

    3574. 

  3574.         $this->set("controller","creativezones");

    3575. 

  3575.         $this->set("action","sales");

    3576. 

  3576.         $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);

    3577. 

  3577. 

    3578. 

  3578.         if(isset($this->params['url']['Page']) || $viewSearchType!='') {

    3579. 

  3579.             $this->render("sales2","ajax");

    3580. 

  3580.         }

    3581. 

  3581. 

    3582. 

  3582.     }

    3583. 

  3583. 

    3584. 

  3584.     function getTransactionDetails($transactionId=null) /// Invoice detail

    3585. 

  3585.     {

    3586. 

  3586.         ##################################################### INVOICE DETAILAS ######################

    3587. 

  3587. 

    3588. 

  3588.         $ticketqry =  "

    3589. 

  3589. 					SELECT tranTic.id, tranTic.invoice , tranTic.total_amount , DATE(tranTic.cudate) as saledate , CONCAT(BUYusrdetail.first_name ,' ',BUYusrdetail.last_name) as Buyername ,

    3590. 

  3590. 					BUYusrdetail.address as Buyeraddress ,IFNULL(BUYCITYName.city_name,'--') as Buyercity , IFNULL(BUYstate.Name,'--') as Buyerstatename , BUYcountry.country_name as BUYercountryname , BUYusrdetail.zip as Buyerzip ,

    3591. 

  3591. 					

    3592. 

  3592. 					POSTBYusrdetail.comp_name as PostCompanyname , CONCAT(POSTBYusrdetail.first_name ,' ',POSTBYusrdetail.last_name) as Postname ,POSTBYusrdetail.email as Postemail,IF(POSTBYusrdetail.land_phone <>'',POSTBYusrdetail.land_phone,'--') as Postphonenumber,

    3593. 

  3593. 					POSTBYusrdetail.address as Postaddress ,IFNULL(POSTCITYMaster.city_name,'--') as Postcity , IFNULL(POSTstate.Name,'--') as Poststatename , POSTcountry.country_name as Postcountryname , POSTBYusrdetail.zip as Postzip ,

    3594. 

  3594. 					

    3595. 

  3595. 					Tic.plan_name as Eventname , tranTic.total_amount as Totalamount , MEMPLAN.picture as logoimage , SUM(MEMPLANCART.plan_price*MEMPLANCART.quantity) as TicketTotal

    3596. 

  3596. 					  

    3597. 

  3597. 					

    3598. 

  3598. 					FROM transaction_memberships tranTic

    3599. 

  3599. 					

    3600. 

  3600. 					LEFT JOIN membership_plantype_cart MEMPLANCART ON MEMPLANCART.transaction_membership_id = tranTic.id

    3601. 

  3601. 					

    3602. 

  3602. 					LEFT JOIN membership_plantype MEMPLAN ON (MEMPLANCART.plantype_id = MEMPLAN.plantype_id AND MEMPLANCART.membership_id = MEMPLAN.membership_id)

    3603. 

  3603. 					

    3604. 

  3604. 					LEFT JOIN user_details BUYusrdetail ON MEMPLANCART.user_id = BUYusrdetail.user_id

    3605. 

  3605. 					

    3606. 

  3606. 					LEFT JOIN state BUYstate ON BUYstate.id = BUYusrdetail.state 

    3607. 

  3607. 					LEFT JOIN city_master  BUYCITYName ON BUYCITYName.city_id = BUYusrdetail.city

    3608. 

  3608. 					LEFT JOIN countries BUYcountry ON BUYcountry.id=BUYusrdetail.c_id 

    3609. 

  3609. 				

    3610. 

  3610. 					LEFT JOIN memberships Tic On MEMPLANCART.membership_id=Tic.id 

    3611. 

  3611. 					

    3612. 

  3612. 					LEFT JOIN user_details POSTBYusrdetail ON tranTic.org_id = POSTBYusrdetail.user_id

    3613. 

  3613. 					LEFT JOIN state POSTstate ON POSTstate.id = POSTBYusrdetail.state 

    3614. 

  3614. 					LEFT JOIN city_master POSTCITYMaster ON POSTCITYMaster.city_id = POSTBYusrdetail.city

    3615. 

  3615. 					LEFT JOIN countries POSTcountry ON POSTcountry.id=POSTBYusrdetail.c_id 

    3616. 

  3616. 					

    3617. 

  3617. 					WHERE tranTic.id='".$tranId."' and MEMPLANCART.pay_status='1' AND MEMPLANCART.user_id='".$_SESSION['UserId']."'

    3618. 

  3618. 					AND MEMPLANCART.ssn_id='".session_id()."'

    3619. 

  3619. 					

    3620. 

  3620. 					GROUP BY MEMPLANCART.transaction_membership_id

    3621. 

  3621. 					ORDER BY MEMPLANCART.id ASC

    3622. 

  3622. 					";

    3623. 

  3623. 

    3624. 

  3624. //echo $ticketqry ;

    3625. 

  3625.         $qry=mysql_query($ticketqry) or die("Error on line :".__LINE__.mysql_error());

    3626. 

  3626.         $this->set("q1",$qry);

    3627. 

  3627. 

    3628. 

  3628. 

    3629. 

  3629. 

    3630. 

  3630. 

    3631. 

  3631. ##################################################### INVOICE DETAILAS ######################

    3632. 

  3632. 

    3633. 

  3633.     }

    3634. 

  3634. 

    3635. 

  3635.     function creative_invoice_detail(){

    3636. 

  3636.         $this->layout = "blank";

    3637. 

  3637.         $this->set("tranId",base64_decode($this->params['url']['inv']));

    3638. 

  3638.     }

    3639. 

  3639. 

    3640. 

  3640.     function printscrap(){

    3641. 

  3641.         $this->layout = "blank";

    3642. 

  3642.     }

    3643. 

  3643. 

    3644. 

  3644.     function sendinvoice() {

    3645. 

  3645.         $this->set("urlVars",$this->params['url']);

    3646. 

  3646. 

    3647. 

  3647.         $userDetails=$this->getUserDetails($_SESSION['UserId']);

    3648. 

  3648.         //____________________________________________________MAIL MANAGEMENT________________________________________________

    3649. 

  3649.         //this mailing code is here so that it fires just once.

    3650. 

  3650. 

    3651. 

  3651.         //mail sent to the user personal account

    3652. 

  3652.         $this->Sendmail->Mail();

    3653. 

  3653.         $this->Sendmail->From(FROMMAIL);

    3654. 

  3654. 

    3655. 

  3655.         if(isset($userDetails['email'])){

    3656. 

  3656.             $this->Sendmail->To($userDetails['email']);

    3657. 

  3657. 

    3658. 

  3658.             //$this->Sendmail->Cc("sujoy@navsoft.in");

    3659. 

  3659.             //$this->Sendmail->Cc("amarjit@navsoft.in");

    3660. 

  3660.             //$this->Sendmail->Bcc( "someoneelse@somewhere.fr");

    3661. 

  3661. 

    3662. 

  3662.             $subject="XOimages - Scrapfoto invoice request";

    3663. 

  3663.             $this->Sendmail->Subject($subject);

    3664. 

  3664. 

    3665. 

  3665.             $this->set("tranId",base64_decode($this->params['url']['inv']));

    3666. 

  3666.             $this->Sendmail->layout='email';

    3667. 

  3667.             $this->Sendmail->view='mail_invoicerequest';

    3668. 

  3668.             $this->Sendmail->startup($this);

    3669. 

  3669.             $messageBody=$this->Sendmail->bodyText();

    3670. 

  3670. 

    3671. 

  3671.             $this->Sendmail->Body($messageBody);        // set the body

    3672. 

  3672.             $this->Sendmail->Priority(1) ;        // set the priority to Low

    3673. 

  3673.             $this->Sendmail->Send();        // send the mail

    3674. 

  3674. 

    3675. 

  3675. 

    3676. 

  3676.             //mail sent to the user mail account in the system

    3677. 

  3677. 

    3678. 

  3678.             $sender=1;

    3679. 

  3679.             $receiver=$_SESSION['UserId'];

    3680. 

  3680.             $this->senderMail($sender,$receiver,$subject,$messageBody);

    3681. 

  3681.             $this->receiverMail($receiver,$sender,$subject,$messageBody);

    3682. 

  3682.         }

    3683. 

  3683.         $this->render("invoicesent","ajax");

    3684. 

  3684.     }

    3685. 

  3685.     

    3686. 

  3686. 

    3687. 

  3687. 

    3688. 

  3688.     function createTransactionNumber($pre) {

    3689. 

  3689.         global $db;

    3690. 

  3690.         $id = $pre;

    3691. 

  3691.         $id .= $this->genRandomStringNumbers(10);

    3692. 

  3692. 

    3693. 

  3693.         // check id if exist in db, if not, add

    3694. 

  3694.         if($pre=='SPTT') {

    3695. 

  3695.             $query ="SELECT id FROM creative_tickets WHERE ticket_number ='".$id."'  LIMIT 1";

    3696. 

  3696.         }else {

    3697. 

  3697.             $query ="SELECT id FROM xouser_transactions WHERE invoice ='".$id."'  LIMIT 1";

    3698. 

  3698.         }

    3699. 

  3699. 

    3700. 

  3700.         $result = mysql_query($query);

    3701. 

  3701. 

    3702. 

  3702.         if(mysql_numrows($result) < 1) {

    3703. 

  3703.             return $id;

    3704. 

  3704.         } else {

    3705. 

  3705.             return $this->createTransactionNumber($pre);

    3706. 

  3706.         }

    3707. 

  3707.         return $this->createTransactionNumber($pre);

    3708. 

  3708.     }

    3709. 

  3709.     function genRandomStringNumbers($length) {

    3710. 

  3710.         $characters = 'ABCEFGHIJKLMNOPQRTUVWXYZ1234567890';

    3711. 

  3711.         $string = '';

    3712. 

  3712.         for ($c = 0; $c < $length; $c++) {

    3713. 

  3713.             $string .= substr($characters, mt_rand(0, strlen($characters)-1), 1);

    3714. 

  3714.         }

    3715. 

  3715.         return $string;

    3716. 

  3716.     }

    3717. 

  3717.     function run_cron_job(){

    3718. 

  3718.         if (!defined('CRON_DISPATCHER')) {

    3719. 

  3719.             exit();

    3720. 

  3720.         }else{

    3721. 

  3721.             //check Feature

    3722. 

  3722.             $query = "UPDATE creative_favorites SET is_featured='0' WHERE is_featured='1' AND featured_time<'".date('Y-m-d G:i:s')."'";

    3723. 

  3723.             mysql_query($query);

    3724. 

  3724.             

    3725. 

  3725.             //check transaction fee

    3726. 

  3726. 

    3727. 

  3727.             $day1 = $this->getConfigAmount('creative settlement time1');

    3728. 

  3728.             $day1 = $day1['config_value'];

    3729. 

  3729. 

    3730. 

  3730.             $day2 = $this->getConfigAmount('creative settlement time2');

    3731. 

  3731.             $day2 = $day2['config_value'];

    3732. 

  3732. 

    3733. 

  3733.             if($day1>$day2){

    3734. 

  3734.                 $tmp = $day1;

    3735. 

  3735.                 $day1 = $day2;

    3736. 

  3736.                 $day2 = $tmp;

    3737. 

  3737.             }

    3738. 

  3738. 

    3739. 

  3739.             $cur_day = date('Y-m-d G:i:s');

    3740. 

  3740.             $today = getdate();

    3741. 

  3741.             $day_c = $today['mday'];

    3742. 

  3742. 

    3743. 

  3743.             $emailtime = $this->getConfigAmount('creative reactivation time');

    3744. 

  3744.             $emailtime = $emailtime['config_value'];

    3745. 

  3745.             $numday_month = date('t')+0;

    3746. 

  3746. 

    3747. 

  3747.             $is_send_mail = ($today['mday']%((int)$numday_month/$emailtime)) == 0 ;

    3748. 

  3748. 

    3749. 

  3749.             $this->set('is_send_mail',$is_send_mail);

    3750. 

  3750. 

    3751. 

  3751. 

    3752. 

  3752. 

    3753. 

  3753.             $time1 = $today['year'].'-'.$today['mon'].'-'.$day1.' '.$today['hours'].':'.$today['minutes'].':'.$today['seconds'];

    3754. 

  3754.             $time2 = $today['year'].'-'.$today['mon'].'-'.$day2.' '.$today['hours'].':'.$today['minutes'].':'.$today['seconds'];

    3755. 

  3755.             $compare_date = ($day_c<$day2) ? $time1 : $time2;

    3756. 

  3756. 

    3757. 

  3757.             $sql = "SELECT TC.*,FX.ssn_id, FX.is_blocked  FROM transaction_creatives TC

    3758. 

  3758.                     LEFT JOIN creative_carts C ON (C.transaction_creative_id = TC.id)

    3759. 

  3759.                     LEFT JOIN creative_cart_details CDT ON (CDT.creative_cart_id = C.id)

    3760. 

  3760.                     LEFT JOIN creative_favorites F ON (F.id = CDT.creative_favorite_id)

    3761. 

  3761.                     RIGHT JOIN creative_favorites FX ON (F.ssn_id = FX.ssn_id and FX.is_republished='1')

    3762. 

  3762. 

    3763. 

  3763.                     WHERE TC.transaction_fee>0 AND TC.is_pay_transaction_fee='0'";

    3764. 

  3764.             $result = mysql_query($sql);

    3765. 

  3765. 

    3766. 

  3766.             $arr = array();

    3767. 

  3767. 

    3768. 

  3768.             while($row=mysql_fetch_assoc($result)){

    3769. 

  3769.                 $trandate = $row['trandate'];

    3770. 

  3770.                 $tmpdate = new DateTime($trandate);

    3771. 

  3771.                 if($tmpdate->format('d')>$day2){

    3772. 

  3772.                     $tmpdate->modify('+1 month');

    3773. 

  3773.                     $pay_date = $tmpdate->format('Y').'-'.$tmpdate->format('m').'-'.$day1.' '.$tmpdate->format('G').':'.$tmpdate->format('i').':'.$tmpdate->format('s');

    3774. 

  3774.                 }else{

    3775. 

  3775.                     $pay_date = $tmpdate->format('Y').'-'.$tmpdate->format('m').'-'.$day2.' '.$tmpdate->format('G').':'.$tmpdate->format('i').':'.$tmpdate->format('s');

    3776. 

  3776.                 }

    3777. 

  3777. 

    3778. 

  3778.                 $due_day = (strtotime($trandate)<strtotime($compare_date)) ? (int)((strtotime($cur_day)-strtotime($pay_date))/(24*60*60)) : 0;

    3779. 

  3779.                 if($due_day>0){

    3780. 

  3780.                     if(isset($arr[$row['seller_id']]))

    3781. 

  3781.                         $arr[$row['seller_id']]['due_amount'] += $row['transaction_fee'];

    3782. 

  3782.                     else{

    3783. 

  3783.                         $arr[$row['seller_id']]['due_amount'] = $row['transaction_fee'];

    3784. 

  3784.                         $arr[$row['seller_id']]['due_day'] = $due_day;

    3785. 

  3785.                         $arr[$row['seller_id']]['ids'] = array();                        

    3786. 

  3786.                     }

    3787. 

  3787.                     $arr[$row['seller_id']]['ids'][$row['ssn_id']]=$row['ssn_id'];

    3788. 

  3788. 

    3789. 

  3789.                     if($due_day>$arr[$row['seller_id']]['due_day'])

    3790. 

  3790.                         $arr[$row['seller_id']]['due_day'] = $due_day;

    3791. 

  3791.                 }

    3792. 

  3792.             }

    3793. 

  3793. 

    3794. 

  3794.             $blockId = array();

    3795. 

  3795.             foreach($arr as $key=>$value){

    3796. 

  3796.                 $blockId = array_merge($blockId, $value['ids']);

    3797. 

  3797.                 //check sendmail

    3798. 

  3798.                 if($is_send_mail)

    3799. 

  3799.                     $this->mail_reactivation($key,$value['due_amount'],$value['due_day']);

    3800. 

  3800. 

    3801. 

  3801.                 $sql = "UPDATE user_payment_setup SET is_blocked='1' WHERE user_id='$key' ";

    3802. 

  3802.                 mysql_query($sql);

    3803. 

  3803.             }

    3804. 

  3804. 

    3805. 

  3805.             if(count($blockId)>0){

    3806. 

  3806.                 $sql = "UPDATE creative_favorites SET is_blocked='1' WHERE ssn_id IN ('".join("', '", $blockId)."') AND is_republished='1' ";

    3807. 

  3807.                 mysql_query($sql);

    3808. 

  3808.             }

    3809. 

  3809.         }

    3810. 

  3810.     }

    3811. 

  3811. 

    3812. 

  3812.     function mail_reactivation($user_id,$due_amount,$due_day){

    3813. 

  3813.         $userDetails=$this->getUserDetails($user_id);

    3814. 

  3814.         //____________________________________________________MAIL MANAGEMENT________________________________________________

    3815. 

  3815.         //this mailing code is here so that it fires just once.

    3816. 

  3816. 

    3817. 

  3817.         //mail sent to the user personal account

    3818. 

  3818.         if(isset($userDetails['email'])){

    3819. 

  3819.             $this->Sendmail->Mail();

    3820. 

  3820.             $this->Sendmail->From(FROMMAIL);

    3821. 

  3821.             $this->Sendmail->To($userDetails['email']);

    3822. 

  3822. 

    3823. 

  3823.             $subject="XOimages Reactivation Notification";

    3824. 

  3824.             $this->Sendmail->Subject($subject);

    3825. 

  3825. 

    3826. 

  3826.             $this->set('user_id',$user_id);

    3827. 

  3827.             $this->set('due_amount',$due_amount);

    3828. 

  3828.             $this->set('due_day',$due_day);

    3829. 

  3829. 

    3830. 

  3830.             $this->Sendmail->layout='email';

    3831. 

  3831.             $this->Sendmail->view='mail_reactivation';

    3832. 

  3832.             $this->Sendmail->startup($this);

    3833. 

  3833.             $messageBody=$this->Sendmail->bodyText();

    3834. 

  3834. 

    3835. 

  3835.             $this->Sendmail->Body($messageBody);        // set the body

    3836. 

  3836.             $this->Sendmail->Priority(1) ;        // set the priority to Low            

    3837. 

  3837.             $this->Sendmail->Send();        // send the mail

    3838. 

  3838. 

    3839. 

  3839. 

    3840. 

  3840.             //mail sent to the user mail account in the system

    3841. 

  3841.             $sender=1;

    3842. 

  3842.             $receiver=$user_id;

    3843. 

  3843.             $this->senderMail($sender,$receiver,$subject,$messageBody);

    3844. 

  3844.             $this->receiverMail($receiver,$sender,$subject,$messageBody);

    3845. 

  3845. 

    3846. 

  3846.             $this->Sendmail->__destruct();

    3847. 

  3847.         }

    3848. 

  3848.     }

    3849. 

  3849. 

    3850. 

  3850. }

    3851. 

  3851. ?>
    3852.