bom_header_id)) { $bom_header = bom_header::find_by_id($this->bom_header_id); if (!empty($bom_header->common_bom_item_id_m)) { echo "
Common BOM, No line is saved"; return -90; } } } public static function find_all_by_bomHeaderId($bom_headerId) { $sql = " Select * from "; $sql .= self::$table_name; $sql .= " WHERE bom_header_id = :bom_header_id "; global $db; $value_a = ['bom_header_id' => $bom_headerId]; $all_bom_commonbom_lines = $db->findBySql($sql, $value_a); return $all_bom_commonbom_lines; } public static function find_by_bomHeaderId_lineId($bom_headerId, $line_id) { $sql = " Select * from "; $sql .= self::$table_name; $sql .= " WHERE bom_header_id = :bom_header_id AND bom_line_id = :bom_line_id "; switch (DB_TYPE) { case 'ORACLE' : $sql .= ' AND ' . ino_perPageSql(1); break; default: $sql .= ino_perPageSql(1); break; } global $db; $value_a = ['bom_header_id' => $bom_headerId, 'bom_line_id' => $line_id]; $result = $db->findBySql($sql, $value_a); return !empty($result) ? array_pop($result) : false; } public function findBy_bomHeaderId_lineId() { $sql = " Select * from "; $sql .= self::$table_name; $sql .= " WHERE bom_header_id = :bom_header_id AND bom_line_id = :bom_line_id "; switch (DB_TYPE) { case 'ORACLE' : $sql .= ' AND ' . ino_perPageSql(1); break; default: $sql .= ino_perPageSql(1); break; } $value_a = ['bom_header_id' => $this->bom_header_id, 'bom_line_id' => $this->bom_line_id]; $result = $this->findBySql($sql, $value_a); return !empty($result) ? array_pop($result) : false; } } //end of inv_transaction class ?>