Подзапросы для pdoTools

SELECT *
FROM `modx_tsklad_detail_naryad_smena_link` AS `tSkladDetNSLink`
LEFT JOIN `modx_tsklad_order_list` `Detail` ON Detail.id=tSkladDetNSLink.det_id
LEFT JOIN `modx_tsklad_orders` `Order` ON Order.id=Detail.sk_order_id
LEFT JOIN `modx_tsklad_naryad` `Naryad` ON Naryad.id=tSkladDetNSLink.naryad_id
LEFT JOIN `modx_tsklad_smena` `Smena` ON Smena.id=tSkladDetNSLink.smena_id
LEFT JOIN `modx_nomenclature_detail_nom` `DetailNom` ON DetailNom.id=Detail.nom_id
LEFT JOIN `modx_nomenclature_detail_class` `DetailClass` ON DetailClass.id=DetailNom.class_id
LEFT JOIN `modx_nomenclature_type_job` `NomTypeJob` ON NomTypeJob.id=DetailClass.type_job_id
LEFT JOIN (
		#subquery subpdo join 
		SELECT NextDNL.det_id AS next_det_id, NextDNL.naryad_id AS next_naryad_id, NextN.name AS next_naryad_name, NextDNL.smena_id AS next_smena_id, NextS.date AS next_smena_date, NextS.number AS next_smena_number
		FROM `modx_tsklad_detail_naryad_smena_link` AS `NextDNL`
		LEFT JOIN `modx_tsklad_smena` `NextS` ON NextS.id=NextDNL.smena_id
		LEFT JOIN `modx_tsklad_naryad` `NextN` ON NextN.id=NextDNL.naryad_id
		ORDER BY NextS.date ASC, NextS.number ASC) `NextDNL1` 

                ON tSkladDetNSLink.det_id = NextDNL1.next_det_id AND 
                 (NextDNL1.next_smena_date > Smena.date OR (NextDNL1.next_smena_date = Smena.date AND NextDNL1.next_smena_number > Smena.number)
) 
 AND NextDNL1.next_smena_id = (
 		#subquery {$subpdo.smena_limit}
		SELECT NextDNL.smena_id AS on_next_smena_id
		FROM `modx_tsklad_detail_naryad_smena_link` AS `NextDNL`
		LEFT JOIN `modx_tsklad_smena` `NextS` ON NextS.id=NextDNL.smena_id
		LEFT JOIN `modx_tsklad_naryad` `NextN` ON NextN.id=NextDNL.naryad_id
		WHERE NextS.date > Smena.date OR (NextS.date = Smena.date AND NextS.number > Smena.number)
		ORDER BY NextS.date ASC, NextS.number ASC
		LIMIT 1
)
LEFT JOIN `modx_plazma_list` `PlazmaList` ON PlazmaList.det_id=tSkladDetNSLink.det_id
WHERE (`Detail`.`sech` = 'pryam' AND `Detail`.`name` = 'зонт' AND `DetailNom`.`A` = '2000' AND `DetailNom`.`B` = '1500' AND `DetailNom`.`a_s` = '500' AND `DetailNom`.`b_s` = '500' AND `Detail`.`metall` = '0,7Ц' AND `Detail`.`L` = '0' AND `Detail`.`comment` = 'тип 1, ф355 заузить под наш отвод' AND `tSkladDetNSLink`.`smena_id` = 65 AND `tSkladDetNSLink`.`naryad_id` = 8 AND `NextDNL1`.`next_smena_id` = '66' AND `PlazmaList`.`file_true` = '0')
ORDER BY Detail.sech DESC, Detail.name ASC, DetailNom.A DESC, DetailNom.B DESC, DetailNom.a_s DESC, DetailNom.b_s DESC, Detail.metall DESC, Detail.L DESC, Detail.comment DESC

[leftJoin] => Array(

            [NextDNL1] => Array
                (
                    [class] => tSkladDetNSLink
                    [on] => tSkladDetNSLink.det_id = NextDNL1.next_det_id
                    
					[subpdo] => Array
                        (
                            /* Здесь массив обычных инструкций pdoTools для запроса. Функция getSubSelectSQL преобразует его в SQL код.
							https://github.com/touol/pdoTools/blob/61af551759b1d83a2ee5aba21cbaff772a24312b/core/components/pdotools/model/pdotools/pdofetch.class.php#L390
							Затем джоиниться
							https://github.com/touol/pdoTools/blob/61af551759b1d83a2ee5aba21cbaff772a24312b/core/components/pdotools/model/pdotools/pdofetch.class.php#L352
							*/

                        )

                )
	)

LEFT JOIN (
		#subquery subpdo join 
		SELECT NextDNL.det_id AS next_det_id, NextDNL.naryad_id AS next_naryad_id, NextN.name AS next_naryad_name, NextDNL.smena_id AS next_smena_id, NextS.date AS next_smena_date, NextS.number AS next_smena_number
		FROM `modx_tsklad_detail_naryad_smena_link` AS `NextDNL`
		LEFT JOIN `modx_tsklad_smena` `NextS` ON NextS.id=NextDNL.smena_id
		LEFT JOIN `modx_tsklad_naryad` `NextN` ON NextN.id=NextDNL.naryad_id
		ORDER BY NextS.date ASC, NextS.number ASC) `NextDNL1` 

                ON tSkladDetNSLink.det_id = NextDNL1.next_det_id AND 
                 (NextDNL1.next_smena_date > Smena.date OR (NextDNL1.next_smena_date = Smena.date AND NextDNL1.next_smena_number > Smena.number)
)

[subpdo] => Array
        (
            [smena_limit] => Array
                (
                    /* Здесь массив обычных инструкций pdoTools для запроса. Функция getSubSelectSQL преобразует его в SQL код.
							*/
                )
        )

[on] => tSkladDetNSLink.det_id = NextDNL1.next_det_id 
        and NextDNL1.next_smena_id = ({$subpdo.smena_limit})

ON tSkladDetNSLink.det_id = NextDNL1.next_det_id AND 
 AND NextDNL1.next_smena_id = (
 		#subquery {$subpdo.smena_limit}
		SELECT NextDNL.smena_id AS on_next_smena_id
		FROM `modx_tsklad_detail_naryad_smena_link` AS `NextDNL`
		LEFT JOIN `modx_tsklad_smena` `NextS` ON NextS.id=NextDNL.smena_id
		LEFT JOIN `modx_tsklad_naryad` `NextN` ON NextN.id=NextDNL.naryad_id
		WHERE NextS.date > Smena.date OR (NextS.date = Smena.date AND NextS.number > Smena.number)
		ORDER BY NextS.date ASC, NextS.number ASC
		LIMIT 1
)

Array
(
    [class] => tSkladDetNSLink
    [limit] => 0
    [sortby] => Array
        (
            [Detail.sech] => DESC
            [Detail.name] => ASC
            [DetailNom.A] => DESC
            [DetailNom.B] => DESC
            [DetailNom.a_s] => DESC
            [DetailNom.b_s] => DESC
            [Detail.metall] => DESC
            [Detail.L] => DESC
            [Detail.comment] => DESC
        )

    [sortdir] => 
    [groupby] => 
    [totalVar] => total
    [setTotal] => 
    [tpl] => Smena.Naryad.Plazma.row
    [return] => data
    [select] => Array
        (
            [tSkladDetNSLink] => `tSkladDetNSLink`.`id`, `tSkladDetNSLink`.`name`, `tSkladDetNSLink`.`det_id`, `tSkladDetNSLink`.`naryad_id`, `tSkladDetNSLink`.`smena_id`, `tSkladDetNSLink`.`det_count`, `tSkladDetNSLink`.`smena_count`, `tSkladDetNSLink`.`flanec_con`, `tSkladDetNSLink`.`done`
            [Detail] => `Detail`.`sk_order_id` AS `d_sk_order_id`, `Detail`.`excel_id` AS `d_excel_id`, `Detail`.`nom_id` AS `d_nom_id`, `Detail`.`detail_nom_id` AS `d_detail_nom_id`, `Detail`.`systema` AS `d_systema`, `Detail`.`sys_number` AS `d_sys_number`, `Detail`.`sech` AS `d_sech`, `Detail`.`name` AS `d_name`, `Detail`.`articul` AS `d_articul`, `Detail`.`mark` AS `d_mark`, `Detail`.`A` AS `d_A`, `Detail`.`B` AS `d_B`, `Detail`.`a_s` AS `d_a_s`, `Detail`.`b_s` AS `d_b_s`, `Detail`.`L` AS `d_L`, `Detail`.`number_shina` AS `d_number_shina`, `Detail`.`metall` AS `d_metall`, `Detail`.`detType` AS `d_detType`, `Detail`.`comment` AS `d_comment`, `Detail`.`count` AS `d_count`, `Detail`.`pro_count` AS `d_pro_count`, `Detail`.`sklad_count` AS `d_sklad_count`, `Detail`.`otgr_count` AS `d_otgr_count`, `Detail`.`SN` AS `d_SN`, `Detail`.`price_metall` AS `d_price_metall`, `Detail`.`price_job` AS `d_price_job`, `Detail`.`price` AS `d_price`, `Detail`.`status_id` AS `d_status_id`, `Detail`.`flanec` AS `d_flanec`, `Detail`.`add_job` AS `d_add_job`, `Detail`.`add_mat` AS `d_add_mat`, `Detail`.`price_svarka` AS `d_price_svarka`, `Detail`.`price_pokraska` AS `d_price_pokraska`, `Detail`.`price_office` AS `d_price_office`, `Detail`.`price_ceh` AS `d_price_ceh`, `Detail`.`price_zp` AS `d_price_zp`, `Detail`.`sektor_upravleniya` AS `d_sektor_upravleniya`, `Detail`.`fas_krug` AS `d_fas_krug`, `Detail`.`fas_pryam` AS `d_fas_pryam`, `Detail`.`vozd_krug` AS `d_vozd_krug`, `Detail`.`vozd_pryam` AS `d_vozd_pryam`, `Detail`.`fanec_count0` AS `d_fanec_count0`, `Detail`.`plazma` AS `d_plazma`
            [Order] => `Order`.`period_id` AS `o_period_id`, `Order`.`order_id` AS `o_order_id`, `Order`.`excel_id` AS `o_excel_id`, `Order`.`org_id` AS `o_org_id`, `Order`.`loc_org_id` AS `o_loc_org_id`, `Order`.`type` AS `o_type`, `Order`.`kontragent` AS `o_kontragent`, `Order`.`automobile` AS `o_automobile`, `Order`.`sentdate` AS `o_sentdate`, `Order`.`plan_makedate` AS `o_plan_makedate`, `Order`.`makedate` AS `o_makedate`, `Order`.`sklad_date` AS `o_sklad_date`, `Order`.`otgr_date` AS `o_otgr_date`, `Order`.`createby_user_id` AS `o_createby_user_id`, `Order`.`status_id` AS `o_status_id`, `Order`.`comment` AS `o_comment`, `Order`.`price` AS `o_price`, `Order`.`beznal` AS `o_beznal`, `Order`.`sum_closed` AS `o_sum_closed`, `Order`.`order_date` AS `o_order_date`, `Order`.`koef_zhuk` AS `o_koef_zhuk`
            [Naryad] => `Naryad`.`name` AS `n_name`
            [Smena] => `Smena`.`date` AS `s_date`, `Smena`.`number` AS `s_number`, `Smena`.`hour` AS `s_hour`
            [DetailNom] => `DetailNom`.`class_id` AS `dn_class_id`, `DetailNom`.`sech` AS `dn_sech`, `DetailNom`.`name2` AS `dn_name2`, `DetailNom`.`articul` AS `dn_articul`, `DetailNom`.`articul2` AS `dn_articul2`, `DetailNom`.`A` AS `dn_A`, `DetailNom`.`B` AS `dn_B`, `DetailNom`.`a_s` AS `dn_a_s`, `DetailNom`.`b_s` AS `dn_b_s`, `DetailNom`.`L` AS `dn_L`, `DetailNom`.`number_shina` AS `dn_number_shina`, `DetailNom`.`metall` AS `dn_metall`, `DetailNom`.`gauge` AS `dn_gauge`, `DetailNom`.`detType` AS `dn_detType`, `DetailNom`.`S` AS `dn_S`
            [NomTypeJob] => `NomTypeJob`.`name` AS `tj_name`, `NomTypeJob`.`description` AS `tj_description`
            [NextDNL1] => NextDNL1.next_naryad_id, NextDNL1.next_naryad_name,
        NextDNL1.next_smena_id, NextDNL1.next_smena_date, NextDNL1.next_smena_number
            [0] => tSkladDetNSLink.smena_count as sum_smena_count
            [1] => Detail.SN/tSkladDetNSLink.det_count*tSkladDetNSLink.smena_count as sum_naryad_s
        )

    [leftJoin] => Array
        (
            [Detail] => Array
                (
                    [class] => tSkladOrderList
                    [on] => Detail.id=tSkladDetNSLink.det_id
                )

            [Order] => Array
                (
                    [class] => tSkladOrders
                    [on] => Order.id=Detail.sk_order_id
                )

            [Naryad] => Array
                (
                    [class] => tSkladNaryad
                    [on] => Naryad.id=tSkladDetNSLink.naryad_id
                )

            [Smena] => Array
                (
                    [class] => tSkladSmena
                    [on] => Smena.id=tSkladDetNSLink.smena_id
                )

            [DetailNom] => Array
                (
                    [class] => DetailNom
                    [on] => DetailNom.id=Detail.nom_id
                )

            [DetailClass] => Array
                (
                    [class] => DetailClass
                    [on] => DetailClass.id=DetailNom.class_id
                )

            [NomTypeJob] => Array
                (
                    [class] => NomTypeJob
                    [on] => NomTypeJob.id=DetailClass.type_job_id
                )

            [NextDNL1] => Array
                (
                    [class] => tSkladDetNSLink
                    [on] => tSkladDetNSLink.det_id = NextDNL1.next_det_id and 
        (NextDNL1.next_smena_date > Smena.date OR (NextDNL1.next_smena_date = Smena.date AND  NextDNL1.next_smena_number > Smena.number))
        
        and NextDNL1.next_smena_id = ({$subpdo.smena_limit})
                    [subpdo] => Array
                        (
                            [class] => tSkladDetNSLink
                            [alias] => NextDNL
                            [select] => Array
                                (
                                    [NextDNL] => NextDNL.det_id as next_det_id, NextDNL.naryad_id AS next_naryad_id, NextN.name AS next_naryad_name,
                NextDNL.smena_id AS next_smena_id, NextS.date AS next_smena_date, NextS.number AS next_smena_number
                                )

                            [leftJoin] => Array
                                (
                                    [NextS] => Array
                                        (
                                            [class] => tSkladSmena
                                            [on] => NextS.id=NextDNL.smena_id
                                        )

                                    [NextN] => Array
                                        (
                                            [class] => tSkladNaryad
                                            [on] => NextN.id=NextDNL.naryad_id
                                        )

                                )

                            [sortby] => Array
                                (
                                    [NextS.date] => ASC
                                    [NextS.number] => ASC
                                )

                        )

                )

            [PlazmaList] => Array
                (
                    [class] => PlazmaList
                    [on] => PlazmaList.det_id=tSkladDetNSLink.det_id
                )

        )

    [where] => Array
        (
            [Detail.sech] => pryam
            [Detail.name] => зонт
            [DetailNom.A] => 2000
            [DetailNom.B] => 1500
            [DetailNom.a_s] => 500
            [DetailNom.b_s] => 500
            [Detail.metall] => 0,7Ц
            [Detail.L] => 0
            [Detail.comment] => тип 1, ф355 заузить под наш отвод
            [tSkladDetNSLink.smena_id] => 65
            [tSkladDetNSLink.naryad_id] => 8
            [NextDNL1.next_smena_id] => 66
            [PlazmaList.file_true] => 0
        )

    [tplWrapper] => Smena.Naryad.Plazma.Outer
    [tpl_sort_sum] => Smena.Naryad.Plazma.row_sort_sum
    [subpdo] => Array
        (
            [smena_limit] => Array
                (
                    [class] => tSkladDetNSLink
                    [alias] => NextDNL
                    [select] => Array
                        (
                            [NextDNL] => NextDNL.smena_id AS on_next_smena_id
                        )

                    [leftJoin] => Array
                        (
                            [NextS] => Array
                                (
                                    [class] => tSkladSmena
                                    [on] => NextS.id=NextDNL.smena_id
                                )

                            [NextN] => Array
                                (
                                    [class] => tSkladNaryad
                                    [on] => NextN.id=NextDNL.naryad_id
                                )

                        )

                    [where] => Array
                        (
                            [0] => NextS.date > Smena.date OR (NextS.date = Smena.date AND  NextS.number > Smena.number)
                        )

                    [sortby] => Array
                        (
                            [NextS.date] => ASC
                            [NextS.number] => ASC
                        )

                    [limit] => 1
                )

        )

)

1. Обработка JSON и JS. Хотелось бы, чтоб, если обнаружился JSON или JS, чтоб ошибки вообще не возникало. Для JSON при парсинге кода можно проверить является ли строка JSON. Как проверить, является ли строка JSON'ом на PHP. Для JS отследить открытие тега script.
2. Обработка ошибок феном. Если у юзера есть разрешение fenom_debuger, то на страницу, где возникла ошибка, и в лог и на почту выводить описание ошибки вида:
   
   • Error: Описание ошибки, как сейчас в логе.
   • call stack pdoTools: страница ошибки(id, pagetitle, ссылка в менеджер, № строки)->Шаблон, если ошибка не в контенте страницы(id, name, ссылка в менеджер, № строки)->Чанк (id, name или имя файла, ссылка в менеджер, № строки). (Еще бы сниппет, где возникло если сниппеты вызываются парсером феном это может возможно???). (В классе ввести pdoTools ввести массив call_stack и записывать в него все вызовы чанков)
   
   
   • call stack Femon: У него стандартная для PHP обработка ошибок и полный call stack можно вывести.
   И предусмотреть уровень вывода ошибок наверно.
   
3. Конфигурация модификаторов феном в системных параметрах MODX.Тут которые.. Только по безопасности продумывать надо. Или не надо??
4. Псевдокод. Мне нужно предоставить юзерам возможность вводить и править формулы. С нуля писать интерпретатор псевдокода — это жесть. Тем более в феном уже практически все есть. То есть, ограничение вызываемых функций php. Можно сделать отдельный компонент от pdoTools, но пока не понятно, может лучше конфигуратор параметров pdoTools сделать.
5. femonSyntax вывести из $this->config или разделить $this->config на массив параметров pdoTools и массив конфига запроса pdoTools
6. Проверять на присутствие инструкций фенома перед вызовом getChunk. В walkFunc точно надо.