invoices columns: Array ( [0] => Array ( [Field] => id [Type] => int(11) unsigned [Null] => NO [Key] => PRI [Default] => [Extra] => auto_increment ) [1] => Array ( [Field] => number [Type] => varchar(20) [Null] => YES [Key] => [Default] => [Extra] => ) [2] => Array ( [Field] => user_id [Type] => int(11) unsigned [Null] => NO [Key] => MUL [Default] => 0 [Extra] => ) [3] => Array ( [Field] => user_data [Type] => text [Null] => YES [Key] => [Default] => [Extra] => ) [4] => Array ( [Field] => cdate [Type] => datetime [Null] => NO [Key] => [Default] => 1881-05-19 00:00:00 [Extra] => ) [5] => Array ( [Field] => duedate [Type] => datetime [Null] => NO [Key] => [Default] => 1881-05-19 00:00:00 [Extra] => ) [6] => Array ( [Field] => datepaid [Type] => datetime [Null] => NO [Key] => [Default] => 1881-05-19 00:00:00 [Extra] => ) [7] => Array ( [Field] => refunddate [Type] => datetime [Null] => NO [Key] => [Default] => 1881-05-19 00:00:00 [Extra] => ) [8] => Array ( [Field] => local [Type] => int(1) unsigned [Null] => NO [Key] => [Default] => 0 [Extra] => ) [9] => Array ( [Field] => legal [Type] => int(1) unsigned [Null] => NO [Key] => [Default] => [Extra] => ) [10] => Array ( [Field] => taxed [Type] => int(1) unsigned [Null] => NO [Key] => [Default] => 0 [Extra] => ) [11] => Array ( [Field] => taxed_file [Type] => text [Null] => YES [Key] => [Default] => [Extra] => ) [12] => Array ( [Field] => data [Type] => text [Null] => YES [Key] => [Default] => [Extra] => ) [13] => Array ( [Field] => status [Type] => varchar(40) [Null] => NO [Key] => [Default] => ghost [Extra] => ) [14] => Array ( [Field] => currency [Type] => int(3) unsigned [Null] => NO [Key] => [Default] => 0 [Extra] => ) [15] => Array ( [Field] => taxation_type [Type] => varchar(50) [Null] => NO [Key] => [Default] => exclusive [Extra] => ) [16] => Array ( [Field] => taxrate [Type] => decimal(10,2) [Null] => NO [Key] => [Default] => 0.00 [Extra] => ) [17] => Array ( [Field] => tax [Type] => decimal(10,4) [Null] => NO [Key] => [Default] => 0.0000 [Extra] => ) [18] => Array ( [Field] => subtotal [Type] => decimal(10,4) [Null] => NO [Key] => [Default] => 0.0000 [Extra] => ) [19] => Array ( [Field] => total [Type] => decimal(10,4) [Null] => NO [Key] => [Default] => 0.0000 [Extra] => ) [20] => Array ( [Field] => recurring [Type] => int(1) unsigned [Null] => NO [Key] => [Default] => 0 [Extra] => ) [21] => Array ( [Field] => recurring_time [Type] => int(6) unsigned [Null] => NO [Key] => [Default] => 0 [Extra] => ) [22] => Array ( [Field] => recurring_period [Type] => varchar(10) [Null] => NO [Key] => [Default] => none [Extra] => ) [23] => Array ( [Field] => discounts [Type] => text [Null] => YES [Key] => [Default] => [Extra] => ) [24] => Array ( [Field] => used_coupons [Type] => varchar(300) [Null] => YES [Key] => [Default] => [Extra] => ) [25] => Array ( [Field] => used_promotions [Type] => varchar(300) [Null] => YES [Key] => [Default] => [Extra] => ) [26] => Array ( [Field] => sendbta [Type] => int(1) unsigned [Null] => NO [Key] => [Default] => 0 [Extra] => ) [27] => Array ( [Field] => sendbta_amount [Type] => decimal(10,4) [Null] => NO [Key] => [Default] => 0.0000 [Extra] => ) [28] => Array ( [Field] => pmethod [Type] => varchar(50) [Null] => NO [Key] => [Default] => none [Extra] => ) [29] => Array ( [Field] => pmethod_commission [Type] => decimal(10,4) [Null] => NO [Key] => [Default] => 0.0000 [Extra] => ) [30] => Array ( [Field] => pmethod_commission_rate [Type] => decimal(10,2) unsigned [Null] => NO [Key] => [Default] => 0.00 [Extra] => ) [31] => Array ( [Field] => pmethod_status [Type] => varchar(50) [Null] => YES [Key] => [Default] => none [Extra] => ) [32] => Array ( [Field] => pmethod_msg [Type] => varchar(255) [Null] => YES [Key] => [Default] => [Extra] => ) [33] => Array ( [Field] => notes [Type] => text [Null] => YES [Key] => [Default] => [Extra] => ) [34] => Array ( [Field] => unread [Type] => int(1) unsigned [Null] => NO [Key] => [Default] => 0 [Extra] => ) ) Last 5 Invoices: Array ( [0] => Array ( [id] => 3862 [number] => INV-260709201814-80 [user_id] => 467 [user_data] => {"id":467} [cdate] => 2026-07-09 20:18:14 [duedate] => 2026-07-09 20:18:14 [datepaid] => 1881-05-19 00:00:00 [refunddate] => 1881-05-19 00:00:00 [local] => 1 [legal] => 1 [taxed] => 1 [taxed_file] => [data] => [status] => unpaid [currency] => 147 [taxation_type] => exclusive [taxrate] => 20.00 [tax] => 279.0005 [subtotal] => 1395.0026 [total] => 1674.0031 [recurring] => 0 [recurring_time] => 0 [recurring_period] => none [discounts] => [] [used_coupons] => [used_promotions] => [sendbta] => 0 [sendbta_amount] => 0.0000 [pmethod] => none [pmethod_commission] => 0.0000 [pmethod_commission_rate] => 0.00 [pmethod_status] => none [pmethod_msg] => [notes] => [unread] => 0 ) [1] => Array ( [id] => 3861 [number] => INV-260709195925-69 [user_id] => 467 [user_data] => {"id":467} [cdate] => 2026-07-09 19:59:25 [duedate] => 2026-07-09 19:59:25 [datepaid] => 1881-05-19 00:00:00 [refunddate] => 1881-05-19 00:00:00 [local] => 1 [legal] => 1 [taxed] => 1 [taxed_file] => [data] => [status] => unpaid [currency] => 147 [taxation_type] => exclusive [taxrate] => 20.00 [tax] => 102.2754 [subtotal] => 511.3769 [total] => 613.6523 [recurring] => 0 [recurring_time] => 0 [recurring_period] => none [discounts] => [] [used_coupons] => [used_promotions] => [sendbta] => 0 [sendbta_amount] => 0.0000 [pmethod] => none [pmethod_commission] => 0.0000 [pmethod_commission_rate] => 0.00 [pmethod_status] => none [pmethod_msg] => [notes] => [unread] => 0 ) [2] => Array ( [id] => 3860 [number] => INV-260709195437-45 [user_id] => 467 [user_data] => {"id":467} [cdate] => 2026-07-09 19:54:37 [duedate] => 2026-07-09 19:54:37 [datepaid] => 1881-05-19 00:00:00 [refunddate] => 1881-05-19 00:00:00 [local] => 1 [legal] => 1 [taxed] => 1 [taxed_file] => [data] => [status] => unpaid [currency] => 147 [taxation_type] => exclusive [taxrate] => 20.00 [tax] => 0.0000 [subtotal] => 511.3769 [total] => 511.3769 [recurring] => 0 [recurring_time] => 0 [recurring_period] => none [discounts] => [] [used_coupons] => [used_promotions] => [sendbta] => 0 [sendbta_amount] => 0.0000 [pmethod] => none [pmethod_commission] => 0.0000 [pmethod_commission_rate] => 0.00 [pmethod_status] => none [pmethod_msg] => [notes] => [unread] => 0 ) [3] => Array ( [id] => 3859 [number] => INV-260709194642-53 [user_id] => 467 [user_data] => {"id":467} [cdate] => 2026-07-09 19:46:42 [duedate] => 2026-07-09 19:46:42 [datepaid] => 1881-05-19 00:00:00 [refunddate] => 1881-05-19 00:00:00 [local] => 1 [legal] => 1 [taxed] => 1 [taxed_file] => [data] => [status] => unpaid [currency] => 147 [taxation_type] => exclusive [taxrate] => 20.00 [tax] => 0.0000 [subtotal] => 511.3769 [total] => 511.3769 [recurring] => 0 [recurring_time] => 0 [recurring_period] => none [discounts] => [] [used_coupons] => [used_promotions] => [sendbta] => 0 [sendbta_amount] => 0.0000 [pmethod] => none [pmethod_commission] => 0.0000 [pmethod_commission_rate] => 0.00 [pmethod_status] => none [pmethod_msg] => [notes] => [unread] => 0 ) [4] => Array ( [id] => 3858 [number] => INV-260709194248-74 [user_id] => 467 [user_data] => {"id":467} [cdate] => 2026-07-09 19:42:48 [duedate] => 2026-07-09 19:42:48 [datepaid] => 1881-05-19 00:00:00 [refunddate] => 1881-05-19 00:00:00 [local] => 1 [legal] => 1 [taxed] => 1 [taxed_file] => [data] => [status] => unpaid [currency] => 147 [taxation_type] => exclusive [taxrate] => 20.00 [tax] => 0.0000 [subtotal] => 511.3769 [total] => 511.3769 [recurring] => 0 [recurring_time] => 0 [recurring_period] => none [discounts] => [] [used_coupons] => [used_promotions] => [sendbta] => 0 [sendbta_amount] => 0.0000 [pmethod] => none [pmethod_commission] => 0.0000 [pmethod_commission_rate] => 0.00 [pmethod_status] => none [pmethod_msg] => [notes] => [unread] => 0 ) )