PageRenderTime 37ms CodeModel.GetById 23ms RepoModel.GetById 1ms app.codeStats 0ms

/app/controllers/creativezones_controller.php

https://bitbucket.org/fxrialab/spsp_editor
PHP | 3440 lines | 2286 code | 611 blank | 543 comment | 357 complexity | 7bc5db9c1b1ac3373b45675c96c20fc1 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.     //ok

    9. 

  9.     function index() {

    10. 

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

    11. 

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

    12. 

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

    13. 

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

    14. 

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

    15. 

  15. 

    16. 

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

    17. 

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

    18. 

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

    19. 

  19. 

    20. 

  20.         //_________________________________________________________________________________________________

    21. 

  21. 

    22. 

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

    23. 

  23.         //check  creative_carts

    24. 

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

    25. 

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

    26. 

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

    27. 

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

    28. 

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

    29. 

  29. 

    30. 

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

    31. 

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

    32. 

  32.                 //delete cart

    33. 

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

    34. 

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

    35. 

  35.                 }

    36. 

  36.             }

    37. 

  37. 

    38. 

  38.             //check delete favorite

    39. 

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

    40. 

  40.         }

    41. 

  41. 

    42. 

  42.         $this->creativeType();

    43. 

  43.         $this->countFavCart();

    44. 

  44.         $this->getRankScrap();

    45. 

  45.         $this->getFeaturedScrap();

    46. 

  46.         $this->getPublicScrap();

    47. 

  47. 

    48. 

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

    49. 

  49.     }

    50. 

  50. 

    51. 

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

    52. 

  52.     function featuredscrap($catlisttype=null) {

    53. 

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

    54. 

  54.         ///////////////////////////////////////////////////// SQL FOR FEATURED SCRAP

    55. 

  55.         /* Pagination and PHOTO listing */

    56. 

  56.         $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";

    57. 

  57. 

    58. 

  58.         $from=" FROM creative_favorites X

    59. 

  59. 

    60. 

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

    61. 

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

    62. 

  62. 

    63. 

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

    64. 

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

    65. 

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

    66. 

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

    67. 

  67. 

    68. 

  68.         $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' ";

    69. 

  69. 

    70. 

  70. 

    71. 

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

    72. 

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

    73. 

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

    74. 

  74.         }

    75. 

  75. 

    76. 

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

    77. 

  77. 

    78. 

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

    79. 

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

    80. 

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

    81. 

  81. 

    82. 

  82.         }

    83. 

  83. 

    84. 

  84.         if(!$catlisttype) {

    85. 

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

    86. 

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

    87. 

  87.         }

    88. 

  88. 

    89. 

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

    90. 

  90.         $tabsql_res = mysql_query($tabsql);

    91. 

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

    92. 

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

    93. 

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

    94. 

  94.     }

    95. 

  95. 

    96. 

  96.     //ok scrap listing

    97. 

  97.     function scrapxonglisting() {

    98. 

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

    99. 

  99. 

    100. 

  100.         $catlisttype = '';

    101. 

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

    102. 

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

    103. 

  103. 

    104. 

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

    105. 

  105.         $scrapType=0;

    106. 

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

    107. 

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

    108. 

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

    109. 

  109.         }

    110. 

  110. 

    111. 

  111.         ############################### Page Title  & Head ############################

    112. 

  112. 

    113. 

  113.         $pageheadArr = array();

    114. 

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

    115. 

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

    116. 

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

    117. 

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

    118. 

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

    119. 

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

    120. 

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

    121. 

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

    122. 

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

    123. 

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

    124. 

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

    125. 

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

    126. 

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

    127. 

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

    128. 

  128.                 /* Album Name*/

    129. 

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

    130. 

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

    131. 

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

    132. 

  132.                 /**/

    133. 

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

    134. 

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

    135. 

  135. 

    136. 

  136.             }

    137. 

  137.             else {

    138. 

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

    139. 

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

    140. 

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

    141. 

  141.                 }

    142. 

  142.                 else {

    143. 

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

    144. 

  144.                         /* SELLER INFO */

    145. 

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

    146. 

  146.                         $sellinfo_res = mysql_query($sellinfo);

    147. 

  147.                         $sellinfo_arr = mysql_fetch_array($sellinfo_res);

    148. 

  148. 

    149. 

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

    150. 

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

    151. 

  151. 

    152. 

  152.                     }

    153. 

  153.                     else {

    154. 

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

    155. 

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

    156. 

  156.                     }

    157. 

  157.                 }

    158. 

  158.             }

    159. 

  159.         }

    160. 

  160.         else {

    161. 

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

    162. 

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

    163. 

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

    164. 

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

    165. 

  165.             }

    166. 

  166.             else {

    167. 

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

    168. 

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

    169. 

  169.             }

    170. 

  170.         }

    171. 

  171.         ############################### Page Title  & Head ############################

    172. 

  172.         /* Pagination and PHOTO listing */

    173. 

  173.         $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";

    174. 

  174. 

    175. 

  175.         $from=" FROM creative_favorites X

    176. 

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

    177. 

  177. 

    178. 

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

    179. 

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

    180. 

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

    181. 

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

    182. 

  182. 

    183. 

  183.         $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'";

    184. 

  184. 

    185. 

  185. 

    186. 

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

    187. 

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

    188. 

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

    189. 

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

    190. 

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

    191. 

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

    192. 

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

    193. 

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

    194. 

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

    195. 

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

    196. 

  196. 

    197. 

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

    198. 

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

    199. 

  199. 

    200. 

  200. 

    201. 

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

    202. 

  202. 

    203. 

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

    204. 

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

    205. 

  205. 

    206. 

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

    207. 

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

    208. 

  208. 

    209. 

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

    210. 

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

    211. 

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

    212. 

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

    213. 

  213. 

    214. 

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

    215. 

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

    216. 

  216. 

    217. 

  217.         if($catlisttype=='')

    218. 

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

    219. 

  219. 

    220. 

  220. 

    221. 

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

    222. 

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

    223. 

  223.         else {

    224. 

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

    225. 

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

    226. 

  226.             else {

    227. 

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

    228. 

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

    229. 

  229.                 else {

    230. 

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

    231. 

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

    232. 

  232.                     else {

    233. 

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

    234. 

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

    235. 

  235.                         else

    236. 

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

    237. 

  237.                     }

    238. 

  238.                 }

    239. 

  239.             }

    240. 

  240.         }

    241. 

  241. 

    242. 

  242. 

    243. 

  243. 

    244. 

  244.         $fltr='';

    245. 

  245.         $CountField="X.id";

    246. 

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

    247. 

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

    248. 

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

    249. 

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

    250. 

  250. 

    251. 

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

    252. 

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

    253. 

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

    254. 

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

    255. 

  255.         }

    256. 

  256. 

    257. 

  257.         /**/

    258. 

  258.         $this->creativeType();

    259. 

  259.         $this->countFavCart();

    260. 

  260.         $this->getPublicScrap();

    261. 

  261.     }

    262. 

  262. 

    263. 

  263.     //ok scrap detail

    264. 

  264.     function scrapxong() {

    265. 

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

    266. 

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

    267. 

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

    268. 

  268. 

    269. 

  269.         ############################################ SCRAP XONG DETAILS

    270. 

  270.         $this->creativeType();

    271. 

  271.         $this->countFavCart();

    272. 

  272.         $this->getPublicScrap();

    273. 

  273. 

    274. 

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

    275. 

  275. 

    276. 

  276.         //update viewed

    277. 

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

    278. 

  278.         mysql_query($select);

    279. 

  279. 

    280. 

  280.         $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,

    281. 

  281.                     Xuser.username ,COUNT(Xcomment.id) as photoreview ,  Xuserdetail.user_profile_img , IFNULL(ROUND(AVG(Xrating.vote),0),0) as photorat,

    282. 

  282.                     X.type";

    283. 

  283. 

    284. 

  284.         $from=" FROM creative_favorites X

    285. 

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

    286. 

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

    287. 

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

    288. 

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

    289. 

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

    290. 

  290. 

    291. 

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

    292. 

  292. 

    293. 

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

    294. 

  294.         $photo_res = mysql_query($photo_sql);

    295. 

  295.         $photores_arr = mysql_fetch_array($photo_res);

    296. 

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

    297. 

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

    298. 

  298. 

    299. 

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

    300. 

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

    301. 

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

    302. 

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

    303. 

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

    304. 

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

    305. 

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

    306. 

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

    307. 

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

    308. 

  308. 

    309. 

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

    310. 

  310.         $checklover_res = mysql_query($checklover);

    311. 

  311.         $checklover_res_num = mysql_num_rows($checklover_res);

    312. 

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

    313. 

  313. 

    314. 

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

    315. 

  315.         $numberpreview=0;

    316. 

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

    317. 

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

    318. 

  318.             $checkbackdropreview_res = mysql_query($checkbackdropreview);

    319. 

  319.             $numberpreview = mysql_num_rows($checkbackdropreview_res);

    320. 

  320.         }

    321. 

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

    322. 

  322. 

    323. 

  323.         ################################################### FOR NEXT AND PREVIOUS #######################

    324. 

  324. 

    325. 

  325.         $Imgselect="

    326. 

  326. 				SELECT CF.id,title,template_img

    327. 

  327. 				FROM creative_favorites CF,creative_favorites_details CFDTL

    328. 

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

    329. 

  329. 				GROUP BY CF.id ORDER BY CF.id DESC

    330. 

  330. 				" ;

    331. 

  331. 

    332. 

  332. 

    333. 

  333.         $Imgselect_res = mysql_query($Imgselect);

    334. 

  334.         $Imgarray = array();

    335. 

  335. 

    336. 

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

    337. 

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

    338. 

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

    339. 

  339.         }

    340. 

  340.         //pr($Imgarray);

    341. 

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

    342. 

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

    343. 

  343.         // Next

    344. 

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

    345. 

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

    346. 

  346. 

    347. 

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

    348. 

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

    349. 

  349.         }

    350. 

  350.         // Prev

    351. 

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

    352. 

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

    353. 

  353.         }

    354. 

  354. 

    355. 

  355.         ################################################### FOR NEXT AND PREVIOUS #######################

    356. 

  356.     }

    357. 

  357. 

    358. 

  358.     function creativetemplatezone() {

    359. 

  359.         $this->checkSession();

    360. 

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

    361. 

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

    362. 

  362.         $this->creativeType();

    363. 

  363. 

    364. 

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

    365. 

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

    366. 

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

    367. 

  367. 

    368. 

  368.         //_________________________________________________________________________________________________

    369. 

  369. 

    370. 

  370. 

    371. 

  371. 

    372. 

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

    373. 

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

    374. 

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

    375. 

  375. 

    376. 

  376.             if($tmpImg==0) {

    377. 

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

    378. 

  378.             }else {

    379. 

  379.                 //empty cart current

    380. 

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

    381. 

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

    382. 

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

    383. 

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

    384. 

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

    385. 

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

    386. 

  386.                     }

    387. 

  387.                 }

    388. 

  388.                 //add favorite

    389. 

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

    390. 

  390. 

    391. 

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

    392. 

  392.                     //add to favorite

    393. 

  393.                     /*$fav = $this->Creative_favorites->findById($tmpImg);

    394. 

  394. 

    395. 

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

    396. 

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

    397. 

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

    398. 

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

    399. 

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

    400. 

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

    401. 

  401. 

    402. 

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

    403. 

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

    404. 

  404. 

    405. 

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

    406. 

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

    407. 

  407. 

    408. 

  408.                     */

    409. 

  409.                 }

    410. 

  410.             }

    411. 

  411.         }

    412. 

  412. 

    413. 

  413.         $this->countFavCart();

    414. 

  414. 

    415. 

  415.         //case create form header

    416. 

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

    417. 

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

    418. 

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

    419. 

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

    420. 

  420.         }

    421. 

  421. 

    422. 

  422.     }

    423. 

  423.     //checking

    424. 

  424.     function creative_favorite() {

    425. 

  425.         $this->checkSession();

    426. 

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

    427. 

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

    428. 

  428.         $this->creativeType();

    429. 

  429. 

    430. 

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

    431. 

  431. 

    432. 

  432.         $tmpImg=0;

    433. 

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

    434. 

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

    435. 

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

    436. 

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

    437. 

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

    438. 

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

    439. 

  439.         }

    440. 

  440. 

    441. 

  441.         if($tmpImg==0) {

    442. 

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

    443. 

  443.         }

    444. 

  444. 

    445. 

  445. 

    446. 

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

    447. 

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

    448. 

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

    449. 

  449. 

    450. 

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

    451. 

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

    452. 

  452.             }

    453. 

  453.             else {//update

    454. 

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

    455. 

  455.                 if($fav['Creative_favorites']['template_id']>0)

    456. 

  456.                     $_SESSION['buyTemplate']['tmpId'] = $fav['Creative_favorites']['template_id'];

    457. 

  457.             }

    458. 

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

    459. 

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

    460. 

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

    461. 

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

    462. 

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

    463. 

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

    464. 

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

    465. 

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

    466. 

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

    467. 

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

    468. 

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

    469. 

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

    470. 

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

    471. 

  471. 

    472. 

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

    473. 

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

    474. 

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

    475. 

  475. 

    476. 

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

    477. 

  477. 

    478. 

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

    479. 

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

    480. 

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

    481. 

  481.             }

    482. 

  482. 

    483. 

  483.             if(isset($_SESSION['buyTemplate']) && isset($_SESSION['buyTemplate']['tmpId'])) {

    484. 

  484.                 $fav['Creative_favorites']['template_id'] =  $_SESSION['buyTemplate']['tmpId'];

    485. 

  485.                 //get price

    486. 

  486.                 $template = $this->Creative_favorites->findById($_SESSION['buyTemplate']['tmpId']);

    487. 

  487.                 if($template)

    488. 

  488.                     $fav['Creative_favorites']['price'] =  $template['Creative_favorites']['price'];

    489. 

  489.             }

    490. 

  490. 

    491. 

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

    492. 

  492. 

    493. 

  493.             //insert tag

    494. 

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

    495. 

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

    496. 

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

    497. 

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

    498. 

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

    499. 

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

    500. 

  500.             }

    501. 

  501. 

    502. 

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

    503. 

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

    504. 

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

    505. 

  505.                     exit();

    506. 

  506.                 }else {

    507. 

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

    508. 

  508.                 }

    509. 

  509.             }

    510. 

  510. 

    511. 

  511.         }

    512. 

  512. 

    513. 

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

    514. 

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

    515. 

  515.         }

    516. 

  516. 

    517. 

  517.         $sql = "";

    518. 

  518.         if($tmpImg==0) {

    519. 

  519.             $sql = "SELECT * FROM creative_favorites WHERE user_id='".$_SESSION['UserId']."' AND template_id<=0 AND is_temp='0' AND is_republished='1' ";

    520. 

  520.         }else {

    521. 

  521.             $sql = "SELECT * FROM creative_favorites WHERE user_id='".$_SESSION['UserId']."' AND template_id>0 AND is_temp='0' ";

    522. 

  522.         }

    523. 

  523. 

    524. 

  524.         if($sql!="") {

    525. 

  525.             $favs = null;

    526. 

  526.             $result = mysql_query($sql) or die("Error on line :".__LINE__.mysql_error());

    527. 

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

    528. 

  528.                 $favs = $result;

    529. 

  529.             }

    530. 

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

    531. 

  531.         }

    532. 

  532. 

    533. 

  533.         $this->countFavCart();

    534. 

  534. 

    535. 

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

    536. 

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

    537. 

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

    538. 

  538. 

    539. 

  539.         //_________________________________________________________________________________________________

    540. 

  540. 

    541. 

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

    542. 

  542.         $this->getCartDetails();

    543. 

  543.     }

    544. 

  544.     //ok

    545. 

  545.     function creative_favorite_ajax() {

    546. 

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

    547. 

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

    548. 

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

    549. 

  549. 

    550. 

  550.             if(!$fav) {

    551. 

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

    552. 

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

    553. 

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

    554. 

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

    555. 

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

    556. 

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

    557. 

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

    558. 

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

    559. 

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

    560. 

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

    561. 

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

    562. 

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

    563. 

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

    564. 

  564. 

    565. 

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

    566. 

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

    567. 

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

    568. 

  568. 

    569. 

  569.                 if(isset($_SESSION['buyTemplate']) && isset($_SESSION['buyTemplate']['tmpId'])) {

    570. 

  570.                     $fav['Creative_favorites']['template_id'] =  $_SESSION['buyTemplate']['tmpId'];

    571. 

  571.                     //get price

    572. 

  572.                     $template = $this->Creative_favorites->findById($_SESSION['buyTemplate']['tmpId']);

    573. 

  573.                     if($template)

    574. 

  574.                         $fav['Creative_favorites']['price'] =  $template['Creative_favorites']['price'];

    575. 

  575.                 }

    576. 

  576. 

    577. 

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

    578. 

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

    579. 

  579. 

    580. 

  580.                 //insert tag

    581. 

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

    582. 

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

    583. 

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

    584. 

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

    585. 

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

    586. 

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

    587. 

  587.                 }

    588. 

  588.             }

    589. 

  589. 

    590. 

  590.             if($fav['Creative_favorites']['template_id']>0) {

    591. 

  591.                 $_SESSION['buyTemplate']['tmpId'] = $fav['Creative_favorites']['template_id'];

    592. 

  592.             }

    593. 

  593.         }

    594. 

  594. 

    595. 

  595.         $this->countFavCart();

    596. 

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

    597. 

  597. 

    598. 

  598.     }

    599. 

  599. 

    600. 

  600.     function creativeType() {

    601. 

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

    602. 

  602.         $i=0;

    603. 

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

    604. 

  604.             if($i==0)

    605. 

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

    606. 

  606.             $i++;

    607. 

  607. 

    608. 

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

    609. 

  609.         }

    610. 

  610. 

    611. 

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

    612. 

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

    613. 

  613. 

    614. 

  614.         $type = 0;

    615. 

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

    616. 

  616.             $type = $key;

    617. 

  617.             break;

    618. 

  618.         }

    619. 

  619. 

    620. 

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

    621. 

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

    622. 

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

    623. 

  623.             if($detail) {

    624. 

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

    625. 

  625.             }

    626. 

  626.         }

    627. 

  627. 

    628. 

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

    629. 

  629.     }

    630. 

  630.     //checking

    631. 

  631. 

    632. 

  632.     function templateDetail($tmpImg) {

    633. 

  633.         $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());

    634. 

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

    635. 

  635.             $rwTmpImg=mysql_fetch_assoc($q1);

    636. 

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

    637. 

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

    638. 

  638.             return $tmpImg;

    639. 

  639.         }

    640. 

  640.         return 0;

    641. 

  641.     }

    642. 

  642.     //ok

    643. 

  643.     function getPublicScrap() {

    644. 

  644. 

    645. 

  645.         $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";

    646. 

  646. 

    647. 

  647.         $from=" FROM creative_favorites X

    648. 

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

    649. 

  649. 						

    650. 

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

    651. 

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

    652. 

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

    653. 

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

    654. 

  654. 

    655. 

  655.         $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'";

    656. 

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

    657. 

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

    658. 

  658. 

    659. 

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

    660. 

  660. 

    661. 

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

    662. 

  662. 

    663. 

  663. 

    664. 

  664. 

    665. 

  665. 

    666. 

  666. 

    667. 

  667. 

    668. 

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

    669. 

  669. 

    670. 

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

    671. 

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

    672. 

  672. 

    673. 

  673.     }

    674. 

  674.     //ok

    675. 

  675.     function getRankScrap() {

    676. 

  676.         /*$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";

    677. 

  677. 

    678. 

  678.         $from=" FROM creative_favorites X

    679. 

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

    680. 

  680. 						

    681. 

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

    682. 

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

    683. 

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

    684. 

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

    685. 

  685. 

    686. 

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

    687. 

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

    688. 

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

    689. 

  689. 

    690. 

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

    691. 

  691. 

    692. 

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

    693. 

  693. 

    694. 

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

    695. 

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

    696. 

  696.         */

    697. 

  697.     }

    698. 

  698.     //ok

    699. 

  699.     function getFeaturedScrap() {

    700. 

  700.         /*$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";

    701. 

  701. 

    702. 

  702.         $from=" FROM creative_favorites X

    703. 

  703. 						

    704. 

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

    705. 

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

    706. 

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

    707. 

  707. 						

    708. 

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

    709. 

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

    710. 

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

    711. 

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

    712. 

  712. 

    713. 

  713.         $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' ";

    714. 

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

    715. 

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

    716. 

  716. 

    717. 

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

    718. 

  718. 

    719. 

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

    720. 

  720. 

    721. 

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

    722. 

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

    723. 

  723.         */

    724. 

  724.     }

    725. 

  725.     //ok

    726. 

  726.     function viewalltag() {

    727. 

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

    728. 

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

    729. 

  729.         $this->creativeType();

    730. 

  730.         $this->getPublicScrap();

    731. 

  731. 

    732. 

  732.     }

    733. 

  733.     //ok

    734. 

  734.     function searchtag($alphasearch=null) {

    735. 

  735. 

    736. 

  736.         if($alphasearch)

    737. 

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

    738. 

  738.         else {

    739. 

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

    740. 

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

    741. 

  741.             else

    742. 

  742.                 $searchtxt='a%';

    743. 

  743.         }

    744. 

  744. 

    745. 

  745.         $tagarray = array();

    746. 

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

    747. 

  747.         $tagsearchsql_res = mysql_query($tagsearchsql);

    748. 

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

    749. 

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

    750. 

  750.         }

    751. 

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

    752. 

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

    753. 

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

    754. 

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

    755. 

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

    756. 

  756. 

    757. 

  757.     }

    758. 

  758.     //ok

    759. 

  759.     function scrapaddtocart($scrapxongid=null) {

    760. 

  760. 

    761. 

  761.         $queryCreativeFavorites=mysql_query("

    762. 

  762. 				SELECT CF.title,CTP.price

    763. 

  763. 				FROM creative_favorites CF,creative_template_pages CTP

    764. 

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

    765. 

  765.         $fetchCreativeFavorites=mysql_fetch_assoc($queryCreativeFavorites);

    766. 

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

    767. 

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

    768. 

  768. 

    769. 

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

    770. 

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

    771. 

  771.             $creativecartsql_res = mysql_query($creativecartsql);

    772. 

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

    773. 

  773.                 mysql_query("INSERT INTO

    774. 

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

    775. 

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

    776. 

  776. 

    777. 

  777.                 $lastId=mysql_insert_id();

    778. 

  778. 

    779. 

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

    780. 

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

    781. 

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

    782. 

  782.                 }

    783. 

  783.             }

    784. 

  784.         }

    785. 

  785. 

    786. 

  786. 

    787. 

  787.         $this->countFavCart();

    788. 

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

    789. 

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

    790. 

  790.     }

    791. 

  791. 

    792. 

  792.     function creative_login() {

    793. 

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

    794. 

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

    795. 

  795. 

    796. 

  796.         $id=0;

    797. 

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

    798. 

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

    799. 

  799. 

    800. 

  800. //This ct variable comes from CREATIVETEMPLATE page

    801. 

  801.         $tmpImg=0;

    802. 

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

    803. 

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

    804. 

  804. 

    805. 

  805. 

    806. 

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

    807. 

  807.         $lastId=0;

    808. 

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

    809. 

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

    810. 

  810. 

    811. 

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

    812. 

  812.         if(!empty($someone))

    813. 

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

    814. 

  814. 

    815. 

  815.     }

    816. 

  816. 

    817. 

  817.     function featuredpayment() {

    818. 

  818.         /*

    819. 

  819.         $this->checkSession();

    820. 

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

    821. 

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

    822. 

  822. 

    823. 

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

    824. 

  824.         $id=0;

    825. 

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

    826. 

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

    827. 

  827. 

    828. 

  828.         //This ct variable comes from CREATIVETEMPLATE page

    829. 

  829.         $tmpImg=0;

    830. 

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

    831. 

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

    832. 

  832. 

    833. 

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

    834. 

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

    835. 

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

    836. 

  836.         $lastId=0;

    837. 

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

    838. 

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

    839. 

  839. 

    840. 

  840. 

    841. 

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

    842. 

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

    843. 

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

    844. 

  844. 

    845. 

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

    846. 

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

    847. 

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

    848. 

  848. 

    849. 

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

    850. 

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

    851. 

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

    852. 

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

    853. 

  853.                     $this->amountPay=$amountCharge;

    854. 

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

    855. 

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

    856. 

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

    857. 

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

    858. 

  858.                     $this->paypal();

    859. 

  859.                 }

    860. 

  860. 

    861. 

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

    862. 

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

    863. 

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

    864. 

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

    865. 

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

    866. 

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

    867. 

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

    868. 

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

    869. 

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

    870. 

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

    871. 

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

    872. 

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

    873. 

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

    874. 

  874. 

    875. 

  875.                 }

    876. 

  876.             }

    877. 

  877. 

    878. 

  878.         }*/

    879. 

  879. 

    880. 

  880.     }

    881. 

  881. 

    882. 

  882.     function creative_featured() {

    883. 

  883.         $this->checkSession();

    884. 

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

    885. 

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

    886. 

  886.         $this->creativeType();

    887. 

  887.         $this->getPublicScrap();

    888. 

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

    889. 

  889. 

    890. 

  890.         $tmpImg =0;

    891. 

  891.         $id =0;

    892. 

  892. 

    893. 

  893.         $lastId=0;

    894. 

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

    895. 

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

    896. 

  896. 

    897. 

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

    898. 

  898. 

    899. 

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

    900. 

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

    901. 

  901. 

    902. 

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

    903. 

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

    904. 

  904. 

    905. 

  905.         //getCartDetails;

    906. 

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

    907. 

  907.         $queryCreativeCarts=mysql_query($sql);

    908. 

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

    909. 

  909. 

    910. 

  910.         $this->getUserDetails();

    911. 

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

    912. 

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

    913. 

  913.         $this->set('receiverId',1);

    914. 

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

    915. 

  915.     }

    916. 

  916.     //checking

    917. 

  917.     function featured_payment_notify() {

    918. 

  918.         /*

    919. 

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

    920. 

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

    921. 

  921. 

    922. 

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

    923. 

  923.         $paypal=0;

    924. 

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

    925. 

  925.             $paypal=1;

    926. 

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

    927. 

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

    928. 

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

    929. 

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

    930. 

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

    931. 

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

    932. 

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

    933. 

  933. 

    934. 

  934.             }

    935. 

  935.         }

    936. 

  936. 

    937. 

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

    938. 

  938.         if(!$paypal) {

    939. 

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

    940. 

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

    941. 

  941.             if($xml_response) {

    942. 

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

    943. 

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

    944. 

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

    945. 

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

    946. 

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

    947. 

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

    948. 

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

    949. 

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

    950. 

  950.             }

    951. 

  951. 

    952. 

  952.         }

    953. 

  953.         */

    954. 

  954.     }

    955. 

  955.     //checking

    956. 

  956.     function featuredsuccess() {

    957. 

  957. 

    958. 

  958.         $is_featured = 1;

    959. 

  959.         $productId=0;

    960. 

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

    961. 

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

    962. 

  962. 

    963. 

  963.         if(isset($_POST['custom'])) {

    964. 

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

    965. 

  965. 

    966. 

  966.             $paypal=1;

    967. 

  967. 

    968. 

  968.             $totalPay=$_POST['total_amount'];

    969. 

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

    970. 

  970. 

    971. 

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

    972. 

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

    973. 

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

    974. 

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

    975. 

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

    976. 

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

    977. 

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

    978. 

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

    979. 

  979.         }else {

    980. 

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

    981. 

  981.             $totalPay = 0;

    982. 

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

    983. 

  983.             $is_featured = 0;

    984. 

  984.         }

    985. 

  985. 

    986. 

  986.         //________________________________________________XOIMAGE DATABASE UPDATION SECTION

    987. 

  987. 

    988. 

  988.         //update featured_time

    989. 

  989.         $featured_time = NULL;

    990. 

  990.         if($is_featured==1) {

    991. 

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

    992. 

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

    993. 

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

    994. 

  994.         }

    995. 

  995. 

    996. 

  996.         $queryCreativeFavorites=mysql_query("

    997. 

  997. 					UPDATE creative_favorites

    998. 

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

    999. 

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

    1000. 

  1000. 

    1001. 

  1001. 

    1002. 

  1002.         if(isset($transactionId)) {

    1003. 

  1003.             //UPDATE date on TRANSACTION_CREATIVE TABLE

    1004. 

  1004.             $queryUpdateTransactionCreative="

    1005. 

  1005.                                     UPDATE transaction_creatives

    1006. 

  1006.                                     SET pay_status='1',invoice='".$invoice."', payment_ts_id='".$_POST['payment_ts_id']."'

    1007. 

  1007.                                     WHERE id='".$transactionId."' ";

    1008. 

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

    1009. 

  1009. 

    1010. 

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

    1011. 

  1011.             $queryUpdateCreativeCart="

    1012. 

  1012.                                     UPDATE creative_carts

    1013. 

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

    1014. 

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

    1015. 

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

    1016. 

  1016.         }

    1017. 

  1017. 

    1018. 

  1018.         //____________________________________________________TRANSACTION LOG MANAGEMENT_____________________________________

    1019. 

  1019. 

    1020. 

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

    1021. 

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

    1022. 

  1022. 

    1023. 

  1023.         if(isset($invoice))

    1024. 

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

    1025. 

  1025. 

    1026. 

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

    1027. 

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

    1028. 

  1028. 

    1029. 

  1029.         //ticket

    1030. 

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

    1031. 

  1031. 

    1032. 

  1032.         if(!$ticketData) {

    1033. 

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

    1034. 

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

    1035. 

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

    1036. 

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

    1037. 

  1037. 

    1038. 

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

    1039. 

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

    1040. 

  1040. 

    1041. 

  1041.             //____________________________________________________MAIL MANAGEMENT________________________________________________

    1042. 

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

    1043. 

  1043. 

    1044. 

  1044.             //mail sent to the user personal account

    1045. 

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

    1046. 

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

    1047. 

  1047. 

    1048. 

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

    1049. 

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

    1050. 

  1050. 

    1051. 

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

    1052. 

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

    1053. 

  1053. 

    1054. 

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

    1055. 

  1055.                 if(isset($invoice)) {

    1056. 

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

    1057. 

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

    1058. 

  1058.                 }

    1059. 

  1059. 

    1060. 

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

    1061. 

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

    1062. 

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

    1063. 

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

    1064. 

  1064. 

    1065. 

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

    1066. 

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

    1067. 

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

    1068. 

  1068. 

    1069. 

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

    1070. 

  1070.                 $sender=1;

    1071. 

  1071.                 $receiver=$userId;

    1072. 

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

    1073. 

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

    1074. 

  1074.             }

    1075. 

  1075. 

    1076. 

  1076.         }else {

    1077. 

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

    1078. 

  1078.             $this->set('ticket_exists',1);

    1079. 

  1079.         }

    1080. 

  1080. 

    1081. 

  1081.         //invoice

    1082. 

  1082.         if(isset($invoice)) {

    1083. 

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

    1084. 

  1084.             $zipfilename = 'scrapfotoimg'.$transactionId.$userId.'.zip';

    1085. 

  1085. 

    1086. 

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

    1087. 

  1087.             mysql_query("

    1088. 

  1088.                                     UPDATE transaction_creatives

    1089. 

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

    1090. 

  1090.                                     WHERE id='".$transactionId."' ") or die("Error on line - ".__LINE__.mysql_error());

    1091. 

  1091.             ;

    1092. 

  1092.             $downloadimgs = array();

    1093. 

  1093.             $Imgdestination='';

    1094. 

  1094.             foreach($downloadimg as $img) {

    1095. 

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

    1096. 

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

    1097. 

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

    1098. 

  1098.             }

    1099. 

  1099. 

    1100. 

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

    1101. 

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

    1102. 

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

    1103. 

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

    1104. 

  1104. 

    1105. 

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

    1106. 

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

    1107. 

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

    1108. 

  1108.                 $transactionHead="scrapfoto";

    1109. 

  1109.                 $transactionTitle="feature";

    1110. 

  1110.                 $invoiceId=$transactionId;

    1111. 

  1111. 

    1112. 

  1112.                 $statusoffee = "nontransactionfee";

    1113. 

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

    1114. 

  1114.                 $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.)

    1115. 

  1115.                 

    1116. 

  1116.                 //____________________________________________________MAIL MANAGEMENT________________________________________________

    1117. 

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

    1118. 

  1118. 

    1119. 

  1119.                 //mail sent to the user personal account

    1120. 

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

    1121. 

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

    1122. 

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

    1123. 

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

    1124. 

  1124. 

    1125. 

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

    1126. 

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

    1127. 

  1127. 

    1128. 

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

    1129. 

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

    1130. 

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

    1131. 

  1131. 

    1132. 

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

    1133. 

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

    1134. 

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

    1135. 

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

    1136. 

  1136. 

    1137. 

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

    1138. 

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

    1139. 

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

    1140. 

  1140. 

    1141. 

  1141. 

    1142. 

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

    1143. 

  1143.                     $sender=1;

    1144. 

  1144.                     $receiver=$userId;

    1145. 

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

    1146. 

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

    1147. 

  1147.                 }

    1148. 

  1148.             }

    1149. 

  1149.         }

    1150. 

  1150. 

    1151. 

  1151. 

    1152. 

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

    1153. 

  1153.         $this->creativeType();

    1154. 

  1154.         $this->countFavCart();

    1155. 

  1155.         $this->getRankScrap();

    1156. 

  1156.         $this->getFeaturedScrap();

    1157. 

  1157.         $this->getPublicScrap();

    1158. 

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

    1159. 

  1159.     }

    1160. 

  1160.     //test

    1161. 

  1161.     function mail_ticket($ticket) {

    1162. 

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

    1163. 

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

    1164. 

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

    1165. 

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

    1166. 

  1166.     }

    1167. 

  1167.     //test

    1168. 

  1168.     function mail_scrapfeature($tranId) {

    1169. 

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

    1170. 

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

    1171. 

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

    1172. 

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

    1173. 

  1173.     }

    1174. 

  1174. 

    1175. 

  1175.     function scrapDetails($id) {

    1176. 

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

    1177. 

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

    1178. 

  1178.     }

    1179. 

  1179. 

    1180. 

  1180.     function getUserCreativeSalesTax($stateId) {

    1181. 

  1181.         $queryCreativeSaletax=mysql_query("

    1182. 

  1182. 				SELECT tax 

    1183. 

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

    1184. 

  1184.         $fetchCreativeSaletax=mysql_fetch_assoc($queryCreativeSaletax);

    1185. 

  1185. 

    1186. 

  1186.         return $fetchCreativeSaletax['tax'];

    1187. 

  1187. 

    1188. 

  1188.     }

    1189. 

  1189.     //checking

    1190. 

  1190.     function chargecouponcode() {

    1191. 

  1191.         //cart deatils

    1192. 

  1192.         $this->getCartDetails();

    1193. 

  1193. 

    1194. 

  1194.         //sale tax

    1195. 

  1195.         $stateId=0;

    1196. 

  1196.         $saleTax=0;

    1197. 

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

    1198. 

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

    1199. 

  1199. 

    1200. 

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

    1201. 

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

    1202. 

  1202. 

    1203. 

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

    1204. 

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

    1205. 

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

    1206. 

  1206.         //Coupon code

    1207. 

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

    1208. 

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

    1209. 

  1209. 

    1210. 

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

    1211. 

  1211.         $couponValue=0;

    1212. 

  1212.         $qry="SELECT coupon_value FROM creative_coupon

    1213. 

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

    1214. 

  1214.         $q1=mysql_query($qry);

    1215. 

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

    1216. 

  1216.             $rw=mysql_fetch_assoc($q1);

    1217. 

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

    1218. 

  1218.         }

    1219. 

  1219. 

    1220. 

  1220.         //payment details

    1221. 

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

    1222. 

  1222.         $tmpImg=0;

    1223. 

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

    1224. 

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

    1225. 

  1225.         }

    1226. 

  1226. 

    1227. 

  1227.         if($tmpImg>0) {

    1228. 

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

    1229. 

  1229.             $fetchPaymentSetup=$this->getPaymentMethods(1);	// that means payment will go to the user paymenbt id

    1230. 

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

    1231. 

  1231.             $this->set('receiverId',1);

    1232. 

  1232.         }else {

    1233. 

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

    1234. 

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

    1235. 

  1235.             $this->set('receiverId',1);

    1236. 

  1236.         }

    1237. 

  1237. 

    1238. 

  1238.         $this->set("paymentMethods",$fetchPaymentSetup);

    1239. 

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

    1240. 

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

    1241. 

  1241. 

    1242. 

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

    1243. 

  1243.     }

    1244. 

  1244. 

    1245. 

  1245.     function feature_chargecouponcode() {

    1246. 

  1246. 

    1247. 

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

    1248. 

  1248.         $totalAmount = round($featuredAmount['config_value'],2);

    1249. 

  1249. 

    1250. 

  1250.         //sale tax

    1251. 

  1251.         $stateId=0;

    1252. 

  1252.         $saleTax=0;

    1253. 

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

    1254. 

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

    1255. 

  1255. 

    1256. 

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

    1257. 

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

    1258. 

  1258. 

    1259. 

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

    1260. 

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

    1261. 

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

    1262. 

  1262.         //Coupon code

    1263. 

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

    1264. 

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

    1265. 

  1265. 

    1266. 

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

    1267. 

  1267.         $couponValue=0;

    1268. 

  1268.         $qry="SELECT coupon_value FROM creative_coupon

    1269. 

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

    1270. 

  1270.         $q1=mysql_query($qry);

    1271. 

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

    1272. 

  1272.             $rw=mysql_fetch_assoc($q1);

    1273. 

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

    1274. 

  1274.         }

    1275. 

  1275. 

    1276. 

  1276.         //payment details

    1277. 

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

    1278. 

  1278.         $this->set("receiverId",1);

    1279. 

  1279.         $this->set("sellerId",1);

    1280. 

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

    1281. 

  1281. 

    1282. 

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

    1283. 

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

    1284. 

  1284. 

    1285. 

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

    1286. 

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

    1287. 

  1287.     }

    1288. 

  1288. 

    1289. 

  1289.     function getcheckoutcity() {

    1290. 

  1290.         $this->checkSession();

    1291. 

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

    1292. 

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

    1293. 

  1293. 

    1294. 

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

    1295. 

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

    1296. 

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

    1297. 

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

    1298. 

  1298. 

    1299. 

  1299.         $this->getCartDetails();

    1300. 

  1300. 

    1301. 

  1301.         //sale tax

    1302. 

  1302.         $stateId=0;

    1303. 

  1303.         $saleTax=0;

    1304. 

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

    1305. 

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

    1306. 

  1306. 

    1307. 

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

    1308. 

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

    1309. 

  1309. 

    1310. 

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

    1311. 

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

    1312. 

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

    1313. 

  1313.         //Coupon code

    1314. 

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

    1315. 

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

    1316. 

  1316. 

    1317. 

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

    1318. 

  1318.         $couponValue=0;

    1319. 

  1319.         $qry="SELECT coupon_value FROM creative_coupon

    1320. 

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

    1321. 

  1321.         $q1=mysql_query($qry);

    1322. 

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

    1323. 

  1323.             $rw=mysql_fetch_assoc($q1);

    1324. 

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

    1325. 

  1325.         }

    1326. 

  1326. 

    1327. 

  1327. 

    1328. 

  1328.         //payment details

    1329. 

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

    1330. 

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

    1331. 

  1331. 

    1332. 

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

    1333. 

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

    1334. 

  1334. 

    1335. 

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

    1336. 

  1336. 

    1337. 

  1337.     }

    1338. 

  1338. 

    1339. 

  1339.     function getcheckoutstate() {

    1340. 

  1340.         $this->checkSession();

    1341. 

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

    1342. 

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

    1343. 

  1343. 

    1344. 

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

    1345. 

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

    1346. 

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

    1347. 

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

    1348. 

  1348. 

    1349. 

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

    1350. 

  1350. 

    1351. 

  1351.     }

    1352. 

  1352. 

    1353. 

  1353.     function getUserDetails($user_id=null) {

    1354. 

  1354.         if($user_id==null)

    1355. 

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

    1356. 

  1356.         $coutryList=array();

    1357. 

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

    1358. 

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

    1359. 

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

    1360. 

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

    1361. 

  1361.         }

    1362. 

  1362. 

    1363. 

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

    1364. 

  1364.         $rowQry=mysql_fetch_assoc($qry2);

    1365. 

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

    1366. 

  1366. 

    1367. 

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

    1368. 

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

    1369. 

  1369. 

    1370. 

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

    1371. 

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

    1372. 

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

    1373. 

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

    1374. 

  1374. 

    1375. 

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

    1376. 

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

    1377. 

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

    1378. 

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

    1379. 

  1379. 

    1380. 

  1380.         return $rowQry;

    1381. 

  1381.     }

    1382. 

  1382. 

    1383. 

  1383.     function getCreativeState($conId) {

    1384. 

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

    1385. 

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

    1386. 

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

    1387. 

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

    1388. 

  1388.         }

    1389. 

  1389. 

    1390. 

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

    1391. 

  1391.     }

    1392. 

  1392. 

    1393. 

  1393.     function getstate() {

    1394. 

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

    1395. 

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

    1396. 

  1396.     }

    1397. 

  1397. 

    1398. 

  1398.     function creative_cart() {

    1399. 

  1399.         $this->checkSession();

    1400. 

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

    1401. 

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

    1402. 

  1402.         $this->creativeType();

    1403. 

  1403.         $this->getPublicScrap();

    1404. 

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

    1405. 

  1405.         if($cartCount<=0) {

    1406. 

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

    1407. 

  1407.             die();

    1408. 

  1408.         }

    1409. 

  1409. 

    1410. 

  1410.         $tmpImg=0;

    1411. 

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

    1412. 

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

    1413. 

  1413. 

    1414. 

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

    1415. 

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

    1416. 

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

    1417. 

  1417. 

    1418. 

  1418.         //_________________________________________________________________________________________________

    1419. 

  1419. 

    1420. 

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

    1421. 

  1421. 

    1422. 

  1422.         $carts = $this->getCartDetails(true);

    1423. 

  1423.         $this->getUserDetails();

    1424. 

  1424. 

    1425. 

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

    1426. 

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

    1427. 

  1427.             if(($row = mysql_fetch_array($carts))) {

    1428. 

  1428. 

    1429. 

  1429.                 $fav = $this->Creative_favorites->findById($row['creative_favorite_id']);

    1430. 

  1430.                 $_SESSION['buyTemplate']['tmpId'] = $fav['Creative_favorites']['template_id'];

    1431. 

  1431. 

    1432. 

  1432.                 $template = $this->Creative_favorites->findById($fav['Creative_favorites']['template_id']);

    1433. 

  1433.                 $fetchPaymentSetup=$this->getPaymentMethods(1);	

    1434. 

  1434.                 $this->set('receiverId',1);

    1435. 

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

    1436. 

  1436.             }

    1437. 

  1437. 

    1438. 

  1438.         }else {

    1439. 

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

    1440. 

  1440.             $this->set('receiverId',1);

    1441. 

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

    1442. 

  1442.         }

    1443. 

  1443. 

    1444. 

  1444.         $this->set("paymentMethods",$fetchPaymentSetup);

    1445. 

  1445. 

    1446. 

  1446.     }

    1447. 

  1447. 

    1448. 

  1448.     //checking

    1449. 

  1449.     function getCartImages($userId,$tranId,$isThumb=false) {

    1450. 

  1450. 

    1451. 

  1451.         $downloadimg=array();

    1452. 

  1452.         $getYearBookImg=mysql_query("

    1453. 

  1453. 					SELECT CF.fileZip, CF.fileThumb2

    1454. 

  1454. 					FROM creative_carts C,creative_cart_details CD, creative_favorites as CF

    1455. 

  1455. 					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."'

    1456. 

  1456. 					") or die(mysql_error());

    1457. 

  1457. 

    1458. 

  1458.         while($rwYearbookImg=mysql_fetch_assoc($getYearBookImg)) {

    1459. 

  1459.             if($isThumb)

    1460. 

  1460.                 array_push($downloadimg,$rwYearbookImg['fileThumb2']);

    1461. 

  1461.             else

    1462. 

  1462.                 array_push($downloadimg,$rwYearbookImg['fileZip']);

    1463. 

  1463.         }

    1464. 

  1464. 

    1465. 

  1465.         return $downloadimg;

    1466. 

  1466. 

    1467. 

  1467.     }

    1468. 

  1468.     //checking

    1469. 

  1469.     function checkout() {

    1470. 

  1470.         $this->checkSession();

    1471. 

  1471.         $this->countFavCart();

    1472. 

  1472.         $this->layout = 'blank';

    1473. 

  1473. 

    1474. 

  1474.         $totalAmount=round($this->data['creative']['totalAmount'],2);

    1475. 

  1475.         $sellerId=$this->data['creative']['sellerId'];

    1476. 

  1476.         $receiverId=$this->data['creative']['receiverId'];

    1477. 

  1477.         $saletax = 0;//$this->data['creativezones']['saletax'];

    1478. 

  1478.         //$rdPage refers to function success

    1479. 

  1479.         $rdPage=$this->data['creative']['rdpage'];

    1480. 

  1480. 

    1481. 

  1481.         if(isset($_SESSION['buyTemplate'])) {

    1482. 

  1482.             $commission = $this->getConfigAmount('creative commission');

    1483. 

  1483.             $commission = $commission['config_value']/100*($totalAmount-$saletax);

    1484. 

  1484.         }else {

    1485. 

  1485.             $commission = 0;

    1486. 

  1486.         }

    1487. 

  1487. 

    1488. 

  1488.         $isAdmin=1;

    1489. 

  1489.         //If user purchases his own scraps then the payment will go to admin

    1490. 

  1490.         //If the user purchases scraps of other users then the payment will go to that other users

    1491. 

  1491.         if($receiverId==1) {

    1492. 

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

    1493. 

  1493.         }

    1494. 

  1494.         else {

    1495. 

  1495.             $isAdmin=0;

    1496. 

  1496.             $fetchAdminPaymentSetup=$this->getPaymentMethodsUsers($sellerId);

    1497. 

  1497.         }

    1498. 

  1498. 

    1499. 

  1499.         //UPDATE USERS ADDRESS

    1500. 

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

    1501. 

  1501.             if(isset($this->data['creativezones']['B']) && ($this->data['creativezones']['B'])!="") {

    1502. 

  1502. 

    1503. 

  1503.                 $updateUser="UPDATE user_details

    1504. 

  1504. 				SET address='".$this->data['creativezones']['Baddress']."',city='".$this->data['creativezones']['Bcity']."',

    1505. 

  1505. 				    zip='".$this->data['creativezones']['Bzip']."',c_id='".$this->params['form']['creativezonesBcountry']."'

    1506. 

  1506. 				    ,state='".$this->params['form']['creativezonesBstate']."'

    1507. 

  1507.                             WHERE user_id=".$_SESSION['UserId'];

    1508. 

  1508.                 mysql_query($updateUser);

    1509. 

  1509.             }

    1510. 

  1510.         }

    1511. 

  1511. 

    1512. 

  1512.         $feature = isset($this->data['creativezones']['feature']);

    1513. 

  1513. 

    1514. 

  1514.         if($feature) {

    1515. 

  1515.             //create creative_carts

    1516. 

  1516.             mysql_query("DELETE FROM creative_carts WHERE pay_status='0' AND user_id='".$_SESSION['UserId']."'");

    1517. 

  1517.             mysql_query("INSERT INTO

    1518. 

  1518.                                     creative_carts(user_id,cart_name,transaction_creative_id,pay_status)

    1519. 

  1519.                                     VALUES('".$_SESSION['UserId']."','Feature fee','0','0')") or die("Error on line : ".__LINE__.mysql_error());

    1520. 

  1520. 

    1521. 

  1521.             $cart_id=mysql_insert_id();

    1522. 

  1522.             $productId = $this->data['creativezones']['lastId'];

    1523. 

  1523. 

    1524. 

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

    1525. 

  1525.             $price = $featuredAmount['config_value'];

    1526. 

  1526. 

    1527. 

  1527.             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'");

    1528. 

  1528.         }

    1529. 

  1529. 

    1530. 

  1530.         

    1531. 

  1531.             //insert data to the TRANSACTION_CREATIVES TABLE after successful transaction

    1532. 

  1532.             mysql_query("INSERT INTO

    1533. 

  1533.                                         transaction_creatives(total_amount,is_admin)

    1534. 

  1534.                                         VALUES('".$totalAmount."','".$isAdmin."')") or die("Error on line : ".__LINE__.mysql_error());

    1535. 

  1535. 

    1536. 

  1536.             $lastTransactionId=mysql_insert_id();

    1537. 

  1537. 

    1538. 

  1538.             //UPDATE CART

    1539. 

  1539.             mysql_query("

    1540. 

  1540.                                         UPDATE creative_carts

    1541. 

  1541.                                         SET

    1542. 

  1542.                                         coupon='".$this->data['creativezones']['couponprice']."',

    1543. 

  1543.                                         saletax='".$this->data['creativezones']['saletax']."',

    1544. 

  1544.                                         transaction_creative_id='".$lastTransactionId."'

    1545. 

  1545.                                         WHERE pay_status='0' AND user_id='".$_SESSION['UserId']."'");

    1546. 

  1546. 

    1547. 

  1547.             $invoice = $this->createTransactionNumber('SP');

    1548. 

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

    1549. 

  1549. 

    1550. 

  1550.         //get title favorite

    1551. 

  1551.         $sql = "SELECT F.title

    1552. 

  1552.                 FROM creative_carts as C

    1553. 

  1553.                 RIGHT JOIN creative_cart_details CDT ON (CDT.creative_cart_id = C.id)

    1554. 

  1554.                 RIGHT JOIN creative_favorites F ON (F.id = CDT.creative_favorite_id)

    1555. 

  1555.                 WHERE C.transaction_creative_id = '".$lastTransactionId."' ";

    1556. 

  1556.         $result = mysql_query($sql);

    1557. 

  1557.         $description = 'ScrapFOTO - ';

    1558. 

  1558.         if(($row=mysql_fetch_array($result))){

    1559. 

  1559.             $description = $row['title'];

    1560. 

  1560.         }else{

    1561. 

  1561.             $description = 'scraps purchase and download';

    1562. 

  1562.         }

    1563. 

  1563.         

    1564. 

  1564. 

    1565. 

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

    1566. 

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

    1567. 

  1567.                 $custom=$_SESSION['UserId']."^".$sellerId."^".$isAdmin."^".$rdPage."^".$invoice."^".$lastTransactionId;

    1568. 

  1568.                 if($feature) {

    1569. 

  1569.                     $itemName="ScrapFOTO&trade; Featured";

    1570. 

  1570.                     $returnUrl=FULL_BASE_URL.$this->webroot."creativezones/featuredsuccess";

    1571. 

  1571.                     $notifyUrl=FULL_BASE_URL.$this->webroot."creativezones/featured_payment_notify";

    1572. 

  1572.                     $custom .= "^".$ticket."^".$productId;

    1573. 

  1573.                     $description = 'Featured '.$description;

    1574. 

  1574.                 }else {

    1575. 

  1575.                     $itemName="ScrapFOTO&trade; Image download";

    1576. 

  1576.                     $returnUrl=FULL_BASE_URL.$this->webroot."creativezones/".$rdPage."?tr=".base64_encode($lastTransactionId);//DOMAIN

    1577. 

  1577.                     $notifyUrl=FULL_BASE_URL.$this->webroot."creativezones/checkout_notify";

    1578. 

  1578.                     if(isset($_SESSION['buyTemplate'])){

    1579. 

  1579.                         $custom .=  "^"."true"."^".$_SESSION['buyTemplate']['tmpId'];

    1580. 

  1580.                         $description = 'Buy '.$description;

    1581. 

  1581.                     }

    1582. 

  1582.                     else

    1583. 

  1583.                         $custom .=  "^"."false";

    1584. 

  1584.                 }

    1585. 

  1585.                 $fields['payment'] = 'paypal';

    1586. 

  1586.                 $fields['business'] = $fetchAdminPaymentSetup['paypal_email'];

    1587. 

  1587.                 $fields['return'] = $returnUrl;

    1588. 

  1588.                 $fields['notify_url'] = $notifyUrl;

    1589. 

  1589.                 $fields['item_name'] = $itemName;

    1590. 

  1590.                 $fields['amount'] = $totalAmount;

    1591. 

  1591.                 $fields['quantity'] = 1;

    1592. 

  1592.                 $fields['invoice'] = $invoice;

    1593. 

  1593.                 $fields['custom'] = $custom;

    1594. 

  1594.             }

    1595. 

  1595.             else {

    1596. 

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

    1597. 

  1597.             }

    1598. 

  1598.         }else {

    1599. 

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

    1600. 

  1600.         }

    1601. 

  1601. 

    1602. 

  1602.         $description = 'ScrapFOTO - '.$description;

    1603. 

  1603. 

    1604. 

  1604.         $fields['section_id'] = 1;//for spsp

    1605. 

  1605.         $fields['type_id'] = 1;//pay normal

    1606. 

  1606.         $fields['invoice'] = $invoice;

    1607. 

  1607.         $fields['user_id'] = $_SESSION['UserId'];

    1608. 

  1608.         $fields['receiver_id'] = $receiverId;

    1609. 

  1609.         $fields['seller_id'] = $sellerId;

    1610. 

  1610.         $fields['amount'] = $totalAmount;

    1611. 

  1611.         $fields['saletax'] = $saletax;

    1612. 

  1612.         $fields['commission'] = $commission;

    1613. 

  1613.         $fields['paypal_fee'] = 0;

    1614. 

  1614.         $fields['transaction_fee'] = 0;

    1615. 

  1615.         $fields['description'] = $description;

    1616. 

  1616.         $fields['key'] = md5(PAYMENT_KEY);

    1617. 

  1617. 

    1618. 

  1618. 

    1619. 

  1619.         $this->set('fields',$fields);

    1620. 

  1620.         $this->set('payment_url',PAYMENT_URL);

    1621. 

  1621.     }

    1622. 

  1622.     //checking

    1623. 

  1623.     function checkout_notify() {

    1624. 

  1624. 

    1625. 

  1625.         /*

    1626. 

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

    1627. 

  1627.         $this->Paypal->paypal_url = $this->paypalUrl;

    1628. 

  1628.         $paypal=0;

    1629. 

  1629.         //____________________________________________________IPN DATA SECTION______________________________________________

    1630. 

  1630. 

    1631. 

  1631.         //This section is used to catch from PAYPAL IPN data

    1632. 

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

    1633. 

  1633.             $paypal=1;

    1634. 

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

    1635. 

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

    1636. 

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

    1637. 

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

    1638. 

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

    1639. 

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

    1640. 

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

    1641. 

  1641.                 $ssnId=$custom['4'];

    1642. 

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

    1643. 

  1643.                 $invoice=$this->Paypal->ipn_data['invoice'];

    1644. 

  1644. 

    1645. 

  1645.             }

    1646. 

  1646.         }

    1647. 

  1647. 

    1648. 

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

    1649. 

  1649.         if(!$paypal) {

    1650. 

  1650. 

    1651. 

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

    1652. 

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

    1653. 

  1653.             if($xml_response) {

    1654. 

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

    1655. 

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

    1656. 

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

    1657. 

  1657. 

    1658. 

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

    1659. 

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

    1660. 

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

    1661. 

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

    1662. 

  1662.                 $ssnId=$ipnData['4'];

    1663. 

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

    1664. 

  1664.                 $invoice=$ipnData['6'];

    1665. 

  1665.                 $totalPay=$ipnData['7'];

    1666. 

  1666.             }

    1667. 

  1667.         }

    1668. 

  1668. 

    1669. 

  1669.         

    1670. 

  1670.          * 

    1671. 

  1671.         */

    1672. 

  1672. 

    1673. 

  1673.     }

    1674. 

  1674.     //checking

    1675. 

  1675.     function success() {

    1676. 

  1676.         $this->checkSession();

    1677. 

  1677.         //

    1678. 

  1678.         $paypal=1;

    1679. 

  1679.         $transactionId=0;

    1680. 

  1680.         if(!isset($_POST['custom'])) {

    1681. 

  1681.             die('<center>Information payment incorrect. Please check again.</center>');

    1682. 

  1682.         }

    1683. 

  1683.         //____________________________________________________IPN DATA SECTION______________________________________________

    1684. 

  1684.         $totalPay = $_POST['total_amount'];

    1685. 

  1685.         $payment_ts_id = $_POST['payment_ts_id'];

    1686. 

  1686. 

    1687. 

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

    1688. 

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

    1689. 

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

    1690. 

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

    1691. 

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

    1692. 

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

    1693. 

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

    1694. 

  1694.         $buyTemplate = ($custom['6']=='true');

    1695. 

  1695. 

    1696. 

  1696.         //____________________________________________________XOIMAGE DATABASE UPDATION_____________________________________

    1697. 

  1697.         if($transactionId>0) {

    1698. 

  1698.             //UPDATE date on TRANSACTION_CREATIVE TABLE

    1699. 

  1699.             $queryUpdateTransactionCreative="

    1700. 

  1700.                                     UPDATE transaction_creatives

    1701. 

  1701.                                     SET pay_status='1',invoice='".$invoice."', payment_ts_id ='".$payment_ts_id."'

    1702. 

  1702.                                     WHERE id='".$transactionId."' ";

    1703. 

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

    1704. 

  1704. 

    1705. 

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

    1706. 

  1706.             $queryUpdateCreativeCart="

    1707. 

  1707.                                     UPDATE creative_carts

    1708. 

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

    1709. 

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

    1710. 

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

    1711. 

  1711. 

    1712. 

  1712.             //generating the downloadable file

    1713. 

  1713.             //Get the list of the downloaded images

    1714. 

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

    1715. 

  1715.             $zipfilename = 'scrapfotoimg'.$transactionId.$userId.'.zip';

    1716. 

  1716. 

    1717. 

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

    1718. 

  1718.             mysql_query("

    1719. 

  1719.                                     UPDATE transaction_creatives

    1720. 

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

    1721. 

  1721.                                     WHERE id='".$transactionId."' ") or die("Error on line - ".__LINE__.mysql_error());

    1722. 

  1722.             ;

    1723. 

  1723.             $downloadimgs = array();

    1724. 

  1724.             $Imgdestination='';

    1725. 

  1725.             foreach($downloadimg as $img) {

    1726. 

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

    1727. 

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

    1728. 

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

    1729. 

  1729.             }

    1730. 

  1730. 

    1731. 

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

    1732. 

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

    1733. 

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

    1734. 

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

    1735. 

  1735. 

    1736. 

  1736.             //____________________________________________________TRANSACTION LOG MANAGEMENT_____________________________________

    1737. 

  1737. 

    1738. 

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

    1739. 

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

    1740. 

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

    1741. 

  1741.                 $transactionDesc="ScrapFOTO - scraps purchase and download";

    1742. 

  1742.                 $transactionHead="scrapfoto";

    1743. 

  1743.                 $transactionTitle="download";

    1744. 

  1744.                 $invoice=$invoice;

    1745. 

  1745.                 $invoiceId=$transactionId;

    1746. 

  1746. 

    1747. 

  1747.                 $statusoffee="nontransactionfee";

    1748. 

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

    1749. 

  1749.                 //if(!isset($_SESSION['buyTemplate']))

    1750. 

  1750.                 $this->transactionDetail($userId,$totalPay,'-1',$lastInsetID,$sellerId,$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.)

    1751. 

  1751. 

    1752. 

  1752.                 //____________________________________________________MAIL MANAGEMENT________________________________________________

    1753. 

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

    1754. 

  1754.                 //check buy template

    1755. 

  1755.                 if($buyTemplate) {

    1756. 

  1756.                     // “notification of sale” (E7) will be send to User Artist

    1757. 

  1757.                     $fav = $this->Creative_favorites->findById($custom[7]);

    1758. 

  1758. 

    1759. 

  1759.                     $fav['Creative_favorites']['num_sell']++;

    1760. 

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

    1761. 

  1761. 

    1762. 

  1762.                     //save transaction of seller

    1763. 

  1763.                     //$transactionDesc="ScrapFOTO - scraps template purchase and download";

    1764. 

  1764.                     //$this->transactionDetail($userId,$totalPay,'-1',$lastInsetID,$fav['Creative_favorites']['user_id'],$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.)

    1765. 

  1765. 

    1766. 

  1766.                     //send mail seller

    1767. 

  1767.                     $sellDetails=$this->getUserDetails($fav['Creative_favorites']['user_id']);

    1768. 

  1768.                     if(isset($sellDetails['email'])) {

    1769. 

  1769. 

    1770. 

  1770.                         $receiver=$fav['Creative_favorites']['user_id'];

    1771. 

  1771. 

    1772. 

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

    1773. 

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

    1774. 

  1774.                         $this->Sendmail->To($sellDetails['email']);

    1775. 

  1775. 

    1776. 

  1776.                         $subject="XOimages - Notification of sales";

    1777. 

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

    1778. 

  1778. 

    1779. 

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

    1780. 

  1780.                         $this->set("sellerId",$receiver);

    1781. 

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

    1782. 

  1782.                         $this->Sendmail->view= 'mail_notification_sales';

    1783. 

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

    1784. 

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

    1785. 

  1785. 

    1786. 

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

    1787. 

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

    1788. 

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

    1789. 

  1789. 

    1790. 

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

    1791. 

  1791.                         $sender=1;

    1792. 

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

    1793. 

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

    1794. 

  1794.                         $this->Sendmail->__destruct();

    1795. 

  1795. 

    1796. 

  1796.                         //check creative quantity sold

    1797. 

  1797.                         $quantitysold = $this->getConfigAmount('creative quantity sold');

    1798. 

  1798.                         if($quantitysold['config_value']==$fav['Creative_favorites']['num_sell']) {

    1799. 

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

    1800. 

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

    1801. 

  1801.                             $this->Sendmail->To($sellDetails['email']);

    1802. 

  1802. 

    1803. 

  1803.                             $subject="XOimages - Notification of user set price";

    1804. 

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

    1805. 

  1805. 

    1806. 

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

    1807. 

  1807.                             $this->set("sellerId",$receiver);

    1808. 

  1808.                             $this->set('num_sell',$fav['Creative_favorites']['num_sell']);

    1809. 

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

    1810. 

  1810.                             $this->Sendmail->view= 'mail_notification_set_price';

    1811. 

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

    1812. 

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

    1813. 

  1813. 

    1814. 

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

    1815. 

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

    1816. 

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

    1817. 

  1817. 

    1818. 

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

    1819. 

  1819.                             $sender=1;

    1820. 

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

    1821. 

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

    1822. 

  1822.                             $this->Sendmail->__destruct();

    1823. 

  1823.                             //$this->redirect('creativezones/mail_notification_set_price/'.$transactionId.'/'.$receiver);

    1824. 

  1824.                         }

    1825. 

  1825.                     }

    1826. 

  1826.                 }

    1827. 

  1827. 

    1828. 

  1828.                 //mail sent to the user personal account

    1829. 

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

    1830. 

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

    1831. 

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

    1832. 

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

    1833. 

  1833. 

    1834. 

  1834.                     $subject="XOimages - Scrapfoto Invoice ".$invoice;

    1835. 

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

    1836. 

  1836. 

    1837. 

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

    1838. 

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

    1839. 

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

    1840. 

  1840.                     $this->Sendmail->view= 'mail_scrapdownload';

    1841. 

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

    1842. 

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

    1843. 

  1843. 

    1844. 

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

    1845. 

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

    1846. 

  1846.                     $this->Sendmail->Attach($zipdestination.$zipfilename, "image/jpeg" ) ;        // attach a file of type image/gif

    1847. 

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

    1848. 

  1848. 

    1849. 

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

    1850. 

  1850.                     $sender=1;

    1851. 

  1851.                     $receiver=$userId;

    1852. 

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

    1853. 

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

    1854. 

  1854.                     $this->Sendmail->__destruct();

    1855. 

  1855.                 }

    1856. 

  1856.             }

    1857. 

  1857. 

    1858. 

  1858.             $sql = "SELECT Favorite.id FROM creative_carts as Cart

    1859. 

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

    1860. 

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

    1861. 

  1861.                     WHERE Cart.transaction_creative_id='".$transactionId."'  ";

    1862. 

  1862. 

    1863. 

  1863.             $result = mysql_query($sql);

    1864. 

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

    1865. 

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

    1866. 

  1866.                     mysql_query("UPDATE creative_favorites SET is_temp='0' WHERE id='".$row['id']."' ");

    1867. 

  1867.                 }

    1868. 

  1868.             }

    1869. 

  1869. 

    1870. 

  1870.             $queryTransactionCreatives=mysql_query("SELECT invoice,scrapfoto_file FROM transaction_creatives WHERE id='".$transactionId."'");

    1871. 

  1871.             $fetchTransactionCreatives=mysql_fetch_assoc($queryTransactionCreatives);

    1872. 

  1872. 

    1873. 

  1873.             $this->set("transactionInv",$fetchTransactionCreatives['invoice']);

    1874. 

  1874.             $this->set('scrapbookfilename',$fetchTransactionCreatives['scrapfoto_file']);

    1875. 

  1875. 

    1876. 

  1876.             $downloadimg=$this->getCartImages($_SESSION['UserId'],$transactionId,true);

    1877. 

  1877.             $this->set("downloadImage",$downloadimg);

    1878. 

  1878.         }

    1879. 

  1879.         //

    1880. 

  1880. 

    1881. 

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

    1882. 

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

    1883. 

  1883.         $this->creativeType();

    1884. 

  1884.         $this->getPublicScrap();

    1885. 

  1885. 

    1886. 

  1886. 

    1887. 

  1887.         $this->countFavCart();

    1888. 

  1888. 

    1889. 

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

    1890. 

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

    1891. 

  1891.         $this->set("nextpage","success");

    1892. 

  1892. 

    1893. 

  1893.         //_________________________________________________________________________________________________

    1894. 

  1894. 

    1895. 

  1895.         $this->render('success','creativehome');

    1896. 

  1896.         //unset($_POST);

    1897. 

  1897.         //unset($_SESSION['buyTemplate']);

    1898. 

  1898.     }

    1899. 

  1899. 

    1900. 

  1900.     function transactionfee_payment_notify() {

    1901. 

  1901. 

    1902. 

  1902.     }

    1903. 

  1903. 

    1904. 

  1904.     function transactionfee_success() {

    1905. 

  1905.         $this->checkSession();

    1906. 

  1906.         //

    1907. 

  1907.         $paypal=0;

    1908. 

  1908.         //____________________________________________________IPN DATA SECTION______________________________________________

    1909. 

  1909. 

    1910. 

  1910.         //This section is used to catch from PAYPAL IPN data

    1911. 

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

    1912. 

  1912.             $paypal=1;

    1913. 

  1913. 

    1914. 

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

    1915. 

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

    1916. 

  1916. 

    1917. 

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

    1918. 

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

    1919. 

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

    1920. 

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

    1921. 

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

    1922. 

  1922.         }

    1923. 

  1923. 

    1924. 

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

    1925. 

  1925.         if(!$paypal) {

    1926. 

  1926. 

    1927. 

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

    1928. 

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

    1929. 

  1929.             if($xml_response) {

    1930. 

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

    1931. 

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

    1932. 

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

    1933. 

  1933. 

    1934. 

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

    1935. 

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

    1936. 

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

    1937. 

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

    1938. 

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

    1939. 

  1939.                 $totalPay=$ipnData['5'];

    1940. 

  1940.             }

    1941. 

  1941.         }

    1942. 

  1942.         //____________________________________________________XOIMAGE DATABASE UPDATION_____________________________________

    1943. 

  1943. 

    1944. 

  1944.         $tf = $this->Transaction_creatives->findByInvoice($invoice);

    1945. 

  1945.         if($tf) {

    1946. 

  1946.             $tf['Transaction_creatives']['is_pay_transaction_fee'] = '1';

    1947. 

  1947.             $this->Transaction_creatives->save($tf);

    1948. 

  1948. 

    1949. 

  1949.             $sql = "SELECT FX .id

    1950. 

  1950.                     FROM transaction_creatives TC

    1951. 

  1951.                     RIGHT JOIN creative_carts C ON ( C.transaction_creative_id = TC.id )

    1952. 

  1952.                     RIGHT JOIN creative_cart_details CDT ON ( CDT.creative_cart_id = C.id )

    1953. 

  1953.                     RIGHT JOIN creative_favorites F ON ( F.id = CDT.creative_favorite_id )

    1954. 

  1954.                     RIGHT JOIN creative_favorites FX ON ( FX.id = F.template_id )

    1955. 

  1955.                     WHERE TC.invoice = '".$invoice."'

    1956. 

  1956.                     LIMIT 1 ";

    1957. 

  1957.             $result = mysql_query($sql);

    1958. 

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

    1959. 

  1959.                 $row = mysql_fetch_assoc($result);

    1960. 

  1960.                 $sql = "UPDATE creative_favorites SET is_blocked='0' WHERE id='".$row['id']."'";

    1961. 

  1961.                 mysql_query($sql);

    1962. 

  1962.             }

    1963. 

  1963.             $this->set('sql',$sql);

    1964. 

  1964. 

    1965. 

  1965.             //check unblock user

    1966. 

  1966. 

    1967. 

  1967.             $result = mysql_query("SELECT * FROM creative_favorites WHERE user_id ='".$userId."' and is_blocked='1' LIMIT 1");

    1968. 

  1968.             if(mysql_num_rows($result)<=0) {

    1969. 

  1969.                 mysql_query("UPDATE user_payment_setup SET is_blocked='0' WHERE user_id ='".$userId."' ");

    1970. 

  1970.             }

    1971. 

  1971. 

    1972. 

  1972.         }

    1973. 

  1973. 

    1974. 

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

    1975. 

  1975.         $queryXouserTransactions=mysql_query("SELECT * FROM xouser_transactions WHERE transaction_head='scrapfoto' AND transaction_title='comission paid' AND invoice='".$invoice."'");

    1976. 

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

    1977. 

  1977.             $transactionDesc="ScrapFOTO - scraps transaction fee";

    1978. 

  1978.             $transactionHead="scrapfoto";

    1979. 

  1979.             $transactionTitle="comission paid";

    1980. 

  1980.             $invoice=$invoice;

    1981. 

  1981.             $invoiceId=0;

    1982. 

  1982. 

    1983. 

  1983.             $statusoffee="projectfee";

    1984. 

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

    1985. 

  1985. 

    1986. 

  1986.             $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.)

    1987. 

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

    1988. 

  1988. 

    1989. 

  1989. 

    1990. 

  1990.             //____________________________________________________MAIL MANAGEMENT________________________________________________

    1991. 

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

    1992. 

  1992. 

    1993. 

  1993. 

    1994. 

  1994.             /*if(isset($userDetails['email'])) {

    1995. 

  1995.                     

    1996. 

  1996. 

    1997. 

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

    1998. 

  1998.                     $this->Sendmail->From(FROMMAIL);

    1999. 

  1999.                     $this->Sendmail->To($userDetails['email']);

    2000. 

  2000. 

    2001. 

  2001.                     //$this->Sendmail->Cc($sellDetails['email']);

    2002. 

  2002.                     //$this->Sendmail->Cc("amarjit@navsoft.in");

    2003. 

  2003.                     //$this->Sendmail->Bcc( "someoneelse@somewhere.fr");

    2004. 

  2004. 

    2005. 

  2005.                     $subject="XOimages Notification of sales";

    2006. 

  2006.                     $this->Sendmail->Subject($subject);

    2007. 

  2007. 

    2008. 

  2008.                     $this->set("tranId",$transactionId);

    2009. 

  2009.                     

    2010. 

  2010.                     $this->Sendmail->layout='email';

    2011. 

  2011.                     $this->Sendmail->view= 'mail_notification_sales';

    2012. 

  2012.                     $this->Sendmail->startup($this);

    2013. 

  2013.                     $messageBody=$this->Sendmail->bodyText();

    2014. 

  2014. 

    2015. 

  2015.                     $this->Sendmail->Body($messageBody);        // set the body

    2016. 

  2016.                     $this->Sendmail->Priority(1) ;        // set the priority to Low

    2017. 

  2017.                     $this->Sendmail->Send();        // send the mail

    2018. 

  2018. 

    2019. 

  2019.                     //mail sent to the user mail account in the system

    2020. 

  2020. 

    2021. 

  2021.                     $sender=1;

    2022. 

  2022.                     $receiver=$userId;

    2023. 

  2023.                     $this->senderMail($sender,$receiver,$subject,$messageBody);

    2024. 

  2024.                     $this->receiverMail($receiver,$sender,$subject,$messageBody);

    2025. 

  2025.                     $this->Sendmail->__destruct();

    2026. 

  2026.                 }*/

    2027. 

  2027. 

    2028. 

  2028.         }

    2029. 

  2029. 

    2030. 

  2030.         $this->pageTitle = 'ScrapFOTO&trade; - transaction fee success';

    2031. 

  2031.         $this->layout = 'creativemysales';

    2032. 

  2032.         $this->creativeType();

    2033. 

  2033.         $this->countFavCart();

    2034. 

  2034.         $this->getPublicScrap();

    2035. 

  2035. 

    2036. 

  2036.         $this->set('transactionInv',$invoice);

    2037. 

  2037. 

    2038. 

  2038.     }

    2039. 

  2039.     //test

    2040. 

  2040.     function mail_scrapdownload($tranId) {

    2041. 

  2041.         $this->layout = 'email';

    2042. 

  2042.         $this->set("tranId",$tranId);

    2043. 

  2043.     }

    2044. 

  2044.     function mail_notification_set_price($tranId,$receiver) {

    2045. 

  2045.         $this->layout = 'email';

    2046. 

  2046.         $this->set('num_sell',2);

    2047. 

  2047.         $this->set("tranId",$tranId);

    2048. 

  2048.         $this->set("sellerId",$receiver);

    2049. 

  2049.     }

    2050. 

  2050. 

    2051. 

  2051.     function setpriceproduct($ssn_id) {

    2052. 

  2052.         $this->checkSession();

    2053. 

  2053.         $this->layout = 'creativedetail';

    2054. 

  2054.         $this->creativeType();

    2055. 

  2055.         $this->countFavCart();

    2056. 

  2056.         $this->getRankScrap();

    2057. 

  2057.         $this->getFeaturedScrap();

    2058. 

  2058.         $this->getPublicScrap();

    2059. 

  2059. 

    2060. 

  2060.         $this->set('id',$ssn_id);

    2061. 

  2061. 

    2062. 

  2062.         if($ssn_id!=null) {

    2063. 

  2063.             $query = "SELECT * FROM creative_favorites WHERE ssn_id='".$ssn_id."' AND user_id='".$_SESSION['UserId']."' and is_republished='1' LIMIT 1 ";

    2064. 

  2064.             $favs = mysql_query($query);

    2065. 

  2065.             if($favs && mysql_num_rows($favs)>0) {

    2066. 

  2066.                 $fav = mysql_fetch_array($favs);

    2067. 

  2067.                 $fav = $this->Creative_favorites->findById($fav['id']);

    2068. 

  2068.                 if($this->data) {

    2069. 

  2069.                     $fav['Creative_favorites']['price'] = $this->data['creativezones']['price'];

    2070. 

  2070.                     $this->Creative_favorites->save($fav);

    2071. 

  2071.                 }

    2072. 

  2072.                 $this->set('price',$fav['Creative_favorites']['price']);

    2073. 

  2073.             }

    2074. 

  2074.         }

    2075. 

  2075.     }

    2076. 

  2076. 

    2077. 

  2077. 

    2078. 

  2078.     function downloadscraps() {

    2079. 

  2079.         $fileName=$this->params['url']['f'];

    2080. 

  2080.         $basePath='../app/webroot/creativezone/downloadscraps/';

    2081. 

  2081.         $this->Download->downloadFile($basePath,$fileName);

    2082. 

  2082.     }

    2083. 

  2083. 

    2084. 

  2084.     function getUserLastTransaction($userId) {

    2085. 

  2085.         $queryTransactionCreatives=mysql_query("SELECT id FROM transaction_creatives WHERE user_id='".$userId."' ORDER BY id DESC") or die("Error on line - ".__LINE__.mysql_error());

    2086. 

  2086.         if(mysql_num_rows($queryTransactionCreatives)>0) {

    2087. 

  2087.             $fetchTransactionCreatives=mysql_fetch_assoc($queryTransactionCreatives);

    2088. 

  2088.             return $fetchTransactionCreatives;

    2089. 

  2089.         }

    2090. 

  2090. 

    2091. 

  2091.     }

    2092. 

  2092. 

    2093. 

  2093. 

    2094. 

  2094.     function scrapsbuynow() {

    2095. 

  2095.         $this->checkSession();

    2096. 

  2096.         $this->pageTitle = 'ScrapFOTO&trade; - Payment';

    2097. 

  2097.         $this->layout = 'creativedetail';

    2098. 

  2098.         $this->getPublicScrap();

    2099. 

  2099. 

    2100. 

  2100.         if(isset($this->params['url']['seller'])) {

    2101. 

  2101.             $sellerId=base64_decode($this->params['url']['seller']);

    2102. 

  2102. 

    2103. 

  2103. 

    2104. 

  2104.             $cartsql = "

    2105. 

  2105. 									SELECT CM.id,Cfav.id as favid,CM.product_name,Creativedetail.imagename,

    2106. 

  2106. 									CM.qty,CM.price ,(CM.price*CM.qty) as subtotal  

    2107. 

  2107. 									from creative_carts CM 

    2108. 

  2108. 									LEFT JOIN creative_cart_details Creativedetail ON CM.id =Creativedetail.creative_cart_id

    2109. 

  2109. 									LEFT JOIN creative_favorites Cfav ON CM.product_name = Cfav.title

    2110. 

  2110. 									LEFT JOIN creative_template_pages ctemppage ON Cfav.id=ctemppage.id

    2111. 

  2111. 									where 

    2112. 

  2112. 									CM.user_id='".$_SESSION['UserId']."' AND CM.ssn_id='".session_id()."'and CM.pay_status='0'   ";

    2113. 

  2113. 

    2114. 

  2114. 

    2115. 

  2115. 

    2116. 

  2116.             $this->set('mycartsql',$cartsql);

    2117. 

  2117. 

    2118. 

  2118.             $newcartsql ="

    2119. 

  2119. 						SELECT ifnull( Buser.username, 'NA') AS username,

    2120. 

  2120. 						Cfav.id , Cfav.user_id,

    2121. 

  2121. 						COUNT( Cfav.title) as creative_count

    2122. 

  2122. 						FROM creative_carts Creativecart

    2123. 

  2123. 						LEFT JOIN creative_favorites Cfav ON Creativecart.product_name = Cfav.title

    2124. 

  2124. 						

    2125. 

  2125. 						LEFT JOIN users Buser ON ( Cfav.user_id = Buser.id )

    2126. 

  2126. 						

    2127. 

  2127. 						WHERE Creativecart.user_id = '".$_SESSION['UserId']."'

    2128. 

  2128. 						AND Creativecart.ssn_id = '".session_id()."'

    2129. 

  2129. 						AND Creativecart.pay_status = '0' AND Cfav.user_id='".$sellerId."'

    2130. 

  2130. 						GROUP BY Cfav.user_id

    2131. 

  2131. 						";

    2132. 

  2132. 

    2133. 

  2133. 

    2134. 

  2134.             $this->set('newmycartsql',$newcartsql);

    2135. 

  2135.             if($sellerId==$_SESSION['UserId']) {

    2136. 

  2136.                 $this->set("sellerId",1);

    2137. 

  2137.                 $paymentMethods=$this->getPaymentMethods(1);	// that means payment will go to the admin paymenbt id

    2138. 

  2138.             }

    2139. 

  2139.             else {

    2140. 

  2140.                 $this->set("sellerId",$sellerId);

    2141. 

  2141.                 $paymentMethods=$this->getPaymentMethodsUsers($sellerId);

    2142. 

  2142.             }

    2143. 

  2143. 

    2144. 

  2144.             $this->set("paymentMethods",$paymentMethods);

    2145. 

  2145.         }

    2146. 

  2146. 

    2147. 

  2147.     }

    2148. 

  2148. 

    2149. 

  2149.     //checking

    2150. 

  2150.     function countFavCart() {

    2151. 

  2151.         //get creativeFavCount

    2152. 

  2152.         $creativeFavCount=0;

    2153. 

  2153.         if(isset($_SESSION['UserId'])) {

    2154. 

  2154.             if(isset($_SESSION['buyTemplate']['tmpId'])) {

    2155. 

  2155.                 $favQry = mysql_query("SELECT * FROM creative_favorites WHERE user_id ='".$_SESSION['UserId']."' AND template_id>0 AND is_temp='0' ") or die("Error on line :".__LINE__.mysql_error());

    2156. 

  2156.             }else {

    2157. 

  2157.                 $favQry = mysql_query("SELECT * FROM creative_favorites WHERE user_id ='".$_SESSION['UserId']."' AND template_id<=0 AND is_temp='0' AND is_republished='1' ") or die("Error on line :".__LINE__.mysql_error());

    2158. 

  2158.             }

    2159. 

  2159.             $creativeFavCount = mysql_num_rows($favQry);

    2160. 

  2160.         }

    2161. 

  2161.         $this->set("creativeFavCount",$creativeFavCount);

    2162. 

  2162. 

    2163. 

  2163.         //get creativeCart Count

    2164. 

  2164.         $creativeCart=0;

    2165. 

  2165.         if(isset($_SESSION['UserId'])) {

    2166. 

  2166.             $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"));

    2167. 

  2167.         }

    2168. 

  2168. 

    2169. 

  2169.         $this->set("creativeCart",$creativeCart);

    2170. 

  2170.         //get config payment

    2171. 

  2171.         $result = $this->getConfigAmount('creative price');

    2172. 

  2172.         $this->set("creative_price",number_format($result['config_value'],2));

    2173. 

  2173. 

    2174. 

  2174.         return $creativeCart;

    2175. 

  2175.     }

    2176. 

  2176.     //ok

    2177. 

  2177.     function getCartDetails($is_return=false) {

    2178. 

  2178.         $sql ="SELECT CM.id,CM.cart_name,(CD.price*CD.qty) as subTotal,CD.product_name,CD.qty,CD.id as cart_detail_id,CD.creative_favorite_id,CF.fileThumb2 as imagename

    2179. 

  2179.                FROM creative_carts CM,creative_cart_details CD,  creative_favorites as CF

    2180. 

  2180.                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']."'

    2181. 

  2181. 		";

    2182. 

  2182.         $queryCreativeCarts = mysql_query($sql) or die("Error on line : ".__LINE__.mysql_error());

    2183. 

  2183.         $this->set("queryCreativeCarts",$queryCreativeCarts);

    2184. 

  2184.         if($is_return)

    2185. 

  2185.             return mysql_query($sql);

    2186. 

  2186. 

    2187. 

  2187.     }

    2188. 

  2188.     //ok

    2189. 

  2189.     function removefromcart() {

    2190. 

  2190.         $cartId =0;

    2191. 

  2191. 

    2192. 

  2192.         if(isset($this->params['url']['cartid']) && isset($this->params['url']['cartdtid']) && isset($this->params['url']['act']) && $this->params['url']['act']=='del' ) {

    2193. 

  2193.             $cartId=base64_decode($this->params['url']['cartid']);

    2194. 

  2194.             $cartdtId=base64_decode($this->params['url']['cartdtid']);

    2195. 

  2195.             mysql_query("DELETE FROM creative_cart_details WHERE creative_cart_id='".$cartId."' AND id ='".$cartdtId."'");

    2196. 

  2196.             $this->set("action",strtoupper($this->params['url']['act']));

    2197. 

  2197.         }

    2198. 

  2198. 

    2199. 

  2199.         $this->set("cartId",$cartId);

    2200. 

  2200. 

    2201. 

  2201.         if(isset($this->params['url']['act']) && $this->params['url']['act']=='edit') {

    2202. 

  2202.             $this->set("action",strtoupper($this->params['url']['act']));

    2203. 

  2203.         }

    2204. 

  2204. 

    2205. 

  2205.         //this is to check whther the delete method is called from CREATIVE_FAVORITE function or CREATIVE_CART

    2206. 

  2206.         if(isset($this->params['url']['f']))

    2207. 

  2207.             $this->set("f",$this->params['url']['f']);

    2208. 

  2208. 

    2209. 

  2209.         $this->getCartDetails();

    2210. 

  2210.         $this->getUserDetails();

    2211. 

  2211.         $this->countFavCart();

    2212. 

  2212. 

    2213. 

  2213.         $fetchAdminPaymentSetup=$this->getPaymentMethods(1);	// that means payment will go to the admin paymenbt id

    2214. 

  2214.         $this->set("paymentMethods",$fetchAdminPaymentSetup);

    2215. 

  2215. 

    2216. 

  2216.         $this->render("cartlist","ajax");

    2217. 

  2217.     }

    2218. 

  2218.     //checking

    2219. 

  2219.     function delfavorite() {

    2220. 

  2220.         $this->checkSession();

    2221. 

  2221.         if(isset($this->params['url']['fid'])) {

    2222. 

  2222.             $favId=base64_decode($this->params['url']['fid']);

    2223. 

  2223. 

    2224. 

  2224.             $sql = "SELECT * FROM creative_favorites WHERE id='".$favId."' AND user_id='".$_SESSION['UserId']."'";

    2225. 

  2225.             $result = mysql_query($sql) or die("Error on line : ".__LINE__.mysql_error());

    2226. 

  2226.             if(mysql_num_rows($result)>0) {

    2227. 

  2227.                 $sql="UPDATE creative_favorites SET is_temp='1' WHERE id='".$favId."' AND user_id='".$_SESSION['UserId']."'";

    2228. 

  2228.                 mysql_query($sql) or die("Error on line : ".__LINE__.mysql_error());

    2229. 

  2229. 

    2230. 

  2230.                 /*$sql="DELETE FROM creative_favorites_details WHERE creative_favorite_id='".$favId."'";

    2231. 

  2231.                 mysql_query($sql) or die("Error on line : ".__LINE__.mysql_error());

    2232. 

  2232. 

    2233. 

  2233.                 $sql="DELETE FROM creative_favorite_comments WHERE creative_favorite_id='".$favId."'";

    2234. 

  2234.                 mysql_query($sql) or die("Error on line : ".__LINE__.mysql_error());

    2235. 

  2235. 

    2236. 

  2236.                 $sql="DELETE FROM creative_favorite_lovers WHERE creative_favorite_id='".$favId."'";

    2237. 

  2237.                 mysql_query($sql) or die("Error on line : ".__LINE__.mysql_error());

    2238. 

  2238. 

    2239. 

  2239.                 $sql="DELETE FROM creative_favorite_tags WHERE creative_favorite_id='".$favId."'";

    2240. 

  2240.                 mysql_query($sql) or die("Error on line : ".__LINE__.mysql_error());

    2241. 

  2241. 

    2242. 

  2242.                 $sql="DELETE FROM creative_favorite_voting WHERE creative_favorite_id='".$favId."'";

    2243. 

  2243.                 mysql_query($sql) or die("Error on line : ".__LINE__.mysql_error());

    2244. 

  2244.                 */

    2245. 

  2245.                 //note check delete item in cart

    2246. 

  2246.                 //get cart not pay

    2247. 

  2247.                 $sql = "SELECT * FROM creative_carts WHERE pay_status='0'";

    2248. 

  2248.                 $result = mysql_query($sql) or die("Error on line : ".__LINE__.mysql_error());

    2249. 

  2249.                 while ($row = mysql_fetch_array($result)) {

    2250. 

  2250.                     $sql="DELETE FROM creative_cart_details  WHERE creative_cart_id='".$row['id']."' AND creative_favorite_id='".$favId."'";

    2251. 

  2251.                     mysql_query($sql) or die("Error on line : ".__LINE__.mysql_error());

    2252. 

  2252.                 }

    2253. 

  2253.             }

    2254. 

  2254. 

    2255. 

  2255.         }

    2256. 

  2256. 

    2257. 

  2257.         $this->redirect("/creativezones/creative_favorite");

    2258. 

  2258.     }

    2259. 

  2259.     //checking

    2260. 

  2260.     function addtocart() {

    2261. 

  2261.         $favId=base64_decode($this->data['xoevent']['favoriteId']);

    2262. 

  2262. 

    2263. 

  2263.         $result=mysql_query("	SELECT *

    2264. 

  2264. 				FROM creative_favorites 

    2265. 

  2265. 				WHERE id='".$favId."' AND user_id='".$_SESSION['UserId']."'");

    2266. 

  2266.         if(mysql_num_rows($result)>0) {

    2267. 

  2267.             $fav=mysql_fetch_assoc($result);

    2268. 

  2268.             $productId=$fav['id'];

    2269. 

  2269.             $cart_name="Scrap";

    2270. 

  2270.             $price=$fav['price'];

    2271. 

  2271.             $productName=$fav['title'];

    2272. 

  2272. 

    2273. 

  2273.             if(!isset($_SESSION['buyTemplate']) || !isset($_SESSION['buyTemplate']['tmpId'])) {

    2274. 

  2274.                 $creative_price=$this->getConfigAmount('creative price');

    2275. 

  2275.                 $price = $creative_price['config_value'];

    2276. 

  2276.             }

    2277. 

  2277. 

    2278. 

  2278.             $result = mysql_query("SELECT * FROM creative_carts WHERE user_id='".$_SESSION['UserId']."' AND pay_status='0' LIMIT 1");

    2279. 

  2279.             if(mysql_num_rows($result)>0) {

    2280. 

  2280.                 $cart = mysql_fetch_assoc($result);

    2281. 

  2281.                 $cart_id = $cart['id'];

    2282. 

  2282.                 //check if buyTemplate

    2283. 

  2283.                 if($fav['template_id']>0) {

    2284. 

  2284.                     mysql_query("DELETE FROM creative_cart_details WHERE creative_cart_id='".$cart_id."' ");

    2285. 

  2285.                 }

    2286. 

  2286. 

    2287. 

  2287.             }else {

    2288. 

  2288.                 mysql_query("INSERT INTO

    2289. 

  2289.                                     creative_carts(user_id,cart_name,transaction_creative_id,pay_status)

    2290. 

  2290.                                     VALUES('".$_SESSION['UserId']."','".$cart_name."','0','0')") or die("Error on line : ".__LINE__.mysql_error());

    2291. 

  2291. 

    2292. 

  2292.                 $cart_id=mysql_insert_id();

    2293. 

  2293.             }

    2294. 

  2294. 

    2295. 

  2295. 

    2296. 

  2296.             $result = mysql_query("SELECT * FROM creative_cart_details WHERE creative_cart_id='".$cart_id."' AND creative_favorite_id='$productId' LIMIT 1");

    2297. 

  2297.             if(mysql_num_rows($result)>0) {

    2298. 

  2298.                 $cartdetail = mysql_fetch_assoc($result);

    2299. 

  2299.                 mysql_query("UPDATE FROM creative_cart_details SET product_name='".$productName."' price='$price',qty='1' WHERE id='".$cartdetail['id']."' ");

    2300. 

  2300.             }else {

    2301. 

  2301.                 mysql_query("INSERT INTO creative_cart_details SET creative_cart_id='$cart_id' ,creative_favorite_id='$productId', product_name='".$productName."',price='$price',qty='1'");

    2302. 

  2302.             }

    2303. 

  2303.         }

    2304. 

  2304.         $this->getCartDetails();

    2305. 

  2305.         $this->countFavCart();

    2306. 

  2306.         $this->render("addtocart","ajax");

    2307. 

  2307.     }

    2308. 

  2308. 

    2309. 

  2309.     function photolover($id=null) {

    2310. 

  2310.         if(isset($_SESSION['UserId'])&& $id) {

    2311. 

  2311.             $checklover = "Select * from creative_favorite_lovers where user_id='".$_SESSION['UserId']."' and creative_favorite_id='".$id."'" ;

    2312. 

  2312.             $checklover_res = mysql_query($checklover);

    2313. 

  2313.             $checklover_res_num = mysql_num_rows($checklover_res);

    2314. 

  2314.             if($checklover_res_num==0) {

    2315. 

  2315.                 $insertlover = "INSERT INTO creative_favorite_lovers SET user_id='".$_SESSION['UserId']."', creative_favorite_id='".$id."' ";

    2316. 

  2316.                 $insertlover=mysql_query($insertlover);

    2317. 

  2317.             }

    2318. 

  2318. 

    2319. 

  2319. 

    2320. 

  2320.         }

    2321. 

  2321.         $checklover = "Select * from creative_favorite_lovers where creative_favorite_id='".$id."'" ;

    2322. 

  2322.         $checklover_res = mysql_query($checklover);

    2323. 

  2323.         $checklover_res_num = mysql_num_rows($checklover_res);

    2324. 

  2324.         $this->set('nooflover', $checklover_res_num);

    2325. 

  2325.         $this->set('photoId', $id);

    2326. 

  2326. 

    2327. 

  2327.         $this->render('photolover', 'ajax');

    2328. 

  2328. 

    2329. 

  2329.     }

    2330. 

  2330. 

    2331. 

  2331.     function addtag($photoId=null) {

    2332. 

  2332.         /* */

    2333. 

  2333.         $this->set('photoImageId',$_REQUEST['hfphotopid']);

    2334. 

  2334.         if(isset($_REQUEST['hfphotopid']) && $_REQUEST['hfphotopid']>0 && isset($_SESSION['UserId']) && addslashes($_REQUEST['phototag'])!='Enter Tag') {

    2335. 

  2335.             /* INSERT INTO TAGE TABLE */

    2336. 

  2336.             $insersql = "INSERT INTO creative_favorite_tags SET user_id='".$_SESSION['UserId']."',creative_favorite_id='".$_REQUEST['hfphotopid']."',tagname='".addslashes($_REQUEST['phototag'])."' ";

    2337. 

  2337.             $insersql_res = mysql_query($insersql);

    2338. 

  2338.         }

    2339. 

  2339.         $this->set('photoImageId', $_REQUEST['hfphotopid']);

    2340. 

  2340.         $this->render('taglist', 'ajax');

    2341. 

  2341.     }

    2342. 

  2342. 

    2343. 

  2343.     function Postreview() {

    2344. 

  2344.         if(isset($_REQUEST['hfphotoid']) && $_REQUEST['hfphotoid']>0 && isset($_SESSION['UserId'])) {

    2345. 

  2345.             /* Getting out the review*/

    2346. 

  2346.             $selectRec= "Select * from creative_favorite_comments where user_id='".$_SESSION['UserId']."' and  creative_favorite_id='".$_REQUEST['hfphotoid']."'" ;

    2347. 

  2347.             $selectRec_res = mysql_query($selectRec);

    2348. 

  2348.             if(mysql_num_rows($selectRec_res)==0) {

    2349. 

  2349.                 $insertIntoreview = "Insert into creative_favorite_comments SET user_id='".$_SESSION['UserId']."',creative_favorite_id='".$_REQUEST['hfphotoid']."',comment_desc='".addslashes($_REQUEST['reviewdesc'])."' ";

    2350. 

  2350.                 mysql_query($insertIntoreview);

    2351. 

  2351. 

    2352. 

  2352.             }

    2353. 

  2353.         }

    2354. 

  2354.         $this->set('photoId', $_REQUEST['hfphotoid']);

    2355. 

  2355.         $this->render('reviewlist', 'ajax');

    2356. 

  2356.     }

    2357. 

  2357. 

    2358. 

  2358.     function getCreativeType($scrapId) {

    2359. 

  2359.         $queryCreativeType=mysql_query("SELECT * FROM creative_type WHERE id='".$scrapId."'");

    2360. 

  2360.         $fetchCreativeType=mysql_fetch_assoc($queryCreativeType);

    2361. 

  2361.         return $fetchCreativeType;

    2362. 

  2362.     }

    2363. 

  2363. 

    2364. 

  2364.     function myscrapxing($idDelete=null) {

    2365. 

  2365.         $this->checksession();

    2366. 

  2366.         $this->layout = 'creativeinner';

    2367. 

  2367.         ############################### Page Title  & Head ############################

    2368. 

  2368.         $this->pageTitle = 'My ScrapFOTO - My Favorite';

    2369. 

  2369.         $this->set('pagehead','My Favorite');

    2370. 

  2370. 

    2371. 

  2371.         if($idDelete!=null) {

    2372. 

  2372.             $delquery ="UPDATE creative_favorites SET is_temp='1' where user_id='".$_SESSION['UserId']."' AND id='".base64_decode($idDelete)."' ";

    2373. 

  2373.             mysql_query($delquery);

    2374. 

  2374.         }

    2375. 

  2375.         ############################### Page Title  & Head ############################

    2376. 

  2376.         /* Pagination and PHOTO listing */

    2377. 

  2377.         $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";

    2378. 

  2378. 

    2379. 

  2379.         $from=" FROM creative_favorites X

    2380. 

  2380.                     RIGHT JOIN creative_favorites X1 ON ( (X.template_id>0 and X1.id=X.template_id) || (X.template_id=0 and X1.id=X.id) )

    2381. 

  2381.                     LEFT JOIN creative_type XCreativetype ON X.creative_type_id = XCreativetype.id

    2382. 

  2382.                     LEFT JOIN creative_favorite_comments Xcomment ON X.id = Xcomment.creative_favorite_id

    2383. 

  2383.                     LEFT JOIN users Xuser ON  X1.user_id = Xuser.id

    2384. 

  2384.                     LEFT JOIN user_details Xuserdetail ON X1.user_id = Xuserdetail.user_id

    2385. 

  2385.                     LEFT JOIN creative_favorite_voting Xrating ON X.id = Xrating.creative_favorite_id";

    2386. 

  2386. 

    2387. 

  2387.         $where=" WHERE  X.is_blocked='0' AND X.is_temp='0' ";

    2388. 

  2388.         $where.=" AND X.user_id='".$_SESSION['UserId']."' ";

    2389. 

  2389. 

    2390. 

  2390.         $others=" group by X.id ";

    2391. 

  2391.         $others.=" order by X.id desc";

    2392. 

  2392.         $PassParameter='';

    2393. 

  2393.         $fltr='';

    2394. 

  2394.         $CountField="X.id";

    2395. 

  2395.         $this->set("controller","creativezones");

    2396. 

  2396.         $this->set("action","myscrapxing");

    2397. 

  2397.         $this->set("parameter",$PassParameter);

    2398. 

  2398.         $this->set("fltr",$fltr);

    2399. 

  2399. 

    2400. 

  2400.         $this->set('sql',$select.$from.$where.$others);

    2401. 

  2401.         $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);

    2402. 

  2402.         if(isset($this->params['url']['Page']) || (isset($fltr) && $fltr!="") || $idDelete!=null) {

    2403. 

  2403.             $this->render("myscrapxing2","ajax");

    2404. 

  2404.         }

    2405. 

  2405. 

    2406. 

  2406.         /**/

    2407. 

  2407.         $this->creativeType();

    2408. 

  2408.         $this->countFavCart();

    2409. 

  2409.         $this->getPublicScrap();

    2410. 

  2410.     }

    2411. 

  2411. 

    2412. 

  2412.     function approve() {

    2413. 

  2413.         $this->checkSession();

    2414. 

  2414.         unset($_SESSION['buyTemplate']);

    2415. 

  2415.         $this->layout = 'creativeinner';

    2416. 

  2416. 

    2417. 

  2417.         $viewSearchType = '';

    2418. 

  2418. 

    2419. 

  2419.         if((isset($this->params['url']['hfsearch']) && $this->params['url']['hfsearch']!='') || isset($_REQUEST['hfsearch']) )

    2420. 

  2420.             $viewSearchType=$_REQUEST['hfsearch'];

    2421. 

  2421. 

    2422. 

  2422. 

    2423. 

  2423. 

    2424. 

  2424.         ############################### Page Title  & Head ############################

    2425. 

  2425.         $this->pageTitle = 'ScrapFOTO&trade; '.'Approve';

    2426. 

  2426.         $this->set('pagehead','Approve');

    2427. 

  2427. 

    2428. 

  2428.         ############################### Page Title  & Head ############################

    2429. 

  2429.         /* Pagination and PHOTO listing */

    2430. 

  2430.         $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

    2431. 

  2431.                     , X.creation, X.is_stop_sell,Ticket.msg_to_user,X.num_sell,X.is_approved";

    2432. 

  2432. 

    2433. 

  2433.         $from=" FROM creative_favorites X

    2434. 

  2434.                                 LEFT JOIN creative_tickets Ticket ON X.id = Ticket.creative_favorites_id

    2435. 

  2435. 				LEFT JOIN creative_type XCreativetype ON X.creative_type_id = XCreativetype.id

    2436. 

  2436. 

    2437. 

  2437. 				LEFT JOIN creative_favorite_comments Xcomment ON X.id = Xcomment.creative_favorite_id

    2438. 

  2438. 				LEFT JOIN users Xuser ON  X.user_id = Xuser.id

    2439. 

  2439. 				LEFT JOIN user_details Xuserdetail ON X.user_id = Xuserdetail.user_id

    2440. 

  2440. 				LEFT JOIN creative_favorite_voting Xrating ON X.id = Xrating.creative_favorite_id";

    2441. 

  2441. 

    2442. 

  2442.         $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' ";

    2443. 

  2443. 

    2444. 

  2444. 

    2445. 

  2445.         $searchpass='';

    2446. 

  2446.         if($viewSearchType=='title' && isset($_REQUEST['txtsrch']) && $_REQUEST['txtsrch']!='') {

    2447. 

  2447.             $where.="  AND X.title like '%".$_REQUEST['txtsrch']."%' ";

    2448. 

  2448.             $searchpass = "&txtsrch=".$_REQUEST['txtsrch'] ;

    2449. 

  2449.         }

    2450. 

  2450. 

    2451. 

  2451.         if($viewSearchType=='prodid') {

    2452. 

  2452.             $where.="  AND X.ssn_id like '%".$_REQUEST['txtsrch']."%'";

    2453. 

  2453.             $searchpass = "&txtsrch=".$_REQUEST['txtsrch'] ;

    2454. 

  2454.         }

    2455. 

  2455. 

    2456. 

  2456.         if($viewSearchType=='daterange') {

    2457. 

  2457.             if($_REQUEST['inpdatefrom'] && $_REQUEST['inpdatefrom']!='mm/dd/YY') {

    2458. 

  2458.                 $eventFromDate=date("Y-m-d",strtotime($_REQUEST['inpdatefrom']));

    2459. 

  2459.                 $urlfromdate  = $_REQUEST['inpdatefrom'];

    2460. 

  2460.             }

    2461. 

  2461.             else {

    2462. 

  2462.                 $eventFromDate=date("Y-m-d");

    2463. 

  2463.                 $urlfromdate  = $_REQUEST['inpdatefrom'];

    2464. 

  2464.             }

    2465. 

  2465. 

    2466. 

  2466.             if($_REQUEST['inpdateto'] && $_REQUEST['inpdateto']!='mm/dd/YY') {

    2467. 

  2467.                 $eventToDate=date("Y-m-d",strtotime($_REQUEST['inpdateto']));

    2468. 

  2468.                 $urltodate  = $_REQUEST['inpdateto'];

    2469. 

  2469.             }

    2470. 

  2470.             else {

    2471. 

  2471.                 $eventToDate=date("Y-m-d");

    2472. 

  2472.                 $urltodate  = $_REQUEST['inpdateto'];

    2473. 

  2473. 

    2474. 

  2474.             }

    2475. 

  2475. 

    2476. 

  2476.             $where.="  AND X.creation between '".$eventFromDate."' and '".$eventToDate."' ";

    2477. 

  2477.             $searchpass = "&inpdatefrom=".$urlfromdate."&inpdateto=".$urltodate ;

    2478. 

  2478.         }

    2479. 

  2479. 

    2480. 

  2480.         $this->set('searchpass',$where);

    2481. 

  2481. 

    2482. 

  2482. 

    2483. 

  2483.         $others=" group by X.id ";

    2484. 

  2484. 

    2485. 

  2485.         if($viewSearchType=='title')

    2486. 

  2486.             $others .=" order by X.title desc ";

    2487. 

  2487. 

    2488. 

  2488.         if($viewSearchType=='prodid')

    2489. 

  2489.             $others .=" order by X.ssn_id  desc ";

    2490. 

  2490. 

    2491. 

  2491.         if($viewSearchType=='daterange')

    2492. 

  2492.             $others .=" order by X.creation desc ";

    2493. 

  2493. 

    2494. 

  2494.         $PassParameter ='';

    2495. 

  2495.         if($viewSearchType!='') {

    2496. 

  2496.             $PassParameter="hfsearch=".$viewSearchType.$searchpass;

    2497. 

  2497.         }

    2498. 

  2498. 

    2499. 

  2499. 

    2500. 

  2500.         $CountField="X.id";

    2501. 

  2501.         $this->set("controller","creativezones");

    2502. 

  2502.         $this->set("action","approve");

    2503. 

  2503.         $this->set("parameter",$PassParameter);

    2504. 

  2504. 

    2505. 

  2505.         $quantityAllowSell = $this->getConfigAmount('creative quantity sold');

    2506. 

  2506.         $this->set('quantityAllowSell',$quantityAllowSell['config_value']);

    2507. 

  2507. 

    2508. 

  2508.         $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);

    2509. 

  2509.         if(isset($this->params['url']['Page']) || $viewSearchType!='') {

    2510. 

  2510.             $this->render("approve_search","ajax");

    2511. 

  2511.         }

    2512. 

  2512. 

    2513. 

  2513.         /**/

    2514. 

  2514. 

    2515. 

  2515.         $this->creativeType();

    2516. 

  2516.         $this->countFavCart();

    2517. 

  2517.         $this->getPublicScrap();

    2518. 

  2518.     }

    2519. 

  2519. 

    2520. 

  2520.     function reject() {

    2521. 

  2521.         $this->checkSession();

    2522. 

  2522.         $this->layout = 'creativeinner';

    2523. 

  2523. 

    2524. 

  2524.         $viewSearchType = '';

    2525. 

  2525. 

    2526. 

  2526.         if((isset($this->params['url']['hfsearch']) && $this->params['url']['hfsearch']!='') || isset($_REQUEST['hfsearch']) )

    2527. 

  2527.             $viewSearchType=$_REQUEST['hfsearch'];

    2528. 

  2528. 

    2529. 

  2529. 

    2530. 

  2530. 

    2531. 

  2531.         ############################### Page Title  & Head ############################

    2532. 

  2532.         $this->pageTitle = 'ScrapFOTO&trade; '.'Reject';

    2533. 

  2533.         $this->set('pagehead','Reject');

    2534. 

  2534. 

    2535. 

  2535.         ############################### Page Title  & Head ############################

    2536. 

  2536.         /* Pagination and PHOTO listing */

    2537. 

  2537.         $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

    2538. 

  2538.                     , X.creation, X.is_stop_sell,Ticket.msg_to_user,X.num_sell,X.is_approved,Ticket.ticket_number";

    2539. 

  2539. 

    2540. 

  2540.         $from=" FROM creative_favorites X

    2541. 

  2541.                                 LEFT JOIN creative_tickets Ticket ON X.id = Ticket.creative_favorites_id

    2542. 

  2542. 				LEFT JOIN creative_type XCreativetype ON X.creative_type_id = XCreativetype.id

    2543. 

  2543. 

    2544. 

  2544. 				LEFT JOIN creative_favorite_comments Xcomment ON X.id = Xcomment.creative_favorite_id

    2545. 

  2545. 				LEFT JOIN users Xuser ON  X.user_id = Xuser.id

    2546. 

  2546. 				LEFT JOIN user_details Xuserdetail ON X.user_id = Xuserdetail.user_id

    2547. 

  2547. 				LEFT JOIN creative_favorite_voting Xrating ON X.id = Xrating.creative_favorite_id";

    2548. 

  2548. 

    2549. 

  2549.         $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' ";

    2550. 

  2550. 

    2551. 

  2551. 

    2552. 

  2552.         $searchpass='';

    2553. 

  2553.         if($viewSearchType=='title' && isset($_REQUEST['txtsrch']) && $_REQUEST['txtsrch']!='') {

    2554. 

  2554.             $where.="  AND X.title like '%".$_REQUEST['txtsrch']."%' ";

    2555. 

  2555.             $searchpass = "&txtsrch=".$_REQUEST['txtsrch'] ;

    2556. 

  2556.         }

    2557. 

  2557. 

    2558. 

  2558.         if($viewSearchType=='prodid') {

    2559. 

  2559.             $where.="  AND X.ssn_id like '%".$_REQUEST['txtsrch']."%'";

    2560. 

  2560.             $searchpass = "&txtsrch=".$_REQUEST['txtsrch'] ;

    2561. 

  2561.         }

    2562. 

  2562. 

    2563. 

  2563.         if($viewSearchType=='ticket') {

    2564. 

  2564.             $where.="  AND Ticket.ticket_number like '%".$_REQUEST['txtsrch']."%'";

    2565. 

  2565.             $searchpass = "&txtsrch=".$_REQUEST['txtsrch'] ;

    2566. 

  2566.         }

    2567. 

  2567. 

    2568. 

  2568.         if($viewSearchType=='daterange') {

    2569. 

  2569.             if($_REQUEST['inpdatefrom'] && $_REQUEST['inpdatefrom']!='mm/dd/YY') {

    2570. 

  2570.                 $eventFromDate=date("Y-m-d",strtotime($_REQUEST['inpdatefrom']));

    2571. 

  2571.                 $urlfromdate  = $_REQUEST['inpdatefrom'];

    2572. 

  2572.             }

    2573. 

  2573.             else {

    2574. 

  2574.                 $eventFromDate=date("Y-m-d");

    2575. 

  2575.                 $urlfromdate  = $_REQUEST['inpdatefrom'];

    2576. 

  2576.             }

    2577. 

  2577. 

    2578. 

  2578.             if($_REQUEST['inpdateto'] && $_REQUEST['inpdateto']!='mm/dd/YY') {

    2579. 

  2579.                 $eventToDate=date("Y-m-d",strtotime($_REQUEST['inpdateto']));

    2580. 

  2580.                 $urltodate  = $_REQUEST['inpdateto'];

    2581. 

  2581.             }

    2582. 

  2582.             else {

    2583. 

  2583.                 $eventToDate=date("Y-m-d");

    2584. 

  2584.                 $urltodate  = $_REQUEST['inpdateto'];

    2585. 

  2585. 

    2586. 

  2586.             }

    2587. 

  2587. 

    2588. 

  2588.             $where.="  AND X.creation between '".$eventFromDate."' and '".$eventToDate."' ";

    2589. 

  2589.             $searchpass = "&inpdatefrom=".$urlfromdate."&inpdateto=".$urltodate ;

    2590. 

  2590.         }

    2591. 

  2591. 

    2592. 

  2592.         $this->set('searchpass',$where);

    2593. 

  2593. 

    2594. 

  2594. 

    2595. 

  2595. 

    2596. 

  2596.         $others=" group by X.id ";

    2597. 

  2597. 

    2598. 

  2598.         if($viewSearchType=='title')

    2599. 

  2599.             $others .=" order by X.title desc ";

    2600. 

  2600. 

    2601. 

  2601.         if($viewSearchType=='prodid')

    2602. 

  2602.             $others .=" order by X.ssn_id  desc ";

    2603. 

  2603. 

    2604. 

  2604.         if($viewSearchType=='daterange')

    2605. 

  2605.             $others .=" order by X.creation desc ";

    2606. 

  2606. 

    2607. 

  2607.         if($viewSearchType=='ticket')

    2608. 

  2608.             $others .=" order by Ticket.ticket_number desc ";

    2609. 

  2609. 

    2610. 

  2610.         $PassParameter ='';

    2611. 

  2611.         if($viewSearchType!='') {

    2612. 

  2612.             $PassParameter="hfsearch=".$viewSearchType.$searchpass;

    2613. 

  2613.         }

    2614. 

  2614. 

    2615. 

  2615.         $CountField="X.id";

    2616. 

  2616.         $this->set("controller","creativezones");

    2617. 

  2617.         $this->set("action","reject");

    2618. 

  2618.         $this->set("parameter",$PassParameter);

    2619. 

  2619. 

    2620. 

  2620.         $quantityAllowSell = $this->getConfigAmount('creative quantity sold');

    2621. 

  2621.         $this->set('quantityAllowSell',$quantityAllowSell['config_value']);

    2622. 

  2622. 

    2623. 

  2623.         $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);

    2624. 

  2624.         if(isset($this->params['url']['Page']) || $viewSearchType!='') {

    2625. 

  2625.             $this->render("approve_search","ajax");

    2626. 

  2626.         }

    2627. 

  2627.        

    2628. 

  2628.         $this->creativeType();

    2629. 

  2629.         $this->countFavCart();

    2630. 

  2630.         $this->getPublicScrap();

    2631. 

  2631.     }

    2632. 

  2632. 

    2633. 

  2633.     function submission() {

    2634. 

  2634.         $this->checkSession();

    2635. 

  2635.         $this->layout = 'creativeinner';

    2636. 

  2636. 

    2637. 

  2637.         $viewSearchType = '';

    2638. 

  2638. 

    2639. 

  2639.         if((isset($this->params['url']['hfsearch']) && $this->params['url']['hfsearch']!='') || isset($_REQUEST['hfsearch']) )

    2640. 

  2640.             $viewSearchType=$_REQUEST['hfsearch'];

    2641. 

  2641. 

    2642. 

  2642.         ############################### Page Title  & Head ############################

    2643. 

  2643.         $this->pageTitle = 'ScrapFOTO&trade; '.'Submisson';

    2644. 

  2644.         $this->set('pagehead','Submisson');

    2645. 

  2645. 

    2646. 

  2646.         ############################### Page Title  & Head ############################

    2647. 

  2647.         /* Pagination and PHOTO listing */

    2648. 

  2648.         $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

    2649. 

  2649.                     , X.creation, X.is_stop_sell,Ticket.msg_to_user,X.num_sell,X.is_approved,Ticket.ticket_number";

    2650. 

  2650. 

    2651. 

  2651.         $from=" FROM creative_favorites X

    2652. 

  2652.                                 LEFT JOIN creative_tickets Ticket ON X.id = Ticket.creative_favorites_id

    2653. 

  2653. 				LEFT JOIN creative_type XCreativetype ON X.creative_type_id = XCreativetype.id

    2654. 

  2654. 

    2655. 

  2655. 				LEFT JOIN creative_favorite_comments Xcomment ON X.id = Xcomment.creative_favorite_id

    2656. 

  2656. 				LEFT JOIN users Xuser ON  X.user_id = Xuser.id

    2657. 

  2657. 				LEFT JOIN user_details Xuserdetail ON X.user_id = Xuserdetail.user_id

    2658. 

  2658. 				LEFT JOIN creative_favorite_voting Xrating ON X.id = Xrating.creative_favorite_id";

    2659. 

  2659. 

    2660. 

  2660.         $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' ";

    2661. 

  2661. 

    2662. 

  2662.         $searchpass='';

    2663. 

  2663.         if($viewSearchType=='title' && isset($_REQUEST['txtsrch']) && $_REQUEST['txtsrch']!='') {

    2664. 

  2664.             $where.="  AND X.title like '%".$_REQUEST['txtsrch']."%' ";

    2665. 

  2665.             $searchpass = "&txtsrch=".$_REQUEST['txtsrch'] ;

    2666. 

  2666.         }

    2667. 

  2667. 

    2668. 

  2668.         if($viewSearchType=='prodid') {

    2669. 

  2669.             $where.="  AND X.ssn_id like '%".$_REQUEST['txtsrch']."%'";

    2670. 

  2670.             $searchpass = "&txtsrch=".$_REQUEST['txtsrch'] ;

    2671. 

  2671.         }

    2672. 

  2672. 

    2673. 

  2673.         if($viewSearchType=='ticket') {

    2674. 

  2674.             $where.="  AND Ticket.ticket_number like '%".$_REQUEST['txtsrch']."%'";

    2675. 

  2675.             $searchpass = "&txtsrch=".$_REQUEST['txtsrch'] ;

    2676. 

  2676.         }

    2677. 

  2677. 

    2678. 

  2678.         if($viewSearchType=='daterange') {

    2679. 

  2679.             if($_REQUEST['inpdatefrom'] && $_REQUEST['inpdatefrom']!='mm/dd/YY') {

    2680. 

  2680.                 $eventFromDate=date("Y-m-d",strtotime($_REQUEST['inpdatefrom']));

    2681. 

  2681.                 $urlfromdate  = $_REQUEST['inpdatefrom'];

    2682. 

  2682.             }

    2683. 

  2683.             else {

    2684. 

  2684.                 $eventFromDate=date("Y-m-d");

    2685. 

  2685.                 $urlfromdate  = $_REQUEST['inpdatefrom'];

    2686. 

  2686.             }

    2687. 

  2687. 

    2688. 

  2688.             if($_REQUEST['inpdateto'] && $_REQUEST['inpdateto']!='mm/dd/YY') {

    2689. 

  2689.                 $eventToDate=date("Y-m-d",strtotime($_REQUEST['inpdateto']));

    2690. 

  2690.                 $urltodate  = $_REQUEST['inpdateto'];

    2691. 

  2691.             }

    2692. 

  2692.             else {

    2693. 

  2693.                 $eventToDate=date("Y-m-d");

    2694. 

  2694.                 $urltodate  = $_REQUEST['inpdateto'];

    2695. 

  2695. 

    2696. 

  2696.             }

    2697. 

  2697. 

    2698. 

  2698.             $where.="  AND X.creation between '".$eventFromDate."' and '".$eventToDate."' ";

    2699. 

  2699.             $searchpass = "&inpdatefrom=".$urlfromdate."&inpdateto=".$urltodate ;

    2700. 

  2700.         }

    2701. 

  2701. 

    2702. 

  2702.         $this->set('searchpass',$where);

    2703. 

  2703. 

    2704. 

  2704.         $others=" group by X.id ";

    2705. 

  2705. 

    2706. 

  2706.         if($viewSearchType=='title')

    2707. 

  2707.             $others .=" order by X.title desc ";

    2708. 

  2708. 

    2709. 

  2709.         if($viewSearchType=='prodid')

    2710. 

  2710.             $others .=" order by X.ssn_id  desc ";

    2711. 

  2711. 

    2712. 

  2712.         if($viewSearchType=='daterange')

    2713. 

  2713.             $others .=" order by X.creation desc ";

    2714. 

  2714. 

    2715. 

  2715.         if($viewSearchType=='ticket')

    2716. 

  2716.             $others .=" order by Ticket.ticket_number desc ";

    2717. 

  2717. 

    2718. 

  2718.         $PassParameter ='';

    2719. 

  2719.         if($viewSearchType!='') {

    2720. 

  2720.             $PassParameter="hfsearch=".$viewSearchType.$searchpass;

    2721. 

  2721.         }

    2722. 

  2722. 

    2723. 

  2723.         $CountField="X.id";

    2724. 

  2724.         $this->set("controller","creativezones");

    2725. 

  2725.         $this->set("action","submission");

    2726. 

  2726.         $this->set("parameter",$PassParameter);

    2727. 

  2727. 

    2728. 

  2728.         $quantityAllowSell = $this->getConfigAmount('creative quantity sold');

    2729. 

  2729.         $this->set('quantityAllowSell',$quantityAllowSell['config_value']);

    2730. 

  2730. 

    2731. 

  2731.         $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);

    2732. 

  2732.         if(isset($this->params['url']['Page']) || $viewSearchType!='') {

    2733. 

  2733.             $this->render("approve_search","ajax");

    2734. 

  2734.         }

    2735. 

  2735.         

    2736. 

  2736.         $this->creativeType();

    2737. 

  2737.         $this->countFavCart();

    2738. 

  2738.         $this->getPublicScrap();

    2739. 

  2739.     }

    2740. 

  2740. 

    2741. 

  2741.     function approve_msg($id,$is_cancel=null) {

    2742. 

  2742.         $this->set('id',$id);

    2743. 

  2743.         $this->set('is_cancel',$is_cancel);

    2744. 

  2744.         if($is_cancel==null) {

    2745. 

  2745.             $tt = $this->Creative_tickets->findByCreative_favorites_id($id);

    2746. 

  2746.             $this->set('msg',$tt['Creative_tickets']['msg_to_user']);

    2747. 

  2747.         }

    2748. 

  2748. 

    2749. 

  2749.     }

    2750. 

  2750.     function approve_stop_sell($id,$is_stop_sell) {

    2751. 

  2751.         $fav = $this->Creative_favorites->findById($id);

    2752. 

  2752.         if($fav) {

    2753. 

  2753.             $fav['Creative_favorites']['is_stop_sell'] = $is_stop_sell;

    2754. 

  2754.             $this->Creative_favorites->save($fav);

    2755. 

  2755.         }

    2756. 

  2756. 

    2757. 

  2757.         $this->set('id',$id);

    2758. 

  2758.         $this->set('is_stop_sell',$is_stop_sell);

    2759. 

  2759. 

    2760. 

  2760.         $this->render("approve_stop_sell","ajax");

    2761. 

  2761.     }

    2762. 

  2762.     function approve_feature($id,$is_cancel=null) {

    2763. 

  2763.         $this->set('id',$id);

    2764. 

  2764.         $this->set('is_cancel',$is_cancel);

    2765. 

  2765.         if($is_cancel==null) {

    2766. 

  2766.             $featuredAmount=$this->getConfigAmount('creative featured');

    2767. 

  2767.             $this->set('totalAmount',$featuredAmount['config_value']);

    2768. 

  2768. 

    2769. 

  2769.             $featuredDay=$this->getConfigAmount('creative featured days');

    2770. 

  2770.             $this->set('featuredDay',$featuredDay['config_value']);

    2771. 

  2771. 

    2772. 

  2772.             //payment details

    2773. 

  2773.             $sellerId = 1;// that means payment will go to the admin paymenbt id

    2774. 

  2774.             $fetchAdminPaymentSetup=$this->getPaymentMethods($sellerId);

    2775. 

  2775.             $this->set("paymentMethods",$fetchAdminPaymentSetup);

    2776. 

  2776.             $this->set("sellerId",$sellerId);

    2777. 

  2777.             $this->set("receiverId",$sellerId);

    2778. 

  2778.         }

    2779. 

  2779.     }

    2780. 

  2780. 

    2781. 

  2781.     function approve_set_price($id,$is_cancel=null) {

    2782. 

  2782.         $this->set('id',$id);

    2783. 

  2783.         $this->set('is_cancel',$is_cancel);

    2784. 

  2784.         if($is_cancel==null) {

    2785. 

  2785.             if($this->data) {

    2786. 

  2786.                 $fav = $this->Creative_favorites->findById($id);

    2787. 

  2787.                 $fav['Creative_favorites']['price'] = $this->data['creativezones']['price'];

    2788. 

  2788.                 $this->Creative_favorites->save($fav);

    2789. 

  2789.             }else {

    2790. 

  2790.                 $fav = $this->Creative_favorites->findById($id);

    2791. 

  2791.             }

    2792. 

  2792.             $this->set('price',$fav['Creative_favorites']['price']);

    2793. 

  2793. 

    2794. 

  2794.         }

    2795. 

  2795.     }

    2796. 

  2796. 

    2797. 

  2797.     function mysales() {

    2798. 

  2798.         $this->checkSession();

    2799. 

  2799.         $this->layout = 'creativemysales';

    2800. 

  2800. 

    2801. 

  2801.         $viewSearchType = '';

    2802. 

  2802. 

    2803. 

  2803.         if((isset($this->params['url']['hfsearch']) && $this->params['url']['hfsearch']!='') || isset($_REQUEST['hfsearch']) )

    2804. 

  2804.             $viewSearchType=$_REQUEST['hfsearch'];

    2805. 

  2805. 

    2806. 

  2806.         ############################### Page Title  & Head ############################

    2807. 

  2807.         $this->pageTitle = 'ScrapFOTO&trade; '.'My Sales';

    2808. 

  2808.         $this->set('pagehead','My Sales');

    2809. 

  2809. 

    2810. 

  2810.         /* Pagination and PHOTO listing */

    2811. 

  2811.         $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,

    2812. 

  2812.                         TC.total_amount, TC.invoice, TC.trandate, PM.commission,PM.saletax

    2813. 

  2813.                     ";                   

    2814. 

  2814.         $from=" FROM transaction_creatives TC

    2815. 

  2815.                     RIGHT JOIN payment_transactions PM ON ( TC.payment_ts_id = PM.id )

    2816. 

  2816.                     RIGHT JOIN creative_carts C ON ( C.transaction_creative_id = TC.id )

    2817. 

  2817.                     RIGHT JOIN creative_cart_details DT ON ( DT.creative_cart_id = C.id )

    2818. 

  2818.                     RIGHT JOIN creative_favorites X ON ( X.id = DT.creative_favorite_id )

    2819. 

  2819.                     RIGHT JOIN creative_favorites X1 ON ( (X.template_id >0 AND X1.id = X.template_id) OR (X.template_id=0 AND X1.id = X.id) )

    2820. 

  2820.                     ";

    2821. 

  2821. 

    2822. 

  2822.         $where=" WHERE PM.seller_id='".$_SESSION['UserId']."' AND  PM.pay_status = '1'";

    2823. 

  2823. 

    2824. 

  2824.         $searchpass='';

    2825. 

  2825.         if($viewSearchType=='within' && (isset($_REQUEST['within']) && $_REQUEST['within']!='' )  ) {

    2826. 

  2826.             $withinType=$_REQUEST['within'];

    2827. 

  2827.             $week=date("Y-m-d G:i:s",mktime(date("G"),date("i"),date("s"),date("m"),(date("d")-7),date("Y")));

    2828. 

  2828.             $month=date("Y-m-d G:i:s",mktime(date("G"),date("i"),date("s"),(date("m")-1),date("d"),date("Y")));

    2829. 

  2829.             $year=date("Y-m-d G:i:s",mktime(date("G"),date("i"),date("s"),date("m"),date("d"),(date("Y")-1)));

    2830. 

  2830.             $date=date("Y-m-d G:i:s");

    2831. 

  2831. 

    2832. 

  2832.             if($withinType=="past") {

    2833. 

  2833.                 $curDate=$date;

    2834. 

  2834.             }

    2835. 

  2835. 

    2836. 

  2836.             if($withinType=="week") {

    2837. 

  2837.                 $past=$week;

    2838. 

  2838.                 $curDate=$date;

    2839. 

  2839.             }

    2840. 

  2840. 

    2841. 

  2841.             if($withinType=="month") {

    2842. 

  2842.                 $past=$month;

    2843. 

  2843.                 $curDate=$date;

    2844. 

  2844.             }

    2845. 

  2845. 

    2846. 

  2846.             if($withinType=="year") {

    2847. 

  2847.                 $past=$year;

    2848. 

  2848.                 $curDate=$date;

    2849. 

  2849.             }

    2850. 

  2850. 

    2851. 

  2851.             if($withinType=="past")

    2852. 

  2852.                 $where.=" AND TC.trandate<'".$curDate."'";

    2853. 

  2853.             else

    2854. 

  2854.                 $where.=" AND TC.trandate BETWEEN '".$past."' AND '".$curDate."'";

    2855. 

  2855. 

    2856. 

  2856.             $searchpass = "&within=".$withinType ;

    2857. 

  2857.         }

    2858. 

  2858. 

    2859. 

  2859.         if($viewSearchType=='daterange') {

    2860. 

  2860.             if(isset($_REQUEST['sdatefrom']) && $_REQUEST['sdatefrom']!='mm/dd/YY') {

    2861. 

  2861.                 $eventFromDate=date("Y-m-d",strtotime($_REQUEST['sdatefrom']));

    2862. 

  2862.                 $urlfromdate  = $_REQUEST['sdatefrom'];

    2863. 

  2863.             }

    2864. 

  2864.             else {

    2865. 

  2865.                 $eventFromDate=date("Y-m-d");

    2866. 

  2866.                 $urlfromdate  = $_REQUEST['sdatefrom'];

    2867. 

  2867.             }

    2868. 

  2868. 

    2869. 

  2869.             if(isset($_REQUEST['sdateto']) && $_REQUEST['sdateto']!='mm/dd/YY') {

    2870. 

  2870.                 $eventToDate=date("Y-m-d",strtotime($_REQUEST['sdateto']));

    2871. 

  2871.                 $urltodate  = $_REQUEST['sdateto'].' 23:59:59';

    2872. 

  2872.             }

    2873. 

  2873.             else {

    2874. 

  2874.                 $eventToDate=date("Y-m-d");

    2875. 

  2875.                 $urltodate  = $_REQUEST['sdateto'].' 23:59:59';

    2876. 

  2876.             }

    2877. 

  2877. 

    2878. 

  2878.             $where.="  AND TC.trandate BETWEEN '".$eventFromDate."' AND '".$eventToDate."' ";

    2879. 

  2879.             $searchpass = "&sdatefrom=".$urlfromdate."&sdateto=".$urltodate ;

    2880. 

  2880.         }

    2881. 

  2881. 

    2882. 

  2882.         if($viewSearchType=='advance') {

    2883. 

  2883.             if(isset($_REQUEST['prodid']) && $_REQUEST['prodid']!='') {

    2884. 

  2884.                 $where.="  AND X.ssn_id like '%".$_REQUEST['prodid']."%' ";

    2885. 

  2885.                 $searchpass .= "&prodid=".$_REQUEST['prodid'] ;

    2886. 

  2886.             }

    2887. 

  2887.             if(isset($_REQUEST['invoice']) && $_REQUEST['invoice']!='') {

    2888. 

  2888.                 $where.="  AND TC.invoice like '%".$_REQUEST['invoice']."%' ";

    2889. 

  2889.                 $searchpass .= "&invoice=".$_REQUEST['invoice'] ;

    2890. 

  2890.             }

    2891. 

  2891. 

    2892. 

  2892.             if(isset($_REQUEST['adatefrom']) && $_REQUEST['adatefrom']!='mm/dd/YY') {

    2893. 

  2893.                 $eventFromDate=date("Y-m-d",strtotime($_REQUEST['adatefrom']));

    2894. 

  2894.                 $urlfromdate  = $_REQUEST['adatefrom'];

    2895. 

  2895.             }

    2896. 

  2896.             else {

    2897. 

  2897.                 $eventFromDate=date("Y-m-d");

    2898. 

  2898.                 $urlfromdate  = $_REQUEST['adatefrom'];

    2899. 

  2899.             }

    2900. 

  2900. 

    2901. 

  2901.             if(isset($_REQUEST['adateto']) && $_REQUEST['adateto']!='mm/dd/YY') {

    2902. 

  2902.                 $eventToDate=date("Y-m-d",strtotime($_REQUEST['adateto']));

    2903. 

  2903.                 $urltodate  = $_REQUEST['adateto'].' 23:59:59';

    2904. 

  2904.             }

    2905. 

  2905.             else {

    2906. 

  2906.                 $eventToDate=date("Y-m-d");

    2907. 

  2907.                 $urltodate  = $_REQUEST['adateto'].' 23:59:59';

    2908. 

  2908.             }

    2909. 

  2909. 

    2910. 

  2910.             if(isset($_REQUEST['adatefrom']) && isset($_REQUEST['adateto']) && $_REQUEST['adatefrom']!='mm/dd/YY' && $_REQUEST['adateto']!='mm/dd/YY') {

    2911. 

  2911.                 $where.="  AND TC.trandate BETWEEN '".$eventFromDate."' AND '".$eventToDate."' ";

    2912. 

  2912.                 $searchpass .= "&adatefrom=".$urlfromdate."&adateto=".$urltodate ;

    2913. 

  2913.             }

    2914. 

  2914.         }

    2915. 

  2915. 

    2916. 

  2916.         $this->set('searchpass',$where);

    2917. 

  2917. 

    2918. 

  2918.         //calculator total sell, total_commission

    2919. 

  2919.         $sqltotal= 'SELECT SUM(PM.total_amount) as total_sell, SUM(PM.commission) as total_commission

    2920. 

  2920.                     FROM payment_transactions as PM

    2921. 

  2921.                     WHERE seller_id="'.$_SESSION['UserId'].'" AND type_id<>"2" AND section_id="1" AND pay_status="1" ';

    2922. 

  2922.         $result = mysql_query($sqltotal);

    2923. 

  2923.         $row = mysql_fetch_array($result);

    2924. 

  2924.         $total_commission = $row['total_commission'];

    2925. 

  2925.         $total_sell = $row['total_sell'];       

    2926. 

  2926.         //calculator total_commission_received

    2927. 

  2927.         $sqltotal= 'SELECT SUM(total_amount) as total_commission_received

    2928. 

  2928.                     FROM payment_transactions

    2929. 

  2929.                     WHERE receiver_id="'.$_SESSION['UserId'].'" AND type_id="2" AND section_id="1" AND pay_status="1" ';//type_id="2": pay commission, section_id="1": for spsp

    2930. 

  2930.         $result = mysql_query($sqltotal);

    2931. 

  2931.         $row = mysql_fetch_array($result);

    2932. 

  2932.         $total_commission_received = $row['total_commission_received'];

    2933. 

  2933. 

    2934. 

  2934.         $this->set('total_sell',$total_sell);

    2935. 

  2935.         $this->set('total_commission',$total_commission);

    2936. 

  2936.         //$this->set('total_commission_received',$row['total_commission_received']);

    2937. 

  2937.        // $this->set('total_commission_unreceived',$total_commission-$total_commission_received);

    2938. 

  2938.         //

    2939. 

  2939.         $others=" order by TC.trandate desc ";

    2940. 

  2940. 

    2941. 

  2941.         $PassParameter ='';

    2942. 

  2942.         if($viewSearchType!='') {

    2943. 

  2943.             $PassParameter="hfsearch=".$viewSearchType.$searchpass;

    2944. 

  2944.         }

    2945. 

  2945. 

    2946. 

  2946. 

    2947. 

  2947.         $CountField="X.id";

    2948. 

  2948.         $this->set("controller","creativezones");

    2949. 

  2949.         $this->set("action","mysales");

    2950. 

  2950.         $this->set("parameter",$PassParameter);

    2951. 

  2951. 

    2952. 

  2952.         $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);

    2953. 

  2953.         if(isset($this->params['url']['Page']) || $viewSearchType!='') {

    2954. 

  2954.             $this->render("mysales_search","ajax");

    2955. 

  2955.         }

    2956. 

  2956. 

    2957. 

  2957.         $this->set('sql',$select.$from.$where.$others);

    2958. 

  2958. 

    2959. 

  2959.         $this->creativeType();

    2960. 

  2960.         $this->countFavCart();

    2961. 

  2961.         $this->getPublicScrap();

    2962. 

  2962.     }

    2963. 

  2963. 

    2964. 

  2964.     function mysales_transaction_fee($invoice,$is_cancel=null) {

    2965. 

  2965.         $this->set('id',$invoice);

    2966. 

  2966.         $this->set('is_cancel',$is_cancel);

    2967. 

  2967.         if($is_cancel==null) {

    2968. 

  2968.             $tc = $this->Transaction_creatives->findByInvoice($invoice);

    2969. 

  2969.             $this->set('totalAmount',$tc['Transaction_creatives']['transaction_fee']);

    2970. 

  2970. 

    2971. 

  2971.             //payment details

    2972. 

  2972.             $sellerId = 1;// that means payment will go to the admin paymenbt id

    2973. 

  2973.             $fetchAdminPaymentSetup=$this->getPaymentMethods($sellerId);

    2974. 

  2974.             $this->set("paymentMethods",$fetchAdminPaymentSetup);

    2975. 

  2975.             $this->set("sellerId",$sellerId);

    2976. 

  2976.         }

    2977. 

  2977.     }

    2978. 

  2978. 

    2979. 

  2979.     function mysales_product_detail($invoice,$ssn_id,$is_cancel=null) {

    2980. 

  2980.         $this->set('id',$invoice);

    2981. 

  2981.         $this->set('is_cancel',$is_cancel);

    2982. 

  2982.         $this->set('ssn_id',$ssn_id);

    2983. 

  2983.         if($is_cancel==null) {

    2984. 

  2984.             $fav = $this->Creative_favorites->findBySsn_id($ssn_id);

    2985. 

  2985.             $this->set('fav',$fav['Creative_favorites']);

    2986. 

  2986.         }

    2987. 

  2987.     }

    2988. 

  2988. 

    2989. 

  2989.     function pagination($select,$from,$where,$others,$CountField,$arg,$PassParameter) {

    2990. 

  2990.         if(isset($arg['Page']))

    2991. 

  2991.             $pageFlag=$arg['Page'];

    2992. 

  2992.         $this->set("PassParameter",$PassParameter);

    2993. 

  2993.         $SetUserNumberOfVpsPerPage=SHOW_REC; /* Defined in config->paths.php*/

    2994. 

  2994. 

    2995. 

  2995.         $this->set("BackgroundClass",'pagination');

    2996. 

  2996.         $this->set("SelectedPage",'pagination_over');

    2997. 

  2997.         $this->set("Linkpage",'pagination_over');

    2998. 

  2998.         $this->set("FirstImage",'fdd.gif');

    2999. 

  2999.         $this->set("PreviousImage",'previous.gif');

    3000. 

  3000.         $this->set("NextImage",'next.gif');

    3001. 

  3001.         $this->set("LastImage",'rewd.gif');

    3002. 

  3002. 

    3003. 

  3003.         $UserNumberOfVpsPerPage=SHOW_REC; /* Defined in config->paths.php*/

    3004. 

  3004.         if(!is_numeric($UserNumberOfVpsPerPage)|| (intval($UserNumberOfVpsPerPage)!=$UserNumberOfVpsPerPage)||($UserNumberOfVpsPerPage<=0))

    3005. 

  3005.             $UserNumberOfVpsPerPage = $SetUserNumberOfVpsPerPage;

    3006. 

  3006. 

    3007. 

  3007.         if(!isset($arg['Page'])) $arg['Page']=1;

    3008. 

  3008.         if(!isset($arg['Offset'])) $arg['Offset']=0;

    3009. 

  3009.         $Query_ForNumber_Records=mysql_query("$select $from $where $others") or die('Line no 120' . mysql_error());

    3010. 

  3010.         //$Result_Query_ForNumber_Records=mysql_fetch_object($Query_ForNumber_Records);

    3011. 

  3011. 

    3012. 

  3012.         //$NoOfVps=$Result_Query_ForNumber_Records->NoOfVps;

    3013. 

  3013.         $NoOfVps=mysql_num_rows($Query_ForNumber_Records);

    3014. 

  3014. 

    3015. 

  3015.         $NumberOfVpsPerPage=$UserNumberOfVpsPerPage;

    3016. 

  3016.         $NoOfPages=ceil($NoOfVps/$NumberOfVpsPerPage);	//3

    3017. 

  3017.         if($arg['Offset']==$NoOfVps) {

    3018. 

  3018.             if(isset($Offset)) {

    3019. 

  3019.                 $Offset=$Offset-$NumberOfVpsPerPage;

    3020. 

  3020.                 $Page--;

    3021. 

  3021.                 if($Offset<0) {

    3022. 

  3022.                     $Offset=0;

    3023. 

  3023.                     $Page=1;

    3024. 

  3024.                 }

    3025. 

  3025.             }else {

    3026. 

  3026.                 $Offset=0;

    3027. 

  3027.                 $Page=1;

    3028. 

  3028.             }

    3029. 

  3029.         }

    3030. 

  3030. 

    3031. 

  3031.         $this->set("Page",$arg['Page']);

    3032. 

  3032.         $this->set("Offset",$arg['Offset']);

    3033. 

  3033.         $this->set("NumberOfVpsPerPage",$NumberOfVpsPerPage);

    3034. 

  3034.         $this->set("NoOfPages",$NoOfPages);

    3035. 

  3035.         $this->set("UserNumberOfVpsPerPage",$UserNumberOfVpsPerPage);

    3036. 

  3036. 

    3037. 

  3037.         //print "$select $from $where $others";

    3038. 

  3038.         $this->set("qryOthr","$select $from $where $others");

    3039. 

  3039. 

    3040. 

  3040.         $SelectRecord = mysql_query("$select $from $where $others LIMIT ".$arg['Offset'].",$NumberOfVpsPerPage") or die('Line no '.__LINE__ . mysql_error());

    3041. 

  3041.         $this->set("query",$SelectRecord);

    3042. 

  3042. 

    3043. 

  3043.     }

    3044. 

  3044. 

    3045. 

  3045.     function sales() {

    3046. 

  3046.         $this->checkSession();

    3047. 

  3047.         $this->pageTitle = 'ScrapFOTO&trade; '.'Order History';

    3048. 

  3048.         $this->layout = 'creativemysales';

    3049. 

  3049.         $this->set('pagehead','Order History');

    3050. 

  3050. 

    3051. 

  3051.         $this->creativeType();

    3052. 

  3052.         $this->getRankScrap();

    3053. 

  3053.         $this->getFeaturedScrap();

    3054. 

  3054.         $this->getPublicScrap();

    3055. 

  3055.         $this->countFavCart();

    3056. 

  3056. 

    3057. 

  3057.         $viewSearchType = '';

    3058. 

  3058. 

    3059. 

  3059.         if((isset($this->params['url']['hfsearch']) && $this->params['url']['hfsearch']!='') || isset($_REQUEST['hfsearch']) )

    3060. 

  3060.             $viewSearchType=$_REQUEST['hfsearch'];

    3061. 

  3061. 

    3062. 

  3062.         $select="SELECT PM.*,TC. * ,TC.id tranId, C. * , GROUP_CONCAT( DISTINCT CONCAT_WS( '-', C.cart_name) ) AS scrapName";

    3063. 

  3063.         $from=" FROM transaction_creatives TC

    3064. 

  3064.                 RIGHT JOIN payment_transactions PM ON ( TC.payment_ts_id = PM.id )

    3065. 

  3065. 			LEFT JOIN creative_carts C ON ( C.transaction_creative_id = TC.id )";

    3066. 

  3066. 

    3067. 

  3067.         $where=" WHERE PM.user_id = '".$_SESSION['UserId']."' AND TC.pay_status='1' ";

    3068. 

  3068. 

    3069. 

  3069.         $searchpass='';

    3070. 

  3070.         if($viewSearchType=='within' && (isset($_REQUEST['within']) && $_REQUEST['within']!='' )  ) {

    3071. 

  3071.             $withinType=$_REQUEST['within'];

    3072. 

  3072.             $week=date("Y-m-d G:i:s",mktime(date("G"),date("i"),date("s"),date("m"),(date("d")-7),date("Y")));

    3073. 

  3073.             $month=date("Y-m-d G:i:s",mktime(date("G"),date("i"),date("s"),(date("m")-1),date("d"),date("Y")));

    3074. 

  3074.             $year=date("Y-m-d G:i:s",mktime(date("G"),date("i"),date("s"),date("m"),date("d"),(date("Y")-1)));

    3075. 

  3075.             $date=date("Y-m-d G:i:s");

    3076. 

  3076. 

    3077. 

  3077.             if($withinType=="past") {

    3078. 

  3078.                 $curDate=$date;

    3079. 

  3079.             }

    3080. 

  3080. 

    3081. 

  3081.             if($withinType=="week") {

    3082. 

  3082.                 $past=$week;

    3083. 

  3083.                 $curDate=$date;

    3084. 

  3084.             }

    3085. 

  3085. 

    3086. 

  3086.             if($withinType=="month") {

    3087. 

  3087.                 $past=$month;

    3088. 

  3088.                 $curDate=$date;

    3089. 

  3089.             }

    3090. 

  3090. 

    3091. 

  3091.             if($withinType=="year") {

    3092. 

  3092.                 $past=$year;

    3093. 

  3093.                 $curDate=$date;

    3094. 

  3094.             }

    3095. 

  3095. 

    3096. 

  3096.             if($withinType=="past")

    3097. 

  3097.                 $where.=" AND TC.trandate<'".$curDate."'";

    3098. 

  3098.             else

    3099. 

  3099.                 $where.=" AND TC.trandate BETWEEN '".$past."' AND '".$curDate."'";

    3100. 

  3100. 

    3101. 

  3101.             $searchpass = "&within=".$withinType ;

    3102. 

  3102.         }

    3103. 

  3103. 

    3104. 

  3104.         if($viewSearchType=='daterange') {

    3105. 

  3105.             if(isset($_REQUEST['sdatefrom']) && $_REQUEST['sdatefrom']!='mm/dd/YY') {

    3106. 

  3106.                 $eventFromDate=date("Y-m-d",strtotime($_REQUEST['sdatefrom']));

    3107. 

  3107.                 $urlfromdate  = $_REQUEST['sdatefrom'];

    3108. 

  3108.             }

    3109. 

  3109.             else {

    3110. 

  3110.                 $eventFromDate=date("Y-m-d");

    3111. 

  3111.                 $urlfromdate  = $_REQUEST['sdatefrom'];

    3112. 

  3112.             }

    3113. 

  3113. 

    3114. 

  3114.             if(isset($_REQUEST['sdateto']) && $_REQUEST['sdateto']!='mm/dd/YY') {

    3115. 

  3115.                 $eventToDate=date("Y-m-d",strtotime($_REQUEST['sdateto']));

    3116. 

  3116.                 $urltodate  = $_REQUEST['sdateto'].' 23:59:59';

    3117. 

  3117.             }

    3118. 

  3118.             else {

    3119. 

  3119.                 $eventToDate=date("Y-m-d");

    3120. 

  3120.                 $urltodate  = $_REQUEST['sdateto'].' 23:59:59';

    3121. 

  3121.             }

    3122. 

  3122. 

    3123. 

  3123.             $where.="  AND TC.trandate BETWEEN '".$eventFromDate."' AND '".$eventToDate."' ";

    3124. 

  3124.             $searchpass = "&sdatefrom=".$urlfromdate."&sdateto=".$urltodate ;

    3125. 

  3125.         }

    3126. 

  3126. 

    3127. 

  3127.         if($viewSearchType=='advance') {

    3128. 

  3128.             if(isset($_REQUEST['cartname']) && $_REQUEST['cartname']!='') {

    3129. 

  3129.                 $where.="  AND C.cart_name like '%".$_REQUEST['cartname']."%' ";

    3130. 

  3130.                 $searchpass .= "&cartname=".$_REQUEST['cartname'] ;

    3131. 

  3131.             }

    3132. 

  3132.             if(isset($_REQUEST['invoice']) && $_REQUEST['invoice']!='') {

    3133. 

  3133.                 $where.="  AND TC.invoice like '%".$_REQUEST['invoice']."%' ";

    3134. 

  3134.                 $searchpass .= "&invoice=".$_REQUEST['invoice'] ;

    3135. 

  3135.             }

    3136. 

  3136. 

    3137. 

  3137.             if(isset($_REQUEST['adatefrom']) && $_REQUEST['adatefrom']!='mm/dd/YY') {

    3138. 

  3138.                 $eventFromDate=date("Y-m-d",strtotime($_REQUEST['adatefrom']));

    3139. 

  3139.                 $urlfromdate  = $_REQUEST['adatefrom'];

    3140. 

  3140.             }

    3141. 

  3141.             else {

    3142. 

  3142.                 $eventFromDate=date("Y-m-d");

    3143. 

  3143.                 $urlfromdate  = $_REQUEST['adatefrom'];

    3144. 

  3144.             }

    3145. 

  3145. 

    3146. 

  3146.             if(isset($_REQUEST['adateto']) && $_REQUEST['adateto']!='mm/dd/YY') {

    3147. 

  3147.                 $eventToDate=date("Y-m-d",strtotime($_REQUEST['adateto']));

    3148. 

  3148.                 $urltodate  = $_REQUEST['adateto'].' 23:59:59';

    3149. 

  3149.             }

    3150. 

  3150.             else {

    3151. 

  3151.                 $eventToDate=date("Y-m-d");

    3152. 

  3152.                 $urltodate  = $_REQUEST['adateto'].' 23:59:59';

    3153. 

  3153.             }

    3154. 

  3154. 

    3155. 

  3155.             if(isset($_REQUEST['adatefrom']) && isset($_REQUEST['adateto']) && $_REQUEST['adatefrom']!='mm/dd/YY' && $_REQUEST['adateto']!='mm/dd/YY') {

    3156. 

  3156.                 $where.="  AND TC.trandate BETWEEN '".$eventFromDate."' AND '".$eventToDate."' ";

    3157. 

  3157.                 $searchpass .= "&adatefrom=".$urlfromdate."&adateto=".$urltodate ;

    3158. 

  3158.             }

    3159. 

  3159.         }

    3160. 

  3160. 

    3161. 

  3161.         $this->set('searchpass',$where);

    3162. 

  3162.         //calculator total sell

    3163. 

  3163.         $sqltotal= 'SELECT SUM(TC.total_amount) as total_sell '.$from.$where.'';

    3164. 

  3164.         $result = mysql_query($sqltotal);

    3165. 

  3165.         $row = mysql_fetch_array($result);

    3166. 

  3166.         $this->set('total_sell',$row['total_sell']);

    3167. 

  3167. 

    3168. 

  3168.         $others=" GROUP BY TC.id ORDER BY TC.id DESC";

    3169. 

  3169. 

    3170. 

  3170.         $PassParameter ='';

    3171. 

  3171.         if($viewSearchType!='') {

    3172. 

  3172.             $PassParameter="hfsearch=".$viewSearchType.$searchpass;

    3173. 

  3173.         }

    3174. 

  3174. 

    3175. 

  3175.         $CountField="tranId";

    3176. 

  3176.         $this->set("controller","creativezones");

    3177. 

  3177.         $this->set("action","sales");

    3178. 

  3178.         $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);

    3179. 

  3179. 

    3180. 

  3180.         if(isset($this->params['url']['Page']) || $viewSearchType!='') {

    3181. 

  3181.             $this->render("sales2","ajax");

    3182. 

  3182.         }

    3183. 

  3183.     }

    3184. 

  3184. 

    3185. 

  3185.     function getTransactionDetails($transactionId=null) /// Invoice detail

    3186. 

  3186.     {        

    3187. 

  3187.         $ticketqry =  "

    3188. 

  3188. 					SELECT tranTic.id, tranTic.invoice , tranTic.total_amount , DATE(tranTic.cudate) as saledate , CONCAT(BUYusrdetail.first_name ,' ',BUYusrdetail.last_name) as Buyername ,

    3189. 

  3189. 					BUYusrdetail.address as Buyeraddress ,IFNULL(BUYCITYName.city_name,'--') as Buyercity , IFNULL(BUYstate.Name,'--') as Buyerstatename , BUYcountry.country_name as BUYercountryname , BUYusrdetail.zip as Buyerzip ,

    3190. 

  3190. 					

    3191. 

  3191. 					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,

    3192. 

  3192. 					POSTBYusrdetail.address as Postaddress ,IFNULL(POSTCITYMaster.city_name,'--') as Postcity , IFNULL(POSTstate.Name,'--') as Poststatename , POSTcountry.country_name as Postcountryname , POSTBYusrdetail.zip as Postzip ,

    3193. 

  3193. 					

    3194. 

  3194. 					Tic.plan_name as Eventname , tranTic.total_amount as Totalamount , MEMPLAN.picture as logoimage , SUM(MEMPLANCART.plan_price*MEMPLANCART.quantity) as TicketTotal

    3195. 

  3195. 					  

    3196. 

  3196. 					

    3197. 

  3197. 					FROM transaction_memberships tranTic

    3198. 

  3198. 					

    3199. 

  3199. 					LEFT JOIN membership_plantype_cart MEMPLANCART ON MEMPLANCART.transaction_membership_id = tranTic.id

    3200. 

  3200. 					

    3201. 

  3201. 					LEFT JOIN membership_plantype MEMPLAN ON (MEMPLANCART.plantype_id = MEMPLAN.plantype_id AND MEMPLANCART.membership_id = MEMPLAN.membership_id)

    3202. 

  3202. 					

    3203. 

  3203. 					LEFT JOIN user_details BUYusrdetail ON MEMPLANCART.user_id = BUYusrdetail.user_id

    3204. 

  3204. 					

    3205. 

  3205. 					LEFT JOIN state BUYstate ON BUYstate.id = BUYusrdetail.state 

    3206. 

  3206. 					LEFT JOIN city_master  BUYCITYName ON BUYCITYName.city_id = BUYusrdetail.city

    3207. 

  3207. 					LEFT JOIN countries BUYcountry ON BUYcountry.id=BUYusrdetail.c_id 

    3208. 

  3208. 				

    3209. 

  3209. 					LEFT JOIN memberships Tic On MEMPLANCART.membership_id=Tic.id 

    3210. 

  3210. 					

    3211. 

  3211. 					LEFT JOIN user_details POSTBYusrdetail ON tranTic.org_id = POSTBYusrdetail.user_id

    3212. 

  3212. 					LEFT JOIN state POSTstate ON POSTstate.id = POSTBYusrdetail.state 

    3213. 

  3213. 					LEFT JOIN city_master POSTCITYMaster ON POSTCITYMaster.city_id = POSTBYusrdetail.city

    3214. 

  3214. 					LEFT JOIN countries POSTcountry ON POSTcountry.id=POSTBYusrdetail.c_id 

    3215. 

  3215. 					

    3216. 

  3216. 					WHERE tranTic.id='".$tranId."' and MEMPLANCART.pay_status='1' AND MEMPLANCART.user_id='".$_SESSION['UserId']."'

    3217. 

  3217. 					AND MEMPLANCART.ssn_id='".session_id()."'

    3218. 

  3218. 					

    3219. 

  3219. 					GROUP BY MEMPLANCART.transaction_membership_id

    3220. 

  3220. 					ORDER BY MEMPLANCART.id ASC

    3221. 

  3221. 					";

    3222. 

  3222. 

    3223. 

  3223.         $qry=mysql_query($ticketqry) or die("Error on line :".__LINE__.mysql_error());

    3224. 

  3224.         $this->set("q1",$qry);

    3225. 

  3225.     }

    3226. 

  3226. 

    3227. 

  3227.     function creative_invoice_detail() {

    3228. 

  3228.         $this->layout = "blank";

    3229. 

  3229.         $this->set("tranId",base64_decode($this->params['url']['inv']));

    3230. 

  3230.     }

    3231. 

  3231. 

    3232. 

  3232.     function printscrap() {

    3233. 

  3233.         $this->layout = "blank";

    3234. 

  3234.     }

    3235. 

  3235. 

    3236. 

  3236.     function sendinvoice() {

    3237. 

  3237.         $this->set("urlVars",$this->params['url']);

    3238. 

  3238. 

    3239. 

  3239.         $userDetails=$this->getUserDetails($_SESSION['UserId']);

    3240. 

  3240.         //____________________________________________________MAIL MANAGEMENT________________________________________________

    3241. 

  3241.         //this mailing code is here so that it fires just once.

    3242. 

  3242. 

    3243. 

  3243.         //mail sent to the user personal account

    3244. 

  3244.         $this->Sendmail->Mail();

    3245. 

  3245.         $this->Sendmail->From(FROMMAIL);

    3246. 

  3246. 

    3247. 

  3247.         if(isset($userDetails['email'])) {

    3248. 

  3248.             $this->Sendmail->To($userDetails['email']);

    3249. 

  3249. 

    3250. 

  3250.             //$this->Sendmail->Cc("sujoy@navsoft.in");

    3251. 

  3251.             //$this->Sendmail->Cc("amarjit@navsoft.in");

    3252. 

  3252.             //$this->Sendmail->Bcc( "someoneelse@somewhere.fr");

    3253. 

  3253. 

    3254. 

  3254.             $subject="XOimages - Scrapfoto invoice request";

    3255. 

  3255.             $this->Sendmail->Subject($subject);

    3256. 

  3256. 

    3257. 

  3257.             $this->set("tranId",base64_decode($this->params['url']['inv']));

    3258. 

  3258.             $this->Sendmail->layout='email';

    3259. 

  3259.             $this->Sendmail->view='mail_invoicerequest';

    3260. 

  3260.             $this->Sendmail->startup($this);

    3261. 

  3261.             $messageBody=$this->Sendmail->bodyText();

    3262. 

  3262. 

    3263. 

  3263.             $this->Sendmail->Body($messageBody);        // set the body

    3264. 

  3264.             $this->Sendmail->Priority(1) ;        // set the priority to Low

    3265. 

  3265.             $this->Sendmail->Send();        // send the mail

    3266. 

  3266. 

    3267. 

  3267.             //mail sent to the user mail account in the system

    3268. 

  3268. 

    3269. 

  3269.             $sender=1;

    3270. 

  3270.             $receiver=$_SESSION['UserId'];

    3271. 

  3271.             $this->senderMail($sender,$receiver,$subject,$messageBody);

    3272. 

  3272.             $this->receiverMail($receiver,$sender,$subject,$messageBody);

    3273. 

  3273.         }

    3274. 

  3274.         $this->render("invoicesent","ajax");

    3275. 

  3275.     }

    3276. 

  3276. 

    3277. 

  3277.     function createTransactionNumber($pre) {

    3278. 

  3278.         global $db;

    3279. 

  3279.         $id = $pre;

    3280. 

  3280.         $id .= $this->genRandomStringNumbers(10);

    3281. 

  3281. 

    3282. 

  3282.         // check id if exist in db, if not, add

    3283. 

  3283.         if($pre=='SPTT') {

    3284. 

  3284.             $query ="SELECT id FROM creative_tickets WHERE ticket_number ='".$id."'  LIMIT 1";

    3285. 

  3285.         }else {

    3286. 

  3286.             $query ="SELECT id FROM xouser_transactions WHERE invoice ='".$id."'  LIMIT 1";

    3287. 

  3287.         }

    3288. 

  3288. 

    3289. 

  3289.         $result = mysql_query($query);

    3290. 

  3290. 

    3291. 

  3291.         if(mysql_numrows($result) < 1) {

    3292. 

  3292.             return $id;

    3293. 

  3293.         } else {

    3294. 

  3294.             return $this->createTransactionNumber($pre);

    3295. 

  3295.         }

    3296. 

  3296.         return $this->createTransactionNumber($pre);

    3297. 

  3297.     }

    3298. 

  3298.     function genRandomStringNumbers($length) {

    3299. 

  3299.         $characters = 'ABCEFGHIJKLMNOPQRTUVWXYZ1234567890';

    3300. 

  3300.         $string = '';

    3301. 

  3301.         for ($c = 0; $c < $length; $c++) {

    3302. 

  3302.             $string .= substr($characters, mt_rand(0, strlen($characters)-1), 1);

    3303. 

  3303.         }

    3304. 

  3304.         return $string;

    3305. 

  3305.     }

    3306. 

  3306.     function run_cron_job() {

    3307. 

  3307.         if (!defined('CRON_DISPATCHER')) {

    3308. 

  3308.             exit();

    3309. 

  3309.         }else {

    3310. 

  3310.             //check Feature

    3311. 

  3311.             $query = "UPDATE creative_favorites SET is_featured='0' WHERE is_featured='1' AND featured_time<'".date('Y-m-d G:i:s')."'";

    3312. 

  3312.             mysql_query($query);

    3313. 

  3313. 

    3314. 

  3314.             //check transaction fee

    3315. 

  3315.             /*

    3316. 

  3316.             $day1 = $this->getConfigAmount('creative settlement time1');

    3317. 

  3317.             $day1 = $day1['config_value'];

    3318. 

  3318. 

    3319. 

  3319.             $day2 = $this->getConfigAmount('creative settlement time2');

    3320. 

  3320.             $day2 = $day2['config_value'];

    3321. 

  3321. 

    3322. 

  3322.             if($day1>$day2) {

    3323. 

  3323.                 $tmp = $day1;

    3324. 

  3324.                 $day1 = $day2;

    3325. 

  3325.                 $day2 = $tmp;

    3326. 

  3326.             }

    3327. 

  3327. 

    3328. 

  3328.             $cur_day = date('Y-m-d G:i:s');

    3329. 

  3329.             $today = getdate();

    3330. 

  3330.             $day_c = $today['mday'];

    3331. 

  3331. 

    3332. 

  3332.             $emailtime = $this->getConfigAmount('creative reactivation time');

    3333. 

  3333.             $emailtime = $emailtime['config_value'];

    3334. 

  3334.             $numday_month = date('t')+0;

    3335. 

  3335. 

    3336. 

  3336.             $is_send_mail = ($today['mday']%((int)$numday_month/$emailtime)) == 0 ;

    3337. 

  3337. 

    3338. 

  3338.             $this->set('is_send_mail',$is_send_mail);

    3339. 

  3339. 

    3340. 

  3340.             $time1 = $today['year'].'-'.$today['mon'].'-'.$day1.' '.$today['hours'].':'.$today['minutes'].':'.$today['seconds'];

    3341. 

  3341.             $time2 = $today['year'].'-'.$today['mon'].'-'.$day2.' '.$today['hours'].':'.$today['minutes'].':'.$today['seconds'];

    3342. 

  3342.             $compare_date = ($day_c<$day2) ? $time1 : $time2;

    3343. 

  3343. 

    3344. 

  3344.             $sql = "SELECT TC.*,FX.ssn_id, FX.is_blocked

    3345. 

  3345.                     FROM transaction_creatives TC

    3346. 

  3346.                     LEFT JOIN creative_carts C ON (C.transaction_creative_id = TC.id)

    3347. 

  3347.                     LEFT JOIN creative_cart_details CDT ON (CDT.creative_cart_id = C.id)

    3348. 

  3348.                     LEFT JOIN creative_favorites F ON (F.id = CDT.creative_favorite_id)

    3349. 

  3349.                     RIGHT JOIN creative_favorites FX ON (F.template_id>0 AND FX.id = F.template_id)

    3350. 

  3350. 

    3351. 

  3351.                     WHERE TC.transaction_fee>0 AND TC.is_pay_transaction_fee='0'";

    3352. 

  3352.             $result = mysql_query($sql);

    3353. 

  3353. 

    3354. 

  3354.             $arr = array();

    3355. 

  3355. 

    3356. 

  3356.             while($row=mysql_fetch_assoc($result)) {

    3357. 

  3357.                 $trandate = $row['trandate'];

    3358. 

  3358.                 $tmpdate = new DateTime($trandate);

    3359. 

  3359.                 if($tmpdate->format('d')>$day2) {

    3360. 

  3360.                     $tmpdate->modify('+1 month');

    3361. 

  3361.                     $pay_date = $tmpdate->format('Y').'-'.$tmpdate->format('m').'-'.$day1.' '.$tmpdate->format('G').':'.$tmpdate->format('i').':'.$tmpdate->format('s');

    3362. 

  3362.                 }else {

    3363. 

  3363.                     $pay_date = $tmpdate->format('Y').'-'.$tmpdate->format('m').'-'.$day2.' '.$tmpdate->format('G').':'.$tmpdate->format('i').':'.$tmpdate->format('s');

    3364. 

  3364.                 }

    3365. 

  3365. 

    3366. 

  3366.                 $due_day = (strtotime($trandate)<strtotime($compare_date)) ? (int)((strtotime($cur_day)-strtotime($pay_date))/(24*60*60)) : 0;

    3367. 

  3367.                 if($due_day>0) {

    3368. 

  3368.                     if(isset($arr[$row['seller_id']]))

    3369. 

  3369.                         $arr[$row['seller_id']]['due_amount'] += $row['transaction_fee'];

    3370. 

  3370.                     else {

    3371. 

  3371.                         $arr[$row['seller_id']]['due_amount'] = $row['transaction_fee'];

    3372. 

  3372.                         $arr[$row['seller_id']]['due_day'] = $due_day;

    3373. 

  3373.                         $arr[$row['seller_id']]['ids'] = array();

    3374. 

  3374.                     }

    3375. 

  3375.                     $arr[$row['seller_id']]['ids'][$row['ssn_id']]=$row['ssn_id'];

    3376. 

  3376. 

    3377. 

  3377.                     if($due_day>$arr[$row['seller_id']]['due_day'])

    3378. 

  3378.                         $arr[$row['seller_id']]['due_day'] = $due_day;

    3379. 

  3379.                 }

    3380. 

  3380.             }

    3381. 

  3381. 

    3382. 

  3382.             $blockId = array();

    3383. 

  3383.             foreach($arr as $key=>$value) {

    3384. 

  3384.                 $blockId = array_merge($blockId, $value['ids']);

    3385. 

  3385.                 //check sendmail

    3386. 

  3386.                 if($is_send_mail)

    3387. 

  3387.                     $this->mail_reactivation($key,$value['due_amount'],$value['due_day']);

    3388. 

  3388. 

    3389. 

  3389.                 $sql = "UPDATE user_payment_setup SET is_blocked='1' WHERE user_id='$key' ";

    3390. 

  3390.                 mysql_query($sql);

    3391. 

  3391.             }

    3392. 

  3392. 

    3393. 

  3393.             if(count($blockId)>0) {

    3394. 

  3394.                 $sql = "UPDATE creative_favorites SET is_blocked='1' WHERE ssn_id IN ('".join("', '", $blockId)."') AND is_republished='1' ";

    3395. 

  3395.                 mysql_query($sql);

    3396. 

  3396.             }

    3397. 

  3397.              *

    3398. 

  3398.              */

    3399. 

  3399.         }

    3400. 

  3400.     }

    3401. 

  3401. 

    3402. 

  3402.     function mail_reactivation($user_id,$due_amount,$due_day) {

    3403. 

  3403.         $userDetails=$this->getUserDetails($user_id);

    3404. 

  3404.         //____________________________________________________MAIL MANAGEMENT________________________________________________

    3405. 

  3405.         //this mailing code is here so that it fires just once.

    3406. 

  3406. 

    3407. 

  3407.         //mail sent to the user personal account

    3408. 

  3408.         if(isset($userDetails['email'])) {

    3409. 

  3409.             $this->Sendmail->Mail();

    3410. 

  3410.             $this->Sendmail->From(FROMMAIL);

    3411. 

  3411.             $this->Sendmail->To($userDetails['email']);

    3412. 

  3412. 

    3413. 

  3413.             $subject="XOimages Reactivation Notification";

    3414. 

  3414.             $this->Sendmail->Subject($subject);

    3415. 

  3415. 

    3416. 

  3416.             $this->set('user_id',$user_id);

    3417. 

  3417.             $this->set('due_amount',$due_amount);

    3418. 

  3418.             $this->set('due_day',$due_day);

    3419. 

  3419. 

    3420. 

  3420.             $this->Sendmail->layout='email';

    3421. 

  3421.             $this->Sendmail->view='mail_reactivation';

    3422. 

  3422.             $this->Sendmail->startup($this);

    3423. 

  3423.             $messageBody=$this->Sendmail->bodyText();

    3424. 

  3424. 

    3425. 

  3425.             $this->Sendmail->Body($messageBody);        // set the body

    3426. 

  3426.             $this->Sendmail->Priority(1) ;        // set the priority to Low

    3427. 

  3427.             $this->Sendmail->Send();        // send the mail

    3428. 

  3428. 

    3429. 

  3429.             //mail sent to the user mail account in the system

    3430. 

  3430.             $sender=1;

    3431. 

  3431.             $receiver=$user_id;

    3432. 

  3432.             $this->senderMail($sender,$receiver,$subject,$messageBody);

    3433. 

  3433.             $this->receiverMail($receiver,$sender,$subject,$messageBody);

    3434. 

  3434. 

    3435. 

  3435.             $this->Sendmail->__destruct();

    3436. 

  3436.         }

    3437. 

  3437.     }

    3438. 

  3438. 

    3439. 

  3439. }

    3440. 

  3440. ?>
    3441.