Run multiple Queries in view.edit.php

[chrislynch8]

Hi,

I have a custom modules and I have created a view.edit.php yo inherite the team_id of the record it was created under.

The custom mondule can only be created under contacts so this teh what I want to do.

 <?php
require_once('include/MVC/View/views/view.edit.php');
class fdc_dependentsViewEdit extends ViewEdit
{
    function fdc_dependentsViewEdit()
    {
        parent::SugarView();
    }
    function display(){
 
    //$this->ev->process();
 
    $this->ev->process();
 
    if (empty($this->ev->focus->id))
    {
        if (!empty($_REQUEST['return_id']))
        {
            $query="SELECT team_id FROM contacts WHERE id ='".$_REQUEST['return_id']."'";
            $res=$this->bean->db->query($query);
            $row=$this->bean->db->fetchByAssoc($res);
            if (!empty($row))
            {
                $this->ev->fieldDefs['team_id']['value'] = $row['team_id'];
            }
        }
 
}
 
//echo $this->ev->display();
echo $this->ev->display();
 
}
 
}  

The $_REQUEST[return_id] returns the ID of the Custom module and to get the team_id from the contact I need to run the following two queries.

 $query1 = "SELECT contacts_idb FROM fdc_dependents_contacts WHERE fdc_dependents_ida ='".$_REQUEST['return_id']."'";
$query2 = "SELECT team_id FROM contacts WHERE id = RESULT OF $query1"; 
  

I can then past the result of $query2 tothe team_id of teh custom module.

How can I do this

Rgds
Chris

[andopes]

You can write a single query with a join between both tables.

Cheers

[chrislynch8]

Hi andopes,

Can you give an example of this - I'm not an expert in mysql yet, only just getting used to simple queries...

Rgds
Chris

[chrislynch8]

My old statement works just fine - this is now ok...

[cmacholz]

Where did you create your view.edit.php file?

I'm trying to do the same thing but I'm confused on which view.edit.php file to change/edit/create.

Thanks.