ALTER TABLE `shifts` ADD `total_deposits` DOUBLE NOT NULL DEFAULT '0' AFTER `total_cash`; ALTER TABLE `barcodes` ADD `max_stock` BIGINT NOT NULL DEFAULT '1' AFTER `pieces_count`, ADD `total_sales` BIGINT NOT NULL DEFAULT '0' AFTER `max_stock`; //update v 1.0 CREATE TABLE drafts ( draft_id INT PRIMARY KEY AUTO_INCREMENT, branch_id INT DEFAULT 0, screen_code VARCHAR(100) DEFAULT NULL, form_data JSON DEFAULT NULL, add_user INT DEFAULT 0, add_date DATETIME DEFAULT NOW(), active TINYINT DEFAULT 1, disable_user INT DEFAULT 0, disable_date DATETIME DEFAULT NULL ); ALTER TABLE `users` ADD `monitor_sales_price` TINYINT(1) NOT NULL DEFAULT '1' AFTER `pos`; //update v1.0.1 20/8/2023 INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '1', 'W_Vat', 'ضريبة الأجور', 'W_Vat', 'number', '0', '', '12,6,4', '1', '0', '0', '1', '1'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '1', 'S_Vat', 'ضريبة الخدمات', 'Services_Vat', 'number', '0', '', '12,6,4', '1', '0', '0', '1', '1'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '1', 'C26 VAT', 'ضريبة الحجر', 'Stone_Vat', 'number', '0', '', '12,6,4', '1', '0', '0', '1', '1'); //updates v 1.0.2 ALTER TABLE `deposit_codes` CHANGE `name_ar` `name_ar` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL; ALTER TABLE `deposit_codes` CHANGE `name_en` `name_en` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL; //update 24/8/2023 ALTER TABLE `map_departments` CHANGE `add_date` `add_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP; // updates 27/8/2023 ALTER TABLE `pieces_transfer_m` CHANGE `pieces_transfer_description` `pieces_transfer_description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL; UPDATE `screen_subs` SET `screen_sub_title_ar` = 'فواتير المبيعات' WHERE `screen_subs`.`screen_sub_id` = 78; ALTER TABLE `barcodes` ADD `is_locked` TINYINT(1) NOT NULL DEFAULT '0' AFTER `out_type`; //updates for pieces cracking 9/19/2023 CREATE TABLE `pieces_cracking_m` (`pieces_cracking_m_id` INT(11) NOT NULL AUTO_INCREMENT , `branch_id` INT(11) NULL DEFAULT NULL , `finance_year_id` INT(11) NULL DEFAULT NULL , `year_ser` INT(11) NULL DEFAULT NULL , `month_ser` INT(11) NULL DEFAULT NULL , `branch_ser` INT(11) NULL DEFAULT NULL , `daily_journal_m_id` INT(11) NULL DEFAULT NULL , `action_date` DATE NULL DEFAULT NULL , `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `active` TINYINT(1) NOT NULL DEFAULT '1' , `add_user` INT(11) NULL DEFAULT NULL , `add_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `disable_user` INT(11) NULL DEFAULT NULL , `disable_date` DATETIME NULL DEFAULT NULL , PRIMARY KEY (`pieces_cracking_m_id`)) ENGINE = InnoDB; CREATE TABLE `pieces_cracking_d` (`pieces_cracking_d_id` INT(11) NOT NULL AUTO_INCREMENT , `pieces_cracking_m_id` INT(11) NULL DEFAULT NULL , `barcode_id` INT(11) NULL DEFAULT NULL , `category_id` INT(11) NULL DEFAULT NULL , `from_item_id` INT(11) NULL DEFAULT NULL , `to_item_id` INT(11) NULL DEFAULT NULL , `from_weight` DOUBLE NOT NULL DEFAULT '0' , `to_weight` DOUBLE NOT NULL DEFAULT '0' , `gen_barcode` TINYINT(1) NOT NULL DEFAULT '0' , PRIMARY KEY (`pieces_cracking_d_id`)) ENGINE = InnoDB; //update pieces cracking 9/20/2023 ALTER TABLE `pieces_cracking_d` ADD `lobe_weight` DOUBLE NOT NULL DEFAULT '0' AFTER `to_weight`; //updates 27/9/2023 CREATE TABLE `wholesale_transfers_m` (`wholesale_transfer_m_id` INT(11) NOT NULL AUTO_INCREMENT , `sub_category_id` INT(11) NOT NULL DEFAULT '0' , `category_id` INT(11) NOT NULL DEFAULT '0' , `from_supplier_id` INT(11) NOT NULL DEFAULT '0' , `to_supplier_id` INT(11) NOT NULL DEFAULT '0' , `branch_id` INT(11) NOT NULL DEFAULT '0' , `finance_year_id` INT(11) NOT NULL DEFAULT '0' , `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , `active` TINYINT(1) NOT NULL DEFAULT '1' , `action_date` DATE NULL DEFAULT NULL , `add_user` INT(11) NULL DEFAULT '0' , `add_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `disable_user` INT(11) NULL DEFAULT '0' , `disable_date` DATETIME NULL DEFAULT NULL , PRIMARY KEY (`wholesale_transfer_m_id`)) ENGINE = InnoDB; CREATE TABLE `wholesale_transfers_d` ( `wholesale_transfer_d_id` INT(11) NOT NULL AUTO_INCREMENT , `wholesale_transfer_m_id` INT(11) NOT NULL DEFAULT '0' , `amount` DOUBLE NOT NULL DEFAULT '0' , `sub_category_id` INT(11) NOT NULL DEFAULT '0' , PRIMARY KEY (`wholesale_transfer_d_id`)) ENGINE = InnoDB; ALTER TABLE `wholesale_transfers_d` ADD `category_id` INT(11) NOT NULL DEFAULT '0' AFTER `sub_category_id`; ALTER TABLE `wholesale_transfers_d` ADD `weight` INT(11) NOT NULL DEFAULT '0' AFTER `amount`; ALTER TABLE `wholesale_transfers_m` ADD `invoice_id` INT NOT NULL DEFAULT '0' AFTER `description`; ALTER TABLE `map_sub_categorys` ADD `is_barcode` TINYINT(1) NOT NULL DEFAULT '0' AFTER `publish`; //updates 2/10/2023 ALTER TABLE `payment_gold_permissions` ADD `shift_id` INT(11) NOT NULL DEFAULT '0' AFTER `customer_id`; ALTER TABLE `receipt_gold_permissions` ADD `shift_id` INT(11) NOT NULL DEFAULT '0' AFTER `customer_id`; ALTER TABLE `shifts` ADD `gold_permissions` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `calibers_data`; // update 8/10/2023 ALTER TABLE `map_sub_categorys` ADD `is_package` TINYINT(1) NOT NULL DEFAULT '0' AFTER `is_barcode`, ADD `package_ids` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `is_package`; //update 12/10/2023 ALTER TABLE `branchs` ADD `weighing_machine` TINYINT(1) NOT NULL DEFAULT '0' AFTER `stock_watch`; ALTER TABLE `used_purchases_d` ADD `diff_weight` DOUBLE NULL DEFAULT '0' AFTER `used_weight`; //update 15/10/2023 ALTER TABLE `users` ADD `super_admin` TINYINT(1) NOT NULL DEFAULT '0' AFTER `monitor_sales_price`; //updates 16/10/2023 RENAME TABLE `payment_gold_permissions` TO `payment_gold_permissions_m`; CREATE TABLE `payment_gold_permissions_d` (`payment_gold_permission_d_id` INT NOT NULL AUTO_INCREMENT , `payment_gold_permission_m_id` INT NOT NULL , `barcode_id` INT NOT NULL DEFAULT '0' , `category_id` INT NOT NULL DEFAULT '0' , `sub_category_id` INT NOT NULL DEFAULT '0' , `weight` DOUBLE NOT NULL DEFAULT '0' , `weight_in_24` DOUBLE NOT NULL DEFAULT '0' , `wages` DOUBLE NOT NULL DEFAULT '0' , `total_wages` DOUBLE NOT NULL DEFAULT '0' , PRIMARY KEY (`payment_gold_permission_d_id`)) ENGINE = InnoDB; RENAME TABLE `receipt_gold_permissions` TO `receipt_gold_permissions_m`; CREATE TABLE `receipt_gold_permissions_d` (`receipt_gold_permission_d_id` INT NOT NULL AUTO_INCREMENT , `receipt_gold_permission_m_id` INT NOT NULL , `barcode_id` INT NOT NULL DEFAULT '0' , `category_id` INT NOT NULL DEFAULT '0' , `sub_category_id` INT NOT NULL DEFAULT '0' , `weight` DOUBLE NOT NULL DEFAULT '0' , `weight_in_24` DOUBLE NOT NULL DEFAULT '0' , `wages` DOUBLE NOT NULL DEFAULT '0' , `total_wages` DOUBLE NOT NULL DEFAULT '0' , PRIMARY KEY (`receipt_gold_permission_d_id`)) ENGINE = InnoDB; ALTER TABLE `receipt_gold_permissions_m` ADD `debit_account_tree_id` INT NOT NULL DEFAULT '0' AFTER `daily_journal_id`; ALTER TABLE `barcodes` ADD `parent_barcode` INT NOT NULL DEFAULT '0' AFTER `barcode_id`; ALTER TABLE `purchase_invoice_d` ADD `pack_items` JSON NULL DEFAULT NULL AFTER `total_with_vat`; //update 22/10/2023 ALTER TABLE `used_purchases_m` CHANGE `sales_gent_id` `sales_agent_id` INT NOT NULL DEFAULT '0'; //update 24/10/2023 CREATE TABLE `manufacturing_m` (`manufacturing_m_id` INT NOT NULL AUTO_INCREMENT , `branch_id` INT NOT NULL DEFAULT '0' , `supplier_id` INT NOT NULL DEFAULT '0' , `finance_year_id` INT NOT NULL DEFAULT '0' , `year_ser` INT NOT NULL DEFAULT '0' , `month_ser` INT NOT NULL DEFAULT '0' , `branch_ser` INT NOT NULL DEFAULT '0' , `description` TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL , `action_date` DATE NULL DEFAULT NULL , `source_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '1=>closing , 2=>used' , `source_m_id` INT NOT NULL DEFAULT '0' , `status` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '1=>pensing , 2=>received' , `daily_journal_m_id` INT NOT NULL DEFAULT '0' , `active` TINYINT(1) NOT NULL DEFAULT '1' , `add_user` INT NOT NULL DEFAULT '0' , `add_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `disable_date` DATETIME NULL DEFAULT NULL , `disable_user` INT NOT NULL DEFAULT '0' , PRIMARY KEY (`manufacturing_m_id`)) ENGINE = InnoDB; CREATE TABLE `manufacturing_d` (`manufacturing_d_id` INT NOT NULL AUTO_INCREMENT , `manufacturing_m_id` INT NOT NULL DEFAULT '0' , `source_d_id` INT NOT NULL DEFAULT '0' , `barcode_id` INT NOT NULL DEFAULT '0' , `category_id` INT NOT NULL DEFAULT '0' , `sub_category_id` INT NOT NULL DEFAULT '0' , `manufacture_type` TINYINT(1) NULL DEFAULT '1' COMMENT '1=>exported ,2=>imported' , `weight` DOUBLE NOT NULL DEFAULT '0' , `price` DOUBLE NOT NULL DEFAULT '0' , `pieces_count` INT NOT NULL DEFAULT '0' , `wages` DOUBLE NOT NULL DEFAULT '0' , PRIMARY KEY (`manufacturing_d_id`)) ENGINE = InnoDB; ALTER TABLE `manufacturing_m` ADD `received_date` DATETIME NULL DEFAULT NULL AFTER `action_date`; ALTER TABLE `purchase_invoice_m` ADD `diamond_invoice` TINYINT(1) NOT NULL DEFAULT '0' AFTER `purchase_invoice_type`; ALTER TABLE `manufacturing_d` ADD `purchase_invoice_d_id` INT NOT NULL DEFAULT '0' AFTER `source_d_id`, ADD `sales_invoice_d_id` INT NOT NULL DEFAULT '0' AFTER `purchase_invoice_d_id`; ALTER TABLE `manufacturing_m` ADD `sales_invoice_m_id` INT NOT NULL DEFAULT '0' AFTER `source_m_id`, ADD `purchase_invoice_m_id` INT NOT NULL DEFAULT '0' AFTER `sales_invoice_m_id`; ALTER TABLE `purchase_invoice_m` CHANGE `purchase_invoice_type` `purchase_invoice_type` INT(11) NOT NULL DEFAULT '1' COMMENT ' 1=>اجور و خامات ,2=>اجور , 3=>الماس, 4=>تصنيع\r\n'; ALTER TABLE `purchase_invoice_d` ADD `factor` INT NOT NULL DEFAULT '1' AFTER `sub_category_id`; ALTER TABLE `purchase_invoice_d` ADD `min_sell_price` DOUBLE NOT NULL DEFAULT '0' AFTER `factor`; //////////////// ALTER TABLE `suppliers` CHANGE `type` `type` INT NULL DEFAULT '1'; //updates 5/11/2023 ALTER TABLE `purchase_invoice_d` ADD `package_weight` DOUBLE NOT NULL DEFAULT '0' AFTER `stone_weight`; ALTER TABLE `barcodes` ADD `package_weight` DOUBLE NOT NULL DEFAULT '0' AFTER `stone_weight`; ALTER TABLE `stocktaking_m` ADD `all_codes` LONGTEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL AFTER `stocktaking_type`, ADD `unknown_codes` LONGTEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL AFTER `all_codes`, ADD `missing` LONGTEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL AFTER `unknown_codes`; ALTER TABLE `stocktaking_m` CHANGE `all_codes` `all_items` LONGTEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL; ALTER TABLE `stocktaking_m` CHANGE `unknown_codes` `unknown_items` LONGTEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL; ALTER TABLE `stocktaking_m` CHANGE `missing` `missing_items` LONGTEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL; ALTER TABLE `metal_transfers_m` ADD `description` TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL AFTER `action_date`; ALTER TABLE `sales_agents` CHANGE `add_date` `add_date` DATETIME NULL DEFAULT CURRENT_TIMESTAMP; ALTER TABLE `manufacturing_m` DROP `source_type`; ALTER TABLE `manufacturing_d` DROP `source_d_id`; ALTER TABLE `manufacturing_d` ADD `supplier_id` INT NOT NULL DEFAULT '0' AFTER `sales_invoice_d_id`, ADD `source_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '1=>closing , 2=>used' AFTER `supplier_id`; ALTER TABLE `map_sub_categorys` ADD `average_purchase_cost` DOUBLE NOT NULL DEFAULT '0' AFTER `package_ids`; ALTER TABLE `manufacturing_d` CHANGE `price` `total_price` DOUBLE NOT NULL DEFAULT '0'; ALTER TABLE `manufacturing_d` ADD `caliber_price` DOUBLE NOT NULL DEFAULT '0' AFTER `weight`; ALTER TABLE `manufacturing_d` ADD `reciept_voucher_gold_d_id` INT NOT NULL DEFAULT '0' AFTER `sales_invoice_d_id`; ALTER TABLE `receipt_vouchers_gold_m` ADD `auto_generate` TINYINT(1) NOT NULL DEFAULT '0' AFTER `receipt_voucher_active`; ALTER TABLE `manufacturing_m` ADD `reciept_voucher_gold_m_id` INT NOT NULL DEFAULT '0' AFTER `purchase_invoice_m_id`; ALTER TABLE `manufacturing_m` CHANGE `status` `status` TINYINT NOT NULL DEFAULT '1' COMMENT '1=>pensing , 2=>received , 3=>closed'; //updates in sub_category ALTER TABLE `map_sub_categorys` ADD `purchases_revenue_id` INT NOT NULL DEFAULT '0' AFTER `package_ids`, ADD `purchases_return_id` INT NOT NULL DEFAULT '0' AFTER `purchases_revenue_id`, ADD `purchases_discount_id` INT NOT NULL DEFAULT '0' AFTER `purchases_return_id`, ADD `sales_revenue_id` INT NOT NULL DEFAULT '0' AFTER `purchases_discount_id`, ADD `sales_return_id` INT NOT NULL DEFAULT '0' AFTER `sales_revenue_id`, ADD `sales_discount_id` INT NOT NULL DEFAULT '0' AFTER `sales_return_id`; ALTER TABLE `map_sub_categorys` ADD `tax_id` INT NOT NULL DEFAULT '0' AFTER `sales_discount_id`; INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'item_default_purchases_revenue', 'حساب ايراد المشتريات', 'حساب ايراد المشتريات', 'select', '21', 'accounts', '12,6,4', '0', '0', '0', '1', '10'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'item_default_sales_revenue', 'حساب ايراد المبيعات', 'حساب ايراد المبيعات', 'select', '21', 'accounts', '12,6,4', '0', '0', '0', '1', '10'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'item_default_sales_return', 'حساب مرتد المبيعات', 'حساب مرتد المبيعات', 'select', '21', 'accounts', '12,6,4', '0', '0', '0', '1', '10'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'item_default_purchases_return', 'حساب مرتد المشتريات', 'حساب مرتد المشتريات', 'select', '21', 'accounts', '12,6,4', '0', '0', '0', '1', '10'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'item_default_sales_discount', 'حساب خصوم المبيعات', 'حساب خصوم المبيعات', 'select', '21', 'accounts', '12,6,4', '0', '0', '0', '1', '10'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'item_default_purchases_discount', 'حساب خصوم المشتريات', 'حساب خصوم المشتريات', 'select', '21', 'accounts', '12,6,4', '0', '0', '0', '1', '10'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'item_default_vat', 'الضريبه الافتراضيه', 'الضريبه الافتراضيه', 'select', '21', 'accounts', '12,6,4', '0', '0', '0', '1', '10'); ALTER TABLE `manufacturing_d` CHANGE `reciept_voucher_gold_d_id` `reciept_gold_m_id` INT NOT NULL DEFAULT '0'; ALTER TABLE `purchase_invoice_m` ADD `auto_generated` TINYINT(1) NOT NULL DEFAULT '0' AFTER `remaining`; ALTER TABLE `q_sales_invoice_m` ADD `auto_generated` TINYINT(1) NOT NULL DEFAULT '0' AFTER `total_paid`; ALTER TABLE `receipt_gold_permissions_m` ADD `auto_generated` TINYINT(1) NOT NULL DEFAULT '0' AFTER `total_wages`; ALTER TABLE `metal_transfers_d` ADD `caliber_price` DOUBLE NOT NULL DEFAULT '0' AFTER `caliber_id`; ALTER TABLE `metal_transfers_m` CHANGE `action_date` `action_date` DATE NOT NULL; ALTER TABLE `purchase_invoice_d` CHANGE `previous_return` `previous_weight_return` DOUBLE NULL DEFAULT '0'; ALTER TABLE `purchase_invoice_d` ADD `previous_price_return` DOUBLE NOT NULL AFTER `previous_weight_return`; ALTER TABLE `purchase_invoice_d` CHANGE `previous_price_return` `previous_price_return` DOUBLE NOT NULL DEFAULT '0'; ALTER TABLE `purchase_invoice_d` CHANGE `previous_weight_return` `previous_return_weight` DOUBLE NULL DEFAULT '0'; ALTER TABLE `purchase_invoice_d` CHANGE `previous_price_return` `previous_return_price` DOUBLE NOT NULL DEFAULT '0'; ALTER TABLE `purchase_invoice_d` ADD `current_price` DOUBLE NULL DEFAULT NULL AFTER `total_with_vat`, ADD `current_vat` DOUBLE NULL DEFAULT NULL AFTER `current_price`, ADD `current_without_vat` DOUBLE NULL DEFAULT NULL AFTER `current_vat`, ADD `current_with_vat` DOUBLE NULL DEFAULT NULL AFTER `current_without_vat`; ALTER TABLE `return_purchase_invoice_d` ADD `returned_price` DOUBLE NULL DEFAULT '0' AFTER `remaining_weight`, ADD `returned_vat` DOUBLE NULL DEFAULT '0' AFTER `returned_price`, ADD `returned_with_vat` DOUBLE NULL DEFAULT '0' AFTER `returned_vat`, ADD `returned_without_vat` DOUBLE NULL DEFAULT '0' AFTER `returned_with_vat`, ADD `remaining_price` DOUBLE NULL DEFAULT '0' AFTER `returned_without_vat`; ALTER TABLE `return_purchase_invoice_m` ADD `returned_price` DOUBLE NOT NULL DEFAULT '0' AFTER `returned_weight`; //updates 22/11/2023 ALTER TABLE `purchase_invoice_m` ADD `is_totals` TINYINT(1) NOT NULL DEFAULT '0' AFTER `auto_generated`; ALTER TABLE `purchase_invoice_d` ADD `total_barcodes_weight` DOUBLE NOT NULL DEFAULT '0' AFTER `pack_items`; // don all mahmoud 27-11-2023 //updates 28/11/2023 ALTER TABLE `payment_vouchers_gold_m` CHANGE `description` `description` TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL; //updates 10/12/2023 CREATE TABLE `coupons` (`coupon_id` INT NOT NULL AUTO_INCREMENT , `coupon_code` VARCHAR(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL , `coupon_type` TINYINT(1) NOT NULL DEFAULT '1' , `start_date` DATE NULL DEFAULT NULL , `end_date` DATE NULL DEFAULT NULL , `categories` TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL , `sub_categories` TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL , `customers_id` INT NULL DEFAULT NULL , `for_customer` TINYINT(1) NOT NULL DEFAULT '0' , `allowed_count` INT NOT NULL DEFAULT '1' , `active` TINYINT(1) NOT NULL DEFAULT '1' , `discount` DOUBLE NOT NULL DEFAULT '0' , `discount_type` TINYINT(1) NOT NULL DEFAULT '1' , `add_user` INT NULL DEFAULT NULL , `add_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `disable_date` DATETIME NULL DEFAULT NULL , `disable_user` INT NULL DEFAULT NULL , PRIMARY KEY (`coupon_id`)) ENGINE = InnoDB; ALTER TABLE `q_sales_invoice_m` ADD `coupon_id` INT NULL DEFAULT NULL AFTER `invoice_code`; ALTER TABLE `coupons` CHANGE `discount_type` `discount_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '1=>wages , 2=>total'; ALTER TABLE `coupons` CHANGE `coupon_type` `coupon_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '1=>percentage , 2=>value'; ALTER TABLE `coupons` CHANGE `customers_id` `customers_id` TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL; ALTER TABLE `coupons` CHANGE `categories` `categories_id` TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL; ALTER TABLE `coupons` CHANGE `sub_categories` `sub_categories_id` TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL; ALTER TABLE `coupons` ADD `minimum` DOUBLE NOT NULL DEFAULT '0' AFTER `coupon_type`; ALTER TABLE `q_sales_invoice_d` ADD `discount_value` DOUBLE NULL DEFAULT '0' AFTER `discount`, ADD `discount_percentage` DOUBLE NOT NULL DEFAULT '0' AFTER `discount_value`; ALTER TABLE `coupons` CHANGE `coupon_type` `coupon_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '2=>percentage , 1=>value'; ALTER TABLE `coupons` ADD `items` TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL AFTER `sub_categories_id`; // don all mahmoud 17-12-2023 ALTER TABLE `closing_transfers_d` ADD `price` DOUBLE NOT NULL DEFAULT '0' AFTER `weight`; ALTER TABLE `closing_transfers_d` ADD `total_price` DOUBLE NOT NULL DEFAULT '0' AFTER `price`; ALTER TABLE `closing_transfers_m` ADD `daily_journal_id` INT NOT NULL DEFAULT '0' AFTER `finance_year_id`; //fix sales_invoice update issues in barcode (notice) UPDATE `barcodes` SET `total_sales` = 0 WHERE `barcodes`.`out_id` = 0 or `barcodes`.`out_id` is null; ALTER TABLE `q_sales_invoice_m` ADD `is_transfered` TINYINT(1) NOT NULL DEFAULT '0' AFTER `treasury_id`; CREATE TABLE `new_shifts` (`shift_id` INT NOT NULL AUTO_INCREMENT , `user_id` INT NOT NULL , `branch_id` INT NOT NULL , `start_date` DATETIME NULL DEFAULT NULL , `end_date` DATETIME NULL DEFAULT NULL , `end_payments` JSON NULL DEFAULT NULL , `final_gold` JSON NULL DEFAULT NULL , `total_cash_actions` JSON NULL DEFAULT NULL , `diff_payments` JSON NULL DEFAULT NULL , `diff_calibers` JSON NULL DEFAULT NULL , `sales_data` JSON NULL DEFAULT NULL , PRIMARY KEY (`shift_id`)) ENGINE = InnoDB; ALTER TABLE `new_shifts` ADD `start_data` JSON NULL DEFAULT NULL AFTER `end_date`; ALTER TABLE `new_shifts` ADD `used_purchase` JSON NULL DEFAULT NULL AFTER `sales_data`, ADD `used_sales` JSON NULL DEFAULT NULL AFTER `used_purchase`, ADD `receipt_gold` JSON NULL DEFAULT NULL AFTER `used_sales`, ADD `payment_gold` JSON NULL DEFAULT NULL AFTER `receipt_gold`, ADD `end_data` JSON NULL DEFAULT NULL AFTER `payment_gold`; ALTER TABLE `q_sales_invoice_m` ADD `is_transfered` TINYINT(1) NULL DEFAULT '0' AFTER `treasury_id`; ALTER TABLE `q_sales_invoice_m` ADD `is_special` TINYINT(1) NOT NULL DEFAULT '0' AFTER `is_transfered`; ALTER TABLE `manufacturing_d` ADD `profit_margin` DOUBLE NOT NULL DEFAULT '0' AFTER `manufacture_type`, ADD `min_profit_margin` DOUBLE NOT NULL DEFAULT '0' AFTER `profit_margin`; INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '1', 'SALES_NOTE', 'ملاحظات المبيعات', 'Sales Notes', 'number', '0', '', '12,6,4', '1', '0', '0', '1', '1'); //updates 8/1/2024 INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'collection_Cheque', ' تحصيل الشيكات', 'collection Cheque', 'select', '0', 'accounts', '12,6,4', '1', '0', '0', '1', '1'); ALTER TABLE `branchs` ADD `branch_protected` TINYINT(1) NOT NULL DEFAULT '0' AFTER `users`, ADD `password` INT NULL DEFAULT NULL AFTER `branch_protected`; INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'whatsapp_msg', 'رسالة واتساب', 'Whatsapp message', 'radiogroup', '1', 'list', '12,6,4', '1', '0', '0', '1', '1'); INSERT INTO `q_sales_invoice_d`(`sales_invoice_d_id`, `sales_invoice_m_id`, `item_id`, `table_id`, `item_code`, `category_id`, `sub_category_id`, `caliber_price`, `purchase_cost`, `org_sell_cost`, `sell_cost`, `discount`, `discount_value`, `discount_percentage`, `weight`, `count_pieces`, `total_purchase_cost`, `total_sell_cost`, `total_org_sell_cost`, `total_discount`, `quality_id`, `clarity_id`, `color_id`, `shap_id`, `stone_id`, `gold_weight`, `diamond_weight`, `stone_weight`, `stone_type`, `caliber_id`, `count_diamonds`, `price`, `vat_per`, `total_vat`, `grand_total`, `add_date`, `add_user`, `base_price`, `returned_pieces`, `returned_weight`, `current_price`, `current_vat`, `current_grand_total`, `current_weight`, `current_pieces`, `lobes`, `notes`, `wages_price`, `total_wages`, `total_wages_vat`, `total_wages_with_vat`, `total_raw`, `total_raw_vat`, `total_raw_with_vat`, `calibration`, `calibration_m`, `calibration_d`) SELECT * FROM qaraterp_v2_1045.`q_sales_invoice_d` WHERE `sales_invoice_d_id` not in ( select `sales_invoice_d_id` from qaraterp_v2_5045 .q_sales_invoice_d); INSERT INTO `q_sales_invoice_m`(`sales_invoice_m_id`, `finance_year_id`, `branch_id`, `daily_journal_id`, `invoice_date`, `customer_id`, `customer_name`, `customer_mobile`, `customer_email`, `invoice_code`, `coupon_id`, `doc_id`, `invoice_active`, `total_weight`, `total_raw_amount`, `total_raw_vat`, `total_purchase_cost`, `total_sell_cost`, `total_org_sell_cost`, `total_cost_amount`, `total_cost_vat`, `grand_total`, `grand_total_vat`, `total_discount`, `final_total`, `total_paid`, `auto_generated`, `add_date`, `add_user`, `payment_method`, `paid_cash`, `paid_bank`, `paid_trans`, `close_day`, `sales_agent_id`, `shift_id`, `supplier_id`, `invoice_type`, `is_wholesale`, `wholesale_type`, `treasury_id`, `is_transfered`, `is_special`) SELECT * FROM qaraterp_v2_1045.`q_sales_invoice_m` WHERE `sales_invoice_m_id` not in ( select `sales_invoice_m_id` from qaraterp_v2_5045 .q_sales_invoice_m); INSERT INTO `q_sales_invoice_payments`(`sales_invoice_payment_id`, `sales_invoice_m_id`, `machine_id`, `card_type`, `payment_type`, `amount`) SELECT * FROM qaraterp_v2_1045.`q_sales_invoice_payments` WHERE `sales_invoice_payment_id` not in ( select `sales_invoice_payment_id` from qaraterp_v2_5045 .q_sales_invoice_payments); INSERT INTO `daily_journal_m`(`daily_journal_m_id`, `branch_id`, `finance_year_id`, `year_ser`, `month_ser`, `branch_ser`, `description`, `journal_date`, `daily_type_id`, `document_id`, `auto_generated`, `add_user`, `add_date`, `journal_active`, `confirmed`, `confirmed_by`, `confirmed_date`, `disable_date`, `disable_user`) SELECT * FROM qaraterp_v2_1045.`daily_journal_m` WHERE `daily_journal_m_id` not in ( select `daily_journal_m_id` from qaraterp_v2_5045 .daily_journal_m); INSERT INTO `daily_journal_d`(`daily_journal_d_id`, `daily_journal_m_id`, `account_tree_id`, `cost_centers`, `debit`, `credit`, `description`, `attach_path`, `attach_ext`) SELECT * FROM qaraterp_v2_1045.`daily_journal_d` WHERE `daily_journal_d_id` not in ( select `daily_journal_d_id` from qaraterp_v2_5045 .daily_journal_d); INSERT INTO `notice_creditors_m`(`notice_creditor_m_id`, `sales_invoice_m_id`, `customer_id`, `finance_year_id`, `branch_id`, `daily_journal_id`, `invoice_date`, `invoice_ser`, `branch_ser`, `month_ser`, `shift_id`, `notice_creditor_active`, `add_date`, `add_user`, `sales_invoice_type`, `payment_type_id`, `machine_id`, `sales_agent_id`) SELECT * FROM qaraterp_v2_1045.`notice_creditors_m` WHERE `notice_creditor_m_id` not in ( select `notice_creditor_m_id` from qaraterp_v2_5045 .notice_creditors_m); INSERT INTO `notice_creditors_d`(`notice_creditor_d_id`, `notice_creditor_m_id`, `sales_invoice_d_id`, `category_id`, `sub_category_id`, `new_price`, `new_vat`, `new_grand_total`, `new_pieces`, `new_weight`, `old_price`, `old_vat`, `old_grand_total`, `old_pieces`, `old_weight`) SELECT * FROM qaraterp_v2_1045.`notice_creditors_d` WHERE `notice_creditor_d_id` not in ( select `notice_creditor_d_id` from qaraterp_v2_5045 .notice_creditors_d); INSERT INTO `multi_voucher_m`(`multi_voucher_m_id`, `currency_id`, `conversion_type_id`, `branch_id`, `finance_year_id`, `year_ser`, `month_ser`, `branch_ser`, `daily_journal_m_id`, `action_date`, `multi_voucher_active`, `description`, `add_date`, `add_user`, `disable_date`, `disable_user`) SELECT * FROM qaraterp_v2_1045.`multi_voucher_m` WHERE `multi_voucher_m_id` not in ( select `multi_voucher_m_id` from qaraterp_v2_5045 .multi_voucher_m); INSERT INTO `multi_voucher_d`(`multi_voucher_d_id`, `multi_voucher_m_id`, `cost_centers`, `voucher_type`, `tax_id`, `taxable`, `total_vat`, `amount_without_vat`, `amount`, `dis_type`, `dis_account_tree_id`, `dis_supplier_id`, `dis_customer_id`, `dis_bank_id`, `dis_treasury_id`, `description`, `multi_voucher_d_active`, `add_user`, `add_date`, `disable_user`, `disable_date`) SELECT * FROM qaraterp_v2_1045.`multi_voucher_d` WHERE `multi_voucher_d_id` not in ( select `multi_voucher_d_id` from qaraterp_v2_5045 .multi_voucher_d); INSERT INTO `payment_vouchers`(`payment_voucher_id`, `branch_id`, `finance_year_id`, `year_ser`, `month_ser`, `branch_ser`, `daily_journal_id`, `cost_center_id`, `action_date`, `document_number`, `to_type`, `to_account_tree_id`, `to_supplier_id`, `to_customer_id`, `delegate_id`, `from_type`, `from_account_tree_id`, `from_treasury_id`, `from_bank_id`, `due_date`, `cheque_number`, `bank_commission`, `tax_id`, `total_vat`, `amount_without_vat`, `amount`, `invoice_type`, `description`, `payment_voucher_active`, `add_date`, `add_user`, `disable_date`, `disable_user`, `pay_for`, `expense_code_id`, `shift_id`, `attach_path`, `attach_ext`) SELECT * FROM qaraterp_v2_1045.`payment_vouchers` WHERE `payment_voucher_id` not in ( select `payment_voucher_id` from qaraterp_v2_5045 .payment_vouchers); INSERT INTO `receipt_vouchers`(`receipt_voucher_id`, `branch_id`, `finance_year_id`, `year_ser`, `month_ser`, `branch_ser`, `daily_journal_id`, `cost_center_id`, `action_date`, `document_number`, `from_type`, `from_account_tree_id`, `from_supplier_id`, `from_customer_id`, `delegate_id`, `to_type`, `to_account_tree_id`, `to_treasury_id`, `to_bank_id`, `due_date`, `cheque_number`, `bank_commission`, `deposit_code_id`, `tax_id`, `total_vat`, `amount_without_vat`, `amount`, `invoice_type`, `description`, `machine_id`, `is_deposit`, `is_closed`, `receipt_voucher_active`, `add_date`, `add_user`, `disable_date`, `disable_user`, `attach_path`, `attach_ext`, `shift_id`) SELECT * FROM qaraterp_v2_1045.`receipt_vouchers` WHERE `receipt_voucher_id` not in ( select `receipt_voucher_id` from qaraterp_v2_5045 .receipt_vouchers); INSERT INTO `third_party_apps`(`app_id`, `app_name_ar`, `app_name_en`, `data`, `is_installed`, `app_token`) VALUES (null,'واتساب','whatsapp','{"instanceid":null,"token":null}',0,null) // CREATE TABLE `transfered_tables` (`id` INT NOT NULL AUTO_INCREMENT , `name_ar` VARCHAR(100) NULL DEFAULT NULL , `name_en` VARCHAR(100) NULL DEFAULT NULL , `table_name` VARCHAR(100) NULL DEFAULT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `receipt_vouchers` ADD `gold_weight` DOUBLE NOT NULL DEFAULT '0' AFTER `amount`, ADD `caliber_id` INT NOT NULL DEFAULT '0' AFTER `gold_weight`, ADD `gold_register` TINYINT(1) NOT NULL DEFAULT '0' AFTER `caliber_id`; ALTER TABLE `payment_vouchers` ADD `gold_weight` DOUBLE NOT NULL DEFAULT '0' AFTER `amount`, ADD `caliber_id` INT NOT NULL DEFAULT '0' AFTER `gold_weight`, ADD `gold_register` TINYINT(1) NOT NULL DEFAULT '0' AFTER `caliber_id`; ALTER TABLE `receipt_gold_permissions_d` ADD `factor` INT NOT NULL DEFAULT '0' AFTER `diamond_weight`, ADD `package_weight` DOUBLE NOT NULL DEFAULT '0' AFTER `factor`, ADD `sell_price` DOUBLE NOT NULL DEFAULT '0' AFTER `package_weight`, ADD `min_sell_price` DOUBLE NOT NULL DEFAULT '0' AFTER `sell_price`, ADD `supplier_code` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL AFTER `min_sell_price`; ALTER TABLE `payment_gold_permissions_d` ADD `factor` INT NOT NULL DEFAULT '0' AFTER `diamond_weight`, ADD `package_weight` DOUBLE NOT NULL DEFAULT '0' AFTER `factor`, ADD `sell_price` DOUBLE NOT NULL DEFAULT '0' AFTER `package_weight`, ADD `min_sell_price` DOUBLE NOT NULL DEFAULT '0' AFTER `sell_price`, ADD `supplier_code` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL AFTER `min_sell_price`; ALTER TABLE `payment_gold_permissions_d` ADD `stone_weight` DOUBLE NOT NULL DEFAULT '0' AFTER `gold_weight`; ALTER TABLE `receipt_gold_permissions_d` ADD `stone_weight` DOUBLE NOT NULL DEFAULT '0' AFTER `diamond_weight`; ALTER TABLE `purchase_invoice_d` ADD `current_weight` DOUBLE NOT NULL DEFAULT '0' AFTER `current_with_vat`; CREATE TABLE `barcodes_types` (`id` INT NOT NULL AUTO_INCREMENT , `name_ar` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL , `name_en` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL , `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '1=>in , 2=> out' , `value` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; INSERT INTO `barcodes_types` (`id`, `name_ar`, `name_en`, `type`, `value`) VALUES (NULL, 'فاتورة مشتريات', 'Purchase Invoice', '1', 'pr'), (NULL, 'انشاء باركود', 'Barcode Create', '1', 'cr'), (NULL, 'فاتورة مبيعات', 'Sales Invoice', '1', 'sa'), (NULL, 'مرتد مبيعات', 'Return Sales', '1', 'rs'), (NULL, 'تقطيع قطع', 'Pieces Cracking', '1', 'pieces_cracking'), (NULL, 'إذن قبض ذهب', 'Receipt Gold Permission', '1', 'receipt_gold_permission'), (NULL, 'تقطيع مشتريات', 'Cracking Purchase', '1', 'cracking_purchase'), (NULL, 'تصنيع', 'Manufacturing', '1', 'manufacturing'); INSERT INTO `barcodes_types` (`id`, `name_ar`, `name_en`, `type`, `value`) VALUES (NULL, 'طلبات سلة', 'Salla Order', '2', 'sallaOrder'), (NULL, 'انشاء باركود', 'Barcode Create', '2', 'return_purchase'), (NULL, 'فاتورة مبيعات', 'Sales Invoice', '2', 'sa'), (NULL, 'حركة جرد', 'Stocktaking', '2', 'st'), (NULL, 'تقطيع قطع', 'Pieces Cracking', '2', 'pieces_cracking'), (NULL, 'إذن صرف ذهب', 'Payemnt Gold Permission', '2', 'payment_gold_permission') ALTER TABLE `payment_gold_permissions_d` ADD `price` DOUBLE NOT NULL DEFAULT '0' AFTER `total_wages`; ALTER TABLE `receipt_gold_permissions_d` ADD `price` DOUBLE NOT NULL DEFAULT '0' AFTER `factor`; CREATE TABLE `reports_m` (`report_m_id` INT NOT NULL AUTO_INCREMENT , `name_en` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL , `name_ar` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL , `file_ar` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL , `file_en` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL , `stored_procedure` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL , `active` TINYINT(1) NOT NULL DEFAULT '1' , `add_user` INT NOT NULL DEFAULT '0' , `add_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `disable_date` DATETIME NULL DEFAULT NULL , `disable_user` INT NOT NULL DEFAULT '0',PRIMARY KEY (`report_m_id`) ) ENGINE = InnoDB; ALTER TABLE `reports_m` ADD `screen_main_id` INT NOT NULL DEFAULT '0' AFTER `stored_procedure`; CREATE TABLE `reports_d` (`report_d_id` INT NOT NULL AUTO_INCREMENT , `report_m_id` INT NOT NULL , `name_ar` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL , `name_en` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL , `value` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL , `lookup` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL , `data_type` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL , `required` TINYINT(1) NOT NULL DEFAULT '0' , `report_order` INT NULL DEFAULT NULL , PRIMARY KEY (`report_d_id`)) ENGINE = InnoDB; ALTER TABLE `reports_d` ADD `input_type` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL AFTER `data_type`, ADD `input_default` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL AFTER `input_type`; ALTER TABLE `reports_d` CHANGE `lookup` `lookup` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL; INSERT INTO `screen_subs` (`screen_sub_id`, `screen_cat_id`, `screen_code`, `screen_sub_title_en`, `screen_sub_title_ar`, `screen_sub_active`, `add_date`, `add_user`, `disable_date`, `disable_user`, `actions`, `url`, `screen_sub_order`, `screen`, `stock_type`) VALUES (NULL, NULL, '15-001', 'Report Configuration', 'إعداد التقارير', '1', '2024-02-14 11:23:13', '1', NULL, NULL, '1,2,3,4,5', '/reports', '8', '1', NULL); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'payment_gold_journal', 'قيد صرف ذهب', 'payment gold journal', 'radiogroup', '1', 'list', '12,6,4', '1', '0', '0', '1', '1'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'payment_voucher_gold_journal', 'قيد سند صرف ذهب', 'payment voucher gold journal', 'radiogroup', '1', 'list', '12,6,4', '1', '0', '0', '1', '1'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'receipt_gold_journal', 'قيد قبض ذهب', 'receipt gold journal', 'radiogroup', '1', 'list', '12,6,4', '1', '0', '0', '1', '1'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'receipt_voucher_gold_journal', 'قيد سند قبض ذهب', 'receipt voucher gold journal', 'radiogroup', '1', 'list', '12,6,4', '1', '0', '0', '1', '1'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'return_purchase_journal', 'قيد مرتد المشتريات', 'return purchase journal', 'radiogroup', '1', 'list', '12,6,4', '1', '0', '0', '1', '1'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'closing_transfer_journal', 'قيد تحويل التسكيرات', 'closing transfer journal', 'radiogroup', '1', 'list', '12,6,4', '1', '0', '0', '1', '1'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'sales_cosing_journal', 'قيد مبيعات التسكيرات', 'closing sales journal', 'radiogroup', '1', 'list', '12,6,4', '1', '0', '0', '1', '1'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'wholesales_journal', 'قيد مبيعات الجملة', 'wholesales sales journal', 'radiogroup', '1', 'list', '12,6,4', '1', '0', '0', '1', '1'); ALTER TABLE `map_categorys` ADD `sales_barcode` TINYINT(1) NOT NULL DEFAULT '0' AFTER `category_image`; INSERT INTO `map_departments` (`department_id`, `department_title_ar`, `department_title_en`, `department_image`, `department_order`, `add_date`, `add_user`, `department_active`) VALUES (NULL, 'فضة', 'Silver', NULL, '1', CURRENT_TIMESTAMP, '1', '1') INSERT INTO `map_categorys` (`category_id`, `department_id`, `category_title_ar`, `category_title_en`, `category_det_ar`, `category_det_en`, `category_image`, `sales_barcode`, `category_active`, `add_user`, `add_date`, `category_order`) VALUES ('925', '5', 'فضة', 'Silver', NULL, NULL, '', '0', '1', '1', '2024-02-25 12:13:28.000000', '8') CREATE TABLE `models` (`model_id` INT NOT NULL AUTO_INCREMENT , `name_en` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL , `name_ar` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL , `model` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL , `helper` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL , `record_id` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL , `date_name` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL , PRIMARY KEY (`model_id`)) ENGINE = InnoDB; ALTER TABLE `notice_creditors_m` ADD `is_transfered` TINYINT(1) NOT NULL DEFAULT '0' AFTER `sales_agent_id`; CREATE TABLE `screens` (`screen_id` INT NOT NULL AUTO_INCREMENT , `name_ar` VARCHAR(100) NULL DEFAULT NULL , `name_en` VARCHAR(100) NULL DEFAULT NULL , `parent_id` INT NULL DEFAULT NULL , `screen_type` TINYINT NULL DEFAULT '1' , `screen_code` VARCHAR(100) NULL DEFAULT NULL , `screen_actions` VARCHAR(100) NULL DEFAULT NULL , `end_point` VARCHAR(100) NULL DEFAULT NULL , `active` TINYINT(1) NOT NULL DEFAULT '1' , `add_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `add_user` INT NULL DEFAULT NULL , `disable_date` DATETIME NULL DEFAULT NULL , `disable_user` INT NULL DEFAULT NULL , PRIMARY KEY (`screen_id`)) ENGINE = InnoDB; ALTER TABLE `screens` ADD `url` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL AFTER `end_point`, ADD `icon` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL AFTER `url`, ADD `active_icon` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL AFTER `icon`, ADD `actions` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL AFTER `active_icon`; ALTER TABLE `financial_collections` ADD `balance_type` INT(1) NOT NULL DEFAULT '3' COMMENT '1 first , 2 in time , last' AFTER `is_print`; // update 22/4/2023 ALTER TABLE `third_party` ADD `slug` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci AFTER `app_name`; // update 30/04/2024 ALTER TABLE `map_sub_categorys` ADD `sales_tax_id` INT(11) NOT NULL DEFAULT '0' AFTER `tax_id`, ADD `purchase_tax_id` INT(11) NOT NULL DEFAULT '0' AFTER `sales_tax_id`; // 01/05/2024 CREATE TABLE `wholesale_invoice_types` ( `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, `name_en` varchar(255) NOT NULL, `name_ar` varchar(255) NOT NULL, `active` tinyint(1) NOT NULL DEFAULT 1, `add_date` datetime NOT NULL DEFAULT current_timestamp(), `add_user` int(11) NOT NULL DEFAULT 1, `disable_date` datetime DEFAULT NULL, `disable_user` int(11) DEFAULT NULL ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci; CREATE TABLE `wholesale_payment_methods` ( `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, `name_en` varchar(255) NOT NULL, `name_ar` varchar(255) NOT NULL, `active` tinyint(1) NOT NULL DEFAULT 1, `add_date` datetime NOT NULL DEFAULT current_timestamp(), `add_user` int(11) NOT NULL DEFAULT 1, `disable_date` datetime DEFAULT NULL, `disable_user` int(11) DEFAULT NULL ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci; CREATE TABLE `wholesale_purchase_places` ( `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, `name_en` varchar(255) NOT NULL, `name_ar` varchar(255) NOT NULL, `active` tinyint(1) NOT NULL DEFAULT 1, `add_date` datetime NOT NULL DEFAULT current_timestamp(), `add_user` int(11) NOT NULL DEFAULT 1, `disable_date` datetime DEFAULT NULL, `disable_user` int(11) DEFAULT NULL ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci; CREATE TABLE `wholesale_sales_invoice_m` ( `wholesale_sales_invoice_m_id` INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, `finance_year_id` INT(11) NOT NULL, `year_ser` INT(11) NOT NULL, `month_ser` INT(11) NOT NULL, `branch_ser` INT(11) NOT NULL, `branch_id` INT(11) NOT NULL, `daily_journal_id` INT(11) NOT NULL, `invoice_type_id` INT(11) NOT NULL, `customer_id` INT(11) NOT NULL DEFAULT '0', `supplier_id` INT(11) NOT NULL DEFAULT '0', `payment_method_id` INT(11) NOT NULL, `purchase_place_id` INT(11) NOT NULL, `tax_id` INT(11) NOT NULL, `action_date` DATE DEFAULT NULL, `gold_price_18` DOUBLE NOT NULL DEFAULT '0', `gold_price_21` DOUBLE NOT NULL DEFAULT '0', `gold_price_22` DOUBLE NOT NULL DEFAULT '0', `gold_price_24` DOUBLE NOT NULL DEFAULT '0', `description` TEXT NOT NULL, `active` BOOLEAN NOT NULL DEFAULT TRUE, `add_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `add_user` INT(11) NOT NULL DEFAULT '1', `disable_date` DATETIME NULL DEFAULT NULL, `disable_user` INT(11) NULL DEFAULT NULL ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci; CREATE TABLE `wholesale_sales_invoice_d` ( `wholesale_sales_invoice_d_id` INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, `wholesale_sales_invoice_m_id` INT(11) NOT NULL, `category_id` INT(11) NULL DEFAULT NULL, `sub_category_id` INT(11) NULL DEFAULT NULL, `payment_caliber` DOUBLE NOT NULL DEFAULT '0', `weight` DOUBLE NOT NULL DEFAULT '0', `weight_without_packet` DOUBLE NOT NULL DEFAULT '0', `wages` DOUBLE NOT NULL DEFAULT '0', `total_wages` DOUBLE NOT NULL, `payment_weight` DOUBLE NOT NULL DEFAULT '0', `active` BOOLEAN NOT NULL DEFAULT TRUE, `add_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `add_user` INT(11) NOT NULL DEFAULT '1', `disable_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `disable_user` INT(11) NOT NULL DEFAULT '1' ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci; CREATE TABLE `wholesale_purchase_invoice_m` ( `wholesale_purchase_invoice_m_id` INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, `finance_year_id` INT(11) NOT NULL, `year_ser` INT(11) NOT NULL, `month_ser` INT(11) NOT NULL, `branch_ser` INT(11) NOT NULL, `branch_id` INT(11) NOT NULL, `daily_journal_id` INT(11) NOT NULL, `invoice_type_id` INT(11) NOT NULL, `customer_id` INT(11) NOT NULL DEFAULT '0', `supplier_id` INT(11) NOT NULL DEFAULT '0', `account_tree_id` INT(11) NOT NULL DEFAULT '0', `payment_method_id` INT(11) NOT NULL, `purchase_place_id` INT(11) NOT NULL, `tax_id` INT(11) NOT NULL, `action_date` DATE DEFAULT NULL, `gold_price_18` DOUBLE NOT NULL DEFAULT '0', `gold_price_21` DOUBLE NOT NULL DEFAULT '0', `gold_price_22` DOUBLE NOT NULL DEFAULT '0', `gold_price_24` DOUBLE NOT NULL DEFAULT '0', `description` TEXT NOT NULL, `active` BOOLEAN NOT NULL DEFAULT TRUE, `add_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `add_user` INT(11) NOT NULL DEFAULT '1', `disable_date` DATETIME NULL DEFAULT NULL, `disable_user` INT(11) NULL DEFAULT NULL ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci; CREATE TABLE `wholesale_purchase_invoice_d` ( `wholesale_purchase_invoice_d_id` INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, `wholesale_purchase_invoice_m_id` INT(11) NOT NULL, `category_id` INT(11) NULL DEFAULT NULL, `sub_category_id` INT(11) NULL DEFAULT NULL, `payment_caliber` DOUBLE NOT NULL DEFAULT '0', `weight` DOUBLE NOT NULL DEFAULT '0', `weight_without_packet` DOUBLE NOT NULL DEFAULT '0', `wages` DOUBLE NOT NULL DEFAULT '0', `total_wages` DOUBLE NOT NULL, `payment_weight` DOUBLE NOT NULL DEFAULT '0', `active` BOOLEAN NOT NULL DEFAULT TRUE, `add_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `add_user` INT(11) NOT NULL DEFAULT '1', `disable_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `disable_user` INT(11) NOT NULL DEFAULT '1' ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci; INSERT INTO wholesale_invoice_types (id, name_en, name_ar, active, add_date, add_user, disable_date, disable_user) VALUES (NULL, 'type 1', 'نوع 1', '1', CURRENT_TIMESTAMP, '1', NULL, NULL), (NULL, 'type 2', 'نوع 2', '1', CURRENT_TIMESTAMP, '1', NULL, NULL); INSERT INTO wholesale_payment_methods (id, name_en, name_ar, active, add_date, add_user, disable_date, disable_user) VALUES (NULL, 'type 1', 'نوع 1', '1', CURRENT_TIMESTAMP, '1', NULL, NULL), (NULL, 'type 2', 'نوع 2', '1', CURRENT_TIMESTAMP, '1', NULL, NULL); INSERT INTO wholesale_purchase_places (id, name_en, name_ar, active, add_date, add_user, disable_date, disable_user) VALUES (NULL, 'type 1', 'نوع 1', '1', CURRENT_TIMESTAMP, '1', NULL, NULL), (NULL, 'type 2', 'نوع 2', '1', CURRENT_TIMESTAMP, '1', NULL, NULL); // 2024-05-13 INSERT INTO map_departments (department_id, department_title_ar, department_title_en, department_image, department_order, add_date, add_user, department_active) VALUES (NULL, 'مواد تصنيع', 'Manufacturing materials', NULL, '', CURRENT_TIMESTAMP, '1', '1') INSERT INTO map_categorys (category_id, department_id, category_title_ar, category_title_en, category_det_ar, category_det_en, category_image, sales_barcode, category_active, add_user, add_date, category_order) VALUES ('51', '5', 'مواد تصنيع', 'Manufacturing materials', NULL, NULL, '', '0', '1', '1', '2024-05-13 11:23:19.000000', '4') // 2024-05-19 sales_invoice => branch_ser ALTER TABLE `q_sales_invoice_m` ADD `branch_ser` INT(11) NOT NULL AFTER `branch_id`; UPDATE q_sales_invoice_m AS i JOIN ( SELECT branch_id, MAX(branch_ser) AS max_branch_ser FROM q_sales_invoice_m GROUP BY branch_id ) AS subquery ON i.branch_id = subquery.branch_id SET i.branch_ser = subquery.max_branch_ser + 1; //////////////////////////////////////////////////////////////////////////////////// // 2024-05-21 //////////////////////////////////////////////////////////////////////////////////// CREATE TABLE `nationalitys` ( `nationality_id` bigint(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, `name_ar` varchar(255) DEFAULT NULL, `name_en` varchar(255) DEFAULT NULL, `nationality_order` int(11) NOT NULL DEFAULT 1, `has_additional_time` tinyint(1) DEFAULT NULL, `add_date` datetime DEFAULT current_timestamp(), `add_user` int(11) DEFAULT NULL, `nationality_active` tinyint(4) DEFAULT 1, `disable_date` datetime DEFAULT NULL, `disable_user` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; INSERT INTO `nationalitys` (`nationality_id`, `name_ar`, `name_en`, `nationality_order`, `has_additional_time`, `add_date`, `add_user`, `nationality_active`, `disable_date`, `disable_user`) VALUES (1, 'سعودي', 'Saudi', 1, NULL, '2023-05-18 12:14:33', NULL, 1, NULL, NULL), (3, 'أفغاني', 'Afghan', 1, NULL, '2023-06-13 08:58:32', 1, 1, NULL, NULL), (4, 'ألباني', 'Albanian', 1, NULL, '2023-06-13 08:58:32', 1, 1, NULL, NULL), (5, 'جزائري', 'Algerian', 1, NULL, '2023-06-13 08:58:32', 1, 1, NULL, NULL); CREATE TABLE `identity_type` ( `identity_type_id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, `name_en` varchar(255) NOT NULL, `name_ar` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT INTO `identity_type` (`identity_type_id`, `name_en`, `name_ar`) VALUES (1, 'Card', 'بطاقة'), (2, 'Driving License', 'رخصة قيادة'); ALTER TABLE `used_purchases_m` ADD `nationality_id` INT(11) NOT NULL DEFAULT '0' AFTER `shift_id`, ADD `identity_type_id` INT(11) NOT NULL DEFAULT '0' AFTER `nationality_id`; ALTER TABLE `map_categorys` ADD `selling_price_difference` DOUBLE NOT NULL DEFAULT '0' AFTER `category_order`, ADD `purchase_price_difference` DOUBLE NOT NULL DEFAULT '0' AFTER `selling_price_difference`; ALTER TABLE `users` ADD `change_sales_agents` BOOLEAN NOT NULL DEFAULT TRUE AFTER `pos`; //////////////////////////////////////////////////////////////////////////////////// // 2024-05-23 //////////////////////////////////////////////////////////////////////////////////// ALTER TABLE `stocktaking_d` ADD `item_value` DOUBLE NOT NULL DEFAULT '0' AFTER `min_sell_cost`; CREATE TABLE `payment_transaction_log` (`transaction_id` INT NOT NULL AUTO_INCREMENT , `payment_method` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL , `add_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `add_user` INT NOT NULL , `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '0=>pending , 1=>success , 2=>faild' , PRIMARY KEY (`transaction_id`)) ENGINE = InnoDB; ALTER TABLE `q_sales_invoice_m` ADD `payment_transaction_id` INT NULL DEFAULT NULL AFTER `is_special`; ALTER TABLE `users` ADD `fcm_token` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL AFTER `pos`; ALTER TABLE `users` ADD `is_nfc` TINYINT(1) NOT NULL DEFAULT '0' AFTER `add_discount`; CREATE TABLE `maintenance_m` (`maintenance_m_id` INT NOT NULL AUTO_INCREMENT , `year_ser` INT NULL DEFAULT NULL , `month_ser` INT NULL DEFAULT NULL , `branch_ser` INT NULL DEFAULT NULL , `action_date` DATE NULL DEFAULT NULL , `description` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL , `branch_id` INT NULL DEFAULT NULL , `status` TINYINT NOT NULL DEFAULT '1' COMMENT '1=>new , 2=>pending , 3=>recieved' , `finance_year_id` INT NULL DEFAULT NULL , `supplier_id` INT NULL DEFAULT NULL , `active` TINYINT(1) NOT NULL DEFAULT '1' , `add_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `add_user` INT NULL DEFAULT NULL , `disable_user` INT NULL DEFAULT NULL , `disable_date` DATETIME NULL DEFAULT NULL , `total_weight` DOUBLE NULL DEFAULT NULL , `total_vat` DOUBLE NULL DEFAULT NULL , `total_without_vat` DOUBLE NULL DEFAULT NULL , `toal_with_vat` DOUBLE NULL DEFAULT NULL , PRIMARY KEY (`maintenance_m_id`)) ENGINE = InnoDB; CREATE TABLE `maintenance_d` (`maintenance_d_id` INT NOT NULL AUTO_INCREMENT , `maintenance_m_id` INT NULL DEFAULT NULL , `barcode_id` INT NULL DEFAULT NULL , `category_id` INT NULL DEFAULT NULL , `sub_category_id` INT NULL DEFAULT NULL , `weight` DOUBLE NOT NULL DEFAULT '0' , `wages` DOUBLE NOT NULL DEFAULT '0' , `total_with_vat` DOUBLE NOT NULL DEFAULT '0' , `vat_amount` DOUBLE NOT NULL DEFAULT '0' , `tax_id` INT NULL DEFAULT NULL , PRIMARY KEY (`maintenance_d_id`)) ENGINE = InnoDB; ALTER TABLE `maintenance_m` ADD `daily_journal_m_id` INT NULL DEFAULT NULL AFTER `finance_year_id`; ALTER TABLE `maintenance_d` ADD `new_weight` DOUBLE NOT NULL DEFAULT '0' AFTER `weight`; ALTER TABLE `maintenance_d` CHANGE `weight` `old_weight` DOUBLE NOT NULL DEFAULT '0'; ALTER TABLE `maintenance_d` ADD `is_recieved` TINYINT(1) NOT NULL DEFAULT '0' AFTER `tax_id`; INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'online_branch', 'Online Branch', 'الفرع الإلكتروني', 'select', '1', 'branchs', '12,6,4', '0', '0', '0', '1', '10'); // 2024-06-04 CREATE TABLE `used_purchase_payments` ( `used_purchase_payment_id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, `used_purchase_m_id` int(11) DEFAULT NULL, `machine_id` int(11) DEFAULT NULL, `card_type` int(11) DEFAULT NULL, `payment_type` int(11) NOT NULL COMMENT '1 cash 2 bank 3 trans', `amount` double DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; // 2024-06-05 ALTER TABLE `branchs` ADD `can_received` BOOLEAN NULL DEFAULT TRUE AFTER `cr_no`; // 2024-06-27 ALTER TABLE used_purchases_m ADD version VARCHAR(50) NULL AFTER payment_method, ADD identity_expire VARCHAR(50) NULL AFTER version; // 2024-06-30 ALTER TABLE `shifts` ADD `total_sales_stc` DOUBLE NOT NULL DEFAULT '0' AFTER `total_sales_tamara`; ALTER TABLE `shifts` ADD `end_stc` DOUBLE NOT NULL DEFAULT '0' AFTER `end_tamara`; ALTER TABLE `shifts` ADD `diff_stc` DOUBLE NOT NULL DEFAULT '0' AFTER `diff_tamara`; ALTER TABLE `shifts` ADD `total_sales_nearpay` DOUBLE NOT NULL DEFAULT '0' AFTER `total_sales_tamara`; ALTER TABLE `shifts` ADD `end_nearpay` DOUBLE NOT NULL DEFAULT '0' AFTER `end_tamara`; ALTER TABLE `shifts` ADD `diff_nearpay` DOUBLE NOT NULL DEFAULT '0' AFTER `diff_tamara`; ALTER TABLE `q_sales_invoice_m` ADD `paid_nearpay` DOUBLE NOT NULL DEFAULT '0' AFTER `paid_tamara`, ADD `paid_stc` DOUBLE NOT NULL DEFAULT '0' AFTER `paid_nearpay`; ////////////// 2024-07-15 ALTER TABLE map_sub_categorys ADD COLUMN cost_identity_m_id int(11) AFTER sub_category_id; 2024-07-16 ALTER TABLE cost_identity_d ADD COLUMN discount_percentage double default(0) AFTER profit_margin_min; ALTER TABLE users ADD COLUMN cost_identity boolean default(1); 2024-07-17 CREATE TABLE `treasurys_gold` ( `treasury_id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, `treasury_name_en` varchar(50) NOT NULL, `treasury_name_ar` varchar(50) NOT NULL, `account_code` int(11) NOT NULL, `users` mediumtext DEFAULT NULL, `first_balance` float DEFAULT NULL, `first_balance_date` date DEFAULT NULL, `first_balance_type` enum('1','2') DEFAULT NULL COMMENT '1=>مدين 2=>دائن', `current_balance` float DEFAULT NULL, `current_balance_date` date DEFAULT NULL, `current_balance_type` enum('1','2') DEFAULT NULL COMMENT '1 => مدين 2 => دائن', `account_tree_id` int(11) NOT NULL, `treasury_order` int(11) NOT NULL DEFAULT 0, `add_user` int(11) NOT NULL, `add_date` datetime NOT NULL DEFAULT current_timestamp(), `treasury_active` tinyint(1) NOT NULL DEFAULT 1, `disable_user` int(11) DEFAULT NULL, `disable_date` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; 2024-07-21 CREATE TABLE `treasurys_gold_transfer` ( `transfer_id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, `branch_id` int(11) NOT NULL, `finance_year_id` int(11) NOT NULL, `daily_journal_m_id` int(11) NOT NULL DEFAULT 0, `year_ser` int(11) NOT NULL, `month_ser` int(11) NOT NULL, `branch_ser` int(11) NOT NULL, `action_date` date NOT NULL, `description` text DEFAULT NULL, `treasury_gold_from_id` int(11) NOT NULL, `treasury_gold_to_id` int(11) NOT NULL, `weight` double NOT NULL DEFAULT 0, `amount` double DEFAULT 0, `active` tinyint(1) NOT NULL DEFAULT 1, `add_date` date NOT NULL, `add_user` int(11) NOT NULL, `disable_date` date NOT NULL, `disable_user` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; 2024-07-22 ALTER TABLE `payment_gold_permissions_m` ADD `treasury_gold_id` INT(11) NULL DEFAULT 0 AFTER `credit_account_tree_id`; ALTER TABLE `receipt_gold_permissions_m` ADD `treasury_gold_id` INT(11) NULL DEFAULT 0 AFTER `debit_account_tree_id`; CREATE TABLE `pre_orders_m` (`order_id` INT NOT NULL AUTO_INCREMENT , `action_date` DATE NULL DEFAULT NULL , `description` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL , `type` TINYINT NOT NULL DEFAULT '1' COMMENT '1=>normal , 2=>salla' , `active` TINYINT NOT NULL DEFAULT '1' , `add_user` INT NULL DEFAULT NULL , `add_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `disable_user` INT NULL DEFAULT NULL , `disable_date` DATETIME NULL DEFAULT NULL , PRIMARY KEY (`order_id`)) ENGINE = InnoDB; ALTER TABLE `salla_product_variant_d` ADD `total_price` DOUBLE NOT NULL DEFAULT '0' AFTER `extra_cost`; ALTER TABLE `salla_product_images` ADD `salla_image_id` INT NULL DEFAULT NULL AFTER `product_id`; CREATE TABLE `auth_devices` (`device_id` INT NOT NULL AUTO_INCREMENT , `device` VARCHAR(100) NOT NULL , `mac_address` TEXT NOT NULL , `status` TINYINT NOT NULL DEFAULT '1' COMMENT '1=>available , 2=>not' , `fcm_token` TEXT NOT NULL , `user_id` INT NULL DEFAULT NULL , `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '1=>pos , 2=>nfc_payment' , PRIMARY KEY (`device_id`)) ENGINE = InnoDB; CREATE TABLE `invoice_temp` (`temp_id` INT NOT NULL AUTO_INCREMENT , `invoice_data` JSON NOT NULL , `type` TINYINT(1) NOT NULL COMMENT '1=>sales_invoice' , `nearpay_res` JSON NOT NULL , PRIMARY KEY (`temp_id`)) ENGINE = InnoDB; ALTER TABLE `invoice_temp` CHANGE `nearpay_res` `nearpay_res` JSON NULL DEFAULT NULL; ALTER TABLE `invoice_temp` CHANGE `type` `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '1=>sales_invoice'; ALTER TABLE `invoice_temp` ADD `invoice_id` INT NULL DEFAULT NULL AFTER `nearpay_res`; ALTER TABLE `invoice_temp` ADD `pos_token` TEXT NULL DEFAULT NULL AFTER `invoice_id`; ALTER TABLE `auth_devices` CHANGE `fcm_token` `fcm_token` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL; 2024-08-04 ALTER TABLE `payment_gold_permissions_m` ADD `treasury_gold_id` INT NULL DEFAULT NULL AFTER `daily_journal_id`, ADD `credit_treasury_gold_id` INT NULL DEFAULT NULL AFTER `treasury_gold_id`; ALTER TABLE `receipt_gold_permissions_m` ADD `treasury_gold_id` INT NULL DEFAULT NULL AFTER `daily_journal_id`, ADD `debit_treasury_gold_id` INT NULL DEFAULT NULL AFTER `treasury_gold_id`; 2024-08-05 ALTER TABLE `manufact_items` ADD `category_id` INT(11) NOT NULL AFTER `model_id`; ALTER TABLE `manufact_items` ADD `sub_category_id` INT(11) NOT NULL AFTER `category_id`; ALTER TABLE `manufact_items` ADD `action_date` DATE NULL DEFAULT NULL AFTER `sub_category_id`; ALTER TABLE `manufact_items` CHANGE `status` `status` ENUM('PENDING','CLOSED') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'PENDING'; 2024-10-01 ALTER TABLE `barcodes` ADD `updated_at` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `salla_product_id`; // edits barcodes ALTER TABLE `barcodes` ADD `in_type_id` INT NULL DEFAULT NULL AFTER `description`, ADD `out_type_id` INT NULL DEFAULT NULL AFTER `in_type_id`; INSERT INTO `barcodes_types` (`id`, `name_ar`, `name_en`, `type`, `value`) VALUES (NULL, 'التصنيع ', 'Manufact', '1', 'manufact'); CREATE TABLE `logging` ( `id` int NOT NULL, `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `payload` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `queries` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `method` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `add_user` int DEFAULT NULL, `add_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; // 2024-09-23 ALTER TABLE `cost_identity_d` CHANGE `discount_percent` `discount_percent` VARCHAR(255) NULL DEFAULT NULL; // 2024-10-02 User Purchase Setting INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '6', 'used_print', 'طباعة مشتريات الكسر', 'User Purchase Print', 'text', 'temp_1069', '', '12,6,4', '1', '0', '0', '1', '1'); // 2024-10-09 INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'Purchase account', 'حساب أجور الذهب', 'Gold Wages Account', 'select', '56', 'accounts', '12,6,4', '1', '0', '0', '1', '6'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'Gold wages account, 'حساب الجور الذهب', 'Gold Wages Account', 'select', '56', 'accounts', '12,6,4', '1', '0', '0', '1', '6'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'Purchase other account', 'حساب مشتريات أخرى', 'Other purchase Account', 'select', '56', 'accounts', '12,6,4', '1', '0', '0', '1', '6'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'Purchase diamond account', 'حساب مشتريات الألماس', 'Diamond purchase Account', 'select', '56', 'accounts', '12,6,4', '1', '0', '0', '1', '6'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'sales deposit', 'حساب العربون', 'sales deposit', 'select', '59', 'accounts', '12,6,4', '1', '0', '0', '1', '5'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'discount allowed', 'خصم مسموح به', 'Discount allowed', 'select', '59', 'accounts', '12,6,4', '1', '0', '0', '1', '5'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'Purchase VAT account', 'حساب أجور الذهب', 'Purchase VAT account, 'select', '56', 'accounts', '12,6,4', '1', '0', '0', '1', '6'); // 2024-10-07 ALTER TABLE `salla_products` ADD `website_url` VARCHAR(255) NULL DEFAULT NULL AFTER `quantity`; ALTER TABLE `salla_products` ADD `admin_url` VARCHAR(255) NULL DEFAULT NULL AFTER `website_url`; // 2024-10-08 ALTER TABLE `salla_products` ADD `caliber_id` INT NULL DEFAULT NULL AFTER `category_id`; ALTER TABLE `salla_products` ADD `extra_cost` DOUBLE NULL DEFAULT '0' AFTER `caliber_id`; ALTER TABLE `salla_products` ADD `weight` DOUBLE NOT NULL DEFAULT '0' AFTER `extra_cost`; ALTER TABLE `salla_products` ADD `wages` DOUBLE NOT NULL DEFAULT '0' AFTER `weight`; ALTER TABLE `salla_products` ADD `item_type` ENUM('qty','piece') NOT NULL DEFAULT 'piece' AFTER `wages`; 2024-10-16 INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'salla_account', 'حساب سلة', 'salla account', 'select', '59', 'accounts', '12,6,4', '0', '0', '0', '1', '10'); ALTER TABLE `q_sales_invoice_m` ADD `paid_salla` DOUBLE NOT NULL DEFAULT '0' AFTER `paid_stc`; ALTER TABLE `shifts` ADD `total_sales_salla` DOUBLE NOT NULL DEFAULT '0' AFTER `total_sales_nearpay`; ALTER TABLE `shifts` ADD `end_salla` DOUBLE NOT NULL DEFAULT '0' AFTER `end_nearpay`; ALTER TABLE `shifts` ADD `diff_salla` DOUBLE NOT NULL DEFAULT '0' AFTER `diff_nearpay`; 2024-10-22 ALTER TABLE `barcodes` ADD `size` INT UNSIGNED NULL DEFAULT NULL AFTER `action_date`; ALTER TABLE `map_sub_categorys` ADD `default_size` INT UNSIGNED NULL DEFAULT NULL AFTER `categorys`; ALTER TABLE `purchase_invoice_d` ADD `size` INT UNSIGNED NULL DEFAULT NULL AFTER `weight`; INSERT INTO `settings` (`screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES ('1', '1', 'salla_branch', 'فرع سلة', 'salla branch', 'select', '1', 'branchs', '12,6,4', '0', '0', '0', '1', '4'); CREATE TABLE `static_pages` ( `id` int NOT NULL PRIMARY KEY AUTO_INCREMENT, `code` varchar(255) COLLATE utf8mb4_general_ci NOT NULL, `text_en` text COLLATE utf8mb4_general_ci NOT NULL, `text_ar` text COLLATE utf8mb4_general_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT INTO `static_pages` (`id`, `code`, `text_en`, `text_ar`) VALUES (1, 'return_policy', 'Return Policy', 'سياسة الاسترجاع'); 2024-10-28 ALTER TABLE `barcodes` ADD `silver_weight` DOUBLE NULL DEFAULT NULL AFTER `gold_weight`; ALTER TABLE `purchase_invoice_d` ADD `silver_weight` DOUBLE NULL DEFAULT NULL AFTER `gold_weight`; 2024-10-29 INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'tabby_account', 'حساب تابي', 'tabby account', 'select', '59', 'accounts', '12,6,4', '0', '0', '0', '1', '10'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'tamara_account', 'حساب تمارا', 'tamara account', 'select', '59', 'accounts', '12,6,4', '0', '0', '0', '1', '10'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'nearpay_account', 'حساب نيرباي', 'nearpay account', 'select', '59', 'accounts', '12,6,4', '0', '0', '0', '1', '10'); INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'stc_account', 'حساب اس تي سي', 'stc account', 'select', '59', 'accounts', '12,6,4', '0', '0', '0', '1', '10'); 2024-10-30 ALTER TABLE `treasurys_gold_transfer` ADD `category_id` INT NOT NULL DEFAULT '0' AFTER `description`; ALTER TABLE `treasurys_gold_transfer` ADD `in_type` VARCHAR(255) NOT NULL AFTER `auto_generated`, ADD `in_id` INT NOT NULL AFTER `in_type`; ALTER TABLE `manufact_models` ADD `stone_weight` DOUBLE NOT NULL DEFAULT '0' AFTER `weight`; 2024-10-31 ALTER TABLE `manufact_wax_stone_d` CHANGE `pieces_count` `pieces_count` INT NOT NULL DEFAULT '0'; 2024-11-03 ALTER TABLE `manufact_d` ADD `stone_weight` DOUBLE NOT NULL DEFAULT '0' AFTER `weight`; ALTER TABLE `manufact_d` ADD `stone_sub_category_id` INT NULL DEFAULT NULL AFTER `stone_weight`; 2024-11-06 ALTER TABLE `money_transfers` CHANGE `response_date` `response_date` DATE NULL DEFAULT NULL; INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'purchse_factor', 'معامل المشتريات', 'purchse factor', 'number', '4.5', '', '12,6,4', '0', '0', '0', '1', '6'); 2024-11-11 ALTER TABLE `manufact_m` CHANGE `add_user` `add_user` INT NULL DEFAULT NULL, CHANGE `disable_date` `disable_date` DATETIME NULL DEFAULT NULL, CHANGE `disable_user` `disable_user` INT NULL DEFAULT NULL; ALTER TABLE `treasurys_gold` ADD `first_balance_18` DOUBLE NOT NULL DEFAULT '0' AFTER `first_balance`, ADD `first_balance_21` DOUBLE NOT NULL DEFAULT '0' AFTER `first_balance_18`, ADD `first_balance_22` DOUBLE NOT NULL DEFAULT '0' AFTER `first_balance_21`, ADD `first_balance_24` DOUBLE NOT NULL DEFAULT '0' AFTER `first_balance_22`; 2024-11-17 ALTER TABLE `q_sales_invoice_m` ADD `platform` VARCHAR(255) NULL DEFAULT NULL AFTER `invoice_qrcode`; ALTER TABLE `used_purchases_m` ADD `platform` VARCHAR(255) NULL DEFAULT NULL AFTER `identity_expire`; ALTER TABLE `notice_creditors_m` ADD `platform` VARCHAR(255) NULL DEFAULT NULL AFTER `invoice_qrcode`; ALTER TABLE `notice_debtors_m` ADD `platform` VARCHAR(255) NULL DEFAULT NULL AFTER `sales_agent_id`; ALTER TABLE `payment_gold_permissions_m` ADD `platform` VARCHAR(255) NULL DEFAULT NULL AFTER `is_diamond`; ALTER TABLE `receipt_gold_permissions_m` ADD `platform` VARCHAR(255) NULL DEFAULT NULL AFTER `is_diamond`; ALTER TABLE `logging` ADD `platform` VARCHAR(255) NULL DEFAULT NULL AFTER `add_date`; CREATE TABLE `complians` ( `id` int NOT NULL PRIMARY KEY AUTO_INCREMENT, `type` enum('request','complian') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'complian', `text` text COLLATE utf8mb4_general_ci NOT NULL, `answer` text COLLATE utf8mb4_general_ci, `status` enum('new','pending','no_problem','working','finish','client_reply','client_accept') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'new', `active` tinyint(1) NOT NULL DEFAULT '1', `add_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `add_user` int DEFAULT NULL, `disable_date` datetime DEFAULT NULL, `disable_user` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; CREATE TABLE `complian_files` ( `id` int NOT NULL PRIMARY KEY AUTO_INCREMENT, `complian_id` int NOT NULL, `file` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; 2024-11-18 ALTER TABLE `complians` ADD `platform_response` JSON NULL DEFAULT NULL AFTER `status`; 2024-11-19 ALTER TABLE `complian_files` ADD `file_name` VARCHAR(255) NOT NULL AFTER `file`; ALTER TABLE `complians` ADD `platform` VARCHAR(255) NULL DEFAULT NULL AFTER `status`; ALTER TABLE `customers` ADD `commercial_registration_no` VARCHAR(255) NULL DEFAULT NULL AFTER `salla_id`, ADD `black_list` BOOLEAN NOT NULL DEFAULT FALSE AFTER `commercial_registration_no`; 2024-11-21 ALTER TABLE `logging` ADD `controller` VARCHAR(255) NULL DEFAULT NULL AFTER `platform`, ADD `function` VARCHAR(255) NULL DEFAULT NULL AFTER `controller`; 2024-11-26 CREATE TABLE `countries` (`id` int NOT NULL PRIMARY KEY AUTO_INCREMENT,`name_en` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,`name_ar` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,`active` tinyint(1) NOT NULL DEFAULT '1',`add_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,`add_user` int DEFAULT NULL,`disable_date` datetime DEFAULT NULL,`disable_user` int DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; CREATE TABLE `areas` (`id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT , `country_id` INT NOT NULL , `name_en` VARCHAR(255) NOT NULL , `name_ar` VARCHAR(255) NOT NULL , `active` BOOLEAN NOT NULL DEFAULT TRUE , `add_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `add_user` INT NULL DEFAULT NULL , `disable_date` DATETIME NULL DEFAULT NULL , `disable_user` INT NULL DEFAULT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB CHARSET=utf8mb4 COLLATE utf8mb4_general_ci; CREATE TABLE `markets` (`id` int NOT NULL PRIMARY KEY AUTO_INCREMENT, `name_en` varchar(255) COLLATE utf8mb4_general_ci NOT NULL, `name_ar` varchar(255) COLLATE utf8mb4_general_ci NOT NULL, `active` tinyint(1) NOT NULL DEFAULT '1', `add_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `add_user` int DEFAULT NULL, `disable_date` datetime DEFAULT NULL, `disable_user` int DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ALTER TABLE `customers` ADD `area_id` INT NULL DEFAULT NULL AFTER `black_list`, ADD `market_id` INT NULL DEFAULT NULL AFTER `area_id`; ALTER TABLE `branchs` ADD `work_type` VARCHAR(255) NOT NULL DEFAULT '1' AFTER `can_received`; ALTER TABLE stock_initial_d DROP COLUMN wages; ALTER TABLE `stock_initial_d` ADD `sell_cost` DOUBLE NOT NULL DEFAULT '0' AFTER `wages`, ADD `min_sell_cost` DOUBLE NOT NULL DEFAULT '0' AFTER `sell_cost`; ALTER TABLE `suppliers` ADD `country_id` INT NULL DEFAULT NULL AFTER `customer_id`; ALTER TABLE `receipt_vouchers` ADD `treasury_gold_id` INT NULL DEFAULT NULL AFTER `delegate_id`; ALTER TABLE `payment_vouchers` ADD `treasury_gold_id` INT NULL DEFAULT NULL AFTER `from_treasury_id`; 2024-11-25 ALTER TABLE `logging` ADD `response` LONGTEXT NULL DEFAULT NULL AFTER `function`; 2024-11-24 ALTER TABLE `q_sales_invoice_m` ADD `latitude` DOUBLE NULL DEFAULT NULL AFTER `platform`, ADD `longitude` DOUBLE NULL DEFAULT NULL AFTER `latitude`; 2024-11-27 ALTER TABLE `stock_initial_d` ADD `supplier_id` INT NULL DEFAULT NULL AFTER `stock_initial_m_id`; CREATE TABLE `branch_types` ( `id` int NOT NULL PRIMARY KEY AUTO_INCREMENT, `name_en` varchar(255) COLLATE utf8mb4_general_ci NOT NULL, `name_ar` varchar(255) COLLATE utf8mb4_general_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT INTO `branch_types` (`id`, `name_en`, `name_ar`) VALUES (1, 'pieces', 'قطاعي'), (2, 'wholesale', 'جملة'), (3, 'manufact', 'تصنيع'); ALTER TABLE `branchs` CHANGE `work_type` `branch_type_ids` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1'; 2024-11-28 ALTER TABLE `suppliers` ADD `currency_id` INT NULL DEFAULT NULL AFTER `country_id`; 2024-12-01 ALTER TABLE `users` ADD `manufact_cost_show` BOOLEAN NOT NULL DEFAULT FALSE AFTER `cost_identity`; ALTER TABLE `users` CHANGE `manufact_cost_show` `show_cost` TINYINT(1) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `prev_show_cost` BOOLEAN NOT NULL DEFAULT FALSE AFTER `show_cost`; 2024-12-04 ALTER TABLE `map_sub_categorys` ADD `code` VARCHAR(255) NULL DEFAULT NULL AFTER `sub_category_id`; ALTER TABLE `manufact_models` ADD `model_code` VARCHAR(255) NULL DEFAULT NULL AFTER `model_id`; 2024-12-08 INSERT INTO `settings` (`setting_id`, `screen_main_id`, `setting_category_id`, `setting_code`, `setting_label_ar`, `setting_label_en`, `type`, `value`, `lookups_id`, `cols`, `required`, `multi`, `disabled`, `setting_active`, `setting_order`) VALUES (NULL, '1', '2', 'purchase_journal_review', 'مراجعة قيود المشتريات', 'Purchase Journal Review', 'radiogroup', '0', 'list', '12,6,4', '1', '0', '0', '1', '1') 2024-12-10 ALTER TABLE `q_sales_invoice_m` ADD `print_count` INT NOT NULL DEFAULT '0' AFTER `longitude`; 2024-12-15 ALTER TABLE `pieces_cracking_m` ADD `is_partial` BOOLEAN NOT NULL DEFAULT FALSE AFTER `description`; 2024-12-17 ALTER TABLE `stock_initial_d` ADD `factor` DOUBLE NOT NULL DEFAULT '0' AFTER `price`, ADD `package_weight` DOUBLE NOT NULL DEFAULT '0' AFTER `factor`, ADD `stone_weight` DOUBLE NOT NULL DEFAULT '0' AFTER `package_weight`; CREATE TABLE `barcodes_deleted` ( `barcode_id` int NOT NULL PRIMARY KEY AUTO_INCREMENT, `parent_barcode` int(11) NOT NULL DEFAULT '0', `supplier_code` varchar(100) DEFAULT NULL, `rfid` varchar(200) DEFAULT NULL, `category_id` int(11) DEFAULT NULL, `sub_category_id` int(11) DEFAULT NULL, `finance_year_id` int(11) DEFAULT NULL, `branch_id` int(11) DEFAULT NULL, `year_ser` int(11) DEFAULT NULL, `month_ser` int(11) DEFAULT NULL, `branch_ser` int(11) DEFAULT NULL, `action_date` date DEFAULT NULL, `size` int(10) UNSIGNED DEFAULT NULL, `weight` double DEFAULT NULL, `gold_weight` double DEFAULT NULL, `silver_weight` double DEFAULT NULL, `diamond_weight` double DEFAULT NULL, `stone_weight` double DEFAULT NULL, `package_weight` double NOT NULL DEFAULT '0', `barcode_caliber_price` double NOT NULL DEFAULT '0', `purchase_cost` float NOT NULL DEFAULT '0', `sell_cost` float NOT NULL DEFAULT '0', `min_sell_cost` float NOT NULL DEFAULT '0', `price` double DEFAULT NULL, `pieces_count` int(11) DEFAULT NULL, `max_stock` bigint(20) NOT NULL DEFAULT '1', `total_sales` bigint(20) NOT NULL DEFAULT '0', `caliber_id` int(11) DEFAULT NULL, `shape_id` int(11) DEFAULT NULL, `color_id` int(11) DEFAULT NULL, `quality_id` int(11) DEFAULT NULL, `clarity_id` int(11) DEFAULT NULL, `description` text, `in_type_id` int(11) DEFAULT NULL, `out_type_id` int(11) DEFAULT NULL, `in_id` int(11) DEFAULT NULL, `in_d_id` int(11) DEFAULT NULL, `in_type` varchar(100) DEFAULT NULL, `out_id` int(11) DEFAULT NULL, `out_d_id` int(11) DEFAULT NULL, `out_type` varchar(100) DEFAULT NULL, `is_locked` tinyint(1) NOT NULL DEFAULT '0', `barcode_active` tinyint(4) NOT NULL DEFAULT '1', `old_code` varchar(50) DEFAULT NULL, `add_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `add_user` int(11) DEFAULT NULL, `disable_date` datetime DEFAULT NULL, `disable_user` int(11) DEFAULT NULL, `salla_product_id` int(10) NOT NULL DEFAULT '0', `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `salla_id` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; 2024-12-23 ALTER TABLE `stock_initial_d` ADD `purchase_date` DATE NULL DEFAULT NULL AFTER `purchase_cost`; CREATE TABLE `shift_transfers` ( `shift_transfer_id` int NOT NULL PRIMARY KEY AUTO_INCREMENT, `from_shift_id` int NOT NULL, `to_shift_id` int NOT NULL, `branch_id` int DEFAULT NULL, `cash` double NOT NULL DEFAULT '0', `master` double NOT NULL DEFAULT '0', `visa` double NOT NULL DEFAULT '0', `mada` double NOT NULL DEFAULT '0', `tabby` double NOT NULL DEFAULT '0', `tamara` double NOT NULL DEFAULT '0', `stc` double NOT NULL DEFAULT '0', `nearpay` double NOT NULL DEFAULT '0', `weight_18` double NOT NULL DEFAULT '0', `weight_21` double NOT NULL DEFAULT '0', `weight_22` double NOT NULL DEFAULT '0', `weight_24` double NOT NULL DEFAULT '0', `active` tinyint(1) NOT NULL DEFAULT 1, `add_user` int NOT NULL, `add_date` datetime NULL DEFAULT NULL, `disable_user` int NOT NULL, `disable_date` datetime NULL DEFAULT NULL ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci; 2024-12-24 ALTER TABLE `stock_initial_d` ADD `size` DOUBLE NOT NULL DEFAULT '0' AFTER `weight`; 2024-12-30 INSERT INTO `manufact_steps` (`step_id`, `slug`, `screen_code`, `name_en`, `name_ar`, `account_tree_id`, `workers_count`, `next_steps`, `avg_cost`, `loss_percentage`, `endpoint`, `treasury_gold_id`, `auto_receive`, `created_transfer`, `active`) VALUES (NULL, 'laser_cut', '07-020', 'Laser Cut', 'قطع ليزر', '133', '1', '14,8,7,6,10,11,12', '1005', '5', 'laser_cut', '3', '1', '1', '1') 2024-12- ALTER TABLE `stock_initial_d` ADD `pack_items` LONGTEXT NULL DEFAULT NULL AFTER `stone_weight`; 2024-12-22 ALTER TABLE `daily_journal_m` ADD `is_transfer` BOOLEAN NOT NULL DEFAULT TRUE AFTER `auto_generated`, ADD `transfer_date` DATETIME NULL DEFAULT NULL AFTER `is_transfer` ; ALTER TABLE `daily_journal_m` ADD `transfer_user` INT NULL DEFAULT NULL AFTER `transfer_date`; 2024-12-31 ALTER TABLE `shifts` ADD `transactions` JSON NOT NULL AFTER `diff_calibers`; 2025-01-09 /***********/ // Important before Merge ALTER TABLE `receipt_vouchers` CHANGE `description` `description` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL; /***********/ /***********/ // Important before Merge ALTER TABLE `manufact_d` ADD `additional_d_weight` DOUBLE NOT NULL DEFAULT '0' AFTER `stone_weight`; /***********/ 2025-01-13 ALTER TABLE `third_party_apps` CHANGE `app_id` `id` INT NOT NULL AUTO_INCREMENT; ALTER TABLE `third_party_apps` DROP PRIMARY KEY, ADD PRIMARY KEY (`id`) USING BTREE; ALTER TABLE `third_party_apps` CHANGE `app_env` `app_env` ENUM('test','live') NOT NULL DEFAULT 'test'; 2025-01-14 ALTER TABLE `q_sales_invoice_m` ADD `description` LONGTEXT NULL DEFAULT NULL AFTER `print_count`; 2025-02-20 ALTER TABLE `wholesale_sales_invoice_d` CHANGE `payment_caliber` `caliber_price` DOUBLE NOT NULL DEFAULT '0', CHANGE `weight_without_packet` `total_without_vat` DOUBLE NOT NULL DEFAULT '0', CHANGE `total_wages` `total_vat` DOUBLE NOT NULL DEFAULT '0', CHANGE `payment_weight` `total_with_vat` DOUBLE NOT NULL DEFAULT '0'; ALTER TABLE `wholesale_sales_invoice_m` ADD `sales_agent_id` INT NOT NULL AFTER `tax_id`, ADD `treasurys_gold_id` INT NOT NULL AFTER `sales_agent_id`, ADD `account_tree_id` INT NOT NULL AFTER `treasurys_gold_id`, ADD `cost_center_id` INT NOT NULL AFTER `account_tree_id`, ADD `closing_tree_account` INT NOT NULL AFTER `cost_center_id`, ADD `default_aliber_price` DOUBLE NOT NULL AFTER `closing_tree_account`, ADD `vat_on` BOOLEAN NOT NULL AFTER `default_aliber_price`, ADD `is_used` BOOLEAN NOT NULL AFTER `vat_on`, ADD `is_delivered` BOOLEAN NOT NULL AFTER `is_used`, ADD `is_transfred` BOOLEAN NOT NULL AFTER `is_delivered`; ALTER TABLE `wholesale_sales_invoice_m` ADD `invoice_date` DATE NOT NULL AFTER `is_transfred`, ADD `total_weight` DOUBLE NOT NULL AFTER `invoice_date`, ADD `total_without_vat` DOUBLE NOT NULL AFTER `total_weight`, ADD `total_vat` DOUBLE NOT NULL AFTER `total_without_vat`, ADD `total_with_vat` DOUBLE NOT NULL AFTER `total_vat`; ALTER TABLE `wholesale_sales_invoice_m` ADD `totals` LONGTEXT NULL AFTER `description`; ALTER TABLE `wholesale_purchase_invoice_d` CHANGE `payment_caliber` `caliber_price` DOUBLE NOT NULL DEFAULT '0', CHANGE `weight_without_packet` `total_without_vat` DOUBLE NOT NULL DEFAULT '0', CHANGE `total_wages` `total_vat` DOUBLE NOT NULL DEFAULT '0', CHANGE `payment_weight` `total_with_vat` DOUBLE NOT NULL DEFAULT '0'; ALTER TABLE `wholesale_purchase_invoice_m` ADD `purchase_agent_id` INT NOT NULL AFTER `tax_id`, ADD `treasurys_gold_id` INT NOT NULL AFTER `purchase_agent_id`, ADD `account_tree_id` INT NOT NULL AFTER `treasurys_gold_id`, ADD `cost_center_id` INT NOT NULL AFTER `account_tree_id`, ADD `closing_tree_account` INT NOT NULL AFTER `cost_center_id`, ADD `default_aliber_price` DOUBLE NOT NULL AFTER `closing_tree_account`, ADD `vat_on` BOOLEAN NOT NULL AFTER `default_aliber_price`, ADD `is_used` BOOLEAN NOT NULL AFTER `vat_on`, ADD `is_delivered` BOOLEAN NOT NULL AFTER `is_used`, ADD `is_transfred` BOOLEAN NOT NULL AFTER `is_delivered`; ALTER TABLE `wholesale_purchase_invoice_m` ADD `invoice_date` DATE NOT NULL AFTER `is_transfred`, ADD `total_weight` DOUBLE NOT NULL AFTER `invoice_date`, ADD `total_without_vat` DOUBLE NOT NULL AFTER `total_weight`, ADD `total_vat` DOUBLE NOT NULL AFTER `total_without_vat`, ADD `total_with_vat` DOUBLE NOT NULL AFTER `total_vat`; ALTER TABLE `wholesale_purchase_invoice_m` ADD `totals` LONGTEXT NULL AFTER `description`; ALTER TABLE `wholesale_purchase_invoice_m` ADD `sales_agent_id` INT NOT NULL DEFAULT '0' AFTER `purchase_place_id`; ALTER TABLE `wholesale_purchase_invoice_m` ADD `currency_id` INT NOT NULL AFTER `invoice_type_id`; ALTER TABLE `wholesale_purchase_invoice_m` ADD `bag_id` VARCHAR(200) NULL AFTER `cost_center_id`; ALTER TABLE `wholesale_sales_invoice_m` CHANGE `bag_id` `bags` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL; ALTER TABLE `wholesale_purchase_invoice_m` CHANGE `bag_id` `bags` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL;