Please enable JavaScript.
Coggle requires JavaScript to display documents.
Coupon Add And Delete - Coggle Diagram
Coupon Add And Delete
Procedure
proc_all_online_courses
proc_get_package_duration
proc_add_coupon
proc_delete_coupon ( pass usere id and coupon name )
Table
tbl_package
online_class_status = 1
package_status = 1
tbl_coupon
tbl_package_duration
package_id
short_description
duration
3
6
Delete Coupon
status = 0
CONCAT(get_coupon_name, "
deleted
",now())
coupon_name set value
view
createcoupon
deletecoupon
Create coupon
Insert into tbl_coupon
Controller
salesController