PageRenderTime 70ms CodeModel.GetById 21ms RepoModel.GetById 0ms app.codeStats 1ms

/app/controllers/tickets_controller.php

https://bitbucket.org/fxrialab/tickets
PHP | 2446 lines | 1956 code | 386 blank | 104 comment | 390 complexity | f9da7d3a0251fbe1f880afa9337551a7 MD5 | raw file
Possible License(s): LGPL-2.1, AGPL-1.0, GPL-2.0, MIT 
    

  1. <?

    2. 

  2. class TicketsController extends AppController {

    3. 

  3.     var $name='Tickets';

    4. 

  4.     var $helpers = array('Html','javascript','error','Ajax','common','Phoogle', 'Form','Friendsurl','Newexcel');

    5. 

  5.     var $components = array('Thumbnail','Thumbnailc','Upload','Sendmail','Mysqllocker','Download');

    6. 

  6.     var $uses=array('Ticket','User','Ticket_carts','PaymentTransaction');

    7. 

  7. 

    8. 

  8.     function index($uid=null,$keyuserId=null) {

    9. 

  9.         $this->pageTitle = 'Tickets Home';

    10. 

  10.         $this->layout = 'tickethome';

    11. 

  11.         if(!isset($_SESSION['UserId']) && $keyuserId && $uid ) {

    12. 

  12.             $uid = base64_decode($uid);

    13. 

  13.             if(md5('checklogin'.$uid)==$keyuserId) {

    14. 

  14.                 $this->login_again($uid);

    15. 

  15.             }

    16. 

  16.         }

    17. 

  17. 

    18. 

  18.         $this->homepageslideInfo('Tickets');

    19. 

  19.         $this->ticketCategory();

    20. 

  20. 

    21. 

  21.         ################################## Event Location ##########################

    22. 

  22.         /* Turn oN the session for the project state and country*/

    23. 

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

    24. 

  24. 

    25. 

  25.             $sql = "SELECT * FROM ticket_carts WHERE user_id='".$_SESSION['UserId']."' AND pay_status='0'";

    26. 

  26. 

    27. 

  27.             $result = mysql_query($sql);

    28. 

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

    29. 

  29.                 //delete cart

    30. 

  30.                 mysql_query("DELETE FROM ticket_cart_details WHERE cart_id='".$row['id']."'") or die(mysql_error());

    31. 

  31.                 mysql_query("DELETE FROM ticket_seat_booked WHERE cart_id='".$row['id']."'") or die(mysql_error());

    32. 

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

    33. 

  33.             }

    34. 

  34. 

    35. 

  35.             $userCountry = "select  user_details.c_id  , countries.country_name ,state.Name, user_details.state, user_details.city , CONCAT_WS(',',city_master.city_name,state.Name,countries.country_name) as CurrentLocation  from user_details LEFT JOIN  countries On  countries.id = user_details.c_id  LEFT JOIN state ON state.id = user_details.state LEFT JOIN city_master ON  user_details.city = city_master.city_id where user_details.user_id= ".$_SESSION['UserId']." ";

    36. 

  36.             $userCountry_res = mysql_query($userCountry);

    37. 

  37.             if(($userCountry_arr = mysql_fetch_array($userCountry_res))) {

    38. 

  38.                 if(!isset($_SESSION['PrjUserCityName'])) {

    39. 

  39.                     $this->Session->write('PrjUserCityName', $userCountry_arr['city']);

    40. 

  40.                     $this->Session->write('PrjUserCityId', $userCountry_arr['city']);

    41. 

  41.                 }

    42. 

  42. 

    43. 

  43.                 if(!isset($_SESSION['PrjUserStateId'])) {

    44. 

  44.                     $this->Session->write('PrjUserStateId', $userCountry_arr['state']);

    45. 

  45.                     $this->Session->write('PrjUserStateName', $userCountry_arr['Name']);

    46. 

  46.                 }

    47. 

  47. 

    48. 

  48.                 if(!isset($_SESSION['PrjUserCountryId'])) {

    49. 

  49.                     $this->Session->write('PrjUserCountryId', $userCountry_arr['c_id']);

    50. 

  50.                     $this->Session->write('PrjUserCountryName', $userCountry_arr['country_name']);

    51. 

  51.                 }

    52. 

  52. 

    53. 

  53.                 if(!isset($_SESSION['PrjUserLocation'])) {

    54. 

  54.                     $locstr=$userCountry_arr['CurrentLocation'];

    55. 

  55.                     //							$locstr='';

    56. 

  56.                     //							if($_SESSION['PrjUserStateName']!="")

    57. 

  57.                     //								$locstr.=$_SESSION['PrjUserStateName'].',' ;

    58. 

  58.                     //

    59. 

  59.                     //							if($_SESSION['PrjUserCountryName']!="")

    60. 

  60.                     //								$locstr.= $_SESSION['PrjUserCountryName'].',' ;

    61. 

  61.                     $this->Session->write('PrjUserLocation',substr($locstr,0,(strlen($locstr)-1)));

    62. 

  62.                 }

    63. 

  63.             }

    64. 

  64.         }

    65. 

  65.         else {

    66. 

  66.             $check = false;

    67. 

  67.             if(!isset($_SESSION['PrjUserCountryId'])) {

    68. 

  68.                 $this->Session->write('PrjUserCityId', 14967);

    69. 

  69.                 $this->Session->write('PrjUserStateId', 168);

    70. 

  70.                 $this->Session->write('PrjUserCountryId', 254);

    71. 

  71.             }

    72. 

  72. 

    73. 

  73.             if(isset($_SESSION['PrjUserCityId']) && isset($_SESSION['PrjUserStateId']) && isset($_SESSION['PrjUserCountryId'])) {

    74. 

  74.                 $sql = "SELECT CONCAT_WS(', ',city_master.city_name,state.Name,countries.country_name) as CurrentLocation, city_master.city_name as CityName, state.Name as StateName,countries.country_name

    75. 

  75.                         FROM countries

    76. 

  76.                         LEFT JOIN state ON (state.id='".$_SESSION['PrjUserStateId']."' AND state.c_id=countries.id)

    77. 

  77.                         LEFT JOIN city_master ON (city_master.city_id='".$_SESSION['PrjUserCityId']."' AND city_master.CountryID=countries.id AND city_master.state_id=state.id)

    78. 

  78.                         WHERE countries.id='".$_SESSION['PrjUserCountryId']."' ";

    79. 

  79.                 $userCountry_res = mysql_query($sql);

    80. 

  80.                 if(($userCountry_arr = mysql_fetch_array($userCountry_res))) {

    81. 

  81.                     $this->Session->write('PrjUserCityName', $userCountry_arr['CityName']);

    82. 

  82.                     $this->Session->write('PrjUserStateName', $userCountry_arr['StateName']);

    83. 

  83.                     $this->Session->write('PrjUserCountryName', $userCountry_arr['country_name']);

    84. 

  84.                     $this->Session->write('PrjUserLocation',$userCountry_arr['CurrentLocation']);

    85. 

  85.                     $check = true;

    86. 

  86.                 }

    87. 

  87.             }

    88. 

  88. 

    89. 

  89.             if(!$check) {

    90. 

  90.                 $userCountry = "select  countries.id  , countries.country_name from countries Where countries.id = '6'";

    91. 

  91.                 $userCountry_res = mysql_query($userCountry);

    92. 

  92.                 if(($userCountry_arr = mysql_fetch_array($userCountry_res))) {

    93. 

  93.                     if(!isset($_SESSION['PrjUserCityName'])) {

    94. 

  94.                         $this->Session->write('PrjUserCityName', '');

    95. 

  95.                         $this->Session->write('PrjUserCityId', 0);

    96. 

  96.                     }

    97. 

  97. 

    98. 

  98.                     if(!isset($_SESSION['PrjUserStateId'])) {

    99. 

  99.                         $this->Session->write('PrjUserStateId', 0);

    100. 

  100.                         $this->Session->write('PrjUserStateName', '');

    101. 

  101.                     }

    102. 

  102.                     if(!isset($_SESSION['PrjUserCountryId'])) {

    103. 

  103.                         $this->Session->write('PrjUserCountryId', $userCountry_arr['id']);

    104. 

  104.                         $this->Session->write('PrjUserCountryName', $userCountry_arr['country_name']);

    105. 

  105.                     }

    106. 

  106. 

    107. 

  107. 

    108. 

  108.                     $locstr='';

    109. 

  109. 

    110. 

  110.                     if(isset($_SESSION['PrjUserCityName']) && $_SESSION['PrjUserCityName']!="")

    111. 

  111.                         $locstr.=$_SESSION['PrjUserCityName'] ;

    112. 

  112. 

    113. 

  113.                     if(isset($_SESSION['PrjUserStateName']) && $_SESSION['PrjUserStateName']!="")

    114. 

  114.                         $locstr.=', '.$_SESSION['PrjUserStateName'] ;

    115. 

  115. 

    116. 

  116.                     if(isset($_SESSION['PrjUserCountryName']) && $_SESSION['PrjUserCountryName']!="")

    117. 

  117.                         $locstr.= $_SESSION['PrjUserCountryName'] ;

    118. 

  118. 

    119. 

  119. 

    120. 

  120.                     $this->Session->write('PrjUserLocation',$locstr);

    121. 

  121.                 }

    122. 

  122.             }

    123. 

  123. 

    124. 

  124. 

    125. 

  125.         }

    126. 

  126.         ###########################################################################

    127. 

  127.     }

    128. 

  128. 

    129. 

  129.     function changelocation() {

    130. 

  130.         /* Turn oN the session for the project state and country*/

    131. 

  131.         $userCountry = "select  IFNULL(countries.id,0) as countryId  ,  IFNULL(countries.country_name,'') as countryName  ,IFNULL(state.Name,'')as StateName, IFNULL(state.id,0) as StateId, IFNULL(city_master.city_id,0) as CityId , IFNULL(city_master.city_name,'')as CityName from countries LEFT JOIN state ON  state.c_id = countries.id  and state.id = ".$_REQUEST['province']." LEFT JOIN city_master ON  state_id = state.id and city_id = ".$_REQUEST['city']." where countries.id = ".$_REQUEST['country']."";

    132. 

  132.         $userCountry_res = mysql_query($userCountry)or die(mysql_error());

    133. 

  133.         if(($userCountry_arr = mysql_fetch_array($userCountry_res))) {

    134. 

  134.             $this->Session->write('PrjUserCityName', $userCountry_arr['CityName']);

    135. 

  135.             $this->Session->write('PrjUserCityId', $userCountry_arr['CityId']);

    136. 

  136. 

    137. 

  137.             $this->Session->write('PrjUserStateId', $userCountry_arr['StateId']);

    138. 

  138.             $this->Session->write('PrjUserStateName', $userCountry_arr['StateName']);

    139. 

  139. 

    140. 

  140.             $this->Session->write('PrjUserCountryId', $userCountry_arr['countryId']);

    141. 

  141.             $this->Session->write('PrjUserCountryName', $userCountry_arr['countryName']);

    142. 

  142. 

    143. 

  143.             $strloc = '';

    144. 

  144.             if($userCountry_arr['CityName']!='') {

    145. 

  145.                 $strloc .= $userCountry_arr['CityName'].', ' ;

    146. 

  146.             }

    147. 

  147.             if($userCountry_arr['StateName']!='') {

    148. 

  148.                 $strloc .= $userCountry_arr['StateName'].', ' ;

    149. 

  149.             }

    150. 

  150.             if($userCountry_arr['countryName']!='') {

    151. 

  151.                 $strloc .= $userCountry_arr['countryName'] ;

    152. 

  152.             }

    153. 

  153. 

    154. 

  154.             $this->Session->write('PrjUserLocation',$strloc);

    155. 

  155.         }

    156. 

  156.         $this->redirect('tickets');

    157. 

  157.     }

    158. 

  158.     

    159. 

  159.     function ticketCategory() {

    160. 

  160.         $evtcat = array();

    161. 

  161.         $evtcat['0']="Select Category";

    162. 

  162.         $select_ticket_cat = mysql_query("Select * from ticket_event_category");

    163. 

  163.         while($select_ticket_cat_arr = mysql_fetch_array($select_ticket_cat)) {

    164. 

  164.             $evtcat[$select_ticket_cat_arr['id']] = $select_ticket_cat_arr['cat_name'];

    165. 

  165.         }

    166. 

  166.         $this->set('ticketcat',$evtcat);

    167. 

  167.     }

    168. 

  168. 

    169. 

  169.     function recentticket() {

    170. 

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

    171. 

  171.         $this->ticketCategory();

    172. 

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

    173. 

  173. 

    174. 

  174.         if(isset($_SESSION['PrjUserCityId']))

    175. 

  175.             $city=$_SESSION['PrjUserCityId'];

    176. 

  176. 

    177. 

  177.         if(isset($_SESSION['PrjUserStateId']))

    178. 

  178.             $state=$_SESSION['PrjUserStateId'];

    179. 

  179. 

    180. 

  180.         if(isset($_SESSION['PrjUserCountryId']))

    181. 

  181.             $country=$_SESSION['PrjUserCountryId'];

    182. 

  182. 

    183. 

  183. 

    184. 

  184.         $pageFlag=null;

    185. 

  185.         $select="SELECT T.* ,TV.id tvId,TV.venue_name venueName,USR.username,USR.id as postedbyuser,TCAT.id as ticketcategoryId ,TCAT.cat_name as ticketcategory";

    186. 

  186.         $from=" FROM tickets T

    187. 

  187. 				LEFT JOIN ticket_event_venue TV ON (T.ticket_venue_section_id=TV.id)

    188. 

  188. 				LEFT JOIN ticket_event_category TCAT  ON (T.ticket_category_id=TCAT.id)

    189. 

  189. 				LEFT JOIN users USR ON (T.user_id=USR.id)

    190. 

  190. 				";

    191. 

  191.         $where="WHERE  T.is_temp='0' AND (NOW() < ticevent_enddate) AND parent_id=0";

    192. 

  192. 

    193. 

  193.         if(isset($city) && $city!=0)

    194. 

  194.             $where.=" AND TV.venue_city_id='".$city."'";

    195. 

  195. 

    196. 

  196.         if(isset($state) && $state!=0)

    197. 

  197.             $where.=" AND TV.venue_state_id='".$state."'";

    198. 

  198. 

    199. 

  199.         if(isset($country) && $country!=0)

    200. 

  200.             $where.=" AND TV.venue_country_id='".$country."'";

    201. 

  201. 

    202. 

  202.         $where.="  ORDER BY T.ticevent_startdate ";

    203. 

  203. 

    204. 

  204.         $CountField='T.id';

    205. 

  205. 

    206. 

  206. 

    207. 

  207.         $SelectRecord = mysql_query("$select $from $where LIMIT 12") or die('Line no '.__LINE__ . mysql_error());

    208. 

  208.         $this->set("ticketQry",$SelectRecord);

    209. 

  209. 

    210. 

  210.         $this->render('hotticket','ajax');

    211. 

  211. 

    212. 

  212.     }

    213. 

  213. 

    214. 

  214.     function category() {

    215. 

  215.         $catid=0;

    216. 

  216.         $searchpass ='';

    217. 

  217.         $this->layout = 'ticketdetail';

    218. 

  218.         $this->ticketCategory();

    219. 

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

    220. 

  220. 

    221. 

  221.         $select="SELECT T.* ,TV.id tvId,TV.venue_name venueName,USR.username,USR.id as postedbyuser,TCAT.id as ticketcategoryId ,TCAT.cat_name as ticketcategory";

    222. 

  222.         $from=" FROM tickets T

    223. 

  223. 				LEFT JOIN ticket_event_venue TV ON (T.ticket_venue_section_id=TV.id)

    224. 

  224. 				LEFT JOIN ticket_event_category TCAT  ON (T.ticket_category_id=TCAT.id)

    225. 

  225. 				LEFT JOIN users USR ON (T.user_id=USR.id)

    226. 

  226. 				";

    227. 

  227.         $where="WHERE  T.is_temp='0' AND (NOW() < ticevent_enddate) AND parent_id>0";

    228. 

  228. 

    229. 

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

    230. 

  230.             $catid=base64_decode($this->params['pass']['0']);

    231. 

  231.         }

    232. 

  232.         if(isset($this->data['Ticket']['ticketcat']) && $this->data['Ticket']['ticketcat']>0) {

    233. 

  233.             $catid = $this->data['Ticket']['ticketcat'];

    234. 

  234.         }

    235. 

  235.         if(isset($_REQUEST['catid']) && $_REQUEST['catid']!='') {

    236. 

  236.             $catid = $_REQUEST['catid'];

    237. 

  237.         }

    238. 

  238. 

    239. 

  239.         if(isset($this->data['Ticket']['srchtect']) && $this->data['Ticket']['srchtect']!="" && $this->data['Ticket']['srchtect']!="Event name or zip") {

    240. 

  240.             $srchtect = addslashes($this->data['Ticket']['srchtect']);

    241. 

  241.         }

    242. 

  242.         if(isset($_REQUEST['srchtect']) && $_REQUEST['srchtect']!='') {

    243. 

  243.             $srchtect = addslashes($_REQUEST['srchtect']);

    244. 

  244.         }

    245. 

  245. 

    246. 

  246.         if(isset($this->data['Ticket']['srchdate']) && $this->data['Ticket']['srchdate']!=0) {

    247. 

  247.             $ticDate =  $this->data['Ticket']['srchdate'];

    248. 

  248.         }

    249. 

  249.         if(isset($_REQUEST['ticDate']) && $_REQUEST['ticDate']!='') {

    250. 

  250.             $ticDate = $_REQUEST['ticDate'];

    251. 

  251.         }

    252. 

  252. 

    253. 

  253.         if(isset($_SESSION['PrjUserCityId']))

    254. 

  254.             $city=$_SESSION['PrjUserCityId'];

    255. 

  255. 

    256. 

  256.         if(isset($_SESSION['PrjUserStateId']))

    257. 

  257.             $state=$_SESSION['PrjUserStateId'];

    258. 

  258. 

    259. 

  259.         if(isset($_SESSION['PrjUserCountryId']))

    260. 

  260.             $country=$_SESSION['PrjUserCountryId'];

    261. 

  261. 

    262. 

  262. 

    263. 

  263.         if(isset($catid) && $catid>0) {

    264. 

  264.             $where.= " AND T.ticket_category_id='".$catid."' ";

    265. 

  265.         }

    266. 

  266. 

    267. 

  267.         if(isset($city) && $city!=0)

    268. 

  268.             $where.=" AND TV.venue_city_id='".$city."'";

    269. 

  269. 

    270. 

  270.         if(isset($state) && $state!=0)

    271. 

  271.             $where.=" AND TV.venue_state_id='".$state."'";

    272. 

  272. 

    273. 

  273.         if(isset($country) && $country!=0)

    274. 

  274.             $where.=" AND TV.venue_country_id='".$country."'";

    275. 

  275. 

    276. 

  276.         if(isset($srchtect) && $srchtect!='') {

    277. 

  277.             $where.= " AND ( T.ticevent_name LIKE '%".$srchtect."%' OR (TV.venue_zip!=0 AND TV.venue_zip='".$srchtect."')) ";

    278. 

  278.             $searchpass .= '&srchtect='.$srchtect;

    279. 

  279.         }

    280. 

  280. 

    281. 

  281.         if(isset($ticDate) && $ticDate!='') {

    282. 

  282.             $where.=" AND T.ticevent_startdate<='".$ticDate."'";

    283. 

  283.             $searchpass .= '&ticDate='.$ticDate;

    284. 

  284.         }

    285. 

  285. 

    286. 

  286.         $others = 'ORDER BY T.ticevent_startdate';

    287. 

  287. 

    288. 

  288.         $this->set('catid',$catid);

    289. 

  289. 

    290. 

  290.         $PassParameter='catid='.$catid.$searchpass;

    291. 

  291. 

    292. 

  292.         $CountField="T.id";

    293. 

  293.         $this->set("controller","tickets");

    294. 

  294.         $this->set("action","category");

    295. 

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

    296. 

  296. 

    297. 

  297.         $this->set('elementsUpdate',array('backdroplist','relatedevent'));

    298. 

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

    299. 

  299.         if(isset($this->params['url']['Page']) || isset($_REQUEST['form_ajax']) ) {

    300. 

  300.             $this->render("category2","ajax");

    301. 

  301.         }

    302. 

  302. 

    303. 

  303.     }

    304. 

  304.    

    305. 

  305.     function saveperformer() {

    306. 

  306.         $inserintoperfomer_id =0;

    307. 

  307.         if(isset($_POST['add']) && $_POST['add']==1) {

    308. 

  308.             $sql =  "INSERT INTO ticket_event_performer SET user_id='".$_SESSION['UserId']."'";

    309. 

  309.             mysql_query($sql);

    310. 

  310.             $inserintoperfomer_id = mysql_insert_id();

    311. 

  311.         }else if(isset($_POST['deleteorg']) && isset($_POST['oid']) && $_POST['deleteorg']==1) {

    312. 

  312.             $sql =  "DELETE FROM ticket_event_performer WHERE id='".$_POST['oid']."'";

    313. 

  313.             mysql_query($sql);

    314. 

  314.             $inserintoperfomer_id = $_POST['oid'];

    315. 

  315.         }

    316. 

  316.         else if(isset($_POST['editorg']) && isset($_POST['oid']) && $_POST['editorg']==1 && $_POST['oid']!=0) {

    317. 

  317.             $sql =  "UPDATE ticket_event_performer SET performer_name='".addslashes($_POST['name'])."' , perfomer_desc = '".addslashes($_POST['description'])."', performer_phone = '".addslashes($_POST['phone'])."', performer_email = '".addslashes($_POST['email'])."'

    318. 

  318.                      , performer_address = '".addslashes($_POST['address'])."', performer_zip = '".addslashes($_POST['zip'])."', performer_country='".$_POST['country']."', performer_state='".$_POST['state']."', performer_city='".$_POST['city']."'

    319. 

  319.                      WHERE id='".addslashes($_POST['oid'])."' AND user_id='".$_SESSION['UserId']."'";

    320. 

  320.             mysql_query($sql) or die($sql);

    321. 

  321.             $inserintoperfomer_id = $_POST['oid'];

    322. 

  322.         }

    323. 

  323. 

    324. 

  324.         $this->set('id',$inserintoperfomer_id);

    325. 

  325.     }

    326. 

  326. 

    327. 

  327.     function create($tidCopy=null) {

    328. 

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

    329. 

  329.         $this->layout = 'ticket_create';

    330. 

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

    331. 

  331.             //$this->Session->write('actContinue','tickets/create');

    332. 

  332.         }else {

    333. 

  333. 

    334. 

  334.             $this->set('countrylist',$this->getCountryList());

    335. 

  335.             $sql = "SELECT * FROM ticket_event_performer WHERE user_id='".$_SESSION['UserId']."' AND blocked='0'";

    336. 

  336.             $this->set('performerlist',mysql_query($sql));

    337. 

  337.             $this->ticketCategory();

    338. 

  338.             $this->set('stateList',array('0'=>'Select State'));

    339. 

  339.             $this->set('cityList',array('0'=>'Select City'));

    340. 

  340. 

    341. 

  341.             $ticketsql_id=0;

    342. 

  342. 

    343. 

  343. 

    344. 

  344.             if(isset($_POST['t']) && md5(md5('save'))==$_POST['t']) {

    345. 

  345.                 

    346. 

  346.                 if(isset($_POST['tid']) && $_POST['tid']!='') {

    347. 

  347.                     $ticketsql_id = base64_decode($_POST['tid']);

    348. 

  348.                     $sql = 'SELECT * FROM tickets WHERE id="'.$ticketsql_id.'" AND user_id="'.$_SESSION['UserId'].'"';

    349. 

  349.                     $result = mysql_query($sql);

    350. 

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

    351. 

  351.                         //update ticket_event_venue

    352. 

  352.                         $ticket_venue_section_id = $row['ticket_venue_section_id'];

    353. 

  353.                         $sql = "UPDATE ticket_event_venue SET venue_name='".addslashes($_REQUEST['venue_name'])."' , venue_desc = '',venue_address='".addslashes($_REQUEST['address_1'])."',

    354. 

  354.                             venue_city_id='".$_REQUEST['city']."',venue_state_id='".$_REQUEST['province']."',venue_country_id='".$_REQUEST['country']."',venue_zip='".$_REQUEST['postal_code']."', venue_phone='".$_REQUEST['phone']."'

    355. 

  355.                              WHERE id='".$ticket_venue_section_id."'";

    356. 

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

    357. 

  357.                     }

    358. 

  358.                 }

    359. 

  359.                 if(!isset($ticket_venue_section_id) || $ticket_venue_section_id==0) {

    360. 

  360.                     //save venue

    361. 

  361.                     $sql = "Insert Into ticket_event_venue SET user_id='".$_SESSION['UserId']."' , venue_name='".addslashes($_REQUEST['venue_name'])."' , venue_desc = '',venue_address='".addslashes($_REQUEST['address_1'])."',

    362. 

  362.                             venue_city_id='".$_REQUEST['city']."',venue_state_id='".$_REQUEST['province']."',venue_country_id='".$_REQUEST['country']."',venue_zip='".$_REQUEST['postal_code']."', venue_phone='".$_REQUEST['phone']."' ";

    363. 

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

    364. 

  364. 

    365. 

  365.                     $ticket_venue_section_id = mysql_insert_id();

    366. 

  366.                 }

    367. 

  367. 

    368. 

  368.                 if($ticketsql_id!='' && $ticketsql_id!=0) {

    369. 

  369.                     $ticketsql = "UPDATE tickets SET

    370. 

  370.                             ticevent_name = '".addslashes($_POST['evname'])."', paypal_email = '".addslashes($_POST['paypal_email'])."',

    371. 

  371.                             ticket_category_id='".$_POST['channels']."',

    372. 

  372.                             ticevent_desc='".addslashes($_POST['description'])."', ticevent_terms='".addslashes($_POST['terms'])."',

    373. 

  373.                             ticket_event_performer_id='".$_POST['savedOrganizers']."', ticket_venue_section_id='".$ticket_venue_section_id."',

    374. 

  374.                             ticket_ship_master_id='1', user_id='".$_SESSION['UserId']."',

    375. 

  375.                             ticevent_image='".addslashes($_POST['image'])."', ticevent_logoimage='".addslashes($_POST['logo'])."',                            

    376. 

  376.                             is_featured='0', is_hotlisted='0',

    377. 

  377.                             timezone_id='".addslashes($_POST['timezone'])."',

    378. 

  378.                             ticket_tags='".addslashes($_POST['tags'])."', is_show_remaining='".(isset($_POST['show_remaining'])?1:0)."',

    379. 

  379.                             is_temp='".$_POST['is_temp']."', seating_type='".$_POST['seating_type']."', is_public='".(isset($_POST['show_public'])?1:0)."' 

    380. 

  380.                             ".(!isset($_POST['show_public']) ? ", password_private='".$_POST['password_private']."'" : '')."

    381. 

  381.                             WHERE id='".$ticketsql_id."' ";

    382. 

  382.                     //ticevent_startdate='".$start_date."', ticevent_enddate='".$end_date."', ticket_dooropen='".$dooropen."',

    383. 

  383.                     mysql_query($ticketsql) or die($ticketsql);

    384. 

  384.                 }else {

    385. 

  385.                     $ticketsql = "INSERT INTO tickets SET

    386. 

  386.                             ticevent_name = '".addslashes($_POST['evname'])."', paypal_email = '".addslashes($_POST['paypal_email'])."',

    387. 

  387.                             ticket_category_id='".$_POST['channels']."',

    388. 

  388.                             ticevent_desc='".addslashes($_POST['description'])."', ticevent_terms='".addslashes($_POST['terms'])."',

    389. 

  389.                             ticket_event_performer_id='".$_POST['savedOrganizers']."', ticket_venue_section_id='".$ticket_venue_section_id."',

    390. 

  390.                             ticket_ship_master_id='1', user_id='".$_SESSION['UserId']."',

    391. 

  391.                             ticevent_image='".addslashes($_POST['image'])."', ticevent_logoimage='".addslashes($_POST['logo'])."',

    392. 

  392.                             is_featured='0', is_hotlisted='0', 

    393. 

  393.                             timezone_id='".addslashes($_POST['timezone'])."', 

    394. 

  394.                             ticket_tags='".addslashes($_POST['tags'])."', is_show_remaining='".(isset($_POST['show_remaining'])?1:0)."',

    395. 

  395.                             is_temp='".$_POST['is_temp']."', seating_type='".$_POST['seating_type']."', is_public='".(isset($_POST['show_public'])?1:0)."'

    396. 

  396.                             ".(!isset($_POST['show_public']) ? ", password_private='".$_POST['password_private']."'" : '');

    397. 

  397.                    

    398. 

  398.                     mysql_query($ticketsql) or die($ticketsql);

    399. 

  399.                     $ticketsql_id = mysql_insert_id();

    400. 

  400.                 }

    401. 

  401. 

    402. 

  402.                 //update datetime

    403. 

  403.                 foreach($_REQUEST['customDates'] as $key=>$value){

    404. 

  404.                     $customDates = split('startDate', $value);

    405. 

  405.                     $start_date = $customDates[0];

    406. 

  406. 

    407. 

  407.                     $customDates = $customDates[1];

    408. 

  408.                     $customDates = split('startTime', $customDates);

    409. 

  409.                     $start_time = $customDates[0];

    410. 

  410. 

    411. 

  411.                     $customDates = $customDates[1];

    412. 

  412.                     $customDates = split('endDate', $customDates);

    413. 

  413.                     $end_date = $customDates[0];

    414. 

  414. 

    415. 

  415.                     $customDates = $customDates[1];

    416. 

  416.                     $customDates = split('endTime', $customDates);

    417. 

  417.                     $end_time = $customDates[0];

    418. 

  418. 

    419. 

  419.                     $dooropen = $customDates[1];

    420. 

  420. 

    421. 

  421.                     $start_date = split('/', $start_date);

    422. 

  422.                     $start_date = $start_date[2].'-'.$start_date[0].'-'.$start_date[1].' '.$start_time;

    423. 

  423. 

    424. 

  424.                     $end_date = split('/', $end_date);

    425. 

  425.                     $end_date = $end_date[2].'-'.$end_date[0].'-'.$end_date[1].' '.$end_time;

    426. 

  426.                     $sql = "UPDATE tickets SET ticevent_startdate='".$start_date."', ticevent_enddate='".$end_date."', ticket_dooropen='".$dooropen."' 

    427. 

  427.                             WHERE id='".$key."'";

    428. 

  428.                     mysql_query($sql) or die($sql);

    429. 

  429.                 }

    430. 

  430. 

    431. 

  431.                 //update for children

    432. 

  432.                 //get list id children

    433. 

  433.                 $sql = "SELECT id FROM tickets WHERE parent_id='".$ticketsql_id."'";

    434. 

  434.                 $result = mysql_query($sql);

    435. 

  435.                 $listid = array();

    436. 

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

    437. 

  437.                     $listid[] = $row['id'];

    438. 

  438.                 }

    439. 

  439.                 if(count($listid)>0){

    440. 

  440.                     //info ticket parent

    441. 

  441.                     $sql = "SELECT * FROM tickets WHERE id='".$ticketsql_id."'";

    442. 

  442.                     $result = mysql_query($sql);

    443. 

  443.                     $parent = mysql_fetch_array($result);

    444. 

  444.                     //update information public

    445. 

  445.                     $ticketsql = "UPDATE tickets SET

    446. 

  446.                             ticevent_name = '".$parent['ticevent_name']."', paypal_email = '".$parent['paypal_email']."',

    447. 

  447.                             ticket_category_id='".$parent['ticket_category_id']."',

    448. 

  448.                             ticevent_desc='".$parent['ticevent_desc']."', ticevent_terms='".$parent['ticevent_terms']."',

    449. 

  449.                             ticket_event_performer_id='".$parent['ticket_event_performer_id']."', ticket_venue_section_id='".$parent['ticket_venue_section_id']."',

    450. 

  450.                             ticket_ship_master_id='1', user_id='".$parent['user_id']."',

    451. 

  451.                             ticevent_image='".$parent['ticevent_image']."', ticevent_logoimage='".$parent['ticevent_logoimage']."',

    452. 

  452.                             is_featured='0', is_hotlisted='0',

    453. 

  453.                             timezone_id='".$parent['timezone_id']."', 

    454. 

  454.                             ticket_tags='".$parent['ticket_tags']."', is_show_remaining='".$parent['is_show_remaining']."',

    455. 

  455.                             is_temp='".$parent['is_temp']."', seating_type='".$parent['seating_type']."', is_public='".$parent['is_public']."',

    456. 

  456.                             password_private='".$parent['password_private']."'

    457. 

  457.                             WHERE id IN (".join(',',$listid).") ";

    458. 

  458.                     mysql_query($ticketsql) or die($ticketsql);

    459. 

  459.                     //update product

    460. 

  460.                     if($parent['seating_type']==0){

    461. 

  461.                         $sql = "SELECT * FROM tickets_product WHERE tickets_id='".$parent['id']."'";

    462. 

  462.                         $result = mysql_query($sql) or die($sql);

    463. 

  463.                         while($p = mysql_fetch_array($result)){

    464. 

  464.                             foreach($listid as $ticket_child){

    465. 

  465.                                 $sql = "SELECT * FROM tickets_product WHERE tickets_id='".$ticket_child."' AND seat_name='".$p['seat_name']."' ";

    466. 

  466.                                 $result_p = mysql_query($sql) or die($sql);

    467. 

  467.                                 if(!($row=mysql_fetch_array($result_p))){

    468. 

  468.                                     $sql = "INSERT tickets_product SET tickets_id='".$ticket_child."', seat_name='".$p['seat_name']."',

    469. 

  469.                                             seat_qty='".$p['seat_qty']."', seat_price='".$p['seat_price']."',color='".$p['color']."',

    470. 

  470.                                             enabled='".$p['enabled']."', handicap='".$p['handicap']."' ";

    471. 

  471.                                     mysql_query($sql) or die($sql);

    472. 

  472.                                 }

    473. 

  473.                             }

    474. 

  474.                         }

    475. 

  475.                         

    476. 

  476.                     }

    477. 

  477.                 }

    478. 

  478.                 if(isset($_POST['is_temp'])) {

    479. 

  479.                     $this->redirect('tickets/index');

    480. 

  480.                 }

    481. 

  481. 

    482. 

  482.                 $this->set('updated',1);

    483. 

  483.             }

    484. 

  484. 

    485. 

  485.             if(isset($_REQUEST['tid']) && $_REQUEST['tid']!='') {

    486. 

  486.                 $ticketsql_id = base64_decode($_REQUEST['tid']);

    487. 

  487.             }

    488. 

  488. 

    489. 

  489.             if(isset($_POST['is_preview']) && $_POST['is_preview']==1) {

    490. 

  490.                 $this->redirect('tickets/previewevent/'.base64_encode($ticketsql_id));

    491. 

  491.             }

    492. 

  492. 

    493. 

  493.             if($tidCopy!=null) {

    494. 

  494.                 $tidCopy = base64_decode($tidCopy);

    495. 

  495.                 $sql = "SELECT * FROM tickets

    496. 

  496.                         WHERE id='".addslashes($tidCopy)."' AND user_id='".$_SESSION['UserId']."' ";

    497. 

  497.                 $result = mysql_query($sql);

    498. 

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

    499. 

  499.                     //Insert ticket_event_venue

    500. 

  500.                     $sql = "INSERT INTO ticket_event_venue(`venue_name`,`venue_address`,`venue_phone`,`venue_city_id`,`venue_state_id`,`venue_country_id`,`user_id`,`venue_desc`,`venue_zip`)

    501. 

  501.                         SELECT `venue_name`,`venue_address`,`venue_phone`,`venue_city_id`,`venue_state_id`,`venue_country_id`,`user_id`,`venue_desc`,`venue_zip`

    502. 

  502.                         FROM ticket_event_venue WHERE id=".$row['ticket_venue_section_id'];

    503. 

  503. 

    504. 

  504.                     mysql_query($sql)or die(mysql_errno());

    505. 

  505.                     $ticket_venue_section_id = mysql_insert_id();

    506. 

  506.                     

    507. 

  507.                     $ticketsql = "INSERT INTO tickets SET

    508. 

  508.                             ticevent_name = '".$row['ticevent_name']." copy', paypal_email='".$row['paypal_email']."',

    509. 

  509.                             ticevent_startdate='".$row['ticevent_startdate']."', ticevent_enddate='".$row['ticevent_enddate']."',  ticket_dooropen='".$row['ticket_dooropen']."',

    510. 

  510.                             ticket_category_id='".$row['ticket_category_id']."',

    511. 

  511.                             ticevent_desc='".$row['ticevent_desc']."', ticevent_terms='".$row['ticevent_terms']."',

    512. 

  512.                             ticket_event_performer_id='".$row['ticket_event_performer_id']."', ticket_venue_section_id='".$ticket_venue_section_id."',

    513. 

  513.                             ticket_ship_master_id='1', user_id='".$_SESSION['UserId']."',

    514. 

  514.                             ticevent_image='".$row['ticevent_image']."', ticevent_logoimage='".$row['ticevent_logoimage']."',                            

    515. 

  515.                             is_featured='0', is_hotlisted='0',                           

    516. 

  516.                             timezone_id='".$row['timezone_id']."', 

    517. 

  517.                             ticket_tags='".$row['ticket_tags']."', is_show_remaining='".$row['is_show_remaining']."',

    518. 

  518.                             is_temp='1', seating_type='".$row['seating_type']."',

    519. 

  519.                             is_public='".$row['is_public']."',password_private='".$row['password_private']."'";

    520. 

  520. 

    521. 

  521.                     mysql_query($ticketsql) or die(mysql_errno());

    522. 

  522.                     $ticketsql_id = mysql_insert_id();

    523. 

  523. 

    524. 

  524.                     $seatsxml = $row['seatsxml'];

    525. 

  525.                     $seatsxml_new = $seatsxml;

    526. 

  526. 

    527. 

  527.                     //insert tickets_product

    528. 

  528.                     $sql = "SELECT * FROM tickets_product WHERE tickets_id='".$row['id']."' ";

    529. 

  529.                     $result = mysql_query($sql)or die($sql);

    530. 

  530.                     $listp = array();

    531. 

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

    532. 

  532.                         $listp[] = $row;

    533. 

  533.                         $sql = "INSERT INTO tickets_product SET tickets_id='".$ticketsql_id."', seat_name='".$row['seat_name']."', seat_qty='".$row['seat_qty']."', seat_price='".$row['seat_price']."',

    534. 

  534.                                         color='".$row['color']."', enabled='".$row['enabled']."',handicap='".$row['handicap']."' ";

    535. 

  535.                         mysql_query($sql)or die(mysql_errno());

    536. 

  536.                         if($seatsxml_new!=''){

    537. 

  537.                             $product_id_new = mysql_insert_id();

    538. 

  538.                             //update id for product

    539. 

  539.                             $old = '/id="'.$row['id'].'"/';

    540. 

  540.                             $new = 'id="'.$product_id_new.'"';

    541. 

  541.                             $seatsxml_new = preg_replace($old,$new , $seatsxml_new);

    542. 

  542. 

    543. 

  543.                             //update group_id for seat, shape

    544. 

  544.                             $old = '/group_id="'.$row['id'].'"/';

    545. 

  545.                             $new = 'group_id="'.$product_id_new.'"';

    546. 

  546. 

    547. 

  547.                             $seatsxml_new = preg_replace($old,$new , $seatsxml_new);

    548. 

  548.                         }

    549. 

  549.                     }

    550. 

  550. 

    551. 

  551.                     $sql= "UPDATE tickets SET seatsxml='".$seatsxml_new."' WHERE id='".$ticketsql_id."'";

    552. 

  552.                     mysql_query($sql)or die(mysql_errno());

    553. 

  553. 

    554. 

  554.                     //check add children

    555. 

  555.                     $sql = "SELECT * FROM tickets WHERE parent_id='".addslashes($tidCopy)."' AND user_id='".$_SESSION['UserId']."' ";

    556. 

  556.                     $result = mysql_query($sql);

    557. 

  557.                     while($child=mysql_fetch_array($result)){

    558. 

  558.                         //insert ticket

    559. 

  559.                         $ticketsql = "INSERT INTO tickets SET

    560. 

  560.                             parent_id='".$ticketsql_id."',

    561. 

  561.                             ticevent_name = '".$child['ticevent_name']." copy', paypal_email='".$child['paypal_email']."',

    562. 

  562.                             ticevent_startdate='".$child['ticevent_startdate']."', ticevent_enddate='".$child['ticevent_enddate']."',  ticket_dooropen='".$child['ticket_dooropen']."',

    563. 

  563.                             ticket_category_id='".$child['ticket_category_id']."',

    564. 

  564.                             ticevent_desc='".$child['ticevent_desc']."', ticevent_terms='".$child['ticevent_terms']."',

    565. 

  565.                             ticket_event_performer_id='".$child['ticket_event_performer_id']."', ticket_venue_section_id='".$ticket_venue_section_id."',

    566. 

  566.                             ticket_ship_master_id='1', user_id='".$_SESSION['UserId']."',

    567. 

  567.                             ticevent_image='".$child['ticevent_image']."', ticevent_logoimage='".$child['ticevent_logoimage']."',

    568. 

  568.                             is_featured='0', is_hotlisted='0',

    569. 

  569.                             timezone_id='".$child['timezone_id']."', 

    570. 

  570.                             ticket_tags='".$child['ticket_tags']."', is_show_remaining='".$child['is_show_remaining']."',

    571. 

  571.                             is_temp='1', seating_type='".$child['seating_type']."',

    572. 

  572.                             is_public='".$child['is_public']."', password_private='".$child['password_private']."'";

    573. 

  573. 

    574. 

  574.                         mysql_query($ticketsql) or die(mysql_errno());

    575. 

  575.                         $child_new_id = mysql_insert_id();

    576. 

  576.                         //insert product

    577. 

  577.                         $seatsxml_new = $seatsxml;

    578. 

  578.                         foreach($listp as $p){

    579. 

  579.                             $sql = "INSERT INTO tickets_product SET tickets_id='".$child_new_id."', seat_name='".$p['seat_name']."', seat_qty='".$p['seat_qty']."', seat_price='".$p['seat_price']."',

    580. 

  580.                                         color='".$p['color']."', enabled='".$p['enabled']."',handicap='".$p['handicap']."' ";

    581. 

  581.                             mysql_query($sql)or die(mysql_errno());

    582. 

  582.                             if($seatsxml_new!=''){

    583. 

  583.                                 $product_id_new = mysql_insert_id();

    584. 

  584.                                 //update id for product

    585. 

  585.                                 $old = '/id="'.$p['id'].'"/';

    586. 

  586.                                 $new = 'id="'.$product_id_new.'"';

    587. 

  587.                                 $seatsxml_new = preg_replace($old,$new , $seatsxml_new);

    588. 

  588. 

    589. 

  589.                                 //update group_id for seat, shape

    590. 

  590.                                 $old = '/group_id="'.$p['id'].'"/';

    591. 

  591.                                 $new = 'group_id="'.$product_id_new.'"';

    592. 

  592. 

    593. 

  593.                                 $seatsxml_new = preg_replace($old,$new , $seatsxml_new);

    594. 

  594.                             }

    595. 

  595.                         }

    596. 

  596.                         $sql= "UPDATE tickets SET seatsxml='".$seatsxml_new."' WHERE id='".$child_new_id."'";

    597. 

  597.                         mysql_query($sql)or die(mysql_errno());

    598. 

  598.                     }

    599. 

  599.                 }

    600. 

  600.             }

    601. 

  601. 

    602. 

  602.             if($ticketsql_id>0) {

    603. 

  603.                 $sql = "SELECT tickets.*,tickets.id as tid,Venue.* FROM tickets

    604. 

  604.                         LEFT JOIN ticket_event_venue Venue ON (Venue.id=tickets.ticket_venue_section_id)

    605. 

  605.                         WHERE tickets.id='".addslashes($ticketsql_id)."' AND tickets.user_id='".$_SESSION['UserId']."' ";

    606. 

  606.                 $result = mysql_query($sql);

    607. 

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

    608. 

  608.                     $this->set('data',$row);

    609. 

  609.                     if($row['seating_type']=='0') {

    610. 

  610.                         //get ticket product

    611. 

  611.                         $sql = "SELECT * FROM tickets_product WHERE tickets_id='".$row['tid']."'";

    612. 

  612.                         $this->set('tickets_seat', mysql_query($sql));

    613. 

  613.                     }

    614. 

  614. 

    615. 

  615.                     if($row['venue_country_id']>=0) {

    616. 

  616.                         $this->set('stateList',$this->getStateList($row['venue_country_id']));

    617. 

  617.                     }

    618. 

  618.                     if($row['venue_state_id']>=0) {

    619. 

  619.                         $this->set('cityList',$this->getCityList($row['venue_state_id']));

    620. 

  620.                     }

    621. 

  621.                    

    622. 

  622.                     $this->set('tid',$ticketsql_id);

    623. 

  623.                     

    624. 

  624.                     //get datetime children

    625. 

  625.                     $sql = "SELECT id,ticevent_startdate,ticevent_enddate,ticket_dooropen FROM tickets WHERE parent_id='".$ticketsql_id."'";

    626. 

  626.                     $result = mysql_query($sql);

    627. 

  627.                     $datetimes = array();

    628. 

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

    629. 

  629.                         $datetimes[] = $row;

    630. 

  630.                     }

    631. 

  631.                     if(count($datetimes)>0)

    632. 

  632.                         $this->set('datetimes',$datetimes);

    633. 

  633.                 }

    634. 

  634.             }else {//new

    635. 

  635.                 //delete all tickets is_temp='1' and title=''

    636. 

  636.                 $sql = "SELECT id FROM tickets WHERE is_temp='1' AND ticevent_name='' AND user_id='".$_SESSION['UserId']."'";

    637. 

  637.                 $result = mysql_query($sql);

    638. 

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

    639. 

  639.                     mysql_query("DELETE FROM tickets WHERE id='".$row['id']."'");

    640. 

  640.                     mysql_query("DELETE FROM tickets_product WHERE tickets_id='".$row['id']."'");

    641. 

  641.                 }

    642. 

  642.                 //insert tickets empty

    643. 

  643.                 $query = "INSERT tickets SET is_temp='1', user_id='".$_SESSION['UserId']."'";

    644. 

  644.                 mysql_query($query);

    645. 

  645.                 $ticketsql_id = mysql_insert_id();

    646. 

  646.                 $this->set('tid',$ticketsql_id);

    647. 

  647.             }

    648. 

  648.         }

    649. 

  649.     }

    650. 

  650. 

    651. 

  651.     function ajax_saveticketseat() {

    652. 

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

    653. 

  653.         if(isset($_POST['tic_action']) && $_POST['tic_action']!='') {

    654. 

  654.             if(isset($_POST['tic_id']) && $_POST['tic_id']>0) {

    655. 

  655.                 if(isset($_POST['tic_action'])) {

    656. 

  656.                     if($_POST['tic_action']=='delete') {

    657. 

  657.                         $sql = "SELECT * FROM tickets_product WHERE id='".$_POST['tic_id']."'";

    658. 

  658.                         $result = mysql_query($sql);

    659. 

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

    660. 

  660.                             $seat_name = $row['seat_name'];

    661. 

  661.                             $sql = "SELECT P.id FROM tickets_product as P

    662. 

  662.                                     RIGHT JOIN tickets as T ON P.tickets_id=T.id

    663. 

  663.                                     WHERE T.parent_id='".$_POST['tictickets_id']."'";

    664. 

  664.                             $result = mysql_query($sql);

    665. 

  665.                             $listid = array();

    666. 

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

    667. 

  667.                                 $listid[] = $row['id'];

    668. 

  668.                             }

    669. 

  669.                             if(count($listid)>0){

    670. 

  670.                                 $sql = "DELETE FROM tickets_product WHERE id='".$_POST['tic_id']."' OR (id IN (".join(',',$listid).") AND seat_name='".$seat_name."')";

    671. 

  671.                             }else{

    672. 

  672.                                 $sql = "DELETE FROM tickets_product WHERE id='".$_POST['tic_id']."'";

    673. 

  673.                             }

    674. 

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

    675. 

  675.                         }                        

    676. 

  676.                         

    677. 

  677.                         $id = $_POST['tic_id'];

    678. 

  678.                         $out ='{"action":"delete","id" : "'.$id.'"}';

    679. 

  679.                     }

    680. 

  680.                     else {

    681. 

  681.                         $sql = "SELECT * FROM tickets_product WHERE id='".$_POST['tic_id']."'";

    682. 

  682.                         $result = mysql_query($sql);

    683. 

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

    684. 

  684.                             $seat_name = $row['seat_name'];

    685. 

  685.                             //check

    686. 

  686.                             $query = "SELECT count(id) as _count FROM tickets_product WHERE tickets_id='".$_POST['tictickets_id']."' AND id<>'".$_POST['tic_id']."' AND seat_name='".$_POST['ticcat']."'";

    687. 

  687.                             $result = mysql_query($query);

    688. 

  688.                             $row= mysql_fetch_array($result);

    689. 

  689.                             if($row['_count']>0){

    690. 

  690.                                 $out ='{"error":"Ticket Name Unavailable"}';

    691. 

  691.                             }else if($_POST['ticprice']<5){

    692. 

  692.                                 $out ='{"error":"Minimum price is $5"}';

    693. 

  693.                             }else{

    694. 

  694.                                 $sql = "SELECT P.id FROM tickets_product as P

    695. 

  695.                                     RIGHT JOIN tickets as T ON P.tickets_id=T.id

    696. 

  696.                                     WHERE T.parent_id='".$_POST['tictickets_id']."'";

    697. 

  697.                                 $result = mysql_query($sql);

    698. 

  698.                                 $listid = array();

    699. 

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

    700. 

  700.                                     $listid[] = $row['id'];

    701. 

  701.                                 }

    702. 

  702.                                 if(count($listid)>0){

    703. 

  703.                                     $sql = "UPDATE tickets_product SET seat_name='".$_POST['ticcat']."', seat_qty='".$_POST['ticquantity']."', seat_price='".$_POST['ticprice']."'

    704. 

  704.                                             WHERE id='".$_POST['tic_id']."' OR (id IN (".join(',',$listid).") AND seat_name='".$seat_name."')";

    705. 

  705.                                 }else{

    706. 

  706.                                     $sql = "UPDATE tickets_product SET seat_name='".$_POST['ticcat']."', seat_qty='".$_POST['ticquantity']."', seat_price='".$_POST['ticprice']."'

    707. 

  707.                                         WHERE id='".$_POST['tic_id']."'";

    708. 

  708.                                 }

    709. 

  709.                                 mysql_query($sql);

    710. 

  710.                                 $id = $_POST['tic_id'];

    711. 

  711.                                 $out ='{"action":"update","id" : "'.$id.'","ticcat": "'.$_POST['ticcat'].'", "ticquantity": "'.$_POST['ticquantity'].'", "ticprice": "'.$_POST['ticprice'].'"}';

    712. 

  712.                             }

    713. 

  713.                         }

    714. 

  714.                     }

    715. 

  715.                 }

    716. 

  716.             }else {

    717. 

  717.                 //check seat_name

    718. 

  718.                 $query = "SELECT count(id) as _count FROM tickets_product WHERE tickets_id='".$_POST['tictickets_id']."' AND seat_name='".$_POST['ticcat']."'";

    719. 

  719.                 $result = mysql_query($query);

    720. 

  720.                 $row= mysql_fetch_array($result);

    721. 

  721.                 if($row['_count']>0){

    722. 

  722.                     $out ='{"error":"Ticket Name Unavailable"}';

    723. 

  723.                 }else if($_POST['ticprice']<5){

    724. 

  724.                     $out ='{"error":"Minimum price is $5"}';

    725. 

  725.                 }else{

    726. 

  726.                     $sql = "INSERT INTO tickets_product SET tickets_id='".$_POST['tictickets_id']."', seat_name='".$_POST['ticcat']."', seat_qty='".$_POST['ticquantity']."', seat_price='".$_POST['ticprice']."',enabled=1 ";

    727. 

  727.                     mysql_query($sql);

    728. 

  728.                     $id = mysql_insert_id();

    729. 

  729.                     $out ='{"action":"insert","id" : "'.$id.'","ticcat": "'.$_POST['ticcat'].'", "ticquantity": "'.$_POST['ticquantity'].'", "ticprice": "'.$_POST['ticprice'].'"}';

    730. 

  730. 

    731. 

  731.                     $query = "SELECT id FROM tickets WHERE parent_id='".$_POST['tictickets_id']."' ";

    732. 

  732.                     $result = mysql_query($query);

    733. 

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

    734. 

  734.                         $sql = "INSERT INTO tickets_product SET tickets_id='".$row['id']."', seat_name='".$_POST['ticcat']."', seat_qty='".$_POST['ticquantity']."', seat_price='".$_POST['ticprice']."',enabled=1 ";

    735. 

  735.                         mysql_query($sql);

    736. 

  736.                     }

    737. 

  737.                 }

    738. 

  738.             }

    739. 

  739.         }

    740. 

  740. 

    741. 

  741.         if(!isset($out))

    742. 

  742.             $out = '{"action":""}';

    743. 

  743. 

    744. 

  744.         $this->set('out',$out);

    745. 

  745.     }

    746. 

  746. 

    747. 

  747.     function ajax_showticketproduct() {

    748. 

  748.         $out = '';

    749. 

  749.         if(isset($_POST['tickets_id'])) {

    750. 

  750.             $query = "SELECT * FROM tickets_product WHERE tickets_id='".$_POST['tickets_id']."' ";

    751. 

  751.             $result = mysql_query($query);

    752. 

  752. 

    753. 

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

    754. 

  754.                 if($out!='') $out .=",";

    755. 

  755.                 $out .= '{ "id":"'.$row['id'].'", "ticcat":"'.$row['seat_name'].'", "ticquantity":"'.$row['seat_qty'].'", "ticprice":"'.$row['seat_price'].'" }';

    756. 

  756.             }

    757. 

  757.         }

    758. 

  758.         $out = '{"data":['.$out.']}';

    759. 

  759. 

    760. 

  760.         $this->set('out',$out);

    761. 

  761.     }

    762. 

  762. 

    763. 

  763.     function ajax_resetSeatProduct() {

    764. 

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

    765. 

  765.         if(isset($_POST['id'])) {

    766. 

  766.             $sql = "SELECT id FROM tickets WHERE id='".$_POST['id']."' or parent_id='".$_POST['id']."'";

    767. 

  767.             $result = mysql_query($sql);

    768. 

  768.             $listid = array();              

    769. 

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

    770. 

  770.                 $listid[] = $row['id'];

    771. 

  771.             }

    772. 

  772. 

    773. 

  773.             if(count($listid)>0){

    774. 

  774.                 $sql= "DELETE FROM tickets_product WHERE tickets_id IN (".join(',',$listid).")";

    775. 

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

    776. 

  776.                 $sql = "UPDATE tickets SET seatsxml='', chart_id=0 WHERE id IN (".join(',',$listid).")";

    777. 

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

    778. 

  778.             }            

    779. 

  779.         }

    780. 

  780.         $this->render('blank_page');

    781. 

  781.     }

    782. 

  782. 

    783. 

  783.     function ajax_adddatetime() {

    784. 

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

    785. 

  785.         $out = '';

    786. 

  786.         if(isset($_POST['action'])){

    787. 

  787.             if( isset($_POST['parent_id']) && $_POST['action']=='insert'){

    788. 

  788.                 $parent_ticketid = $_POST['parent_id'];

    789. 

  789.                 if($_POST['action']=='insert'){

    790. 

  790.                     $ticket['Ticket']['parent_id'] = $parent_ticketid;

    791. 

  791.                     $ticket['Ticket']['user_id'] = $_SESSION['UserId'];

    792. 

  792.                     $ticket['Ticket']['is_temp'] = 1;

    793. 

  793.                     $this->Ticket->create();

    794. 

  794.                     $this->Ticket->save($ticket);

    795. 

  795.                     $id = $this->Ticket->id;

    796. 

  796.                 }

    797. 

  797.                 $out = '"action":"insert","id":"'.$id.'"';

    798. 

  798.             }else if(isset($_POST['id']) && $_POST['action']=='delete'){

    799. 

  799.                 $sql = "DELETE FROM tickets WHERE id='".$_POST['id']."'";

    800. 

  800.                 mysql_query($sql);

    801. 

  801.                 $out = '"action":"delete","id":"'.$_POST['id'].'"';

    802. 

  802.             }

    803. 

  803.         }

    804. 

  804. 

    805. 

  805.         $out = '{'.$out.'}';

    806. 

  806.         $this->set('out',$out);

    807. 

  807.      }

    808. 

  808. 

    809. 

  809.     function ajax_checkeventname(){

    810. 

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

    811. 

  811.         $out = '"check":"error"';

    812. 

  812.         if(isset($_POST['id']) && isset($_POST['evname'])){

    813. 

  813.             $id = base64_decode($_POST['id']);

    814. 

  814.             $sql = 'SELECT count(id) as _count FROM tickets WHERE id<>"'.$id.'" AND ticevent_name="'.addslashes($_POST['evname']).'" AND parent_id=0 ';

    815. 

  815.             $result = mysql_query($sql);

    816. 

  816.             $row = mysql_fetch_array($result) or die(mysql_error());

    817. 

  817.             if($row['_count']==0){

    818. 

  818.                 $out = '"check":"ok"';

    819. 

  819.             }

    820. 

  820.         }

    821. 

  821.         $out = '{'.$out.'}';

    822. 

  822.         $this->set('out',$out);

    823. 

  823.     }

    824. 

  824. 

    825. 

  825.     function eventlogoupload() {

    826. 

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

    827. 

  827. 

    828. 

  828.         $uploadstatus = 0;

    829. 

  829.         $imagefilename= 0;

    830. 

  830.         if(!isset($_REQUEST['type'])) $_REQUEST['type']='image';

    831. 

  831.         $type= $_REQUEST['type'];

    832. 

  832. 

    833. 

  833.         if (isset($_FILES['filedata'])) {

    834. 

  834.             $this->cleanUpFields();

    835. 

  835. 

    836. 

  836.             // grab the file

    837. 

  837.             $file = $_FILES['filedata'];

    838. 

  838.             // upload the image using the upload component

    839. 

  839.             //	pr($_FILES);

    840. 

  840.             $file_info = getimagesize($file['tmp_name']);

    841. 

  841.             if(!empty($file_info)) {

    842. 

  842. 

    843. 

  843.                 $des = "webroot/ticket_images/";

    844. 

  844.                 if(!file_exists($des))

    845. 

  845.                     mkdir($des);

    846. 

  846. 

    847. 

  847.                 $this->Upload->upload($file,$des);

    848. 

  848.                 if($this->Upload->errors!=null) {

    849. 

  849.                     $this->set('errors',join('<br/>',$this->Upload->errors));

    850. 

  850.                 }

    851. 

  851.                 else {

    852. 

  852.                     $uploadstatus = 1;

    853. 

  853.                     $filesrc = str_replace($des, '', $this->Upload->_name);

    854. 

  854.                     $file['tmp_name'] = $this->Upload->_name;

    855. 

  855.                     if($type=="image") {

    856. 

  856.                         $des = "webroot/ticket_images/medium/";

    857. 

  857.                         if(!file_exists($des))

    858. 

  858.                             mkdir($des);

    859. 

  859. 

    860. 

  860.                         $this->Upload->_name = $des.$filesrc;

    861. 

  861.                         $this->Upload->image($file,'resizemin',array(200,200),'jpg');

    862. 

  862. 

    863. 

  863.                         $des = "webroot/ticket_images/thumb/";

    864. 

  864.                         if(!file_exists($des))

    865. 

  865.                             mkdir($des);

    866. 

  866. 

    867. 

  867.                         $this->Upload->_name = $des.$filesrc;

    868. 

  868.                         $this->Upload->image($file,'resizemin',array(45,45),'jpg');

    869. 

  869.                     }else if($type=="logo") {

    870. 

  870.                         $des = "webroot/ticket_images/logo/";

    871. 

  871.                         if(!file_exists($des))

    872. 

  872.                             mkdir($des);

    873. 

  873. 

    874. 

  874.                         $this->Upload->_name = $des.$filesrc;

    875. 

  875.                         $this->Upload->image($file,'resizemin',array(100,100),'jpg');

    876. 

  876.                     }

    877. 

  877. 

    878. 

  878.                     $filethumb = str_replace($des, '', $this->Upload->_name);

    879. 

  879. 

    880. 

  880.                     //$this->set('filesrc' , $filesrc);

    881. 

  881.                     $this->set('filethumb' , $filethumb);

    882. 

  882.                 }

    883. 

  883.             }else {

    884. 

  884.                 $this->set('errors','Required file image.');

    885. 

  885.             }

    886. 

  886.         }

    887. 

  887. 

    888. 

  888.         if(isset($_REQUEST['filesrc']) && $_REQUEST['filesrc']!='') {

    889. 

  889.             $this->set('filethumb' , $_REQUEST['filesrc']);

    890. 

  890.         }

    891. 

  891.         $maxwidth = $type=='logo'?100:200;

    892. 

  892.         $this->set('maxwidth',$maxwidth);

    893. 

  893.         $this->set('maxdimension',"$maxwidth x $maxwidth");

    894. 

  894.         $this->set('uploadstatus',$uploadstatus);

    895. 

  895.     }

    896. 

  896. 

    897. 

  897.     function venueinfo($venueid=null) {

    898. 

  898.         $this->checkSession();

    899. 

  899.         $this->layout = 'ticketcategoryinner';

    900. 

  900.         $this->ticketCategory();

    901. 

  901. 

    902. 

  902.         $this->pageTitle = 'View venue';

    903. 

  903.         $this->set('venueid',$venueid);

    904. 

  904.     }

    905. 

  905. 

    906. 

  906.     function perfomerinfo($perfomerid = null) {

    907. 

  907.         $this->checkSession();

    908. 

  908.         $this->layout = 'ticketcategoryinner';

    909. 

  909.         $this->ticketCategory();

    910. 

  910.         $this->pageTitle = 'View Perfomer';

    911. 

  911.         $this->set('perfomerid',$perfomerid);

    912. 

  912.     }

    913. 

  913. 

    914. 

  914.     function getTicketDetails($eventId) {

    915. 

  915.         $q1=mysql_query("SELECT user_id,ticevent_name,ticevent_desc,ticket_category_id  FROM tickets WHERE id='".$eventId."'");

    916. 

  916.         return $rw=mysql_fetch_array($q1);

    917. 

  917.     }

    918. 

  918. 

    919. 

  919.     function remainingTicket($cart_id) {

    920. 

  920.         

    921. 

  921.         $sql = "SELECT DT.*,T.seating_type,C.tickets_id FROM ticket_cart_details as DT

    922. 

  922.                 RIGHT JOIN ticket_carts C ON C.id=DT.cart_id

    923. 

  923.                 RIGHT JOIN tickets T ON T.id=C.tickets_id

    924. 

  924.                 WHERE DT.cart_id='".$cart_id."' ";

    925. 

  925.         $result = mysql_query($sql) or die($this->log_content(mysql_error()));

    926. 

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

    927. 

  927.             if($row['seating_type']==0){//event without seat

    928. 

  928.                 $sql = " SELECT seat_qty FROM tickets_product tic WHERE tickets_id ='".$row['tickets_id']."' AND id='".$row['group_id']."' ";

    929. 

  929.                 $seat_result = mysql_query($sql);

    930. 

  930.                 $prod = mysql_fetch_array($seat_result);

    931. 

  931.                 $remain = $prod['seat_qty'];

    932. 

  932. 

    933. 

  933.                 //get the total no of tickets already sold or of transaction is in progress within the 15 min difference

    934. 

  934.                 $sql="SELECT SUM(item.qty) sold FROM ticket_cart_details as item

    935. 

  935.                           RIGHT JOIN ticket_carts cart ON (item.cart_id=cart.id)

    936. 

  936.                           WHERE cart.id<>".$cart_id." AND cart.tickets_id='".$row['tickets_id']."' AND item.group_id='".$row['group_id']."' AND (cart.pay_status='1' OR ( ADDTIME( cart.tran_time, '0:30:0') >=  NOW()) )

    937. 

  937.                           GROUP BY item.group_id";

    938. 

  938. 

    939. 

  939.                 $seat_result = mysql_query($sql) or die($this->log_content(mysql_error()));

    940. 

  940.                 if( ($item=mysql_fetch_array($seat_result)) ) {

    941. 

  941.                     $remain -= $item['sold'];

    942. 

  942.                 }

    943. 

  943. 

    944. 

  944.                 if($row['qty']>$remain){

    945. 

  945.                     return false;

    946. 

  946.                 }

    947. 

  947.             }else{//event with seat

    948. 

  948.                  $sql = "SELECT S.seatnumber,S.event_id FROM ticket_seat_booked as S

    949. 

  949.                         RIGHT JOIN ticket_carts cart ON (cart.id = S.cart_id)

    950. 

  950.                         WHERE S.cart_id<>".$cart_id." AND S.event_id='".$row['tickets_id']."' AND (cart.pay_status='1' OR (ADDTIME( cart.tran_time, '0:30:0') >=  NOW()) )";

    951. 

  951.                  $seats_book_result = mysql_query($sql) or die($this->log_content(mysql_error()));

    952. 

  952.                  $seats_book = array();

    953. 

  953.                  while($seat = mysql_fetch_array($seats_book_result)){

    954. 

  954.                      $seats_book[] = $seat['seatnumber'];

    955. 

  955.                  }

    956. 

  956.                  if(count($seats_book)>0){

    957. 

  957.                      $sql = "SELECT count(S.id) as _count FROM ticket_seat_booked as S

    958. 

  958.                              WHERE S.cart_detail_id=".$row['id']." AND S.seatnumber IN ('".join("','",$seats_book)."')";

    959. 

  959.                      $seats_result = mysql_query($sql) or die($this->log_content(mysql_error()));

    960. 

  960.                      $booked = mysql_fetch_array($seats_result);

    961. 

  961.                      if($booked['_count']>0){

    962. 

  962.                          return false;

    963. 

  963.                      }

    964. 

  964.                  }

    965. 

  965.             }

    966. 

  966.         }

    967. 

  967. 

    968. 

  968.         return true;

    969. 

  969.     }

    970. 

  970. 

    971. 

  971.     function addtocart() {

    972. 

  972.         $this->checkSession();

    973. 

  973.         $this->ticketCategory();

    974. 

  974.         $this->layout = 'ticketdetail';

    975. 

  975.         $cart_id = isset($_POST['cart_id']) ? $_POST['cart_id'] : null;

    976. 

  976.         if(empty($cart_id)) {

    977. 

  977.             $cart_id = $this->Session->read('cart_id');

    978. 

  978.         }

    979. 

  979. 

    980. 

  980.         $ticket_id = isset($_POST['ticket_id']) ? $_POST['ticket_id'] : null;

    981. 

  981.         if(empty($ticket_id)) {

    982. 

  982.             $ticket_id = $this->Session->read('ticket_id');

    983. 

  983.         }

    984. 

  984. 

    985. 

  985.         if(empty($cart_id) || empty($ticket_id)) {

    986. 

  986.             $this->set('msgerror','cart does not exists');

    987. 

  987.             return;

    988. 

  988.         }

    989. 

  989. 

    990. 

  990.         $ticket = $this->Ticket->findById($ticket_id);

    991. 

  991.         if(!$ticket) {

    992. 

  992.             $this->set('msgerror','Event does not exists');

    993. 

  993.             return;

    994. 

  994.         }

    995. 

  995. 

    996. 

  996.         $cart = $this->Ticket_carts->findById($cart_id);

    997. 

  997.         if(!$cart) {

    998. 

  998.             $this->set('msgerror','Cart does not exists');

    999. 

  999.             return;

    1000. 

  1000.         }

    1001. 

  1001. 

    1002. 

  1002.         if(isset($_POST['_action']) && $_POST['_action']=='cancel'){

    1003. 

  1003.             //delete cart

    1004. 

  1004.             $sql = "DELETE FROM ticket_carts WHERE id='".$cart_id."' ";

    1005. 

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

    1006. 

  1006.             //delete cart ticket_seat_booked

    1007. 

  1007.             $sql = "SELECT * FROM ticket_cart_details WHERE cart_id='".$cart_id."'";

    1008. 

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

    1009. 

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

    1010. 

  1010.                 $sql = "DELETE FROM ticket_seat_booked WHERE cart_detail_id='".$row['id']."' ";

    1011. 

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

    1012. 

  1012.             }

    1013. 

  1013.             //delete cart item

    1014. 

  1014.             $sql = "DELETE FROM ticket_cart_details WHERE cart_id='".$cart_id."' ";

    1015. 

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

    1016. 

  1016.             $this->redirect('tickets/eventdetail/'.base64_encode($ticket['Ticket']['ticket_category_id']).'/'.base64_encode($ticket_id));

    1017. 

  1017.             return;

    1018. 

  1018.         }

    1019. 

  1019. 

    1020. 

  1020.         //check paypal email seller

    1021. 

  1021.         if($ticket['Ticket']['paypal_email']=='') {

    1022. 

  1022.             $this->set('msgerror','Sorry, Seller do not set payment method');

    1023. 

  1023.             //delete cart

    1024. 

  1024.             $sql = "DELETE FROM ticket_carts WHERE id='".$cart_id."' ";

    1025. 

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

    1026. 

  1026.             //delete cart ticket_seat_booked

    1027. 

  1027.             $sql = "SELECT * FROM ticket_cart_details WHERE cart_id='".$cart_id."'";

    1028. 

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

    1029. 

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

    1030. 

  1030.                 $sql = "DELETE FROM ticket_seat_booked WHERE cart_detail_id='".$row['id']."' ";

    1031. 

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

    1032. 

  1032.             }

    1033. 

  1033.             //delete cart item

    1034. 

  1034.             $sql = "DELETE FROM ticket_cart_details WHERE cart_id='".$cart_id."' ";

    1035. 

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

    1036. 

  1036.             return;

    1037. 

  1037.         }

    1038. 

  1038. 

    1039. 

  1039.         $sql = "SELECT B.*,DT.group_name,DT.price

    1040. 

  1040.                 FROM ticket_seat_booked B

    1041. 

  1041.                 RIGHT JOIN ticket_cart_details DT ON (B.cart_detail_id=DT.id)

    1042. 

  1042.                 RIGHT JOIN ticket_carts C ON (C.id=B.cart_id)

    1043. 

  1043.                 RIGHT JOIN tickets T ON (T.id=C.tickets_id)

    1044. 

  1044.                 WHERE C.id='".$cart_id."'";

    1045. 

  1045. 

    1046. 

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

    1047. 

  1047. 

    1048. 

  1048.         $this->set('result',$result);

    1049. 

  1049. 

    1050. 

  1050.         $this->set('cart_id',$cart_id);

    1051. 

  1051.         $this->set('ticket_id',$ticket_id);

    1052. 

  1052.     }

    1053. 

  1053. 

    1054. 

  1054.     function ajax_removeitemcart() {

    1055. 

  1055.         $this->layout="blank";

    1056. 

  1056.         $this->render('blank_page');

    1057. 

  1057.         if(isset($_POST['cart_id']) && isset($_POST['item_id']) && isset($_SESSION['UserId'])) {

    1058. 

  1058.             $sql = "SELECT * FROM ticket_seat_booked WHERE id='".$_POST['item_id']."' LIMIT 1";

    1059. 

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

    1060. 

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

    1061. 

  1061.                 //update cart detail

    1062. 

  1062.                 $sql = "UPDATE ticket_cart_details SET qty=qty-1, subTotal=qty*price WHERE id='".$row['cart_detail_id']."'";

    1063. 

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

    1064. 

  1064.                 //update cart

    1065. 

  1065.                 $sql = "UPDATE ticket_carts SET total_price = (SELECT SUM(subTotal) FROM ticket_cart_details WHERE cart_id='".$row['cart_id']."'  )  WHERE id='".$row['cart_id']."'";

    1066. 

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

    1067. 

  1067. 

    1068. 

  1068.                 //delete item

    1069. 

  1069.                 $sql = "DELETE FROM ticket_seat_booked WHERE id='".$row['id']."'";

    1070. 

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

    1071. 

  1071.             }

    1072. 

  1072.         }

    1073. 

  1073.     }

    1074. 

  1074. 

    1075. 

  1075.     function payment() {

    1076. 

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

    1077. 

  1077.         $this->ticketCategory();

    1078. 

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

    1079. 

  1079.             $this->set('msgerror','Session die. Please login again');

    1080. 

  1080.             $this->layout = 'ticketdetail';

    1081. 

  1081.             return;

    1082. 

  1082.         }

    1083. 

  1083.         if(!isset($_POST['cart_id']) || !isset($_POST['ticket_id']) || !isset($_POST['holder_name']) ) {

    1084. 

  1084.             $this->set('msgerror','Sorry cart does not exists');

    1085. 

  1085.             $this->layout = 'ticketdetail';

    1086. 

  1086.             return;

    1087. 

  1087.         }

    1088. 

  1088. 

    1089. 

  1089.         $cart_id=$_POST['cart_id'];

    1090. 

  1090.         $eventId=$_POST['ticket_id'];

    1091. 

  1091. 

    1092. 

  1092.         $ticket = $this->Ticket->findById($eventId);

    1093. 

  1093.         if(!$ticket) {

    1094. 

  1094.             $this->set('msgerror','Event does not exists');

    1095. 

  1095.             $this->layout = 'ticketdetail';

    1096. 

  1096.             return;

    1097. 

  1097.         }

    1098. 

  1098. 

    1099. 

  1099.         $cart = $this->Ticket_carts->findById($cart_id);

    1100. 

  1100.         if(!$cart) {

    1101. 

  1101.             $this->set('msgerror','Cart does not exists');

    1102. 

  1102.             $this->layout = 'ticketdetail';

    1103. 

  1103.             return;

    1104. 

  1104.         }

    1105. 

  1105. 

    1106. 

  1106.         foreach($_POST['holder_name'] as $key=>$value) {

    1107. 

  1107.             $sql = "UPDATE ticket_seat_booked SET holder_name='".addslashes($value)."' WHERE id='".$key."'";

    1108. 

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

    1109. 

  1109.         }

    1110. 

  1110. 

    1111. 

  1111.         //get number seat

    1112. 

  1112.         $sql = "SELECT SUM(qty) as num_seat FROM ticket_cart_details WHERE cart_id='".$cart_id."'";

    1113. 

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

    1114. 

  1114.         $row = mysql_fetch_array($result);

    1115. 

  1115.         $num_seat = $row['num_seat'];

    1116. 

  1116. 

    1117. 

  1117.         $ticketTitle = $ticket['Ticket']['ticevent_name'];

    1118. 

  1118. 

    1119. 

  1119.         $sellerId = $ticket['Ticket']['user_id'];

    1120. 

  1120.         $receiverId = $sellerId;//for seller, admin receive XOFee

    1121. 

  1121.         $totalAmt = $cart['Ticket_carts']['total_price'];

    1122. 

  1122.         $shipping = $cart['Ticket_carts']['ship'];

    1123. 

  1123.         $saletax = 0;

    1124. 

  1124.         $amountPay = number_format($totalAmt+$shipping,2);

    1125. 

  1125.         $paypal_fee = number_format($amountPay*0.029 + 0.3,2);

    1126. 

  1126.         if($paypal_fee>=$amountPay){

    1127. 

  1127.             $paypal_fee = $amountPay;

    1128. 

  1128.             $transaction_fee = 0;

    1129. 

  1129.         }else{

    1130. 

  1130.             $transaction_fee = number_format($amountPay*0.02 + 0.75*$num_seat,2);

    1131. 

  1131.             if($transaction_fee>($amountPay-$paypal_fee)){

    1132. 

  1132.                 $transaction_fee = number_format($amountPay-$paypal_fee,2);

    1133. 

  1133.             }            

    1134. 

  1134.         }

    1135. 

  1135. 

    1136. 

  1136.         $commission = number_format($amountPay - $paypal_fee - $transaction_fee,2);

    1137. 

  1137. 

    1138. 

  1138.         //$paymentMethods=$this->getPaymentMethods($receiverId);

    1139. 

  1139.         

    1140. 

  1140.         mysql_query("DELETE FROM transaction_ticket WHERE user_id='".$_SESSION['UserId']."' AND pflag='0' ");

    1141. 

  1141.         mysql_query("INSERT INTO

    1142. 

  1142. 				transaction_ticket(user_id,event_id,total_amount,date,photo_id)

    1143. 

  1143. 				VALUES('".$_SESSION['UserId']."','".$eventId."','".$amountPay."','".date("Y-m-d H:i:s")."','".$sellerId."')");

    1144. 

  1144.         $tranTicketId=0;

    1145. 

  1145.         $tranTicketId=mysql_insert_id();

    1146. 

  1146.         $invoice= $this->createTransactionNumber("TTUU");

    1147. 

  1147.         $qty = 1;

    1148. 

  1148. 

    1149. 

  1149.         $itemName = "Ticket purchase - ".$ticketTitle;

    1150. 

  1150.         $description = "Ticket purchase - ".$ticketTitle;

    1151. 

  1151. 

    1152. 

  1152.         //$returnUrl = FULL_BASE_URL.$this->webroot."tickets/myorderhistory";

    1153. 

  1153.         //$notifyUrl = $this->webroot."tickets/ticketpayment_notify";

    1154. 

  1154.         $cancelUrl = FULL_BASE_URL.$this->webroot."tickets/index";

    1155. 

  1155.         $custom = base64_encode($_SESSION['UserId'].'-userid')."^".$eventId."^".$tranTicketId."^".session_id()."^".$qty."^".$eventId."^".$invoice."^".$cart_id;

    1156. 

  1156.         $custom = $tranTicketId."^".$cart_id;

    1157. 

  1157. 

    1158. 

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

    1159. 

  1159.         $fields['business'] = $ticket['Ticket']['paypal_email'];

    1160. 

  1160.         //$fields['return_url'] = $returnUrl;

    1161. 

  1161.         //$fields['notify_url'] = $notifyUrl;

    1162. 

  1162.         $fields['full_base_url'] = FULL_BASE_URL.$this->webroot;

    1163. 

  1163.         $fields['webroot'] = $this->webroot;

    1164. 

  1164.         $fields['cancel_url'] = $cancelUrl;

    1165. 

  1165.         $fields['custom'] = $custom;

    1166. 

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

    1167. 

  1167.         $fields['amount'] = $amountPay;

    1168. 

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

    1169. 

  1169. 

    1170. 

  1170.         $fields['section_id'] = 2;//for ticket

    1171. 

  1171.         $fields['type_id'] = 1;//pay normal

    1172. 

  1172.         $fields['invoice'] = $invoice;

    1173. 

  1173.         $fields['user_id'] = $_SESSION['UserId'];

    1174. 

  1174.         $fields['receiver_id'] = $receiverId;

    1175. 

  1175.         $fields['seller_id'] = $sellerId;

    1176. 

  1176. 

    1177. 

  1177.         $fields['saletax'] = $saletax;

    1178. 

  1178.         $fields['shipping'] = $shipping;

    1179. 

  1179.         $fields['paypal_fee'] = $paypal_fee;

    1180. 

  1180.         $fields['transaction_fee'] = $transaction_fee;

    1181. 

  1181.         $fields['commission'] = $commission;

    1182. 

  1182.         $fields['description'] = $description;

    1183. 

  1183.         $fields['key'] = md5(PAYMENT_KEY.$fields['user_id']);

    1184. 

  1184.         $fields['is_shipping'] = 0;

    1185. 

  1185. 

    1186. 

  1186.         //card information

    1187. 

  1187.         /*$fields['paymentType'] = 'Sale';

    1188. 

  1188.         $fields['firstName'] = $_POST['billing_fname'];

    1189. 

  1189.         $fields['lastName'] = $_POST['billing_lname'];

    1190. 

  1190.         $fields['address'] = $_POST['billing_address'];

    1191. 

  1191.         $fields['city'] = $_POST['billing_city'];

    1192. 

  1192.         $fields['state'] = $_POST['billing_state'];

    1193. 

  1193.         $fields['zip'] = $_POST['billing_zip'];

    1194. 

  1194.         $fields['phone'] = $_POST['billing_phone'];

    1195. 

  1195.         $fields['creditCardType'] = $_POST['card_type'];

    1196. 

  1196.         $fields['creditCardNumber'] = $_POST['ccnumber'];

    1197. 

  1197.         $fields['expDateMonth'] = $_POST['cardmon'];

    1198. 

  1198.         $fields['expDateYear'] = $_POST['cardyear'];

    1199. 

  1199.         $fields['cvv2Number'] = $_POST['cvvnumber'];

    1200. 

  1200.         $fields['billing_country'] = $_POST['billing_country'];

    1201. 

  1201.         */

    1202. 

  1202.         $this->set("payment_url",PAYMENT_DIRECT_URL);

    1203. 

  1203.         $this->set('fields',$fields);

    1204. 

  1204.     }

    1205. 

  1205. 

    1206. 

  1206.     function payment_notify($strvalid=null,$payment_ts_id=null,$custom=null) {

    1207. 

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

    1208. 

  1208.         if($strvalid==null || $payment_ts_id==null || $custom==null || $strvalid!=md5('checknotify'.$payment_ts_id)) {

    1209. 

  1209.             return;

    1210. 

  1210.         }

    1211. 

  1211. 

    1212. 

  1212.         $ptc = $this->PaymentTransaction->findById($payment_ts_id);

    1213. 

  1213.         if(!$ptc) {

    1214. 

  1214.             $content=" - ticketpayment_notify:payment_ts_id not exists.  payment_ts_id:$payment_ts_id; custom:$custom \r\n";

    1215. 

  1215.             $this->log_content($content);

    1216. 

  1216.             return;

    1217. 

  1217.         }

    1218. 

  1218. 

    1219. 

  1219.         $custom = base64_decode($custom);

    1220. 

  1220.         $custom=explode("^",$custom);

    1221. 

  1221.         $transactionId=$custom['0'];

    1222. 

  1222.         $cart_id = $custom['1'];

    1223. 

  1223. 

    1224. 

  1224.         $sql = "SELECT * FROM transaction_ticket WHERE id='".$transactionId."'";

    1225. 

  1225.         $result = mysql_query($sql);

    1226. 

  1226.         

    1227. 

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

    1228. 

  1228.             $eventId = $row['event_id'];

    1229. 

  1229.         }else{

    1230. 

  1230.             $content=" - ticketpayment_notify:tranTicketId not exists. transactionId:$transactionId; custom:$custom \r\n";

    1231. 

  1231.             $this->log_content($content);

    1232. 

  1232.             return;

    1233. 

  1233.         }

    1234. 

  1234.         

    1235. 

  1235.         $ticket = $this->Ticket->findById($eventId);

    1236. 

  1236.         if(!$ticket) {

    1237. 

  1237.             $content = " - ticketpayment_notify:ticket not exists. event_id:".$eventId."; custom:$custom \r\n";

    1238. 

  1238.             $this->log_content($content);

    1239. 

  1239.             return;

    1240. 

  1240.         }

    1241. 

  1241. 

    1242. 

  1242.         if($ptc['PaymentTransaction']['pay_status']>1) {

    1243. 

  1243.             $this->delete_cart($ptc['PaymentTransaction']['user_id'],$cart_id);

    1244. 

  1244.             $this->sendFailureMail($payment_ts_id);

    1245. 

  1245.             return;

    1246. 

  1246.         }

    1247. 

  1247. 

    1248. 

  1248.         //________________________________________________XOIMAGE DATABASE UPDATION SECTION

    1249. 

  1249.         $tickets = $this->Ticket_carts->findById($cart_id);

    1250. 

  1250.         if(!$tickets){

    1251. 

  1251.             $content = "ticketpayment_notify: cart does not exist $cart_id \r\n";

    1252. 

  1252.             $this->log_content($content);

    1253. 

  1253.             return;

    1254. 

  1254.         }

    1255. 

  1255. 

    1256. 

  1256.         $sql = "SELECT * FROM ticket_carts WHERE id='".$cart_id."' AND ( ADDTIME( tran_time, '0:30:0') >=  NOW() ) ";

    1257. 

  1257.         $result = mysql_query($sql) or die($sql);

    1258. 

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

    1259. 

  1259. 

    1260. 

  1260.         }else {

    1261. 

  1261.             $this->log_content("ticketpayment_notify: check remainingTicket");

    1262. 

  1262.             if(!$this->remainingTicket($cart_id)){

    1263. 

  1263.                

    1264. 

  1264.                 $ptc['PaymentTransaction']['pay_status']=9;

    1265. 

  1265.                 $sql = "UPDATE payment_transactions SET pay_status=9 WHERE id=".$ptc['PaymentTransaction']['id'];

    1266. 

  1266.                 mysql_query($sql);

    1267. 

  1267.                 

    1268. 

  1268.                 $this->delete_cart($ptc['PaymentTransaction']['user_id'],$cart_id);

    1269. 

  1269.                 $this->sendFailureMail($ptc['PaymentTransaction']['id']);

    1270. 

  1270. 

    1271. 

  1271.                 $content = "ticketpayment_notify: time execute payment large 15 minute. payment_ts_id:$payment_ts_id; \r\n";

    1272. 

  1272.                 $this->log_content($content);

    1273. 

  1273.                 return;

    1274. 

  1274.             }

    1275. 

  1275.         }        

    1276. 

  1276. 

    1277. 

  1277.         $totalPay = $ptc['PaymentTransaction']['total_amount'];

    1278. 

  1278.         $UserId= $ptc['PaymentTransaction']['user_id'];

    1279. 

  1279.         $invoice = $ptc['PaymentTransaction']['invoice'];        

    1280. 

  1280. 

    1281. 

  1281.         mysql_query("UPDATE transaction_ticket SET pflag='1',invoice='".$invoice."', payment_ts_id='".$payment_ts_id."' WHERE id='".$transactionId."' AND pflag='0'");

    1282. 

  1282.         mysql_query("UPDATE ticket_carts SET pay_status='1',transaction_id='".$transactionId."' WHERE id='".$cart_id."' ");

    1283. 

  1283. 

    1284. 

  1284.         //____________________________________________________TRANSACTION LOG MANAGEMENT_____________________________________

    1285. 

  1285.         $ticketDetails=$this->getTicketDetails($eventId);

    1286. 

  1286.         $userDetails=$this->getUserDetails($UserId);

    1287. 

  1287. 

    1288. 

  1288.         ############## User Name & Location ######

    1289. 

  1289.         $this->set('UserInfo',$userDetails);

    1290. 

  1290.         $countrysql = mysql_query("Select country_name from countries where id=".$userDetails['c_id']."");

    1291. 

  1291.         $countrysql_arr = mysql_fetch_array($countrysql);

    1292. 

  1292.         $this->set('Countryname', $countrysql_arr['country_name']);

    1293. 

  1293. 

    1294. 

  1294.         $countrysql = mysql_query("Select Name from state where id=".$userDetails['state']."");

    1295. 

  1295.         $countrysql_arr = mysql_fetch_array($countrysql);

    1296. 

  1296.         $this->set('Statename', $countrysql_arr['Name']);

    1297. 

  1297. 

    1298. 

  1298.         $cityname = '';

    1299. 

  1299.         if($userDetails['city']!='') {

    1300. 

  1300.             $countrysql = mysql_query("Select city_name from city_master where city_id=".$userDetails['city']."");

    1301. 

  1301.             $countrysql_arr = mysql_fetch_array($countrysql);

    1302. 

  1302.             $cityname = $countrysql_arr['city_name'];

    1303. 

  1303.         }

    1304. 

  1304.         $this->set('Cityname',$cityname);

    1305. 

  1305.         /**/

    1306. 

  1306.         ############## User Location ######

    1307. 

  1307. 

    1308. 

  1308.         $ownerId=$ticketDetails['user_id'];

    1309. 

  1309. 

    1310. 

  1310.         $queryXouserTransactions=mysql_query("SELECT * FROM xouser_transactions WHERE transaction_head='ticket' AND transaction_title='purchase' AND invoice_id='".$transactionId."'");

    1311. 

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

    1312. 

  1312.             $transactionDesc="Ticket purchase details";

    1313. 

  1313.             $transactionHead="ticket";

    1314. 

  1314.             $transactionTitle="purchase";

    1315. 

  1315.             $invoiceId=$transactionId;

    1316. 

  1316.             $commissionType='Ticket Commission';

    1317. 

  1317. 

    1318. 

  1318.             $statusoffee="nontransactionfee";

    1319. 

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

    1320. 

  1320. 

    1321. 

  1321.             $this->transactionDetail($UserId,$totalPay,'-1',$lastInsertId,$ownerId,$statusoffee,0,'finished');	//charged//this code is changed on 5th January 2010(statusoffee is added)

    1322. 

  1322. 

    1323. 

  1323.             $fetchAdminPaymentConfig=$this->getConfigAmount($commissionType);

    1324. 

  1324.             $comissionValue=($totalPay*$fetchAdminPaymentConfig['config_value'])/100;

    1325. 

  1325. 

    1326. 

  1326.             $statusoffee="transactionfee";

    1327. 

  1327.             $this->transactionDetail($ownerId,$comissionValue,'-1',$lastInsertId,'1',$statusoffee,0,'pending');//this code is changed on 5th January 2010(statusfee added as well as paymentstatus value 'pending' added---pending is not in used now.)

    1328. 

  1328. 

    1329. 

  1329.             //____________________________________________________MAIL MANAGEMENT________________________________________________

    1330. 

  1330. 

    1331. 

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

    1332. 

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

    1333. 

  1333. 

    1334. 

  1334.             $subject="Ticket purchase - ".$invoice;

    1335. 

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

    1336. 

  1336. 

    1337. 

  1337.             $this->set('uid',$UserId);

    1338. 

  1338.             $this->generateInvoice($transactionId,$UserId);

    1339. 

  1339.             $this->Sendmail->layout='blank';

    1340. 

  1340.             $this->Sendmail->view='mail_generateticket';

    1341. 

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

    1342. 

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

    1343. 

  1343. 

    1344. 

  1344.             $this->Sendmail->Body($messageBody);

    1345. 

  1345.             $this->Sendmail->Priority(1) ;

    1346. 

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

    1347. 

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

    1348. 

  1348.                 $this->Sendmail->Send();

    1349. 

  1349.             }

    1350. 

  1350. 

    1351. 

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

    1352. 

  1352.             $sender=$ownerId;

    1353. 

  1353.             $receiver=$UserId;

    1354. 

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

    1355. 

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

    1356. 

  1356.         }

    1357. 

  1357.     }

    1358. 

  1358. 

    1359. 

  1359.     function login_again($UserId) {

    1360. 

  1360.         $someone = $this->User->findById($UserId);

    1361. 

  1361.         if($someone) {

    1362. 

  1362.             if($someone['User']['user_status']==1) {

    1363. 

  1363.                 $this->Session->write('User', $someone['User']['username']);

    1364. 

  1364.                 $this->Session->write('UserId', $someone['User']['id']);

    1365. 

  1365.                 $this->Session->write('GrpId', $someone['User']['user_group_master_id']);

    1366. 

  1366.                 $userdetail = $this->getUserDetails($someone['User']['id']);

    1367. 

  1367.                 if(!isset($_SESSION['PrjUserCityId'])) $this->Session->write('PrjUserCityId', $userdetail['city']);

    1368. 

  1368.                 if(!isset($_SESSION['PrjUserStateId'])) $this->Session->write('PrjUserStateId', $userdetail['state']);

    1369. 

  1369.                 if(!isset($_SESSION['PrjUserCountryId'])) $this->Session->write('PrjUserCountryId', $userdetail['c_id']);

    1370. 

  1370. 

    1371. 

  1371.                 unset($_SESSION['PrjUserCityName']);

    1372. 

  1372.                 unset($_SESSION['PrjUserStateName']);

    1373. 

  1373.                 unset($_SESSION['PrjUserCountryName']);

    1374. 

  1374.                 unset($_SESSION['PrjUserLocation']);

    1375. 

  1375. 

    1376. 

  1376.                 if($someone['User']['user_group_master_id']==2) {

    1377. 

  1377.                     $_SESSION['pubSchool']='p';

    1378. 

  1378.                     $_SESSION['is_public']=1;

    1379. 

  1379.                     $_SESSION['categoryTab']=2;

    1380. 

  1380.                 }

    1381. 

  1381. 

    1382. 

  1382.                 if($someone['User']['user_group_master_id']==3) {

    1383. 

  1383.                     $_SESSION['pubSchool']='s';

    1384. 

  1384.                     $_SESSION['is_public']=2;

    1385. 

  1385.                     $_SESSION['categoryTab']=3;

    1386. 

  1386.                 }

    1387. 

  1387.             }

    1388. 

  1388.         }

    1389. 

  1389.     }

    1390. 

  1390. 

    1391. 

  1391.     function ticketitemdetail($UserId,$transactionId) {

    1392. 

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

    1393. 

  1393.         if($UserId!=null)

    1394. 

  1394.             $UserId = base64_decode($UserId);

    1395. 

  1395.         else

    1396. 

  1396.             $UserId = $_SESSION['UserId'];

    1397. 

  1397.         if($transactionId==null || $UserId==null)

    1398. 

  1398.             die('Sorry item cart detail does not exists');

    1399. 

  1399.         $transactionId = base64_decode($transactionId);

    1400. 

  1400.         $this->generateInvoice($transactionId,$UserId);

    1401. 

  1401.     }

    1402. 

  1402. 

    1403. 

  1403.     function sendFailureMail($ptc_id) {

    1404. 

  1404.         $this->log_content("sendFailureMail: PaymentTransaction id: $ptc_id");

    1405. 

  1405.         if($ptc_id==null) return;

    1406. 

  1406.         $sql = "SELECT * FROM payment_transactions WHERE id=".$ptc_id;

    1407. 

  1407.         $result = mysql_query($sql);

    1408. 

  1408.         if(!$ptc=mysql_fetch_array($result)){

    1409. 

  1409.             $this->log_content("sendFailureMail: PaymentTransaction id: $ptc_id does not exist");

    1410. 

  1410.             return;

    1411. 

  1411.         }

    1412. 

  1412.         

    1413. 

  1413.         $UserId = $ptc['user_id'];

    1414. 

  1414.         $invoice = $ptc['invoice'];

    1415. 

  1415.         $userDetails=$this->getUserDetails($UserId);

    1416. 

  1416. 

    1417. 

  1417.         $subject = '';

    1418. 

  1418.         switch($ptc['pay_status']) {

    1419. 

  1419.             case 2: $subject = 'Ticket purchase - Transaction chargeback'  ;

    1420. 

  1420.                 $mess = "Invoice: ".$invoice ." <br/><br/>Transaction is a chargeback";

    1421. 

  1421.                 break;

    1422. 

  1422.             case 3: $subject = 'Ticket purchase - Transaction reversed'  ;

    1423. 

  1423.                 $mess = "Invoice: ".$invoice ." <br/><br/> Transaction was reversed by PayPal administrators";

    1424. 

  1424.                 break;

    1425. 

  1425.             case 4: $subject = 'Ticket purchase - Transaction refunded'  ;

    1426. 

  1426.                 $mess = "Invoice: ".$invoice ." <br/><br/> Transaction was partially or fully refunded";

    1427. 

  1427.                 break;

    1428. 

  1428.             case 9: $subject = 'Ticket purchase - Transaction timeout'  ;

    1429. 

  1429.                 $mess = "Invoice: ".$invoice ." <br/><br/>You did not make the payment in specified time period".

    1430. 

  1430.                         "<br/><br/>You suppose to make your payment within <strong>15 MINUTES</strong>. Please make a fresh purchase and make the payment within time.

    1431. 

  1431.                          <br/><br/>Seller will refund money for you.";

    1432. 

  1432.                 break;

    1433. 

  1433.         }

    1434. 

  1434.        

    1435. 

  1435.         $sellerDetails=$this->getUserDetails($ptc['seller_id']);

    1436. 

  1436. 

    1437. 

  1437.         if(isset($userDetails['email']) && $subject!='') {

    1438. 

  1438.             $this->set('userDetails',$userDetails);

    1439. 

  1439.             $this->set('mess',$mess);

    1440. 

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

    1441. 

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

    1442. 

  1442. 

    1443. 

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

    1444. 

  1444.             

    1445. 

  1445.             if(isset($sellerDetails['email']) && $sellerDetails['email']!=''){

    1446. 

  1446.                 $this->Sendmail->Cc($sellerDetails['email']);

    1447. 

  1447.             }

    1448. 

  1448. 

    1449. 

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

    1450. 

  1450.            

    1451. 

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

    1452. 

  1452.             $this->Sendmail->view='mail_ticketfailure';

    1453. 

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

    1454. 

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

    1455. 

  1455. 

    1456. 

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

    1457. 

  1457.             $this->Sendmail->Priority(1) ;

    1458. 

  1458.             $this->Sendmail->Send();

    1459. 

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

    1460. 

  1460. 

    1461. 

  1461.             $sender=1;

    1462. 

  1462.             $receiver=$UserId;

    1463. 

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

    1464. 

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

    1465. 

  1465.         }

    1466. 

  1466.     }

    1467. 

  1467. 

    1468. 

  1468.     function getMaxTransaction($photoId) {

    1469. 

  1469.         $q1=mysql_query("SELECT MAX(id) FROM transaction_ticket WHERE photo_id='".$photoId."'") or die("Error on line no ".__LINE__.mysql_error());

    1470. 

  1470.         $rw=mysql_fetch_array($q1);

    1471. 

  1471.         $maxId=$rw['0']+1;

    1472. 

  1472.         return $maxId;

    1473. 

  1473.     }

    1474. 

  1474. 

    1475. 

  1475.     function generateInvoice($tranId,$UserId) {

    1476. 

  1476. 

    1477. 

  1477.         ###########To find invoice only ################

    1478. 

  1478.         $tofind_invoice = mysql_query("select invoice from transaction_ticket where id='".$tranId."' AND pflag='1'");

    1479. 

  1479.         $tofind_invoice_result = mysql_fetch_array($tofind_invoice);

    1480. 

  1480. 

    1481. 

  1481.         if(!empty($tofind_invoice_result)) {

    1482. 

  1482.             $this->set("invoice_value",$tofind_invoice_result['invoice']);

    1483. 

  1483.         } else {

    1484. 

  1484.             $this->set("invoice_value",'');

    1485. 

  1485.         }

    1486. 

  1486. 

    1487. 

  1487. 

    1488. 

  1488.         ##########end of finding invoice only ###############

    1489. 

  1489. 

    1490. 

  1490. 

    1491. 

  1491.         $ticketqry =  "SELECT tranTic.id, tranTic.invoice , tranTic.total_amount , tranTic.date as saledate ,

    1492. 

  1492.                         IF(PM.billing_fname='' AND PM.billing_lname='',CONCAT(BUYusrdetail.first_name ,' ',BUYusrdetail.last_name),CONCAT(PM.billing_fname ,' ',PM.billing_lname)) as Buyername ,

    1493. 

  1493. 			IF(PM.billing_address='',BUYusrdetail.address,PM.billing_address) as Buyeraddress ,IF(PM.billing_city='',BUYCity.city_name,PM.billing_city) as Buyercity , IF(PM.billing_state='',BUYstate.Name,PM.billing_state) as Buyerstatename , 

    1494. 

  1494.                         IF(PM.billing_country='',BUYcountry.country_name,PM.billing_country) as BUYercountryname ,IF(PM.billing_zip='',BUYusrdetail.zip,PM.billing_zip) as Buyerzip , IF(PM.billing_phone='',BUYusrdetail.mobile_phone,PM.billing_phone) as Buyerphone ,

    1495. 

  1495. 							

    1496. 

  1496. 			TicOrg.performer_name as Postname ,TicOrg.performer_email as Postemail,TicOrg.performer_phone as Postphonenumber,

    1497. 

  1497. 			TicOrg.performer_address as Postaddress ,Orgcity.city_name as Postcity , Orgstate.Name as Poststatename , Orgcountry.country_name as Postcountryname , TicOrg.performer_zip as Postzip ,

    1498. 

  1498. 							

    1499. 

  1499. 			Tic.ticevent_name as Eventname , Tic.ticevent_startdate as EventDate ,Tic.ticevent_enddate as EventEndDate ,Tic.ticket_dooropen as EventDoorOpen , Tic.ticevent_terms as EventTerms,Tic.seating_type as EventType, Tic.id as EventId,Tic.ticevent_desc as EventDetail,

    1500. 

  1500. 			Ticvenue.venue_name as Venuename , Ticvenue.venue_address as Venueaddress , Venuecity.city_name as VenueCity , Venuestate.Name as Venuestate , Venuecountry.country_name as Venuecountry , Ticvenue.venue_zip as Venuezip ,Ticvenue.venue_phone as Venuephone,

    1501. 

  1501. 							

    1502. 

  1502. 			Ticcart.saletax as saletax , Ticcart.ship as Shipping ,Ticcart.total_price as TicketTotal,Ticcart.tran_time,Ticcart.id as cart_id,

    1503. 

  1503.                         tranTic.total_amount as Totalamount , POSTBYusrdetail.company_logo as logo,

    1504. 

  1504.                         CONCAT(PM.billing_fname, ', ', PM.billing_lname) as cardName, PM.card_type, PM.ccnumber

    1505. 

  1505. 							

    1506. 

  1506. 			FROM transaction_ticket tranTic

    1507. 

  1507.                         RIGHT JOIN payment_transactions as PM ON tranTic.payment_ts_id = PM.id

    1508. 

  1508. 							

    1509. 

  1509. 			LEFT JOIN user_details BUYusrdetail ON tranTic.user_id = BUYusrdetail.user_id

    1510. 

  1510.                         LEFT JOIN state BUYstate ON BUYstate.id = BUYusrdetail.state

    1511. 

  1511.                         LEFT JOIN city_master BUYCity ON BUYCity.city_id = BUYusrdetail.city

    1512. 

  1512. 			LEFT JOIN countries BUYcountry ON BUYcountry.id=BUYusrdetail.c_id 

    1513. 

  1513. 						

    1514. 

  1514. 			LEFT JOIN tickets Tic On tranTic.event_id=Tic.id

    1515. 

  1515.                         

    1516. 

  1516. 			LEFT JOIN user_details POSTBYusrdetail ON tranTic.photo_id = POSTBYusrdetail.user_id

    1517. 

  1517. 							

    1518. 

  1518. 			LEFT JOIN ticket_event_venue Ticvenue ON Tic.ticket_venue_section_id = 	Ticvenue.id

    1519. 

  1519. 			LEFT JOIN city_master Venuecity ON Venuecity.city_id  = Ticvenue.venue_city_id

    1520. 

  1520. 			LEFT JOIN state Venuestate ON Venuestate.id = Ticvenue.venue_state_id

    1521. 

  1521. 			LEFT JOIN countries Venuecountry ON Venuecountry.id=Ticvenue.venue_country_id

    1522. 

  1522. 

    1523. 

  1523.                         LEFT JOIN ticket_event_performer TicOrg ON Tic.ticket_event_performer_id = TicOrg.id

    1524. 

  1524. 			LEFT JOIN city_master Orgcity ON Orgcity.city_id  = TicOrg.performer_city

    1525. 

  1525. 			LEFT JOIN state  Orgstate ON Orgstate.id = TicOrg.performer_state

    1526. 

  1526. 			LEFT JOIN countries Orgcountry ON Orgcountry.id=TicOrg.performer_country

    1527. 

  1527. 							

    1528. 

  1528. 			LEFT JOIN ticket_carts Ticcart ON Ticcart.transaction_id = tranTic.id

    1529. 

  1529. 							

    1530. 

  1530. 			WHERE tranTic.id='".$tranId."' AND tranTic.pflag='1' AND Ticcart.transaction_id!=0 AND (Ticcart.user_id='".$UserId."' || tranTic.photo_id='".(isset($_SESSION['UserId'])? $_SESSION['UserId']:0)."')

    1531. 

  1531. 			GROUP BY Ticcart.transaction_id

    1532. 

  1532.                         ORDER BY Ticcart.tran_time ASC	";

    1533. 

  1533. 

    1534. 

  1534. 

    1535. 

  1535.         $qry=mysql_query($ticketqry) or die("Error on line :".__LINE__.mysql_error());

    1536. 

  1536.         $this->set("q1",$qry);

    1537. 

  1537. 

    1538. 

  1538.     }

    1539. 

  1539. 

    1540. 

  1540.     function generateticket($tranId='',$userId=null) {

    1541. 

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

    1542. 

  1542.         $this->ticketCategory();

    1543. 

  1543. 

    1544. 

  1544.         $tranId=base64_decode($tranId);

    1545. 

  1545.         if($userId==null) $userId = isset($_SESSION['UserId']) ? $_SESSION['UserId'] : 0;

    1546. 

  1546. 

    1547. 

  1547.         $this->generateInvoice($tranId,$userId);

    1548. 

  1548.         $this->render('generateticket');

    1549. 

  1549.     }

    1550. 

  1550. 

    1551. 

  1551.     function eventDetails($eventId) {

    1552. 

  1552.         $previewsql =  "

    1553. 

  1553. 				SELECT tic.*, ticcat.cat_name , ticvenue.id ticVanueId,ticvenue.venue_name , 

    1554. 

  1554. 				ticship.order_name ,ticvenue.venue_address ,S.Name,C.city_name,CN.country_name , tic.is_public,  tic.password_private,

    1555. 

  1555.                                 tic.user_id,

    1556. 

  1556. 				CONCAT_WS(', ',ticvenue.venue_address ,S.Name,C.city_name,CN.country_name) as placeofevent,

    1557. 

  1557.                                 P.performer_name, P.perfomer_desc, P.performer_phone, P.performer_email

    1558. 

  1558. 				FROM tickets tic 

    1559. 

  1559. 				LEFT JOIN ticket_event_category ticcat ON tic.ticket_category_id=ticcat.id 

    1560. 

  1560. 				LEFT JOIN ticket_event_venue ticvenue ON tic.ticket_venue_section_id = ticvenue.id

    1561. 

  1561. 				LEFT JOIN state S ON(ticvenue.venue_state_id=S.id)

    1562. 

  1562. 				LEFT JOIN city_master C ON(ticvenue.venue_city_id=C.city_id)

    1563. 

  1563. 				LEFT JOIN countries CN ON(ticvenue.venue_country_id=CN.id)

    1564. 

  1564. 				LEFT JOIN ticket_ship_master ticship ON tic.ticket_ship_master_id = ticship.id

    1565. 

  1565.                                 LEFT JOIN ticket_event_performer P ON P.id=tic.ticket_event_performer_id

    1566. 

  1566. 				WHERE tic.id='".$eventId."'";

    1567. 

  1567. 

    1568. 

  1568.         $previewsql_res = mysql_query($previewsql) or die(mysql_error());

    1569. 

  1569.         $previewsql_arr = mysql_fetch_assoc($previewsql_res);

    1570. 

  1570.         

    1571. 

  1571.         $this->set("previewEvent",$previewsql_arr);

    1572. 

  1572.         //check children

    1573. 

  1573.         $sql = "SELECT id,ticevent_startdate,ticevent_enddate,ticket_dooropen FROM tickets WHERE id='".$eventId."' OR parent_id='".$eventId."'

    1574. 

  1574.                        AND is_temp='0' AND (NOW() < ticevent_enddate) ORDER BY ticevent_startdate";

    1575. 

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

    1576. 

  1576.         $datetimes = array();

    1577. 

  1577.         if(mysql_num_rows($result)>1){            

    1578. 

  1578.             while($row=mysql_fetch_array($result)){//Start date: 07/28/2011 at 10:00 AM, End date: 07/28/2011 at 10:00 AM, Door open: 01:00 AM

    1579. 

  1579.                 $startdate = strtotime($row['ticevent_startdate']);

    1580. 

  1580.                 $enddate = strtotime($row['ticevent_enddate']);

    1581. 

  1581.                 $datetime['datetime'] = "Start date: ".date("m/d/Y",$startdate)." at ".date("h:i A",$startdate).", End date: ".date("m/d/Y",$enddate)." at ".date("h:i A",$enddate).", Door open: ".date("h:i A",strtotime($row['ticket_dooropen']));

    1582. 

  1582.                 $datetime['id'] = $row['id'];

    1583. 

  1583.                 $datetimes[] = $datetime;

    1584. 

  1584.             }

    1585. 

  1585.             $this->set('datetimes',$datetimes);

    1586. 

  1586.             $this->set('current_event_id',$datetimes[0]['id']);

    1587. 

  1587.         }else{

    1588. 

  1588.             $this->set('current_event_id',$eventId);

    1589. 

  1589.         }

    1590. 

  1590.         

    1591. 

  1591.         return $previewsql_arr;

    1592. 

  1592.     }

    1593. 

  1593. 

    1594. 

  1594.     function getPhoto($eventId) {

    1595. 

  1595.         $q1="

    1596. 

  1596. 				SELECT T.user_id,U.* 

    1597. 

  1597. 				FROM tickets T

    1598. 

  1598. 				LEFT JOIN user_details U ON(T.user_id=U.user_id)

    1599. 

  1599. 				WHERE T.id='".$eventId."'";

    1600. 

  1600.         $query=mysql_query($q1) or die(mysql_error());

    1601. 

  1601.         $rw=mysql_fetch_assoc($query);

    1602. 

  1602.         return $rw;

    1603. 

  1603.     }

    1604. 

  1604. 

    1605. 

  1605.     function getSaleTax($eventId,$amount) {

    1606. 

  1606.         $userDetail=$this->getPhoto($eventId);

    1607. 

  1607.         $qry="SELECT tax FROM venue_saletax WHERE user_id='".$userDetail['user_id']."' AND state_id='".$userDetail['state']."'";

    1608. 

  1608.         $rwQry=mysql_fetch_array(mysql_query($qry));

    1609. 

  1609.         $sale_tax_cal = round((($amount * $rwQry['0'])/100),2) ;

    1610. 

  1610. 

    1611. 

  1611.         $this->set('SaletaxVal',$rwQry['0']);

    1612. 

  1612.         return $sale_tax_cal;

    1613. 

  1613.     }

    1614. 

  1614. 

    1615. 

  1615.     function getShipping($eventId,$amount) {

    1616. 

  1616.         $q1=mysql_query("

    1617. 

  1617. 				SELECT ship_postage

    1618. 

  1618. 				FROM tickets T,ticket_shipping_list TS

    1619. 

  1619. 				WHERE T.ticket_ship_master_id=TS.ticket_ship_master_id AND T.id='".$eventId."' AND $amount BETWEEN ship_price_from AND ship_price_to

    1620. 

  1620.                 ");

    1621. 

  1621. 

    1622. 

  1622.         $rw=mysql_fetch_array($q1);

    1623. 

  1623.         return $rw['0'];

    1624. 

  1624. 

    1625. 

  1625.     }

    1626. 

  1626. 

    1627. 

  1627.     function eventdetail($catid=null,$eventid=null) {        

    1628. 

  1628.         $eventid=base64_decode($eventid);

    1629. 

  1629.         $catid=base64_decode($catid);

    1630. 

  1630.         //get seats

    1631. 

  1631.         $seatsql = "SELECT *  FROM tickets_product  WHERE tickets_id ='".$eventid."'";

    1632. 

  1632.         $this->set('seats',mysql_query($seatsql));

    1633. 

  1633. 

    1634. 

  1634.         //DELETING THE UNPROCESSED TRANSACRTION FROM THE CART TABLE.

    1635. 

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

    1636. 

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

    1637. 

  1637.             $sql = "SELECT * FROM ticket_carts WHERE user_id='".$_SESSION['UserId']."' AND pay_status='0'";

    1638. 

  1638. 

    1639. 

  1639.             $result = mysql_query($sql);

    1640. 

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

    1641. 

  1641.                 //delete cart

    1642. 

  1642.                 mysql_query("DELETE FROM ticket_cart_details WHERE cart_id='".$row['id']."'") or die(mysql_error());

    1643. 

  1643.                 mysql_query("DELETE FROM ticket_seat_booked WHERE cart_id='".$row['id']."'") or die(mysql_error());

    1644. 

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

    1645. 

  1645.             }

    1646. 

  1646.         }

    1647. 

  1647. 

    1648. 

  1648.         $this->set("arg",$this->params);

    1649. 

  1649.         $this->layout = 'ticketdetail';        

    1650. 

  1650.         $this->ticketCategory();

    1651. 

  1651.         $this->pageTitle = 'Event Detail';

    1652. 

  1652. 

    1653. 

  1653.         $this->set('eventid',$eventid);

    1654. 

  1654.         $this->set("eventcat",$catid);

    1655. 

  1655.         $this->set("catid",$catid);   

    1656. 

  1656. 

    1657. 

  1657.         $ticketDetails=$this->eventDetails($eventid);        

    1658. 

  1658.     }

    1659. 

  1659. 

    1660. 

  1660.     function showmap() {

    1661. 

  1661.         $this->layout = 'event_blank';

    1662. 

  1662.         //$this->set('googleApiKey','ABQIAAAAZbvN0mJPDCn9zfVqOJrFGhTjCjhcgT5sBu_1-Crz1kMdzbs1gBQjnvJPAqera0uOmds8G6C0LV5Wuw');

    1663. 

  1663.     }

    1664. 

  1664. 

    1665. 

  1665.     function eventmap() {

    1666. 

  1666.         $this->layout = 'event_blank';

    1667. 

  1667.         /// FILESERVER : ABQIAAAAZbvN0mJPDCn9zfVqOJrFGhQqm1mUMRM_Eo-m6ZX5YqB39V6w7hQS_94m3yT8PemODFLrYSVQpkfUEA

    1668. 

  1668.         /// SERVER  : ABQIAAAAZbvN0mJPDCn9zfVqOJrFGhS-KiuPEQq0GrsMtFXPPlF7KwuyUBRpW6kaA7dJUSQY4su7jZCr_d3HlA

    1669. 

  1669.         //"http://localhost:"ABQIAAAAO4MUzap1ASh6GqP2LdADShT2yXp_ZAY8_ufC3CFXhHIE1NvwkxT038xw4xtipfZlYhqCG0f-N6pKSA

    1670. 

  1670. 

    1671. 

  1671.         $this->set('googleApiKey','ABQIAAAAO4MUzap1ASh6GqP2LdADShRKkXVcGXJeyJTZqOmXgYJHqb1yUxS1El0TvwuXVENbp-P69kXSuRojvA');

    1672. 

  1672. 

    1673. 

  1673.         if(isset($this->params['url']['subDomain'])!='' && $this->params['url']['subDomain']='mpac') {

    1674. 

  1674.             $this->set('googleApiKey',"ABQIAAAAO4MUzap1ASh6GqP2LdADShTktV2mukEYRnKiHRV5vkDtXer92BQefSfBw_iiWVpAeeFTq8GkfEs3qw");

    1675. 

  1675.         }

    1676. 

  1676.     }

    1677. 

  1677. 

    1678. 

  1678.     function eventphoto() {

    1679. 

  1679.         $this->layout = 'event_blank';

    1680. 

  1680.         $this->set('googleApiKey','ABQIAAAAZbvN0mJPDCn9zfVqOJrFGhQqm1mUMRM_Eo-m6ZX5YqB39V6w7hQS_94m3yT8PemODFLrYSVQpkfUEA');

    1681. 

  1681.     }

    1682. 

  1682. 

    1683. 

  1683.     function manageevent() {

    1684. 

  1684.         $this->checkSession();

    1685. 

  1685.         $this->layout = 'ticketcategoryinner';

    1686. 

  1686.         $this->ticketCategory();

    1687. 

  1687.         $this->pageTitle = 'Manage Event';

    1688. 

  1688.         $this->ticketCategory();

    1689. 

  1689. 

    1690. 

  1690.         $eventsql = "SELECT xoe.id,xoe.ticket_category_id,xoe.ticevent_name,xoe.ticevent_startdate as eventstartdate, xoe.ticevent_enddate as eventenddate,

    1691. 

  1691.                             (xoe.is_temp='0') as is_published

    1692. 

  1692.                          FROM tickets  xoe

    1693. 

  1693.                          LEFT JOIN ticket_event_category xocat ON(xoe.ticket_category_id  = xocat.id)

    1694. 

  1694. 			 WHERE xoe.user_id = ".$_SESSION['UserId']." AND xoe.parent_id=0";

    1695. 

  1695. 

    1696. 

  1696.         if(isset($_REQUEST['hidsrch']) && $_REQUEST['hidsrch']!="") {

    1697. 

  1697. 

    1698. 

  1698.             if(isset($_REQUEST['evtsrctxt']) && $_REQUEST['evtsrctxt']!="Event Title")

    1699. 

  1699.                 $eventsql .= " and xoe.ticevent_name like '%".$_REQUEST['evtsrctxt']."%'" ;

    1700. 

  1700. 

    1701. 

  1701.             if(isset($_REQUEST['sdatefrom']) && $_REQUEST['sdatefrom']!="mm/dd/YY")

    1702. 

  1702.                 $eventsql .= " and xoe.ticevent_startdate  >= '".date('Y-m-d',strtotime($_REQUEST['sdatefrom']))." 0:0:0' ";

    1703. 

  1703.             if(isset($_REQUEST['sdateto']) && $_REQUEST['sdateto']!="mm/dd/YY")

    1704. 

  1704.                 $eventsql .= " and xoe.ticevent_startdate  <= '".date('Y-m-d',strtotime($_REQUEST['sdateto']))." 23:59:59' ";

    1705. 

  1705.         }

    1706. 

  1706. 

    1707. 

  1707.         $eventsql .=" ORDER BY xoe.ticevent_startdate DESC";

    1708. 

  1708. 

    1709. 

  1709. 

    1710. 

  1710.         $eventsql_res = mysql_query($eventsql) or die(mysql_error());

    1711. 

  1711.         $eventnum = mysql_num_rows($eventsql_res) ;

    1712. 

  1712.         if(($eventnum*40)<520) {

    1713. 

  1713.             $divheight = ($eventnum*40) ;

    1714. 

  1714.         }

    1715. 

  1715.         else {

    1716. 

  1716.             $divheight = ($eventnum*40)+20;

    1717. 

  1717.         }

    1718. 

  1718. 

    1719. 

  1719.         $this->set('eventsql_res',$eventsql_res);

    1720. 

  1720.         $this->set('divheight',$divheight);

    1721. 

  1721.         $this->set('eventnum',$eventnum);

    1722. 

  1722.     }

    1723. 

  1723. 

    1724. 

  1724.     function viewevent($eventid=null) {

    1725. 

  1725.         $this->checkSession();

    1726. 

  1726.         $this->layout = 'ticketcategoryinner';

    1727. 

  1727.         $this->ticketCategory();

    1728. 

  1728.         $this->pageTitle = 'View Event';

    1729. 

  1729.         $this->set('eventid',base64_decode($eventid));

    1730. 

  1730.         $this->eventDetails(base64_decode($eventid));

    1731. 

  1731.     }

    1732. 

  1732. 

    1733. 

  1733.     function delevent($eventid=null) {

    1734. 

  1734.         /*  DELETE FROM TICKET TABLE*/

    1735. 

  1735.         $this->checkSession();

    1736. 

  1736.         $eventid = base64_decode($eventid);

    1737. 

  1737. 

    1738. 

  1738.         $ticsql = "DELETE FROM tickets WHERE (id='".$eventid."' OR parent_id='".$eventid."') AND user_id='".$_SESSION['UserId']."'";

    1739. 

  1739.         $ticsql_res = mysql_query($ticsql);

    1740. 

  1740. 

    1741. 

  1741.         $nextstepurl = 'tickets/manageevent'  ;

    1742. 

  1742.         $this->redirect($nextstepurl);

    1743. 

  1743.     }

    1744. 

  1744. 

    1745. 

  1745.     function ticketsales($ticeventid=null) {

    1746. 

  1746.         $this->checkSession();

    1747. 

  1747.         $this->layout = 'ticketcategoryinner';

    1748. 

  1748.         $this->pageTitle = 'Ticket Event Sales';

    1749. 

  1749.         $this->set("display","none");

    1750. 

  1750.         $this->set("custOpen","Open");

    1751. 

  1751.         $this->set("textMonth","month");

    1752. 

  1752.         $this->set("textDay","day");

    1753. 

  1753.         $this->set("textYear","year");

    1754. 

  1754.         $this->set("textMonth2","month");

    1755. 

  1755.         $this->set("textDay2","day");

    1756. 

  1756.         $this->set("textYear2","year");

    1757. 

  1757. 

    1758. 

  1758.         $this->set("textMonth_2","month");

    1759. 

  1759.         $this->set("textDay_2","day");

    1760. 

  1760.         $this->set("textYear_2","year");

    1761. 

  1761.         $this->set("textMonth2_2","month");

    1762. 

  1762.         $this->set("textDay2_2","day");

    1763. 

  1763.         $this->set("textYear2_2","year");

    1764. 

  1764. 

    1765. 

  1765. 

    1766. 

  1766.         $this->set("past",0);

    1767. 

  1767.         $this->set("eventName",0);

    1768. 

  1768.         $this->set("invoice",0);

    1769. 

  1769.         $this->set("userId",0);

    1770. 

  1770.         $this->set("fDate",0);

    1771. 

  1771.         $this->set("tDate",0);

    1772. 

  1772.         $this->set("dateErr");

    1773. 

  1773. 

    1774. 

  1774.         if(isset($this->data['Ticket']['eventname']) && ($this->data['Ticket']['eventname'])!="") {

    1775. 

  1775.             $this->set("display","block");

    1776. 

  1776.             $eventName=$this->data['Ticket']['eventname'];

    1777. 

  1777.             $this->data['Ticket']['within']="";

    1778. 

  1778.         }

    1779. 

  1779. 

    1780. 

  1780.         if(isset($this->data['Ticket']['invoice']) && ($this->data['Ticket']['invoice'])!="") {

    1781. 

  1781.             $this->set("display","block");

    1782. 

  1782.             $invoice=$this->data['Ticket']['invoice'];

    1783. 

  1783.             $this->data['Ticket']['within']="";

    1784. 

  1784.         }

    1785. 

  1785. 

    1786. 

  1786.         if(isset($this->data['Ticket']['userid']) && ($this->data['Ticket']['userid'])!="") {

    1787. 

  1787.             $this->set("display","block");

    1788. 

  1788.             $userId=$this->data['Ticket']['userid'];

    1789. 

  1789.             $this->data['Ticket']['within']="";

    1790. 

  1790.         }

    1791. 

  1791. 

    1792. 

  1792.         if(isset($this->data['Ticket']['fyear']) && isset($this->data['Ticket']['fmonth']) && isset($this->data['Ticket']['fday'])) {

    1793. 

  1793.             $fromDate=$this->data['Ticket']['fyear']."-".$this->data['Ticket']['fmonth']."-".$this->data['Ticket']['fday'];

    1794. 

  1794.             $len=strlen($fromDate);

    1795. 

  1795.             if($len==10) {

    1796. 

  1796.                 $this->set("textMonth",$this->data['Ticket']['fmonth']);

    1797. 

  1797.                 $this->set("textDay",$this->data['Ticket']['fday']);

    1798. 

  1798.                 $this->set("textYear",$this->data['Ticket']['fyear']);

    1799. 

  1799. 

    1800. 

  1800.                 $this->set("display","block");

    1801. 

  1801.                 $this->data['Ticket']['within']="";

    1802. 

  1802.                 $dateF=date("Y-m-d",strtotime($this->data['Ticket']['fyear']."-".$this->data['Ticket']['fmonth']."-".$this->data['Ticket']['fday']));

    1803. 

  1803.                 $fDate=$dateF;

    1804. 

  1804.             }

    1805. 

  1805.             else if(($this->data['Ticket']['fyear'])!="year" && ($this->data['Ticket']['fmonth'])!="month" && ($this->data['Ticket']['fday'])!="day") {

    1806. 

  1806.                 $this->set("dateErr","Date format should be : mm/dd/yyyy");

    1807. 

  1807.             }

    1808. 

  1808.         }

    1809. 

  1809. 

    1810. 

  1810.         if(isset($this->data['Ticket']['tyear']) && isset($this->data['Ticket']['tmonth']) && isset($this->data['Ticket']['tday'])) {

    1811. 

  1811.             $toDate=$this->data['Ticket']['tyear']."-".$this->data['Ticket']['tmonth']."-".$this->data['Ticket']['tday'];

    1812. 

  1812.             $len=strlen($toDate);

    1813. 

  1813.             if($len==10) {

    1814. 

  1814.                 $this->set("textMonth2",$this->data['Ticket']['tmonth']);

    1815. 

  1815.                 $this->set("textDay2",$this->data['Ticket']['tday']);

    1816. 

  1816.                 $this->set("textYear2",$this->data['Ticket']['tyear']);

    1817. 

  1817.                 $this->set("display","block");

    1818. 

  1818.                 $this->data['Ticket']['within']="";

    1819. 

  1819.                 $dateT=date("Y-m-d",strtotime($this->data['Ticket']['tyear']."-".$this->data['Ticket']['tmonth']."-".$this->data['Ticket']['tday']));

    1820. 

  1820.                 $tDate=$dateT;

    1821. 

  1821.             }

    1822. 

  1822.             else

    1823. 

  1823.             if(($this->data['Ticket']['tyear'])!="year" && ($this->data['Ticket']['tmonth'])!="month" && ($this->data['Ticket']['tday'])!="day") {

    1824. 

  1824.                 $this->set("dateErr","Date format should be : mm/dd/yyyy");

    1825. 

  1825.             }

    1826. 

  1826.         }

    1827. 

  1827. 

    1828. 

  1828. 

    1829. 

  1829.         if(isset($this->data['Ticket']['radio'])) {

    1830. 

  1830.             $radio = $this->data['Ticket']['radio'];

    1831. 

  1831.             if($radio==1) {

    1832. 

  1832.                 if(isset($this->data['Ticket']['within'])) {

    1833. 

  1833.                     $withinType=$this->data['Ticket']['within'];

    1834. 

  1834.                     $week=date("Y-m-d G:i:s",mktime(date("G"),date("i"),date("s"),date("m"),(date("d")-7),date("Y")));

    1835. 

  1835.                     $month=date("Y-m-d G:i:s",mktime(date("G"),date("i"),date("s"),(date("m")-1),date("d"),date("Y")));

    1836. 

  1836.                     $year=date("Y-m-d G:i:s",mktime(date("G"),date("i"),date("s"),date("m"),date("d"),(date("Y")-1)));

    1837. 

  1837.                     $date=date("Y-m-d G:i:s");

    1838. 

  1838. 

    1839. 

  1839.                     if($withinType=="past") {

    1840. 

  1840.                         $curDate= $date;

    1841. 

  1841.                     }

    1842. 

  1842. 

    1843. 

  1843.                     if($withinType=="week") {

    1844. 

  1844.                         $past=$week;

    1845. 

  1845.                         $curDate=$date;

    1846. 

  1846.                     }

    1847. 

  1847. 

    1848. 

  1848.                     if($withinType=="month") {

    1849. 

  1849.                         $past=$month;

    1850. 

  1850.                         $curDate=$date;

    1851. 

  1851.                     }

    1852. 

  1852. 

    1853. 

  1853.                     if($withinType=="year") {

    1854. 

  1854.                         $past=$year;

    1855. 

  1855.                         $curDate=$date;

    1856. 

  1856.                     }

    1857. 

  1857.                 }

    1858. 

  1858.             }

    1859. 

  1859. 

    1860. 

  1860.             if($radio==2) {

    1861. 

  1861.                 $past='';

    1862. 

  1862.                 $curDate='';

    1863. 

  1863.                 $fromDate=$this->data['Ticket']['fyear_2']."-".$this->data['Ticket']['fmonth_2']."-".$this->data['Ticket']['fday_2'];

    1864. 

  1864.                 $len=strlen($fromDate);

    1865. 

  1865.                 if($len==10) {

    1866. 

  1866.                     $this->set("textMonth_2",$this->data['Ticket']['fmonth_2']);

    1867. 

  1867.                     $this->set("textDay_2",$this->data['Ticket']['fday_2']);

    1868. 

  1868.                     $this->set("textYear_2",$this->data['Ticket']['fyear_2']);

    1869. 

  1869. 

    1870. 

  1870.                     //$this->set("display","block");

    1871. 

  1871.                     $this->data['Ticket']['within']="";

    1872. 

  1872.                     $dateF=date("Y-m-d",strtotime($this->data['Ticket']['fyear_2']."-".$this->data['Ticket']['fmonth_2']."-".$this->data['Ticket']['fday_2']));

    1873. 

  1873.                     $past=$dateF;

    1874. 

  1874.                 }

    1875. 

  1875.                 else {

    1876. 

  1876.                     $this->set("dateErr","Date format should be : mm/dd/yyyy");

    1877. 

  1877.                 }

    1878. 

  1878. 

    1879. 

  1879.                 $toDate=$this->data['Ticket']['tyear_2']."-".$this->data['Ticket']['tmonth_2']."-".$this->data['Ticket']['tday_2'];

    1880. 

  1880.                 $len=strlen($toDate);

    1881. 

  1881.                 if($len==10) {

    1882. 

  1882.                     $this->set("textMonth2_2",$this->data['Ticket']['tmonth_2']);

    1883. 

  1883.                     $this->set("textDay2_2",$this->data['Ticket']['tday_2']);

    1884. 

  1884.                     $this->set("textYear2_2",$this->data['Ticket']['tyear_2']);

    1885. 

  1885.                     //$this->set("display","block");

    1886. 

  1886.                     $this->data['Ticket']['within']="";

    1887. 

  1887.                     $dateT=date("Y-m-d",strtotime($this->data['Ticket']['tyear_2']."-".$this->data['Ticket']['tmonth_2']."-".$this->data['Ticket']['tday_2']));

    1888. 

  1888.                     $curDate=$dateT;

    1889. 

  1889.                 }

    1890. 

  1890.                 else {

    1891. 

  1891.                     $this->set("dateErr","Date format should be : mm/dd/yyyy");

    1892. 

  1892.                 }

    1893. 

  1893.             }

    1894. 

  1894.         }

    1895. 

  1895. 

    1896. 

  1896. 

    1897. 

  1897. 

    1898. 

  1898.         if(isset($_REQUEST['ticeventid']))      $ticeventid = $_REQUEST['ticeventid'];

    1899. 

  1899.         if(isset($_REQUEST['radio']))           $radio = $_REQUEST['radio'];

    1900. 

  1900.         if(isset($_REQUEST['withinType']))      $withinType = $_REQUEST['withinType'];

    1901. 

  1901.         if(isset($_REQUEST['curDate']))         $curDate = $_REQUEST['curDate'];

    1902. 

  1902.         if(isset($_REQUEST['past']))            $past = $_REQUEST['past'];

    1903. 

  1903.         if(isset($_REQUEST['eventName']))       $eventName = $_REQUEST['eventName'];

    1904. 

  1904.         if(isset($_REQUEST['invoice']))         $invoice = $_REQUEST['invoice'];

    1905. 

  1905.         if(isset($_REQUEST['userId']))          $userId = $_REQUEST['userId'];

    1906. 

  1906.         if(isset($_REQUEST['fDate']))           $fDate = $_REQUEST['fDate'];

    1907. 

  1907.         if(isset($_REQUEST['tDate']))           $tDate = $_REQUEST['tDate'];

    1908. 

  1908. 

    1909. 

  1909.         $select="SELECT XT.id tranId,XT.total_amount,XT.invoice,XT.date,XU.id userId,XU.username AS userName, CONCAT_WS(', ',XUDetail.first_name,XUDetail.last_name) as fullname,

    1910. 

  1910.                     XC.tickets_id,XC.ship,XC.saletax,XC.total_price AS basic, (XC.total_price*0.029+0.3) as paypal_fee, (XC.total_price*0.02+0.99) as transaction_fee,

    1911. 

  1911.                     T.id as eventId, T.ticket_category_id, T.ticevent_name ";

    1912. 

  1912.         $from= ' FROM transaction_ticket XT

    1913. 

  1913.                 RIGHT JOIN ticket_carts XC ON(XT.id=XC.transaction_id)

    1914. 

  1914.                 LEFT JOIN tickets T ON (T.id=XC.tickets_id)

    1915. 

  1915.                 LEFT JOIN users XU ON ( XT.user_id = XU.id )

    1916. 

  1916.                 LEFT JOIN user_details XUDetail ON ( XUDetail.user_id = XU.id )

    1917. 

  1917.                 ';

    1918. 

  1918. 

    1919. 

  1919.         $where=" WHERE XT.photo_id='".$_SESSION['UserId']."' AND XT.pflag='1' ";

    1920. 

  1920. 

    1921. 

  1921.         $PassParameter = '';

    1922. 

  1922.         if($ticeventid && $ticeventid!=0) {

    1923. 

  1923.             $where.=" AND XC.tickets_id='".$ticeventid."'";

    1924. 

  1924.             $PassParameter .= "&ticeventid=".$ticeventid;

    1925. 

  1925.         }

    1926. 

  1926. 

    1927. 

  1927.         if(isset($radio)) {

    1928. 

  1928.             $PassParameter .= "&radio=".$radio;

    1929. 

  1929.             if(isset($withinType)) $PassParameter .= "&withinType=".$withinType;

    1930. 

  1930.             if(isset($past)) $PassParameter .= "&past=".$past;

    1931. 

  1931.             if(isset($curDate)) $PassParameter .= "&curDate=".$curDate;

    1932. 

  1932. 

    1933. 

  1933.             if(isset($withinType) && $withinType=="past")

    1934. 

  1934.                 $where.=" AND XT.date <'".$curDate."'";

    1935. 

  1935.             else

    1936. 

  1936.                 $where.=" AND XT.date BETWEEN '".$past."' AND '".$curDate."'";

    1937. 

  1937.         }

    1938. 

  1938. 

    1939. 

  1939.         if(isset($eventName) && $eventName!='') {

    1940. 

  1940.             $where.=" AND T.ticevent_name LIKE '%".$eventName."%'";

    1941. 

  1941.             $PassParameter .= "&eventName=".$eventName;

    1942. 

  1942.         }

    1943. 

  1943. 

    1944. 

  1944.         if(isset($invoice) && $invoice!='') {

    1945. 

  1945.             $where.=" AND XT.invoice LIKE '%".$invoice."%'";

    1946. 

  1946.             $PassParameter .= "&invoice=".$invoice;

    1947. 

  1947.         }

    1948. 

  1948. 

    1949. 

  1949.         if(isset($userId) && $userId!='') {

    1950. 

  1950.             $where.=" AND XU.username LIKE '%".$userId."%'";

    1951. 

  1951.             $PassParameter .= "&userId=".$userId;

    1952. 

  1952.         }

    1953. 

  1953. 

    1954. 

  1954.         if(isset($fDate) && $fDate!='' && isset($tDate) && $tDate!='') {

    1955. 

  1955.             $where.=" AND XT.date BETWEEN '".$fDate."' AND '".$tDate."'";

    1956. 

  1956.             $PassParameter .= "&fDate=".$fDate."&tDate=".$tDate;

    1957. 

  1957.         }

    1958. 

  1958. 

    1959. 

  1959.         $others=" GROUP BY XT.id ORDER BY XC.tran_time DESC";

    1960. 

  1960. 

    1961. 

  1961.         $CountField="XT.id";

    1962. 

  1962.         $this->set("controller","tickets");

    1963. 

  1963.         $this->set("action","ticketsales");

    1964. 

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

    1965. 

  1965. 

    1966. 

  1966.         $this->set('elementsUpdate',array('backdroplist','pagegin'));

    1967. 

  1967. 

    1968. 

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

    1969. 

  1969.         $this->ticketCategory();

    1970. 

  1970.         if(isset($this->params['url']['Page']) ) {

    1971. 

  1971.             $this->render("ticketsales_ajax","ajax");

    1972. 

  1972.         }

    1973. 

  1973.         $this->set('sql',$where);

    1974. 

  1974.     }

    1975. 

  1975. 

    1976. 

  1976.     function myorderhistory($uid=null,$keyuserId=null) {

    1977. 

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

    1978. 

  1978.         $this->layout = 'ticketcategoryinner';

    1979. 

  1979.         $this->pageTitle = 'Ticket Event Order History';

    1980. 

  1980.         $this->ticketCategory();

    1981. 

  1981.         $ticeventid=null;

    1982. 

  1982. 

    1983. 

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

    1984. 

  1984.             if(isset($_POST['uid']) && isset($_POST['key']) && $_POST['key']==md5('checklogin')) {

    1985. 

  1985.                 $uid = base64_decode($_POST['uid']);

    1986. 

  1986.                 $this->login_again($uid);

    1987. 

  1987.             }else if($keyuserId && $uid ) {

    1988. 

  1988.                 $uid = base64_decode($uid);

    1989. 

  1989.                 if(md5('checklogin'.$uid)==$keyuserId) {

    1990. 

  1990.                     $this->login_again($uid);

    1991. 

  1991.                 }

    1992. 

  1992.             }

    1993. 

  1993.         }

    1994. 

  1994. 

    1995. 

  1995. 

    1996. 

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

    1997. 

  1997.             return;

    1998. 

  1998.         }

    1999. 

  1999. 

    2000. 

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

    2001. 

  2001.             $sql = "SELECT * FROM ticket_carts WHERE user_id='".$_SESSION['UserId']."' AND pay_status='0'";

    2002. 

  2002. 

    2003. 

  2003.             $result = mysql_query($sql);

    2004. 

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

    2005. 

  2005.                 //delete cart

    2006. 

  2006.                 mysql_query("DELETE FROM ticket_cart_details WHERE cart_id='".$row['id']."'") or die(mysql_error());

    2007. 

  2007.                 mysql_query("DELETE FROM ticket_seat_booked WHERE cart_id='".$row['id']."'") or die(mysql_error());

    2008. 

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

    2009. 

  2009.             }

    2010. 

  2010.         }

    2011. 

  2011. 

    2012. 

  2012.         $this->set("display","none");

    2013. 

  2013.         $this->set("custOpen","Open");

    2014. 

  2014.         $this->set("textMonth","month");

    2015. 

  2015.         $this->set("textDay","day");

    2016. 

  2016.         $this->set("textYear","year");

    2017. 

  2017.         $this->set("textMonth2","month");

    2018. 

  2018.         $this->set("textDay2","day");

    2019. 

  2019.         $this->set("textYear2","year");

    2020. 

  2020. 

    2021. 

  2021.         $this->set("textMonth_2","month");

    2022. 

  2022.         $this->set("textDay_2","day");

    2023. 

  2023.         $this->set("textYear_2","year");

    2024. 

  2024.         $this->set("textMonth2_2","month");

    2025. 

  2025.         $this->set("textDay2_2","day");

    2026. 

  2026.         $this->set("textYear2_2","year");

    2027. 

  2027. 

    2028. 

  2028. 

    2029. 

  2029.         $this->set("past",0);

    2030. 

  2030.         $this->set("eventName",0);

    2031. 

  2031.         $this->set("invoice",0);

    2032. 

  2032.         $this->set("userId",0);

    2033. 

  2033.         $this->set("fDate",0);

    2034. 

  2034.         $this->set("tDate",0);

    2035. 

  2035.         $this->set("dateErr");

    2036. 

  2036. 

    2037. 

  2037.         if(isset($this->data['Ticket']['eventname']) && ($this->data['Ticket']['eventname'])!="") {

    2038. 

  2038.             $this->set("display","block");

    2039. 

  2039.             $eventName=$this->data['Ticket']['eventname'];

    2040. 

  2040.             $this->data['Ticket']['within']="";

    2041. 

  2041.         }

    2042. 

  2042. 

    2043. 

  2043.         if(isset($this->data['Ticket']['invoice']) && ($this->data['Ticket']['invoice'])!="") {

    2044. 

  2044.             $this->set("display","block");

    2045. 

  2045.             $invoice=$this->data['Ticket']['invoice'];

    2046. 

  2046.             $this->data['Ticket']['within']="";

    2047. 

  2047.         }

    2048. 

  2048. 

    2049. 

  2049.         if(isset($this->data['Ticket']['userid']) && ($this->data['Ticket']['userid'])!="") {

    2050. 

  2050.             $this->set("display","block");

    2051. 

  2051.             $userId=$this->data['Ticket']['userid'];

    2052. 

  2052.             $this->data['Ticket']['within']="";

    2053. 

  2053.         }

    2054. 

  2054. 

    2055. 

  2055.         if(isset($this->data['Ticket']['fyear']) && isset($this->data['Ticket']['fmonth']) && isset($this->data['Ticket']['fday'])) {

    2056. 

  2056.             $fromDate=$this->data['Ticket']['fyear']."-".$this->data['Ticket']['fmonth']."-".$this->data['Ticket']['fday'];

    2057. 

  2057.             $len=strlen($fromDate);

    2058. 

  2058.             if($len==10) {

    2059. 

  2059.                 $this->set("textMonth",$this->data['Ticket']['fmonth']);

    2060. 

  2060.                 $this->set("textDay",$this->data['Ticket']['fday']);

    2061. 

  2061.                 $this->set("textYear",$this->data['Ticket']['fyear']);

    2062. 

  2062. 

    2063. 

  2063.                 $this->set("display","block");

    2064. 

  2064.                 $this->data['Ticket']['within']="";

    2065. 

  2065.                 $dateF=date("Y-m-d",strtotime($this->data['Ticket']['fyear']."-".$this->data['Ticket']['fmonth']."-".$this->data['Ticket']['fday']));

    2066. 

  2066.                 $fDate=$dateF;

    2067. 

  2067.             }

    2068. 

  2068.             else if(($this->data['Ticket']['fyear'])!="year" && ($this->data['Ticket']['fmonth'])!="month" && ($this->data['Ticket']['fday'])!="day") {

    2069. 

  2069.                 $this->set("dateErr","Date format should be : mm/dd/yyyy");

    2070. 

  2070.             }

    2071. 

  2071.         }

    2072. 

  2072. 

    2073. 

  2073.         if(isset($this->data['Ticket']['tyear']) && isset($this->data['Ticket']['tmonth']) && isset($this->data['Ticket']['tday'])) {

    2074. 

  2074.             $toDate=$this->data['Ticket']['tyear']."-".$this->data['Ticket']['tmonth']."-".$this->data['Ticket']['tday'];

    2075. 

  2075.             $len=strlen($toDate);

    2076. 

  2076.             if($len==10) {

    2077. 

  2077.                 $this->set("textMonth2",$this->data['Ticket']['tmonth']);

    2078. 

  2078.                 $this->set("textDay2",$this->data['Ticket']['tday']);

    2079. 

  2079.                 $this->set("textYear2",$this->data['Ticket']['tyear']);

    2080. 

  2080.                 $this->set("display","block");

    2081. 

  2081.                 $this->data['Ticket']['within']="";

    2082. 

  2082.                 $dateT=date("Y-m-d",strtotime($this->data['Ticket']['tyear']."-".$this->data['Ticket']['tmonth']."-".$this->data['Ticket']['tday']));

    2083. 

  2083.                 $tDate=$dateT;

    2084. 

  2084.             }

    2085. 

  2085.             else

    2086. 

  2086.             if(($this->data['Ticket']['tyear'])!="year" && ($this->data['Ticket']['tmonth'])!="month" && ($this->data['Ticket']['tday'])!="day") {

    2087. 

  2087.                 $this->set("dateErr","Date format should be : mm/dd/yyyy");

    2088. 

  2088.             }

    2089. 

  2089.         }

    2090. 

  2090. 

    2091. 

  2091. 

    2092. 

  2092.         if(isset($this->data['Ticket']['radio'])) {

    2093. 

  2093.             $radio = $this->data['Ticket']['radio'];

    2094. 

  2094.             if($radio==1) {

    2095. 

  2095.                 if(isset($this->data['Ticket']['within'])) {

    2096. 

  2096.                     $withinType=$this->data['Ticket']['within'];

    2097. 

  2097.                     $week=date("Y-m-d G:i:s",mktime(date("G"),date("i"),date("s"),date("m"),(date("d")-7),date("Y")));

    2098. 

  2098.                     $month=date("Y-m-d G:i:s",mktime(date("G"),date("i"),date("s"),(date("m")-1),date("d"),date("Y")));

    2099. 

  2099.                     $year=date("Y-m-d G:i:s",mktime(date("G"),date("i"),date("s"),date("m"),date("d"),(date("Y")-1)));

    2100. 

  2100.                     $date=date("Y-m-d G:i:s");

    2101. 

  2101. 

    2102. 

  2102.                     if($withinType=="past") {

    2103. 

  2103.                         $curDate= $date;

    2104. 

  2104.                     }

    2105. 

  2105. 

    2106. 

  2106.                     if($withinType=="week") {

    2107. 

  2107.                         $past=$week;

    2108. 

  2108.                         $curDate=$date;

    2109. 

  2109.                     }

    2110. 

  2110. 

    2111. 

  2111.                     if($withinType=="month") {

    2112. 

  2112.                         $past=$month;

    2113. 

  2113.                         $curDate=$date;

    2114. 

  2114.                     }

    2115. 

  2115. 

    2116. 

  2116.                     if($withinType=="year") {

    2117. 

  2117.                         $past=$year;

    2118. 

  2118.                         $curDate=$date;

    2119. 

  2119.                     }

    2120. 

  2120.                 }

    2121. 

  2121.             }

    2122. 

  2122. 

    2123. 

  2123.             if($radio==2) {

    2124. 

  2124.                 $past='';

    2125. 

  2125.                 $curDate='';

    2126. 

  2126.                 $fromDate=$this->data['Ticket']['fyear_2']."-".$this->data['Ticket']['fmonth_2']."-".$this->data['Ticket']['fday_2'];

    2127. 

  2127.                 $len=strlen($fromDate);

    2128. 

  2128.                 if($len==10) {

    2129. 

  2129.                     $this->set("textMonth_2",$this->data['Ticket']['fmonth_2']);

    2130. 

  2130.                     $this->set("textDay_2",$this->data['Ticket']['fday_2']);

    2131. 

  2131.                     $this->set("textYear_2",$this->data['Ticket']['fyear_2']);

    2132. 

  2132. 

    2133. 

  2133.                     //$this->set("display","block");

    2134. 

  2134.                     $this->data['Ticket']['within']="";

    2135. 

  2135.                     $dateF=date("Y-m-d",strtotime($this->data['Ticket']['fyear_2']."-".$this->data['Ticket']['fmonth_2']."-".$this->data['Ticket']['fday_2']));

    2136. 

  2136.                     $past=$dateF;

    2137. 

  2137.                 }

    2138. 

  2138.                 else {

    2139. 

  2139.                     $this->set("dateErr","Date format should be : mm/dd/yyyy");

    2140. 

  2140.                 }

    2141. 

  2141. 

    2142. 

  2142.                 $toDate=$this->data['Ticket']['tyear_2']."-".$this->data['Ticket']['tmonth_2']."-".$this->data['Ticket']['tday_2'];

    2143. 

  2143.                 $len=strlen($toDate);

    2144. 

  2144.                 if($len==10) {

    2145. 

  2145.                     $this->set("textMonth2_2",$this->data['Ticket']['tmonth_2']);

    2146. 

  2146.                     $this->set("textDay2_2",$this->data['Ticket']['tday_2']);

    2147. 

  2147.                     $this->set("textYear2_2",$this->data['Ticket']['tyear_2']);

    2148. 

  2148.                     //$this->set("display","block");

    2149. 

  2149.                     $this->data['Ticket']['within']="";

    2150. 

  2150.                     $dateT=date("Y-m-d",strtotime($this->data['Ticket']['tyear_2']."-".$this->data['Ticket']['tmonth_2']."-".$this->data['Ticket']['tday_2']));

    2151. 

  2151.                     $curDate=$dateT;

    2152. 

  2152.                 }

    2153. 

  2153.                 else {

    2154. 

  2154.                     $this->set("dateErr","Date format should be : mm/dd/yyyy");

    2155. 

  2155.                 }

    2156. 

  2156.             }

    2157. 

  2157.         }

    2158. 

  2158. 

    2159. 

  2159. 

    2160. 

  2160. 

    2161. 

  2161.         if(isset($_REQUEST['ticeventid']))      $ticeventid = $_REQUEST['ticeventid'];

    2162. 

  2162.         if(isset($_REQUEST['radio']))           $radio = $_REQUEST['radio'];

    2163. 

  2163.         if(isset($_REQUEST['withinType']))      $withinType = $_REQUEST['withinType'];

    2164. 

  2164.         if(isset($_REQUEST['curDate']))         $curDate = $_REQUEST['curDate'];

    2165. 

  2165.         if(isset($_REQUEST['past']))            $past = $_REQUEST['past'];

    2166. 

  2166.         if(isset($_REQUEST['eventName']))       $eventName = $_REQUEST['eventName'];

    2167. 

  2167.         if(isset($_REQUEST['invoice']))         $invoice = $_REQUEST['invoice'];

    2168. 

  2168.         if(isset($_REQUEST['userId']))          $userId = $_REQUEST['userId'];

    2169. 

  2169.         if(isset($_REQUEST['fDate']))           $fDate = $_REQUEST['fDate'];

    2170. 

  2170.         if(isset($_REQUEST['tDate']))           $tDate = $_REQUEST['tDate'];

    2171. 

  2171. 

    2172. 

  2172.         $select="SELECT XT.id tranId,XT.total_amount,XT.invoice,XT.date,XU.id userId,XU.username AS userName,CONCAT_WS(', ',XUDetail.first_name,XUDetail.last_name) as fullname,

    2173. 

  2173.                     XC.tickets_id,XC.ship,XC.saletax,XC.total_price AS basic,

    2174. 

  2174.                     T.id as eventId, T.ticket_category_id, T.ticevent_name ";

    2175. 

  2175.         $from= ' FROM transaction_ticket XT

    2176. 

  2176.                 RIGHT JOIN ticket_carts XC ON(XT.id=XC.transaction_id)

    2177. 

  2177.                 LEFT JOIN tickets T ON (T.id=XC.tickets_id)

    2178. 

  2178.                 LEFT JOIN users XU ON ( XT.user_id = XU.id )

    2179. 

  2179.                 LEFT JOIN user_details XUDetail ON ( XUDetail.user_id = XU.id ) ';

    2180. 

  2180.         $where=" WHERE XT.user_id='".$_SESSION['UserId']."' AND XT.pflag='1' ";

    2181. 

  2181. 

    2182. 

  2182.         $PassParameter = '';

    2183. 

  2183.         if($ticeventid && $ticeventid!=0) {

    2184. 

  2184.             $where.=" AND XC.tickets_id='".$ticeventid."'";

    2185. 

  2185.             $PassParameter .= "&ticeventid=".$ticeventid;

    2186. 

  2186.         }

    2187. 

  2187. 

    2188. 

  2188.         if(isset($radio)) {

    2189. 

  2189.             $PassParameter .= "&radio=".$radio;

    2190. 

  2190.             if(isset($withinType)) $PassParameter .= "&withinType=".$withinType;

    2191. 

  2191.             if(isset($past)) $PassParameter .= "&past=".$past;

    2192. 

  2192.             if(isset($curDate)) $PassParameter .= "&curDate=".$curDate;

    2193. 

  2193. 

    2194. 

  2194.             if(isset($withinType) && $withinType=="past")

    2195. 

  2195.                 $where.=" AND XT.date <'".$curDate."'";

    2196. 

  2196.             else

    2197. 

  2197.                 $where.=" AND XT.date BETWEEN '".$past."' AND '".$curDate."'";

    2198. 

  2198.         }

    2199. 

  2199. 

    2200. 

  2200.         if(isset($eventName) && $eventName!='') {

    2201. 

  2201.             $where.=" AND T.ticevent_name LIKE '%".$eventName."%'";

    2202. 

  2202.             $PassParameter .= "&eventName=".$eventName;

    2203. 

  2203.         }

    2204. 

  2204. 

    2205. 

  2205.         if(isset($invoice) && $invoice!='') {

    2206. 

  2206.             $where.=" AND XT.invoice LIKE '%".$invoice."%'";

    2207. 

  2207.             $PassParameter .= "&invoice=".$invoice;

    2208. 

  2208.         }

    2209. 

  2209. 

    2210. 

  2210.         if(isset($userId) && $userId!='') {

    2211. 

  2211.             $where.=" AND XU.username LIKE '%".$userId."%'";

    2212. 

  2212.             $PassParameter .= "&userId=".$userId;

    2213. 

  2213.         }

    2214. 

  2214. 

    2215. 

  2215.         if(isset($fDate) && $fDate!='' && isset($tDate) && $tDate!='') {

    2216. 

  2216.             $where.=" AND XT.date BETWEEN '".$fDate."' AND '".$tDate."'";

    2217. 

  2217.             $PassParameter .= "&fDate=".$fDate."&tDate=".$tDate;

    2218. 

  2218.         }

    2219. 

  2219. 

    2220. 

  2220.         $others=" GROUP BY XT.id ORDER BY XC.tran_time DESC";

    2221. 

  2221. 

    2222. 

  2222.         $CountField="XT.id";

    2223. 

  2223.         $this->set("controller","tickets");

    2224. 

  2224.         $this->set("action","myorderhistory");

    2225. 

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

    2226. 

  2226. 

    2227. 

  2227.         $this->set('elementsUpdate',array('backdroplist','pagegin'));

    2228. 

  2228. 

    2229. 

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

    2230. 

  2230. 

    2231. 

  2231. 

    2232. 

  2232.         if(isset($this->params['url']['Page']) ) {

    2233. 

  2233.             $this->render("myorderhistory2","ajax");

    2234. 

  2234.         }

    2235. 

  2235.     }

    2236. 

  2236. 

    2237. 

  2237.     function exportdata2excel($type) {

    2238. 

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

    2239. 

  2239. 

    2240. 

  2240.         $select="SELECT XT.invoice,XT.date,XU.username AS userName, XC.total_price AS basic, T.ticevent_name,

    2241. 

  2241.                     (XC.total_price*0.029+0.3) as paypal_fee, (XC.total_price*0.02+0.99) as transaction_fee ";

    2242. 

  2242.         $from= " FROM transaction_ticket XT

    2243. 

  2243.                 RIGHT JOIN ticket_carts XC ON(XT.id=XC.transaction_id)

    2244. 

  2244.                 LEFT JOIN tickets T ON (T.id=XC.tickets_id)

    2245. 

  2245.                 LEFT JOIN users XU ON ( XT.user_id = XU.id ) ";

    2246. 

  2246.         $where=" WHERE  XT.pflag='1' ";

    2247. 

  2247. 

    2248. 

  2248.         if($type==1) {//sales

    2249. 

  2249.             $select .= ", CONCAT_WS(', ',BUYusrdetail.first_name,BUYusrdetail.last_name) as fullname,BUYusrdetail.email,BUYusrdetail.address as address,BUYstate.Name as state,BUYCity.city_name as city,BUYcountry.country_name as country , BUYusrdetail.mobile_phone as phone,BUYusrdetail.zip as zip";

    2250. 

  2250.             $from .= "  LEFT JOIN user_details BUYusrdetail ON (BUYusrdetail.user_id=XT.user_id)

    2251. 

  2251.                         LEFT JOIN state BUYstate ON BUYstate.id = BUYusrdetail.state

    2252. 

  2252.                         LEFT JOIN city_master BUYCity ON BUYCity.city_id = BUYusrdetail.city

    2253. 

  2253. 			LEFT JOIN countries BUYcountry ON BUYcountry.id=BUYusrdetail.c_id  ";

    2254. 

  2254.             $where .= " AND XT.photo_id='".$_SESSION['UserId']."' ";

    2255. 

  2255. 

    2256. 

  2256.         }else {//order history

    2257. 

  2257.             $where .= " AND XT.user_id='".$_SESSION['UserId']."' ";

    2258. 

  2258.         }

    2259. 

  2259. 

    2260. 

  2260.         if(isset($_REQUEST['radio'])) {

    2261. 

  2261.             if(isset($_REQUEST['withinType']) && $_REQUEST['withinType']=="past")

    2262. 

  2262.                 $where.=" AND XT.date <'".$_REQUEST['curDate']."'";

    2263. 

  2263.             else

    2264. 

  2264.                 $where.=" AND XT.date BETWEEN '".$_REQUEST['past']."' AND '".$_REQUEST['curDate']."'";

    2265. 

  2265.         }

    2266. 

  2266. 

    2267. 

  2267.         if(isset($_REQUEST['eventName']) && $_REQUEST['eventName']!='') {

    2268. 

  2268.             $where.=" AND T.ticevent_name LIKE '%".$_REQUEST['eventName']."%'";

    2269. 

  2269.         }

    2270. 

  2270. 

    2271. 

  2271.         if(isset($_REQUEST['invoice']) && $_REQUEST['invoice']!='') {

    2272. 

  2272.             $where.=" AND XT.invoice LIKE '%".$_REQUEST['invoice']."%'";

    2273. 

  2273.         }

    2274. 

  2274. 

    2275. 

  2275.         if(isset($_REQUEST['userId']) && $_REQUEST['userId']!='') {

    2276. 

  2276.             $where.=" AND XU.username LIKE '%".$_REQUEST['userId']."%'";

    2277. 

  2277.         }

    2278. 

  2278. 

    2279. 

  2279.         if(isset($_REQUEST['fDate']) && $_REQUEST['fDate']!='' && isset($_REQUEST['tDate']) && $_REQUEST['tDate']!='') {

    2280. 

  2280.             $where.=" AND XT.date BETWEEN '".$_REQUEST['fDate']."' AND '".$_REQUEST['tDate']."'";

    2281. 

  2281.         }

    2282. 

  2282. 

    2283. 

  2283.         $others=" GROUP BY XT.id ORDER BY XT.date DESC";

    2284. 

  2284. 

    2285. 

  2285.         $result = mysql_query($select.$from.$where.$others) or die(mysql_error());

    2286. 

  2286.         $list = array();

    2287. 

  2287.         $total = 0;

    2288. 

  2288.         $totalPaypalFee = 0;

    2289. 

  2289.         $totalTransFee = 0;

    2290. 

  2290. 

    2291. 

  2291.         if($type==1) {

    2292. 

  2292.             $list[] = array('','','','','','','','','','','','','','');

    2293. 

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

    2294. 

  2294.                 $address = $row['address'];

    2295. 

  2295.                 if($row['city']!='') $address .=', <br/>'.$row['city'];

    2296. 

  2296.                 if($row['state']!='') $address .=', '.$row['state'];

    2297. 

  2297.                 if($row['zip']!='' && $row['zip']!='0') $address .=' '.$row['zip'];

    2298. 

  2298.                 if($row['country']!='') $address .='<br/>'.$row['country'];

    2299. 

  2299. 

    2300. 

  2300.                 $list[] = array($row['invoice'],date('m-d-Y h:i A',strtotime($row['date'])),$row['userName'].'/ '.$row['fullname'],$row['email'],$row['phone'],$row['address'],$row['city'],$row['state'],$row['zip'],$row['country'],$row['ticevent_name'],$row['basic'],$row['paypal_fee'],$row['transaction_fee']);

    2301. 

  2301. 

    2302. 

  2302.                 $total+=$row['basic'];

    2303. 

  2303.                 $totalPaypalFee+=$row['paypal_fee'];

    2304. 

  2304.                 $totalTransFee+=$row['transaction_fee'];

    2305. 

  2305.             }

    2306. 

  2306.             $rows = array();

    2307. 

  2307.             $title = 'Result Sales Order Search';

    2308. 

  2308.             $header= 'Invoice No,Date,Username/Full Name,Email,Phone,Address,City,State,Zip,Country,Event Name,Amount($),Paypal Fee($), Transaction Fee($)';

    2309. 

  2309.             $rows[] = array('','','','','','','','','','','','','','');

    2310. 

  2310.             $rows = array_merge($rows, $list);

    2311. 

  2311.             $rows[] = array('','','','','','','','','','','','','','');

    2312. 

  2312.             $rows[] = array('<b>Total</b>','','','','','','','','','','',$total,$totalPaypalFee,$totalTransFee);

    2313. 

  2313.             $this->set('numcols',14);

    2314. 

  2314.         }else {

    2315. 

  2315.             $list[] = array('','','','','');

    2316. 

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

    2317. 

  2317.                 $list[] = array($row['invoice'],date('m-d-Y h:i A',strtotime($row['date'])),$row['userName'],$row['ticevent_name'],$row['basic']);

    2318. 

  2318.                 $total+=$row['basic'];

    2319. 

  2319.             }

    2320. 

  2320. 

    2321. 

  2321.             $rows = array();

    2322. 

  2322. 

    2323. 

  2323.             $title = 'Result Order History Search';

    2324. 

  2324.             $header= 'Invoice No,Date,User Name,Event Name,Amount($)';

    2325. 

  2325.             $rows[] = array('','','','','');

    2326. 

  2326.             $rows = array_merge($rows, $list);

    2327. 

  2327.             $rows[] = array('','','','','');

    2328. 

  2328.             $rows[] = array('<b>Total</b>','','','',$total);

    2329. 

  2329.             $this->set('numcols',5);

    2330. 

  2330.         }

    2331. 

  2331.         $this->set('titlePage',$title);

    2332. 

  2332.         $this->set('rows',$rows);

    2333. 

  2333.         $this->set('header',$header);

    2334. 

  2334.         $this->set('sql',$select.$from.$where.$others);

    2335. 

  2335.     }    

    2336. 

  2336. 

    2337. 

  2337.     public function extension($basename) {

    2338. 

  2338.         $pos=strrpos($basename,".");

    2339. 

  2339.         return substr($basename,$pos);

    2340. 

  2340.     }

    2341. 

  2341. 

    2342. 

  2342.     function downloadfile() {

    2343. 

  2343.         $fileName=$this->params['url']['f'];

    2344. 

  2344.         $basePath='../app/webroot/download/';

    2345. 

  2345.         $this->Download->downloadFile($basePath,$fileName);

    2346. 

  2346.     }

    2347. 

  2347. 

    2348. 

  2348.     function get_location() {

    2349. 

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

    2350. 

  2350. 

    2351. 

  2351.         if($_REQUEST['type']=='state') {

    2352. 

  2352.             $this->set('stateList',$this->getStateList($_REQUEST['country_id']));

    2353. 

  2353.         }

    2354. 

  2354.         if($_REQUEST['type']=='city') {

    2355. 

  2355.             $this->set('cityList',$this->getCityList($_REQUEST['state_id']));

    2356. 

  2356.         }

    2357. 

  2357.     }

    2358. 

  2358.     

    2359. 

  2359.     function get_location_custom() {

    2360. 

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

    2361. 

  2361. 

    2362. 

  2362.         if($_REQUEST['type']=='state') {

    2363. 

  2363.             $this->set('stateList',$this->getStateList($_REQUEST['country_id']));

    2364. 

  2364.             $this->set('stateSelect',$_REQUEST['provinceSelect']);

    2365. 

  2365.             $this->set('citySelect',$_REQUEST['citySelect']);

    2366. 

  2366.         }

    2367. 

  2367.         if($_REQUEST['type']=='city') {

    2368. 

  2368.             $this->set('cityList',$this->getCityList($_REQUEST['state_id']));

    2369. 

  2369.             $this->set('citySelect',$_REQUEST['citySelect']);

    2370. 

  2370.         }

    2371. 

  2371.     }

    2372. 

  2372.     

    2373. 

  2373.     function pagination($select,$from,$where,$others,$CountField,$arg,$PassParameter) {

    2374. 

  2374.         if(isset($arg['Page']))

    2375. 

  2375.             $pageFlag=$arg['Page'];

    2376. 

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

    2377. 

  2377.         $SetUserNumberOfVpsPerPage=SHOW_REC; /* Defined in config->paths.php*/

    2378. 

  2378. 

    2379. 

  2379.         $this->set("BackgroundClass",'pagination');

    2380. 

  2380.         $this->set("SelectedPage",'pagination_over');

    2381. 

  2381.         $this->set("Linkpage",'pagination_over');

    2382. 

  2382.         $this->set("FirstImage",'fdd.gif');

    2383. 

  2383.         $this->set("PreviousImage",'previous.gif');

    2384. 

  2384.         $this->set("NextImage",'next.gif');

    2385. 

  2385.         $this->set("LastImage",'rewd.gif');

    2386. 

  2386. 

    2387. 

  2387.         $UserNumberOfVpsPerPage=SHOW_REC; /* Defined in config->paths.php*/

    2388. 

  2388.         if(!is_numeric($UserNumberOfVpsPerPage)|| (intval($UserNumberOfVpsPerPage)!=$UserNumberOfVpsPerPage)||($UserNumberOfVpsPerPage<=0))

    2389. 

  2389.             $UserNumberOfVpsPerPage = $SetUserNumberOfVpsPerPage;

    2390. 

  2390. 

    2391. 

  2391.         if(!isset($arg['Page'])) $arg['Page']=1;

    2392. 

  2392.         if(!isset($arg['Offset'])) $arg['Offset']=0;

    2393. 

  2393.         $Query_ForNumber_Records=mysql_query("$select $from $where $others") or die('Line no 120' . mysql_error());

    2394. 

  2394.         //$Result_Query_ForNumber_Records=mysql_fetch_object($Query_ForNumber_Records);

    2395. 

  2395. 

    2396. 

  2396.         //$NoOfVps=$Result_Query_ForNumber_Records->NoOfVps;

    2397. 

  2397.         $NoOfVps=mysql_num_rows($Query_ForNumber_Records);

    2398. 

  2398. 

    2399. 

  2399.         $NumberOfVpsPerPage=$UserNumberOfVpsPerPage;

    2400. 

  2400.         $NoOfPages=ceil($NoOfVps/$NumberOfVpsPerPage);	//3

    2401. 

  2401.         if($arg['Offset']==$NoOfVps) {

    2402. 

  2402.             if(isset($Offset)) {

    2403. 

  2403.                 $Offset=$Offset-$NumberOfVpsPerPage;

    2404. 

  2404.                 $Page--;

    2405. 

  2405.                 if($Offset<0) {

    2406. 

  2406.                     $Offset=0;

    2407. 

  2407.                     $Page=1;

    2408. 

  2408.                 }

    2409. 

  2409.             }else {

    2410. 

  2410.                 $Offset=0;

    2411. 

  2411.                 $Page=1;

    2412. 

  2412.             }

    2413. 

  2413.         }

    2414. 

  2414. 

    2415. 

  2415.         $this->set("Page",$arg['Page']);

    2416. 

  2416.         $this->set("Offset",$arg['Offset']);

    2417. 

  2417.         $this->set("NumberOfVpsPerPage",$NumberOfVpsPerPage);

    2418. 

  2418.         $this->set("NoOfPages",$NoOfPages);

    2419. 

  2419.         $this->set("UserNumberOfVpsPerPage",$UserNumberOfVpsPerPage);

    2420. 

  2420. 

    2421. 

  2421.         //print "$select $from $where $others";

    2422. 

  2422.         $this->set("qryOthr","$select $from $where $others");

    2423. 

  2423. 

    2424. 

  2424.         $SelectRecord = mysql_query("$select $from $where $others LIMIT ".$arg['Offset'].",$NumberOfVpsPerPage") or die('Line no '.__LINE__ . mysql_error());

    2425. 

  2425.         $this->set("query",$SelectRecord);

    2426. 

  2426.         return $SelectRecord;

    2427. 

  2427.     }

    2428. 

  2428. 

    2429. 

  2429.     function delete_cart($UserId,$cart_id){//private

    2430. 

  2430.         //delete cart

    2431. 

  2431.         $sql = "SELECT * FROM ticket_carts WHERE user_id='".$UserId."' AND id='".$cart_id."'";

    2432. 

  2432.         $result = mysql_query($sql);

    2433. 

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

    2434. 

  2434.             //delete cart

    2435. 

  2435.             mysql_query("DELETE FROM ticket_cart_details WHERE cart_id='".$row['id']."'") or die(mysql_error());

    2436. 

  2436.             mysql_query("DELETE FROM ticket_seat_booked WHERE cart_id='".$row['id']."'") or die(mysql_error());

    2437. 

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

    2438. 

  2438.             mysql_query("DELETE FROM transaction_ticket WHERE id='".$row['transaction_id']."'") or die(mysql_error());

    2439. 

  2439.         }

    2440. 

  2440.     }

    2441. 

  2441. 

    2442. 

  2442.     function test_sql(){

    2443. 

  2443.         

    2444. 

  2444.     }

    2445. 

  2445. }

    2446. 

  2446. ?>
    2447.