Task Details

<p>3. product list page.... you can see when i update some data it is updating wiht ajax i think.</p> <p>but some reason it is hanging... resolv this issue.</p> <p>&nbsp;</p> <p>4. import ordrs function in admin001. need to check the code to know what is the excel file format that is needed for import orders.<br /> like what columns it will be taking</p>

5. we will made EDIT USER profile page on new-admin.

This function already exist... but it is only for driver user.

Now we want edit user for "client' user type.

If user_type = Client then visible=client profile form
client profile form is same like driver user form - just need more fields:

office number
contact person name
contact person mobile
second contact person name
second person mobile no.
address for pick up
upload logo
upload trade license pdf
email adress for email notification - this field should allow mutiple email addresses like this: rob@mvp.com, rob@qarz.com, nigel@qarz.com

<p>6. we will make new button in order management called &quot;Import Client Orders&quot;</p> <p>in this function we will upload the items in the attached CSV file, INTO the according tables...</p> <p>you will make a new function called addNewClientOrder()</p> <p>this will be same as addNewOrder()... just you will add some extra items in this function acording to the attached csv</p>

7. next we will do the same Import Orders option in new-admin - for the client login user.

user thsi account:
S4J
pass: s4j123

in dashboard there is button called UPLOAD ORDERS... when user click thsi you will show modal window with instructions (i will give you instructions).. .with upload file otipn.

user will select file and upload... and redirect to new page showing a table of the orders they will upload.... so they can review.

or if any error in uploading CLEARLY mention the error to the user so tehy can fix their csv and upload again.

ALWAYS ENSURE you are using the theme styling for modal, for table etc.

03:14
the order they upload we must show option to confirm the data, incsae they will upload many times becasue they make mistake.

example: "Is this data correct, do you want to Save?"

If they click yes, they we add the orders to teh table. otherwise we discard the upload.

<p>8. After user click Save for the uploaded data, we ask them next question - &quot;Do you want to generate AWB bill for your package now?&quot;</p> <p>if they click Yes then we do this:</p> <p>foreach row item<br /> &nbsp;&nbsp; make pdf page of the order details</p> <p>so the user will download a pdf file with many pages of order details.</p> <p>one page will be 1 order detail by using teh Layout in teh attached sample i am giving you.</p>

<p>Nigel,</p> <p>&nbsp;</p> <p>for every order that is uploaded... we need to keep record of the histoy of what will happen to this order.... we call this order tracking.</p> <p>&nbsp;</p> <p><strong>This will be a new table you will create called &quot;Order_Tracking&quot;, currently it will have these column:</strong></p> <p><br /> <strong>Order ID</strong> - this is primary key from orders</p> <p><strong>DateTime -</strong> need to keep track when the order was updated</p> <p><strong>Status</strong> - this will the update of the order depending on different cases we will do later..<br /> The first case we know already... which is &quot;Order has been uploaded&quot; - so you can ADD this as a new entry into the Order_Tracking when user confirm &quot;upload data&quot;</p> <p>the second case we know alerady... which is &quot;AWB Bills created&quot; - so you can add this when user clicks created AWB and the pdf is downloaded successfully.</p> <p>&nbsp;</p> <p>So this will be a table with multiple rows for each order... each time something new is updated for teh order.</p> <p>&nbsp;</p> <p>the table screenshot shows what it will look like.</p> <p>&nbsp;</p> <p>We will show the tracking for the orders later on anotehr task.</p> <p>&nbsp;</p>

<p>Nigel,</p> <p>&nbsp;</p> <p>check to see if tehre is a auto email function that can call to send email notifications.</p> <p>if there isnt then just create one. dont spend too long searchign.</p> <p>&nbsp;</p> <p>in different part of teh new-admin we will need to send email updates to user.</p> <p>&nbsp;</p> <p>here is the first case:</p> <p>&nbsp;</p> <ol> <li><strong>When user clicks Create AWB bill - pickup@qarzdeals.com will get email notification that new parcels are ready - and a summary of today orders is included. meaning, table of parcels - same as upload orders.... and total count, and ofcourse the client user details like company name, address, telephone, client code.</strong></li> </ol>

<p>NIgel,</p> <p>&nbsp;</p> <p>recently you added new user type.</p> <p>&nbsp;</p> <p>now we want a very simple homepage for him that he will see when he login. he will not see the standard dashbaord.</p> <p>&nbsp;</p> <p>as you saw when driver login, he is not seeing the main dahsboard - he is seeing the orders assign to him only.</p> <p>&nbsp;</p> <p>in same way when pick up user login - he will see which client he need to visit.</p> <p>&nbsp;</p> <p>here are the steps how its working:</p> <p>1. we need a table called pickup_task. this will have columns:</p> <p>- primary key</p> <p>- date time</p> <p>- client code for knowing which client e.g not cl-s4j, the primary key code,</p> <p>- status e.g. Ready, Collected, Cancelled etc...</p> <p>( we will add more column if we need)</p> <p>&nbsp;</p> <p>2. when the client user is creating AWB bill.... we will add a new record in pickup_task, and status will be READY</p> <p>&nbsp;</p> <p>3. in the pick up sers home page we will just see this summary (see image) make sure you are using teh themes orignal table styling. this is will looking almost same as teh DRIVER home page. the driver is doing delivery of the parcel. whereas teh pick up user is doing delivery to the client office.<br /> <br /> 4. of course teh status column will be updated according to the action button that is pressed (tick = Collected, X = cancelled</p>

<p>Nigel,</p> <p>&nbsp;</p> <p>this is a small code we need to add to send auto email to client user from admin001.</p> <p>&nbsp;</p> <p>watch thsi video to see which function we need to edit:</p> <p>https://drive.google.com/file/d/19TtkvJnw2FnIhWQw1IZAUCEgHCLpAjqt/view?usp=sharing</p> <p>&nbsp;</p> <p>auto email function in admin001 exist... you can check the code in order histroy to find the code - there are many sections in there that is sending auto email.</p>

<p>nigel,</p> <p>&nbsp;</p> <p>check driver home page... you will see some filter options (see screenshot).</p> <p>&nbsp;</p> <p>i need you to add thsi SAME FILTER OPTION in eCommerce &gt; Order History</p> <p>&nbsp;</p> <p>The filters we need are by Status so that user can see differnt status items:</p> <p>Dispatched</p> <p>Paid</p> <p>Postponed</p> <p>Returned</p> <p>&nbsp;</p>

So the dashboard has some dummy data, we need to replace with real data.

 

for admin user the statistics will be calculated form ALL orders

 

for client user the statsitics will be calculated based on orders belonging to him.

 

we need these statstics:

- Total Orders

- Yesterday Orders

- Total Pending Orders

-  Delivery Ratio

- Total Paid Orders Value AED

 

<p>Nigel,</p> <p>&nbsp;</p> <p>when teh driver is choosing POSTPONE or CANCEL option, we need to send auto email to client user to INFORM them of the situation.</p> <p>&nbsp;</p> <p>Dear &lt;client name&gt;,</p> <p>&nbsp;</p> <p>Order Number &lt;XXXXXX&gt; has been &lt;RETURNED for the reason XXXXX / POSTPONED for XX days&gt; by the Customer.</p> <p>&nbsp;</p> <p>Click to see the Order Tracking History - &lt;hyperlink to traking page&gt;</p> <p>&nbsp;</p> <p>Thank You for your Custom</p> <p>&nbsp;</p> <p>Q-Delivery Team</p>

<p>Nigel,</p> <p>&nbsp;</p> <p>when i download orders in order management teh Geolocation data is not coming.... maybe ther is a mixup in the geolocation column.</p> <p>&nbsp;</p> <p>did you create new geolocation column? or used existing geolocation column?</p> <p>&nbsp;</p> <p>lets discuss on whatsapp</p>

Nigel,

 

we need to check some coding in driver action buttons to see what tables/columns are updated.

 

lets discuss on whatsapp

<p>Nigel,</p> <p>&nbsp;</p> <p>in other task we made an auto email for customer to CONFIRM delivery, by clking confirm button.</p> <p>&nbsp;</p> <p>now we will do the back end coding for this. its quite simple:</p> <p>&nbsp;</p> <p>&nbsp; <p><strong>When customer will click this butotn they will go to delivery.qarzdeals.com/order-confirm.html.</strong></p> </p> <p>&nbsp;</p> <p><strong>This page should ONLY BE VISIBLE if the query string has a Order ID. otherwise this page should not be accessible - and just redirect to tracking page.</strong></p> <p>&nbsp;</p> <p>i made this page already... user has 2 buttons to click.</p> <p>&nbsp;</p> <p>YES CONFIRM</p> <p>or</p> <p>POSTPONE NEXT DAY</p> <p>&nbsp;</p> <p>If customer click YES CONFIRM - then nothing to do actually. You just show a message &quot;Thank You your Order will be delivered Tomorrow. Our Driver will call you when he is Near&quot;<br /> <strong>- AND also update tracking hisotry will message &quot;Next Day Delivery Confirmed by Customer&quot;</strong></p> <p>&nbsp;</p> <p>IF customer click POSTPONE NEXT DAY - in this case you need to chekc teh code for the POSTPONE button in Driver account. And same coding need here as well, as it is same purpose for POSTPONE.<br /> i cant remember what happens in that code - does it update table with somethign information? Or..? Advise me first.</p> <ul> <li><strong>AND update tracking hisotry with message: &quot;Postponed to Next Day by Customer&quot;</strong></li> </ul>

<p>this might need to be a CRON job.</p> <p>&nbsp;</p> <p>at 10pm each night send an auto email to each clietn with a sumamry of TODAY ORDERS... showing the STATUS.</p> <p>&nbsp;</p> <p>this way client can see which customer did POSTPONE</p> <p>&nbsp;</p> <p>&nbsp;</p>

<p>Nigel,</p> <p>&nbsp;</p> <p>when driver clicks button like PAID, CANCELLED etc only one place we have a time record is in ORDER TRACKING table.</p> <p>&nbsp;</p> <p>We need option to be able to DOWNLOAD all the orders that have been action on a chosen day.</p> <p>&nbsp;</p> <p>example... i will selet Yesterday date and click DOWNLOAD.</p> <p>This will give me export of all the orders which had some ACTIOn yesterday, like drive did PAID, or CANCEL or Postpone etc.</p> <p>So this table is the same as upload order table.</p> <p>&nbsp;</p> <p>So you will have to do some kind of Join between the Orders Details and the Tracking HIstroy date.<br /> <br /> e.g<br /> for each item on tracking_histroy table WHERE date=selected_date<br /> &nbsp;&nbsp; get order details</p> <p>&nbsp;</p> <p>make a new page for this in new-admin &gt; eCommerce &gt; Manage Orders</p> <p>in this page will be this panel which date selector and download button.</p> <p>&nbsp;</p> <p>user will select the date and click download to export all orders that got actioned on teh selected date.</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p>

NIgel,

 

in admin001, we need to add a new Status called "COD PAID".

 

so taht admin user can update order status same like how they update status to dispatch.

<p>Nigel,</p> <p>&nbsp;</p> <p>in new-admin &gt; eCommerce &gt; Manage Orders</p> <p>&nbsp;</p> <p>you will create a new PANEL&nbsp; with a button called &quot;Create Customer COD&quot;.</p> <p>&nbsp;</p> <p>when user click this, it will show</p> <p>- drop down to select client user</p> <p>- text box for assinging a numerical value</p> <p>- Save button</p> <p>&nbsp;</p> <p>when click save it will create a new row in a table called COD_Payment. This table should contain these columns:<br /> ID, date_time, client_ID (secondary key), COD_Value, isPaid, date_time_received,</p> <p>&nbsp;</p> <p>Now... when this data is saved, the client user DASHBOARD will show a small PANEL with this COD information. The text will be like this:</p> <p><strong>Your COD Amount of &lt;COD_value&gt; AED is due to be paid today.</strong></p> <p>DId you Receive this COD payment?</p> <p>&lt;yes button&gt; &lt;no button&gt;</p> <p>&nbsp;</p> <p>If cliet user clicks YES then update the table with isPaid=1, and date_time_received = current_date_time<br /> <br /> and of course this panel will disappear. since the user can only click Yes only 1 time.</p>

<p>Nigel,</p> <p>&nbsp;</p> <p>when driver click PAID button... we need to send auto email to CUSTOMER of the order... asking for feedback.</p> <p>&nbsp;</p> <p>Dear &lt;customer_name&gt;,</p> <p>&nbsp;</p> <p>Are you happy with the Driver you met Today for your delivery?</p> <p>&lt;3 smiley faces for user to click. Unhappy-red , Neutral-orange, Happy-green&gt;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>When the customer click any of the smiley faces we will keep a COUNT of the feedback for this driver in his PROFILE table.</p> <p>so we can add 3 columns feedback_bad, feedback_neutral, feedback_good</p> <p>so when customer click we just increase teh value of the respect column by 1.</p>

NIgel,

 

i wonder if there is a simple way we can allow image upload for the driver?

 

so when he click PAID.... we want to show a image upload screen.

 

we will click upload image.... and he will take a picture and upload the image.

of course we must OPTIMIZE the image before uploading to our server because the driver will use huge megapixel camera that will make image too big.

 

Let me know what you think will be simple way of doing this

<p>Nigel,</p> <p>&nbsp;</p> <p>when driver click PAID... we want to keep a COUNT for the client user. maybe in teh client user table?</p> <p>&nbsp;</p> <p>we need a colum to keep a count of how many paid deliveries have been completed.&nbsp; each paid delivery means 1 point.</p> <p>&nbsp;</p> <p>so in the dashboard on the box below the UPload Orders - we will show the points total.</p>

<p>Nigel,</p> <p>&nbsp;</p> <p>some user have 1 email in the field. otehr user have multiple email in teh field.</p> <p>&nbsp;</p> <p>in some case the auto email is not sending.</p> <p>&nbsp;</p> <p>test properly and eusre its working please for single email and multiple email.</p>

Nigel,

 

when client user click AWB bill... the customer of the order is getting auto email to inform them about the order.

 

but this auto email does not contain any link / option to know how to track the email. it has only CONFIRM button.

So when they click CONFIRM... we need to send them a new email... which will be like this:

 

Dear <name>,

 

Thank you for Confirming your Order. We will deliver this tomorrow.

 

You can TRACK your Order here:

 

Thank You

Q-Delivery

<p>Nigel,</p> <p>&nbsp;</p> <p>when teh drive us clicking POSTPONE... this item is disappearing from TODAY orders page.</p> <p>&nbsp;</p> <p>but it is showing in Order HISTORY page.</p> <p>&nbsp;</p> <p>so somethign is wrong in today order page.. please fix so that postpone item is showing.</p>

NIgel,

 

we neeed EXPORT ORDER button in Order History page incase client user want to download all his orders.

 

the export will be the same table that he is seeing on his screen.

<p>Nigel,</p> <p>&nbsp;</p> <p>in edit user we have a unnnessary field (see image).</p> <p>&nbsp;</p> <p>replace this with a Drop Down List... called &quot;Select Delivery Zone&quot;.</p> <p>&nbsp;</p> <p>the options for thsi drop down will be coming from an existing table.</p> <p>&nbsp;</p> <p>you can check admin001 &gt; Order Hisotry &gt; AWB Column</p> <p>there is a drop down in this column. we want that same data so you can check which table the data is coming from.</p> <p>&nbsp;</p>