problem in showing DetailView of custom module

[MahsaN]

Hi

I have a custom module which name is invoicemaster and in the invoicemaster.php file I override the save function and at the end of save function return the id which was saved in table but when I click the save button in editview .I can not see detailview , instead I see the error below:

Error retrieving record. This record may be deleted or you may not be authorized to view it.

the code which is written in save function is:

function save($check_notify = FALSE){
$GLOBALS['log']->debug("Mahsa: in the save function");
			$p_id = $GLOBALS['current_user']->account_id;
			$customtype = $this->customtype; 
			$GLOBALS['log']->debug("Mahsa : customtype".$customtype);
			$sex = $this->sex;
			$religion = $this->religon; 
			$status = $this->status ; 
			$billingdate = $this->billingdate; 
			$shippingdate = $this->shippingdate;
			$phone = $this->phone;
			$shippingaddress_city = $this->shippingaddress_city; 
			$shippingaddress_postalcode = $this->shippingaddress_postalcode;
			$shippingaddress_country = $this->shippingaddress_country;
			$shippingaddress_subway = $this->shippingaddress_subway; 
			$shippingaddress_street1 = $this->shippingaddress_street1;
			$shippingaddress_street2 = $this->shippingaddress_street2;
			$shippingaddress_street3 = $this->shippingaddress_street3;
			$shippingaddress_alley = $this->shippingaddress_alley;
			$region = $this->region ;
			$description = $this->description;
		  $this->db->query("BEGIN", true , "Error in begining the transaction");
		  $this->db->query("START TRANSACTION" , true , "Error in starting transaction");
		  $GLOBALS['log']->debug("Mahsa : account id = ".$GLOBALS['current_user']->account_id);
          $query = "SELECT last_invoice_id FROM accounts WHERE id = '18b18262-8e93-6b47-b720-4c1d9e13352b'";
          $result = $this->db->query($query,true,"Error in finding invoice id");
          $row = $this->db->fetchByAssoc($result);
          $last_invoice_id= $row['last_invoice_id'];
          $last_invoice_id +=1;
		  $GLOBALS['log']->debug("Mahsa : last invoice id = ".$last_invoice_id);
          $query = "UPDATE accounts SET last_invoice_id = '".$last_invoice_id."' WHERE id = '18b18262-8e93-6b47-b720-4c1d9e13352b'";
          $result = $this->db->query($query, true , "Error in updating account table");
		  $GLOBALS['log']->debug("Mahsa the result of update the table :".$result);
          if( $this->db->mysql_error){
        
            $this->db->query("ROLLBACK", true , "Error in Rolling back");
          }
          else
          { 
          	$id = create_guid();
            $GLOBALS['log']->debug("Mahsa: else statement before insert query");
          	$query = "INSERT INTO np_invoicemaster ( id , name , customtype , sex , religion ,status , billingdate ,shippingdate , phone ,
          	shippingaddress_city , shippingaddress_postalcode , shippingaddress_country , shippingaddress_subway ,
          	shippingaddress_street1 , shippingaddress_street2 , shippingaddress_street3 , 
          	shippingaddress_alley , region , description )VALUES( '$id' , '$last_invoice_id', '$customtype' , '$sex' , '$religion' ,
          	'$status' , '$billingdate' , '$shippingdate' , '$phone' , '$shippingaddress_city' ,
          	'$shippingaddress_postalcode' , '$shippingaddress_country' , '$shippingaddress_subway' ,
          	'$shippingaddress_street1' , '$shippingaddress_street2' , '$shippingaddress_street3' ,
          	'shippingaddress_alley' , '$region' , '$description')";
          	$result = $this->db->query($query, true ,"Error in inserting data into invoice master table");
			$GLOBALS['log']->debug("Mahsa : the result of inserting in invoice master".$result);
			$this->db->query("COMMIT" , true);
			
          }
		  $GLOBALS['log']->debug("Mahsa : the id is =".$id);
         return $id;
			 
		}

So...what should i do?

[davidboris]

Hi,

Do you see record ID when you are redirected to detail view?

[MahsaN]

hi

when i checked the $id in return id in my save function I can see the value.
but it is not in address bar and at the end of url I see: record=

[davidboris]

Hi,

I can see you have used debug to fill log file, do you have the ID in that?

[MahsaN]

yes.
i have it.

[andopes]

yes.
i have it.

Please, attach the whole php script containing the function save you created.

Cheers

[MahsaN]

ok.
this is my whole php code inNP_ InvoiceMaster.php file and it is attached in this post.

 <?PHP
 require_once('modules/NP_InvoiceMaster/NP_InvoiceMaster_sugar.php');
class NP_InvoiceMaster extends NP_InvoiceMaster_sugar {
    
    //.....Mahsa...///////////////
    var $np_payment_header_id;
    //...........//////////////////
    var $np_good_id;
    function NP_InvoiceMaster(){    
        parent::NP_InvoiceMaster_sugar();
    }
    
    function save($check_notify = FALSE){
       if( $this->is_issue == FALSE)
       {
               return parent::save();
       }
       else
       {
            
            $GLOBALS['log']->debug("Mahsa: in the save function");
            $p_id = $GLOBALS['current_user']->account_id;
            $customtype = $this->customtype; 
            $GLOBALS['log']->debug("Mahsa : customtype".$customtype);
            $sex = $this->sex;
            $religion = $this->religon; 
            $status = $this->status ; 
            $billingdate = $this->billingdate; 
            $shippingdate = $this->shippingdate;
            $phone = $this->phone;
            $shippingaddress_city = $this->shippingaddress_city; 
            $shippingaddress_postalcode = $this->shippingaddress_postalcode;
            $shippingaddress_country = $this->shippingaddress_country;
            $shippingaddress_subway = $this->shippingaddress_subway; 
            $shippingaddress_street1 = $this->shippingaddress_street1;
            $shippingaddress_street2 = $this->shippingaddress_street2;
            $shippingaddress_street3 = $this->shippingaddress_street3;
            $shippingaddress_alley = $this->shippingaddress_alley;
            $region = $this->region ;
            $description = $this->description;
          $this->db->query("BEGIN", true , "Error in begining the transaction");
          $this->db->query("START TRANSACTION" , true , "Error in starting transaction");
          $GLOBALS['log']->debug("Mahsa : account id = ".$GLOBALS['current_user']->account_id);
          $query = "SELECT last_invoice_id FROM accounts WHERE id = '18b18262-8e93-6b47-b720-4c1d9e13352b'";
          $result = $this->db->query($query,true,"Error in finding invoice id");
          $row = $this->db->fetchByAssoc($result);
          $last_invoice_id= $row['last_invoice_id'];
          $last_invoice_id +=1;
          $GLOBALS['log']->debug("Mahsa : last invoice id = ".$last_invoice_id);
          $query = "UPDATE accounts SET last_invoice_id = '".$last_invoice_id."' WHERE id = '18b18262-8e93-6b47-b720-4c1d9e13352b'";
          $result = $this->db->query($query, true , "Error in updating account table");
          $GLOBALS['log']->debug("Mahsa the result of update the table :".$result);
          if( $this->db->mysql_error){
        
            $this->db->query("ROLLBACK", true , "Error in Rolling back");
          }
          else
          { 
              $id = create_guid();
            $GLOBALS['log']->debug("Mahsa: else statement before insert query");
              $query = "INSERT INTO np_invoicemaster ( id , name , customtype , sex , religion ,status , billingdate ,shippingdate , phone ,
              shippingaddress_city , shippingaddress_postalcode , shippingaddress_country , shippingaddress_subway ,
              shippingaddress_street1 , shippingaddress_street2 , shippingaddress_street3 , 
              shippingaddress_alley , region , description )VALUES( '$id' , '$last_invoice_id', '$customtype' , '$sex' , '$religion' ,
              '$status' , '$billingdate' , '$shippingdate' , '$phone' , '$shippingaddress_city' ,
              '$shippingaddress_postalcode' , '$shippingaddress_country' , '$shippingaddress_subway' ,
              '$shippingaddress_street1' , '$shippingaddress_street2' , '$shippingaddress_street3' ,
              'shippingaddress_alley' , '$region' , '$description')";
              $result = $this->db->query($query, true ,"Error in inserting data into invoice master table");
            $GLOBALS['log']->debug("Mahsa : the result of inserting in invoice master".$result);
            $this->db->query("COMMIT" , true);
            
          }
          $GLOBALS['log']->debug("Mahsa : the id is =".$id);
         return $id;
        }     
        }
 
 
}
?>  

[andopes]

At the else clause you have the id hardcoded ('18b18262-8e93-6b47-b720-4c1d9e13352b'). Is that exactly what you want?
If this is what you really want so you have to set $id as this hardcoded id.

Regards

[MahsaN]

No that's not the id which i want.
at the last ELSE statement I have a insert query , and i created the id of table myself with create_guid() . after inserting new record in table i want to return the id of that record to show data in detailview.