/**
* Generates various pulldown (<option>...</option>) lists for ready use in HTML
* Output is set to e.g. $this->data['lists']['milestones']
*
*/
function __pulldownLists()
{
//profiling
$this->data['controller_profiling'][] = __FUNCTION__;
//[all_departments]
$data = $this->tickets_departments_model->allDepartments();
$this->data['debug'][] = $this->tickets_departments_model->debug_data;
$this->data['lists']['all_departments'] = create_pulldown_list($data, 'tickets_departments', 'id');
//[all_team_members]
$data = $this->teamprofile_model->allTeamMembers('team_profile_full_name', 'ASC');
$this->data['debug'][] = $this->teamprofile_model->debug_data;
$this->data['lists']['all_team_members'] = create_pulldown_list($data, 'team_members', 'id');
//[all_users]
$data = $this->users_model->allUsers('client_users_full_name', 'ASC');
$this->data['debug'][] = $this->users_model->debug_data;
$this->data['lists']['all_users'] = create_pulldown_list($data, 'users', 'id');
//[all_clients]
$data = $this->clients_model->allClients('clients_company_name', 'ASC');
$this->data['debug'][] = $this->clients_model->debug_data;
$this->data['lists']['all_clients'] = create_pulldown_list($data, 'clients', 'id');
}
/**
* Generates various pulldown (<option>...</option>) lists for ready use in HTML
* Output is set to e.g. $this->data['lists']['milestones']
*
*/
function __pulldownLists()
{
//profiling
$this->data['controller_profiling'][] = __FUNCTION__;
//[all_team_members]
$data = $this->teamprofile_model->allTeamMembers('team_profile_full_name', 'ASC');
$this->data['debug'][] = $this->teamprofile_model->debug_data;
$this->data['lists']['all_team_members'] = create_pulldown_list($data, 'team_members', 'id');
}
/**
* Generates various pulldown (<option>...</option>) lists for ready use in HTML
* Output is set to e.g. $this->data['lists']['milestones']
*
*/
function __pulldownLists()
{
//profiling
$this->data['controller_profiling'][] = __FUNCTION__;
//[all_clients]
$data = $this->clients_model->allClients('clients_company_name', 'ASC');
$this->data['debug'][] = $this->clients_model->debug_data;
$this->data['lists']['all_clients'] = create_pulldown_list($data, 'clients', 'name');
//[all_users_email]
$data = $this->users_model->allUsers('client_users_full_name', 'ASC');
$this->data['debug'][] = $this->users_model->debug_data;
$this->data['lists']['all_users_email'] = create_pulldown_list($data, 'users_email', 'name');
}
/**
* Generates various pulldown (<option>...</option>) lists for ready use in HTML
* Output is set to e.g. $this->data['lists']['milestones']
*/
function __pulldownLists()
{
//profiling
$this->data['controller_profiling'][] = __FUNCTION__;
//[all_groups_id]
$data = $this->groups_model->allGroups('groups_name', 'ASC');
$this->data['debug'][] = $this->groups_model->debug_data;
$this->data['lists']['all_groups_id'] = create_pulldown_list($data, 'groups', 'id');
}
/**
* Generates various pulldown (<option>...</option>) lists for ready use in HTML
* Output is set to e.g. $this->data['lists']['milestones']
*
*
*
*
*/
function __pulldownLists()
{
//profiling
$this->data['controller_profiling'][] = __FUNCTION__;
//[all_groups]
$data = $this->tickets_departments_model->allDepartments();
$this->data['debug'][] = $this->tickets_departments_model->debug_data;
$this->data['lists']['all_departments_id'] = create_pulldown_list($data, 'tickets_departments', 'id');
}
/**
* Generates various pulldown (<option>...</option>) lists for ready use in HTML
* Output is set to e.g. $this->data['lists']['milestones']
*/
function __pulldownLists()
{
//profiling
$this->data['controller_profiling'][] = __FUNCTION__;
//[all_invoice_items]
$data = $this->invoice_items_model->allItems('invoice_items_title', 'ASC');
$this->data['debug'][] = $this->invoice_items_model->debug_data;
$this->data['lists']['all_invoice_items'] = create_pulldown_list($data, 'invoice_items', 'id');
//[payment_methods]
$data = $this->settings_payment_methods_model->paymentMethods('enabled');
$this->data['debug'][] = $this->settings_payment_methods_model->debug_data;
$this->data['lists']['payment_methods'] = create_pulldown_list($data, 'payment_methods', 'id');
}
/**
* Generates various pulldown (<option>...</option>) lists for ready use in HTML
* Output is set to e.g. $this->data['lists']['milestones']
*
*/
function __pulldownLists()
{
//profiling
$this->data['controller_profiling'][] = __FUNCTION__;
//[all_quotation_forms]
$data = $this->quotationforms_model->allQuotationForms('enabled');
$this->data['debug'][] = $this->quotationforms_model->debug_data;
$this->data['lists']['all_quotation_forms'] = create_pulldown_list($data, 'quotation_forms', 'id');
}
/**
* Generates various pulldown (<option>...</option>) lists for ready use in HTML
* Output is set to e.g. $this->data['lists']['milestones']
*
*/
function __pulldownLists()
{
//profiling
$this->data['controller_profiling'][] = __FUNCTION__;
//[memebers projects]
$data = $this->project_members_model->membersProjects(0, 'list', $this->data['vars']['my_id'], 'open');
$this->data['debug'][] = $this->project_members_model->debug_data;
$this->data['lists']['all_projects'] = create_pulldown_list($data, 'projects', 'id');
}
/**
* Generates various pulldown (<option>...</option>) lists for ready use in HTML
* Output is set to e.g. $this->data['lists']['milestones']
*/
function __pulldownLists()
{
//profiling
$this->data['controller_profiling'][] = __FUNCTION__;
//[all_projects]
$data = $this->projects_model->allProjects('projects_title', 'ASC');
$this->data['debug'][] = $this->projects_model->debug_data;
$this->data['lists']['all_projects'] = create_pulldown_list($data, 'projects', 'id');
}
/**
* create project list based on project id
*/
function __clientsProjectsList()
{
//profiling
$this->data['controller_profiling'][] = __FUNCTION__;
//load the models that we will use
$this->load->model('projects_model');
//get post daataa
$clients_id = $this->input->post('data_mysql_record_id');
//flow control
$next = true;
//validate post
if (!is_numeric($clients_id)) {
//log this error
log_message('error', 'AJAX-LOG:: [FILE: ' . __FILE__ . '] [FUNCTION: ' . __FUNCTION__ . '] [LINE: ' . __LINE__ . "] [MESSAGE: Fetch projects list error: invalid input]");
//halt
$next = false;
}
//get all milestones for this project
if ($next) {
//get list of milestone for the project
$result = $this->projects_model->allProjects('projects_title', 'ASC', $clients_id, '');
$this->data['debug'][] = $this->projects_model->debug_data;
if (is_array($result)) {
//create a list from results
$list = create_pulldown_list($result, 'projects', 'id');
//json output
$this->jsondata = array('result' => 'success', 'list' => $list);
//send headers
header('HTTP/1.0 200 OK', true, 200);
} else {
//log this messsage
log_message('error', 'AJAX-LOG:: [FILE: ' . __FILE__ . '] [FUNCTION: ' . __FUNCTION__ . '] [LINE: ' . __LINE__ . "] [MESSAGE: Database Error]");
//halt
$next = false;
}
}
//an error occurred, send to javascript
if (!$next) {
//json output
$this->jsondata = array('result' => 'failed', 'message' => $this->data['lang']['lang_requested_item_not_loaded'], 'debug_line' => __LINE__);
//send headers
header('HTTP/1.0 400 Bad Request', true, 400);
}
//log debug data
$this->__ajaxdebugging();
//load the view for json echo
$this->__flmView('common/json');
}
/**
* Generates various pulldown (<option>...</option>) lists for ready use in HTML
* Output is set to e.g. $this->data['lists']['milestones']
*
*/
function __pulldownLists()
{
//profiling
$this->data['controller_profiling'][] = __FUNCTION__;
//[all clients]
$data = $this->clients_model->allClients('clients_company_name', 'ASC');
$this->data['debug'][] = $this->clients_model->debug_data;
$this->data['lists']['all_clients'] = create_pulldown_list($data, 'clients', 'id');
//[all user emails]
$data = $this->projects_model->allProjects('projects_title', 'ASC');
$this->data['debug'][] = $this->projects_model->debug_data;
$this->data['lists']['all_projects'] = create_pulldown_list($data, 'projects', 'name');
}