1<?php
2require_once('./Services/ActiveRecord/class.ActiveRecord.php');
3
4/**
5 * Class arUser
6 *
7 * @author  Fabian Schmid <fs@studer-raimann.ch>
8 * @version 2.0.7
9 */
10class arUser extends ActiveRecord
11{
12
13    /**
14     * @return string
15     */
16    public static function returnDbTableName()
17    {
18        return 'usr_data';
19    }
20
21
22    /**
23     * @var int
24     *
25     * @con_has_field  true
26     * @con_fieldtype  integer
27     * @con_length     4
28     * @con_is_notnull true
29     * @con_is_primary true
30     */
31    protected $usr_id;
32    /**
33     * @var int
34     *
35     * @con_has_field true
36     * @con_fieldtype text
37     * @con_length    80
38     */
39    protected $login;
40    /**
41     * @var int
42     *
43     * @con_has_field true
44     * @con_fieldtype text
45     * @con_length    32
46     */
47    protected $passwd;
48    /**
49     * @var int
50     *
51     * @con_has_field true
52     * @con_fieldtype text
53     * @con_length    32
54     */
55    protected $firstname;
56    /**
57     * @var int
58     *
59     * @con_has_field true
60     * @con_fieldtype text
61     * @con_length    32
62     */
63    protected $lastname;
64    /**
65     * @var int
66     *
67     * @con_has_field true
68     * @con_fieldtype text
69     * @con_length    32
70     */
71    protected $title;
72    /**
73     * @var int
74     *
75     * @con_has_field true
76     * @con_fieldtype text
77     * @con_length    1
78     */
79    protected $gender;
80    /**
81     * @var int
82     *
83     * @con_has_field true
84     * @con_fieldtype text
85     * @con_length    80
86     */
87    protected $email;
88    /**
89     * @var int
90     *
91     * @con_has_field true
92     * @con_fieldtype text
93     * @con_length    80
94     */
95    protected $institution;
96    /**
97     * @var int
98     *
99     * @con_has_field true
100     * @con_fieldtype text
101     * @con_length    40
102     */
103    protected $street;
104    /**
105     * @var int
106     *
107     * @con_has_field true
108     * @con_fieldtype text
109     * @con_length    40
110     */
111    protected $city;
112    /**
113     * @var int
114     *
115     * @con_has_field true
116     * @con_fieldtype text
117     * @con_length    10
118     */
119    protected $zipcode;
120    /**
121     * @var int
122     *
123     * @con_has_field true
124     * @con_fieldtype text
125     * @con_length    40
126     */
127    protected $country;
128    /**
129     * @var int
130     *
131     * @con_has_field true
132     * @con_fieldtype text
133     * @con_length    40
134     */
135    protected $phone_office;
136    /**
137     * @var int
138     *
139     * @con_has_field true
140     * @con_fieldtype
141     * @con_length
142     */
143    protected $last_login;
144    /**
145     * @var int
146     *
147     * @con_has_field true
148     * @con_fieldtype
149     * @con_length
150     */
151    protected $last_update;
152    /**
153     * @var int
154     *
155     * @con_has_field true
156     * @con_fieldtype
157     * @con_length
158     */
159    protected $create_date;
160    /**
161     * @var int
162     *
163     * @con_has_field true
164     * @con_fieldtype text
165     * @con_length    4000
166     */
167    protected $hobby;
168    /**
169     * @var int
170     *
171     * @con_has_field true
172     * @con_fieldtype text
173     * @con_length    80
174     */
175    protected $department;
176    /**
177     * @var int
178     *
179     * @con_has_field true
180     * @con_fieldtype text
181     * @con_length    40
182     */
183    protected $phone_home;
184    /**
185     * @var int
186     *
187     * @con_has_field true
188     * @con_fieldtype text
189     * @con_length    40
190     */
191    protected $phone_mobile;
192    /**
193     * @var int
194     *
195     * @con_has_field true
196     * @con_fieldtype text
197     * @con_length    40
198     */
199    protected $fax;
200    /**
201     * @var int
202     *
203     * @con_has_field true
204     * @con_fieldtype text
205     * @con_length    32
206     */
207    protected $i2passwd;
208    /**
209     * @var int
210     *
211     * @con_has_field true
212     * @con_fieldtype integer
213     * @con_length    4
214     */
215    protected $time_limit_owner;
216    /**
217     * @var int
218     *
219     * @con_has_field true
220     * @con_fieldtype integer
221     * @con_length    4
222     */
223    protected $time_limit_unlimited;
224    /**
225     * @var int
226     *
227     * @con_has_field true
228     * @con_fieldtype integer
229     * @con_length    4
230     */
231    protected $time_limit_from;
232    /**
233     * @var int
234     *
235     * @con_has_field true
236     * @con_fieldtype integer
237     * @con_length    4
238     */
239    protected $time_limit_until;
240    /**
241     * @var int
242     *
243     * @con_has_field true
244     * @con_fieldtype integer
245     * @con_length    4
246     */
247    protected $time_limit_message;
248    /**
249     * @var int
250     *
251     * @con_has_field true
252     * @con_fieldtype text
253     * @con_length    250
254     */
255    protected $referral_comment;
256    /**
257     * @var int
258     *
259     * @con_has_field true
260     * @con_fieldtype text
261     * @con_length    40
262     */
263    protected $matriculation;
264    /**
265     * @var int
266     *
267     * @con_has_field  true
268     * @con_fieldtype  integer
269     * @con_length     4
270     * @con_is_notnull true
271     */
272    protected $active;
273    /**
274     * @var int
275     *
276     * @con_has_field true
277     * @con_fieldtype
278     * @con_length
279     */
280    protected $approve_date;
281    /**
282     * @var int
283     *
284     * @con_has_field true
285     * @con_fieldtype
286     * @con_length
287     */
288    protected $agree_date;
289    /**
290     * @var int
291     *
292     * @con_has_field true
293     * @con_fieldtype text
294     * @con_length    255
295     */
296    protected $client_ip;
297    /**
298     * @var int
299     *
300     * @con_has_field true
301     * @con_fieldtype text
302     * @con_length    10
303     */
304    protected $auth_mode;
305    /**
306     * @var int
307     *
308     * @con_has_field true
309     * @con_fieldtype integer
310     * @con_length    4
311     */
312    protected $profile_incomplete;
313    /**
314     * @var int
315     *
316     * @con_has_field true
317     * @con_fieldtype text
318     * @con_length    250
319     */
320    protected $ext_account;
321    /**
322     * @var int
323     *
324     * @con_has_field true
325     * @con_fieldtype text
326     * @con_length    32
327     */
328    protected $feed_hash;
329    /**
330     * @var int
331     *
332     * @con_has_field true
333     * @con_fieldtype text
334     * @con_length    30
335     */
336    protected $latitude;
337    /**
338     * @var int
339     *
340     * @con_has_field true
341     * @con_fieldtype text
342     * @con_length    30
343     */
344    protected $longitude;
345    /**
346     * @var int
347     *
348     * @con_has_field  true
349     * @con_fieldtype  integer
350     * @con_length     4
351     * @con_is_notnull true
352     */
353    protected $loc_zoom;
354    /**
355     * @var int
356     *
357     * @con_has_field  true
358     * @con_fieldtype  integer
359     * @con_length     1
360     * @con_is_notnull true
361     */
362    protected $login_attempts;
363    /**
364     * @var int
365     *
366     * @con_has_field  true
367     * @con_fieldtype  integer
368     * @con_length     4
369     * @con_is_notnull true
370     */
371    protected $last_password_change;
372    /**
373     * @var int
374     *
375     * @con_has_field true
376     * @con_fieldtype text
377     * @con_length    32
378     */
379    protected $reg_hash;
380    /**
381     * @var int
382     *
383     * @con_has_field true
384     * @con_fieldtype
385     * @con_length
386     */
387    protected $birthday;
388    /**
389     * @var int
390     *
391     * @con_has_field true
392     * @con_fieldtype text
393     * @con_length    2
394     */
395    protected $sel_country;
396    /**
397     * @var int
398     *
399     * @con_has_field true
400     * @con_fieldtype
401     * @con_length
402     */
403    protected $last_visited;
404    /**
405     * @var int
406     *
407     * @con_has_field true
408     * @con_fieldtype
409     * @con_length
410     */
411    protected $inactivation_date;
412    /**
413     * @var int
414     *
415     * @con_has_field  true
416     * @con_fieldtype  integer
417     * @con_length     1
418     * @con_is_notnull true
419     */
420    protected $is_self_registered;
421
422
423    /**
424     * @param int $active
425     */
426    public function setActive($active)
427    {
428        $this->active = $active;
429    }
430
431
432    /**
433     * @return int
434     */
435    public function getActive()
436    {
437        return $this->active;
438    }
439
440
441    /**
442     * @param int $agree_date
443     */
444    public function setAgreeDate($agree_date)
445    {
446        $this->agree_date = $agree_date;
447    }
448
449
450    /**
451     * @return int
452     */
453    public function getAgreeDate()
454    {
455        return $this->agree_date;
456    }
457
458
459    /**
460     * @param int $approve_date
461     */
462    public function setApproveDate($approve_date)
463    {
464        $this->approve_date = $approve_date;
465    }
466
467
468    /**
469     * @return int
470     */
471    public function getApproveDate()
472    {
473        return $this->approve_date;
474    }
475
476
477    /**
478     * @param int $auth_mode
479     */
480    public function setAuthMode($auth_mode)
481    {
482        $this->auth_mode = $auth_mode;
483    }
484
485
486    /**
487     * @return int
488     */
489    public function getAuthMode()
490    {
491        return $this->auth_mode;
492    }
493
494
495    /**
496     * @param int $birthday
497     */
498    public function setBirthday($birthday)
499    {
500        $this->birthday = $birthday;
501    }
502
503
504    /**
505     * @return int
506     */
507    public function getBirthday()
508    {
509        return $this->birthday;
510    }
511
512
513    /**
514     * @param int $city
515     */
516    public function setCity($city)
517    {
518        $this->city = $city;
519    }
520
521
522    /**
523     * @return int
524     */
525    public function getCity()
526    {
527        return $this->city;
528    }
529
530
531    /**
532     * @param int $client_ip
533     */
534    public function setClientIp($client_ip)
535    {
536        $this->client_ip = $client_ip;
537    }
538
539
540    /**
541     * @return int
542     */
543    public function getClientIp()
544    {
545        return $this->client_ip;
546    }
547
548
549    /**
550     * @param int $country
551     */
552    public function setCountry($country)
553    {
554        $this->country = $country;
555    }
556
557
558    /**
559     * @return int
560     */
561    public function getCountry()
562    {
563        return $this->country;
564    }
565
566
567    /**
568     * @param int $create_date
569     */
570    public function setCreateDate($create_date)
571    {
572        $this->create_date = $create_date;
573    }
574
575
576    /**
577     * @return int
578     */
579    public function getCreateDate()
580    {
581        return $this->create_date;
582    }
583
584    /**
585     * @param int $department
586     */
587    public function setDepartment($department)
588    {
589        $this->department = $department;
590    }
591
592
593    /**
594     * @return int
595     */
596    public function getDepartment()
597    {
598        return $this->department;
599    }
600
601
602    /**
603     * @param int $email
604     */
605    public function setEmail($email)
606    {
607        $this->email = $email;
608    }
609
610
611    /**
612     * @return int
613     */
614    public function getEmail()
615    {
616        return $this->email;
617    }
618
619
620    /**
621     * @param int $ext_account
622     */
623    public function setExtAccount($ext_account)
624    {
625        $this->ext_account = $ext_account;
626    }
627
628
629    /**
630     * @return int
631     */
632    public function getExtAccount()
633    {
634        return $this->ext_account;
635    }
636
637
638    /**
639     * @param int $fax
640     */
641    public function setFax($fax)
642    {
643        $this->fax = $fax;
644    }
645
646
647    /**
648     * @return int
649     */
650    public function getFax()
651    {
652        return $this->fax;
653    }
654
655
656    /**
657     * @param int $feed_hash
658     */
659    public function setFeedHash($feed_hash)
660    {
661        $this->feed_hash = $feed_hash;
662    }
663
664
665    /**
666     * @return int
667     */
668    public function getFeedHash()
669    {
670        return $this->feed_hash;
671    }
672
673
674    /**
675     * @param int $firstname
676     */
677    public function setFirstname($firstname)
678    {
679        $this->firstname = $firstname;
680    }
681
682
683    /**
684     * @return int
685     */
686    public function getFirstname()
687    {
688        return $this->firstname;
689    }
690
691
692    /**
693     * @param int $gender
694     */
695    public function setGender($gender)
696    {
697        $this->gender = $gender;
698    }
699
700
701    /**
702     * @return int
703     */
704    public function getGender()
705    {
706        return $this->gender;
707    }
708
709
710    /**
711     * @param int $hobby
712     */
713    public function setHobby($hobby)
714    {
715        $this->hobby = $hobby;
716    }
717
718
719    /**
720     * @return int
721     */
722    public function getHobby()
723    {
724        return $this->hobby;
725    }
726
727
728    /**
729     * @param int $i2passwd
730     */
731    public function setI2passwd($i2passwd)
732    {
733        $this->i2passwd = $i2passwd;
734    }
735
736
737    /**
738     * @return int
739     */
740    public function getI2passwd()
741    {
742        return $this->i2passwd;
743    }
744
745    /**
746     * @param int $inactivation_date
747     */
748    public function setInactivationDate($inactivation_date)
749    {
750        $this->inactivation_date = $inactivation_date;
751    }
752
753
754    /**
755     * @return int
756     */
757    public function getInactivationDate()
758    {
759        return $this->inactivation_date;
760    }
761
762
763    /**
764     * @param int $institution
765     */
766    public function setInstitution($institution)
767    {
768        $this->institution = $institution;
769    }
770
771
772    /**
773     * @return int
774     */
775    public function getInstitution()
776    {
777        return $this->institution;
778    }
779
780
781    /**
782     * @param int $is_self_registered
783     */
784    public function setIsSelfRegistered($is_self_registered)
785    {
786        $this->is_self_registered = $is_self_registered;
787    }
788
789
790    /**
791     * @return int
792     */
793    public function getIsSelfRegistered()
794    {
795        return $this->is_self_registered;
796    }
797
798
799    /**
800     * @param int $last_login
801     */
802    public function setLastLogin($last_login)
803    {
804        $this->last_login = $last_login;
805    }
806
807
808    /**
809     * @return int
810     */
811    public function getLastLogin()
812    {
813        return $this->last_login;
814    }
815
816
817    /**
818     * @param int $last_password_change
819     */
820    public function setLastPasswordChange($last_password_change)
821    {
822        $this->last_password_change = $last_password_change;
823    }
824
825
826    /**
827     * @return int
828     */
829    public function getLastPasswordChange()
830    {
831        return $this->last_password_change;
832    }
833
834
835    /**
836     * @param int $last_update
837     */
838    public function setLastUpdate($last_update)
839    {
840        $this->last_update = $last_update;
841    }
842
843
844    /**
845     * @return int
846     */
847    public function getLastUpdate()
848    {
849        return $this->last_update;
850    }
851
852
853    /**
854     * @param int $last_visited
855     */
856    public function setLastVisited($last_visited)
857    {
858        $this->last_visited = $last_visited;
859    }
860
861
862    /**
863     * @return int
864     */
865    public function getLastVisited()
866    {
867        return $this->last_visited;
868    }
869
870
871    /**
872     * @param int $lastname
873     */
874    public function setLastname($lastname)
875    {
876        $this->lastname = $lastname;
877    }
878
879
880    /**
881     * @return int
882     */
883    public function getLastname()
884    {
885        return $this->lastname;
886    }
887
888
889    /**
890     * @param int $latitude
891     */
892    public function setLatitude($latitude)
893    {
894        $this->latitude = $latitude;
895    }
896
897
898    /**
899     * @return int
900     */
901    public function getLatitude()
902    {
903        return $this->latitude;
904    }
905
906
907    /**
908     * @param int $loc_zoom
909     */
910    public function setLocZoom($loc_zoom)
911    {
912        $this->loc_zoom = $loc_zoom;
913    }
914
915
916    /**
917     * @return int
918     */
919    public function getLocZoom()
920    {
921        return $this->loc_zoom;
922    }
923
924
925    /**
926     * @param int $login
927     */
928    public function setLogin($login)
929    {
930        $this->login = $login;
931    }
932
933
934    /**
935     * @return int
936     */
937    public function getLogin()
938    {
939        return $this->login;
940    }
941
942
943    /**
944     * @param int $login_attempts
945     */
946    public function setLoginAttempts($login_attempts)
947    {
948        $this->login_attempts = $login_attempts;
949    }
950
951
952    /**
953     * @return int
954     */
955    public function getLoginAttempts()
956    {
957        return $this->login_attempts;
958    }
959
960
961    /**
962     * @param int $longitude
963     */
964    public function setLongitude($longitude)
965    {
966        $this->longitude = $longitude;
967    }
968
969
970    /**
971     * @return int
972     */
973    public function getLongitude()
974    {
975        return $this->longitude;
976    }
977
978
979    /**
980     * @param int $matriculation
981     */
982    public function setMatriculation($matriculation)
983    {
984        $this->matriculation = $matriculation;
985    }
986
987
988    /**
989     * @return int
990     */
991    public function getMatriculation()
992    {
993        return $this->matriculation;
994    }
995
996
997    /**
998     * @param int $passwd
999     */
1000    public function setPasswd($passwd)
1001    {
1002        $this->passwd = $passwd;
1003    }
1004
1005
1006    /**
1007     * @return int
1008     */
1009    public function getPasswd()
1010    {
1011        return $this->passwd;
1012    }
1013
1014
1015    /**
1016     * @param int $phone_home
1017     */
1018    public function setPhoneHome($phone_home)
1019    {
1020        $this->phone_home = $phone_home;
1021    }
1022
1023
1024    /**
1025     * @return int
1026     */
1027    public function getPhoneHome()
1028    {
1029        return $this->phone_home;
1030    }
1031
1032
1033    /**
1034     * @param int $phone_mobile
1035     */
1036    public function setPhoneMobile($phone_mobile)
1037    {
1038        $this->phone_mobile = $phone_mobile;
1039    }
1040
1041
1042    /**
1043     * @return int
1044     */
1045    public function getPhoneMobile()
1046    {
1047        return $this->phone_mobile;
1048    }
1049
1050
1051    /**
1052     * @param int $phone_office
1053     */
1054    public function setPhoneOffice($phone_office)
1055    {
1056        $this->phone_office = $phone_office;
1057    }
1058
1059
1060    /**
1061     * @return int
1062     */
1063    public function getPhoneOffice()
1064    {
1065        return $this->phone_office;
1066    }
1067
1068
1069    /**
1070     * @param int $profile_incomplete
1071     */
1072    public function setProfileIncomplete($profile_incomplete)
1073    {
1074        $this->profile_incomplete = $profile_incomplete;
1075    }
1076
1077
1078    /**
1079     * @return int
1080     */
1081    public function getProfileIncomplete()
1082    {
1083        return $this->profile_incomplete;
1084    }
1085
1086
1087    /**
1088     * @param int $referral_comment
1089     */
1090    public function setReferralComment($referral_comment)
1091    {
1092        $this->referral_comment = $referral_comment;
1093    }
1094
1095
1096    /**
1097     * @return int
1098     */
1099    public function getReferralComment()
1100    {
1101        return $this->referral_comment;
1102    }
1103
1104
1105    /**
1106     * @param int $reg_hash
1107     */
1108    public function setRegHash($reg_hash)
1109    {
1110        $this->reg_hash = $reg_hash;
1111    }
1112
1113
1114    /**
1115     * @return int
1116     */
1117    public function getRegHash()
1118    {
1119        return $this->reg_hash;
1120    }
1121
1122
1123    /**
1124     * @param int $sel_country
1125     */
1126    public function setSelCountry($sel_country)
1127    {
1128        $this->sel_country = $sel_country;
1129    }
1130
1131
1132    /**
1133     * @return int
1134     */
1135    public function getSelCountry()
1136    {
1137        return $this->sel_country;
1138    }
1139
1140
1141    /**
1142     * @param int $street
1143     */
1144    public function setStreet($street)
1145    {
1146        $this->street = $street;
1147    }
1148
1149
1150    /**
1151     * @return int
1152     */
1153    public function getStreet()
1154    {
1155        return $this->street;
1156    }
1157
1158
1159    /**
1160     * @param int $time_limit_from
1161     */
1162    public function setTimeLimitFrom($time_limit_from)
1163    {
1164        $this->time_limit_from = $time_limit_from;
1165    }
1166
1167
1168    /**
1169     * @return int
1170     */
1171    public function getTimeLimitFrom()
1172    {
1173        return $this->time_limit_from;
1174    }
1175
1176
1177    /**
1178     * @param int $time_limit_message
1179     */
1180    public function setTimeLimitMessage($time_limit_message)
1181    {
1182        $this->time_limit_message = $time_limit_message;
1183    }
1184
1185
1186    /**
1187     * @return int
1188     */
1189    public function getTimeLimitMessage()
1190    {
1191        return $this->time_limit_message;
1192    }
1193
1194
1195    /**
1196     * @param int $time_limit_owner
1197     */
1198    public function setTimeLimitOwner($time_limit_owner)
1199    {
1200        $this->time_limit_owner = $time_limit_owner;
1201    }
1202
1203
1204    /**
1205     * @return int
1206     */
1207    public function getTimeLimitOwner()
1208    {
1209        return $this->time_limit_owner;
1210    }
1211
1212
1213    /**
1214     * @param int $time_limit_unlimited
1215     */
1216    public function setTimeLimitUnlimited($time_limit_unlimited)
1217    {
1218        $this->time_limit_unlimited = $time_limit_unlimited;
1219    }
1220
1221
1222    /**
1223     * @return int
1224     */
1225    public function getTimeLimitUnlimited()
1226    {
1227        return $this->time_limit_unlimited;
1228    }
1229
1230
1231    /**
1232     * @param int $time_limit_until
1233     */
1234    public function setTimeLimitUntil($time_limit_until)
1235    {
1236        $this->time_limit_until = $time_limit_until;
1237    }
1238
1239
1240    /**
1241     * @return int
1242     */
1243    public function getTimeLimitUntil()
1244    {
1245        return $this->time_limit_until;
1246    }
1247
1248
1249    /**
1250     * @param int $title
1251     */
1252    public function setTitle($title)
1253    {
1254        $this->title = $title;
1255    }
1256
1257
1258    /**
1259     * @return int
1260     */
1261    public function getTitle()
1262    {
1263        return $this->title;
1264    }
1265
1266
1267    /**
1268     * @param int $usr_id
1269     */
1270    public function setUsrId($usr_id)
1271    {
1272        $this->usr_id = $usr_id;
1273    }
1274
1275
1276    /**
1277     * @return int
1278     */
1279    public function getUsrId()
1280    {
1281        return $this->usr_id;
1282    }
1283
1284
1285    /**
1286     * @param int $zipcode
1287     */
1288    public function setZipcode($zipcode)
1289    {
1290        $this->zipcode = $zipcode;
1291    }
1292
1293
1294    /**
1295     * @return int
1296     */
1297    public function getZipcode()
1298    {
1299        return $this->zipcode;
1300    }
1301
1302
1303    /**
1304     * @param int $key
1305     */
1306    public function setKey($key)
1307    {
1308        $this->key = $key;
1309    }
1310
1311
1312    /**
1313     * @return int
1314     */
1315    public function getKey()
1316    {
1317        return $this->key;
1318    }
1319}
1320