customer_kiosk.mwb000064400000054667150253271320010336 0ustar00PKPW 8كLG$document.mwb.xmlrK-_!y8YbUujK[-iD$PC_HI 6 )1ZjϦzJq4XΗG'`h68ˣOO_~y>lḚ?y9U׍g{?r~1\ >teYOƣ?=WR(J,I5W3"E WcOOgE9>1fՂ0ɳ7Z5'Cd<4dRC' /oo 3򧧗׶mں;O=/t nէ[^)e[FO!RE6d4_21X,gg&v#65e^巟~Dmퟝ/aha[_d`__iO?gߜ׏-GZzlpَU[8][ W!bĉi Rg>L>l:7xzcp>npM]n6fvDUC+hӋy5ʸj׿xG}Φ_bn vO:eޭ tІ^6!-JdᲚVbyc&Af3LV6xzIV?hUy[,跋xΫ#_@Sm%"5S@=!Jڷ~Y1ߦ/M:eM_ϾzSkt+EY:m^VgGض ms`=<9^m?lJ"A()] @"4JI".QݑDP$B}!+t/H~HMiU_[p8* 2hăEEL`X\H)ҖMNkӯtN r/p7ls,! sq6/[;bjd4vQ!nF$HM#s<кdxGrb dGdCnZՍ#)k:j0onW#oڭ17A\m>A |i?ŏw{p|=Xض03-x?_gЪ|{f^7Jh_l k~*a&LHRX! C’Lt 1VЯ'BЏ~~xι8Xa!4(,bB&̑gL*H4!J^pw4f']''`:O`@KE Zlyvu,Z:N S MD< dJ}A2-wGWkwH?qAADp a=;VRcHȈ:!gA:%YаhhDA 6A4b 9,48QFBh%j:X /h?4d\R^vJ 6ABj|l5 `!)8gQYQ`aTXH-XX .gi{$epPHlQ,)zTHJ 0&de߼{2}g_ދ z3`::y5<ѠPBIlM F99 b 噵R؂=9.(sDS 00^:V"nSh&L̷돟721oebK`-mt`T_6RA0`;Ðfj|:\y6&vQtT}rxXuPl$[)QTQS""$|$Xym/t HݡF{T0PЙZ W'}#C;NI$ ᆖm,pU&evbXMGm[7¼:湎ʨl:@YΊ ۖmSq͈&ᇷDWo"M[(fԢ'h,5xMFvg_yҾGK]VjԫXct|܆RcvXc}WY?ըGPȱm4ЪQYudrӫ62q6fij~Z'\tC``;Hh6Z|IVchšn #C2T`m#.B.(^X~1/JC4I䑦6D"xΒ췷~.w__J_I{4~,dBNkk{eYlI„$@5VHRob2b%)Lqoby;+L0Lūޚ'Nvh<\#ƾƝo)QDt_&DQDxLD)QD2[NU+e"J[cd~F]Zye"ԸZEԿ$JFDH2#c"5 jʌ&d%#|`"nC& +mgR2^RH%%#dDI=OO%,) g H{ +tJD&ŠR2G+j% i W"A<}MSE\=A #)8Xp NA MScH'X-I`piZppwܛHH `t< ֵtX(XĈ*thd9ql]ur "5"RU! 6AóxֳsXHHD N8Z扒 {86dڔ=CeTg=2s`VFQa 1HjR.H  aa{ ؕB00ռȰDƙ7[D㈧Hs"qX &Y |pIĂ) uQQaaP,A|hb&nyRV/]Di5D+:bQHEm 9 3u9۴joZ+h$rDy"Gbm6=7bq7jIQ7*FEhEܨd@?BNhJ0cQCYصg x(F"@&QpXFBCЈ"V)LeZTJȂ?1YҡO&>I?eA-g4˜;j$0@?lNȘ,4 _nSC_я~vE틣پwvX(>rq=29 -}DDY{_@-wE<:PaP@T2EIRDK3%G*ZsN"'LfXb Uoq+5ݣsTBBkN")גb=UXEWkXŊXQ+bXŊحS?CQlVޓCQk&VNgd!<:3Ȁ*%$Ʃ퇒2rte [4$WK^y=Q,0dמ%-gOjeicuB\dqHzl.Y},Tt4{~<%~;,bJ.SG9$\Aꈒc=GK)㞔_ڃb+O"rw@pa”({m{SRgHx2 u:2ŘI9D IL@PX a0Že=4S`O0[0Ţ޹wTPŢY;L ^;\^bQ,EwnۿQEwz Eijg>Zӈc )wi1yϠGM}?<G,'1xB7IÜJ9?{hIYOrVjI B:8 1ׅPc$WBpxmƫ}C=tGNJ6uXqLSqm"1'rZU*`@RĂM0#@D*hOh8 ' %VXQ.a=AcBHR_аhXTXӂ au6Oڃa-3&ZG#hF$.uJRXHd)g,d`aF)ڦ >FQfuNļ8+pcD &Ll٨+Lc0rϩjH A/GL%N ".'a"tj5>@O_BrG[ː ""PJx9C㾩(7jq M3;upBA.t0'L&TDA  !  úr{2HYV&`^QHc` $PÂq9PM;P1c氰0$2QI-QEMS,^ "MKif::y4ʿAGm!e8"IXP2I+5 `!0ʒg`4cƦEGc}[QzCLsgTB%NX*`LŞ #a=; Qjkvq3K}v[;/-e|4 ǻ m>^VJ@$4]lEv%WMPw<:O.OOYSa3#G9@ߟ)gҀq/44(qY69Yw]&_Klhk"_M/'-ijv|^] u4ڮ3EAcȪ J"͂Db-728L>2EL;"XL0~3Z+0)[Eܕ$Q]1FrGSc_N>\k.4nUhV;d`HV(:zGK19t qV%FJ̉ :-uUyc_cN-: L u ui uR c+#=0C"q/#&:0 $ؗʗ9u u,QP\mPǫ]G# uu;}:R#i9 Eb^uıQp6 ()fsTj‚긷Ա2~SZ+PB:, mX{v}uӽ62q6fij~ZK\tg``/b[6i[t__%T'[o6K6b=à7Kcklhc]4v5skd͙}3`~`h, ɰ|Kpû+';x;yӯ9o70rqB [-urk1ouzۘb:jl[Zq[%ɻeֿaq~ww@ gf^2v8eb6C S0EX?!L mt~,n@V2{ՌK\^1 gb=.Y'Z!D)$"ըF8^+i-Qݝw_}*YR,yBRUwr!9dt|.L\ ACENܠ"EMSƢ5W`&8xu=ֵtXh(-Yj0 Z"6*H)&B 0*d唰[$"z(J ȩg D J%Dc\ŞABe|_KRqİ \\[Xxt%Lb#E (4R?XMi4'_t4^>"^*w(10h_%IudJ s1tYݨ>V$Y)xǣR+T/T޼Toq3Iơ@UKBS qGXb.2q2HSD@/Y%d֊/d"E>7|1 "sb>-OO)b>Eg 8Y|Ṫ#Ÿ`|v?Ck+ F(*MQiS!:xA&YjdTx/AO'?AևI:M aM@.V$E֧VDfgS\J,l9G~z&*LOsW3Qw$(K>+W a4&w;^t5  ( +-`!'őz`a#"iW,t`a&X}푰Acrd j\"KBScPpR {żaF gfQ4"nIB=pNcl#S0+X0 ͎Ǔt^9Bnr!$iK8J"&  )w}/HX P~"q1)bĹQ̑&>`I$!}QW a!z CFQJ"Nd@AhH -QaP؂Bq‚_tpU1jeH`dO6Z@:%<9ű`P"wSBJ ltEaMCvNg> &B:!S{!TaR ЯG\ƻӝlBZ*C.kˊ>"˂@B/bJRr=T B<,!p(1sX8%Uq#rRdLJ5{I).-5W8?TYutIWr/AAb}[ uOj]L#]vk}~j2"rUsAցHͫiVrd_?جu[$Jp$xXur]Н;I"jdH∓.8S=> fBb>WN H17'(&,a{\.nt߂V|t/&͋?Z+U;!G[%^g~: qo{q/:E}3`긫'DBh#wOq_qϷ՝ɩ{3%Z}ص;R8!AENۈ*bN뇖;(aPϛ#aKG yn{/s˽fpS{voho9B~H(NS$'Vyʻp%{u__HnM{$羞+\g{E 1l!&d=429ay꤈.pC XDeI"(8X`=; ca؋"G&Ru`D-(; oPE-t"n? U arꄑ99Rce"GdE¨ȨyAƂ |2ַX2%ӜJqߙyur E3!$ҔH)Wܱ @ #q/7}Z9K ]@Zy -v3 ^m"[^ 1C>y^)@?,V V|6Jm齮Xd r]dc01x+cTOFky? %Ԣ"G<WwϕÁz--Eé %yؕwѿZ g bF|sdLR* JkX_NȂ~vpXu5 8iX)bAGd~ä`]q||9,tZ|%$9^d {hk0z[.`OQӯv(^aA"2 @n|B ,4@aߠ0АX>Ba:[žay{HkbO#3*h >dc0tP|nK{(w+'n-D;jd0(:0Mఏer c3G={EZs4ȹN0fw)2f{PƬV~1KRƬԎébW1.j9ЂB=,x+s,x,x%$-* *lLR S[C36 S,LS܏G-"Pb_bݙ[Jޖ]9_Jxۖm)y[JޖRM)y{%o FD>!L ?V+y_jn;⮏mDv!tqP/FDͯTR#l0>?V_WYO:]jwSEAj,ȮNAn_(;9:g3>gGlA+E^ J-:d^Qjjl[>;!B^Q|(7EKVWR+y~>:'%c3ޞF,m2niT u7:tayGm0y72MIh7*Սb8wcEGיԍx!iG~w7/1uzL4f+c鼪>t}jE5ݑ3͌#K thT_;k`8:35 ݡ4p"ЖVGx<_:r7lu ?9ՆEGƈmC1?m7 $Nת0|_ nZ !> NlDNL:ü@}C}5\\XJp(9fs4- sH4wԉaáӧwIwOFoV 4nxRV׿vp\zy6q@X%xYa`(qhhG\xUߛ6al}G|iHS6]~nkE[6Zku>7wހOp^ jd\wOyw X$jrB*}TȀEɤ@)iR F+m#將I ҆xĔlb0w 5qm5wZPξAf``CcpV ؗ#!; a"#a1)OHi0-7 I&N(ȣDlxūM޽y?7=Gǫl mHyKHHJa12cr݅A'*`%# zH GCu4 8hul o{aM}~{ kEi3z>Xճs5XVݲ~\\ 20W6r&%:~CV`2LYwt<>d6IGF ]Κvdjڡy-\wiKոL}P'i =w<w5K3 ?iWRrcs+54|;TgSv-uZv}gݑxZ7rJ깬]L.;re޼lf]z|2^gKӋym^%@7  fZ#- AJM|3_^} ѐnY!` aKdDlۯ n[ՀZSp'guc" a+w%16X, 9C qDg"~+;! 9ǂR%y0 sT x(YTPGEA{F!$G Q k3] ց]@?sB$2~˭4 =r"j/9 Ρ-lJg ZIJqo222W }P5/g9s~$)gv$ҔH)WƘ9?s< !XBcp*Fd V9JS5ecHKOc̹ga]4y -AY&RL\ˑZ N:F5aV" F 9:b kc`;.F "H!ttRԨZ MnfSōYp+Q+uN.o>&lrq6](_N!.o񚕝x:6 Wa8 y.VQy4~mr{,X2뺻kݿcxeKyծ -7қi|zuKIGYFIvR@ ۵&Fl0Lގ{;$/g^Bw~x|rvpzD[`j=xŃ?UM(VY8.Ph=8!g\̃ *{pzAx;ǹqI ҚiM?Z&nxߘ=4q9Kqn.3E5Hd1H$R1*fJ_\83o)͹8ʅ}׺KVCoTp<QUJ2(Vg[7o ^‹sL!,cD mLՋ3;U8ͽx\$|UA72/$r83=BCfȀw J'l!UhQ #j"O[*\h- };d=R[(Qyl<=>A\bO4GGpFqEղ8@sK,hŅsݳ}i3d>ዳѼZϦax,‹c+% hHűɫmDI`OW({MQ0/Wyd<0Q$88L5 ΂ %JF }OHi2JM=,Ez3#v5mkm]'cSV<&9; eKW긝[A8l\E4swܞiR J~J/br}a' @׍CT#o-%"2@pΰzKFjr `bxthc5Ĝ,vL hA`YmwX9NѠ$k ,8 %f&|^ +د%xumA6@Ϸ_|o:5"v)_).u"SdM L@2ĉH,]QqF; .:}@!JI&qT|~k6/cX|O[Z.qhmLUXx`m:8<6%|m q|i-*D;Vќrak'p/ N2ۆ-Q"huNYʓѶ x1QACC)AK䔤Ux;$i`@B$*=9T4`O ++I ua"gW#,C|K J2(8ULSb3BI_A6N&`9`>9$`I\ w<}@tscVLL:iϞ26J€mScFܪ`he%WXӆ{M̛ U>$!δ>qAT@NoH5Q4>_c#]ϼ%"l^0T.y/zD17VEjmq.4% $#^#( *_4kZl XZPxu|R2oZpJXD)$ R^0u"(+W4;miaLnep RI ep#ɛ,?6+ `8ƒq-E0)dJ/< ,Tj˲CX\&4aPm E .?Z5oB'5, A vT_ۢ |sψ08l`PS$yE0 Dr~Y,V;p48]4j3"Xj 2=:f<kVKfZr M"P"j:qS&(XC4N0u=n ؕTN#p (Vbшyjx>^(6*xnuYM is |gvC Q>%b!Q;pjL6^Ct|{N-S${B/Z,Sp09?}~ۭF yuCd%-}n;y%,0G0S xDg_FίXHq`-uyd%ܞW}!V872SCq:wN4fk Ju/G4団cҞ9za9C|tuГ7wEؚR}Lo5My<{76{OwK-Yrx1]}0kԧHmNf8 u2ġu ׳/uӷYag/x&*#CH_~_oo|_F|sWd,)wWR۶tQ[h \SW4WIz>jn+Sדz?hf跳%{ /}V6U#kab hb}ʹ5Ԧ-.˃}o6ϵϟ"F.yNژRR>e&}ZLwh 8_ [_\,6`:)7+ .ڼ>=YU h޹ӜBb#" YYe^qy~B/X׷@Og?l7j*v9۹|_U#ӌZ`-wlWRFnnVHxfCO1NYW`w[1Kr@5p>/rש2g|߯=tlyl#wwb8KĎ3V~5xo?PKVOPW}lock16472PKPPW; P @db/data.db[o]G~K%PJETu$6 i3QԒFm8)[lچ?+$lP7lذa6t7Ikx({t{Ͻ3sf}_ѳWw\гwl4=:^Ŀfݞ=ߟėkuo|uhII{J% )r6Xծ:U>_9=[Wsx[7.}IIs\)(Ι!ɛG< dd4(V%rQdz8+BShl(Fd.zxm[HBT X، y'VEk GgedFJ! )#e$91R*%-= SsiQm@1Ʃ@qGZ2|Ug}qm㏯: Ko=|#M׮-.K7vw./^⹽k?›}"+!||f!SR=O.yg?޺kۻ;O9ݭx~9sy畭߱3g.]ݹ=?s?4Pͳ~ ?6r2# ||>6k>6R>~/f8&l/=,΍;\rbgW)Nm.?f8&l6班,ӐL6hf{?鿙}…_ͻGVX!*9+4za/zp7a)[(`)kPeVo7/޺=[^81d,n֏ϭF$yh$%SQ]6FFF L1G6 BVJVIkFbQXq ZCI* fZsirXi 1V9KЪVZJG$ ֔J`J5zQ)iy]?p{[kKdmT. 3+, '*jW=8,ɕ/I &+`e_؜j OJ֖1[SlyPXVҠi8bPܢ9"UT-osȘϸQdҨIUQ`fkSY+d s(?yb+?IcAWD3 tjc~u0U$"rz $p-B nvCt"Vz`s/9ª a@$eN&ƻ isLIȴ**W@STbak^)S ,0Q67Gc7PٗKzgT/bϾan5ߙWs `\6v1F"6#EYT|1QyUZ.DZ="|GW.=Z4Q-c/*U{Q7s 4r&:[u{W;0`kQE/eGҖc`'Ԫ4 O;~vv6; zpDyC$*ʱ@rs2 JNwb"!uu/ qu4]>rP1+RDFj\.TP M6'{G_uE|BbmjW}u,tM-], 2JȻ3[5<$)BlS N.i$F4TMb+>dB$.Ʊ\fhoRP].4|d->Jt A2!˹ C-+&0]Z19ͣT9y+9(.L:F͢dyT.74cU&jM6٧;1d{<>U̓"9iB-deal_name !!} take the protection of your personal information seriously. The information you provide on our establishment’s customer kiosk, including your first name, last name, email, mobile number, and optional photograph, is collected solely for the purpose of monitoring your account transactions and providing you with better customer service, including promotions, newsletters, and product information. By providing your personal information, you consent to the collection, use, processing, storage, and retention of all personal information you hereby freely provide to {!! Auth::user()->comp_name !!} doing business as {!! Auth::user()->deal_name !!}.\n \nBy consenting to this data privacy notice, you acknowledge that we will share the information you provide through this devise exclusively within the Autohub Group, including its affiliates and subsidiaries, for the specified purposes only. We shall implement reasonable and appropriate organizational, physical, and technical security measures for the protection of all personal information it collected and continuously implement new policies and improve existing measures to ensure comprehensive and sustainable compliance with privacy laws.\n\nPlease be informed that you have the right to withdraw your consent at any time, to access, rectify or delete your personal information, and to exercise other rights provided for in the Data Privacy Act of 2012 through a written request to dataprotectionofficer@autohubgroup.com. Furthermore, you have the right to file a complaint to the National Privacy Commission if you believe that your right has been violated or denied.\n\nIf you have any questions or concerns regarding our use of your personal information, please contact us.\n', 5, '2023-05-16 09:33:20', '2023-05-16 09:33:20'), (2, 'terms and conditions', 5, '2023-08-01 14:01:22', '2023-08-01 14:01:22'); -- Dumping structure for table customer_kiosk_v2.ratings DROP TABLE IF EXISTS `ratings`; CREATE TABLE IF NOT EXISTS `ratings` ( `id` int NOT NULL AUTO_INCREMENT, `cust_id` int NOT NULL, `rating` int NOT NULL, `comment` text, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, PRIMARY KEY (`id`), KEY `cust_id_idx` (`cust_id`), CONSTRAINT `cust_id` FOREIGN KEY (`cust_id`) REFERENCES `customers` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Dumping data for table customer_kiosk_v2.ratings: ~1 rows (approximately) INSERT INTO `ratings` (`id`, `cust_id`, `rating`, `comment`, `created_at`, `updated_at`) VALUES (1, 4, 5, 'this is very good', '2023-10-16 10:49:31', '2023-10-16 10:49:31'); -- Dumping structure for table customer_kiosk_v2.sms_response DROP TABLE IF EXISTS `sms_response`; CREATE TABLE IF NOT EXISTS `sms_response` ( `id` int NOT NULL AUTO_INCREMENT, `cust_Id` varchar(45) DEFAULT NULL, `token` varchar(45) DEFAULT NULL, `url` varchar(45) DEFAULT NULL, `mobile` varchar(45) DEFAULT NULL, `status` varchar(45) DEFAULT NULL, `message` varchar(45) DEFAULT NULL, `type` varchar(45) DEFAULT NULL, `transid` varchar(45) DEFAULT NULL, `sms_length` varchar(45) DEFAULT NULL, `sms_parts` varchar(45) DEFAULT NULL, `transaction_amount` varchar(45) DEFAULT NULL, `telco` varchar(45) DEFAULT NULL, `created_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Dumping data for table customer_kiosk_v2.sms_response: ~5 rows (approximately) INSERT INTO `sms_response` (`id`, `cust_Id`, `token`, `url`, `mobile`, `status`, `message`, `type`, `transid`, `sms_length`, `sms_parts`, `transaction_amount`, `telco`, `created_at`) VALUES (3, '6', '63e3046421ed9T5Tqd9PrVvw2jFqoj2Wz3kJB6Qos8JUj', NULL, '9067466142', '1', 'success', 'real-time', '00196278596', '152', '1', '0.25', 'GLOBE', '2023-04-18 09:08:26'), (4, '6', '63e3046421ed9T5Tqd9PrVvw2jFqoj2Wz3kJB6Qos8JUj', 'https://tinyurl.com/2b2bhgh8', '9067466142', '1', 'success', 'real-time', '00134163776', '152', '1', '0.25', 'GLOBE', '2023-04-18 10:34:03'), (5, '6', '63e3046421ed9T5Tqd9PrVvw2jFqoj2Wz3kJB6Qos8JUj', 'https://tinyurl.com/2b2bhgh8', '', '0', 'mobile parameter is required.', NULL, NULL, NULL, NULL, NULL, NULL, '2023-04-18 10:48:04'), (6, '6', '63e3046421ed9T5Tqd9PrVvw2jFqoj2Wz3kJB6Qos8JUj', 'https://tinyurl.com/2b2bhgh8', '', '0', 'mobile parameter is required.', NULL, NULL, NULL, NULL, NULL, NULL, '2023-04-18 10:48:04'), (7, '6', '63e3046421ed9T5Tqd9PrVvw2jFqoj2Wz3kJB6Qos8JUj', 'https://tinyurl.com/2b2bhgh8', '', '0', 'mobile parameter is required.', NULL, NULL, NULL, NULL, NULL, NULL, '2023-04-18 10:48:04'); -- Dumping structure for table customer_kiosk_v2.transactions DROP TABLE IF EXISTS `transactions`; CREATE TABLE IF NOT EXISTS `transactions` ( `id` int NOT NULL AUTO_INCREMENT, `transactions_custId` int NOT NULL, `orNo` varchar(45) NOT NULL, `amount` float DEFAULT NULL, `assisting_sc_fName` varchar(45) DEFAULT NULL, `assisting_sc_lName` varchar(45) DEFAULT NULL, `cashier_payment` varchar(45) DEFAULT NULL, `sc_payment` varchar(45) DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `custId_idx` (`transactions_custId`), CONSTRAINT `transactions_custId` FOREIGN KEY (`transactions_custId`) REFERENCES `customers` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Dumping data for table customer_kiosk_v2.transactions: ~1 rows (approximately) INSERT INTO `transactions` (`id`, `transactions_custId`, `orNo`, `amount`, `assisting_sc_fName`, `assisting_sc_lName`, `cashier_payment`, `sc_payment`, `created_at`, `updated_at`) VALUES (1, 16, 'OR-1234-abcd', 3000, 'Adrian', 'P', NULL, '1', '2023-05-06 08:47:44', '2023-05-06 08:47:44'); -- Dumping structure for table customer_kiosk_v2.users DROP TABLE IF EXISTS `users`; CREATE TABLE IF NOT EXISTS `users` ( `id` int NOT NULL AUTO_INCREMENT, `user_name` varchar(45) DEFAULT NULL, `f_name` varchar(45) DEFAULT NULL, `l_name` varchar(45) DEFAULT NULL, `email` varchar(45) DEFAULT NULL, `deal_name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `deal_code` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `comp_name` varchar(45) NOT NULL, `receipt` varchar(45) DEFAULT NULL, `logo` varchar(45) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `token` varchar(45) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `access` int DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_name_UNIQUE` (`user_name`), UNIQUE KEY `comp_name_UNIQUE` (`deal_name`), UNIQUE KEY `comp_code_UNIQUE` (`deal_code`), UNIQUE KEY `email_UNIQUE` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Dumping data for table customer_kiosk_v2.users: ~14 rows (approximately) INSERT INTO `users` (`id`, `user_name`, `f_name`, `l_name`, `email`, `deal_name`, `deal_code`, `comp_name`, `receipt`, `logo`, `password`, `token`, `created_at`, `updated_at`, `access`) VALUES (1, 'GCASI', NULL, NULL, NULL, 'Global City Auto Sales Inc', 'GCASI', '', 'files/img/GCASI.jpg', 'files/img/logo/GCASI.jpg', '$2y$10$7xUbX2z4Z8uirtBqM/vffOQqH.UXtcI8qyKliqkCtOWsLczClT/RK', '63e3046421ed9T5Tqd9PrVvw2jFqoj2Wz3kJB6Qos8JUj', '2023-02-08 10:09:40', '2023-02-08 10:09:40', 0), (3, 'AGC', NULL, NULL, NULL, 'Autohub Group of Companies Inc.', 'AGC', '', 'files/img/AGC.jpg', NULL, '$2y$10$1bFrsFh9VUWW/4E9YytWFuukcErnSHz9XejOicrCa3/F/Cis4TThy', '643cb0568b8d2bAQitpvrar9vNmZBIAzT2cRB4h4HBRET', '2023-04-17 10:35:02', '2023-04-17 10:35:02', 0), (5, NULL, 'adrian', 'pusana', 'apusana2@autohubgroup.com', NULL, NULL, '', NULL, NULL, '$2y$10$XR7/Jjc5gMAtqcZCP1ZryOxyuyAYtQPJGtt32I3mUwh3/Ws3vb3Aa', '643cb8da457e1ITcrAHFluKJz9aoPtFAhXjhPvGEnHCQY', '2023-04-17 11:11:22', '2023-04-25 13:11:53', 1), (6, NULL, 'admin', 'account', 'admin@email.com', NULL, NULL, '', NULL, NULL, '$2a$12$2Fw6sSBVsJF1FFz5UC7P9ecB2jeT1s2.Kjmh.UCGneyTuMA2Tbux2', '643e3be146b195ol8vzbMnbK1i14yTq26aLhfDlMekh3k', '2023-04-18 14:42:41', '2023-04-20 11:34:58', 1), (16, 'MVAL', NULL, NULL, NULL, 'Moto Valenzuela', 'MVAL', 'MCGI', 'files/img/MVAL.jpg', NULL, '$2y$10$fsOuY6Fnd1evMUamNCO.aORgR00r0GNJjiPu2QT0GDc07gCdWJYGW', '6440b5e9292a5PLiec1P7Y4V8XwgQ11zmcq7tjaqFJFg6', '2023-04-20 11:47:53', '2023-04-20 11:47:53', 0), (17, NULL, 'Aaron John', 'Pusana', 'apusana@autohubgroup.com', NULL, NULL, '', NULL, NULL, '$2y$10$YAqbLi3/aghUB8polX8OEeYXQdPeMdACD0M1ZxRFktQPGRJ56WBU6', '6440b62125320piLSb78ZCYuPbh8faaZ1TX1oiZLpmVxl', '2023-04-20 11:48:49', '2023-04-22 08:28:57', 1), (18, 'Mitsubishi', NULL, NULL, NULL, 'Mitsubishi', 'Mitsubishi', '', 'files/img/Mitsubishi.jpg', NULL, '$2y$10$ALr3DUXf6aOTHnCQm380zO3M6faVuvJ3DnJE5L5e0LxQH3q6.eJqG', '6440c8fbbea89GI9MQrsZgMLXAIcn8J3fSIztAkWpX45l', '2023-04-20 13:09:15', '2023-04-20 13:09:15', 0), (26, 'MGM', NULL, NULL, NULL, 'MGM Motor Trading', 'MGM', 'MCGI', 'files/img/MGM.jpg', NULL, '$2y$10$gqlxkEwtABIlj4EkXnIhs.tsYbBh5laq3p3lUaUzspup/6dcSzVyq', '6451ef36aada6ZJb2fnGMHFko7KlFJjhJKTl7J2CQfEjG', '2023-05-03 13:20:54', '2023-05-03 13:20:54', 0), (28, 'NDLR', NULL, NULL, NULL, 'new Dealer', 'NDLR', '', 'files/img/NDLR.jpg', 'files/img/logo/NDLR_logo.jpg', '$2y$10$dbfHCwGCFrR4q83IKhCiM.BCvqdUOmqwDxH./pXHYzxjF0YhlBdXq', '645da6f00e64dCNDLKtpLZx49DrF6Eu7r4kWT2DOOjgEi', '2023-05-12 10:39:44', '2023-05-12 10:39:44', 0), (29, 'NDLR2', NULL, NULL, NULL, 'New Dealer 2', 'NDLR2', '', 'files/img/NDLR2.jpg', 'files/img/logoNDLR2_logo.jpg', '$2y$10$Cc7tD7ZH9W4QNWzoIdNAf.qyo0zrbIFcKjF1pW4TkCOCKXxGo5SE.', '645da90fe9e66XBJU9n6BrBtKTkGfcOtrzT4yQ2R5NUQf', '2023-05-12 10:48:48', '2023-05-12 10:48:48', 0), (30, 'NDLR3', NULL, NULL, NULL, 'New Dealer3', 'NDLR3', '', 'files/img/NDLR3.jpg', 'files/img/logoNDLR3_logo.jpg', '$2y$10$Gnb0KTgzwPSl4O9gyoWiCuLyUeE/B3Vs/D3fF.25YMMCFqwhaYEHC', '645da9ccf383aTABMzwRgbgvuiMfeVw5c8ZhACgg9SA8y', '2023-05-12 10:51:57', '2023-05-12 10:51:57', 0), (31, 'NDLR5', NULL, NULL, NULL, 'New Dealer5', 'NDLR5', '', 'files/img/648272624b081NDLR5.jpg', 'files/img/logo/648273f8d7034NDLR5_logo.jpg', '$2y$10$TZ7UKKaK1MPs3FXfJgyjy.anGloKjbrk5/G7rXY/HR3hRsHhYoQVq', '645daa322cc08dUbzfZULvmoizt2bIqepQViD2Sv3Yazh', '2023-05-12 10:53:38', '2023-06-09 08:36:08', 0), (32, NULL, 'ADRIAN', 'PUSANA', 'NDLR4', NULL, NULL, '', NULL, NULL, '$2y$10$tdJDlzutUlTLDLqd1we/nO1VwVidF9gBEZIVvG8F.XCAYJZNSPjJi', '645db6a238faaWML1ljrZ3lL8wAuIIFwKlw5kr8rFAH21', '2023-05-12 11:46:42', '2023-05-12 11:46:42', NULL), (34, 'FGC', NULL, NULL, NULL, 'Ford Global City', 'FGC', 'Autohub Group', 'files/img/64a53739959d9FGC.jpg', 'files/img/logo/64a537399649bFGC_logo.jpg', '$2y$10$T.Q0R9EDsO7AYLV2X02LAu9ZDtj6W/d6ErAJmMjRM8pvFHjy2Xjr.', '64a53739959b5SFwiCfN6wfZP8F1TQS8ulRnSnZazQKws', '2023-07-05 17:26:17', '2023-07-05 17:26:17', 0); /*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; /*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */; customer_kiosk.sql000064400000011477150253271320010340 0ustar00-- MySQL Workbench Forward Engineering SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; -- ----------------------------------------------------- -- Table `companies` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `companies` ( `id` INT NOT NULL AUTO_INCREMENT, `compCode` VARCHAR(45) NOT NULL, `compName` VARCHAR(45) NOT NULL DEFAULT 'Autohub Group of Companies Inc', `active` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, `receipt` VARCHAR(45) NOT NULL, `token` VARCHAR(45) NOT NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci; -- ----------------------------------------------------- -- Table `company_address` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `company_address` ( `id` INT NOT NULL AUTO_INCREMENT, `company_address_compId` INT NULL DEFAULT NULL, `mac_address` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `companies_id_idx` (`company_address_compId` ASC) VISIBLE, CONSTRAINT `company_address_compId` FOREIGN KEY (`company_address_compId`) REFERENCES `companies` (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci; -- ----------------------------------------------------- -- Table `customers` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `customers` ( `id` INT NOT NULL AUTO_INCREMENT, `fname` VARCHAR(45) NOT NULL, `lname` VARCHAR(45) NOT NULL, `nickname` VARCHAR(45) NULL DEFAULT NULL, `mobile` VARCHAR(45) NOT NULL, `email` TEXT NULL DEFAULT NULL, `messenger` VARCHAR(45) NULL DEFAULT NULL, `image` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci; -- ----------------------------------------------------- -- Table `links` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `links` ( `id` INT NOT NULL AUTO_INCREMENT, `links_custId` INT NOT NULL, `flag` INT NULL DEFAULT NULL, `link` VARCHAR(100) NOT NULL, `token` VARCHAR(45) NOT NULL, `verified` INT NULL DEFAULT NULL, `deleted_at` DATETIME NULL DEFAULT NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `custId_idx` (`links_custId` ASC) VISIBLE, CONSTRAINT `links_custId` FOREIGN KEY (`links_custId`) REFERENCES `customers` (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci; -- ----------------------------------------------------- -- Table `transactions` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `transactions` ( `id` INT NOT NULL AUTO_INCREMENT, `transactions_custId` INT NOT NULL, `orNo` VARCHAR(45) NOT NULL, `amount` FLOAT NULL DEFAULT NULL, `assisting_sc_fName` VARCHAR(45) NULL DEFAULT NULL, `assisting_sc_lName` VARCHAR(45) NULL DEFAULT NULL, `cashier_payment` VARCHAR(45) NULL DEFAULT NULL, `sc_payment` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `custId_idx` (`transactions_custId` ASC) VISIBLE, CONSTRAINT `transactions_custId` FOREIGN KEY (`transactions_custId`) REFERENCES `customers` (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci; -- ----------------------------------------------------- -- Table `users` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `users` ( `id` INT NOT NULL AUTO_INCREMENT, `user_name` VARCHAR(45) NULL DEFAULT NULL, `comp_name` VARCHAR(45) NULL DEFAULT NULL, `comp_code` VARCHAR(45) NULL DEFAULT NULL, `receipt` VARCHAR(45) NULL DEFAULT NULL, `password` VARCHAR(255) NULL DEFAULT NULL, `token` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT NULL, `updated_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `user_name_UNIQUE` (`user_name` ASC) VISIBLE, UNIQUE INDEX `comp_name_UNIQUE` (`comp_name` ASC) VISIBLE, UNIQUE INDEX `comp_code_UNIQUE` (`comp_code` ASC) VISIBLE) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci; SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; autoph_guest.sql000064400000043157150253271320010006 0ustar00-- phpMyAdmin SQL Dump -- version 4.9.11 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Apr 17, 2023 at 01:59 PM -- Server version: 5.7.41-log -- PHP Version: 7.4.33 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `autoph_guest` -- -- -------------------------------------------------------- -- -- Table structure for table `companies` -- CREATE TABLE `companies` ( `id` int(11) NOT NULL, `compCode` varchar(45) COLLATE utf8_unicode_ci NOT NULL, `compName` varchar(45) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Autohub Group of Companies Inc', `active` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL, `status` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL, `receipt` varchar(45) COLLATE utf8_unicode_ci NOT NULL, `token` varchar(45) COLLATE utf8_unicode_ci NOT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `company_address` -- CREATE TABLE `company_address` ( `id` int(11) NOT NULL, `company_address_compId` int(11) DEFAULT NULL, `mac_address` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `customers` -- CREATE TABLE `customers` ( `id` int(11) NOT NULL, `fname` varchar(45) NOT NULL, `lname` varchar(45) NOT NULL, `nickname` varchar(45) DEFAULT NULL, `mobile` varchar(45) NOT NULL, `email` text, `messenger` varchar(45) DEFAULT NULL, `image` varchar(45) DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `customers` -- INSERT INTO `customers` (`id`, `fname`, `lname`, `nickname`, `mobile`, `email`, `messenger`, `image`, `created_at`, `updated_at`) VALUES (4, 'Tablet_FName', 'Tablet_LName', NULL, '09067466142', NULL, NULL, '.', '2023-01-17 12:47:35', '2023-01-17 12:47:35'), (5, 'Ffff', 'Jhhjhjjh', NULL, 'Hdgdhdh', 'Hdbd', NULL, '.', '2023-01-17 13:18:55', '2023-01-17 13:18:55'), (6, 'Danica', 'Magtangob', 'Dan', '09176331398', 'dmagtangob@autohubgroup.com', NULL, '.', '2023-01-17 13:22:17', '2023-01-17 13:22:17'), (7, 'Arnel', 'Endaya', 'Arnel', '09269172111', 'aendaya@autohubgroup.com', NULL, '.', '2023-01-17 13:23:15', '2023-01-17 13:23:15'), (8, 'Danica', 'Magtangob', 'Dan', '9176331398', 'dmagtangob@autohubgroup.com', NULL, '.', '2023-01-19 13:46:25', '2023-01-19 13:46:25'), (9, 'Danica', 'Magtangob', 'Dandan', '09176331398', 'dmagtangob@autohubgroup.com', NULL, '.', '2023-01-25 11:20:50', '2023-01-25 11:20:50'), (10, 'Danica', 'Magtangob', 'Dandan', '09176331398', 'dmagtangob@autohubgroup.com', NULL, '.', '2023-01-25 11:21:10', '2023-01-25 11:21:10'), (11, 'Danica', 'Magtangob', 'Dan', '09176331398', 'dmagtangob@autohubgroup.com', NULL, '.', '2023-01-25 13:56:28', '2023-01-25 13:56:28'), (12, 'Arnel', 'Endaya', 'Arnel', '09269172111', 'aendaya@autohubgroup.com', NULL, '.', '2023-01-25 13:56:56', '2023-01-25 13:56:56'), (13, 'Christil', 'Almazan', NULL, '09125735445', NULL, NULL, '.', '2023-01-31 10:20:05', '2023-01-31 10:20:05'), (14, 'Christil', 'Almazan', NULL, '09125735445', NULL, NULL, '.', '2023-01-31 10:20:31', '2023-01-31 10:20:31'), (15, 'Danica', 'Magtangob', NULL, '09176331398', NULL, NULL, '.', '2023-01-31 10:33:33', '2023-01-31 10:33:33'), (16, 'Arnel', 'Endaya', NULL, '09269172111', NULL, NULL, '.', '2023-01-31 10:41:58', '2023-01-31 10:41:58'), (17, 'Arnel', 'Endaya', NULL, '09269172111', NULL, NULL, '.', '2023-01-31 11:09:04', '2023-01-31 11:09:04'), (18, 'Danica', 'Magtangob', NULL, '09176331398', NULL, NULL, '.', '2023-01-31 11:11:59', '2023-01-31 11:11:59'), (19, 'Danica', 'Magtangob', 'Dandan', '09176331398', 'dmagtangob@autohubgroup.com', NULL, '.', '2023-02-06 10:11:16', '2023-02-06 10:11:16'), (20, 'Arnel', 'Endaya', 'Arnel', '09269172111', 'aendaya@autohubgroup.com', NULL, '.', '2023-02-06 10:11:42', '2023-02-06 10:11:42'), (21, 'Adrian', 'Pusana', 'Adrian', '09269172111', 'apusana@autohubgroup.com', NULL, '.', '2023-02-06 10:12:36', '2023-02-06 10:12:36'), (22, 'Arnel', 'Endaya', NULL, '09269172111⁩', NULL, NULL, '.', '2023-02-09 14:59:16', '2023-02-09 14:59:16'), (23, 'Danica', 'Magtangob', NULL, '09176331398', NULL, NULL, '.', '2023-02-09 15:03:12', '2023-02-09 15:03:12'), (24, 'Danica', 'Magtangob', 'Dan', '09176331398', 'dmagtangob@autohubgroup.com', NULL, '.', '2023-02-20 16:22:50', '2023-02-20 16:22:50'), (25, 'Arnel', 'Endaya', 'Arnel', '09269172111', 'aendaya@autohubgroup.com', NULL, '.', '2023-02-20 16:23:23', '2023-02-20 16:23:23'), (26, 'Adrian', 'Pusana', NULL, '09067466142', 'apusana@autohubgroup.com', NULL, '.', '2023-02-20 16:23:56', '2023-02-20 16:23:56'); -- -------------------------------------------------------- -- -- Table structure for table `links` -- CREATE TABLE `links` ( `id` int(11) NOT NULL, `links_custId` int(11) NOT NULL, `flag` int(11) DEFAULT NULL, `link` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `token` varchar(45) COLLATE utf8_unicode_ci NOT NULL, `verified` int(11) DEFAULT NULL, `deleted_at` datetime DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `links` -- INSERT INTO `links` (`id`, `links_custId`, `flag`, `link`, `token`, `verified`, `deleted_at`, `created_at`, `updated_at`) VALUES (1, 4, NULL, '/verify/token/63c628676a6fcNUUnMgNP54vgpLcQ/q/63c62840ab891E9IYVwukXNZIHyuJ4E4a2UsWoKsktrRY', '63c628676a6fcNUUnMgNP54vgpLcQ', NULL, NULL, '2023-01-17 12:47:35', '2023-01-17 12:47:35'), (2, 5, NULL, '/verify/token/63c62fbf865e3qHNfiWhqnJ9aOSLu/q/63c62840ab891E9IYVwukXNZIHyuJ4E4a2UsWoKsktrRY', '63c62fbf865e3qHNfiWhqnJ9aOSLu', NULL, NULL, '2023-01-17 13:18:55', '2023-01-17 13:18:55'), (3, 6, NULL, '/verify/token/63c63089db5d0SndRp3VdQzwTnHSd/q/63c62840ab891E9IYVwukXNZIHyuJ4E4a2UsWoKsktrRY', '63c63089db5d0SndRp3VdQzwTnHSd', NULL, NULL, '2023-01-17 13:22:17', '2023-01-17 13:22:17'), (4, 7, NULL, '/verify/token/63c630c3dbe0bThhFqIL1fGzfs2Wi/q/63c62840ab891E9IYVwukXNZIHyuJ4E4a2UsWoKsktrRY', '63c630c3dbe0bThhFqIL1fGzfs2Wi', NULL, NULL, '2023-01-17 13:23:15', '2023-01-17 13:23:15'), (5, 8, NULL, '/verify/token/63c8d9310b998COeSTxMlTEDQgOeS/q/63c8d8d82d87cXvTP8HKidaLDAM9ph4ypM28sBpiPbwVi', '63c8d9310b998COeSTxMlTEDQgOeS', NULL, NULL, '2023-01-19 13:46:25', '2023-01-19 13:46:25'), (6, 9, NULL, '/verify/token/63d0a01261103wdcyFfQsVTsXsbKI/q/63d09fd477f37KLXOvDzQqCKMDOUxWqMphQC7wrVjaRbq', '63d0a01261103wdcyFfQsVTsXsbKI', NULL, NULL, '2023-01-25 11:20:50', '2023-01-25 11:20:50'), (7, 10, NULL, '/verify/token/63d0a0263dea84kasuAqqDLy7xsxZ/q/63d09fd477f37KLXOvDzQqCKMDOUxWqMphQC7wrVjaRbq', '63d0a0263dea84kasuAqqDLy7xsxZ', NULL, NULL, '2023-01-25 11:21:10', '2023-01-25 11:21:10'), (8, 11, NULL, '/verify/token/63d0c48c2375fP92bKY5XQVnEJhdG/q/63d0c47473baaAjbxZnFqeKBtXFxpdPa3zlJJFhZGOrbt', '63d0c48c2375fP92bKY5XQVnEJhdG', NULL, NULL, '2023-01-25 13:56:28', '2023-01-25 13:56:28'), (9, 12, NULL, '/verify/token/63d0c4a87cea7N9IismbJF65Knxlf/q/63d0c47473baaAjbxZnFqeKBtXFxpdPa3zlJJFhZGOrbt', '63d0c4a87cea7N9IismbJF65Knxlf', NULL, NULL, '2023-01-25 13:56:56', '2023-01-25 13:56:56'), (10, 13, NULL, '/verify/token/63d87ad589187ioNZA0cVC4eOTXzT/q/63d87a98941beJ63cp6bYOjSRsFUoskAX6h3sY3yc4Cv8', '63d87ad589187ioNZA0cVC4eOTXzT', NULL, NULL, '2023-01-31 10:20:05', '2023-01-31 10:20:05'), (11, 14, NULL, '/verify/token/63d87aef46ed10sh0Kab5Ba6RP2eM/q/63d87a98941beJ63cp6bYOjSRsFUoskAX6h3sY3yc4Cv8', '63d87aef46ed10sh0Kab5Ba6RP2eM', NULL, NULL, '2023-01-31 10:20:31', '2023-01-31 10:20:31'), (12, 15, NULL, '/verify/token/63d87dfd979c2It2gbu2rmWD1R9no/q/63d87da30b08435vZZBKggFDKlNn4LUFFfuaO31sw0Gk1', '63d87dfd979c2It2gbu2rmWD1R9no', NULL, NULL, '2023-01-31 10:33:33', '2023-01-31 10:33:33'), (13, 16, NULL, '/verify/token/63d87ff625cceKUPkVFRCAOk1Xrhw/q/63d87f9bd360b1w0bHSCvCVU2YXJkTRuGzHYXQhwh6JEj', '63d87ff625cceKUPkVFRCAOk1Xrhw', NULL, NULL, '2023-01-31 10:41:58', '2023-01-31 10:41:58'), (14, 17, NULL, '/verify/token/63d8865096ba8BFWDIS5Hal6ic4PE/q/63d8860e28addPGoM9bDAR5fD55E5VANAVNM1SLPYiduK', '63d8865096ba8BFWDIS5Hal6ic4PE', NULL, NULL, '2023-01-31 11:09:04', '2023-01-31 11:09:04'), (15, 18, NULL, '/verify/token/63d886ffc1989uoVnlAQCeqNeP8IJ/q/63d886ce7c6d9z7wD3XKsadYwf71SzDdqg1whJ3YzW6K5', '63d886ffc1989uoVnlAQCeqNeP8IJ', NULL, NULL, '2023-01-31 11:11:59', '2023-01-31 11:11:59'), (16, 19, NULL, '/verify/token/63e061c41004arQnDOvFck5BkDK94/q/63e06153e8d8aFNbfvNsiUDkrKB3e10HmPCaQRoTAS40q', '63e061c41004arQnDOvFck5BkDK94', NULL, NULL, '2023-02-06 10:11:16', '2023-02-06 10:11:16'), (17, 20, NULL, '/verify/token/63e061deeeb09jhT4TJ6PAj4j60qT/q/63e06153e8d8aFNbfvNsiUDkrKB3e10HmPCaQRoTAS40q', '63e061deeeb09jhT4TJ6PAj4j60qT', NULL, NULL, '2023-02-06 10:11:42', '2023-02-06 10:11:42'), (18, 21, NULL, '/verify/token/63e06214eaa56RqOP55yUzr5BoglP/q/63e06153e8d8aFNbfvNsiUDkrKB3e10HmPCaQRoTAS40q', '63e06214eaa56RqOP55yUzr5BoglP', NULL, NULL, '2023-02-06 10:12:36', '2023-02-06 10:12:36'), (19, 22, NULL, '/verify/token/63e499c43e388wWpvC8VClkDlXECI/q/63e4997f6b807XXUW9AgYDNCdxsYxYa8u3SIE0koCLkT2', '63e499c43e388wWpvC8VClkDlXECI', NULL, NULL, '2023-02-09 14:59:16', '2023-02-09 14:59:16'), (20, 23, NULL, '/verify/token/63e49ab0cb7b6KDj9vqr8I0cfZ3jz/q/63e49a542a95dJQ9dAXmu1nnEK2RBjhba10gvfzUQAZX7', '63e49ab0cb7b6KDj9vqr8I0cfZ3jz', NULL, NULL, '2023-02-09 15:03:12', '2023-02-09 15:03:12'), (21, 24, NULL, '/verify/token/63f32ddad1963CMADDVQpKcm6u1Um/q/63f32d851a5e1tnjvSMgT9irZINK3ig03tqOoU07Jh9hp', '63f32ddad1963CMADDVQpKcm6u1Um', NULL, NULL, '2023-02-20 16:22:50', '2023-02-20 16:22:50'), (22, 25, NULL, '/verify/token/63f32dfb3ecb4GmQ24lshHrel0nfT/q/63f32d851a5e1tnjvSMgT9irZINK3ig03tqOoU07Jh9hp', '63f32dfb3ecb4GmQ24lshHrel0nfT', NULL, NULL, '2023-02-20 16:23:23', '2023-02-20 16:23:23'), (23, 26, NULL, '/verify/token/63f32e1c7df13IOJwXnoCu249kkpO/q/63f32d851a5e1tnjvSMgT9irZINK3ig03tqOoU07Jh9hp', '63f32e1c7df13IOJwXnoCu249kkpO', NULL, NULL, '2023-02-20 16:23:56', '2023-02-20 16:23:56'); -- -------------------------------------------------------- -- -- Table structure for table `transactions` -- CREATE TABLE `transactions` ( `id` int(11) NOT NULL, `transactions_custId` int(11) NOT NULL, `orNo` varchar(45) NOT NULL, `amount` float DEFAULT NULL, `assisting_sc_fName` varchar(45) DEFAULT NULL, `assisting_sc_lName` varchar(45) DEFAULT NULL, `cashier_payment` varchar(45) DEFAULT NULL, `sc_payment` varchar(45) DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `user_name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL, `comp_name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL, `comp_code` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL, `receipt` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL, `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `token` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `user_name`, `comp_name`, `comp_code`, `receipt`, `password`, `token`, `created_at`, `updated_at`) VALUES (1, 'GCASI', 'Global City Auto Sales Inc', 'GCASI', 'files/img/GCASI.jpg', '$2y$10$bjIkYOYs8HB7h2wFmOp6C.jlqheVN4o6c0NMFvlKQdOag36kJ.moK', '63c62840ab891E9IYVwukXNZIHyuJ4E4a2UsWoKsktrRY', '2023-01-17 12:46:56', '2023-01-17 12:46:56'), (3, 'FOM', 'Ford Manila', 'FOM', 'files/img/FOM.jpg', '$2y$10$msluLXNIaX515PNMkRIwmOt/Dija7hNDdTMDH6XhyziPdRulLomxW', '63c8d8d82d87cXvTP8HKidaLDAM9ph4ypM28sBpiPbwVi', '2023-01-19 13:44:56', '2023-01-19 13:44:56'), (4, 'FPAL', 'Ford Palawan', 'FPAL', 'files/img/FPAL.png', '$2y$10$WmilnjfBXN4AU3qJbwDv0.Qqb5CMscoTulS6BJDlRGGHS29lshXbW', '63c8f4748e98fGqKuusemHAy9TnAsEto0Q4Ts9vWbPzfr', '2023-01-19 15:42:44', '2023-01-19 15:42:44'), (19, 'LEAP', 'Hyundai', 'LEAP', 'files/img/LEAP.jpg', '$2y$10$YZerpQgxddj.theNaOj84OKwOFyhpzGwD3M5yKyemuwyXrvxNMXa.', '63d09fd477f37KLXOvDzQqCKMDOUxWqMphQC7wrVjaRbq', '2023-01-25 11:19:48', '2023-01-25 11:19:48'), (23, 'MGC', 'Mitsubishi Global', 'MGC', 'files/img/MGC.jpg', '$2y$10$qEmh238oCL8wQFQ7FuvDsuCEP24WjkJ.dGoHznWqO/D7J0aOVSbN6', '63d0c47473baaAjbxZnFqeKBtXFxpdPa3zlJJFhZGOrbt', '2023-01-25 13:56:04', '2023-01-25 13:56:04'), (25, 'GCASIS', 'Global City', 'GCASIS', 'files/img/GCASIS.jpg', '$2y$10$oOncCDJpbuNBGmhrLPpfeeW32tzKYsNKcc399.1279Q2wjNukckG6', '63d87935825fdaevC8V1sLes03s29aq4pJvnJopoCbj0B', '2023-01-31 10:13:09', '2023-01-31 10:13:09'), (26, 'adfdsfsf', 'fdsfsdfa', 'adfdsfsf', 'files/img/adfdsfsf.png', '$2y$10$0Z7G3ceddEfeFFrPrEMQtOHydceMK4zHfcznqtUsC.5XdmqbyB9OK', '63d87a370b39dNJEQGk6SIYyaCNZ0M6g01wqe1PKUbfN7', '2023-01-31 10:17:27', '2023-01-31 10:17:27'), (27, 'caa', 'almazan', 'caa', 'files/img/caa.jpg', '$2y$10$EpdgmAom9vkEduApdSbOIOgZdEWTtTVBbqgwT4eMIweWG1oyLD/XC', '63d87a98941beJ63cp6bYOjSRsFUoskAX6h3sY3yc4Cv8', '2023-01-31 10:19:04', '2023-01-31 10:19:04'), (28, 'MsDan', 'Danica Magtangob', 'MsDan', 'files/img/MsDan.jpg', '$2y$10$KmnzH/ETzgNXg0GpjeTlKuwfYTtrssiKvJblS0tIE/30EutNky.4e', '63d87da30b08435vZZBKggFDKlNn4LUFFfuaO31sw0Gk1', '2023-01-31 10:32:03', '2023-01-31 10:32:03'), (29, 'SirArnel', 'Arnel Endaya', 'SirArnel', 'files/img/SirArnel.jpg', '$2y$10$0fvgO5mNJBHEy3mo0S57Oe7kEix18xVom4dLu8vqEieA4V0iG6Eaq', '63d87f9bd360b1w0bHSCvCVU2YXJkTRuGzHYXQhwh6JEj', '2023-01-31 10:40:27', '2023-01-31 10:40:27'), (30, 'FGC', 'Ford Global', 'FGC', 'files/img/FGC.jpg', '$2y$10$etYCdtr8oiLMPc1muLUE7eXDCaL53soZTRTWZgP7wTCsBbzzcsaIG', '63d8860e28addPGoM9bDAR5fD55E5VANAVNM1SLPYiduK', '2023-01-31 11:07:58', '2023-01-31 11:07:58'), (31, 'FGC2', 'Ford Global', 'FGC2', 'files/img/FGC2.jpg', '$2y$10$VxVA2/E2TN8x1883IlkrTu9y8pXpAHuX5Psh9e06QSZiHIpIn9RCa', '63d886ce7c6d9z7wD3XKsadYwf71SzDdqg1whJ3YzW6K5', '2023-01-31 11:11:10', '2023-01-31 11:11:10'), (32, 'MNBGC', 'Miini BGC', 'MNBGC', 'files/img/MNBGC.jpg', '$2y$10$n1iE202JeBCuQs/iNXIdIOe841S1piD2vgSlBzFDm4bgzEJxEyPWC', '63e06153e8d8aFNbfvNsiUDkrKB3e10HmPCaQRoTAS40q', '2023-02-06 10:09:24', '2023-02-06 10:09:24'), (33, 'FGCv2', 'FORD GLOBAL CITY', 'FGCv2', 'files/img/FGCv2.jpg', '$2y$10$8IrPWHekCkow6INwS8cwCuNfSvaz7VIgvarXEIj/fDbw7bFunuXS.', '63e4997f6b807XXUW9AgYDNCdxsYxYa8u3SIE0koCLkT2', '2023-02-09 14:58:07', '2023-02-09 14:58:07'), (34, 'FGCv2.0', 'FORD GLOBAL CITY', 'FGCv2.0', 'files/img/FGCv2.0.jpg', '$2y$10$xAFXmTPRyVN.Tph/aFUuwuyfxTyzz39gtMAI6EAPrQFz/HC9gfopS', '63e49a542a95dJQ9dAXmu1nnEK2RBjhba10gvfzUQAZX7', '2023-02-09 15:01:40', '2023-02-09 15:01:40'), (35, 'ACCS', 'ACCS', 'ACCS', 'files/img/ACCS.png', '$2y$10$aLtrkp2ZBVfZuVTCIDOYG.a8tdEl5YYmIPGQu5uI4TOI8IQ6KiKCK', '63f32d851a5e1tnjvSMgT9irZINK3ig03tqOoU07Jh9hp', '2023-02-20 16:21:25', '2023-02-20 16:21:25'); -- -- Indexes for dumped tables -- -- -- Indexes for table `companies` -- ALTER TABLE `companies` ADD PRIMARY KEY (`id`); -- -- Indexes for table `company_address` -- ALTER TABLE `company_address` ADD PRIMARY KEY (`id`), ADD KEY `companies_id_idx` (`company_address_compId`); -- -- Indexes for table `customers` -- ALTER TABLE `customers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `links` -- ALTER TABLE `links` ADD PRIMARY KEY (`id`), ADD KEY `custId_idx` (`links_custId`); -- -- Indexes for table `transactions` -- ALTER TABLE `transactions` ADD PRIMARY KEY (`id`), ADD KEY `custId_idx` (`transactions_custId`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `user_name_UNIQUE` (`user_name`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `companies` -- ALTER TABLE `companies` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `company_address` -- ALTER TABLE `company_address` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `customers` -- ALTER TABLE `customers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27; -- -- AUTO_INCREMENT for table `links` -- ALTER TABLE `links` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT for table `transactions` -- ALTER TABLE `transactions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36; -- -- Constraints for dumped tables -- -- -- Constraints for table `company_address` -- ALTER TABLE `company_address` ADD CONSTRAINT `company_address_compId` FOREIGN KEY (`company_address_compId`) REFERENCES `companies` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Constraints for table `links` -- ALTER TABLE `links` ADD CONSTRAINT `links_custId` FOREIGN KEY (`links_custId`) REFERENCES `customers` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Constraints for table `transactions` -- ALTER TABLE `transactions` ADD CONSTRAINT `transactions_custId` FOREIGN KEY (`transactions_custId`) REFERENCES `customers` (`id`); COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; customer_kiosk.mwb.bak000064400000052417150253271320011061 0ustar00PKVqHdocument.mwb.xml}rK{L3mYzbԕZҭI %`*HI 6 9dS5_g?<%|o 'l~2X)x2 N`W_/O2<O^FUcߞLX7g])wє_W->[;;.?puКw;'v,Vڂj !> NlDNL:üa!5dSwh;获xzmpW>np6HQ]7fv8D ECn#>=Wmv-}Φ_/bV&uЎE,[g@&dP7PQu48,|0\Vw]-w d2l曩 `r0ozӌU/O+jaƗ|8;1@5l޺Cj`zo %wd2XQb'D<Ϋ}u:ڤS֠yjn䳵(U>[]xXϡߜMF76%L[ . H%J$ ڨHF"| 鮐!wDD$B|?$&l8i4"h– ,- 9%ڲi >}/?6AynG;Du|œL/=xeqcGl[[]8="R:MHcdydZW oiЭ];8[^Nlc\}9Wq74eMXm͸4n9s L4y GϦeo?]4:d</ V;- ?o:xx}6ԞP7 ]ڼqGqln'iʓs׊~p^MM,_t7>9TSՇ<}}G'/f3hd=3ʌG \Rm4߯6uƆ5E?0&r$ cv! aIiWz~.(i0ϋ٨ju-B"&, BXd3&f$JC 0Ըhf燳']''`:O`nĊeA˦h`7hY~0E DJc:!JΩ.h=Z_CDODD\qSxX~=2bĭNbPN b5A4N  shr(A!B `_,Mg4!}=W$lЩt k/,dB$h ")Rq1(,:x>UXp9XM#a-3B f`O#G"45} Cqm|W{Nc%g?TIup7jVyAb}[4@ r!r ļ3k%-Ƃ=U#B 00:vV"nSh&Lw_42!oebK`-mt`?U_2RA0hEm4W)4]~pTr2~/˅㜎êFוf#JȘF!AE#RFh3=~&3'.,wMzMRxBAgk-^\ADn9%T2|ȆZXnE`ظj:jے-x],6Q5uFWFe3 . uV]pײm `4s1?d6nMtm*ܴ%bH-*| "[ _@y8_tjd|ۗۿ5kxf>>̿*kՎΪ1LZ5Fwa)Fmk?XAՀlO5j?n7rl *E`Tgv\L }^4v5?^N.XmzC``V0 /x[ a+obym2x7[oyO70rvBW [W-urk1oVeV3 yqzx9΂kng[QiF. Ǘ8ouj0nyvhW;igUlj./ ζMBzǺ;EX?!9 ͌-Bs} IXiCZ%֛`ypݎDr$;hZ[L!U%'*ƢmjC02*^H/w%:IO-w,{vH Kɤ%1~;= Ⱥ\)v2epz|r `(ƃQ7;_Hi8g֚q'I4b2()1؄=MA1RjOK-O Dk[E\,Y?9@:hMZ_׬AxʩzU>ȼ Z;.)4X9 G`4GK+8?YUpp{ܕHR`a,ú %u2\s1'?NNA>TZb 4l',gg: rg3pH,n'J$alicCcM)/34\V_Lu2O#a-3{vXh8i「/Ⴄi2g ĺ%,lODuM&2μq"G`gߓ>_`u)YPqkT3V ] Nq DKMY&a,qaB! 3.'.$!?xz7AAmrD(DB#MEB1KyR6}AUtpۂMPvm L2 P# A'k&$Up8 xS+eStkTG㪃cºls)<cBNhdY0B=FCXAÞ Udmvid2ÐЄcD0M9 0]oY%GDI3b()HaBXcTPe3ϛؕ㣨`}X*Xo:`m ֭U D$KtCK I"Qo@ ѐmεߕ]e]ǛFܲ}^/شpӸ¡ݗ]ݽ=ԠL5fwug@}t)f`s'()Vz` 1ۺ5 -aU軫3ڼ[z}vP20~kڊZәz+j_d[ՒBD"4\)#Μ@F*RA8;NDK{)a4Vh9: pΰ7DtUUlE"j"QD"HĦvHыDtHDcX+&I(Y"$`"%Eʙ#-9XENlwb{w;+L0Lښ'WjVGїBŅ**֜ERl%z(f/b{(r/(E(VXQQݘ럡(M+IQlu5Sy]+ 3@Db d@TsRh~ϔ 2rte [4$W\B4ىdW/JkrzgOjeicuB\dqHzl.Y=j%_?RUЯ߶ u1˔h`tQi}tI&<1W}:pD0l)C|dEQ|)%3|ܑRY{PceP0IYC:.2L%9+(= L#nK!d6xXqp/۴Gzvl4&iD3r6һ%#Ю}X {| w)*,=X`1<8˭d~&`=V`ĭD'$ID!JR-Q% JF=񡤑DM#5Ȱ $b:J: J%.(YPQYøf{ogp+ntYA#+AGIT:"G|cZc" >6G:!Hi4 AZ$ (VPHʝz֖ƾAd'tcGަ905;}< dcG.˝B>un딶z9/g_Jc,|:{pZ6IӋx:!4gYl qFc(YY5rm܉b]wdI1x0q5r8)D]R0=c&,>j2 2   3Q)m&h2ժۚLV|d*LEsS;JG/]ꝵ"]d>2ŘI9D IL@PX a0ŝe=4S`O0[0Ţ޹kTSZb_bQ,i\QsΖ{Ew΢yhY;zג>Ϋg3Z}ص;r)S$cDAJ^9Li-O#F%<" AL{LH& S<{K=9?.=)Zwb?ZBa"NCu!ػ$dĕ}D?i 7c3ܑjIgj~0nmSȤH0&"s!W NU`1ѻ=K0#@zRаa4NI{0efP1Q(p (ĥRIB 12 {X`aiGamSDx(:'ENcXb\L| 6i1Ll٨+Lcj0rϩjH A/81>rX0&BVTjڳ)$xDJp -r(b 3^/{qx@‚ܦ:KS~ :qO pSu`wJcI0 ! w / úr Xe逅HYV&`^QHa`h>' 5!rvbX~aaI e ,Z ͣ--XG,,iG4 r|R=]U2@C$,Bh(N$ ̈[ 0U50m;um0F91!IBahS Yk,:ab.LzF=(=GzvvLJfB).ϖG䐷2zw[<`8^dTMY/jV@$8]6KL"'+&;Vȧ\'Dpj`LΩ0MKmBa}3Fi@ȈiHѸB|笻.%_Klhk"_Mۗۿ'-ijvRU u4ڮ2EAcȪ J"͂Db-728L)Jf ߉Dd@)0 ⑅).S#̵L֊/L0{c~߿Dw%tЦAcJƸh<ך [%'mJݤ:RL#&]B&%jsbB;KkemXkXS2:^PGRcoV^2dC\Q,Y!;JS1xO1R)Wu1@u`@@ 1I/ӻKk/qXgX㣠t1p]cc{ԑʀuLIíȱP^("u: n]F!EB<%ln0JSB UXBw:RFmXkXSǕeBBkOݮF&N_>/~W/m,6˳o00xiei) -WV/#;̗j~vvW6򹶋D7m xV~ͩe7ҹX%a[؂ܹ56.5skd͙}3`n`<Φm|ȥE -a>fASXVdʛj%xû-';x7yo9o70rvBW [W-urk1ouzۘr:jl;Zqcv7j[V[6կN~=΀f3\x7m31!b)C"S [ՏE֭J&﷚qIӋ6`1L[G"D+d#(D$k3%j^۽n{ﳓ;߽uT"bT q\"O[*Й[.$ nOk\l6XMh{c癉 &@\x$:I{mhƺ{EJ]{.V-VR?.)u.ָeib?*sLFD !BNx$z^BR)W?WtvIO(O{efp@48 `;a# cEO8bpp NzhWL!)A\r"pXF]>ƃ)r]p`]}\8690(AE1==.8}QZp`# Z/4,5rd $! {*ZаQLа(("!Pi/(R *!".}EjG2燂%8be.-D<:&E[@+}EetMsYJ"x#(ν%(]R}ב)) C$#s r& tB dM]n* !soFF($Ld<)28{WZݻ]u֊/U7K"($(q|7[}FI璤XdrH*-c w>{/U!M`͐F Y(9 I)g}:+0>xT_gWEӧ7T޼Toq3Iơ@UKBMHTbb #YD:OdVnZ+Bϣ⋩ȇ/1"pb>;^|\̧s)b>Ȩ$쩘G?|"?C粕|#`Y(4Sу]< C5Bz*X JsY&:M aM@.V$E֧ٲ5RghEsZ ১a[a24q)0=)c)G3_OO]Ұ `8x 4_X(D;< LGy`=,ICžb 6c5mk#CxNPY  %^= UWW`&8x6@ا@Y[# 4K>Ƃ 'r,X0 Ǔt^ٳBnr!$iK8J"&>},L  m(HX Pn"q1)bĹQ̑&>`I$!^$l?APX~aah=JYa1" 4$N{NY`aOB ,ltW25ٍQ+C2#|ʵ)9q({iDhDAPp>.H"ih D(BQp'k1,(-F.,,Xdq kڳ0DR(lέ YkJ"%(J>a_H))X)"暞n$i4 `P7ڮǿI⎇U'WݡtkF PqJ8(@T IZwKZ w4 "˘Ad$):RJtU*R+i`KZK)RJlj>tIt.f.bxbH)&&!0E=rcuPVQ#),S`b[`)؂)|_[D.xPDp}5'n)X C@CJ=/r/,KRT[ i@~sLV+x:_Kf[ⶏoTRIׁ|3T}G5K{<'|+վN{nx-OwӶl7FO~[o4p_ )[;sVQ>gnmA;9" j::>0J&s5Zuju ѭP..Q柪/лDwueŊk^!jDD2%!a›nޜ@,i2ooiT u7:S.L}8Mgc=Tƾ)s4X nL}::W/$hWgÏY7 we2|?WǮ<Wءo]蓼;rwdi-ag: Ug泓;TR$ڒkG-Θa30ɢ;ڰP!nw:At^ F䴈k3 ~S4vξeÏ?gu.pml #Dz.@a@L >1I]x2zn@HnxRWߎ׿tp\K Uˆ'a6 A ƌ-B G,F[bEޮZ/gѬ5cw+< կqCW;%ݙZ\suhٴ+v.ֱltiWZu)si:{jvR-;󾧳 |Z7zJ,V۝M.;re2_ϫFW4N'eX{4>>WfQtP i5rTGW=sx!*DCNf=(-mݶgV. 6 E$AxxZYPMh-W0`Dq<̮#B"S0g`N'$Ks NXňQy51Gi*f2lxVd5F%snK:|:Ǜ̆,ڞe]G_::Zk\_bD9j8<|Z{t0sBBX]jcd0 d֛uA`50W5Orb1/qi4L"Z&djuw$&3 hݶm Z|n֎ G@]J:k86ATGed#sVoZLض%Γl0y7*op{H^Nn|+$ZȏO~- & j @LĉuG =g\P؃+=啪4?#x i:N٤e3*Ms*.#?]}^bBq9cQ$Z#D3M"lŅ3CҜ3\j郸Z}?Ng8y|ྱU\3uߊ} !YcrWg>uN_Cxq#w)%04LQgBcLc//ys/. _UxͤL LP2҉+[HøoG52ZJ"ZGKiߎ3YϼTyT{0:Ofl\##FyJ8`qs#Eϸ"%Ql9} %4¹>شr>ዓZΦax‹c+% hHűɫmDI`OW({MQ0/Wyd;;=_y*g[]\ oWK;/7 o|ܺPl)jmnvmZEuF`d?;͒,nspV/>_lvrxkn0%m7(W-wټA[.~^n,4qAV?߬BCY˞GNqpE/VZיPF:ώƓjjs-7J0XIR&P#fur_B3 G3 dzǃOiHGo, )>b nOlKx AD`|A#ǰA[FqMϩQF'tbPaPDSDGo޾|e}37'*  t:|Qv <BW8ꭄ0ȑ9h`0b4AzI F`πhtyAy ZkyC`S@߅4w t+̢@' \#{`cmÐdž4o3o#Rb"EXHy2Si=S#lme `pIfP%|W@ bl-0F^a axTrJjR9%)<'%qՀ6^%I>,"䭧JE&=XS Ffyif];&z:'@IiJr#9[sb:oT~5*yG5& Gcy Lf`f(M#ϘT( =_<3 fsuX,OA& g`|@pqrur'ij)ߑ#2~{C% n7822XE5@G,HhՃcbO_@XfH~ϱD)}2xGlހnx96oB{MD2SVC ĀbI 5jQX*7e x02O&Q>|$" &&a#w!jG XB/@, jԁh|O@; ݫ&^;b"! 8ua\y:^K ɔ9o) =Nhr?UѸj2wnxSyXg# pX`dFդj:G'|{[s(ySd6a`ACC^hN`^yZzyY1n`;%q ^#yq!/Lڼ9GiC[yxK7;fTY>aNT0!O)h$ 6,_a9fJͭj^` P_Pruxqu6k n`-M6|' q V3 'r|g4FұT12|-a *vѶ+|-&:.Vh;p)A!)0GQ)o?KUدr@,-(^p*Ym>A[)w L-@8ch` sL)|F[Ff+7O@^&h2GLT28yMk勶6j`q$%Z`RK!if^xXH)ԖeLil0iZA\kU3QJyh@/ 'QyN|n6/i0I>#ఝBiN6Z6xy9g XDÅR&wdv֨ΈObǃ[cZ-gkaa+4|BA1=z۷u▧La!w;Ph`z+FAP >"!X'tM:ky|@!< Pl$T.')( 8 6L|KByGGmp)1!y\}x:9wu )C=!9Ro9We&c/n !| ArM`b`| ;3Qȯ 1na;:b"Nl@ ^/7@,+ổp{v0J qex-x6ohrj q_i>7G9Ƃ=s%8rv)0'onpgJ2%ոzR-RnJfMnH}75 ɠRRI'_oi[F^M*yEUFʙ11h}7L~_]5|o|_F|փ+|y[YPtT}ii)gm[ri J]E_) y=KJy~y=-T?xoO 2y3 (f~=xq|ge[VΖ+֗L[Cm&n\Y ax줍9!%Sflާuͤ;%8@q/_-?B4ӳ`:) kм>?Yռs? 9* υz/ EX?!9l(sNuՁLΟ̎,?TO?m̡c3\Kk|֏ ?7]\\zs8ϏU#ӌZ`-wlWRFjnRHxf᛿k1ޮ+lw|,lmz`s_)zlـGnyp -gͭ5xoPKzV,lock10268PKzV;N H @db/data.dbZo]G~KP yu3gʆ3iA"$7qۈ8)[*oJӂ?+$luÆ  yN= ‘{t=Μ3s򍃝vzvf2b16ٿ͏^wۜߟŗ31lɾڳ/;{;7w,xcrr}c&{l}_?;3dGۘ6[]ݟp短nreW'mi6 'u3!-Ғ]0G1 w#+k%' VS} ji;sKL?d1/7><_7OMd${J=ˆJm"لф!|̑3FCpv}BcVAkF"餇mBԸM@I* #Gc-~ȹ4l9"V-d*g)P6bZJK y$ZX䨔4<63&ov4%e(Y/El`h$ SÑU')y*vʅPzQ]g':6ӓ!Es˘ҿ)*c%i% V,1Q[T2r҃N,E c[UK6N>&j.4\lm*kja%,k(1IyLV4^g0gTQ>p