a:2:{i:0;a:2:{s:6:"schema";O:18:"yii\db\TableSchema":7:{s:10:"schemaName";N;s:4:"name";s:12:"mjbk_invoice";s:8:"fullName";s:12:"mjbk_invoice";s:10:"primaryKey";a:1:{i:0;s:2:"id";}s:12:"sequenceName";s:0:"";s:11:"foreignKeys";a:0:{}s:7:"columns";a:34:{s:2:"id";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;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:10:"created_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:10:"created_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:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";}s:18:"is_associated_with";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:18:"is_associated_with";s:9:"allowNull";b:0;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"tinyint";s:12:"defaultValue";i:1;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:22:"0 -> Case, 1 -> Client";}s:7:"case_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:7:"case_id";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:17:"user_address_type";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:17:"user_address_type";s:9:"allowNull";b:0;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"tinyint";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:18:"1 - User, 2 - Firm";}s:15:"user_address_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:15:"user_address_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:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:38:"reference to mjbk_company_address's id";}s:9:"client_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:9:"client_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:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";}s:16:"client_full_name";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:16:"client_full_name";s:9:"allowNull";b:1;s:4:"type";s:6:"binary";s:7:"phpType";s:8:"resource";s:6:"dbType";s:14:"varbinary(255)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:255;s:9:"precision";i:255;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:12:"client_email";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:12:"client_email";s:9:"allowNull";b:1;s:4:"type";s:6:"binary";s:7:"phpType";s:8:"resource";s:6:"dbType";s:14:"varbinary(255)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:255;s:9:"precision";i:255;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:16:"client_mobile_no";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:16:"client_mobile_no";s:9:"allowNull";b:1;s:4:"type";s:6:"binary";s:7:"phpType";s:8:"resource";s:6:"dbType";s:14:"varbinary(255)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:255;s:9:"precision";i:255;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:14:"client_address";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:14:"client_address";s:9:"allowNull";b:1;s:4:"type";s:6:"binary";s:7:"phpType";s:8:"resource";s:6:"dbType";s:4:"blob";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:12:"client_gstin";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:12:"client_gstin";s:9:"allowNull";b:1;s:4:"type";s:6:"binary";s:7:"phpType";s:8:"resource";s:6:"dbType";s:14:"varbinary(255)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:255;s:9:"precision";i:255;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:25:"GST Identification Number";}s:10:"client_pan";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:10:"client_pan";s:9:"allowNull";b:1;s:4:"type";s:6:"binary";s:7:"phpType";s:8:"resource";s:6:"dbType";s:14:"varbinary(255)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:255;s:9:"precision";i:255;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:17:"Client PAN Number";}s:5:"title";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:5:"title";s:9:"allowNull";b:0;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"varchar(255)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:255;s:9:"precision";i:255;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:7:"subject";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:7:"subject";s:9:"allowNull";b:1;s:4:"type";s:6:"binary";s:7:"phpType";s:8:"resource";s:6:"dbType";s:4:"blob";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:14:"invoice_number";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:14:"invoice_number";s:9:"allowNull";b:0;s:4:"type";s:6:"binary";s:7:"phpType";s:8:"resource";s:6:"dbType";s:14:"varbinary(255)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:255;s:9:"precision";i:255;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:9:"sub_total";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:9:"sub_total";s:9:"allowNull";b:0;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(16,2)";s:12:"defaultValue";s:4:"0.00";s:10:"enumValues";N;s:4:"size";i:16;s:9:"precision";i:16;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";}s:10:"tax_amount";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:10:"tax_amount";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:0:"";}s:12:"total_amount";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:12:"total_amount";s:9:"allowNull";b:0;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(16,2)";s:12:"defaultValue";s:4:"0.00";s:10:"enumValues";N;s:4:"size";i:16;s:9:"precision";i:16;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";}s:11:"amount_paid";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:11:"amount_paid";s:9:"allowNull";b:1;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(16,2)";s:12:"defaultValue";s:4:"0.00";s:10:"enumValues";N;s:4:"size";i:16;s:9:"precision";i:16;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";}s:10:"issue_date";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:10:"issue_date";s:9:"allowNull";b:0;s:4:"type";s:8:"datetime";s:7:"phpType";s:6:"string";s:6:"dbType";s:8:"datetime";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:15:"notes_to_client";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:15:"notes_to_client";s:9:"allowNull";b:0;s:4:"type";s:6:"binary";s:7:"phpType";s:8:"resource";s:6:"dbType";s:4:"blob";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:13:"email_subject";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:13:"email_subject";s:9:"allowNull";b:1;s:4:"type";s:6:"binary";s:7:"phpType";s:8:"resource";s:6:"dbType";s:14:"varbinary(255)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:255;s:9:"precision";i:255;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:10:"email_body";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:10:"email_body";s:9:"allowNull";b:1;s:4:"type";s:6:"binary";s:7:"phpType";s:8:"resource";s:6:"dbType";s:8:"longblob";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:6:"status";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:6:"status";s:9:"allowNull";b:1;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"tinyint";s:12:"defaultValue";i:1;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:19:"1 - Draft, 2 - Sent";}s:14:"payment_status";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:14:"payment_status";s:9:"allowNull";b:1;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"tinyint";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:0;s:7:"comment";s:38:"0-No Payment, 1-Partially Paid, 2-Paid";}s:17:"include_signature";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:17:"include_signature";s:9:"allowNull";b:0;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"tinyint";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:0;s:7:"comment";s:15:"0 - No, 1 - Yes";}s:15:"terms_condition";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:15:"terms_condition";s:9:"allowNull";b:0;s:4:"type";s:6:"binary";s:7:"phpType";s:8:"resource";s:6:"dbType";s:4:"blob";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:12:"bank_details";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:12:"bank_details";s:9:"allowNull";b:0;s:4:"type";s:6:"binary";s:7:"phpType";s:8:"resource";s:6:"dbType";s:4:"blob";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:13:"internal_note";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:13:"internal_note";s:9:"allowNull";b:0;s:4:"type";s:6:"binary";s:7:"phpType";s:8:"resource";s:6:"dbType";s:4:"blob";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:15:"place_of_supply";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:15:"place_of_supply";s:9:"allowNull";b:0;s:4:"type";s:6:"binary";s:7:"phpType";s:8:"resource";s:6:"dbType";s:4:"blob";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:10:"created_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:10:"created_at";s:9:"allowNull";b:0;s:4:"type";s:9:"timestamp";s:7:"phpType";s:6:"string";s:6:"dbType";s:9:"timestamp";s:12:"defaultValue";s:19:"0000-00-00 00:00:00";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:10:"updated_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:10:"updated_at";s:9:"allowNull";b:0;s:4:"type";s:9:"timestamp";s:7:"phpType";s:6:"string";s:6:"dbType";s:9:"timestamp";s:12:"defaultValue";s:19:"0000-00-00 00:00:00";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:15:"last_updated_by";O:25:"yii\db\mysql\ColumnSchema":15:{s:18:"disableJsonSupport";b:0;s:4:"name";s:15:"last_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:12:"cacheVersion";i:1;}i:1;O:25:"yii\caching\TagDependency":3:{s:4:"tags";s:32:"bf2589a174cf81d4c264cda96caf1b12";s:4:"data";a:1:{s:35:"mmle3024cef410bee0d6a79cd53e0dd2e45";s:21:"0.91601600 1784539640";}s:8:"reusable";b:0;}}