CRUD

​​​​​​​=========== Ahmed ===========

• Md.T&B.custody > new > group [field] should be single select not a text.
• Md.T&B.bank_account >new; create form is empty except for inactive boolean. Why?
• Md.invoicing.incoterm > new > Freight[Field]  should be single select?
• Md.invoicing.incoterm > new > Other_Charges[Field] should be single select?
• Md.warehousing.commodities > new {Error! A database error occurred: Column 'commodity_imo_option' specified twice}
• Md.other.stock unit > new; {Error! A database error occurred: Unknown column 'unit_type_name' in 'INSERT INTO’} when saving new entry.
• Md.invoicing.product > new; Name[field] duplicated.
• Md.invoicing.service >new; create form is empty except for inactive boolean. Why?
• Md.trucking.driver >new; {SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sub_account_name' in 'SELECT’}
• Md.trucking.trailer >new; {SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sub_account_name' in 'SELECT’}
• Md.trucking.equipment >new; {SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sub_account_name' in 'SELECT’}
• Md.other.customer_networks ; create trigger that From_date[Field] is greater than To_date[Field].
• Md.other.mawb_stock > new; start_number[field] should be limited to  exactly 7 characters.
• Md.other.mawb_stock > new; end_number[field] should be limited to  exactly 7 characters.
• Md.other.mawb_stock > new; amount[field] should be limited to  exactly 3 characters.
• Md.other.airline_charges > new; the screen only contains partner name and inactive boolean. Is this correct?
• Md.other.container_type > new code[field]  is disabled and not autogenerated.
• Md.other.container_type > new name[field]  is disabled.
• Md.other.file_upload > new > the user doesn’t have the option to add any file.
• Md.other.file_upload > new > what does selal[field] do?
• Md.other.vessels > new >  callsign[field]  should be limited to exactly 5 digits.
• Md.other.document_types > new > document[field]  is deactivated; What should be here? File upload? 
• Md.other.customer_type > should we have this table on? Or we have alreadyçe consignee and the shipper issue?
• Md.other.partner_operations_transactions_link > new > entity[field] shouldn’t this field be linked to partners table as single select?
• Md.other.stock_unit_conversion > new > from_unit[field] and from_unit[field] shouldn’t this field be linked to a predefined table to identify the units?
• Md.other.stock_stock_unit > {SQLSTATE[42S22]: Column not found: 1054 Unknown column 'stock_unit.stock_unit_name' in 'SELECT’}
• Md.other.stock_unit_type > {count(): Argument #1 ($value) must be of type Countable|array, bool given}
• Md.other.stock_unit_type > we need to create: inactive, created_by,created_on, updated_by, and updated_on).
• Md.other.operations_archiving >  bill_to[field] shouldn’t that be linked to partner table? Any specific category of partners? @kareem
• Md.other.operations_complaint >  customer[field] should be linked to partner table, customer screen.
• Md.other.operations_complaint >  operation_code[field] should be linked to operations table.
• Md.other.operations_complaint >  sales_rep[field] should be linked to users table, when is_sales[field] is checked.
• Md.other.operations_complaint >  complaint_type[field] should be either state value, or lookup (single-select).
• Md.other.operations_complaint >  customer[field] should be linked to partner table, customer screen.

=========== ESLAM ===========

• Md.other.address > new; add buttons does nothing. <Link=Create>
• Md.other.contacts > new; add buttons does nothing. <Link=Create>
• Md.other.container_type > new > add > {substr(): Argument #3 ($length) must be of type ?int, string given}  <link=Create.add_button>
• Md.other.document_types  >  {Deprecated: explode(): Passing null to parameter #2 ($string) of type string is deprecated in /home/u671588468/domains/youngbit.space/public_html/ils_staging/app/controllers/ScreenController.php on line 272} appears on top of the screen 10 times. <Link=Create&Update>
• Md.other.custom_clearance_authorization  >  {Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u671588468/domains/youngbit.space/public_html/ils_staging/app/views/fields/checkbox.php on line 64} appears at buttom of the screen one time. <Link=Create&Update>
• Md.other.banks > edit; {SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'from bank_branch' at line 1}. <Link=Update>
• The selected screen name in sidebar should always be centered in the remaining part of sidebar. Or at least be visible when there are many names above it. (The selected screen name disappears as soon s the user interacts with the main screen) <Sidebar>