Find Jobs
Hire Freelancers

Shopping order sql insert bug fix

$10-30 USD

Tamamlandı
İlan edilme: yaklaşık 10 yıl önce

$10-30 USD

Teslimde ödenir
3 Issues to fix MULTIPLE PRODUCT CHECKOUT #[login to view URL] different prodcut (item_id) is sotred in a row as pending before chekout. once shopper completed checkout, the each product should be FOREACH and insert into ordered table as each diffrent row with its detail included other table’s data. But here only insert one product and needed to be fix. #[login to view URL] checkout, each item stock number should be decreased by the number of its purchased. #3. Add case of “Delete only purchased item in shopping cart if there is uncheckout item remains” to DELETE shopping cart WHERE ID=shopper DETAILS #1 example. Shopper is about to checkout 3 products in shopping cart and this is saved as pending as INSERT INTO `bx_pmt_ordres_pending` (`id`, `order_id`, `client_id`, `seller_id`, `item_type`, `items`, `amount`, `shp_amt`, `currency`, `b_currency`, `b_amount`, `b_shpamt`, `shp_type`, `provider`, `error_code`, `error_msg`, `txn_id`, `date`, `shp_id`) VALUES (460, '94VP2S55F98GR1VY', 5479, 5606, 'P', '5606_31_533_1:5606_31_531_1:5606_31_534_1', 934.5, 60, 'USD', 'USD', 934.5, 20, 'pp', 'paypal', '', '', '', '1395897518', 16); Once checkout has completed, below has inserted include table in blue but red row is missing. INSERT INTO `bx_pmt_ordres` (`id`, `pending_id`, `txn_id`, `client_id`, `seller_id`, `module_id`, `item_id`, `color`, `size`, `option`, `item_count`, `amount`, `shp_amount`, `option_amt`, `s_currency`, `s_amount`, `s_shpamt`, `s_optionamt`, `b_currency`, `b_amount`, `b_shpamt`, `b_optionamt`, `buyer_status`, `seller_status`, `tracking_code`, `seller_pmt_status`, `admin_pmt_status`, `date`) VALUES (222, 460, '', 5479, 5606, 31, 533, 'Black', 'M', 'no', 1, 934.5, 20, 0, 'USD', 934.5, 20, 0, 'USD', 934.5, 20, 0, 'n', 'n', '', 'n', 'n', '1395897550'); (222, 460, '', 5479, 5606, 31, 531, 'White', 'L', 'no', 1, 189.50, 20, 0, 'USD', 189.50, 20, 0, 'USD', 189.50, 20, 0, 'n', 'n', '', 'n', 'n', '1395897550'); (222, 460, '', 5479, 5606, 31, 534, 'Black', '4', 'no', 1, 690.0, 20, 0, 'USD', 690.0, 20, 0, 'USD', 690.0, 20, 0, 'n', 'n', '', 'n', 'n', '1395897550'); INSERT INTO `bx_store_product_files` (`id`, `author_id`, `entry_id`, `media_id`, `price`, `allow_purchase_to`, `hidden`, `color`, `size`, `store_type`, `stock_num`, `cond`) VALUES (531, 5606, 486, 0, '189.50', '4', 0, 'White', 'L', 'P', 2, 0), (533, 5606, 488, 0, '55.00', '4', 0, 'Black', 'M', 'P', 1, 0), (534, 5606, 489, 0, '690.00', '4', 0, 'Black', '4', 'P', 2, 0); #2 example. $updateStockSql = 'UPDATE bx_store_product_files SET stock_num=stock_num-'.$item_count.' WHERE id='.$item_id.' '; echo $updateStockSql;exit; mysql_query($updateStockSql) or die(mysql_error()); #3 example. only value in purple should be deleted INSERT INTO `bx_pmt_cart` (`client_id`, `items`) VALUES (5479, '177_31_510_1:177_31_509_1':5606_31_533_1:5606_31_531_1:5606_31_534_1); REQUIREMENTS PHP MYSQL skills YOUR IP ADDRESS for htaccess to allow access The project should be consider as completed only when checkout sql insert test clears below @each of products has confirmed as order as each ( inserted into different row ) m/payment/history/site/ @product stock number has decrease the number of purchased quantity @only purchased item(s) has deleted in shopping bag m/payment/history/site/
Proje No: 5725448

Proje hakkında

8 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 10 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
Seçilen:
Kullanıcı Avatarı
Hi daida, I will fix them for you. Please provide me more details of this project. (Such as web site URL, or source code of the shop...) Regards, Huy
$30 USD 2 gün içinde
5,0 (93 değerlendirme)
6,4
6,4
8 freelancers are bidding on average $61 USD for this job
Kullanıcı Avatarı
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks
$93 USD 1 gün içinde
4,8 (471 değerlendirme)
8,3
8,3
Kullanıcı Avatarı
A proposal has not yet been provided
$126 USD 3 gün içinde
4,8 (71 değerlendirme)
6,7
6,7
Kullanıcı Avatarı
Hello! You are taking tehse obviously from some notes sent to you from your client, as all these "blue,red,purple" references are totally "out of place" (not in sinc with what's been posted here) and having no visual reference at all, so if you copuld please at least provide teh full notes so I can assess the job properly. Also, these wxamples. This is teh SQL sattemets it's executing as is now? If yes, then they contradict what you explain as problem #1, so please clarify on this as well. In overall I don't expect setting up these to pose any problem once the tasks have been clarified on. I can start working on these as soon as you make teh decision to move forward, and have clarified upon the tasks. Kind Regards, Dobri
$20 USD 0 gün içinde
4,9 (176 değerlendirme)
6,2
6,2
Kullanıcı Avatarı
A proposal has not yet been provided
$55 USD 1 gün içinde
5,0 (54 değerlendirme)
5,8
5,8

Müşteri hakkında

   JAPAN bayrağı
Bunkyoku, Japan
4,7
13
Ödeme yöntemi onaylandı
Şub 24, 2011 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.