Suljettu

Edit/Reverse Transaction Function On Inventory Site ***MySQL Experts Only***

Hi, I have a website designed in php/mysql using codeigniter framework for inventory management. Our current process allows users to receive inventory and dispense inventory but no function to edit or reverse these transactions if a mistake is made. I need the ability to view transactions, edit them or reverse while keeping a record of such events for auditing purposes. A possible solution would be to create parent and child tables in the database with status categories, but any suggestions are welcome. Only experts in MySQL should reply.

Taidot: HTML, MySQL, PHP

Näytä lisää: need auditing, mysql inventory management, experts solution, auditing i, mysql transferring database site, reverse bid function code, quickbooks multi site inventory, mysql optimization busy site, site creator reverse auction, mysql optimizations traffic site

About the Employer:
( 5 reviews ) New York, United States

Projektin tunnus: #8647586

10 freelanceria on tarjonnut keskimäärin 78 $ tähän työhön

dboyzhang

Hello, it's clear to create a child table to store all changes. And maybe some button to restore to any step. or reverse( once transaction is reversed, there will be a new field in the main table to change the status o Lisää

94 $ USD 2 päivässä
(315 arvostelua)
7.2
darkwind

Hello, Basing on the illustration you sent, when you view a transaction detail, the Original transaction will display the first record of the transaction, whether it has a mistake or not and has been edited already. Lisää

144 $ USD 3 päivässä
(224 arvostelua)
7.0
Churaliya

Hello there, I am a PHP and MySQL expert. I can complete this Today. Regards, Chura.

72 $ USD 2 päivässä
(45 arvostelua)
6.1
suraj2

Possibilities: - Cancel transaction and create new transaction (this is better idea for auditing) - Edit option with some kind of logs - Direct edit option for super admin (no need of any kind of history/logs)

75 $ USD 3 päivässä
(39 arvostelua)
5.4
krashmi

HI I have experience in php mysql and codeignitor framework will modify the code so that inventory entries are viewed and edited and saved there after Quality work for sure Looking forward to getting hired Thanks

75 $ USD 3 päivässä
(69 arvostelua)
5.1
ratulcse10

Hello I'll add a soft delete field on tables to delete that temporarily but can be used for further use also for editing we can add a updated at field to track if this was edited minimum once I can make it working, Lisää

66 $ USD 2 päivässä
(18 arvostelua)
4.3
angel915

Hello, Thanks for posting project related to my workspace.I have 10+ years experience in Php, WordPress, CakePhp, Codeigniter, HTML5, Bootstrap,Ajax, MySQL. I have done many projects using above technologies.I believ Lisää

83 $ USD 1 päivässä
(7 arvostelua)
3.4
axiomswb

I have expertise in PHP and MySQL.. I can resolve your problem.. Please feel free to communicate.. thank you..

50 $ USD 1 päivässä
(4 arvostelua)
1.8
saliihguul34

Bir öneri henüz sağlanmadı

40 $ USD 0 päivässä
(0 arvostelua)
0.0
mahavis

A proposal has not yet been provided

77 $ USD 2 päivässä
(0 arvostelua)
0.0