public static function DRP_Units($dropdownName, $selectedID = "", $extraRow = "", $width = "", $where = "") { $query = "select ouid,ptitle from org_new_units"; $query .= $where != "" ? " where " . $where : ""; $obj = new AutoComplete_DROPDOWN(); $temp = parent::runquery($query); $obj->datasource = $temp; $obj->valuefield = "%ouid%"; $obj->textfield = "%ptitle%"; $obj->width = $width; $obj->Style = 'class="x-form-text x-form-field" style="width:' . $width . '" '; $obj->id = $dropdownName; if (!empty($extraRow)) { $obj->datasource = array_merge(array(array("ouid" => "-1", "ptitle" => $extraRow)), $obj->datasource); } $return = $obj->bind_dropdown($selectedID); return $return; }
public static function DRP_Jobs($dropdownName, $selectedID = "", $formName = "", $style = "") { $query = "select job_id,title,job_group from HRM_jobs"; $obj = new AutoComplete_DROPDOWN(); $temp = PdoDataAccess::runquery($query); $obj->datasource = $temp; $obj->valuefield = "%job_id%"; $obj->textfield = "%title%"; $obj->formName = $formName; $obj->withStoreObject = true; $obj->Style = 'class="x-form-text x-form-field" style="' . $style . '"'; $obj->id = $dropdownName; return $obj->bind_dropdown_returnObjects($selectedID); }