@@ -27,9 +27,9 @@ discard block |
||
27 | 27 | $this->body('amount'), |
28 | 28 | $this->body('currency'), |
29 | 29 | $language, |
30 | - NET_SCHEME . NET_HOST. $this->url('../', array('status' => 'success')), |
|
31 | - NET_SCHEME . NET_HOST. $this->url('../payment', array('action_store_identifier' => $this->body('action_store_identifier'), 'payment_error' => 'true')), |
|
32 | - NET_SCHEME . NET_HOST. $this->url('/process', array('action_store_identifier' => $this->body('action_store_identifier'))), |
|
30 | + NET_SCHEME.NET_HOST.$this->url('../', array('status' => 'success')), |
|
31 | + NET_SCHEME.NET_HOST.$this->url('../payment', array('action_store_identifier' => $this->body('action_store_identifier'), 'payment_error' => 'true')), |
|
32 | + NET_SCHEME.NET_HOST.$this->url('/process', array('action_store_identifier' => $this->body('action_store_identifier'))), |
|
33 | 33 | $this->query(), |
34 | 34 | $this->body() |
35 | 35 | ); |
@@ -47,7 +47,7 @@ discard block |
||
47 | 47 | 'form_action' => $form_action, |
48 | 48 | 'language' => $language); |
49 | 49 | |
50 | - $tpl = $this->template->create(dirname(__FILE__) . '/templates/postform'); |
|
50 | + $tpl = $this->template->create(dirname(__FILE__).'/templates/postform'); |
|
51 | 51 | return $tpl->render($this, $data); |
52 | 52 | } |
53 | 53 |
@@ -36,7 +36,7 @@ discard block |
||
36 | 36 | 'modulepackageshop' => $modulepackageshop, |
37 | 37 | 'modulepackage' => $this->modulepackage, |
38 | 38 | 'kernel' => $this->getKernel()); |
39 | - $tpl = $this->template->create(dirname(__FILE__) . '/templates/add-package'); |
|
39 | + $tpl = $this->template->create(dirname(__FILE__).'/templates/add-package'); |
|
40 | 40 | return $tpl->render($this, $data); |
41 | 41 | } |
42 | 42 | |
@@ -86,7 +86,7 @@ discard block |
||
86 | 86 | if ($this->getKernel()->intranet->address->get('name') != $this->getKernel()->user->getAddress()->get('name')) { |
87 | 87 | $contact['contactperson'] = $this->getKernel()->user->getAddress()->get('name'); |
88 | 88 | $contact['contactemail'] = $this->getKernel()->user->getAddress()->get('email'); |
89 | - $contact['contactphone'] = $this->getKernel()->user->getAddress()->get('phone'); |
|
89 | + $contact['contactphone'] = $this->getKernel()->user->getAddress()->get('phone'); |
|
90 | 90 | } |
91 | 91 | |
92 | 92 | // We add the contact_id. But notice, despite of the bad naming the contact_id is the contact_id in the intranet_maintenance intranet! |
@@ -62,7 +62,7 @@ |
||
62 | 62 | 'email_shared' => $email_shared |
63 | 63 | ); |
64 | 64 | |
65 | - $tpl = $this->template->create(dirname(__FILE__) . '/templates/index'); |
|
65 | + $tpl = $this->template->create(dirname(__FILE__).'/templates/index'); |
|
66 | 66 | return $tpl->render($this, $data); |
67 | 67 | } |
68 | 68 |
@@ -56,10 +56,10 @@ discard block |
||
56 | 56 | */ |
57 | 57 | public function load() |
58 | 58 | { |
59 | - $result = $this->db->query("SELECT module_package.id, module_package.product_id, module_package_group.group_name AS ".$this->db->quoteIdentifier('group').", module_package_plan.plan, module_package_plan.plan_index, module_package_group.id AS group_id " . |
|
60 | - "FROM module_package " . |
|
61 | - "INNER JOIN module_package_group ON module_package.module_package_group_id = module_package_group.id " . |
|
62 | - "INNER JOIN module_package_plan ON module_package.module_package_plan_id = module_package_plan.id " . |
|
59 | + $result = $this->db->query("SELECT module_package.id, module_package.product_id, module_package_group.group_name AS ".$this->db->quoteIdentifier('group').", module_package_plan.plan, module_package_plan.plan_index, module_package_group.id AS group_id ". |
|
60 | + "FROM module_package ". |
|
61 | + "INNER JOIN module_package_group ON module_package.module_package_group_id = module_package_group.id ". |
|
62 | + "INNER JOIN module_package_plan ON module_package.module_package_plan_id = module_package_plan.id ". |
|
63 | 63 | "WHERE module_package.id = ".$this->db->quote($this->id, 'integer')); |
64 | 64 | |
65 | 65 | if (PEAR::isError($result)) { |
@@ -93,8 +93,8 @@ discard block |
||
93 | 93 | $id = intval($id); |
94 | 94 | } |
95 | 95 | |
96 | - $result = $this->db->query("SELECT id, module, limiter " . |
|
97 | - "FROM module_package_module " . |
|
96 | + $result = $this->db->query("SELECT id, module, limiter ". |
|
97 | + "FROM module_package_module ". |
|
98 | 98 | "WHERE module_package_module.module_package_id = ".$this->db->quote($id, 'integer')); |
99 | 99 | |
100 | 100 | if (PEAR::isError($result)) { |
@@ -61,7 +61,7 @@ discard block |
||
61 | 61 | public function load() |
62 | 62 | { |
63 | 63 | $db = new DB_Sql; |
64 | - $db->query("SELECT id, name, email, phone, mobile, contact_id FROM contact_person WHERE id = " . $this->id . " LIMIT 1"); |
|
64 | + $db->query("SELECT id, name, email, phone, mobile, contact_id FROM contact_person WHERE id = ".$this->id." LIMIT 1"); |
|
65 | 65 | while ($db->nextRecord()) { |
66 | 66 | $this->value['id'] = $db->f('id'); |
67 | 67 | $this->value['name'] = $db->f('name'); |
@@ -99,7 +99,7 @@ discard block |
||
99 | 99 | |
100 | 100 | if ($this->id > 0) { |
101 | 101 | $sql_type = "UPDATE "; |
102 | - $sql_end = " WHERE id = " . $this->id; |
|
102 | + $sql_end = " WHERE id = ".$this->id; |
|
103 | 103 | } else { |
104 | 104 | $sql_type = "INSERT INTO "; |
105 | 105 | $sql_end = ", date_created = NOW()"; |
@@ -108,15 +108,15 @@ discard block |
||
108 | 108 | |
109 | 109 | $db = MDB2::singleton(DB_DSN); |
110 | 110 | |
111 | - $result = $db->exec($sql_type . "contact_person " . |
|
112 | - "SET " . |
|
113 | - "intranet_id = ".$db->quote($this->contact->kernel->intranet->get("id"), 'integer').", " . |
|
114 | - "name = ".$db->quote($input['name'], 'text').", " . |
|
115 | - "email = ".$db->quote($input['email'], 'text').", " . |
|
116 | - "phone = ".$db->quote($input['phone'], 'text').", " . |
|
117 | - "mobile = ".$db->quote($input['mobile']).", " . |
|
118 | - "contact_id = " . $db->quote($this->contact->get('id'), 'integer') . ", " . |
|
119 | - "date_changed = NOW() " . $sql_end); |
|
111 | + $result = $db->exec($sql_type."contact_person ". |
|
112 | + "SET ". |
|
113 | + "intranet_id = ".$db->quote($this->contact->kernel->intranet->get("id"), 'integer').", ". |
|
114 | + "name = ".$db->quote($input['name'], 'text').", ". |
|
115 | + "email = ".$db->quote($input['email'], 'text').", ". |
|
116 | + "phone = ".$db->quote($input['phone'], 'text').", ". |
|
117 | + "mobile = ".$db->quote($input['mobile']).", ". |
|
118 | + "contact_id = ".$db->quote($this->contact->get('id'), 'integer').", ". |
|
119 | + "date_changed = NOW() ".$sql_end); |
|
120 | 120 | |
121 | 121 | if (PEAR::isError($result)) { |
122 | 122 | throw new Exception('Error in query: '.$result->getUserInfo()); |
@@ -143,7 +143,7 @@ discard block |
||
143 | 143 | public function getList() |
144 | 144 | { |
145 | 145 | $db = new DB_Sql; |
146 | - $db->query("SELECT * FROM contact_person WHERE contact_id = " . $this->contact->get('id')); |
|
146 | + $db->query("SELECT * FROM contact_person WHERE contact_id = ".$this->contact->get('id')); |
|
147 | 147 | $persons = array(); |
148 | 148 | $i = 0; |
149 | 149 | while ($db->nextRecord()) { |
@@ -3,7 +3,7 @@ discard block |
||
3 | 3 | * @package Intraface_Contact |
4 | 4 | */ |
5 | 5 | |
6 | -require_once dirname(__FILE__) . '/ContactReminder.php'; |
|
6 | +require_once dirname(__FILE__).'/ContactReminder.php'; |
|
7 | 7 | $contact_module = $kernel->useModule('contact'); |
8 | 8 | |
9 | 9 | $contact = new Contact($kernel); |
@@ -25,7 +25,7 @@ discard block |
||
25 | 25 | } |
26 | 26 | $_attention_needed[] = array( |
27 | 27 | 'module' => $contact_module->getName(), |
28 | - 'link' => $contact_module->getPath() .$reminder['contact_id'] . '/memo/' . $reminder['id'], |
|
28 | + 'link' => $contact_module->getPath().$reminder['contact_id'].'/memo/'.$reminder['id'], |
|
29 | 29 | 'msg' => $text.' ('.$reminder['dk_reminder_date'].'): '.$reminder['contact_name'].': '.$reminder['subject'].'.', |
30 | 30 | 'no_translation' => true |
31 | 31 | ); |
@@ -199,9 +199,9 @@ discard block |
||
199 | 199 | throw new Exception("Was not able to convert date in ContactReminder->update"); |
200 | 200 | } |
201 | 201 | |
202 | - $sql = "reminder_date = ".$this->db->quote($date->get(), 'date')."," . |
|
203 | - "date_changed = NOW()," . |
|
204 | - "subject = ".$this->db->quote($input['subject'], 'text')."," . |
|
202 | + $sql = "reminder_date = ".$this->db->quote($date->get(), 'date').",". |
|
203 | + "date_changed = NOW(),". |
|
204 | + "subject = ".$this->db->quote($input['subject'], 'text').",". |
|
205 | 205 | "description = ".$this->db->quote($input['description'], 'text').""; |
206 | 206 | |
207 | 207 | if ($this->error->isError()) { |
@@ -212,17 +212,17 @@ discard block |
||
212 | 212 | $result = $this->db->exec("UPDATE contact_reminder_single SET ".$sql." WHERE intranet_id = ".$this->db->quote($this->contact->kernel->intranet->get('id'), 'integer')." AND id = ".$this->db->quote($this->id, 'integer')); |
213 | 213 | } else { |
214 | 214 | $result = $this->db->exec("INSERT INTO contact_reminder_single SET ".$sql.", ". |
215 | - "intranet_id = ".$this->db->quote($this->contact->kernel->intranet->get('id'), 'integer')."," . |
|
216 | - "contact_id = ".$this->db->quote($this->contact->get('id'), 'integer')."," . |
|
217 | - "created_by_user_id = ".$this->db->quote($this->contact->kernel->user->get('id'), 'integer')."," . |
|
218 | - "status_key = 1," . |
|
219 | - "date_created = NOW()," . |
|
215 | + "intranet_id = ".$this->db->quote($this->contact->kernel->intranet->get('id'), 'integer').",". |
|
216 | + "contact_id = ".$this->db->quote($this->contact->get('id'), 'integer').",". |
|
217 | + "created_by_user_id = ".$this->db->quote($this->contact->kernel->user->get('id'), 'integer').",". |
|
218 | + "status_key = 1,". |
|
219 | + "date_created = NOW(),". |
|
220 | 220 | "active = 1"); |
221 | 221 | $this->id = $this->db->lastInsertID(); |
222 | 222 | } |
223 | 223 | |
224 | 224 | if (PEAR::isError($result)) { |
225 | - throw new Exception('Could not save information in ContactReminder->update' . $result->getUserInfo()); |
|
225 | + throw new Exception('Could not save information in ContactReminder->update'.$result->getUserInfo()); |
|
226 | 226 | return false; |
227 | 227 | } |
228 | 228 | return $this->id; |
@@ -240,9 +240,9 @@ discard block |
||
240 | 240 | /** |
241 | 241 | * @todo: validation needed - not crucial as we are setting the postpone date |
242 | 242 | */ |
243 | - $result = $this->db->exec('UPDATE contact_reminder_single SET date_changed = NOW(), reminder_date = ' .$this->db->quote($date, 'date').' WHERE intranet_id = '.$this->db->quote($this->contact->kernel->intranet->get('id'), 'integer').' AND id = '.$this->db->quote($this->id, 'integer')); |
|
243 | + $result = $this->db->exec('UPDATE contact_reminder_single SET date_changed = NOW(), reminder_date = '.$this->db->quote($date, 'date').' WHERE intranet_id = '.$this->db->quote($this->contact->kernel->intranet->get('id'), 'integer').' AND id = '.$this->db->quote($this->id, 'integer')); |
|
244 | 244 | if (PEAR::isError($result)) { |
245 | - throw new Exception('Could not postphone reminder' . $result->getUserInfo()); |
|
245 | + throw new Exception('Could not postphone reminder'.$result->getUserInfo()); |
|
246 | 246 | return false; |
247 | 247 | } |
248 | 248 | $this->load(); |
@@ -265,11 +265,11 @@ discard block |
||
265 | 265 | |
266 | 266 | $db = MDB2::singleton(DB_DSN); |
267 | 267 | // |
268 | - $result = $db->query('SELECT contact_reminder_single.*, DATE_FORMAT(contact_reminder_single.reminder_date, "%d-%m-%Y") AS dk_reminder_date, address.name AS contact_name ' . |
|
269 | - 'FROM contact_reminder_single ' . |
|
270 | - 'INNER JOIN contact ON (contact_reminder_single.contact_id = contact.id AND contact.intranet_id = '.$db->quote($kernel->intranet->get('id'), 'integer') . ' AND contact.active = 1) '. |
|
271 | - 'LEFT JOIN address ON (address.belong_to_id = contact.id AND address.type = 3 AND address.active = 1) ' . |
|
272 | - 'WHERE contact_reminder_single.reminder_date < DATE_ADD(NOW(), INTERVAL 30 DAY) AND contact_reminder_single.intranet_id = ' .$db->quote($kernel->intranet->get('id'), 'integer').' AND contact_reminder_single.active = 1 AND contact_reminder_single.status_key = 1 ' . |
|
268 | + $result = $db->query('SELECT contact_reminder_single.*, DATE_FORMAT(contact_reminder_single.reminder_date, "%d-%m-%Y") AS dk_reminder_date, address.name AS contact_name '. |
|
269 | + 'FROM contact_reminder_single '. |
|
270 | + 'INNER JOIN contact ON (contact_reminder_single.contact_id = contact.id AND contact.intranet_id = '.$db->quote($kernel->intranet->get('id'), 'integer').' AND contact.active = 1) '. |
|
271 | + 'LEFT JOIN address ON (address.belong_to_id = contact.id AND address.type = 3 AND address.active = 1) '. |
|
272 | + 'WHERE contact_reminder_single.reminder_date < DATE_ADD(NOW(), INTERVAL 30 DAY) AND contact_reminder_single.intranet_id = '.$db->quote($kernel->intranet->get('id'), 'integer').' AND contact_reminder_single.active = 1 AND contact_reminder_single.status_key = 1 '. |
|
273 | 273 | 'ORDER BY contact_reminder_single.reminder_date ASC'); |
274 | 274 | if (PEAR::isError($result)) { |
275 | 275 | die($result->getUserInfo()); |
@@ -292,9 +292,9 @@ discard block |
||
292 | 292 | { |
293 | 293 | $status_key = array_search($status, $this->status_types); |
294 | 294 | |
295 | - $result = $this->db->exec('UPDATE contact_reminder_single SET date_changed = NOW(), status_key = ' .$this->db->quote($status_key, 'integer').' WHERE intranet_id = '.$this->db->quote($this->contact->kernel->intranet->get('id'), 'integer').' AND id = '.$this->db->quote($this->id, 'integer')); |
|
295 | + $result = $this->db->exec('UPDATE contact_reminder_single SET date_changed = NOW(), status_key = '.$this->db->quote($status_key, 'integer').' WHERE intranet_id = '.$this->db->quote($this->contact->kernel->intranet->get('id'), 'integer').' AND id = '.$this->db->quote($this->id, 'integer')); |
|
296 | 296 | if (PEAR::isError($result)) { |
297 | - throw new Exception('Could not postphone reminder' . $result->getUserInfo()); |
|
297 | + throw new Exception('Could not postphone reminder'.$result->getUserInfo()); |
|
298 | 298 | return false; |
299 | 299 | } |
300 | 300 | $this->load(); |
@@ -119,7 +119,7 @@ discard block |
||
119 | 119 | * @license |
120 | 120 | * |
121 | 121 | */ |
122 | -require_once dirname(__FILE__) . '/ContactPerson.php'; |
|
122 | +require_once dirname(__FILE__).'/ContactPerson.php'; |
|
123 | 123 | require_once 'Intraface/functions.php'; |
124 | 124 | |
125 | 125 | class Contact extends Intraface_Standard |
@@ -386,7 +386,7 @@ discard block |
||
386 | 386 | { |
387 | 387 | // HACK NECCESSARY FOR THE NEWSLETTERSUBSCRIBER |
388 | 388 | $this->kernel->useModule('contact'); |
389 | - return ($this->value['login_url'] = 'http://' . $this->kernel->getSetting()->get('intranet', 'contact.login_url') . '/' .$this->kernel->intranet->get('identifier') . '/login?code='. $this->get('code')); |
|
389 | + return ($this->value['login_url'] = 'http://'.$this->kernel->getSetting()->get('intranet', 'contact.login_url').'/'.$this->kernel->intranet->get('identifier').'/login?code='.$this->get('code')); |
|
390 | 390 | } |
391 | 391 | |
392 | 392 | /** |
@@ -556,16 +556,16 @@ discard block |
||
556 | 556 | |
557 | 557 | // prepare sql to update or insert |
558 | 558 | if ($this->id > 0) { |
559 | - $sql="UPDATE contact "; |
|
560 | - $sql_after=" WHERE id='".$this->id."'"; |
|
559 | + $sql = "UPDATE contact "; |
|
560 | + $sql_after = " WHERE id='".$this->id."'"; |
|
561 | 561 | $sql_create = ""; |
562 | 562 | } else { |
563 | - $sql="INSERT INTO contact "; |
|
564 | - $sql_after = ", code='".safeToDb(md5(date('Y-m-d H:i:s') . $sql_items))."'"; |
|
563 | + $sql = "INSERT INTO contact "; |
|
564 | + $sql_after = ", code='".safeToDb(md5(date('Y-m-d H:i:s').$sql_items))."'"; |
|
565 | 565 | $sql_create = "date_created = NOW(),"; |
566 | 566 | } |
567 | 567 | |
568 | - $sql .= " SET ".$sql_create. " |
|
568 | + $sql .= " SET ".$sql_create." |
|
569 | 569 | intranet_id = '". $this->kernel->intranet->get('id')."'," |
570 | 570 | .$sql_items. |
571 | 571 | "date_changed = NOW() |
@@ -595,7 +595,7 @@ discard block |
||
595 | 595 | // Delivery Address |
596 | 596 | foreach ($address_fields as $key => $value) { |
597 | 597 | if (array_key_exists('delivery_'.$value, $var)) { |
598 | - $delivery_address_to_save[$value] = $var['delivery_' . $value]; |
|
598 | + $delivery_address_to_save[$value] = $var['delivery_'.$value]; |
|
599 | 599 | } |
600 | 600 | } |
601 | 601 | |
@@ -629,7 +629,7 @@ discard block |
||
629 | 629 | return false; |
630 | 630 | } |
631 | 631 | $db = new DB_Sql; |
632 | - $db->query("UPDATE contact SET active = 0, date_changed = NOW() WHERE intranet_id = " . $this->kernel->intranet->get("id") . " AND id = " . $this->id); |
|
632 | + $db->query("UPDATE contact SET active = 0, date_changed = NOW() WHERE intranet_id = ".$this->kernel->intranet->get("id")." AND id = ".$this->id); |
|
633 | 633 | return true; |
634 | 634 | } |
635 | 635 | |
@@ -649,7 +649,7 @@ discard block |
||
649 | 649 | return false; |
650 | 650 | } |
651 | 651 | $db = new DB_Sql; |
652 | - $db->query("UPDATE contact SET active = 1, date_changed = NOW() WHERE intranet_id = " . $this->kernel->intranet->get("id") . " AND id = " . $this->id); |
|
652 | + $db->query("UPDATE contact SET active = 1, date_changed = NOW() WHERE intranet_id = ".$this->kernel->intranet->get("id")." AND id = ".$this->id); |
|
653 | 653 | |
654 | 654 | return true; |
655 | 655 | } |
@@ -667,9 +667,9 @@ discard block |
||
667 | 667 | $db = new DB_Sql(); |
668 | 668 | $sql = "SELECT id |
669 | 669 | FROM contact |
670 | - WHERE intranet_id = " . $this->kernel->intranet->get("id") . " |
|
671 | - AND number = " . (int)$number . " |
|
672 | - AND id <> " . $this->id . " |
|
670 | + WHERE intranet_id = " . $this->kernel->intranet->get("id")." |
|
671 | + AND number = " . (int)$number." |
|
672 | + AND id <> " . $this->id." |
|
673 | 673 | AND active = 1 |
674 | 674 | LIMIT 1"; |
675 | 675 | $db->query($sql); |
@@ -689,7 +689,7 @@ discard block |
||
689 | 689 | public function getMaxNumber() |
690 | 690 | { |
691 | 691 | $db = new DB_Sql(); |
692 | - $db->query("SELECT number FROM contact WHERE intranet_id = " . $this->kernel->intranet->get("id") . " ORDER BY number DESC"); |
|
692 | + $db->query("SELECT number FROM contact WHERE intranet_id = ".$this->kernel->intranet->get("id")." ORDER BY number DESC"); |
|
693 | 693 | if (!$db->nextRecord()) { |
694 | 694 | return 0; |
695 | 695 | } |
@@ -781,11 +781,11 @@ discard block |
||
781 | 781 | WHERE address.type=3 |
782 | 782 | AND contact.active = 1 |
783 | 783 | AND address.active = 1 |
784 | - AND contact.intranet_id = " . $db->quote($this->kernel->intranet->get('id'), 'integer') . " |
|
785 | - AND contact.id != " . $db->quote($this->id, 'integer') . " |
|
784 | + AND contact.intranet_id = " . $db->quote($this->kernel->intranet->get('id'), 'integer')." |
|
785 | + AND contact.id != " . $db->quote($this->id, 'integer')." |
|
786 | 786 | AND ( |
787 | - (address.email = " . $db->quote($this->address->get('email'), 'text') . " AND address.email != '') |
|
788 | - OR (address.phone = " . $db->quote($this->address->get('phone'), 'text') . " AND address.phone != '')) |
|
787 | + (address.email = " . $db->quote($this->address->get('email'), 'text')." AND address.email != '') |
|
788 | + OR (address.phone = " . $db->quote($this->address->get('phone'), 'text')." AND address.phone != '')) |
|
789 | 789 | |
790 | 790 | "; |
791 | 791 | |
@@ -874,7 +874,7 @@ discard block |
||
874 | 874 | function isFilledIn() |
875 | 875 | { |
876 | 876 | $db = new DB_Sql; |
877 | - $db->query("SELECT count(*) AS antal FROM contact WHERE intranet_id = " . $this->kernel->intranet->get('id')); |
|
877 | + $db->query("SELECT count(*) AS antal FROM contact WHERE intranet_id = ".$this->kernel->intranet->get('id')); |
|
878 | 878 | if ($db->nextRecord()) { |
879 | 879 | return $db->f('antal'); |
880 | 880 | } |
@@ -892,7 +892,7 @@ discard block |
||
892 | 892 | return false; |
893 | 893 | } |
894 | 894 | $db = new DB_Sql; |
895 | - $db->query("UPDATE contact SET code = '".md5($this->id . date('Y-m-d H:i:s') . $this->kernel->intranet->get('id'))."' WHERE id = " . $this->id); |
|
895 | + $db->query("UPDATE contact SET code = '".md5($this->id.date('Y-m-d H:i:s').$this->kernel->intranet->get('id'))."' WHERE id = ".$this->id); |
|
896 | 896 | $this->load(); |
897 | 897 | return true; |
898 | 898 | } |
@@ -909,7 +909,7 @@ discard block |
||
909 | 909 | return false; |
910 | 910 | } |
911 | 911 | $db = new DB_Sql; |
912 | - $db->query("UPDATE contact SET password = '".md5($this->id . date('Y-m-d H:i:s') . $this->kernel->intranet->get('id'))."' WHERE id = " . $this->id); |
|
912 | + $db->query("UPDATE contact SET password = '".md5($this->id.date('Y-m-d H:i:s').$this->kernel->intranet->get('id'))."' WHERE id = ".$this->id); |
|
913 | 913 | $this->load(); |
914 | 914 | return true; |
915 | 915 | } |
@@ -922,7 +922,7 @@ discard block |
||
922 | 922 | function getNewsletterSubscriptions() |
923 | 923 | { |
924 | 924 | $db = new DB_Sql; |
925 | - $db->query("SELECT * FROM newsletter_subscriber WHERE optin = 1 AND active = 1 AND contact_id = " . $this->id . " AND intranet_id =" . $this->kernel->intranet->get('id')); |
|
925 | + $db->query("SELECT * FROM newsletter_subscriber WHERE optin = 1 AND active = 1 AND contact_id = ".$this->id." AND intranet_id =".$this->kernel->intranet->get('id')); |
|
926 | 926 | $lists = array(); |
927 | 927 | while ($db->nextRecord()) { |
928 | 928 | $lists[] = $db->f('list_id'); |
@@ -938,7 +938,7 @@ discard block |
||
938 | 938 | function needNewsletterOptin() |
939 | 939 | { |
940 | 940 | $db = new DB_Sql; |
941 | - $db->query("SELECT list_id, code FROM newsletter_subscriber WHERE optin = 0 AND contact_id = " . $this->id . " AND intranet_id =" . $this->kernel->intranet->get('id')); |
|
941 | + $db->query("SELECT list_id, code FROM newsletter_subscriber WHERE optin = 0 AND contact_id = ".$this->id." AND intranet_id =".$this->kernel->intranet->get('id')); |
|
942 | 942 | $lists = array(); |
943 | 943 | $i = 0; |
944 | 944 | while ($db->nextRecord()) { |
@@ -959,7 +959,7 @@ discard block |
||
959 | 959 | function canBeDeleted() |
960 | 960 | { |
961 | 961 | $db = new DB_Sql; |
962 | - $db->query("SELECT * FROM debtor WHERE contact_id = " . $this->id . " AND intranet_id = " . $this->kernel->intranet->get('id')); |
|
962 | + $db->query("SELECT * FROM debtor WHERE contact_id = ".$this->id." AND intranet_id = ".$this->kernel->intranet->get('id')); |
|
963 | 963 | if (!$db->nextRecord()) { |
964 | 964 | return true; |
965 | 965 | } |
@@ -57,18 +57,18 @@ discard block |
||
57 | 57 | } |
58 | 58 | |
59 | 59 | if (is_array($keywords) && count($keywords) > 0) { |
60 | - $this->addText($this->get('x') + $this->label_padding_left, $this->get('y') - $this->label_padding_top - $this->get('font_spacing') * $line, $this->get('font_size'), "Nøgleord: ".implode(", ", $keywords)); |
|
60 | + $this->addText($this->get('x') + $this->label_padding_left, $this->get('y') - $this->label_padding_top - $this->get('font_spacing')*$line, $this->get('font_size'), "Nøgleord: ".implode(", ", $keywords)); |
|
61 | 61 | $line++; |
62 | 62 | } |
63 | 63 | |
64 | - $this->addText($this->get('x') + $this->label_padding_left, $this->get('y') - $this->label_padding_top - $this->get('font_spacing') * $line, $this->get('font_size'), "Antal labels i søgning: ".count($contacts)); |
|
64 | + $this->addText($this->get('x') + $this->label_padding_left, $this->get('y') - $this->label_padding_top - $this->get('font_spacing')*$line, $this->get('font_size'), "Antal labels i søgning: ".count($contacts)); |
|
65 | 65 | |
66 | 66 | // The contacts on labels |
67 | 67 | |
68 | 68 | for ($i = 0, $max = count($contacts); $i < $max; $i++) { |
69 | 69 | // TODO -- hvorfor bruger vi ikke antallet af labels til at vide, hvorn�r |
70 | 70 | // vi skifter linje? Vi kender faktisk ikke antallet af labels i en r�kke. Det kunne vi selvf�lgelig komme til |
71 | - if ($this->get('x') + $this->label_width > $this->get('right_margin_position')) { |
|
71 | + if ($this->get('x') + $this->label_width > $this->get('right_margin_position')) { |
|
72 | 72 | // For enden af linjen, ny linje |
73 | 73 | $this->setY("-".$this->label_height); |
74 | 74 | $this->setX(0); |
@@ -91,13 +91,13 @@ discard block |
||
91 | 91 | $address_lines = explode("\n", $contacts[$i]['address']['address']); |
92 | 92 | foreach ($address_lines as $l) { |
93 | 93 | if (trim($l) != "") { |
94 | - $this->addText($this->get('x') + $this->label_padding_left, $this->get('y') - $this->label_padding_top - $this->get('font_spacing') * $line, $this->get('font_size'), $l); |
|
94 | + $this->addText($this->get('x') + $this->label_padding_left, $this->get('y') - $this->label_padding_top - $this->get('font_spacing')*$line, $this->get('font_size'), $l); |
|
95 | 95 | $line++; |
96 | 96 | } |
97 | 97 | } |
98 | - $this->addText($this->get('x') + $this->label_padding_left, $this->get('y') - $this->label_padding_top - $this->get('font_spacing') * $line, $this->get('font_size'), $contacts[$i]['address']['postcode']." ".$contacts[$i]['address']['city']); |
|
98 | + $this->addText($this->get('x') + $this->label_padding_left, $this->get('y') - $this->label_padding_top - $this->get('font_spacing')*$line, $this->get('font_size'), $contacts[$i]['address']['postcode']." ".$contacts[$i]['address']['city']); |
|
99 | 99 | $line++; |
100 | - $this->addText($this->get('x') + $this->label_padding_left, $this->get('y') - $this->label_padding_top - $this->get('font_spacing') * $line, $this->get('font_size'), $contacts[$i]['address']['country']); |
|
100 | + $this->addText($this->get('x') + $this->label_padding_left, $this->get('y') - $this->label_padding_top - $this->get('font_spacing')*$line, $this->get('font_size'), $contacts[$i]['address']['country']); |
|
101 | 101 | } |
102 | 102 | } |
103 | 103 | } |