"; } $iscustq = pg_exec($conn, "SELECT type,iscustomid" ." FROM item_types" ." WHERE sernum_first<=$sernum" ." AND $sernum<=sernum_last;" ); if(!$iscustq) { return "Can't pg_exec() for item type."; } if(pg_numrows($iscustq)!=1) { return "No item type is defined for sernum=$sernum."; } $type = pg_result($iscustq,0,'type'); if(pg_result($iscustq,0,'iscustomid') == 'f') { $id = $sernum; } else { $cidq = pg_exec($conn, "SELECT custom_id" ." FROM custom_id" ." WHERE sernum=$sernum"); if(!$cidq) { return "format_default_id(): Error:" ." can't pg_exec() for custom_id
"; } if(pg_numrows($cidq)!=1) { return "format_default_id(): Error:" ." wrong number of rows in pg_exec() for" ." custom_id"; } $id = pg_result($cidq, 0, 'custom_id'); } ### Numeric part is known here. Format it: $res = numeric_to_string($id,$type, &$error); if($errror) { die($errror); } return $res; } #================================================================ # Find an existing sernum of an item by custom_id and type. # Returns serial number of the item or undef. # First arg is necessary to see an incompleted transaction # data on the connection. # function find_sernum($conn, $custom_id,$type) { $custom_id = string_to_numeric($custom_id, $type, $err); if($err) { die($err); } $q = pg_exec($conn, "SELECT iscustomid" ." FROM item_types" ." WHERE type=$type;" ); if(!$q) { echo "Error looking for iscustomid"; exit; } if(pg_numrows($q) != 1) { echo "find_sernum(): unknown item type"; exit; } $iscustomid = pg_result($q,0,'iscustomid'); if($iscustomid == 'f') { $sernum = $custom_id; } else { $q = pg_exec($conn, "SELECT sernum" ." FROM custom_id" ." WHERE type=$type AND custom_id=$custom_id;" ); if(!$q) { echo "Error in pg_exec() for sernum."; exit; } if(pg_numrows($q)==1) { $sernum = pg_result($q,0,'sernum'); } else { unset($sernum); } } return $sernum; } ################################################################ # Looks for existing sernum of the item or assigns a new one. # Should be called after start_transaction() call and before commit. function make_sernum($conn,$item_id, $item_type) { $item_id = string_to_numeric($item_id, $item_type, $err); if($err) { die($err); } $item_sernum = find_sernum($conn,$item_id, $item_type); if(!isset($item_sernum)) { # Take the first unused sernum from the appropriate range. $nsq = pg_exec($conn, "INSERT INTO custom_id" ." (tn,sernum,custom_id,type)" ." SELECT currval('tn'),max(" ." CASE WHEN custom_id.type=$item_type" ." THEN sernum+1" ." ELSE sernum_first" ." END" ." ),$item_id,$item_type" ." FROM custom_id,item_types" ." WHERE item_types.type=$item_type;" ); if(!$nsq) { echo "Error assigning new sernum to the item."; pg_exec($conn, "ROLLBACK;"); exit; } $item_sernum = find_sernum($conn,$item_id, $item_type); if(!isset($item_sernum)) { echo "Strange error trying to obtain item's sernum."; pg_exec($conn, "ROLLBACK;"); exit; } } return $item_sernum; } ################################################################ # OLD. DEPRECATED. Use edit_std_id() instead. # Check validity of item's id (format and numeric value). # Returns "canonical" string representation of the id. function check_item_id($id,$type) { global $conn; $id = trim($id); if("$id" == "") { die("You have to specify item id." . BACKMSG); } # This checks format of the $id $id = string_to_numeric($id, $type, $err); if($err) { die($err); } $q = pg_exec($conn, "SELECT sernum_first,sernum_last,iscustomid" ." FROM item_types" ." WHERE type=$type;" ); if(!$q) { die("Can't pg_exec() for sernum range."); } if(pg_numrows($q) != 1) { die("Error in check_item_id(): unknown item type $type"); } # Numeric value can be checked only # when custom ids are not used. if(pg_result($q,0,'iscustomid') == 'f') { $sernum_first = pg_result($q,0,'sernum_first'); $sernum_last = pg_result($q,0,'sernum_last'); if($id<$sernum_first || $id>$sernum_last) { echo "Entered number $id is outside" ." of the valid range ($sernum_first, $sernum_last).\n" . BACKMSG; exit; } } $res = numeric_to_string($id,$type, &$error); if($error) { die($error); } return $res; } ################################################################