a:2:{i:0;a:2:{s:6:"schema";O:18:"yii\db\TableSchema":7:{s:10:"schemaName";N;s:4:"name";s:17:"commercial_config";s:8:"fullName";s:17:"commercial_config";s:10:"primaryKey";a:1:{i:0;s:2:"id";}s:12:"sequenceName";s:0:"";s:11:"foreignKeys";a:0:{}s:7:"columns";a:29:{s:2:"id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:2:"id";s:9:"allowNull";b:0;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:3:"int";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:1;s:13:"autoIncrement";b:1;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:7:"vat_pct";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:7:"vat_pct";s:9:"allowNull";b:0;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"decimal(5,2)";s:12:"defaultValue";s:5:"15.00";s:10:"enumValues";N;s:4:"size";i:5;s:9:"precision";i:5;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:20:"Saudi VAT percentage";s:18:"disableJsonSupport";b:0;}s:17:"marketing_fee_pct";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:17:"marketing_fee_pct";s:9:"allowNull";b:0;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"decimal(5,2)";s:12:"defaultValue";s:4:"0.00";s:10:"enumValues";N;s:4:"size";i:5;s:9:"precision";i:5;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:23:"Navagoo marketing fee %";s:18:"disableJsonSupport";b:0;}s:18:"processing_fee_pct";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:18:"processing_fee_pct";s:9:"allowNull";b:0;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"decimal(5,2)";s:12:"defaultValue";s:4:"0.00";s:10:"enumValues";N;s:4:"size";i:5;s:9:"precision";i:5;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:24:"Payment processing fee %";s:18:"disableJsonSupport";b:0;}s:13:"fixed_fee_sar";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:13:"fixed_fee_sar";s:9:"allowNull";b:0;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(10,2)";s:12:"defaultValue";s:4:"0.00";s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:31:"Fixed fee per transaction (SAR)";s:18:"disableJsonSupport";b:0;}s:21:"min_marketing_fee_sar";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:21:"min_marketing_fee_sar";s:9:"allowNull";b:0;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(10,2)";s:12:"defaultValue";s:4:"0.00";s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:33:"Minimum marketing fee floor (SAR)";s:18:"disableJsonSupport";b:0;}s:15:"max_deposit_pct";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:15:"max_deposit_pct";s:9:"allowNull";b:0;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:16:"tinyint unsigned";s:12:"defaultValue";i:100;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:1;s:7:"comment";s:33:"Max deposit as % of booking value";s:18:"disableJsonSupport";b:0;}s:18:"min_withdrawal_sar";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:18:"min_withdrawal_sar";s:9:"allowNull";b:0;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(10,2)";s:12:"defaultValue";s:7:"5000.00";s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:31:"Minimum withdrawal amount (SAR)";s:18:"disableJsonSupport";b:0;}s:23:"carry_forward_threshold";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:23:"carry_forward_threshold";s:9:"allowNull";b:0;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(10,2)";s:12:"defaultValue";s:4:"0.00";s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:54:"Balance below this carries forward instead of settling";s:18:"disableJsonSupport";b:0;}s:16:"invoice_due_days";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:16:"invoice_due_days";s:9:"allowNull";b:0;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:16:"tinyint unsigned";s:12:"defaultValue";i:30;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:1;s:7:"comment";s:25:"Days until invoice is due";s:18:"disableJsonSupport";b:0;}s:20:"settlement_hold_days";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:20:"settlement_hold_days";s:9:"allowNull";b:0;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:16:"tinyint unsigned";s:12:"defaultValue";i:7;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:1;s:7:"comment";s:37:"Days funds are held before settlement";s:18:"disableJsonSupport";b:0;}s:17:"grace_window_days";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:17:"grace_window_days";s:9:"allowNull";b:0;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:16:"tinyint unsigned";s:12:"defaultValue";i:3;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:1;s:7:"comment";s:34:"Grace period days for late payment";s:18:"disableJsonSupport";b:0;}s:20:"max_shop_cancel_days";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:20:"max_shop_cancel_days";s:9:"allowNull";b:0;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:16:"tinyint unsigned";s:12:"defaultValue";i:0;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:1;s:7:"comment";s:55:"Max days shop can cancel without penalty (0 = no limit)";s:18:"disableJsonSupport";b:0;}s:23:"subscription_grace_days";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:23:"subscription_grace_days";s:9:"allowNull";b:0;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:16:"tinyint unsigned";s:12:"defaultValue";i:0;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:1;s:7:"comment";s:56:"Days after an unpaid due charge before the account locks";s:18:"disableJsonSupport";b:0;}s:18:"default_trial_days";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:18:"default_trial_days";s:9:"allowNull";b:0;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:16:"tinyint unsigned";s:12:"defaultValue";i:0;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:1;s:7:"comment";s:59:"Fallback free-period when a plan omits its own trial length";s:18:"disableJsonSupport";b:0;}s:14:"sms_sell_price";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"sms_sell_price";s:9:"allowNull";b:0;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"decimal(8,4)";s:12:"defaultValue";s:6:"0.0000";s:10:"enumValues";N;s:4:"size";i:8;s:9:"precision";i:8;s:5:"scale";i:4;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:32:"SMS sell price per message (SAR)";s:18:"disableJsonSupport";b:0;}s:14:"sms_cost_price";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"sms_cost_price";s:9:"allowNull";b:0;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"decimal(8,4)";s:12:"defaultValue";s:6:"0.0000";s:10:"enumValues";N;s:4:"size";i:8;s:9:"precision";i:8;s:5:"scale";i:4;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:32:"SMS cost price per message (SAR)";s:18:"disableJsonSupport";b:0;}s:15:"sms_fail_refund";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:15:"sms_fail_refund";s:9:"allowNull";b:1;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"decimal(8,4)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:8;s:9:"precision";i:8;s:5:"scale";i:4;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:70:"Refund per FAILED SMS (SAR); NULL=code default, 0=provider bills fails";s:18:"disableJsonSupport";b:0;}s:14:"sms_free_month";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"sms_free_month";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:12:"int unsigned";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:1;s:7:"comment";s:46:"Free SMS per shop per month; NULL=code default";s:18:"disableJsonSupport";b:0;}s:13:"wa_sell_price";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:13:"wa_sell_price";s:9:"allowNull";b:0;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"decimal(8,4)";s:12:"defaultValue";s:6:"0.0000";s:10:"enumValues";N;s:4:"size";i:8;s:9:"precision";i:8;s:5:"scale";i:4;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:37:"WhatsApp sell price per message (SAR)";s:18:"disableJsonSupport";b:0;}s:13:"wa_cost_price";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:13:"wa_cost_price";s:9:"allowNull";b:0;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"decimal(8,4)";s:12:"defaultValue";s:6:"0.0000";s:10:"enumValues";N;s:4:"size";i:8;s:9:"precision";i:8;s:5:"scale";i:4;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:37:"WhatsApp cost price per message (SAR)";s:18:"disableJsonSupport";b:0;}s:14:"wa_fail_refund";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"wa_fail_refund";s:9:"allowNull";b:1;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"decimal(8,4)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:8;s:9:"precision";i:8;s:5:"scale";i:4;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:79:"Refund per FAILED WhatsApp msg (SAR); NULL=code default, 0=provider bills fails";s:18:"disableJsonSupport";b:0;}s:13:"wa_free_month";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:13:"wa_free_month";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:12:"int unsigned";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:1;s:7:"comment";s:56:"Free WhatsApp msgs per shop per month; NULL=code default";s:18:"disableJsonSupport";b:0;}s:10:"updated_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"updated_at";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:3:"int";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:10:"updated_by";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"updated_by";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:3:"int";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:21:"subscription_pay_card";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:21:"subscription_pay_card";s:9:"allowNull";b:0;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:10:"tinyint(1)";s:12:"defaultValue";i:1;s:10:"enumValues";N;s:4:"size";i:1;s:9:"precision";i:1;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:36:"Shops may pay a subscription by card";s:18:"disableJsonSupport";b:0;}s:30:"subscription_pay_bank_transfer";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:30:"subscription_pay_bank_transfer";s:9:"allowNull";b:0;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:10:"tinyint(1)";s:12:"defaultValue";i:1;s:10:"enumValues";N;s:4:"size";i:1;s:9:"precision";i:1;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:45:"Shops may pay a subscription by bank transfer";s:18:"disableJsonSupport";b:0;}s:15:"freeze_list_cap";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:15:"freeze_list_cap";s:9:"allowNull";b:0;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:3:"int";s:12:"defaultValue";i:2000;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:87:"NVG-BEA-005: global default freeze-list entry cap, overridable via shop.freeze_list_cap";s:18:"disableJsonSupport";b:0;}s:14:"max_group_size";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"max_group_size";s:9:"allowNull";b:0;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:3:"int";s:12:"defaultValue";i:10;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:64:"NVG-BEA-011: platform default max participants per group booking";s:18:"disableJsonSupport";b:0;}}}s:12:"cacheVersion";i:1;}i:1;O:25:"yii\caching\TagDependency":3:{s:4:"data";a:1:{s:32:"8acc260eb18a90ef8e1e2ac3ed1a4e99";s:21:"0.45856200 1781042842";}s:8:"reusable";b:0;s:4:"tags";s:32:"8be6b63a26b15c2f12d384a84f8beb8c";}}