Im tring to use sugars database structure in a custom php application.
for example you'd write a query something like this
SELECT *
FROM quotes
INNER JOIN quotes_cstm on quotes.id = quotes_cstm.id_c AND quotes.deleted = 0
# some wheres here
From laravel heres an exmaple of my code.
class quotes_cstmModel extends baseModel
{
}
class quotesModel extends baseModel
{
public static $select = ['id', 'name'];
protected $with = ['quotes_cstm'];
public function quotes_cstm()
{
return $this->hasOne('quotes_cstmModel','id_c');
}
}
the toArray output of the quotes model is something like
array(
id => '231312',
name => 'quote name',
quotes_cstm = array(
'id_c' => '231312'
'some_cstm_field_c' => 'some value',
)
);
so what I am asking, how do I just append the id_c and some_cstm_field_c to the main array without the quotes_cstm part of the multidimensional array?
usage example I want something like
Im trying to keep my usage to something like this.
$quote = quotesModel::find('QUOTE_ID_HERE');