Thread

$accepted_documents = new Document();
$accepted_documents->select('id')
    ->where_related('sme_profile', 'id', $this->sme_profile->id);
$documents = new Document();
$documents->where_not_in_subquery('id', $accepted_documents);
return $documents->count() > 0 ? TRUE : FALSE;

$documents->where_related('sme_profile', 'id !=', $this->sme_profile->id);

SELECT COUNT(*) AS `numrows`
FROM (`tdb_documents`)
LEFT OUTER JOIN `tdb_join_documents_products` tdb_join_documents_products ON `tdb_documents`.`id` = `tdb_join_documents_products`.`document_id`
LEFT OUTER JOIN `tdb_products` tdb_products ON `tdb_products`.`id` = `tdb_join_documents_products`.`product_id`
LEFT OUTER JOIN `tdb_join_products_purchases` product_tdb_join_products_purchases ON `tdb_products`.`id` = `product_tdb_join_products_purchases`.`product_id`
LEFT OUTER JOIN `tdb_purchases` product_tdb_purchases ON `product_tdb_purchases`.`id` = `product_tdb_join_products_purchases`.`purchase_id`
LEFT OUTER JOIN `tdb_join_documents_locations_projects` tdb_join_documents_locations_projects ON `tdb_documents`.`id` = `tdb_join_documents_locations_projects`.`document_id`
LEFT OUTER JOIN `tdb_join_documents_sme_profiles` tdb_join_documents_sme_profiles ON `tdb_documents`.`id` = `tdb_join_documents_sme_profiles`.`document_id`
LEFT OUTER JOIN `tdb_sme_profiles` tdb_sme_profiles ON `tdb_sme_profiles`.`id` = `tdb_join_documents_sme_profiles`.`sme_profile_id`
WHERE  (
`product_tdb_purchases`.`sme_profile_id` = 1
OR tdb_join_documents_locations_projects.id IN (SELECT `tdb_join_documents_locations_projects`.`id`
    FROM (`tdb_join_documents_locations_projects`)
    LEFT OUTER JOIN `tdb_projects` tdb_projects ON `tdb_projects`.`id` = `tdb_join_documents_locations_projects`.`project_id`
    LEFT OUTER JOIN `tdb_join_projects_purchases` project_tdb_join_projects_purchases ON `tdb_projects`.`id` = `project_tdb_join_projects_purchases`.`project_id`
    LEFT OUTER JOIN `tdb_purchases` project_tdb_purchases ON `project_tdb_purchases`.`id` = `project_tdb_join_projects_purchases`.`purchase_id`
    WHERE `project_tdb_purchases`.`sme_profile_id` = 1
    AND `tdb_join_documents_locations_projects`.`location_id` = '1')
)
AND `tdb_sme_profiles`.`id` != 1

var $has_many = array(
        'movies' => array(
            'class' => 'movie',
            'other_field' => 'movie_id'
        )
    );

var $has_many = array(
        'users' => array(
            'class' => 'user',
            'other_field' => 'user_id'
        )
    );

//Check if Search data is sent
            if($this->input->post('sSearch'))
            {                
                //Initiate a new SQL Query group
                $obj->group_start();
                
                //Create a loop to go over each column
                foreach($columns as $position => $column)
                {

                    //Add a the SQL statment for searching in that column to the Query Group
                    $obj->or_like($column, $this->input->post('sSearch'));
                }
                
                //Close the SQL Query Group 
                $obj->group_end();
            }

A Database Error Occurred

Error Number: 1054

Unknown column 'avaliator_name' in 'where clause'

SELECT `browsers`.*, `avaliators`.`name` AS avaliator_name FROM (`browsers`) LEFT OUTER JOIN `avaliators` avaliators ON `avaliators`.`id` = `browsers`.`avaliator_id` WHERE ( `browsers`.`engine` LIKE '% Microso%' OR `browsers`.`browser` LIKE '% Microso%' OR `browsers`.`platform` LIKE '% Microso%' OR `browsers`.`version` LIKE '% Microso%' OR `avaliator_name` LIKE '% Microso%' ) ORDER BY `browsers`.`engine` asc

//Check if Search data is sent
if($this->input->post('sSearch'))
{                
    //Initiate a new SQL Query group
    $obj->group_start();
                
    //Create a loop to go over each column
    foreach($columns as $position => $column)
    {
        //Add a the SQL statment for searching in that column to the Query Group
        $obj->or_like($column, $this->input->post('sSearch'));
    }

    // You need some way to know which related object to look at
    // Here, I've chosen to have an array of related objects and their columns.
    foreach($related as $related_object => $columns)
    {
        foreach($columns as $column) {
            //Add a the SQL statment for searching in that column to the Query Group
            $obj->or_like_related($related_object, $column, $this->input->post('sSearch'));
        }
    }
           
    //Close the SQL Query Group
    $obj->group_end();
}

//Variable with columns of the table
    var TableColums = [{ "sName": "engine" },
                       { "sName": "browser" },
                       { "sName": "platform" },
                       { "sName": "version" },
                       { "sName": "avaliator_name" } //Deep relationship column
                      ];
    
    //Initiate the table
        //The paramters are:
        //The id of the table container, the object to be loaded, the columns of the table
    
        initTableGrid("#browser", 'browser', TableColums);

$obj->or_like_related('avaliator/company/manager', 'name', $this->input->post('sSearch'));

Fatal error: Class 'town' not found in C:\xampp\htdocs\NEWSDT\sdt\application\libraries\datamapper.php on line 4472

$file = $path . DataMapper::$config['models_path'] . 'models/' . $class . EXT;

Table 'sdt.general_county_general_towns_country' doesn't exist

SELECT general_county.* FROM (general_county) LEFT OUTER JOIN general_county_general_towns_country general_county_general_towns_country ON general_county.id = general_county_general_towns_country.county_id WHERE `general_county_general_towns_country`.`townscountry_id` = 4

class TownsCountry extends DataMapper
{
    public $table ="general_towns_country";    
    
    /*var $has_one = array('town'=>array('class'=>'town',
                                       'other_field'=>'tid'
                                       ),
                        'general_country'=>array('class'=>'country',
                                         'other_field'=>'countryid'
                                       ),
                        'general_county'=>array('class'=>'county',
                                        'other_field'=>'cid'
                                       )
                                                    
                                                    );*/
    public $has_one = array('town','country','county');

    public function __construct()
    {
        // model constructor
        parent::__construct();    
         
    }
    
}

class Country extends DataMapper
{
    public $table ="general_country";    
    /*public $has_many = array('countryid'=>array('class'=>'townscountry',
                                                   'other_field'=>'general_country'                                                         
                                                      )
                            );*/
    
    public $has_many = array('townscountry');
    public function __construct()
    {
        // model constructor
        parent::__construct();
    }
    
}

class Town extends DataMapper
{
    public $table ="town";    
    /*public $has_many = array('tid'=>array('class'=>'townscountry',
                                                   'other_field'=>'town'                                                         
                                                      )
                            );*/
    public $has_many = array('townscountry');

    public function __construct()
    {
        // model constructor
        parent::__construct();
        
    }
    
}

class County extends DataMapper
{
    public $table ="general_county";    
/*public $has_many = array('cid'=>array('class'=>'townscountry',
                                                   'other_field'=>'general_county'                                                         
                                                      )
                            );*/
    var $has_many = array('townscountry');
                            
    public function __construct()
    {
        // model constructor
        parent::__construct();
    }
    
}