a) 7/͝~¼)m Pqe{m'W{=TpTUgS[[GcLٯM Lm$a7 | KGKq-i$b5&_O~,e-QZ:͝(Oa[@PiSٻkml+HdI^oKt^ؖڨiık7i~Hg+ -Ya-b}M-KNqfCa$c虥_V~ɬ?ʶjnoa)_b_Ffa.rryd3D F\!)JsKxޕfeAP)'F=[b[hD / A^M9К8'cCgྠH} DͳJ}@c~<6|Q֪`,ٯ/ A Ee--OXA?]Tև[f/N˳bc1oW86Ae&?)t! Ji[{]8\l>g}.FGbRvH.zSbxG+}r#U4Dpp侎SD"9@q@D9yx#sZ% 7gmZTX'vGkbqQZRQb>R][3y9z1}2p6eIŔ 7ΩRc}vYޕqġn}+s Gw>?bМI#<77o?ϣnt=hkΖ"2<8C}J(˶CtYAnR<(g}N`~9U\?BpǘXf(؏FGJm++iRBnŹՎpׇFi(~_+;"(99\Cgr@BƩB/ A ֔C[пF$LKjQȺ1@(X7*%]0M/ AGc!qU f[*YOq57z^<.$Gމua"tR2i m,y@?[t1.C孬_Uŋ/e0P]OS_vzG³ԋBZo_*[bϋ* </ Ad_u oԕŸBQE`ZDoh% JN/̹Rw$cOG(7C0ix4]+s7 = `N/Ȥ–=Q*G|Æ7u;g74 pҎ&}>g}.FGbR-bޣ jf2x.41j#Op h/bE"@/ AQ٭k]̰=Y4(W#ߣE6qkڟ-hP8 ω} 8A`SAnR<(g}Ndv]IOZC"6wCjyG# ĭCKx:~mUɩ>I/)B*7u/ AN4pgAܪ<xHgGF BU!dODCqflg__:RKd`aN&ÇE!5'l.4vI &%@+nʎݨoCbPf8{}URqچ_ko|(9tw02Mb ovK[ה/ ADDuqq3fY\e{ :Q+7`>N#5E՜;/ A tJM >E̊V#CǓ |;(Mvh)qun([`"z.;Jo6hIZŽ/ A/uR-r\:VPц D +0zsy3ސ x'Ǒ,7,1B714LdE歔/ A^t"T*_؋)\}=R] m)ׅ˷h)i~Y""c휟2=K)@t 9n/ ᣠhwc9dZI[E_|)/ Ad;Ƣ?s I Ζ(WvEّ+$zu_@G=v2/ A}kc|*3&e-9R4zO(vaF>{G.^vA)أnig1ChAqWHa R+KPF/ A0$%Hڄ!LlxX!nM{ +7 F{H(bVH޵,zDGJq9f|um0#A-lW߹$sӹ1/ AR梅K2qklH't" h^Q\I`A$gʊkk^ ,>*ۤ6ʛh6U$zB*c?v•y&xRGUH4mp@ƙlKjT T*W0anzfY\RaeVƁ2 !-Z1Ot}'7"vgq/ A.PD:38]$Q#*\v hܬAnR<(g}NOp.b_hhVJ<ϵ.[`ץiXk (Ԝ(Jpca HA)@9M 3,}lD_.{m*7p~),g\F++PPm9/$~:BlE$۔/ A嶾 4Muk(+z;م& mN؅`a!nr$9͉wZ9>TB>& U9V[$*׽"H7'qgdt@?[t1.á$ )K](A֖R? BETc 4CH8d1( #T=8 q3tat<'i ƻw / AuМ2# CQEW]=C2Ov|PYxK֥gʊkk^ ,cr}lr.{iY>S5S<\[S)\+GR>S0\94Sj5r\@RS5S<\[SB\[S)\+GR>S0\94Sj5r\@RS5S<\[SB\[S0\94Sj5r\@RS5S<\[SB\[S0\94Sj5r\@RS5S<\[SB\[S)\+GRHS0\94Sj5rSrSrSrSSjrSrSSjrSr\@RS5S<\[SB\[S)\+GRZS0\94Sj5r\@RS5S<\[SB\[S0\94Sj5rSr\@RS5S<\[S)\+GRbS0\94Sj5r\@RS5S<\[SB\[S)\+GRbS0\94Sj5r\@RS5S<\[SB\[S)\+GRhS0\94Sj5r\@RS5S<\[SB\[S0\94Sj5r\@RS5S<\[SB\[S0\94Sj5r\@RS5S<\[SB\[S)\+GRpS0\94Sj5r\@RS5S<\[S)\+GRtS0\94Sj5r\@RS5S<\[SB\[S)\+GRxS0\94Sj5r\@RS5S<\[S)\+GR|S0\94Sj5r\@RS5S<\[SB\[S)\+GRxS0\94Sj5rSr\@RS5S<\[S)\+GRS0\94Sj5r\@RS5S<\[SB\[S)\+GRS0\94Sj5r\@RS5S<\[SB\[S0\94Sj5rSSSSSSS.rS)\+GR4Sjr\@RS5S<\[S)\+GRS0\94Sj5r\@RS5S<\[SB\[S)\+GRS0\94Sj5r\@RS5S<\[SB\[S0\94Sj5r\@RS5S<\[S)\+GRS0\94Sj5r\@RS5S<\[SB\[S)\+GRS0\94Sj5rS)\+GR4Sjr\@RS5S<\[S)\+GRS0\94Sj5r\@RS5S<\[SB\[S)\+GRS0\94Sj5rS)\+GR4Sjr\@RS5S<\[S)\+GRS0\94Sj5r\@RS5S<\[SB\[S)\+GRS0\94Sj5r\@RS5S<\[SB\[S0\94Sj5r\@RS5SS<\[S0\9S\[S\[S\[S\[4 Sjj5rSr\@RS5S<\[S\[SB\[S0\94Sj5r\@RS5\"S5S4S<\[S\[SB\[S0\9S\S\[4 Sjj5r\@RS5S<\[SB\[S0\94Sj5r\@RS5S<\[SB\[S0\94Sj5r\@RS5S<\[S0\94Sj5r\@GRS\"\-S- S9SS9 \@RS5S5rg)N)asynccontextmanager)date)Path) Annotated)urlparse)FastAPIDepends HTTPExceptionRequestResponse UploadFileFile) FileResponse JSONResponse HTMLResponse) StaticFiles)TrustedHostMiddleware)ImageUnidentifiedImageError)encrypt_secret send_message)build_estimate_pdf)authmodels) ROOTDATA_DIRdb initializeuidnowinsertupdaterecordaudit next_code>leadsinvoicesservices estimates transactions service_callsinventory_itemspurchase_orders>jobsr'tasksr(r) customersr* properties warrantiesr+r,calendar_eventsr-r.>r/r1r2r+r,r-r.c[U5nURSS5 SUR5;a[US5OSUS'U$)Nsmtp_password_encFsmtp_password_set)dictpopkeysbool)rowdatas app/main.py safe_businessr?sI cDHH $'@SWZW_W_Wa@ad3':#;lifespanrD&s L szLB Exterior Lighting CRMz0.5.8 CRM_API_DOCS1z /api/docsz/api/openapi.json)titleversionrDdocs_url redoc_url openapi_urlCRM_ALLOWED_HOSTSzlocalhost,127.0.0.1,testserver,) allowed_hostshttpc# URS;aURRS5n[R"SS5R S5nUR RSURRSS53nURRS5S :XdU(aX$U4;a [S S 0S S 9$URRSS5n[U5S:a [S S0SS 9$U"U5IShvN nSURS'SURS'SURS'SURS'SURS'UR RRS5(dnUR RRS 5(dDUR RS!;d*UR RRS"5(aS#URS$'S%URS&'[R(aS'URS('U$![a [S S0SS 9s$f=fGNH7f))N)GETHEADOPTIONSoriginCRM_PUBLIC_ORIGIN/://hostzsec-fetch-sitez cross-sitedetailz(Cross-origin requests are not permitted.i status_codezcontent-length0izRequest is too large.zInvalid request length.nosniffzX-Content-Type-OptionsDENYzX-Frame-Optionsz same-originzReferrer-Policyz(camera=(), microphone=(), geolocation=()zPermissions-Policyzdefault-src 'self'; script-src 'self'; style-src 'self' 'unsafe-inline'; img-src 'self' data: blob:; font-src 'self'; connect-src 'self'; frame-ancestors 'none'; base-uri 'self'; form-action 'self'; object-src 'none'zContent-Security-Policyz/api/z/static/)rWz /index.html/quote/zno-store, max-age=0 Cache-Controlzno-cachePragmazmax-age=31536000zStrict-Transport-Security)methodheadersgetosgetenvrstripurlschemerint ValueErrorpath startswithrSECURE)request call_nextrTallowedownsizeresponses r>securityrx2sR~~55$$X.))/3::3?##$C(;(;FB(G'HI ??  / 0L @VPVdk^lPl*T Ucfg g""#3C8 W4y++#X.E$FTWXX,w''H1:H-.*0H&'*7H&'-WH)*3MH./{{""7++w{{/?/?/J/J:/V/VZaZeZeZjZjoC[CGNGRGRGWGWGbGbclGmGm,A)%/" {{8J45 O W*C DRUV V W's7CIH29 IID+I2I I I  Ic"# [SS0SS9$7f)NrZz>This change conflicts with an existing record or relationship.r[)r)rrexcs r>integrity_errorr|Ns "bcqt uus z /api/healthcz[5nURS5 SSS5 SS0$!,(df  SS0$=f)NzSELECT 1statusok)rexecute)conns r>healthrSs6  Z   T?  T?s) :z/api/auth/statusc[5n[URS5R55nURS5R5SnSSS5 WWS.$!,(df  N=f)N,SELECT 1 FROM users WHERE is_super=1 LIMIT 1zSELECT COUNT(*) FROM businessesr) configuredbusiness_count)rr;rfetchone)rreadyrs r> setup_statusrZs^ T\\"PQZZ\]&GHQQSTUV  @@ s A A## A1z/api/auth/setuppayloadc [SS9nURS5R5(a [SS5eURS5R5(a [SS5e[R "XR URURSS9nS nURR5(a[[5URR5URURURS S [!5[!5S 9 n[#US U5 [%XUSSS USUS5 [%XS SSUS5 S S S 5 SWS.$!,(df  N=f)zPBrowser-based first-run wizard. It is permanently disabled once an admin exists.Twriterrzz)Initial setup has already been completed.zSELECT 1 FROM users LIMIT 1zBUser records already exist. Use the server recovery tools instead.)is_superNrr) idnameemailphoneaddressactiveis_demo created_at updated_at businessesrz#Created first business during setuprz"Completed first-run platform setupusers)rbusiness)rrrr r create_user admin_name admin_emailpassword company_namestripr8r company_email company_phonecompany_addressr!r"r%)rradminrs r>first_run_setuprbsV $4 <<F G P P R R%PQ Q <<5 6 ? ? A A%ij j  '9'97;N;NPWP`P`kop    % % ' 'su7+?+?+E+E+GwOdOd")"7"7AXAX#$aCEceUH 4x 0 $x~/TVbdlmqdrt|~DuE F d4!EwPUVZP[\ H 55 s EE%% E3z/api/auth/loginrrrwcZ[R"XURUR5$rB)rloginrr)rrrrws r>rrvs ::g8H8H IIr@z/api/meuserc z[5nUS(a3URS5Vs/sHn[[U5SS9PM nnO/URSUS45Vs/sHn[U5PM nnSSS5 [[R "U5WUSS9$s snfs snf!,(df  N:=f) Nrz.SELECT * FROM businesses ORDER BY is_demo,nameownerrolez~SELECT b.*,m.role FROM businesses b JOIN memberships m ON m.business_id=b.id WHERE m.user_id=? ORDER BY b.namercsrf)rrr)rrr8r?r safe_user)rrrrs r>mer{s   HL VFIGHIG1$}Q/g>IGJHJ48LLB^`dei`j_l5no5nq-*5nJo  T^^D)jtF| TT Ho s(B,B"B,!B'6B," B,, B:z/api/auth/logoutc *[SS9nURS[R"URR [R S5545 SSS5 UR[R SS9 SS0$!,(df  N0=f)NTrz'DELETE FROM sessions WHERE token_hash=?rVrW)ror)rrrdigestcookiesrgCOOKIE delete_cookie)rrrwrrs r>logoutrsm $4 >W__M`M`aealalmoMpAq@st  4;;S1 ; s AB Bz/api/auth/passwordc [R"USUR5(d [SS5eURUR:Xa [SS5e[ SS9nUR S[R"UR5US45 UR S US45 [X!SS S US5 SSS5 SS S .$!,(df  N=f)N password_hashr_zCurrent password is incorrect.zChoose a different password.Trz9UPDATE users SET password_hash=?,must_change=0 WHERE id=?r$DELETE FROM sessions WHERE user_id=?zChanged passwordrz7Password changed. Sign in again with your new password.)rmessage) rverifycurrent_passwordr new_passwordrr hash_passwordr%)rrrs r>rrs ;;tO,W-E-E F FC @AA7#7#77C >?? $4 PSWSeSefmfzfzS{}ABF}GSH I ;d4j]K d/T C  Y ZZ s %AC Cz /api/profilec r[R"URSS9SSn[R"URSS9SSn[ SS9nUR SUR URURX#US45 [XASS S US5 SSS5 S S0$!,(df  S S0$=f) N)rM:) separatorsi N'TrzZUPDATE users SET name=?,phone=?,job_title=?,dashboard_json=?,preferences_json=? WHERE id=?rzUpdated profilerr) jsondumps dashboard preferencesrrrr job_titler%)rrrprefsrs r>profile_updatersjj**yA&5II **W((Y ? GE $4 qll7==1B1B9SWX\S]^ ` d.wtDzB  ;  ;s A B%% B6z/api/admin/businessesc[R"U5 [5nURS5Vs/sHn[ U5PM snsSSS5 $s snf!,(df  g=f)NaoSELECT b.*, (SELECT COUNT(*) FROM memberships m WHERE m.business_id=b.id) AS members, (SELECT COUNT(*) FROM customers c WHERE c.business_id=b.id) AS customers, (SELECT COUNT(*) FROM jobs j WHERE j.business_id=b.id AND j.status NOT IN ('completed','cancelled')) AS active_jobs FROM businesses b ORDER BY b.is_demo,b.name)rplatformrrr?rrrs r>rrsXMM$ *.,,8;+<=+create_businessrs MM$ G  4(;(;#<<C ]^^   |M&B  CDYsuYtY1Q#%SVSXYH $4tL* d'9,xPT~V^_eVfgmtnAnA8D>':L:LWM`M`ahiGK   // s A+D D z"/api/admin/businesses/{bid}/activebidc [R"U5 [SS9nURSU45R 5(d [ SS5eURS[ UR5[5U45 [X2XR(aSOSS U5 SSS5 S S0$!,(df  S S0$=f) NTrz#SELECT 1 FROM businesses WHERE id=?Business not found.z6UPDATE businesses SET active=?,updated_at=? WHERE id=?zEnabled businesszSuspended businessrr) rrrrrr rmrr!r%rrrrs r>business_activersMM$ $4||A3&IRRTT$9: : MsSZSaSaObcfchilNmn d...FZ[ghkl  ;  ;s BB00 Cz/api/admin/userscX[R"U5 [5n/nURS5HRn[ U5nURSUS45Vs/sHn[ U5PM snUS'UR U5 MT UsSSS5 $s snf!,(df  g=f)NzSELECT id,name,email,is_super,active,must_change,created_at, (SELECT COUNT(*) FROM memberships m WHERE m.user_id=u.id) AS businesses FROM users u ORDER BY namezSELECT m.business_id,m.role,b.name AS business_name,b.active AS business_active FROM memberships m JOIN businesses b ON b.id=m.business_id WHERE m.user_id=? ORDER BY b.namer memberships)rrrrr8append)rrpeoplerpersonxs r> admin_usersrsMM$ rsA7F48LLBpqwx|q}p5A#B5Aq475A#BF= ! MM& ! s   #B s:BB0BB B)c [R"U5 [R"S5n/n[ SS9nUR SUR 45R5(a [SS5e[R"X@RUR USS9n[5nURHnURU;a [SS 5eURUR5 UR S UR45R5nU(d [SS 5e[US [!URUS UR"S95 UR%[!URUSUR"S95 M ['XASSSUS [)U5S35 SSS5 [R*"W5X2S.$!,(df  N'=f)NTrz0SELECT 1 FROM users WHERE email=? COLLATE NOCASErzz]An account with this email already exists. Use Manage access to assign it to more businesses.) must_changer_%A business can only be assigned once.)SELECT id,name FROM businesses WHERE id=?0One of the selected businesses no longer exists.rr business_iduser_idrr)r business_namerzCreated user accountrz business assignment(s))rrtemporary_password)rrsecrets token_urlsaferrrrr rrsetrraddr"r8rrr%lenr) rrrrrrseen assignmentrs r>admin_create_userrsMM$  " "2 &HK $4 <<JGMMK[ \ e e g g%DE E\\'--UYZ U!--J%%-#C(OPP HHZ++ ,\\"MzOeOeNghqqsH=5g#hh 4 dz7M7MV\]aVbhrhwhw&x y   t 0F0FU]^dUekukzkz{ |. d3GF4LCP[L\K]]tIuv >>&) bb s E7G Gz"/api/admin/users/{rid}/membershipsridc ,[R"U5 XS:Xa [SS5e[SS9nUR SU45R 5nU(d [SS5eUS (a [SS 5e[ 5n/nURHnURU;a [SS 5eURUR5 UR S UR45R 5nU(d [SS 5eURURURUS45 M UR SU(aSRSU55OS-U(aU/UQ7OU45 UR SU45 UHupn [US[XU S95 M UR SU45 [X2SSSUSRSU55=(d S5 SSS5 SS0$!,(df  SS0$=f)Nrr_zZPlatform administrators already have access to every business and do not need assignments.TrzSELECT * FROM users WHERE id=?rUser not found.rz8Platform administrators do not use business memberships.rrrrzZUPDATE jobs SET assigned_user_id=NULL WHERE assigned_user_id=? AND business_id NOT IN (%s)rMc3&# UHnSv M g7f?Nr.0_s r> $admin_assign_user..s(~QLPGHBLPz''z'DELETE FROM memberships WHERE user_id=?rrrzUpdated business assignmentsr, c34# UHupo3SU3v M g7f)z: Nr)rrrrs r>rrs2RDxChshiosTZZ\]a\bRcxCszNo business accessr)rrr rrrrrrrrrjoinr"r8r%) rrrrtargetr assignmentsrrrrrs r>admin_assign_userr s8MM$ 4jC |}} $4||vF%JCQ 4 dsD&Q R& ;SFC d;GC RDxCRDIDI\H\ ]! " ;# " ;s GH Hz/api/admin/users/{rid}/activec [R"U5 XS:Xa [SS5e[SS9nUR SU45R 5(d [SS5eUR S [ UR5U45 UR S U45 [X2SUR(aS OS S U5 SSS5 SS0$!,(df  SS0$=f)Nrr_z$You cannot disable your own account.TrSELECT 1 FROM users WHERE id=?rrz$UPDATE users SET active=? WHERE id=?rzEnabled accountzDisabled accountrr) rrr rrrrmrr%)rrrrs r> user_activer sMM$ 4jC FGG $4|| reset_userrsMM$  " "2 &H $4||platform_activityr"sIMM$ !%.q!rs!rAQ!rs s rz/api/b/{bid}/settingsc [SS9n[R"X2US5 UR5nUR SUSUSUSUS[ 5U45 [ X2US S U5 SSS5 S S0$!,(df  S S0$=f) NTrrzNUPDATE businesses SET name=?,email=?,phone=?,address=?,updated_at=? WHERE id=?rrrrzUpdated business profilerr)rr authorizerrr!r%rrrrr=s r>settingsr)s $4 tW-    ! e6l4=gtIsuUXY [ d6|CH  ;  ;s A$A:: B z/api/b/{bid}/teamc[5n[R"X!U5 URSU45Vs/sHn[ U5PM snsSSS5 $s snf!,(df  g=f)NzSELECT u.id,u.name,u.email,u.active,m.role FROM users u JOIN memberships m ON m.user_id=u.id WHERE m.business_id=? ORDER BY u.name)rrrrr8)rrrrs r>teamr4sf  t%!%/Z[^Z`"bc"bAQ"bc c s-AA AA A,c [SS9n[R"X2US5 [R"X2XRUR UR 5sSSS5 $!,(df  g=f)NTrr)rrrrrrrrs r>team_addr<sC $4 tW-t\\'-- U s AA## A1cURSX45R5nU(d [SS5eUSS:Xa5URSU45R5SS::a [S S 5egg) Nz>SELECT role FROM memberships WHERE business_id=? AND user_id=?rTeam member not found.rrzESELECT COUNT(*) FROM memberships WHERE business_id=? AND role='owner'rrr_z1Add another owner before changing the last owner.rrr )rrrr<s r>guard_last_ownerrCs UWZV_`iikC C 899 6{G -vx{w} ~!H!H!JKL!MOP!PC STT!Pr@z/api/b/{bid}/team/{rid}c [SS9n[R"XCUS5 URS:wa [ X@U5 UR SX45R 5(d [SS5eUR SURX45 [XCUSS XR5 SSS5 S S0$!,(df  S S0$=f) NTrr;SELECT 1 FROM memberships WHERE business_id=? AND user_id=?rrz?UPDATE memberships SET role=? WHERE business_id=? AND user_id=?zChanged team rolerr) rrrrrrrr r%rrrrrs r> team_roler Ks $4 tW- << Tc *||Y[^Zcdmmoo$<= = VX_XdXdehWmn d/LLI  ;  ;s BB44 Cc [SS9n[R"X2US5 [X0U5 UR SX45 UR SX45 [ X2USSU5 SSS5 SS0$!,(df  SS0$=f) NTrrzPUPDATE jobs SET assigned_user_id=NULL WHERE business_id=? AND assigned_user_id=?z9DELETE FROM memberships WHERE business_id=? AND user_id=?zRemoved team memberrr)rrrrrr%)rrrrs r> team_remover"Xs $4 tW-#& gilhqr PRUQZ[ d1'#>  ;  ;s AA00 Bc[U5nSH@nX!;dM [R"URU55XR S5'MB U$)N) items_jsonchecklist_json_json)r8rloadsr9 removesuffix)r<r=keys r> serializer*csE cD. ;,0JJtxx},ED!!'* +/ Kr@cURSUS3U45Vs/sHn[U5PM nnUS:XaURSU45Vs0sH o3SUS_M nnUH[nURUSS5US 'US S :XaSO US US - US 'US S :XaS OUS S:XaSO US (aSOSUS'M] U$s snfs snf)NzSELECT * FROM z8 WHERE business_id=? ORDER BY created_at DESC,rowid DESCr(zSELECT invoice_id,SUM(amount_cents) amount FROM transactions WHERE business_id=? AND kind='payment' AND voided=0 GROUP BY invoice_id invoice_idamountrr paid_centsr~void total_cents balance_centspaidpartialunpaidpayment_status)rr*rg)rtablerrrowsr2r<s r> list_recordsr8ks< $ ~eWD|-}@CE!F G!F1)A,!FD G j37<<AWX[W]4_`4_a oak)4_`C"hhs4y3C &)(mV&;]ASTWXdTeAeC ,/M6,A&RUVeRfhiRi~ABN~OpyU]C ! K G`s C CcURSU45R5nU(d [SS5e[U5$)N#SELECT * FROM businesses WHERE id=?rr)rrr r8)rrr<s r>_email_settings_rowr;ws9 :C6BKKMC C 566 9r@z/api/b/{bid}/email-settingscp[5n[R"X!US5 [X 5nUR SS5UR SS5UR SS5UR SS5UR SS 5UR S S 5UR S S5[ UR S 55[ UR S55UR SS5=(d+ UR SS5=(d UR SS5S. sSSS5 $!,(df  g=f)Nremail_sender_namerVsmtp_from_email smtp_reply_to smtp_hostzsmtp.purelymail.com smtp_porti smtp_securityssl smtp_username smtp_enabledr6approval_notify_emailr) sender_name from_emailreply_tor@rArBrDenabled password_setrF)rrrr;rgr;)rrrr<s r>email_settings_getrL~s  tW-  )''"5b9PabdHewwr2 Ti@j C0#''/Z_B`GGOB74P^H_C`(; <=$'GG,CB$G$377SdegKh$lolslst{|~l   s DD'' D5c[SS9n[R"X2US5 [X05nUR SS5nUR (a[ UR 5nUR(aU(d [SS5eURSURURURURURURUR U[#UR5UR$['5U4 5 [)X2US S XR5 SSS5 S S0$!,(df  S S0$=f) NTrrr6rVr_z2Enter the SMTP app password before enabling email.zUPDATE businesses SET email_sender_name=?,smtp_from_email=?,smtp_reply_to=?,smtp_host=?,smtp_port=?, smtp_security=?,smtp_username=?,smtp_password_enc=?,smtp_enabled=?,approval_notify_email=?,updated_at=? WHERE id=?zUpdated company email settingsrr)rrrr;rg smtp_passwordrrJr rrGrHrIr@rArBrDrmrFr!r%)rrrrr< password_encs r>email_settings_putrPs $4 tW-  )WW04  '(=(=>L ??<$XY Y B  !3!3G4D4DWEVEVW^WhWhipi~i~  " "<GOO0DWEbEbcfchil n o d<\#N`N`a  ;  ;s D"D88 E z /api/b/{bid}/email-settings/testc [5n[R"X2US5 [X05nSSS5 [ WUR SSUR SS5S3S9 [S S 9n[X2US SXR 5 SSS5 SS 0$!,(df  Nh=f![a n[SS [U5SS 35eSnAff=f!,(df  SS 0$=f)NrzLB CRM email testzThis is a test message from rz your companyz& CRM. Your SMTP connection is working.to_emailsubjecttextzEmail test failed: ^TrzSent test emailrr) rrrr;rrSrg Exceptionr strr%)rrrrrr{s r>email_settings_testrZs  tW-$T. HXw'7'7@S8f^9\8]^DE F $4 d-l3?O?OP  ;  HC"5c#htn5E FGGH  ;s.$B*B"+C B" C ,CC  C returnc@[R"SS5R5RS5nU(aU$URR S5=(d UR R=(d SRS5SR5nURR S5=(d8 URR S 5=(d UR RRS5SR5nUS U3$) NrUrVrWzx-forwarded-protorOrMrzx-forwarded-hostrYrX) rhrirrjrfrgrkrlsplitnetloc)rrrprotorYs r>_public_originr`syy,R0668??DJ ??  2 3 Sw{{7I7I SV Z Z[^ _`a b h h jE //  0 1 fW__5H5H5P fT[T_T_TfTf m mnq rst u { { }DWCv r@tokencf[R"UR55R5$rB)hashlibsha256encode hexdigest)ras r> _token_hashrgs >>%,,. ) 3 3 55r@c^ SSKm SRU 4SjURS/555nU(a%ST RURSS55S3OSnST RUS S 9S 3nS T RU5R [ S 5S5SUST RURSS55ST RURSS55ST RURSS55ST RURSS55SUSUS[ URSS55S- SS3$)NrrVc3l># UHnSTR[URSS555STR[URSS555STR[URSS555S[URSS 55S - S S 3 v M g 7f)z< descriptionrVzNquantity unitzO$r0rd,.2f N)escaperYrgrm)rihtmls r>r'_estimate_email_html..sw~e}`aTUYU`U`adefejejkxy{e|a}U~T@NOSOZOZ[^_`_d_deopr_s[tOuNvvwx|xCxCDGHIHMHMNTUWHXDYxZw[[jknopototuBCDoEkFGJkJKOjPPZ[e}sB1B4itemsz

Property: rz

z"

View & approve estimate

zK

z
z6

ru — Estimate codez

rGz

Prepared for: az>
DescriptionQtyTotal

Total: $r0rnroz{

The PDF estimate is attached. You can also use the secure button above to approve the estimate online.

)rsrrgrqreplacechrrm) rcustomerestimate property_rowr approval_url rows_htmlpropbuttonrss @r>_estimate_email_htmlrsgg~emeqeqryz|e}~~IUa  L,<,estimate_emailrsB##B'I9%J $4 tX. fT+c6 7 x=/ /$UV V[]);C@ADAWAWVDc-&8 =]a$T. ] suS5 7 #7+,GI;?L T xT :&x'//R^_ ??))+.RS_R``b,cc X'7'7U^ #6{m44H J $4 x=' ! 4 CXf,= > d.{3f+dSZScScRdd}?~ CM7$:T RR5 " T d^t LLV*- /^^C"A#c(4C.AQ RSS T sIB/F93A-G )_public_quote_lookuprsO5!J / 1;}  > ?Ghj   9FI 6::l3;t<XXn- |8  LL45;M5J<4X ZZbZbZd   #Y 88& ' '||%?@F}@UVb?ceememeo 88F#)r#'88,B#C#Ir6@*T"2b! =&!*  Mr@c SSKnU(d [SSS9$[R"UR S5=(d S5nUR S5=(d 0n/nUGHn U R S5=(d S n UR U 05n U R S 5=(d S n U (aoS UR US S 9SUR U S S 9SUR [ U R S5=(d U R S5=(d S5S S 9S3OS n [ U R S5=(d S 5R5n[ U R SS 55nSUR U5S3U(aX:waSUR U5S3OS -S-nURSU USUR [ U R SS 555SUR [ U R SS 555S[U R S S55S!- S"S#3 5 GM S RU5n[UR S$5=(a) US$[R"5R5:5n[UR S%5=(d UR S&5S':H5nU=(d UR S&5S(;nU=(d U(aS)O U(aS*OS+nS nU(d_U(dXS,UR US S 9S-UR UR S.S 5S S 9S/UR UR S0S155S23nO U(aS3nU(dU(aS4O U(aS5OS nUR S65(a'S7UR UR S6S 55-S-OS nUR S85(a$S9UR UR S8S 55-OS nS R/S:PUR UR S;S<55PS=PUR UR S0S 55PS>PUR UR S0S 55PS?PUR UR S;S<55PS9PUR UR S@S 55PSAPUR UR S.S 55PSBPUPSCPUR U5PSDPUR UR SE5=(d SF5PSGPUR UR S$5=(d SH5PSIPUPSJP[UR S S55S!- S"PSPUPUPSKPUR UR S0S 55PUPSLP5n[UUS9$)MNrz

Estimate link unavailable

This approval link is invalid or has been replaced by a newer estimate link.

rr[r$rrrrVrz'r���rj��Productzrz"
z zzz
z"
z
rkrlrmz$r0rnrorp expires_onpublic_token_used_atr~acceptedr(This estimate has already been accepted.JThis estimate has expired. Please contact the office for an updated quote.z?Review the scope and pricing below, then confirm your approval.z#
u^
✓ Estimate accepted. Thank you — the office has been notified.
successwarnnoteszD
Scope, terms & exclusions
business_phoneu · zery��Estimateu��� — a ��
z

rGz%

Prepared for z+
Property
property_addressz Not specifiedz-
Valid through
zNo expiration datezx
z+
DescriptionQtyTotal
Total: $z%
Questions? Contact z$
)rsrrr'rgrqrYrrrmrr;rtoday isoformat)qrarrr\rsrur row_partsrrrr attachment_id image_htmlrrj detail_htmlr7expiredalreadydisabled notice_textform status_class notes_html phone_htmlbodys r>_public_quote_pager s2  tADE E **QUU<(0D 1Eee'(.BII UU>*0b ]]< +hh45; xE>dkk%VZk>[=\\cdhdodop}EIdoeJdKK KKDHHV,<,am@T,aXa(bimKnooqsKM  *@!A!GRHNNPmB/0 9$++k:R9SS\]Och|iL&-A!B C7KRTU  =j\+W,,0KKAEE*Rh+>>Hy'FipYevwK D 84T[[T[5R4STIJNJUJUVWV[V[\klnVovzJUJ{I||BCGCNCNOPOTOTUderOsCtBuu^a  m%vrLDEDIDIJQDRDRVW[WbWbcdchchipqsctWuuv~~XZJCD55IYCZCZt{{155)9"#=>>`bJ k8 k8 r k8sws~s~@A@E@EFLMW@XtYsZ k8Z_ k8`d`k`klmlqlqrABDlE`F_G k8GI+ k8J+N+J+U+J+U+V+W+V+[+V+[+\+k+l+n+V+o+J+p+I+q+ k8q+{+ k8|+@,|+G,|+G,H,I,H,M,H,M,N,T,U,_,H,`,|+a,{+b, k8b,f, k8g,k,g,r,g,r,s,t,s,x,s,x,y,@-A-C-s,D-g,E-f,F- k8F-k- k8l-p-l-w-l-w-x-y-x-}-x-}-~-M.N.P.x-Q.l-R.k-S. k8S.~. k8.K/~.L/ k8L/N/ k8O/S/O/Z/O/Z/[/f/O/g/N/h/ k8h/b0 k8c0g0c0n0c0n0o0p0o0t0o0t0u0G1o0H1o0[1L1[1c0\1b0]1 k8]1J2 k8K2O2K2V2K2V2W2X2W2\2W2\2]2i2W2j2W2B3n2B3K2C3J2D3 k8D3|4 k8}4A5|4B5 k8B5m5 k8n5q5r5s5r5w5r5w5x5E6F6G6r5H6n5I6J6M6n5M6N6R6m5S6 k8S6Y6 k8Z6d6Y6e6 k8f6j6e6k6 k8k6P7 k8Q7U7Q7\7Q7\7]7^7]7b7]7b7c7r7s7u7]7v7Q7w7P7x7 k8y7C8x7D8 k8D8h8 k8D  55r@z$/quote/{token}/image/{attachment_id}rcd[5n[X 5nU(d [SS5eURS5=(d 0R 5Vs1sH+oDRS5(dMURS5iM- nnX;a [SS5eUR SXS45R 5nU(d [SS5eUSovSnSSS5 [S - W- n U R5(d [SS5e[U WS S S .S 9$s snf!,(df  NN=f)NrzEstimate image unavailable.rrz~SELECT storage_key,content_type FROM attachments WHERE id=? AND business_id=? AND entity='inventory_items' LIMIT 1r storage_key content_typeuploadsinlinezprivate, no-store, max-age=0)Content-Dispositionrc media_typerf) rrr rgvaluesrrris_filer) rarrrr allowed_idsr<rrrs r>public_quote_imager0s@  t *$AB BBC%%H[B\Bb`bAjAjAlQAlpxpxzOqP4TXX34Al Q  +$AB B LLQR_bo`pQq ss{s{s} $AB B & 5H   I k )F >>  C =>> ,V^pN@O PPQ s%A D!D1DAD!D!! D/z/quote/{token})response_classc[U5S:a [SS5e[5n[X5nSSS5 [ WU5$!,(df  N=f)NrEstimate link unavailable.)rr rrr)rarrs r> public_quoterDsF 5z#~C <==  t *  a && s A Az/quote/{token}/acceptc# [U5S:a [SS5eUR5IShvN n[UR SS55R 5SSn[UR SS55R 5S;nU(aU(d*[5n[XP5nSSS5 [WUSS S 9$0n[S S 9n[XP5nU(d[SU5sSSS5 $UR S 5(a?US [R"5R5:a[X`S5sSSS5 $UR S5S;a[X`S5sSSS5 $UR S5(dUR S5S:Xa[X`SS 5sSSS5 $USoSn SUS3S.n [USX[SSSU3[5[5S95 [!USX5n [#XXU 5n U (a[%['XXXU 55n O [)XXX5n [+XXXU 5 [-XZUSSXSSUS U R SS5S!35 [/XX5nXR S"5=(d) UR S#5=(d UR S$5USUS%UR S&5=(d SUS'U R SS5U[1U5XS(. n[XP5nSSS5 UR S)5(aS*USS+US,3nUS,S-USS.US/S0US1S2US3S4- S5S6US7S8US9S:3n[3US;US)UUS<9 [S S 9n[-USS=S.US>S?SUS@US)5 SSS5 [WUSCS 5$GN!,(df  GN=f!,(df  N=f!,(df  NB=f![4aXn[S S 9n[-USS=S.US>SASUS@[U5SSB5 SSS5 SnAM!,(df  SnAN=fSnAff=f7f)DNrrrrrVagree)yesontruerFz=Enter your name and check the agreement box before accepting.r_r[Trrrr~rz2This estimate is no longer available for approval.rrrrrz (customer))rrr*zOnline approvalzAccepted online by )r~approval_method approval_note accepted_atrz!Customer accepted estimate onlineryz accepted by z; job z ready to schedulerFr>rrrr0) rtoryr|propertytotaljob_code accepted_byrTr estimate_idr Estimate u accepted — r|z accepted estimate z online. Accepted by: rz Property: rz Estimate total: $rrnroz Job created/updated: rz Open the CRM: rTz/#jobsrrRzCRM automationrz%Sent estimate acceptance notificationrz Estimate acceptance email failediu>Estimate accepted. Thank you — the office has been notified.)rr rrYrgrlowerrrrrrrr#r8r!r$job_for_estimate_lineager*sync_job_from_estimatecreate_job_from_estimatesync_final_invoicer%r;r`rrX)rarrrragreedrrnotifyrractorrexistingjobrrTrUr{s r>public_quote_acceptrMs 5z#~C <==||~ Ddhhvb)*0024C8M txx# $ * * ,0G GF  TT"4.A!!E*ivyzz F $4 t *%d51  55  1\?TZZ\5K5K5M#M%a.z{  55?1 1%a.bc  55' ( (AEE(OZ,G%a.XY]^  m D'c=/ =>tKJO`rEFSETpUbebg}@}B)C D 4 C ,)$37 0#HMNC(#P=QRGJ'((;F6N;KKdeklyezd{|HIOPZI[H\\opvw~p@CpCDHoII`aghras`ttFGMNVGWFXX^_D  +VD\'W[ \$4d-=>ve}MtvABHIVBWX^_cXde a&fgk llU T :  b$4d-=>ve}Mop{}CDQ}RSVWZS[\`]`Sab  bs/QN8A4Q& N;2QO / Q9A O  Q O . Q87O / Q9EO  Q+AO/O"O/*Q; O Q OQ O,(O/+Q,O// Q9 Q 'P7)Q 1Q7 Q Q Q Q  QQz/api/b/{bid}/datac [5n[R"X!U5nUS;a[O1Skn[ U5Vs0sHoU[ X%U5_M nnUS:XaUSHnUR SS5 M US:wa-URSU45Vs/sHn[U5PM snO/US'URSU45Vs/sHn[U5PM snUS 'US Vs/sHn[U5PM n nU Vs1sHoS iM n nURS 5H'n U S U ;dMU R[U S S 95 M) XS'US:wa0URSU45Vs/sHn[U5PM snUS'SSS5 U$s snfs snfs snfs snfs snfs snf!,(df  W$=f)N)rmanager>r/r0r1r2r4staffr/rzUSELECT * FROM audit WHERE business_id=? ORDER BY created_at DESC,rowid DESC LIMIT 100activityzSELECT u.id,u.name,u.email,u.active,u.phone,u.job_title,m.role FROM users u JOIN memberships m ON m.user_id=u.id WHERE m.business_id=? ORDER BY u.namerrzbSELECT id,name,email,active,phone,job_title FROM users WHERE is_super=1 AND active=1 ORDER BY nameplatform_adminrassignable_userszSELECT id,entity,entity_id,filename,content_type,size,category,created_at FROM attachments WHERE business_id=? ORDER BY created_at DESC attachments) rrrTABLESsortedr8r9rr8r) rrrrtablesr6rrr assignablersus r>all_datar~s  ^^Dc *!44v:u@FvOul4c22O =f~ d+&_cel_lT\\;RTWSY.Z[.ZDG.Z[rtz)-7Z[^Z`*bc*bAQ*bcv%+F^4^DG^ 4#-.:aD':.,, DEB$xx'!!$r/?"@AE$.!" =48LLBKMPLR5S#T5Sq475S#TF= !% & M!P [c4. #T% & Ms`5F4FAF4F,F4 F  F4+F%F4F*F45validate_linksrsD 4 K, Dk 6   +$XY Y ,r@c [S [5US.UD[5[5S.D6n[XU5 [ XUSUR S5-XS[ URSURSS5555 [U5$) N)rr)rrzCreated srrrGrVr) r8r r!r"r%rjrYrgr*)rr6rr=rr<s r> create_basicrsz O#OOOC 4c $C 5<<#44Ut9SRXY]YaYabijlYmInEop S>r@cUR5nURS5nU(a%U(aXS:Xa [SS5e[USXQ5 U$)Nreferred_by_customer_idr_z#A customer cannot refer themselves.r1)rrgr r$)rrrrr=refs r> customer_datarsH    D *+C 38$IJ JtK( Kr@z/api/b/{bid}/customersc [SS9n[R"X2US5 [USU[ X0U5U5sSSS5 $!,(df  g=f)NTrrr1)rrrrrrs r>customer_creaters= $4 tX.DSt1PQUV s 1A Az/api/b/{bid}/customers/{rid}c [SS9n[R"XCUS5 [USX5 [ USX[ X@X!55 [ XCUSSXR5 SSS5 SS0$!,(df  SS0$=f)NTrrr1zUpdated customerr)rrrr$r#rr%rrs r>customer_updater su $4 tX.tK0PtK dw(KL d.{3||L  ;  ;s AA-- A>z/api/b/{bid}/propertiesc[SS9n[R"X2US5 [USURU5 [ USXR 5U5sSSS5 $!,(df  g=f)NTrrr1r2)rrrr$rrrrs r>property_creater sP $4 tX.tKH[H[\_0`Dc2D2D2FtL s A A  A.z/api/b/{bid}/properties/{rid}c H[SS9n[R"XCUS5 [USX5nURUS:wa [ SS5e[ USXUR55 [XCUSSXR5 SSS5 S S0$!,(df  S S0$=f) NTrrr2rr_zproperty_updaters $4 tX. 4 S -   M 2 2$bc ctL););)=> d.|C N  ;  ; A:B B!cURSS1S9n[S0UD[R"UR5[R"UR 5S.D6$)Npricecostr) price_cents cost_centsr)rr8mcentsrrrr=s r> service_datarsI   WV$4  5D  [$ [1777==#9QWWW\\EZ [[r@z/api/b/{bid}/servicesc [SS9n[R"X2US5 [USU[ U5U5sSSS5 $!,(df  g=f)NTrrr))rrrrrrs r>service_creaters: $4 tX.DC W0EdK  0A Az/api/b/{bid}/services/{rid}c [SS9n[R"XCUS5 [USX5 [ USX[ U55 [ XCUSSXR5 SSS5 SS0$!,(df  SS0$=f)NTrrr)zUpdated servicer)rrrr$r#rr%rrs r>service_updaters $4 tX.tJs0OtJs|G'<=uTsSdeopsuAuA@B  ;  ; AA,, A=c  UR1SkS9n[S0UD[R"UR5[R"UR 5[ UR5[ UR5S.D6$)N>rr min_stockquantity_on_handr)rrr#r"r) rr8rrrrfloatr#r"rs r>inventory_datar%sm   $S  TD  f$ fAGGGMM$:qwww||G\!&w'?'?!@ERYRcRcLd ffr@z/api/b/{bid}/inventoryc [SS9n[R"X2US5 [USU[ U5U5sSSS5 $!,(df  g=f)NTrrr-)rrrrr%rs r>inventory_creater's; $4 tX.D!23~g7NtT rz/api/b/{bid}/inventory/{rid}c [SS9n[R"XCUS5 [USX5 [ USX[ U55 [ XCUSSXR5 SSS5 SS0$!,(df  SS0$=f)NTrrr-zUpdated inventory itemr)rrrr$r#r%r%rrs r>inventory_updater)sv $4 tX.t# UHn[UT5v M g7frB_json_contains_inventoryrvrs r>r+_json_contains_inventory..sUn+A|<# UHn[UT5v M g7frBr,r.s r>rr0sLe+A|<r-r-s\% 99^ $ 4UellnUUU%LeLLL r@c/SQn/nUHupVnURSUSUS3U45R5nUHKn X=(d Sn [R "U 5n [X5(dM9URU5 M~ M U$![Ra Mf=f![ [[R4a Mf=f)N))r*r$r})r/r$r)r(r$invoice)r.r$purchase order)r,r$ service call)estimate_revisions snapshot_jsonzestimate revisionz SELECT id,z FROM z WHERE business_id=?rV) rfetchallsqlite3OperationalErrorrr' TypeErrorrnJSONDecodeErrorr-r) rrrchecksusedr6columnr r7r<rawr=s r>_inventory_usagerFsF D &u <<*VHF5'AU VY\X^_hhjDC+#C zz#(22 E" !' K''    z4+?+?@  s#(B B*B'&B'*C  C c D/n[SS9n[R"XBUS5 [USX5n[ X@U5nU(a8SR USS5[ U5S:aSOS-n[S S US 35eURS USU45Vs/sHoS PM nnURSUSU45 [XBUSSXS5 URSX45 SSS5 UHn [S- U - RSS9 M SS0$s snf!,(df  N9=f)NTrrr-rz and other recordsrVrzz!This inventory item is used on a zB. Deactivate it instead so historical quotes and jobs stay intact.zTSELECT storage_key FROM attachments WHERE business_id=? AND entity=? AND entity_id=?rzHDELETE FROM attachments WHERE business_id=? AND entity=? AND entity_id=?zDeleted inventory itemrz8DELETE FROM inventory_items WHERE id=? AND business_id=?r missing_okr) rrrr$rFrrr rr%runlink) rrr storage_keysrr<rCkindsrr)s r>inventory_deleterN"sJL $4 tX.T+C4- IId2Ah'3t9q=+?VXYE'HPR&ST T26,, b "3 '3)*3)Q-(3) * _+C0 2 d45Fsv;W OQTPYZ  ) C ''4'8 ;* sBDD " lead_datarQ8s2  ['$$gY$7 [AGGGMMDZ [[r@z/api/b/{bid}/leadsc [SS9n[R"X2US5 [USU[ U5U5sSSS5 $!,(df  g=f)NTrrr')rrrrrQrs r> lead_createrS<s: $4 tX.DYw-?E rz/api/b/{bid}/leads/{rid}c [SS9n[R"XCUS5 [USX5 [ USX[ U55 [ XCUSSXR5 SSS5 SS0$!,(df  SS0$=f)NTrrr'z Updated leadr)rrrr$r#rQr%stagers r> lead_updaterVCsu $4 tX.tGC0LtGCIg$67t^\cdghuhu9v  ;  ;r z /api/b/{bid}/leads/{rid}/convertc[SS9n[R"X2US5 [USX5nUS(a[USUSU5sSSS5 $[ USU[ USUSUS US US S 9U5nUS (a[ US U[ USSUS SS9U5 [ USX[ USS95 [X2USSU5 SSS5 U$!,(df  W$=f)NTrrr'rr1rrrrr)rrrbilling_addressrr2rzPrimary propertyrV)rr rr)rzLinked lead to new customer)rrrr$rr8r#r%)rrrrleadr|s r> lead_convertrZKs $4 tX.VD5Q  ${4 +>sC d;s4T&\PTU\P]dhipdq O$w-4AAEG  ? l3tUgptu~pGI0JKO PtGCDXd^$DE d9'#F  O  OsACA9C C&c [XURUR5 URHnUR(a[ USURU5 UR (a[ USUR U5 UR(dMhUR (dM{[SS5e [R"U5n[R"URS55US'[SURURUR UR"UR$S.UD6$![an[S[U55eSnAff=f) Nr)r-r_zOAn estimate line can reference either a service or an inventory item, not both.rur$)rrrGrrr)rrrru service_idr$rr r calculaternrYrrr9r8rGrr)rrrrtotalsr{s r> estimate_datar_Zs4G//0C0CD  ?? 4 4??3 7    4)$*;*;C @ ???t000$uv v *{{7#FJJw$78F<  LG//G lead_archiverals $4 tX.F44P \cjcqcq^_wxy|y~@C^H I d>>OW^_bgmcno  ;  ;rc N[SS9n[R"X2US5 [USX5nUR SX45 [ X2USSUUR S5(aUSS 3OUS5 UR S X45 SSS5 S S0$!,(df  S S0$=f) NTrrr'zRDELETE FROM calendar_events WHERE business_id=? AND entity='leads' AND entity_id=?z Deleted leadrrz (converted customer preserved)z.DELETE FROM leads WHERE id=? AND business_id=?r)rrrr$rr%rgrrrrr<s r> lead_deleterdus $4 tX.F44P ` I   c.?Bww}?U?Us6{m: ;[^_e[f  EsiP  ;  ;s A=B B$z/api/b/{bid}/estimatesc[SS9n[R"X2US5 [X0U5n[ USU[ S0UD[ USUS5SS.D6U5sSSS5 $!,(df  g=f) NTrrr*ESTr)ryr~r)rrrr_rr8r&rs r>estimate_creatergs` $4 tX. 4G ,DS1w1w)DQ\]`afBgov1wx|} s A A!! A/z/api/b/{bid}/estimates/{rid}c [SS9n[R"XCUS5 [USX5nUSS:wa [ SS5e[ USX[ X@U55 [XCUS SXS 5 SSS5 S S0$!,(df  S S0$=f) NTrrr*r~rrzz=Sent estimates are locked. Create a revision to make changes.zUpdated estimateryr)rrrr$r r#r_r%rs r>estimate_updateris $4 tX.F4 C4T x=' !$cd dtK dw(GH d.{36{K  ;  ;s A%A;; B c @[SS9n[R"X2US5 [USX5nUSS:wa [ SS5eUR S X45R 5(a [ SS 5eUR S X45R 5(a [ SS 5eUR S X45R 5(a [ SS5eUR SX45 [X2USSXS5 SSS5 SS0$!,(df  SS0$=f)NTrrr*r~rrzzNOnly draft estimates can be permanently deleted. Void a sent estimate instead.zESELECT 1 FROM estimates WHERE business_id=? AND revision_of=? LIMIT 1z=This draft has a revision linked to it and cannot be deleted.z@SELECT 1 FROM jobs WHERE business_id=? AND estimate_id=? LIMIT 1z7This estimate is linked to a job and cannot be deleted.zDSELECT 1 FROM invoices WHERE business_id=? AND estimate_id=? LIMIT 1zestimate_deleterms $4 tX. 4 C , x=' !$tu u <<_ad`i j s s u u$cd d <<Z\_[d e n n p p$]^ ^ <<^`c_h i r r t t$bc c I3)T d4[[Q  ;  ;s C6D  Dz%/api/b/{bid}/estimates/{rid}/revisioncv[SS9n[R"X2US5 [USX5nUSS:Xa[ U5sSSS5 $UR SX45R 5S nUR5VVs0sHupgXg_M nnn[US [[5XU[R"U5[5S 95 [USX[SS S SS SSS 95 [X2USSUSUSUS35 [ [USX55sSSS5 $s snnf!,(df  g=f)zStart an in-place quote revision. The estimate keeps the same id/code so one project never becomes multiple operational estimates/jobs. A snapshot is stored for history, then the current estimate is reopened as a draft for editing. Trrr*r~rNzcSELECT COALESCE(MAX(revision_no),0)+1 FROM estimate_revisions WHERE business_id=? AND estimate_id=?rr;)rrr revision_nor<rrV)r~rrrpublic_token_hashpublic_token_issued_atrzStarted estimate revisionz Revision z of ry)rrrr$r*rrrur"r8r rrr!r#r%) rrrrrrev_nokr/snapshots r>estimate_revisionrusy $4 tX. 4 C , x=' !S>  ||BDGCLMVVXYZ[!$-#!!#-t(3cix|yCyCDLyMY\Y^*_ `tKGB]_lpDF^bx|)} ~ d7 C)TZS[[_`cdj`k_lHmn[9:  . s$9D* 7D*D$BD*$D** D8z#/api/b/{bid}/estimates/{rid}/statusc SS11SkS.n[SS9n[R"XSUS5 [USX5nURUR US [ 55;a [S S 5eS UR0nURS :XaUR=(d# URR5(aS OSnU(d [SS5eUS(a6US[R"5R5:a [SS5eURXR[5S9 [USXU5 URS :Xa:[USX5n [!XPU5n U (a[#XPXU 5n [%XPXU 5 ['XSUSUR-SXS5 SSS5 SS0$!,(df  SS0$=f)Nrr/>r/rr)rrTrrr*r~rzz)This estimate cannot move to that status.rzVerbal agreementr_z/Choose how the customer approved this estimate.rz@This estimate has expired. Issue a new revision before approval.)rrrrryr)rrrr$r~rgrr rrrrrrr#r!rrrr%) rrrr transitionsrrchangesreapproved existing_jobs r>estimate_statusr{s 0NOK $4 tX.F4 C4T >>Xsu!E E$OP P'..) >>: %**mWEZEZE`E`EbEb/AhlF#C(YZZ< S%6tzz|7M7M7O%O#C(jkk NN6@U@UbebgN htK0 >>: %DS5H1$3?L3DX<X "4H,G dK6{36{S' ( ;) ( ;s FF<< G c/nUn[5nU(ahXE;acURU5 URSX45R5nU(dU$UR US5 USnU(aXE;aMcU$)zBReturn this estimate and each ancestor revision, newest to oldest.zASELECT id,revision_of FROM estimates WHERE business_id=? AND id=?r revision_of)rrrrr)rrridscurrentrr<s r>estimate_lineage_idsrs C G D g)  LL\^a]j k t t v  J 3t9M" g) Jr@c[XU5nUH0nURSXU45R5nU(dM.Us $ g)NzZSELECT * FROM jobs WHERE business_id=? AND (estimate_id=? OR latest_estimate_id=?) LIMIT 1)rrr)rrrr~eidr<s r>rrs\Tk2C LLuwz@CwD E N N P 3J r@c[USUSU[USUSUSUSUSS95 [USUSU5n[XUSSUSUS S 35 U$) zMake the existing job's working scope match the latest approved quote. Scheduling, status, assignee, checklist progress, and notes stay untouched. Only customer/property/title plus the quoted item scope are refreshed. r/rrrrGr$)rrrGlatest_estimate_idr$zUpdated job scope from estimateryz refreshed job items)r#r8r$r%)rrrrr refresheds r>rrs  4s4yT & &'lt9|$ &T&T3/I $C9&TcRXk]ZnKop r@cU(a*URSX45R5nU(aU$[XU5H/nURSX45R5nU(dM-Us $ g)NzkSELECT * FROM invoices WHERE business_id=? AND job_id=? AND status!='void' ORDER BY created_at DESC LIMIT 1zpSELECT * FROM invoices WHERE business_id=? AND estimate_id=? AND status!='void' ORDER BY created_at DESC LIMIT 1)rrr)rrrjob_idr<rs r>invoice_for_estimate_lineager s LLGILHT U ^ ^ ` J#D[9 LLLNQMV W ` ` b 3J: r@c [R"US5VVVs/sH0nUR5VVs0sHup#US;dM X#_M snnPM2 snnn$s snnfs snnnf)Nr$)unit_cost_centsrr\r)rr'ru)rrrsr/s r>invoice_items_from_estimaters[ 3|#45 75!JJL rLSQA5q,qSQSL r5 77 r 7sA  AA A A c 6U=(d [XUS5n[XUSU(aUSOS5nU(dgURSXS45R5SnUSU:a [ SS5e[ USU(aUSOUS US [ R"[U55US US US USS9nUbXXS'[USUSX5 [XUSSUSUSSUSS- S35 [[USUSU55$)zSUpdate the one active final invoice for this estimate/revision chain, if it exists.rN{SELECT COALESCE(SUM(amount_cents),0) FROM transactions WHERE business_id=? AND invoice_id=? AND kind='payment' AND voided=0rr0rzzThis revision would make the final invoice lower than payments already recorded. Adjust the revision or correct the payment first.rrrGsubtotal_centsdiscount_cents tax_cents)rrrGr$rrrr0due_dater(z#Updated final invoice from revisionryz updated the final invoice to rnz.2f) rrrrr r8rrrr#r%r*r$) rrrrrrrr2rs r>rrs =)$3t9=C &tD s#d)PT UC  TVY^bZcUd e n n pqr sD =D C!ef f  &s4yS]'l::9#>?+,+,k" & F#z 4 3t9S0 $C=jTVYZ`VaUbcABEFSBTUXBXY\A]T^_ VDCIc: ;;r@c[XUS5nU(a[[XX#U55$[XUS5nU(aUSOUSnSVs/sH n[ USS9PM nn[ USU[ USUSXbSUS [ USUS 5S US [R"U5S 9 U5n U(a?URSSRSU55-S-U S[5U/UQ75OS U(aGSSRSU55-S-n URSU -S-U S[5X/UQ75 U $s snf)Nr)zConfirm access and measurementszPrepare materialszComplete installationzTest with customerzUpload completion photosF)rUdoner/rrrGJOBryr$) rrrrrGryr~r$r%zRUPDATE invoices SET job_id=?,updated_at=? WHERE business_id=? AND estimate_id IN (rMc3&# UHnSv M g7frrrs r>r+create_job_from_estimate..<s oE}Dwxor}Dr)z@SELECT id FROM invoices WHERE business_id=? AND estimate_id IN (c3&# UHnSv M g7frrrs r>rr?sUkcj^_VYcjrzUUPDATE transactions SET job_id=?,updated_at=? WHERE business_id=? AND invoice_id IN () rr*rrr8rr&rrrrr!) rrrrrlineageroot_idt checklistrrs r>rr3s #d)4C /#FGG #d) 4G"GBKD G1pq1p1t&1pIqT&Tc-6HUXYfUgt{TXPY'l $vc% @ ^abn^o@D@J@JKT@U&VW[ \C5< LLefifnfnoE}DoEgEEFIId)CE#/w/1AE LSXXUkcjUkMk klo o lmnnorr$ic7w7 9 JqsE z,/api/b/{bid}/estimates/{rid}/approve-and-jobc[SS9n[R"XCUS5 [USX5n[ X@U5nUSS;a)U(aO!USS:Xa [ SS 5e[ SS 5eUR S 5=(d S nU(d-USS :wa$U(aU[5SS:a [ SS5eUR=(d S R5nUR=(d S R5n U(d9UR S5=(d S R5(d [ SS5eS U=(d UR SS 5U =(d UR SS 5UR S5=(d [5S.n [USXU 5 [USX5nU(aq[X@XSU5n[U5n [X@XSU5n [XCUSSUSU R SU R SS 55S35 [U5XSS.sSSS5 $[!X@XS5n [X@XSU 5n [U5XS S.sSSS5 $!["an [ X@U5nU(av[X@XSU5n[U5n [X@XSU5n [XCUSSUSU R SU R SS 55S35 [U5XSS.sSn A sSSS5 $U eSn A ff=f!,(df  g=f)!NTrrr*r~)rrrrzz/Mark this estimate as sent before approving it.z7This estimate cannot be approved in its current status.rrVrrxzAThis estimate has expired. Create a revision before approving it.rr_z8Choose an approval method before approving the estimate.rr)r~rrrapprove_and_job_reusedr}zReused existing job ryrz while approving estimate.)r}rr8reused_existing_jobapprove_and_job_recoveredzRecovered existing job z$ after duplicate conversion attempt.F)rrrr$rr rgr!rrrr#rr*rr%rrX)rrrrrrrexpiresrenoterrr8r{s r>approve_and_jobrEs $4 tX. 4 C ,*$37 x= 3 3X'#C(YZZ#C(abb %+CM:5'gPSPUVYWYPZFZ$gh h''-2446##)r 0 0 2sww'89?RFFHH$^_ _ $E0A"(E ?CGGOB$?''-09CE   tK/ 4 C , +DShGH(#C&tBG $C 8C(R8H)I(JJde g(~C`deU X (#;C#4CS9$S>\aby \ .ds;H/(Kh'*4CXFd$? 3/swwtB?O0P/QQuvx#,S>dhiiq rI ] sCHK=/ I ;K= K:*A:K5$K:%K=3K55K::K== L z /api/b/{bid}/estimates/{rid}/jobc[SS9n[R"X2US5 [USX5nUSS:wa [ SS5e[ X0XB5sSSS5 $!,(df  g=f) NTrrr*r~rr_z/Record customer approval before creating a job.)rrrr$r rrls r> estimate_jobrsV $4 tX.F4 C4T x=* $$UV V': s AA A(c[XURUR5 UR(a<UR SXR45R 5(d [ SS5eURS:XaUR(d [ SS5eURS:XaUR(d [ SS5eUR(aUR(d [ SS5eUR(a7UR(a&URUR::a [ SS5eUR(a7UR(a&URUR:a [ SS 5eURS 1S 9n[R"URVs/sHoDR5PM sn5US 'U$s snf) Nrr_-Assign this job to a member of this business. scheduledz0Choose an installation date for a scheduled job.z(Choose a start time for a scheduled job.z/Choose a start time before setting an end time.*The end time must be after the start time.z4The due date cannot be before the installation date.rrr%)rrrassigned_user_idrrr r~scheduled_datescheduled_timescheduled_end_timerrrrr)rrrr=cs r>job_datars4G//0C0CD 5rtwyQyQtR)S)\)\)^)^C OPP~~{"7+A+AC RSS~~{"7+A+AC JKK!!'*@*@C QRR'"<"<A[A[_f_u_uAuC LMMG22w7G7GH^H^7^C VWW     2D::w?P?P&Q?P!||~?P&QRD  K'Rs5Gz/api/b/{bid}/jobsc[SS9n[R"X2US5 [USU[ S0[ X0U5DS[ USUS50D6U5sSSS5 $!,(df  g=f)NTrrr/ryrr)rrrrr8rr&rs r> job_creatersZ $4 tX.DD,t8DW3M,tS\]abhilmrSs,tuyz  A A A,z/api/b/{bid}/jobs/{rid}c z[SS9n[R"XCUS5 [USX5nUS(a2URUS:wdUR US:wa [ SS 5e[USX[X@U55 [XCUS SXR5 SSS5 S S0$!,(df  S S0$=f) NTrrr/rrrr_z job_updaters $4 tX.F4s4O } 7#6#6M8J#JgNaNacfgtcuNu$bc ctF38DW#=>dPSTabhilm{m{@|  ;  ;s BB)) B:z /api/b/{bid}/jobs/{rid}/schedulec r[SS9n[R"XCUS5 [USX5nUR(d [ SS5eUR (d [ SS5eUR(a&URUR ::a [ SS5eUR(a<URS XR45R5(d [ SS 5e[S URUR URURURS 9nURS 5(dURUS '[USXU5 [XCUSSXRSUR 35 [![USX55sSSS5 $!,(df  g=f)NTrrr/r_zChoose an installation date.zChoose a start time.rrrr)r~rrrrrrz Scheduled jobrl)rrrr$rr rrrrrr8rrgr#r%r*)rrrrrrrs r> job_schedulers $4 tX.F4s4O%%$BC C%%$:; ;  % %'*D*DH^H^*^$PQ Q  # #DLL9vx{}U}UxV-W-`-`-b-b$ST T;g6L6L\c\r\r'.'A'ASZSkSkryrrAwwz""&55F: tF36* dOF3:P:P9QQRSZSiSiRj7klVC45! s FF(( F6z"/api/b/{bid}/jobs/{rid}/unschedulec [SS9n[R"X2US5 [USX5nUR S5=(d Sn[ SSSSS9nUR S 5(aUR S 5U:XaSUS '[ USXU5 [X2US SXS 5 [[USX55sSSS5 $!,(df  g=f) NTrrr/rrVry)r~rrrrzRemoved job from calendarry) rrrr$rgr8r#r%r*)rrrrrold_daters r>job_unschedulers $4 tX.F4s4O)*0b:Rr]_` 77:  377:#6#@!F: tF36* d7sv;OVC45 s B1C Cc v[SS9n[R"X2US5 [USX5nUSS;a [ SS5e/S QnUHCupgnUR S US US 3X45R 5(dM5[ SS US35e UR SX45R 5(a [ SS5eUR SX45R 5(a [ SS5e[X2USSXS5 UR SX45 SSS5 SS0$!,(df  SS0$=f)NTrrr/r~) in_progress completedrzzfIn-progress and completed jobs are part of service history and cannot be deleted. Cancel them instead.))r(rr8)r+rzpayment or expense)r3rwarranty)r.related_job_idr9)r,rr:zSELECT 1 FROM z WHERE business_id=? AND z =? LIMIT 1zThis job is linked to a z and cannot be deleted.zWSELECT 1 FROM attachments WHERE business_id=? AND entity='jobs' AND entity_id=? LIMIT 1zTThis job has uploaded files. Remove or retain the job so those records are not lost.zQSELECT 1 FROM tasks WHERE business_id=? AND entity='jobs' AND entity_id=? LIMIT 1z0This job has linked tasks and cannot be deleted.z Deleted jobryz-DELETE FROM jobs WHERE id=? AND business_id=?rrk) rrrrr<blockersr6rD label_names r> job_deletersc $4 tX.F4s4O x=7 7%MN N (0 #E||nUG3LVHT^_ad`ijssuu#C*B:,Ne(fgg(0 <<qsvr{ | F F H H$z{ { <<kmplu v   B B$VW W dM&[A DcYO' ( ;) ( ;sA2D'BD'' D8z /api/b/{bid}/jobs/{rid}/progressc [SS9n[R"XCU5 [USX5nURS:Xa,US(aUR S5(d [ SS5e[USX[URUR[R"URVs/sHofR5PM sn5S 95 [XCUS SXR5 SSS5 S S0$s snf!,(df  S S0$=f) NTrr/rrrr_z8A manager must set the installation date and time first.)r~rr%zUpdated job progressr)rrrr$r~rgr r#r8rrrrrr%)rrrrrrrs r> job_progressrs  $4 t%6$vc+Fs >>; &4D0ESWWUeMfMf$^_ _tF34w~~GMMaeakakFMFWFWmXFWABmymym{FWmXbY$Z [ d26#nnM  ;mX  ;sB"C<,C7&C<7C<< D z/api/b/{bid}/invoicesc[SS9n[R"X2US5 [USURU5nUSS:wa [ SS5e[ X0US 5n[X0US U(aUS OS5nU(a2[X0XBXQRS 9nU=(d [U5sSSS5 $[US U[US U(aUS OSUS [US US 5USS[R"[!U55USUSUSUSURS9 U5sSSS5 $!,(df  g=f)NTrrr*r~rr_z5Invoices can only be created from approved estimates.r)rr(rINVrGopenrrrr0) rrrryrGr~r$rrrr0r)rrrr$rr rrrrr*rr8r&rrr)rrrrrrrupdateds r>invoice_creatersD $4 tX.F4 GL_L_`c4d x=* $$[\ \ $Tc$i 8-ds4ycTW[\ &tFVFVWG1i1 DC]AShk[^_c[dquD yjU'KRUV]R^flzz"=c"BCSVWgShx{}MyN+&3}3EwO_O_1abfg sB D24A4D22 Ez /api/b/{bid}/invoices/{rid}/voidc j[SS9n[R"XCUS5 [USX5 UR SX45R 5SnU(a [ SS5e[USX[S S 95 [XCUS SXR5 SSS5 S S0$!,(df  S S0$=f) NTrrr(zhSELECT COALESCE(SUM(amount_cents),0) FROM transactions WHERE business_id=? AND invoice_id=? AND voided=0rr_zSA paid invoice cannot be voided. Refund processing is not included in this release.r/)r~zVoided invoicer) rrrr$rrr r#r8r%reason)rrrrrr-s r> invoice_voidr s $4 tX.tJs0O||GILHQR[[]^_` $yz ztJst6':;U4SQablmpqq>A  ;  ;s B B!! B2z/api/b/{bid}/transactionsc[SS9n[R"X2US5 URS1S9nUR(d [ SS5eUR[R "5R5:a [ SS5eUR(a[US URU5 URS :XaUR(d [ SS 5e[US URU5nURS XR45R5SnUSS:Xd*[R"UR 5USU- :a [ SS5eUSUS'OUR(a [ SS5e[#USU[%S0UDS[R"UR 50D6U5sSSS5 $!,(df  g=f)NTrrr-rr_zEnter the transaction date.zIRecord payments and expenses when they occur, not as future transactions.r/paymentz#Select an invoice for this payment.r(rrr~r/r0z;Payment exceeds the invoice balance or the invoice is void.rz/Expenses attach to jobs, not customer invoices.r+ amount_centsr)rrrrrr rrrr$kindr,rrrrr-rr8)rrrrr=r8r2s r>transaction_creaters $4 tX.     3||$AB B << ..0 0$op p >> 4w~~c 2 << "%%#C(MNN4 7+=+=cBG^`cdvdv_wxAACDEFDx &(AGGGNN,CGMDZ[_D_,_#C(eff"8,DN!!#C(YZZDD4e44eQWWU\UcUcMd4efjk) s F=G Gz$/api/b/{bid}/transactions/{rid}/voidc >[SS9n[R"XCUS5 [USX5nUS(a [ SS5e[ USX[ SURS 95 [XCUS SXR5 SSS5 S S0$!,(df  S S0$=f) NTrrr+voidedrzz#This entry has already been voided.r)r void_reasonzVoided ledger entryr) rrrr$r r#r8rr%rs r>transaction_voidr-s $4 tX.F4s4W x=$IJ JtN34qW^^+TU d1.^^T  ;  ;s A5B  Bc U(dgURSU45R5nU(a US(d [SS5eUS(d3URSX45R5(d [SS5egg)Nz,SELECT is_super,active FROM users WHERE id=?rr_zAssigned user is not active.rrz3Assigned user does not have access to this company.r)rrrr<s r>_validate_user_for_businessr8s F CWJOXXZC c(mC >?? z?4<<0morn{#|$F$F$H$HC UVV$H?r@z/api/b/{bid}/tasksc[SS9n[R"X2US5 [X0UR5 [ USXR 5U5sSSS5 $!,(df  g=f)NTrrr0)rrrrrrrrs r> task_createrAsM $4 tX.0KDU\UmUm0nD-?-?-A$G rz/api/b/{bid}/tasks/{rid}c 6[SS9n[R"XCUS5 [USX5 [ X@UR 5 [ USXUR55 [XCUSSXR5 SSS5 SS0$!,(df  SS0$=f)NTrrr0z Updated taskr) rrrr$rrr#rr%rGrs r> task_updaterHs $4 tX.tGC0LNijnsztLtLOMtGCG$6$6$8953~^efijwjw;x  ;  ;s A1B Bc [SS9n[R"X2US5 [USX5n[ X2USSXS5 UR SX45 SSS5 SS0$!,(df  SS0$=f) NTrrr0z Deleted taskrGz.DELETE FROM tasks WHERE id=? AND business_id=?rrrrr$r%rrcs r> task_deleterPs $4 tX.F44PRWX\beftu|~AFMBNSOQUQ]Q]^NPSOXQY  ;  ; A A!! A2r'r1r*r,r0r/)r'r1r*r,r0r/cbUR(d [SS5eUR(a7UR(a&URUR::a [SS5e[ XUR 5 UR =(d SR5nUR=(d SR5n[U5[U5:wa [SS5eU(a4[RU5nU(d [SS5e[XXA5 UR5$)Nr_zChoose a calendar date.rrVzBChoose both a related record type and record, or leave both blank.z2That record type cannot be linked to the calendar.) event_dater end_time start_timerrentityr entity_idr;CALENDAR_LINK_TABLESrgr$r)rrrrrr6s r>_calendar_event_datar\s   C 9::G..73C3CwGYGY3YC LMM)A)AB NN b ' ' )F  &B--/I F|tI&C dee "&&v.$XY Yt)(    r@z/api/b/{bid}/calendar-eventsc[SS9n[R"X2US5 [X0U5n[ USXU5sSSS5 $!,(df  g=f)NTrrr4)rrrrrrs r>calendar_event_createrms@ $4 tX. !$7 3D!23DA s 2A Az"/api/b/{bid}/calendar-events/{rid}c [SS9n[R"XCUS5 [USX5 [ X@U5n[ USXU5 [ XCUSSXR5 SSS5 SS0$!,(df  SS0$=f)NTrrr4zUpdated calendar itemr)rrrr$rr#r%rG)rrrrrr=s r>calendar_event_updaterts $4 tX.tcalendar_event_deleter|sx $4 tX.F4@QRU4Z d34Ecg,W OQTPYZ  ;  ;rz/api/b/{bid}/warrantiescF[SS9n[R"X2US5 [X0URUR 5 UR (a[USUR U5 [USXR5U5sSSS5 $!,(df  g=f)NTrrr/r3) rrrrrrrr$rrrs r>warranty_creatersl $4 tX.tH[H[\c\o\o0p >>6$vgnnSADc2D2D2FtL s A>B B z/api/b/{bid}/warranties/{rid}c L[SS9n[R"XCUS5 [USX5 [ X@UR UR 5 [USXUR55 [XCUSSXR5 SSS5 SS0$!,(df  SS0$=f)NTrrr3zUpdated warrantyr) rrrr$rrrr#rr% item_namers r>warranty_updaters $4 tX.tL0QSabfkrk~k~@G@S@STTtL););)=>dPSTfgstwyJyJAK  ;  ;s A_po_datars? Eqh  WWT^^ $3t}}T/A+BddNH Tt'8'8TEUEU_bcgcpcp_qCGY Z  C ))7K]K]ovpHpHW^WlWl|C|R|R^b^h^hin^oGbjbnu|uBuB CCr@z/api/b/{bid}/purchase-ordersc [SS9n[R"X2US5 UR(a[ USURU5 [ U5n[ USUS5US'[USXU5sSSS5 $!,(df  g=f)NTrrr/r.POry)rrrrr$rr&rrs r> po_createrso $4 tX.  ! !6$vg6L6LS#Q g Yt po_updaters $4 tX.F4@QRU4Zaijqar\`t%cd3U4SIabstw}CyD6E  ;  ;s AA'' A8c/nSnURHn[R"UR5n[R"UR5n[ UR U-5obU- nUR[URURUR[UR 5URXEU[ UR U-5S9 5 M [ U[R"UR5-S- 5n[S0SUR_SUR _SUR"_SUR$_SUR&_S UR(_S UR*_S UR,_S UR._S UR0_SUR2_S[ UR45_S[6R8"U5_SU_SU_SX'-_SUR:_6$)Nr) r\rrjrkrmunit_price_centsrr0rrrrr warranty_idrGr~issue diagnosisrrrbillabler$rrr0rr)rurr unit_pricerrmrkrr8r\rrjrYrm tax_percentrrrrrGr~rrrrrrrrr)rrurrrrrrs r> _service_datar s Eqh ggdoo&QWWT^^-DCPTP]P]^cPcLdepufufn TT__$BSBS`d`p`pz}CLL{MSWS\S\nsUZfijnjwjwx|j|f}~  HQWWW001 1% 78C  fG// fGservice_call_creaters $4 tX.tH[H[\c\o\o0psNOSX_XpXpsq 7 #[[i_UXY^6_ko[%pD$? s BB B%z /api/b/{bid}/service-calls/{rid}c "[SS9n[R"XCUS5 [USX5n[ X@UR 5 [ U5n[USXU5 [XCUSSXS5 SSS5 SS0$!,(df  SS0$=f)NTrrr,zUpdated service callryr) rrrr$rrr r#r%rs r>service_call_updaters $4 tX.F4PS4XZuvz@G@X@X[Y 7 #VD%NPUVZ`cdz|KLOTZP[Q\  ;  ;s A'A== Bz(/api/b/{bid}/service-calls/{rid}/invoicec [SS9n[R"X2US5 [USX5nUS(a#[ [USUSU55sSSS5 $US(d [ SS 5e[ 5n[US US 5n[S10S U_S U_SUS_SUS_SU_SSUS-_SS_SUS_SUS_SS_SS_SUS_SUS_SS_SS_SS_SS US-_S!S"_S#S_S$S%_S&S"_S'[5_S([5_S)[5_6n[US U5 [ 5n[S10S U_S U_SUS_S*US*_S+U_S[USUS,5_SSUS-_SS-_SUS_SUS_SS_SUS_SUS_S.S"_S([5_S)[5_6n [USU 5 URS/U[5X45 [X2US0SXS5 SSS5 [ W 5$!,(df  N=f)2NTrrr,r,r(rr_z>Mark this service call as billable before creating an invoice.r*rfrrrrryrGz Service - r~rr$rrrtax_bpsrr0r deposit_bps deposit_centsrzGenerated from rrVr}rzService invoicerrrrrrrrrzOUPDATE service_calls SET invoice_id=?,updated_at=? WHERE id=? AND business_id=?zCreated service invoicer) rrrr$r*r r r&r8r!r"rr%) rrrrsvcest_idest_coderinv_idrs r>service_invoicers8 $4 tX.F4PS4X | VDC 4EcJK :$de euyk#eDh  VF Vs Vs=7I VVYZgVh Vnv V~JKNOVKW~W V_i VuxyEuF VVYZjVk V{| VEF VQTU`Qa Vnqrn@ VLM VZ[ Vjk VrCDGHNDOrO V[] Vjn VP V_a Vnqns VBD VPSPU VtK$u$T&TSTSEWT_bck_lTyTFOPTU_`cdiFjTq}~ABI~JqJTRXTdghtduTEHIYEZTjkTvyzEvFTSVWdSeToqT}@}BTNQNSTctJs#T\\3DFLMPMRSVE[&\^cdhnqrKL[\_dj`k^l  S> sA G%E5G%% G3z/api/b/{bid}/duplicatesrrrrc [5n[R"XaU5 /nURSU45GH/n/n U(a@US(a6UR 5USR 5:XaU R S5 U(arUS(ahSR [[RU55SR [[RUS55:XaU R S5 U(a@US(a6UR 5USR 5:XaU R S5 U (dGMUR [XS 95 GM2 USS sSSS5 $!,(df  g=f) NzMSELECT id,name,email,phone,billing_address FROM customers WHERE business_id=?rz same emailrrVz same phonerXz same address)reasons) rrrrrrrfilterrYisdigitr8) rrrrrrroutrscores r> duplicatesr!s-  t% morntuAE7 qz7G7G7I(I5<attachment_accessr%s9 _$C >??NN4S^-CP 4sr@z!/api/b/{bid}/files/{entity}/{rid}rc[5n[XCXU5 URSXU45Vs/sHn[U5PM snsSSS5 $s snf!,(df  g=f)NzSELECT id,filename,content_type,size,category,created_at FROM attachments WHERE business_id=? AND entity=? AND entity_id=? ORDER BY created_at DESC)rr%rr8)rrrrrrs r>rrss $Cs3!%/DFIQTEU"VW"VAQ"VW W s$AAAA A#.Otherfilecategoryc# [5n[XcXU5 SSS5 URS5IShvN nUR5IShvN [ U5S:a [ SS5eSnUR S5(aSnO[R"[R"U55n U RU R-S:a [ S S 5eS S S S.RU RS5nU R5 SSS5 U(d [ S S5e[)5n [+UR,=(d SR/SS55R0SSn SR3SU 55=(d Sn [4S- U - n [SS9n[XcXU5 U R7U5 U R9S5 [;[)5XX+U[ U5XSS=(d S[=5S9 n [?USU 5 [AXcUSXU 5 SSS5 W S U S!.$!,(df  GN"=fGNGN!,(df  GNF=f![ ["[$[R&4a [ S S5ef=f!,(df  Nt=f![Ba U RESS9 ef=f7f)"Niir^zFiles must be 8 MB or smaller.rVs%PDF-zapplication/pdfi@x}r_zImage dimensions are too large.z image/pngz image/jpegz image/webp)PNGJPEGWEBPz'Upload a valid PNG, JPEG, WebP, or PDF.z0Only PNG, JPEG, WebP, and PDF files are allowed.r\rWc3X# UH n[U5S:dMUS;dMUv M" g7f)rz N)ord)rchs r>rupload.. s%O(Bc"grkRb>NRR(s ** *rTriPr') rrrrfilenamerrvrr)rrzUploaded attachmentrIr)rr5)#rr%r#closerr rprrioBytesIOwidthheightrgformatrrOSErrorrnDecompressionBombErrorr rr5rzrrr write_byteschmodr8r!r"r% BaseExceptionrK)rrrrr(r)rcontentrimr)r5rr=s r>uploadrCs $Cs3 ))M* *G **, 7|KC @AAL(##&  OBJJw/0B88BII%h.',MNN$/|<X\\]_]f]fgij  1 C RSS C 4==0L99$sC D I I$3 OH WWO(O O _S_H I c !F  d^t d3 7   w ' LL 3sjv|AH}IVYlomocpc{t{GJGLMD 4 d +U4SAVW]bj-k dx 00E  *10 'wz%:V:VW O$MN N O^   & s KH6KIKI :K *I 5AII BK J%&BJ&J%.K6 I K K II KI 1JK J"J%!K"J%%KKz/api/b/{bid}/attachment/{rid}c 4[5n[R"X2U5 [USX5n[ X2XSUS5 SSS5 [ S- WS- nUR 5(d [SS5e[USUS S 9$!,(df  NL=f) NrrrrrrAttachment file is unavailable.zapplication/octet-streamr5)rr5 rrrr$r%rrr rrrrrr<rs r>downloadrHs  t% 4 c .$CH c+6FG  I c-0 0F >>  C ABB *DcR\o ^^ s 8B  Bz"/api/b/{bid}/attachment/{rid}/viewc 6[5n[R"X2U5 [USX5n[ X2XSUS5 SSS5 [ S- WS- nUR 5(d [SS5e[XTSS S 0S 9$!,(df  NM=f) NrrrrrrrErrrrrFrGs r>view_attachmentrJ(s  t%6$}S+MsO`aekns{o|~ABM~NPO  I c-0 0F >>  =5V#WW n*=G\]eFf gg s 8B  Bz/api/b/{bid}/exportc [SS9n[R"X!US5 [[5Vs0sHo3[ X#U5_M nn[ URSU45R55US'[5US'URSU45Vs/sHn[ U5PM snUS'URS U45VVs/sHnS Vs0sHofXV_M snPM snnUS '[X!US S U5 SSS5 [[R"WSS9SSSUSSS30S9$s snfs snfs snfs snnf!,(df  NJ=f)NTrrr:r exported_atz'SELECT * FROM audit WHERE business_id=?rz-SELECT * FROM attachments WHERE business_id=?)rrrr5rrvrattachment_metadatazExported business recordsr)indentzapplication/jsonrzattachment; filename="business-z -export.json"r)rrrrrr8r8rrr!r%r rr)rrrr6r=rrss r>export_businessrQ1s $4 tW->DVn MnULC00n Mdll+PRUQWXaacdZE]+/<<8acfbh+ij+ia$q'+ijZKOKWKWXGILHNKO%PKOFG6&A6f6&AKO%P "# d7 SI  DJJt1-9KUjnMNQRTSTNUMVVcldUe ff Nk&A%P sM*ED0 AED50E D?D:$D?+E0 E:D??E Ez/staticstatic) directory)rrWc,[[S- S- 5$)NrRz index.html)rrrr@r>indexrUAs X l2 33r@)rVFrrB)NN)rVrVrVrV)r7rrcrhrr> contextlibrdatetimerpathlibrtypingr urllib.parserfastapirr r r r r rfastapi.responsesrrrfastapi.staticfilesr starlette.middleware.trustedhostrPILrremail_securityrr quote_pdfrrVrrrrrrrr r!r"r#r$r%r&r8 current_userUser FINANCIALrr$r?rDrirCadd_middlewarer] middlewarerxexception_handlerIntegrityErrorr|rgrrpostSetuprLoginrrrPasswordChangerputProfilerrBusinessCreaterpatchrYActiverrAdminUserCreaterAdminAssignmentsr r rrBusinessrrMemberrrRoler deleter"r*r8r;rL EmailSettingsrP EmailTestrZr`rgr QuoteEmailrrrrrrrrrrCustomerrr Propertyr rrServicerrr% InventoryItemr'r)r-rFrNrQLeadrSrVrZr_rardrrgrirmruEstimateStatusr{rrrrrrrEstimateApprovalrrrJobrr JobSchedulerrr JobProgressrInvoicerVoidr TransactionrrrTaskrrrr CalendarEventrrrrWarrantyrr PurchaseOrderrrr ServiceCallr rrrr!r%rrCrHrJrQmountrUrr@r>rs  *!XXXFF+B-8)bbbbwt00112 z  v  .(&(ii&?3&F{D\`13>1Jc1Q-W[]( BUVv8w8}8}B9CD6w--.v/v  AA 6QWW66& J177JWJJJUTUU Gxt  [a&& [d [  [AIIT !=T="= !" 0Q-- 0T 0# 0 /0qxxt1  d   cq00ccc* -.3););4/0 *+ S 188 4 ,  () +C +d +* + tDt t  !QZZT" cScdcc VVQXXV4VV U $% # # aff $ &  %&CCT'  &'  3  D  (   &'3qD(" ,- C   . G6s6s6e ./SsSsS1<<SSTS0S@#L#6L /0PSPsP1P& 6's'7' !>-mC-m-m?-m` $.Z "#WWAJJWDW$W  '(AJJD) #$MMAJJMDM%M  ()AJJD*\  !"LsL199L$L#L  &'ss199$(f  "#UUQ__U$U$U  '(Q__$)6 *+$,*\ FCFFDF F  #$CCD% ,- S S d . L$ -.SSt/ &'CCT(& "#~~AJJ~D~$~ '(AJJD) *+," 12;#;#;4;3;( 01A,<,<$26 $ 7 <2$ 89=c=c=cA,>,>=cD=c:=c~ ,-;S;S;d;.;& {3{quu{${{  "#33quu$$ -.6S6S66D6/6( /0 6s 6s 6 61 6 %&33D'0 -.SSD/ !" gs g199 g$ g# g  ,-SST. %&l3lq}}l$l'l0 01QVV2W HCHHDH H  #$CCD% &'CCT( +#WV  !// " ()BcB!//BtB*B  -.cc!//t/ 01cct2 #$MMAJJMDM%M ()AJJD*CQ__C ()B#BaooB4B*B -.##aoo4/f!--f &'@C@ @4@(@ +,CC 4- 45    6  "# 3 D c 3  s $   ,-WCWsWsWW.W  -.FJ3i]d#1S#1#1#1#1:#1Y\#1/#1L () _ _ _$ _* _ -.hhhh/h  f f f  f )K$x-8h G44r@