PageRenderTime 40ms CodeModel.GetById 8ms RepoModel.GetById 0ms app.codeStats 0ms

/inc/amfphp/Amfphp/Services/ec_admin_productimporter.php

https://github.com/EmranAhmed/wp-easycart
PHP | 713 lines | 490 code | 105 blank | 118 comment | 114 complexity | 810aa482cc6c78532e72d98e7d8bb4e2 MD5 | raw file
    

  1. <?php
    2. 

  2. /*
    3. 

  3. ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    4. 

  4. ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    5. 

  5. //All Code and Design is copyrighted by Level Four Development, llc
    6. 

  6. //
    7. 

  7. //Level Four Development, LLC provides this code "as is" without warranty of any kind, either express or implied,     
    8. 

  8. //including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.         
    9. 

  9. //
    10. 

  10. //Only licnesed users may use this code and storfront for live purposes. All other use is prohibited and may be 
    11. 

  11. //subject to copyright violation laws. If you have any questions regarding proper use of this code, please
    12. 

  12. //contact Level Four Development, llc and EasyCart prior to use.
    13. 

  13. //
    14. 

  14. //All use of this storefront is subject to our terms of agreement found on Level Four Development, llc's  website.
    15. 

  15. ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    16. 

  16. ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    17. 

  17. */
    18. 

  18. 

  19. 

  20. class ec_admin_productimporter
    21. 

  21. 	{		
    22. 

  22. 	
    23. 

  23. 		function ec_admin_productimporter() {
    24. 

  24. 			/*load our connection settings
    25. 

  25. 			if( file_exists( '../../../../wp-easycart-data/connection/ec_conn.php' ) ) {
    26. 

  26. 				require_once('../../../../wp-easycart-data/connection/ec_conn.php');
    27. 

  27. 			} else {
    28. 

  28. 				require_once('../../../connection/ec_conn.php');
    29. 

  29. 			};*/
    30. 

  30. 		
    31. 

  31. 			//set our connection variables
    32. 

  32. 			$dbhost = DB_HOST;
    33. 

  33. 			$dbname = DB_NAME;
    34. 

  34. 			$dbuser = DB_USER;
    35. 

  35. 			$dbpass = DB_PASSWORD;
    36. 

  36. 			global $wpdb;
    37. 

  37. 			define ('WP_PREFIX', $wpdb->prefix);
    38. 

  38. 			
    39. 

  39. 			require_once( "../../classes/core/ec_db.php" );
    40. 

  40. 			require_once '../administration/excel_reader2.php';
    41. 

  41. 

  42. 		
    43. 

  43. 			//make a connection to our database
    44. 

  44. 			$this->conn = mysql_connect($dbhost, $dbuser, $dbpass);
    45. 

  45. 			mysql_select_db ($dbname);	
    46. 

  46. 			mysql_query("SET CHARACTER SET utf8", $this->conn); 
    47. 

  47. 			mysql_query("SET NAMES 'utf8'", $this->conn); 
    48. 

  48. 

  49. 		}	
    50. 

  50. 			
    51. 

  51. 		//secure all of the services for logged in authenticated users only	
    52. 

  52. 		public function _getMethodRoles($methodName){
    53. 

  53. 		   if ($methodName == 'productimport') return array('admin');
    54. 

  54. 		   else  return null;
    55. 

  55. 		}
    56. 

  56. 		
    57. 

  57. 		//HELPER - used to escape out SQL calls
    58. 

  58. 		function escape($sql) 
    59. 

  59. 		{ 
    60. 

  60. 			  $args = func_get_args(); 
    61. 

  61. 				foreach($args as $key => $val) 
    62. 

  62. 				{ 
    63. 

  63. 					$args[$key] = mysql_real_escape_string($val); 
    64. 

  64. 				} 
    65. 

  65. 				 
    66. 

  66. 				$args[0] = $sql; 
    67. 

  67. 				return call_user_func_array('sprintf', $args); 
    68. 

  68. 		} 
    69. 

  69. 		
    70. 

  70. 			
    71. 

  71. 		public function productimport() {
    72. 

  72. 			
    73. 

  73. 			$excel = new Spreadsheet_Excel_Reader("../administration/productimportfile.xls", false);
    74. 

  74. 			// read spreadsheet data
    75. 

  75. 			$excel->read('../administration/productimportfile.xls'); 
    76. 

  76. 			
    77. 

  77. 

  78. 			if(!mysql_error()) {
    79. 

  79. 				// iterate over spreadsheet rows and columns
    80. 

  80. 				// first check all the data
    81. 

  81. 				$errorfound = false;
    82. 

  82. 				for ($x=2; $x<=$excel->sheets[0]['numRows']; $x++) {
    83. 

  83. 			
    84. 

  84. 					//1 product_id
    85. 

  85. 					
    86. 

  86. 					//2 model_number
    87. 

  87. 					if ($excel->sheets[0]['cells'][$x][2] == '') {
    88. 

  88. 						$errorfound = true;
    89. 

  89. 						return "Error at record ".$x.", all products require a unique model number." ;
    90. 

  90. 					}
    91. 

  91. 					//3 post_id
    92. 

  92. 					
    93. 

  93. 					//4 activate_in_store
    94. 

  94. 						if (!is_numeric($excel->sheets[0]['cells'][$x][4]) || ($excel->sheets[0]['cells'][$x][4] != 0 && $excel->sheets[0]['cells'][$x][4] != 1)) {
    95. 

  95. 							$errorfound = true;
    96. 

  96. 							return "Error at record ".$x.", activate in store must be either 1 - active or 0 - not active" ;
    97. 

  97. 						}
    98. 

  98. 					//5 title
    99. 

  99. 					if ($excel->sheets[0]['cells'][$x][5] == '') {
    100. 

  100. 						$errorfound = true;
    101. 

  101. 						return "Error at record ".$x.", all products require a title." ;
    102. 

  102. 					}
    103. 

  103. 					//6 description
    104. 

  104. 					if ($excel->sheets[0]['cells'][$x][6] == '') {
    105. 

  105. 						$errorfound = true;
    106. 

  106. 						return "Error at record ".$x.", all products require a description." ;
    107. 

  107. 					}
    108. 

  108. 					//7 specifications
    109. 

  109. 					
    110. 

  110. 					//8 price
    111. 

  111. 					if ($excel->sheets[0]['cells'][$x][8] == '' || !is_numeric($excel->sheets[0]['cells'][$x][8])) {
    112. 

  112. 						$errorfound = true;
    113. 

  113. 						return "Error at record ".$x.", all products require you enter a valid price for the item.  Do not enter currency signs or thousands seperators." ;
    114. 

  114. 					}
    115. 

  115. 					//9 list_price
    116. 

  116. 					if (!is_numeric($excel->sheets[0]['cells'][$x][9])) {
    117. 

  117. 						$errorfound = true;
    118. 

  118. 						return "Error at record ".$x.", if you include a list price, it must be in numeric format.  Do not enter currency signs or thousands seperators." ;
    119. 

  119. 					}
    120. 

  120. 					//10 vat_rate
    121. 

  121. 					
    122. 

  122. 					//11 handling_price
    123. 

  123. 					
    124. 

  124. 					//12 stock_quantity
    125. 

  125. 					if ($excel->sheets[0]['cells'][$x][12] == '' || !is_numeric($excel->sheets[0]['cells'][$x][12])) {
    126. 

  126. 						$errorfound = true;
    127. 

  127. 						return "Error at record ".$x.", all products require you enter a stock quantity for the product." ;
    128. 

  128. 					}
    129. 

  129. 					//13 weight
    130. 

  130. 					
    131. 

  131. 					//14 width
    132. 

  132. 					
    133. 

  133. 					//15 height
    134. 

  134. 					
    135. 

  135. 					//16 length
    136. 

  136. 					
    137. 

  137. 					//17 seo_description
    138. 

  138. 					
    139. 

  139. 					//18 seo_keywords
    140. 

  140. 					
    141. 

  141. 					//19 use_specifications
    142. 

  142. 					if (!is_numeric($excel->sheets[0]['cells'][$x][19]) || ($excel->sheets[0]['cells'][$x][19] != 0 && $excel->sheets[0]['cells'][$x][19] != 1)) {
    143. 

  143. 						$errorfound = true;
    144. 

  144. 						return "Error at record ".$x.", use specifications must be either a 1 - selected or 0 - not selected." ;
    145. 

  145. 					}
    146. 

  146. 					//20 use_customer_reviews
    147. 

  147. 					if (!is_numeric($excel->sheets[0]['cells'][$x][20]) || ($excel->sheets[0]['cells'][$x][20] != 0 && $excel->sheets[0]['cells'][$x][20] != 1)) {
    148. 

  148. 						$errorfound = true;
    149. 

  149. 						return "Error at record ".$x.", use customer reviews must be either a 1 - selected or 0 - not selected." ;
    150. 

  150. 					}
    151. 

  151. 					//21 manufacturer_id
    152. 

  152. 					
    153. 

  153. 					//22 download_file_name
    154. 

  154. 					
    155. 

  155. 					//23 image1
    156. 

  156. 					
    157. 

  157. 					//24 image2
    158. 

  158. 					
    159. 

  159. 					//25 image3
    160. 

  160. 					
    161. 

  161. 					//26 image4
    162. 

  162. 					
    163. 

  163. 					//27 image5
    164. 

  164. 					
    165. 

  165. 					//28 option_id_1
    166. 

  166. 					
    167. 

  167. 					//29 option_id_2
    168. 

  168. 					
    169. 

  169. 					//30 option_id_3
    170. 

  170. 					
    171. 

  171. 					//31 option_id_4
    172. 

  172. 					
    173. 

  173. 					//32 option_id_5
    174. 

  174. 					
    175. 

  175. 					//33 use_advanced_optionset
    176. 

  176. 					if (!is_numeric($excel->sheets[0]['cells'][$x][33]) || ($excel->sheets[0]['cells'][$x][33] != 0 && $excel->sheets[0]['cells'][$x][33] != 1)) {
    177. 

  177. 						$errorfound = true;
    178. 

  178. 						return "Error at record ".$x.", use advanced optionsets must be either a 1 - selected or 0 - not selected." ;
    179. 

  179. 					}
    180. 

  180. 					//34 menulevel1_id_1
    181. 

  181. 					
    182. 

  182. 					//35 menulevel1_id_2
    183. 

  183. 					
    184. 

  184. 					//36 menulevel1_id_3
    185. 

  185. 					
    186. 

  186. 					//37 menulevel2_id_1
    187. 

  187. 					
    188. 

  188. 					//38 menulevel2_id_2
    189. 

  189. 					
    190. 

  190. 					//39 menulevel2_id_3
    191. 

  191. 					
    192. 

  192. 					//40 menulevel3_id_1
    193. 

  193. 					
    194. 

  194. 					//41 menulevel3_id_2
    195. 

  195. 					
    196. 

  196. 					//42 menulevel3_id_3
    197. 

  197. 					
    198. 

  198. 					//43 featured_product_id_1
    199. 

  199. 					
    200. 

  200. 					//44 featured_product_id_2
    201. 

  201. 					
    202. 

  202. 					//45 featured_product_id_3
    203. 

  203. 					
    204. 

  204. 					//46 featured_product_id_4
    205. 

  205. 					
    206. 

  206. 					//47 is_giftcard
    207. 

  207. 					if (!is_numeric($excel->sheets[0]['cells'][$x][47]) || ($excel->sheets[0]['cells'][$x][47] != 0 && $excel->sheets[0]['cells'][$x][47] != 1)) {
    208. 

  208. 						$errorfound = true;
    209. 

  209. 						return "Error at record ".$x.", is giftcard must be either a 1 - selected or 0 - not selected." ;
    210. 

  210. 					}
    211. 

  211. 					//48 is_download
    212. 

  212. 					if (!is_numeric($excel->sheets[0]['cells'][$x][48]) || ($excel->sheets[0]['cells'][$x][48] != 0 && $excel->sheets[0]['cells'][$x][48] != 1)) {
    213. 

  213. 						$errorfound = true;
    214. 

  214. 						return "Error at record ".$x.", is download must be either a 1 - selected or 0 - not selected." ;
    215. 

  215. 					}
    216. 

  216. 					//49 is_donation
    217. 

  217. 					if (!is_numeric($excel->sheets[0]['cells'][$x][49]) || ($excel->sheets[0]['cells'][$x][49] != 0 && $excel->sheets[0]['cells'][$x][49] != 1)) {
    218. 

  218. 						$errorfound = true;
    219. 

  219. 						return "Error at record ".$x.", is donation must be either a 1 - selected or 0 - not selected." ;
    220. 

  220. 					}
    221. 

  221. 					//50 is_special
    222. 

  222. 					if (!is_numeric($excel->sheets[0]['cells'][$x][50]) || ($excel->sheets[0]['cells'][$x][50] != 0 && $excel->sheets[0]['cells'][$x][50] != 1)) {
    223. 

  223. 						$errorfound = true;
    224. 

  224. 						return "Error at record ".$x.", is special must be either a 1 - selected or 0 - not selected." ;
    225. 

  225. 					}
    226. 

  226. 					//51 is_taxable
    227. 

  227. 					if (!is_numeric($excel->sheets[0]['cells'][$x][51]) || ($excel->sheets[0]['cells'][$x][51] != 0 && $excel->sheets[0]['cells'][$x][51] != 1)) {
    228. 

  228. 						$errorfound = true;
    229. 

  229. 						return "Error at record ".$x.", is taxable must be either a 1 - selected or 0 - not selected." ;
    230. 

  230. 					}
    231. 

  231. 					//52 is_subscription_item
    232. 

  232. 					if (!is_numeric($excel->sheets[0]['cells'][$x][52]) || ($excel->sheets[0]['cells'][$x][52] != 0 && $excel->sheets[0]['cells'][$x][52] != 1)) {
    233. 

  233. 						$errorfound = true;
    234. 

  234. 						return "Error at record ".$x.", is subscription item must be either a 1 - selected or 0 - not selected." ;
    235. 

  235. 					}
    236. 

  236. 					//53 is_preorder
    237. 

  237. 					
    238. 

  238. 					//54 added_to_db_date
    239. 

  239. 					
    240. 

  240. 					//55 show_on_startup
    241. 

  241. 					if (!is_numeric($excel->sheets[0]['cells'][$x][55]) || ($excel->sheets[0]['cells'][$x][55] != 0 && $excel->sheets[0]['cells'][$x][55] != 1)) {
    242. 

  242. 						$errorfound = true;
    243. 

  243. 						return "Error at record ".$x.", show on store startup must be either a 1 - selected or 0 - not selected." ;
    244. 

  244. 					}
    245. 

  245. 					//56 use_optionitem_images
    246. 

  246. 					if (!is_numeric($excel->sheets[0]['cells'][$x][56]) || ($excel->sheets[0]['cells'][$x][56] != 0 && $excel->sheets[0]['cells'][$x][56] != 1)) {
    247. 

  247. 						$errorfound = true;
    248. 

  248. 						return "Error at record ".$x.", use optionitem images must be either a 1 - selected or 0 - not selected." ;
    249. 

  249. 					}
    250. 

  250. 					//57 use_optionitem_quantity_tracking
    251. 

  251. 					if (!is_numeric($excel->sheets[0]['cells'][$x][57]) || ($excel->sheets[0]['cells'][$x][57] != 0 && $excel->sheets[0]['cells'][$x][57] != 1)) {
    252. 

  252. 						$errorfound = true;
    253. 

  253. 						return "Error at record ".$x.", use optionitem quantity tracking must be either a 1 - selected or 0 - not selected." ;
    254. 

  254. 					}
    255. 

  255. 					//58 views
    256. 

  256. 					
    257. 

  257. 					//59 last_viewed
    258. 

  258. 					
    259. 

  259. 					//60 show_stock_quantity
    260. 

  260. 					if (!is_numeric($excel->sheets[0]['cells'][$x][60]) || ($excel->sheets[0]['cells'][$x][60] != 0 && $excel->sheets[0]['cells'][$x][60] != 1)) {
    261. 

  261. 						$errorfound = true;
    262. 

  262. 						return "Error at record ".$x.", show stock quantity must be either a 1 - selected or 0 - not selected." ;
    263. 

  263. 					}
    264. 

  264. 					//61 maximum_downloads_allowed
    265. 

  265. 					
    266. 

  266. 					//62 download_timelimit_seconds
    267. 

  267. 					
    268. 

  268. 					//63 QB list_id
    269. 

  269. 					
    270. 

  270. 					//64 QB edit_sequence
    271. 

  271. 					
    272. 

  272. 					//65 subscription_bill_length
    273. 

  273. 					
    274. 

  274. 					//66 subscription_bill_period
    275. 

  275. 					
    276. 

  276. 					//67 trial_period_days
    277. 

  277. 					
    278. 

  278. 					//68 stripe_plan_added
    279. 

  279. 					
    280. 

  280. 					//69 subscription_plan_id
    281. 

  281. 					
    282. 

  282. 					//70 allow_multiple_subscription_purchases
    283. 

  283. 					
    284. 

  284. 					//71 membership_page
    285. 

  285. 

  286. 

  287. 			
    288. 

  288. 				}
    289. 

  289. 

  290. 

  291. 				//if we made it through validation, then begin inserting or updating data
    292. 

  292. 				if($errorfound == false) {
    293. 

  293. 					
    294. 

  294. 					
    295. 

  295. 					
    296. 

  296. 					
    297. 

  297. 					  for ($x=2; $x<=$excel->sheets[0]['numRows']; $x++) {
    298. 

  298. 						  
    299. 

  299. 						  //Create SQL Query
    300. 

  300. 						  $sql = $this->escape("SELECT ec_product.product_id FROM ec_product WHERE ec_product.product_id = '".$excel->sheets[0]['cells'][$x][1]."'");
    301. 

  301. 						  // Run query on database
    302. 

  302. 						  $result = mysql_query($sql);
    303. 

  303. 						  //if results, then we found an existing product, do update
    304. 

  304. 						  if(mysql_num_rows($result) > 0) {
    305. 

  305. 

  306. 							    //update product
    307. 

  307. 							  	$sql = $this->escape("UPDATE ec_product SET 
    308. 

  308. 								ec_product.product_id = '%s',
    309. 

  309. 								ec_product.model_number = '%s',
    310. 

  310. 								ec_product.post_id = '%s',
    311. 

  311. 								ec_product.activate_in_store = '%s',
    312. 

  312. 								ec_product.title = '%s',
    313. 

  313. 								ec_product.description = '%s',
    314. 

  314. 								ec_product.specifications = '%s',
    315. 

  315. 								ec_product.price = '%s',
    316. 

  316. 								ec_product.list_price = '%s',
    317. 

  317. 								ec_product.vat_rate = '%s',
    318. 

  318. 								ec_product.handling_price = '%s',
    319. 

  319. 								ec_product.stock_quantity = '%s',
    320. 

  320. 								ec_product.weight = '%s',
    321. 

  321. 								ec_product.width = '%s',
    322. 

  322. 								ec_product.height = '%s',
    323. 

  323. 								ec_product.length = '%s',
    324. 

  324. 								ec_product.seo_description = '%s',
    325. 

  325. 								ec_product.seo_keywords = '%s',
    326. 

  326. 								ec_product.use_specifications = '%s',
    327. 

  327. 								ec_product.use_customer_reviews = '%s',
    328. 

  328. 								ec_product.manufacturer_id = '%s',
    329. 

  329. 								ec_product.download_file_name = '%s',
    330. 

  330. 								ec_product.image1 = '%s',
    331. 

  331. 								ec_product.image2 = '%s',
    332. 

  332. 								ec_product.image3 = '%s',
    333. 

  333. 								ec_product.image4 = '%s',
    334. 

  334. 								ec_product.image5 = '%s',
    335. 

  335. 								ec_product.option_id_1 = '%s',
    336. 

  336. 								ec_product.option_id_2 = '%s',
    337. 

  337. 								ec_product.option_id_3 = '%s',
    338. 

  338. 								ec_product.option_id_4 = '%s',
    339. 

  339. 								ec_product.option_id_5 = '%s',
    340. 

  340. 								ec_product.use_advanced_optionset = '%s',
    341. 

  341. 								ec_product.menulevel1_id_1 = '%s',
    342. 

  342. 								ec_product.menulevel1_id_2 = '%s',
    343. 

  343. 								ec_product.menulevel1_id_3 = '%s',
    344. 

  344. 								ec_product.menulevel2_id_1 = '%s',
    345. 

  345. 								ec_product.menulevel2_id_2 = '%s',
    346. 

  346. 								ec_product.menulevel2_id_3 = '%s',
    347. 

  347. 								ec_product.menulevel3_id_1 = '%s',
    348. 

  348. 								ec_product.menulevel3_id_2 = '%s',
    349. 

  349. 								ec_product.menulevel3_id_3 = '%s',
    350. 

  350. 								ec_product.featured_product_id_1 = '%s',
    351. 

  351. 								ec_product.featured_product_id_2 = '%s',
    352. 

  352. 								ec_product.featured_product_id_3 = '%s',
    353. 

  353. 								ec_product.featured_product_id_4 = '%s',
    354. 

  354. 								ec_product.is_giftcard = '%s',
    355. 

  355. 								ec_product.is_download = '%s',
    356. 

  356. 								ec_product.is_donation = '%s',
    357. 

  357. 								ec_product.is_special = '%s',
    358. 

  358. 								ec_product.is_taxable = '%s',
    359. 

  359. 								ec_product.is_subscription_item = '%s',
    360. 

  360. 								ec_product.is_preorder = '%s',
    361. 

  361. 								ec_product.added_to_db_date = '%s',
    362. 

  362. 								ec_product.show_on_startup = '%s',
    363. 

  363. 								ec_product.use_optionitem_images = '%s',
    364. 

  364. 								ec_product.use_optionitem_quantity_tracking = '%s',
    365. 

  365. 								ec_product.views = '%s',
    366. 

  366. 								ec_product.last_viewed = '%s',
    367. 

  367. 								ec_product.show_stock_quantity = '%s',
    368. 

  368. 								ec_product.maximum_downloads_allowed = '%s',
    369. 

  369. 								ec_product.download_timelimit_seconds = '%s',
    370. 

  370. 								ec_product.list_id = '%s',
    371. 

  371. 								ec_product.edit_sequence = '%s',
    372. 

  372. 								ec_product.subscription_bill_length = '%s',
    373. 

  373. 								ec_product.subscription_bill_period = '%s',
    374. 

  374. 								ec_product.trial_period_days = '%s',
    375. 

  375. 								ec_product.stripe_plan_added = '%s',
    376. 

  376. 								ec_product.subscription_plan_id = '%s',
    377. 

  377. 								ec_product.allow_multiple_subscription_purchases = '%s',
    378. 

  378. 								ec_product.membership_page = '%s'
    379. 

  379. 								
    380. 

  380. 								WHERE product_id = '".$excel->sheets[0]['cells'][$x][1]."'",
    381. 

  381. 								
    382. 

  382. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][1]),
    383. 

  383. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][2]),
    384. 

  384. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][3]),
    385. 

  385. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][4]),
    386. 

  386. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][5]),
    387. 

  387. 								$excel->sheets[0]['cells'][$x][6],
    388. 

  388. 								$excel->sheets[0]['cells'][$x][7],
    389. 

  389. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][8]),
    390. 

  390. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][9]),
    391. 

  391. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][10]),
    392. 

  392. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][11]),
    393. 

  393. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][12]),
    394. 

  394. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][13]),
    395. 

  395. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][14]),
    396. 

  396. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][15]),
    397. 

  397. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][16]),
    398. 

  398. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][17]),
    399. 

  399. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][18]),
    400. 

  400. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][19]),
    401. 

  401. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][20]),
    402. 

  402. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][21]),
    403. 

  403. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][22]),
    404. 

  404. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][23]),
    405. 

  405. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][24]),
    406. 

  406. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][25]),
    407. 

  407. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][26]),
    408. 

  408. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][27]),
    409. 

  409. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][28]),
    410. 

  410. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][29]),
    411. 

  411. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][30]),
    412. 

  412. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][31]),
    413. 

  413. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][32]),
    414. 

  414. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][33]),
    415. 

  415. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][34]),
    416. 

  416. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][35]),
    417. 

  417. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][36]),
    418. 

  418. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][37]),
    419. 

  419. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][38]),
    420. 

  420. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][39]),
    421. 

  421. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][40]),
    422. 

  422. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][41]),
    423. 

  423. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][42]),
    424. 

  424. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][43]),
    425. 

  425. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][44]),
    426. 

  426. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][45]),
    427. 

  427. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][46]),
    428. 

  428. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][47]),
    429. 

  429. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][48]),
    430. 

  430. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][49]),
    431. 

  431. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][50]),
    432. 

  432. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][51]),
    433. 

  433. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][52]),
    434. 

  434. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][53]),
    435. 

  435. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][54]),
    436. 

  436. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][55]),
    437. 

  437. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][56]),
    438. 

  438. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][57]),
    439. 

  439. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][58]),
    440. 

  440. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][59]),
    441. 

  441. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][60]),
    442. 

  442. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][61]),
    443. 

  443. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][62]),
    444. 

  444. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][63]),
    445. 

  445. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][64]),
    446. 

  446. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][65]),
    447. 

  447. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][66]),
    448. 

  448. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][67]),
    449. 

  449. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][68]),
    450. 

  450. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][69]),
    451. 

  451. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][70]),
    452. 

  452. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][71]));
    453. 

  453. 								
    454. 

  454. 								if (!mysql_query($sql)) {
    455. 

  455. 									//error out
    456. 

  456. 									break;
    457. 

  457. 								} else {
    458. 

  458. 									//Enqueue Quickbooks Add Product
    459. 

  459. 									if( file_exists( "../../../../wp-easycart-quickbooks/QuickBooks.php" ) ){
    460. 

  460. 										$quickbooks = new ec_quickbooks( );
    461. 

  461. 										$quickbooks->update_product( $excel->sheets[0]['cells'][$x][2] ); //model_number	
    462. 

  462. 									}
    463. 

  463. 									
    464. 

  464. 									// Insert a WordPress Custom post type post.
    465. 

  465. 									$post = array(	'ID'			=> $excel->sheets[0]['cells'][$x][3],
    466. 

  466. 													'post_content'	=> "[ec_store modelnumber=\"" . $excel->sheets[0]['cells'][$x][2] . "\"]",
    467. 

  467. 													'post_status'	=> "publish",
    468. 

  468. 													'post_title'	=> $GLOBALS['language']->convert_text( $excel->sheets[0]['cells'][$x][5] ),
    469. 

  469. 													'post_type'		=> "ec_store",
    470. 

  470. 													'post_name'		=> str_replace(' ', '-', $GLOBALS['language']->convert_text( $excel->sheets[0]['cells'][$x][5] ) ),
    471. 

  471. 												  );
    472. 

  472. 									$post_id = wp_update_post( $post );
    473. 

  473. 									
    474. 

  474. 									
    475. 

  475. 									
    476. 

  476. 									//if using stripe and is subscription
    477. 

  477. 									if (get_option( 'ec_option_payment_process_method' ) == 'stripe' && $excel->sheets[0]['cells'][$x][52] == '1') {
    478. 

  478. 										//create an object for call to stripe
    479. 

  479. 										$stripe_plan = (object)array(
    480. 

  480. 										  "product_id" 					=> $excel->sheets[0]['cells'][$x][1],
    481. 

  481. 										  "title"						=> $excel->sheets[0]['cells'][$x][5]);
    482. 

  482. 										
    483. 

  483. 										$stripe = new ec_stripe;
    484. 

  484. 										$response = $stripe->update_plan($stripe_plan);
    485. 

  485. 										if ($response == false) {
    486. 

  486. 											//try to insert it then
    487. 

  487. 											//create an object for call to stripe
    488. 

  488. 											$stripe_plan = (object)array(
    489. 

  489. 											  "price" 						=> $excel->sheets[0]['cells'][$x][8],
    490. 

  490. 											  "product_id" 					=> $excel->sheets[0]['cells'][$x][1],
    491. 

  491. 											  "title"						=> $excel->sheets[0]['cells'][$x][5],
    492. 

  492. 											  "subscription_bill_period" 	=> $excel->sheets[0]['cells'][$x][66],
    493. 

  493. 											  "subscription_bill_length" 	=> $excel->sheets[0]['cells'][$x][65],
    494. 

  494. 											  "trial_period_days" 			=> $excel->sheets[0]['cells'][$x][67]);
    495. 

  495. 											
    496. 

  496. 											$stripe = new ec_stripe;
    497. 

  497. 											$response = $stripe->insert_plan($stripe_plan);
    498. 

  498. 										}
    499. 

  499. 									}
    500. 

  500. 								}
    501. 

  501. 							  
    502. 

  502. 						  } else {
    503. 

  503. 							    //insert product
    504. 

  504. 								
    505. 

  505. 								// Insert a WordPress Custom post type post.
    506. 

  506. 								$sql_product = sprintf("SELECT ec_product.product_id, ec_product.title, ec_product.model_number FROM ec_product WHERE ec_product.model_number = '%s'", $excel->sheets[0]['cells'][$x][1] );
    507. 

  507. 								$result_get_product = mysql_query( $sql_product );
    508. 

  508. 								$product = mysql_fetch_assoc( $result_get_product );
    509. 

  509. 								$post = array(	'post_content'	=> "[ec_store modelnumber=\"" . $product['model_number'] . "\"]",
    510. 

  510. 												'post_status'	=> "publish",
    511. 

  511. 												'post_title'	=> $product['title'],
    512. 

  512. 												'post_type'		=> "ec_store"
    513. 

  513. 											  );
    514. 

  514. 								$post_id = wp_insert_post( $post, $wp_error );
    515. 

  515. 								$db = new ec_db( );
    516. 

  516. 								$db->update_product_post_id( $product['product_id'], $post_id );
    517. 

  517. 									
    518. 

  518. 									
    519. 

  519. 								$sql = $this->escape("INSERT into ec_product(
    520. 

  520. 								ec_product.product_id,
    521. 

  521. 								ec_product.model_number,
    522. 

  522. 								ec_product.post_id,
    523. 

  523. 								ec_product.activate_in_store,
    524. 

  524. 								ec_product.title,
    525. 

  525. 								ec_product.description,
    526. 

  526. 								ec_product.specifications,
    527. 

  527. 								ec_product.price,
    528. 

  528. 								ec_product.list_price,
    529. 

  529. 								ec_product.vat_rate,
    530. 

  530. 								ec_product.handling_price,
    531. 

  531. 								ec_product.stock_quantity,
    532. 

  532. 								ec_product.weight,
    533. 

  533. 								ec_product.width,
    534. 

  534. 								ec_product.height,
    535. 

  535. 								ec_product.length,
    536. 

  536. 								ec_product.seo_description,
    537. 

  537. 								ec_product.seo_keywords,
    538. 

  538. 								ec_product.use_specifications,
    539. 

  539. 								ec_product.use_customer_reviews,
    540. 

  540. 								ec_product.manufacturer_id,
    541. 

  541. 								ec_product.download_file_name,
    542. 

  542. 								ec_product.image1,
    543. 

  543. 								ec_product.image2,
    544. 

  544. 								ec_product.image3,
    545. 

  545. 								ec_product.image4,
    546. 

  546. 								ec_product.image5,
    547. 

  547. 								ec_product.option_id_1,
    548. 

  548. 								ec_product.option_id_2,
    549. 

  549. 								ec_product.option_id_3,
    550. 

  550. 								ec_product.option_id_4,
    551. 

  551. 								ec_product.option_id_5,
    552. 

  552. 								ec_product.use_advanced_optionset,
    553. 

  553. 								ec_product.menulevel1_id_1,
    554. 

  554. 								ec_product.menulevel1_id_2,
    555. 

  555. 								ec_product.menulevel1_id_3,
    556. 

  556. 								ec_product.menulevel2_id_1,
    557. 

  557. 								ec_product.menulevel2_id_2,
    558. 

  558. 								ec_product.menulevel2_id_3,
    559. 

  559. 								ec_product.menulevel3_id_1,
    560. 

  560. 								ec_product.menulevel3_id_2,
    561. 

  561. 								ec_product.menulevel3_id_3,
    562. 

  562. 								ec_product.featured_product_id_1,
    563. 

  563. 								ec_product.featured_product_id_2,
    564. 

  564. 								ec_product.featured_product_id_3,
    565. 

  565. 								ec_product.featured_product_id_4,
    566. 

  566. 								ec_product.is_giftcard,
    567. 

  567. 								ec_product.is_download,
    568. 

  568. 								ec_product.is_donation,
    569. 

  569. 								ec_product.is_special,
    570. 

  570. 								ec_product.is_taxable,
    571. 

  571. 								ec_product.is_subscription_item,
    572. 

  572. 								ec_product.is_preorder,
    573. 

  573. 								ec_product.added_to_db_date,
    574. 

  574. 								ec_product.show_on_startup,
    575. 

  575. 								ec_product.use_optionitem_images,
    576. 

  576. 								ec_product.use_optionitem_quantity_tracking,
    577. 

  577. 								ec_product.views,
    578. 

  578. 								ec_product.last_viewed,
    579. 

  579. 								ec_product.show_stock_quantity,
    580. 

  580. 								ec_product.maximum_downloads_allowed,
    581. 

  581. 								ec_product.download_timelimit_seconds,
    582. 

  582. 								ec_product.list_id,
    583. 

  583. 								ec_product.edit_sequence,
    584. 

  584. 								ec_product.subscription_bill_length,
    585. 

  585. 								ec_product.subscription_bill_period,
    586. 

  586. 								ec_product.trial_period_days,
    587. 

  587. 								ec_product.stripe_plan_added,
    588. 

  588. 								ec_product.subscription_plan_id,
    589. 

  589. 								ec_product.allow_multiple_subscription_purchases,
    590. 

  590. 								ec_product.membership_page
    591. 

  591. 								)
    592. 

  592. 												values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s', '%s')",
    593. 

  593. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][1]),
    594. 

  594. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][2]),
    595. 

  595. 								mysql_real_escape_string($post_id),
    596. 

  596. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][4]),
    597. 

  597. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][5]),
    598. 

  598. 								$excel->sheets[0]['cells'][$x][6],
    599. 

  599. 								$excel->sheets[0]['cells'][$x][7],
    600. 

  600. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][8]),
    601. 

  601. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][9]),
    602. 

  602. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][10]),
    603. 

  603. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][11]),
    604. 

  604. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][12]),
    605. 

  605. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][13]),
    606. 

  606. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][14]),
    607. 

  607. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][15]),
    608. 

  608. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][16]),
    609. 

  609. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][17]),
    610. 

  610. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][18]),
    611. 

  611. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][19]),
    612. 

  612. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][20]),
    613. 

  613. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][21]),
    614. 

  614. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][22]),
    615. 

  615. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][23]),
    616. 

  616. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][24]),
    617. 

  617. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][25]),
    618. 

  618. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][26]),
    619. 

  619. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][27]),
    620. 

  620. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][28]),
    621. 

  621. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][29]),
    622. 

  622. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][30]),
    623. 

  623. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][31]),
    624. 

  624. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][32]),
    625. 

  625. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][33]),
    626. 

  626. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][34]),
    627. 

  627. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][35]),
    628. 

  628. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][36]),
    629. 

  629. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][37]),
    630. 

  630. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][38]),
    631. 

  631. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][39]),
    632. 

  632. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][40]),
    633. 

  633. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][41]),
    634. 

  634. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][42]),
    635. 

  635. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][43]),
    636. 

  636. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][44]),
    637. 

  637. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][45]),
    638. 

  638. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][46]),
    639. 

  639. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][47]),
    640. 

  640. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][48]),
    641. 

  641. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][49]),
    642. 

  642. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][50]),
    643. 

  643. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][51]),
    644. 

  644. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][52]),
    645. 

  645. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][53]),
    646. 

  646. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][54]),
    647. 

  647. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][55]),
    648. 

  648. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][56]),
    649. 

  649. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][57]),
    650. 

  650. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][58]),
    651. 

  651. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][59]),
    652. 

  652. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][60]),
    653. 

  653. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][61]),
    654. 

  654. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][62]),
    655. 

  655. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][63]),
    656. 

  656. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][64]),
    657. 

  657. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][65]),
    658. 

  658. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][66]),
    659. 

  659. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][67]),
    660. 

  660. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][68]),
    661. 

  661. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][69]),
    662. 

  662. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][70]),
    663. 

  663. 								mysql_real_escape_string($excel->sheets[0]['cells'][$x][71]));
    664. 

  664. 								
    665. 

  665. 								if (!mysql_query($sql)) {
    666. 

  666. 									//error out
    667. 

  667. 									break;
    668. 

  668. 								} else {
    669. 

  669. 									//Enqueue Quickbooks Add Product
    670. 

  670. 									if( file_exists( "../../../../wp-easycart-quickbooks/QuickBooks.php" ) ){
    671. 

  671. 										$quickbooks = new ec_quickbooks( );
    672. 

  672. 										$quickbooks->add_product( $excel->sheets[0]['cells'][$x][1] ); //model_number	
    673. 

  673. 									}
    674. 

  674. 									
    675. 

  675. 									
    676. 

  676. 									
    677. 

  677. 									//if using stripe and is subscription, insert plan
    678. 

  678. 									if (get_option( 'ec_option_payment_process_method' ) == 'stripe' && $excel->sheets[0]['cells'][$x][52] == '1') {
    679. 

  679. 										//create an object for call to stripe
    680. 

  680. 										$stripe_plan = (object)array(
    681. 

  681. 										  "price" 						=> $excel->sheets[0]['cells'][$x][8],
    682. 

  682. 										  "product_id" 					=> $product['product_id'],
    683. 

  683. 										  "title"						=> $excel->sheets[0]['cells'][$x][5],
    684. 

  684. 										  "subscription_bill_period" 	=> $excel->sheets[0]['cells'][$x][66],
    685. 

  685. 										  "subscription_bill_length" 	=> $excel->sheets[0]['cells'][$x][65],
    686. 

  686. 										  "trial_period_days" 			=> $excel->sheets[0]['cells'][$x][67]);
    687. 

  687. 										
    688. 

  688. 										$stripe = new ec_stripe;
    689. 

  689. 										$response = $stripe->insert_plan($stripe_plan);
    690. 

  690. 									}
    691. 

  691. 								}
    692. 

  692. 							
    693. 

  693. 						  }
    694. 

  694. 							
    695. 

  695. 							
    696. 

  696. 		
    697. 

  697. 					  }
    698. 

  698. 					  if(!mysql_error()) {
    699. 

  699. 						  $returnArray[] ="success";
    700. 

  700. 				 		  return($returnArray); //return array results if there are some
    701. 

  701. 					  } else {
    702. 

  702. 						  return 'Error at record '.$x.', Please Check Excel File: ' . mysql_error();
    703. 

  703. 					  }
    704. 

  704. 				}
    705. 

  705. 			}
    706. 

  706. 

  707. 

  708. 		}
    709. 

  709. 

  710. 

  711. 

  712. 	}//close class
    713. 

  713. ?>
    714.