/** * Return record model by it id. * @param type $id * @return \self */ public static function getInstanceById($id) { $instance = new SPPDFTemplates_Record_Model(); if (!isset($id) || $id == '') { return $instance; } $db = PearDatabase::getInstance(); $query = 'SELECT * FROM sp_templates WHERE templateid=?'; $params = array($id); $result = $db->pquery($query, $params); if ($db->num_rows($result) > 0) { $row = $db->query_result_rowdata($result, 0); $instance->setData($row); } return $instance; }