var scProducts = [
  {id:106,ref:'BYD-HVM-111',name:'BYD HVM 11.1kWh'},
  {id:107,ref:'BYD-HVM-138',name:'BYD HVM 13.8kWh'},
  {id:105,ref:'BYD-HVM-83',name:'BYD HVM 8.3kWh'},
  {id:103,ref:'BYD-HVS-102',name:'BYD HVS 10.2kWh'},
  {id:104,ref:'BYD-HVS-128',name:'BYD HVS 12.8kWh'},
  {id:101,ref:'BYD-HVS-51',name:'BYD HVS 5.1kWh'},
  {id:102,ref:'BYD-HVS-77',name:'BYD HVS 7.7kWh'},
  {id:243,ref:'BYD-HVSBM-10.2/A-S',name:'BYD Battery-Box Premium HVS 10.2kWh'},
  {id:244,ref:'BYD-HVSBM-15.3/A-S',name:'BYD Battery-Box Premium HVS 15.3kWh'},
  {id:241,ref:'BYD-HVSBM-2.56/C-S',name:'BYD Battery-Box Premium HVS 2.56kWh Module'},
  {id:245,ref:'BYD-HVSBM-20.4/A-S',name:'BYD Battery-Box Premium HVS 20.4kWh'},
  {id:242,ref:'BYD-HVSBM-5.1/B-S',name:'BYD Battery-Box Premium HVS 5.1kWh'},
  {id:248,ref:'BYD-LVS-16.0',name:'BYD Battery-Box LVS 16.0kWh (48V)'},
  {id:246,ref:'BYD-LVS-4.0',name:'BYD Battery-Box LVS 4.0kWh (48V)'},
  {id:247,ref:'BYD-LVS-8.0',name:'BYD Battery-Box LVS 8.0kWh (48V)'},
  {id:59,ref:'CANSOL-HIKU7-580',name:'Canadian Solar HiKu7 580W'},
  {id:60,ref:'CANSOL-HIKU7-590',name:'Canadian Solar HiKu7 590W'},
  {id:199,ref:'CS6R-405MS',name:'Canadian Solar HiKu6 405W Mono PERC Panel'},
  {id:203,ref:'CS6W-570MB-AG',name:'Canadian Solar BiKu7 570W Bifacial Glass-Glass'},
  {id:200,ref:'CS7N-580MS',name:'Canadian Solar HiKu7 580W N-Type Panel'},
  {id:202,ref:'CS7N-605MB',name:'Canadian Solar TOPBiKu7 605W Bifacial'},
  {id:201,ref:'CS7N-605MS',name:'Canadian Solar HiKu7 605W N-Type Panel'},
  {id:100,ref:'DEYE-SUN-10',name:'Deye SUN-10K-SG'},
  {id:95,ref:'DEYE-SUN-3',name:'Deye SUN-3K-SG'},
  {id:96,ref:'DEYE-SUN-4',name:'Deye SUN-4K-SG'},
  {id:97,ref:'DEYE-SUN-5',name:'Deye SUN-5K-SG'},
  {id:98,ref:'DEYE-SUN-6',name:'Deye SUN-6K-SG'},
  {id:99,ref:'DEYE-SUN-8',name:'Deye SUN-8K-SG'},
  {id:112,ref:'DYNESS-T48',name:'Dyness Tower 4.8kWh'},
  {id:113,ref:'DYNESS-T96',name:'Dyness Tower 9.6kWh'},
  {id:8,ref:'EXP_GEN',name:'Expenses'},
  {id:252,ref:'FORCE-H1-5.4kWh',name:'Pylontech Force H1 5.4kWh Battery (48V)'},
  {id:253,ref:'FORCE-H2-10.65kWh',name:'Pylontech Force H2 10.65kWh Battery (48V)'},
  {id:254,ref:'FORCE-H2-15.98kWh',name:'Pylontech Force H2 15.98kWh Battery (48V)'},
  {id:88,ref:'GOODWE-DNS-10',name:'GoodWe GW10K-DNS'},
  {id:83,ref:'GOODWE-DNS-3',name:'GoodWe GW3K-DNS'},
  {id:84,ref:'GOODWE-DNS-4',name:'GoodWe GW4K-DNS'},
  {id:85,ref:'GOODWE-DNS-5',name:'GoodWe GW5K-DNS'},
  {id:86,ref:'GOODWE-DNS-6',name:'GoodWe GW6K-DNS'},
  {id:87,ref:'GOODWE-DNS-8',name:'GoodWe GW8K-DNS'},
  {id:89,ref:'GROWATT-MIN-1',name:'Growatt MIN 1000TL-X'},
  {id:90,ref:'GROWATT-MIN-2',name:'Growatt MIN 2000TL-X'},
  {id:91,ref:'GROWATT-MIN-3',name:'Growatt MIN 3000TL-X'},
  {id:92,ref:'GROWATT-MIN-4',name:'Growatt MIN 4000TL-X'},
  {id:93,ref:'GROWATT-MIN-5',name:'Growatt MIN 5000TL-X'},
  {id:94,ref:'GROWATT-MIN-6',name:'Growatt MIN 6000TL-X'},
  {id:67,ref:'HUAWEI-SUN2K-10',name:'Huawei SUN2000-10KTL'},
  {id:68,ref:'HUAWEI-SUN2K-12',name:'Huawei SUN2000-12KTL'},
  {id:69,ref:'HUAWEI-SUN2K-15',name:'Huawei SUN2000-15KTL'},
  {id:70,ref:'HUAWEI-SUN2K-17',name:'Huawei SUN2000-17KTL'},
  {id:61,ref:'HUAWEI-SUN2K-2',name:'Huawei SUN2000-2KTL'},
  {id:71,ref:'HUAWEI-SUN2K-20',name:'Huawei SUN2000-20KTL'},
  {id:62,ref:'HUAWEI-SUN2K-3',name:'Huawei SUN2000-3KTL'},
  {id:63,ref:'HUAWEI-SUN2K-4',name:'Huawei SUN2000-4KTL'},
  {id:64,ref:'HUAWEI-SUN2K-5',name:'Huawei SUN2000-5KTL'},
  {id:65,ref:'HUAWEI-SUN2K-6',name:'Huawei SUN2000-6KTL'},
  {id:66,ref:'HUAWEI-SUN2K-8',name:'Huawei SUN2000-8KTL'},
  {id:56,ref:'JA-DB40-580',name:'JA Deep Blue 4.0 580W'},
  {id:57,ref:'JA-DB40-590',name:'JA Deep Blue 4.0 590W'},
  {id:58,ref:'JA-DB40-600',name:'JA Deep Blue 4.0 600W'},
  {id:194,ref:'JAM54S30-400/MR',name:'JA Solar DeepBlue 3.0 400W Panel'},
  {id:195,ref:'JAM72D40-580/MB',name:'JA Solar DeepBlue 4.0 580W N-Type Panel'},
  {id:196,ref:'JAM72D42-580/MB',name:'JA Solar DeepBlue 4.0 Pro 580W N-Type'},
  {id:197,ref:'JAM72D42-605/MB',name:'JA Solar DeepBlue 4.0 Pro 605W N-Type'},
  {id:198,ref:'JAM72D42-620/LB',name:'JA Solar DeepBlue 4.0 Pro 620W Bifacial'},
  {id:49,ref:'JINKO-TIGNEO-565',name:'Jinko Tiger Neo N-type 565W'},
  {id:50,ref:'JINKO-TIGNEO-575',name:'Jinko Tiger Neo N-type 575W'},
  {id:51,ref:'JINKO-TIGNEO-580',name:'Jinko Tiger Neo N-type 580W'},
  {id:52,ref:'JINKO-TIGNEO-590',name:'Jinko Tiger Neo N-type 590W'},
  {id:183,ref:'JKM415N-54HL4-V',name:'JinkoSolar Tiger Neo 415W N-Type Panel'},
  {id:184,ref:'JKM575N-72HL4-BDV',name:'JinkoSolar Tiger Neo 575W N-Type Bifacial'},
  {id:185,ref:'JKM600N-78HL4-BDV',name:'JinkoSolar Tiger Neo 600W N-Type Bifacial'},
  {id:186,ref:'JKM620N-78HL4-V',name:'JinkoSolar Tiger Neo 3.0 620W Panel'},
  {id:187,ref:'JKM665N-78HL4M-V',name:'JinkoSolar Tiger Neo 3.0 665W Flagship Panel'},
  {id:41,ref:'LONGI-HIMO7-560',name:'LONGi Hi-MO 7 560W'},
  {id:42,ref:'LONGI-HIMO7-570',name:'LONGi Hi-MO 7 570W'},
  {id:43,ref:'LONGI-HIMO7-580',name:'LONGi Hi-MO 7 580W'},
  {id:44,ref:'LONGI-HIMO7-590',name:'LONGi Hi-MO 7 590W'},
  {id:45,ref:'LONGI-HIMO7-600',name:'LONGi Hi-MO 7 600W'},
  {id:46,ref:'LONGI-HIMOX6-565',name:'LONGi Hi-MO X6 565W'},
  {id:47,ref:'LONGI-HIMOX6-575',name:'LONGi Hi-MO X6 575W'},
  {id:48,ref:'LONGI-HIMOX6-585',name:'LONGi Hi-MO X6 585W'},
  {id:177,ref:'LR5-54HBD-430M',name:'LONGi Hi-MO X6 430W HJT Panel'},
  {id:173,ref:'LR5-54HTH-405M',name:'LONGi Hi-MO 7 405W Solar Panel'},
  {id:178,ref:'LR5-66HBD-540M',name:'LONGi Hi-MO X6 540W HJT Panel'},
  {id:174,ref:'LR5-66HTH-500M',name:'LONGi Hi-MO 7 500W Solar Panel'},
  {id:179,ref:'LR5-72HBD-575M',name:'LONGi Hi-MO X6 575W HJT Panel'},
  {id:175,ref:'LR5-72HTH-580M',name:'LONGi Hi-MO 7 580W Solar Panel'},
  {id:176,ref:'LR5-72HTH-600M',name:'LONGi Hi-MO 7 600W Solar Panel'},
  {id:180,ref:'LR7-54HVD-490M',name:'LONGi Hi-MO X10 490W HPBC 2.0 Panel'},
  {id:182,ref:'LR7-54HVD-560M-Light',name:'LONGi Hi-MO X10 Light 560W Panel'},
  {id:181,ref:'LR7-72HVD-655M',name:'LONGi Hi-MO X10 655W HPBC 2.0 Panel'},
  {id:232,ref:'LUNA2000-10-S0',name:'Huawei LUNA2000-10-S0 10.0kWh Battery'},
  {id:233,ref:'LUNA2000-15-S0',name:'Huawei LUNA2000-15-S0 15.0kWh Battery'},
  {id:234,ref:'LUNA2000-21-S1',name:'Huawei LUNA2000-21-S1 20.7kWh Battery'},
  {id:231,ref:'LUNA2000-5-S0',name:'Huawei LUNA2000-5-S0 5.0kWh Battery'},
  {id:111,ref:'PYLON-FH2',name:'Pylontech Force H2 7.1kWh'},
  {id:108,ref:'PYLON-US2000C',name:'Pylontech US2000C 2.4kWh'},
  {id:109,ref:'PYLON-US3000C',name:'Pylontech US3000C 3.5kWh'},
  {id:110,ref:'PYLON-US5000',name:'Pylontech US5000 4.8kWh'},
  {id:16,ref:'SC-10KW-ECO',name:'10kW Economy Solar System'},
  {id:18,ref:'SC-10KW-PRE',name:'10kW Premium Solar System'},
  {id:17,ref:'SC-10KW-STD',name:'10kW Standard Solar System'},
  {id:19,ref:'SC-20KW-ECO',name:'20kW Economy Solar System'},
  {id:21,ref:'SC-20KW-PRE',name:'20kW Premium Solar System'},
  {id:20,ref:'SC-20KW-STD',name:'20kW Standard Solar System'},
  {id:10,ref:'SC-3KW-ECO',name:'3kW Economy Solar System'},
  {id:12,ref:'SC-3KW-PRE',name:'3kW Premium Solar System'},
  {id:11,ref:'SC-3KW-STD',name:'3kW Standard Solar System'},
  {id:23,ref:'SC-5KW-AGR',name:'5kW Agricultural Pump System'},
  {id:13,ref:'SC-5KW-ECO',name:'5kW Economy Solar System'},
  {id:15,ref:'SC-5KW-PRE',name:'5kW Premium Solar System'},
  {id:14,ref:'SC-5KW-STD',name:'5kW Standard Solar System'},
  {id:22,ref:'SC-5KW-STD-BAT',name:'5kW Standard System + BYD Battery 5.1kWh'},
  {id:145,ref:'SC-BAT-BYD-102',name:'BYD HVS 10.2kWh Battery'},
  {id:146,ref:'SC-BAT-BYD-153',name:'BYD HVS 15.3kWh Battery'},
  {id:27,ref:'SC-BAT-BYD-5',name:'BYD Battery 5.1kWh'},
  {id:144,ref:'SC-BAT-BYD-51',name:'BYD HVS 5.1kWh Battery'},
  {id:29,ref:'SC-BAT-DYN-5',name:'Dyness Battery 5.12kWh'},
  {id:28,ref:'SC-BAT-PYL-5',name:'Pylontech Battery 4.8kWh'},
  {id:147,ref:'SC-BAT-PYLON-10',name:'Pylontech H2 10kWh Battery'},
  {id:120,ref:'SC-CAB-DC4',name:'DC Solar Cable 4mm² (per meter)'},
  {id:121,ref:'SC-CAB-DC6',name:'DC Solar Cable 6mm² (per meter)'},
  {id:124,ref:'SC-CON-MC4-BR2',name:'MC4 T-Branch 2-in-1 Connector'},
  {id:125,ref:'SC-CON-MC4-BR3',name:'MC4 T-Branch 3-in-1 Connector'},
  {id:123,ref:'SC-CON-MC4-F',name:'MC4 Female Connector'},
  {id:122,ref:'SC-CON-MC4-M',name:'MC4 Male Connector'},
  {id:164,ref:'SC-DEL-ZONE-A',name:'Delivery: Zone A — Erbil'},
  {id:165,ref:'SC-DEL-ZONE-B',name:'Delivery: Zone B — Sulaymaniyah/Duhok'},
  {id:166,ref:'SC-DEL-ZONE-C',name:'Delivery: Zone C — Kirkuk'},
  {id:167,ref:'SC-DEL-ZONE-D',name:'Delivery: Zone D — Baghdad'},
  {id:168,ref:'SC-DEL-ZONE-E',name:'Delivery: Zone E — Mosul/Tikrit'},
  {id:169,ref:'SC-DEL-ZONE-F',name:'Delivery: Zone F — Najaf/Karbala'},
  {id:170,ref:'SC-DEL-ZONE-G',name:'Delivery: Zone G — Basra'},
  {id:171,ref:'SC-DEL-ZONE-H',name:'Delivery: Zone H — Remote Areas'},
  {id:140,ref:'SC-INV-DEYE-5K',name:'Deye SUN-5K Hybrid Inverter'},
  {id:143,ref:'SC-INV-HUAWEI-SUN',name:'Huawei SUN2000 Smart Inverter'},
  {id:141,ref:'SC-INV-SUNGROW-SG',name:'Sungrow SG Grid-Tie Inverter'},
  {id:142,ref:'SC-INV-SUNGROW-SH',name:'Sungrow SH Hybrid Inverter'},
  {id:117,ref:'SC-MNT-CLAMP-END',name:'End Clamp 35mm'},
  {id:116,ref:'SC-MNT-CLAMP-MID',name:'Mid Clamp 35mm'},
  {id:119,ref:'SC-MNT-FOOT',name:'Roof Foot / Base Mount'},
  {id:115,ref:'SC-MNT-MECH-RAIL',name:'Mechanical Rail Aluminum 4.2m'},
  {id:118,ref:'SC-MNT-SPLICE',name:'Rail Splice Connector'},
  {id:114,ref:'SC-MNT-WELD-RAIL',name:'Welding Frame Rail 2.4m'},
  {id:132,ref:'SC-MON-4G',name:'Inverter 4G Logger'},
  {id:133,ref:'SC-MON-SMART',name:'Smart Energy Meter'},
  {id:131,ref:'SC-MON-WIFI',name:'Inverter WiFi Logger Dongle'},
  {id:138,ref:'SC-PNL-LONGI-580',name:'LONGi Hi-MO 7 580W Solar Panel'},
  {id:139,ref:'SC-PNL-LONGI-HJT-575',name:'LONGi HJT X6 575W Premium Panel'},
  {id:128,ref:'SC-PRO-ACSURGE',name:'AC Surge Protector'},
  {id:130,ref:'SC-PRO-COMBBOX',name:'4-String Combiner Box'},
  {id:129,ref:'SC-PRO-DCBREAK',name:'DC Circuit Breaker 32A'},
  {id:126,ref:'SC-PRO-DCFUSE',name:'DC String Fuse 15A'},
  {id:127,ref:'SC-PRO-DCSURGE',name:'DC Surge Protector'},
  {id:136,ref:'SC-SPA-CLEANER',name:'Panel Cleaning Solution 5L'},
  {id:134,ref:'SC-SPA-MC4TOOL',name:'MC4 Crimping Tool'},
  {id:135,ref:'SC-SPA-TESTER',name:'PV Panel Tester'},
  {id:26,ref:'SC-SRV-AMC',name:'Annual Maintenance Contract'},
  {id:24,ref:'SC-SRV-DEL',name:'Delivery Service'},
  {id:32,ref:'SC-SRV-DEL-FLAT',name:'Delivery Service - Flatbed'},
  {id:33,ref:'SC-SRV-DEL-HIAB',name:'Delivery Service - HIAB'},
  {id:31,ref:'SC-SRV-DEL-PICKUP',name:'Delivery Service - Pickup'},
  {id:30,ref:'SC-SRV-EXT-WARR',name:'Extended Inverter Warranty 5yr'},
  {id:25,ref:'SC-SRV-INS',name:'Installation Service'},
  {id:161,ref:'SC-SRV-INS-10KW-MECH',name:'Installation: 10kW Mechanical Rail'},
  {id:160,ref:'SC-SRV-INS-10KW-WELD',name:'Installation: 10kW Welding Frame'},
  {id:163,ref:'SC-SRV-INS-20KW-MECH',name:'Installation: 20kW Mechanical Rail'},
  {id:162,ref:'SC-SRV-INS-20KW-WELD',name:'Installation: 20kW Welding Frame'},
  {id:157,ref:'SC-SRV-INS-3KW-MECH',name:'Installation: 3kW Mechanical Rail'},
  {id:156,ref:'SC-SRV-INS-3KW-WELD',name:'Installation: 3kW Welding Frame'},
  {id:159,ref:'SC-SRV-INS-5KW-MECH',name:'Installation: 5kW Mechanical Rail'},
  {id:158,ref:'SC-SRV-INS-5KW-WELD',name:'Installation: 5kW Welding Frame'},
  {id:207,ref:'SG10RT',name:'Sungrow SG10RT Grid-Tie Inverter 10kW'},
  {id:217,ref:'SG10RT-3P',name:'Sungrow SG10RT-3P 3-Phase 10kW'},
  {id:230,ref:'SG150CX',name:'Sungrow SG150CX String Inverter 150kW'},
  {id:208,ref:'SG15RT',name:'Sungrow SG15RT Grid-Tie Inverter 15kW'},
  {id:209,ref:'SG20RT',name:'Sungrow SG20RT Grid-Tie Inverter 20kW'},
  {id:204,ref:'SG3.0RT',name:'Sungrow SG3.0RT Grid-Tie Inverter 3kW'},
  {id:218,ref:'SG30KTL-M5',name:'Sungrow SG30KTL-M5 Commercial 3-Phase 30kW'},
  {id:205,ref:'SG5.0RT',name:'Sungrow SG5.0RT Grid-Tie Inverter 5kW'},
  {id:216,ref:'SG5.0RT-3P',name:'Sungrow SG5.0RT-3P 3-Phase 5kW'},
  {id:206,ref:'SG8.0RT',name:'Sungrow SG8.0RT Grid-Tie Inverter 8kW'},
  {id:213,ref:'SH10RT',name:'Sungrow SH10RT Hybrid Inverter 10kW'},
  {id:214,ref:'SH15T',name:'Sungrow SH15T Hybrid Inverter 15kW'},
  {id:215,ref:'SH20T',name:'Sungrow SH20T Hybrid Inverter 20kW'},
  {id:210,ref:'SH3.0RS',name:'Sungrow SH3.0RS Hybrid Inverter 3kW'},
  {id:211,ref:'SH5.0RT',name:'Sungrow SH5.0RT Hybrid Inverter 5kW'},
  {id:212,ref:'SH8.0RT',name:'Sungrow SH8.0RT Hybrid Inverter 8kW'},
  {id:238,ref:'SUN-10K-SG01HP3-EU',name:'Deye SUN-10K-SG01HP3 10kW Hybrid Inverter'},
  {id:239,ref:'SUN-12K-SG01HP3-EU-AM2',name:'Deye SUN-12K-SG01HP3 12kW Hybrid Inverter'},
  {id:240,ref:'SUN-20K-SG01HP3-EU-AM2',name:'Deye SUN-20K-SG01HP3 20kW Hybrid Inverter'},
  {id:235,ref:'SUN-3K-SG03LP1-EU',name:'Deye SUN-3K-SG03LP1 3kW Hybrid Inverter'},
  {id:236,ref:'SUN-5K-SG01HP3-EU',name:'Deye SUN-5K-SG01HP3 5kW Hybrid Inverter'},
  {id:237,ref:'SUN-8K-SG01HP3-EU',name:'Deye SUN-8K-SG01HP3 8kW Hybrid Inverter'},
  {id:226,ref:'SUN2000-10KTL-M1',name:'Huawei SUN2000-10KTL-M1 3-Phase 10kW'},
  {id:227,ref:'SUN2000-12K-MB0',name:'Huawei SUN2000-12K-MB0 Hybrid 12kW'},
  {id:228,ref:'SUN2000-15K-MB0',name:'Huawei SUN2000-15K-MB0 Hybrid 15kW'},
  {id:229,ref:'SUN2000-20K-MB0',name:'Huawei SUN2000-20K-MB0 Hybrid 20kW'},
  {id:219,ref:'SUN2000-2KTL-L1',name:'Huawei SUN2000-2KTL-L1 Smart Inverter 2kW'},
  {id:220,ref:'SUN2000-3KTL-L1',name:'Huawei SUN2000-3KTL-L1 Smart Inverter 3kW'},
  {id:223,ref:'SUN2000-3KTL-M1',name:'Huawei SUN2000-3KTL-M1 3-Phase 3kW'},
  {id:221,ref:'SUN2000-5KTL-L1',name:'Huawei SUN2000-5KTL-L1 Smart Inverter 5kW'},
  {id:224,ref:'SUN2000-5KTL-M1',name:'Huawei SUN2000-5KTL-M1 3-Phase 5kW'},
  {id:222,ref:'SUN2000-6KTL-L1',name:'Huawei SUN2000-6KTL-L1 Smart Inverter 6kW'},
  {id:225,ref:'SUN2000-8KTL-M1',name:'Huawei SUN2000-8KTL-M1 3-Phase 8kW'},
  {id:77,ref:'SUNGROW-SG10RS',name:'Sungrow SG10RS'},
  {id:78,ref:'SUNGROW-SG12RS',name:'Sungrow SG12RS'},
  {id:72,ref:'SUNGROW-SG3RS',name:'Sungrow SG3RS'},
  {id:73,ref:'SUNGROW-SG4RS',name:'Sungrow SG4RS'},
  {id:74,ref:'SUNGROW-SG5RS',name:'Sungrow SG5RS'},
  {id:75,ref:'SUNGROW-SG6RS',name:'Sungrow SG6RS'},
  {id:76,ref:'SUNGROW-SG8RS',name:'Sungrow SG8RS'},
  {id:82,ref:'SUNGROW-SH10RS',name:'Sungrow SH10RS Hybrid'},
  {id:79,ref:'SUNGROW-SH5RS',name:'Sungrow SH5RS Hybrid'},
  {id:80,ref:'SUNGROW-SH6RS',name:'Sungrow SH6RS Hybrid'},
  {id:81,ref:'SUNGROW-SH8RS',name:'Sungrow SH8RS Hybrid'},
  {id:53,ref:'TRINA-VERTSP-580',name:'Trina Vertex S+ 580W'},
  {id:54,ref:'TRINA-VERTSP-590',name:'Trina Vertex S+ 590W'},
  {id:55,ref:'TRINA-VERTSP-600',name:'Trina Vertex S+ 600W'},
  {id:188,ref:'TSM-400DE09.08',name:'Trina Solar Vertex S 400W Panel'},
  {id:189,ref:'TSM-450NEG9RC.20',name:'Trina Solar Vertex S+ 450W N-Type Panel'},
  {id:190,ref:'TSM-455NEG9R.28',name:'Trina Solar Vertex S+ 455W N-Type Panel'},
  {id:191,ref:'TSM-585NEG9RC.20',name:'Trina Solar Vertex S+ 585W N-Type Panel'},
  {id:192,ref:'TSM-665NEG21C.20',name:'Trina Solar Vertex 665W i-TOPCon Bifacial'},
  {id:193,ref:'TSM-720NEG21C.20',name:'Trina Solar Vertex 720W N-Type Bifacial Commercial'},
  {id:249,ref:'US2000C',name:'Pylontech US2000C 2.4kWh Battery (48V)'},
  {id:250,ref:'US3000C',name:'Pylontech US3000C 3.5kWh Battery (48V)'},
  {id:251,ref:'US5000',name:'Pylontech US5000 4.8kWh Battery (48V)'},
];

var scPrices = [];
var scChanged = false;
var scPartnerId = 0;

function scRPC(model, method, args, kwargs) {
  return fetch('/web/dataset/call_kw/' + model + '/' + method, {
    method: 'POST',
    headers: {'Content-Type': 'application/json'},
    body: JSON.stringify({
      jsonrpc: '2.0', method: 'call', id: Date.now(),
      params: {model: model, method: method, args: args, kwargs: kwargs || {}}
    })
  }).then(function(r) { return r.json(); }).then(function(data) {
    if (data.error) throw new Error(data.error.data ? data.error.data.message : 'RPC Error');
    return data.result;
  });
}

function scGetSessionInfo() {
  return fetch('/web/session/get_session_info', {
    method: 'POST',
    headers: {'Content-Type': 'application/json'},
    body: JSON.stringify({jsonrpc: '2.0', method: 'call', id: 1, params: {}})
  }).then(function(r) { return r.json(); }).then(function(data) {
    if (data.result && data.result.partner_id) scPartnerId = data.result.partner_id;
    return scPartnerId;
  });
}

function scInit() {
  scGetSessionInfo().then(function() { scLoadPrices(); }).catch(function() { scLoadPrices(); });
  scSetupAutocomplete();
}

// Custom autocomplete
function scSetupAutocomplete() {
  var input = document.getElementById('sc-new-product-text');
  var dropdown = document.getElementById('sc-autocomplete-list');
  if (!input || !dropdown) return;

  input.addEventListener('input', function() {
    var q = this.value.toLowerCase();
    if (q.length < 1) { dropdown.style.display = 'none'; return; }
    var matches = scProducts.filter(function(p) {
      return p.ref.toLowerCase().indexOf(q) !== -1 || p.name.toLowerCase().indexOf(q) !== -1;
    }).slice(0, 15);
    if (matches.length === 0) { dropdown.style.display = 'none'; return; }
    var html = '';
    for (var i = 0; i < matches.length; i++) {
      html += '<div class="sc-ac-item" data-id="' + matches[i].id + '" style="padding:8px 12px;cursor:pointer;border-bottom:1px solid #eee;font-size:13px;" onmouseover="this.style.background=\'#FFF8E1\'" onmouseout="this.style.background=\'white\'">';
      html += '<strong>[' + matches[i].ref + ']</strong> ' + matches[i].name;
      html += '</div>';
    }
    dropdown.innerHTML = html;
    dropdown.style.display = 'block';

    var items = dropdown.querySelectorAll('.sc-ac-item');
    items.forEach(function(item) {
      item.addEventListener('click', function() {
        var id = this.getAttribute('data-id');
        input.value = this.textContent.trim();
        document.getElementById('sc-new-product').value = id;
        dropdown.style.display = 'none';
      });
    });
  });

  input.addEventListener('blur', function() {
    setTimeout(function() { dropdown.style.display = 'none'; }, 200);
  });
  input.addEventListener('focus', function() {
    if (this.value.length > 0) this.dispatchEvent(new Event('input'));
  });
}

function scLoadPrices() {
  scRPC('product.supplierinfo', 'search_read', [[], ['product_tmpl_id', 'price', 'delay', 'min_qty']], {limit: 100})
  .then(function(records) {
    scPrices = records;
    scRenderTable();
    document.getElementById('sc-status').textContent = scPrices.length + ' products';
    document.getElementById('sc-status').className = 'badge bg-success';
  })
  .catch(function(e) {
    document.getElementById('sc-prices-body').innerHTML =
      '<tr><td colspan="5" class="text-center text-danger py-3">Error: ' + e.message + '</td></tr>';
  });
}

function scRenderTable() {
  var tbody = document.getElementById('sc-prices-body');
  if (scPrices.length === 0) {
    tbody.innerHTML = '<tr><td colspan="5" class="text-center text-muted py-4">No products yet. Add your first product below.</td></tr>';
    return;
  }
  var html = '';
  for (var i = 0; i < scPrices.length; i++) {
    var p = scPrices[i];
    var name = p.product_tmpl_id ? p.product_tmpl_id[1] : 'Unknown';
    html += '<tr data-id="' + p.id + '">';
    html += '<td class="align-middle" style="font-size:13px;">' + name + '</td>';
    html += '<td><input type="number" class="form-control form-control-sm sc-price" value="' + Math.round(p.price) + '" min="1" onchange="scMarkChanged()"/></td>';
    html += '<td><input type="number" class="form-control form-control-sm sc-delay" value="' + (p.delay||3) + '" min="1" max="30" onchange="scMarkChanged()"/></td>';
    html += '<td><input type="number" class="form-control form-control-sm sc-qty" value="' + Math.round(p.min_qty||1) + '" min="1" onchange="scMarkChanged()"/></td>';
    html += '<td><button class="btn btn-sm btn-outline-danger" onclick="scRemoveRow(' + p.id + ')">x</button></td>';
    html += '</tr>';
  }
  tbody.innerHTML = html;
}

function scMarkChanged() {
  scChanged = true;
  document.getElementById('sc-save-btn').disabled = false;
  document.getElementById('sc-save-btn').style.background = '#F5A623';
  document.getElementById('sc-save-msg').textContent = 'Unsaved changes';
  document.getElementById('sc-save-msg').style.color = '#F59E0B';
}

function scSaveAll() {
  var btn = document.getElementById('sc-save-btn');
  btn.disabled = true; btn.textContent = 'Saving...';
  var msg = document.getElementById('sc-save-msg');
  var rows = document.querySelectorAll('#sc-prices-body tr[data-id]');
  var promises = [];
  for (var i = 0; i < rows.length; i++) {
    var r = rows[i], id = parseInt(r.getAttribute('data-id'));
    var price = parseFloat(r.querySelector('.sc-price').value);
    var delay = parseInt(r.querySelector('.sc-delay').value) || 3;
    var qty = parseFloat(r.querySelector('.sc-qty').value) || 1;
    if (price > 0) promises.push(scRPC('product.supplierinfo', 'write', [[id], {price:price,delay:delay,min_qty:qty}]));
  }
  Promise.all(promises).then(function() {
    scChanged = false; btn.textContent = 'Saved!'; btn.style.background = '#22C55E';
    msg.textContent = 'All prices saved'; msg.style.color = '#22C55E';
    setTimeout(function() { btn.textContent = 'Save All Changes'; btn.style.background = '#F5A623'; btn.disabled = true; }, 2000);
  }).catch(function(e) {
    btn.disabled = false; btn.textContent = 'Save All Changes';
    msg.textContent = 'Error: ' + e.message; msg.style.color = '#EF4444';
  });
}

function scAddProduct() {
  var hiddenInput = document.getElementById('sc-new-product');
  var textInput = document.getElementById('sc-new-product-text');
  var prodId = parseInt(hiddenInput.value);
  if (!prodId) { alert('Select a product from the list'); return; }
  var price = parseFloat(document.getElementById('sc-new-price').value);
  if (!price || price <= 0) { alert('Enter a valid price'); return; }
  var delay = parseInt(document.getElementById('sc-new-delay').value) || 3;
  var qty = parseFloat(document.getElementById('sc-new-qty').value) || 1;
  if (!scPartnerId) { alert('Session error. Reload page.'); return; }

  scRPC('product.supplierinfo', 'create', [{product_tmpl_id:prodId,price:price,delay:delay,min_qty:qty,partner_id:scPartnerId}])
  .then(function() {
    textInput.value = ''; hiddenInput.value = '';
    document.getElementById('sc-new-price').value = '';
    document.getElementById('sc-new-delay').value = '3';
    document.getElementById('sc-new-qty').value = '1';
    scLoadPrices();
  }).catch(function(e) { alert('Error: ' + e.message); });
}

function scRemoveRow(id) {
  if (!confirm('Remove this product?')) return;
  scRPC('product.supplierinfo', 'unlink', [[id]])
  .then(function() { scLoadPrices(); })
  .catch(function(e) { alert('Error: ' + e.message); });
}

if (document.readyState === 'loading') { document.addEventListener('DOMContentLoaded', scInit); }
else { scInit(); }