$x = DB_DataObject::factory('core_company');
$x->comptype= 'OWNER';
$x->find(true);
-
+
if (!empty($q['query']['company_project_id'])) {
$add = '';
if (!empty($q['query']['company_include_self'])) {
if (!empty($q['query']['company_not_self'])) {
$add = " AND {$tn}.id != {$x->id}";
}
+
$pids = array();
$pid = $q['query']['company_project_id'];
if (strpos($pid, ',')) {
$this->whereAddIn('comptype', explode(',', $q['query']['comptype']), 'string');
}
-
+ /*if (!empty($q['query']['deleted_by'])) {
+ $deleted_by = $this->escape($q['query']['deleted_by']);
+ $this->whereAdd("deleted_by = '$deleted_by'");
+ }*/
// depricated - should be moved to module specific (texon afair)
if (!empty($q['query']['province'])) {
) as comptype_display_name
");
- if(!empty($q['search']['name'])){
- $s = $this->escape($q['search']['name']);
+ if(!empty($q['query']['name'])){
+ $s = $this->escape($q['query']['name']);
$this->whereAdd("
{$tn}.name LIKE '%$s%'
");
function beforeDelete($req, $roo)
{
+
// should check for members....
if(!empty($this->is_system) &&
($old->code != $this->code || $old->name != $this->name)
){
$roo->jerr('This company is not allow to delete');
}
+
+ /*if(!empty($req['_flag_delete']) && $req['_flag_delete'] * 1 == 1){
+ $delete_dt = date('Y-m-d H:i:s');
+ $this->query("UPDATE {$x->tableName()} SET deleted_by = {$this->getAuthUser()} , deleted_dt = {$delete_dt} WHERE id = {$req['_delete']}");
+ //$this->addEvent("UPDATE", false, "update core_company record");
+ $this->jok("Updated");
+ }*/
}
function onDelete($req, $roo)
- {
+ {
+
$img = DB_DataObject::factory('Images');
$img->ontable = $this->tableName();
$img->onid = $this->id;
{
$affects = array();
- $all_links = $x->databaseLinks();
+ $all_links = $this->databaseLinks();
foreach($all_links as $tbl => $links) {
foreach($links as $col => $totbl_col) {