[2023-08-16 19:39:08] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-000000000000202022.1.4.104712023-08-16T19:39:08.007Z2023-08-16T19:44:08.007Z0No Errorf4bada30-e0f6-498f-8817-cc83d7eaa93fmariano.rossin@gmail.comMarianoRossina41d5d54-be35-4645-8ce3-e0a145c923a66106-05-25T07:00:00"} [] [2023-08-16 19:39:09] dev.INFO: API Request Auth: {"context":"\nmariano.rossin@gmail.coma41d5d54-be35-4645-8ce3-e0a145c923a6\n"} [] [2023-08-16 19:39:11] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.4.104712023-08-16T19:39:11.125Z2023-08-16T19:44:11.125Z0No ErrorFirm Prueba Mariano
Los Ceibos 2731San Jose of The CornerTX23121US
3425290600
"} [] [2023-08-16 19:39:11] dev.INFO: API Request Auth: {"context":"\nmariano.rossin@gmail.coma41d5d54-be35-4645-8ce3-e0a145c923a6f4bada30-e0f6-498f-8817-cc83d7eaa93f\n"} [] [2023-08-16 19:39:13] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.4.104712023-08-16T19:39:13.110Z2023-08-16T19:44:13.110Z0No Errormariano.rossin@gmail.comMarianoJorgeRossin2023-08-16T19:39:07.913falsefalse"} [] [2023-08-16 19:47:25] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-07-17 00:00:00" AND va.created_at <= "2023-08-16 23:59:59" ORDER BY va.created_at DESC [] [] [2023-08-16 19:47:31] dev.INFO: email value - mariano.rossin@gmail.com [] [] [2023-08-16 19:47:31] dev.INFO: passHash value - a41d5d54-be35-4645-8ce3-e0a145c923a6 [] [] [2023-08-16 19:47:31] dev.INFO: session PasswordHash value - 1 [] [] [2023-08-16 19:47:31] dev.INFO: API Request Auth: {"context":"\nmariano.rossin@gmail.coma41d5d54-be35-4645-8ce3-e0a145c923a6\n"} [] [2023-08-16 19:47:33] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.4.104712023-08-16T19:47:33.333Z2023-08-16T19:52:33.333Z0No ErrorTraining Global242712335VISA4448122029Mariano Rossintrue"} [] [2023-08-16 19:47:33] dev.INFO: global acct liststdClass Object ( [PaymentAccountListResponse] => stdClass Object ( [Error] => stdClass Object ( [ErrorCode] => 0 [ErrorText] => No Error ) [PaymentAccount] => stdClass Object ( [AccountName] => Training Global [AccountToken] => 242712335 [CardType] => VISA [CardLast4] => 4448 [CardMonth] => 12 [CardYear] => 2029 [CardHolderName] => Mariano Rossin [Active] => 1 [PaymentAccountID] => 65acb7f3-9011-48af-b996-9a792fcfc483 [PaymentAccountTypeCode] => CC ) ) ) [] [] [2023-08-16 19:47:46] dev.INFO: API Request Auth: {"context":"\nmariano.rossin@gmail.coma41d5d54-be35-4645-8ce3-e0a145c923a6\n"} [] [2023-08-16 19:47:48] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.4.104712023-08-16T19:47:48.056Z2023-08-16T19:52:48.056Z0No Error784512MarioRossinaurora487@sbcglobal.net789123MarianoJorgeRossinojubom@yahoo.com789123jorgeRamanoojubom@yahoo.com"} [] [2023-08-16 19:47:48] dev.INFO: attorney list: stdClass Object ( [AttorneyListResponse] => stdClass Object ( [Error] => stdClass Object ( [ErrorCode] => 0 [ErrorText] => No Error ) [Attorney] => Array ( [0] => stdClass Object ( [BarNumber] => 784512 [FirstName] => Mario [MiddleName] => [LastName] => Rossin [AttorneyID] => fb6e3e92-2b99-4e22-86b5-551c2e657de0 [FirmID] => 8384e46c-71b6-42bd-ad01-125ecba387f3 ) [1] => stdClass Object ( [BarNumber] => 789123 [FirstName] => Mariano [MiddleName] => Jorge [LastName] => Rossin [AttorneyID] => 89ce0d18-25be-48db-9ec4-c9dd5e4eae5f [FirmID] => 8384e46c-71b6-42bd-ad01-125ecba387f3 ) [2] => stdClass Object ( [BarNumber] => 789123 [FirstName] => jorge [MiddleName] => [LastName] => Ramano [AttorneyID] => 523a5992-a29e-4935-96a1-64e0c081dd4b [FirmID] => 8384e46c-71b6-42bd-ad01-125ecba387f3 ) ) ) ) [] [] [2023-08-16 19:47:48] dev.INFO: API Request Auth: {"context":"\nmariano.rossin@gmail.coma41d5d54-be35-4645-8ce3-e0a145c923a6\n"} [] [2023-08-16 19:47:49] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.4.104712023-08-16T19:47:49.781Z2023-08-16T19:52:49.781Z0No Errormariano.rossin+attorney@gmail.comMarioRossin2023-07-14T15:26:23.673falsefalsemariano.rossin@gmail.comMarianoJorgeRossin2023-08-16T19:39:07.913falsefalsemjrossin@hotmail.comMarioRossin2023-04-27T19:15:59falsefalse"} [] [2023-08-16 19:47:49] dev.INFO: user data stdClass Object ( [Error] => stdClass Object ( [ErrorCode] => 0 [ErrorText] => No Error ) [User] => Array ( [0] => stdClass Object ( [Email] => mariano.rossin+attorney@gmail.com [FirstName] => Mario [MiddleName] => [LastName] => Rossin [LastLoginDate] => 2023-07-14T15:26:23.673 [RestrictFiling] => [RestrictFilingComment] => [UserID] => 1a700e63-3ecd-4b56-93da-939df192cc37 [FirmID] => 8384e46c-71b6-42bd-ad01-125ecba387f3 [IsApproved] => 1 [IsActive] => 1 [IsActivated] => 1 [IsLockedOut] => ) [1] => stdClass Object ( [Email] => mariano.rossin@gmail.com [FirstName] => Mariano [MiddleName] => Jorge [LastName] => Rossin [LastLoginDate] => 2023-08-16T19:39:07.913 [RestrictFiling] => [RestrictFilingComment] => [UserID] => f4bada30-e0f6-498f-8817-cc83d7eaa93f [FirmID] => 8384e46c-71b6-42bd-ad01-125ecba387f3 [IsApproved] => 1 [IsActive] => 1 [IsActivated] => 1 [IsLockedOut] => ) [2] => stdClass Object ( [Email] => mjrossin@hotmail.com [FirstName] => Mario [MiddleName] => [LastName] => Rossin [LastLoginDate] => 2023-04-27T19:15:59 [RestrictFiling] => [RestrictFilingComment] => [UserID] => 8e430260-586d-4dcf-9657-eb818725394d [FirmID] => 8384e46c-71b6-42bd-ad01-125ecba387f3 [IsApproved] => 1 [IsActive] => 1 [IsActivated] => 1 [IsLockedOut] => ) ) ) [] [] [2023-08-16 19:47:49] dev.INFO: user ids Array ( [0] => 1a700e63-3ecd-4b56-93da-939df192cc37 [1] => f4bada30-e0f6-498f-8817-cc83d7eaa93f [2] => 8e430260-586d-4dcf-9657-eb818725394d ) [] [] [2023-08-16 19:47:57] dev.INFO: API Request Auth: {"context":"\nmariano.rossin@gmail.coma41d5d54-be35-4645-8ce3-e0a145c923a6\n"} [] [2023-08-16 19:47:59] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.4.104712023-08-16T19:47:59.848Z2023-08-16T19:52:59.848Z0No ErrorTraining-135242010313VISA4448122029Mariano Rossintruetrue"} [] [2023-08-16 19:47:59] dev.INFO: email value - [] [] [2023-08-16 19:47:59] dev.INFO: passHash value - [] [] [2023-08-16 19:47:59] dev.INFO: session PasswordHash value - 1 [] [] [2023-08-16 19:47:59] dev.INFO: API Request Auth: {"context":"\nmariano.rossin@gmail.coma41d5d54-be35-4645-8ce3-e0a145c923a6\n"} [] [2023-08-16 19:48:01] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.4.104712023-08-16T19:48:01.491Z2023-08-16T19:53:01.491Z0No ErrorTraining Global242712335VISA4448122029Mariano Rossintrue"} [] [2023-08-16 19:48:01] dev.INFO: global acct liststdClass Object ( [PaymentAccountListResponse] => stdClass Object ( [Error] => stdClass Object ( [ErrorCode] => 0 [ErrorText] => No Error ) [PaymentAccount] => stdClass Object ( [AccountName] => Training Global [AccountToken] => 242712335 [CardType] => VISA [CardLast4] => 4448 [CardMonth] => 12 [CardYear] => 2029 [CardHolderName] => Mariano Rossin [Active] => 1 [PaymentAccountID] => 65acb7f3-9011-48af-b996-9a792fcfc483 [PaymentAccountTypeCode] => CC ) ) ) [] [] [2023-08-16 22:15:22] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-000000000000202022.1.4.104712023-08-16T22:15:22.179Z2023-08-16T22:20:22.179Z0No Errorf4bada30-e0f6-498f-8817-cc83d7eaa93fmariano.rossin@gmail.comMarianoRossina41d5d54-be35-4645-8ce3-e0a145c923a66106-05-25T07:00:00"} [] [2023-08-16 22:15:23] dev.INFO: API Request Auth: {"context":"\nmariano.rossin@gmail.coma41d5d54-be35-4645-8ce3-e0a145c923a6\n"} [] [2023-08-16 22:15:25] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.4.104712023-08-16T22:15:25.193Z2023-08-16T22:20:25.193Z0No ErrorFirm Prueba Mariano
Los Ceibos 2731San Jose of The CornerTX23121US
3425290600
"} [] [2023-08-16 22:15:25] dev.INFO: API Request Auth: {"context":"\nmariano.rossin@gmail.coma41d5d54-be35-4645-8ce3-e0a145c923a6f4bada30-e0f6-498f-8817-cc83d7eaa93f\n"} [] [2023-08-16 22:15:27] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.4.104712023-08-16T22:15:27.245Z2023-08-16T22:20:27.245Z0No Errormariano.rossin@gmail.comMarianoJorgeRossin2023-08-16T22:15:22.087falsefalse"} []