SELECT p.id_product, pl.name, id_image, t.id_button, IFNULL(pcl.name, "Sin stock con fecha de entrada") as contact, p.id_product as id_od_outofstock FROM ps_product p
LEFT JOIN ps_product_lang pl ON p.id_product = pl.id_product AND pl.id_lang = 1
LEFT JOIN ps_od_oosbutton t ON t.id_product = p.id_product
LEFT JOIN ps_contact_lang pcl ON t.id_button = pcl.id_contact AND pcl.id_lang = 1
LEFT JOIN ps_image_shop i ON p.id_product = i.id_product AND i.cover = 1 WHERE (t.id_button IS NOT NULL) GROUP BY id_product
array:23 [0 => array:6 [
"id_product" => "203"
"name" => "Power supply 4 Amp. Single channel amplifier serie Tas 001 Triax"
"id_image" => "2627"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "203"
]
1 => array:6 [
"id_product" => "204"
"name" => "Triax TAS 050 Mono Amplifier TDT UHF 50 dB"
"id_image" => "2632"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "204"
]
2 => array:6 [
"id_product" => "21818"
"name" => "Tegui Dual camera B/W TC-70 Europa Series"
"id_image" => "294910"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "21818"
]
3 => array:6 [
"id_product" => "28161"
"name" => "Wisenet WAVE-ENC-04 Encoder license."
"id_image" => "297644"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28161"
]
4 => array:6 [
"id_product" => "28162"
"name" => "Wisenet WAVE-IO-01 Entry/Exit Unit License."
"id_image" => "297645"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28162"
]
5 => array:6 [
"id_product" => "28163"
"name" => "Wisenet WAVE-PRO-16 16 x Hanwha IP Camera Server Recording…"
"id_image" => "297646"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28163"
]
6 => array:6 [
"id_product" => "28164"
"name" => "Wisenet WAVE-PRO-24 24 x Hanwha IP Camera Server Recording…"
"id_image" => "297647"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28164"
]
7 => array:6 [
"id_product" => "28165"
"name" => "Wisenet WAVE-PRO-48 48 x Hanwha IP Camera Server Recording…"
"id_image" => "297648"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28165"
]
8 => array:6 [
"id_product" => "28166"
"name" => "Wisenet WAVE-VW-02 Video Wall License. Management of 2 monitors."
"id_image" => "297649"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28166"
]
9 => array:6 [
"id_product" => "28179"
"name" => "Wisenet WAVE-EMB-04 4 x Play license for Hanwha NVR."
"id_image" => "297663"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28179"
]
10 => array:6 [
"id_product" => "28181"
"name" => "Wisenet WAVE-PRO-04 4 x Hanwha IP Camera Server Recording…"
"id_image" => "297665"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28181"
]
11 => array:6 [
"id_product" => "28182"
"name" => "Wisenet WAVE-PRO-08 8 x Hanwha IP Camera Server Recording…"
"id_image" => "297666"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28182"
]
12 => array:6 [
"id_product" => "28190"
"name" => "Reyee RG-NBS3200-48GT4XS-P - Manageable Reyee Cloud PoE Switch PoE L2, 48 PoE + 4…"
"id_image" => "297674"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28190"
]
13 => array:6 [
"id_product" => "28217"
"name" => "Reyee RG-ES216GC - Reyee Switch Cloud Layer 2, 16 RJ45 Gigabit ports,…"
"id_image" => "297701"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28217"
]
14 => array:6 [
"id_product" => "28225"
"name" => "Risco RP512B00000A Polycarbonate box for ProSYS Plus control…"
"id_image" => "297709"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28225"
]
15 => array:6 [
"id_product" => "28247"
"name" => "Aeotec ZW100 Multisensor 6 Aeotec Z-Wave Plus"
"id_image" => "297731"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28247"
]
16 => array:6 [
"id_product" => "28248"
"name" => "Hochiki ACC-EN(WHT)SCI Hochiki multi-sensor detector"
"id_image" => "297732"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28248"
]
17 => array:6 [
"id_product" => "28249"
"name" => "Wisenet TNO-3030T IP thermal tube, 13.7 mm fixed optics, 16º…"
"id_image" => "297733"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28249"
]
18 => array:6 [
"id_product" => "28250"
"name" => "Wisenet TNO-3040T IP thermal tube, 19 mm fixed optics, 11.5º…"
"id_image" => "297734"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28250"
]
19 => array:6 [
"id_product" => "28251"
"name" => "Philio Technology PST10 Philio 4-in-1 multisensor"
"id_image" => "297735"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28251"
]
20 => array:6 [
"id_product" => "28756"
"name" => "Bticino 336803. Cable for connection to the installation of internal stations installed on a desktop support"
"id_image" => "298287"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28756"
]
21 => array:6 [
"id_product" => "28758"
"name" => "Hikvision pro DS-2CD3646G2/P-IZS(2.8-12MM) Cámara IP 4MP bullet…"
"id_image" => "298289"
"id_button" => "0"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28758"
]
22 => array:6 [
"id_product" => "28780"
"name" => "Risco RVIM3A15000A / PFA150 Pole adapter for PFBx PFAx"
"id_image" => "298428"
"id_button" => "2"
"contact" => "Sin stock con fecha de entrada"
"id_od_outofstock" => "28780"
]
]
SELECT * FROM ps_od_oosbutton_manufacturer WHERE id_manufacturer = 315SELECT * FROM ps_od_oosbutton JOIN ps_od_oosbutton_lang USING (id_product) WHERE id_product = 14201 AND id_lang = 1
Morley-IAS by Honeywell 714-001-242 4-loop analog panel
Morley-IAS by Honeywell 714-001-242. 4-loop analog panel Central analogica dxc4 de 4 lazos.
Features
Analog fire detection center with 4 MorleyIAS loops, with 792 addresses (396 sensors + 396 modules).
2 supervised siren outputs (1A max.c / u).
4A power supply, 2 general relays (alarm and fault).
A programmable relay, fixed and resettable auxiliary output 24Vdc 250mA, 2 keys and 2 inputs for programmable functions.
LCD graphic display 240x64 pixels.
Integrated port for PC programming via USB cable and RS485 port for repeaters.
Optional isolated port communications module for connection to the DXcNET central network and optional RS232 serial isolated port module (for integration or connection to a PC with TG graphic management terminal).
It includes verification and matching algorithms to eliminate false alarms.
Specific control algorithms for ultrasensitive MI-LZR laser sensor and time plan for multi-criteria sensors
MI-PTSE and MI-PTIR.
It includes a CD with a tool for calculating the dimensions of the loops and the batteries, a program for the treatment of the history, manuals and programming software that allows you to customize the graphic display of the plant with the company logo and import the texts of Personalization of the equipment from an Excel document.
Cab with capacity to accommodate 2 batteries 12Vdc, 7Ah to 17Ah.
