$cgm = DB_DataObject::Factory('core_group_member')->tableName();;
$this->selectAdd("
- (
- SELECT
- count(user_id)
- FROM
- {$cgm}
- WHERE
- to_group_id = {$cgm}.group_id
- )
- AS group_member_count,
+ (
+ SELECT
+ count(id)
+ FROM
+ {$cgm}
+ WHERE
+ to_group_id = {$cgm}.group_id
+ ) AS group_member_count,
- (
- SELECT
- count(user_id)
- FROM
- {$cgm}
- WHERE
- bcc_group_id = {$cgm}.group_id
- )
- AS bcc_group_member_count
+ (
+ SELECT
+ count(id)
+ FROM
+ {$cgm}
+ WHERE
+ bcc_group_id = {$cgm}.group_id
+ ) AS bcc_group_member_count
");
}
return;
}
$c = DB_DataObject::Factory('core_company');
- $tc =$c->count();
-
+ $tc = $c->count();
if (!$tc || $tc> 1) {
$roo->jerr("can not create initial user as multiple companies already exist");
}
[core_email]
owner_id = core_person:id
-bcc_group = core_group:id
-to_group = core_group:id
+bcc_group_id = core_group:id
+to_group_id = core_group:id
[core_ip_access]
function initEmails($templateDir, $emails)
{
-
+ HTML_FlexyFramework::get()->generateDataobjectsCache(true);
+
$pg = HTML_FlexyFramework::get()->page;
foreach($emails as $name=>$data) {
$cm = DB_DataObject::factory('core_email');
$update = $cm->get('name', $name);
$old = clone($cm);
- if (empty($cm->bcc_group)) {
+ if (empty($cm->bcc_group_id)) {
if (empty($data['bcc_group'])) {
$this->jerr("missing bcc_group for template $name");
}
}
$cm->test_class = $data['test_class'];
//}
- if(isset($cm->to_group)) {
+ if(isset($cm->to_group_id)) {
print_r('isset');
}
if (
!empty($data['to_group']) &&
- (!isset($cm->to_group) || !empty($cm->to_group))
+ (!isset($cm->to_group_id) || !empty($cm->to_group_id))
) {
$gp = DB_DataObject::Factory('core_group')->lookup('name',$data['to_group']);
$this->jerr("to_group {$data['to_group']} does not exist when importing template $name");
}
- $cm->to_group = $gp->id;
+ $cm->to_group_id = $gp->id;
}
if(
ALTER TABLE core_email ADD COLUMN active INT(2) NOT NULL DEFAULT 1;
-- need to store BCC data here.
-ALTER TABLE core_email CHANGE COLUMN bcc_group_ bcc_group_id INT(11) NOT NULL DEFAULT 0;
+ALTER TABLE core_email CHANGE COLUMN bcc_group bcc_group_id INT(11) NOT NULL DEFAULT 0;
ALTER TABLE core_email ADD COLUMN bcc_group_id INT(11) NOT NULL DEFAULT 0;
-- each email template should have a test class with a static method ::test_{name}
ALTER TABLE core_email ADD COLUMN test_class VARCHAR(254) NOT NULL DEFAULT '';
ALTER TABLE core_email CHANGE COLUMN in_group to_group_id INT(11) NOT NULL DEFAULT -1;
+ALTER TABLE core_email CHANGE COLUMN to_group to_group_id INT(11) NOT NULL DEFAULT -1;
ALTER TABLE core_email ADD COLUMN to_group_id INT(11) NOT NULL DEFAULT -1;
+
UPDATE core_email SET updated_dt = NOW() where updated_dt IS NULL;