17 lines
517 B
PHP
Executable File
17 lines
517 B
PHP
Executable File
<?php
|
|
|
|
function getSubpanelQueryParts($params)
|
|
{
|
|
$bean = $GLOBALS['app']->controller->bean;
|
|
|
|
$return_array['select']='SELECT meetings.id ';
|
|
$return_array['from']='FROM meetings ';
|
|
$return_array['where']=" WHERE meetings.parent_id = '$bean->id'
|
|
AND meetings.parent_type = 'Leads' AND meetings.id NOT IN ( SELECT meeting_id FROM meetings_leads ) ";
|
|
$return_array['join'] = "";
|
|
$return_array['join_tables'][0] = '';
|
|
echo 'lol';
|
|
echo $bean->id;
|
|
|
|
return $return_array;
|
|
} |