Скачать или смотреть #166

In Part-166 of E-commerce series, we will work on COD/Prepaid pincodes list. Our Laravel E-commerce website must check for user delivery pincode before the order placement so we are going to add functionality for it.

1) Search Pincodes data :-
First search Google for indian pincodes in excel format or better if we will get MySql database otherwise we will import. You can also search pincodes for your country and I am sure you will also get some data.

Search keyword :- download indian pincodes in excel format github
https://github.com/saravanakumargn/Al...

2) Create pincodes table :-
Now create cod_pincodes and prepaid_pincodes table with below columns :-
id (int, AI, primary)
pincode (varchar,10)
created_at (datetime)
updated_at (timestamp)

3) Import CSV file :-
We will modify excel file with 4 columns of pincodes table and convert into CSV before importing them into pincodes table as shown in video.

Now our pincodes table is ready with pincodes that are available for shipping of the order. We will not allow the user to place the order with some other pincode.

4) Update checkout function :-
Now update checkout function to count the delivery pincode available in cod and prepaid pincodes tables and we can return count of both to checkout page to display COD and Prepaid options based on it as shown in video.

5) Update checkout.blade.php file :-
Add codpincodeCount and prepaidpincodeCount with address radio button at checkout page so that we can pass both to jQuery to show/hide Prepaid and COD options.

6) Update front_script.js file :-
Now update jQuery at front_script.js file to check codpincodeCount and prepaidpincodeCount count and if count is more then 0 then display COD/Prepaid otherwise hide them.

Thanks for watching :)

Join this channel to get complete code / support :
   / @stackdevelopers