user id 2129
parent id 993
applicable charges 30
event type oc
select * from users where user_id = '2129'
Resource id #7
client limit 0
parent id 25096
select * from track_consignment_user where user_id = '2129'
avialble with applicable charges -30
insert into track_consignment_user (applicable_charges , user_type , user_id , credit_limit , used_limit , available_limit ) values ('30','client','2129' , '0' ,'30' , '-30')
insert into track_consignment_user_notification (client_consignment_id , event_type, applicable_charges , user_type , user_id , credit_limit , used_limit , available_limit ) values ( '', 'oc','30','client','2129' , '0' ,'30' , '-30' ) update users set credit_limit_current_amount = '-30' where user_id = '2129' and credit_limit_status='1' and user_id in (select user_id from client_consignment where client_consignment_id = '' and limit_tracking_status ='0' ) update client_consignment set limit_tracking_status= '1' , limit_tracking_code='oc' ,limit_tracking_event_type='oc' where client_consignment_id='' and limit_tracking_status ='0'
select * from users where user_id = '25096'
0
parent_client
select * from track_consignment_user where parent_id = '25096'
insert into track_consignment_user (applicable_charges , user_type , parent_id , parent_credit_limit , parent_used_limit , parent_available_limit) values ( '30','parent_client' , '25096' , '0' ,'30' , '-30')
insert into track_consignment_user_notification (client_consignment_id , event_type, applicable_charges , user_type , parent_id , parent_credit_limit , parent_used_limit , parent_available_limit ) values ('', 'oc', '30','parent_client' , '25096' , '0' ,'30' , '-30' )