public $file_location; // string(254) not_null
public $open_date; // date(10) binary
public $open_by; // int(11) not_null
+ public $close_date; // date(10) binary
public $countries; // string(128) not_null
public $languages; // string(128) not_null
- public $close_date; // date(10) binary
public $agency_id; // int(11) not_null
$pr->whereAdd("Projects.type IN ('N','X')");
$prjs = $pr->fetchAll('id');
-
+ //DB_DataObject::debugLevel(1);
$pd = DB_DataObject::factory('ProjectDirectory');
$pd->joinAdd(DB_DataObject::factory('Projects'), 'LEFT');
$pd->whereAdd("Projects.type NOT IN ('N','X')");
// this is clipping related.. -- we should have an API for addons like this.. (and docs)
- if ($au->company()->comptype == 'SUPPLIER') {
- $pr = DB_DataObject::factory('CampaignAssign');
- $pr->supplier_id = $au->company_id;
- $prjs = $pr->fetchAll('project_id');
- if (count($prjs)) {
- $this->whereAdd("
- (Projects.id IN (".implode(',', $prjs)."))
- ");
- } else {
- $this->whereAdd("1=0"); // can see nothing!!!
- }
- }
- if ($au->company()->comptype == 'CLIENT') {
- $this->client_id = $au->company()->id; // can see nothing!!!
-
- }
+
return true;
}
- function fetchAll($k= false) {
- if ($k !== false) {
- $this->selectAdd();
- $this->selectAdd($k);
- }
-
- $this->find();
- $ret = array();
- while ($this->fetch()) {
- $ret[] = $k === false ? clone($this) : $this->$k;
- }
- return $ret;
-
- }
/**
* fetch a list of user projects.
* if you need to filter open/closed.. then add whereAdds before calling
*/
- function getUserProjects($au, $data='id') // COMPANY BASED!!!!
+ function userProjects($au, $data='id') // COMPANY BASED!!!!
{
+
$id = (int) $au->company_id;
+
$this->whereAdd("
(client_id= $id) OR (agency_id= $id)
");
- if (!empty($data)) {
- $this->selectAdd();
- $this->selectAdd($data);
- }
- $this->find();
- $ret = array();
- while ($this->fetch()) {
- $ret[] = empty($data) ? clone($this) : $this->$data;
- }
- return $ret;
+
+ return empty($data) ? $this->fetchAll() :$this->fetchAll($data);
+
+
+ }
+
+ // DEPRICATED - use userProjects
+
+ function getUserProjects($au, $data='id') // COMPANY BASED!!!!
+ {
+ return $this->userProjects($au, $data);
+
}