Need a SQL tool for my point of sale

Ukończone Opublikowano 5 lat temu Płatność przy odbiorze
Ukończone Płatność przy odbiorze

Basically I need an SQL code written that will help close the day of our POINT OF SALE. The person will have to remote log in and back up and execute the program as I have no working knowledge. OR GIVE ME A PRETTY DETAILED DESCRIPTION HOW TO execute, Here is a cut and paste to the conversation that I had with the designer.

the program we use currently is [login to view URL]

PROGRAMMER:

You can mass cash your orders out using an SQL tool. There is no way from within the program to do this. If you do use an SQL tool, make sure that you backup your file first! SQL tools change everything that they're told to change without prompting, so if the command is slightly wrong, then the database could be permanently damaged.

SQL tools, there are many available "SQLite Database Tools" that are throughout the internet. You can even go to [login to view URL] and get their free command line tool, but be every careful, and you should have some SQL knowledge. Off the top of my head the SQL command to cash out any not cashed out orders would be as follows;

UPDATE orders_tbl SET cashout_machine='SQL', cashout_id=1, cash_tot=ord_total, paid_in_full=1 WHERE record_type=1 AND voided_order=0 AND paid_in_full=0;

This is one continuous line and must be entered in EXACTLY as shown and ending with the semi-colon. Again, backup the file before doing this or any other SQL editing on your database!

MySQL PHP Architektura oprogramowania

Numer ID Projektu: #18457253

O projekcie

7 ofert Zdalny projekt Aktywny 5 lat temu

Przyznany użytkownikowi:

Cyberpau

I can deliver your desired script in one day if weekends OR two days if weekdays (I'm a full time PoS programmer with knowledge on VB.NET, Java and SQL Server) I am an expert in SQL Server (same applies to MySQL, etc. Więcej

$20 USD w ciągu 2 dni
(0 ocen)
0.0

7 freelancerów złożyło ofertę za $27 w tym projekcie

rajeshsonisl

Hi there, Quick and easy. Makes perfect sense. Just need CPanel access to the server. I have a 99% project completion rate and a 4.99 reputation (out of max 5.0!) from more than 1150 projects from a period of 12 Więcej

$26 USD w ciągu 1 dnia
(948 Oceny)
8.6
dinorahskm

I need credentials to log in and back up your database I can do this today All you need to get this done now is click on the green award button next to my bid. Regards, Kellogg

$10 USD w ciągu 1 dnia
(3 Oceny)
4.6
MangoCoderz

Need a SQL tool for my point of sale i m interested to your project. As a full-stack developer I can do this job.

$25 USD w ciągu 1 dnia
(7 Oceny)
4.4
waqaramjad1993

Dear sir, madam I am interesting your project. I can satisfy you perfectly. I have read your description and I would like to work for you having perfect expertise in required task. I am software engineer having 5 year Więcej

$55 USD w ciągu 1 dnia
(0 Oceny)
1.2
RavinduJayzz

Hey ! I can help with the project, but i need some more information about your requirement. Can you please message me and we can talk about it ! Thank You :)

$25 USD w ciągu 1 dnia
(1 Ocena)
0.0