prG|@!sۜe)׬ƙ`%q7b/p*HNbG/˹U(D8_K+ /VO+;U疨d“IqGnu$Z@"2X 4u>H~LFt XU%qЦUFu"GLJէ+َ/_-&:$p{5Ǖg_3v'^o;gi ɌtӎE?^0T纅pf>ф{d hʌґӅ^ɚn1jJ8SA@i^HK6;cG=*=|@Di 9[䷎Tud;f[2f^yGRwN?XU+]RǨ@4#ˉ)ZyC+!y-En_J2 Ǥ3H:gn2y-oУOڞ)V z˼= QWCeD, lCĻP>_p񡁂P@ēJYbxà&FXDjzNM{>iP.n_J2 Ǥ ፞O#"i,lvh"rRh41K8 y;V= 2V)vuoV޹Kҿd%ߢ޵)ʅ 0]2VWe4cڸf 'cq"~|^aXi(nюsY(`JW.B`WB#.qNwO90'ay(~*ơS,󼢶Z["M:_iN?W=[p1<2M*8d8%JWƟ2ڀ?-/AA &moTH/]'a_pȰWj kr 2x`JA& f+"<1ٚ$xl;p?"*לlj1OafN'G8gu> IL`JYz`G0&+]Q)}IOтɏGP'[Ay 1i%p1E39&l{LNḻJ F]>DѽfHdS|:қLA}耮⣱]#,vDMveh蕰֦%ahVbOQd_佪@Q3W򉁭JEIhQFEԐXIskC(3r*;k?`YjwWk29ҏ(\Fy8~:@Ruc(ĩ"|.4qf5?Lh7f!mW M\QN(nИv1tړbd5HkZ^̓hҲ7P.^ L+MI5f`҂\CžߙH3!eD-a <֓X: =𻻑KES8Wl%3 =A0Zmbk`G}%6r+6Q{Q[}`:{\ ,ne"]-l=7MV{G7Β!$ ΞkW{hJ})Fb$TD1$$!_*T*#zrϿN`}34eQ(j~lhŵ>(j"zLu/4yP8+7[{h^€ ]r4%0MB ScMr:Q/ԟHe\ȫkDӄfgMRnNL0( ' 'I\>48<룄$pbYfBQAҌO%x@᤼K7k"YN s/T)l0Kl(cw5ʪ-t.”Qͮ}ި~lߩt4W-\ ZȐLWFSI &k7 Yboq3 V"%ahjTAlͿJ,lT>oο!;h* D'ۆ4O =ay̑0K+En i-X% Ƴ #7F dA{smp>CclIQ)\ gJ;\!=  # sgWty݂PVle0 ')w֩e*3Y5T #P!WYZ`G~3Bd ^,o]1]u HS&nP1+_7Asu>6ŏam)g)H/u83k]F2aגk,g7&jUiISܬ7%@ OEO]nt JXnlQ$A{8}p{2aZ;`(SW}˭ h=DpWgsIЮ7qԺrWh |1-ꆭP*,B, bw?2y)iGy9QɛECyA4ԋ߭665>7ƒ*)}1*T:=8I}[&$p᷷1?os~: !z.%8*.jNMqoV~gR-xF #1  $?]XHp ߠQ9ɉzMA7 F"gVDϊz L:[C-W02ЭCyD/R)9[Doá)i*W8.G8+zU=cr+yi׾p;'sRv0UJ*ڏz_;91 dtYt4Tң`ج=P+U8atMX2\Cb݁0hsz3j{ #vuR̪L҆Ŗ/p Ҥ0%zŇħ 1kUt5I<ȶkK㌔Jumk^:R&Y~qF*Fױ/\%VL*BרּI̶UN5s%o<36oJȞ1c> D|/Q9(Y)2tve6 IX~9u0Jqy,VA.qTxs6[OڌDS_S8 ] `EaoI>#_1Xd5(\WWłZ/،~o8l.T >TH|kQBf[ =tǴlk02 else -10)) if i<5: put('transactions',kind='payment',invoice_id=inv['id'],job_id=job['id'],amount_cents=est['total_cents'] if i<3 else est['deposit_cents'], date=scheduled if i<3 else day(),category='Customer payment',method='Bank transfer' if i%2 else 'Check',description='Final payment' if i<3 else 'Installation deposit',reference='SAMPLE') put('transactions',kind='expense',invoice_id=None,job_id=job['id'],amount_cents=80000+i*11000,date=day(-5 if i>2 else [-80,-49,-18][i]), category='Materials',method='Business card',description='Lighting materials - sample expense',reference='SAMPLE') put('transactions',kind='expense',invoice_id=None,job_id=None,amount_cents=6500,date=day(),category='Overhead',method='Business card',description='Sample business overhead',reference='SAMPLE') for action,entity,detail in [('Created sample workspace','businesses','All records and prices are fictional.'),('Prepared estimate','estimates','Front roofline lighting'),('Scheduled installation','jobs','Upcoming lighting installation'),('Recorded deposit','transactions','Sample customer payment')]: audit(conn,dict(admin),bid,action,entity,bid,detail) return bid def main(): parser=argparse.ArgumentParser(description='LB Exterior Lighting CRM administration') parser.add_argument('command',choices=['init','demo','reset-admin']) args=parser.parse_args() try: if args.command=='init': print('\nCreate your PLATFORM ADMINISTRATOR. No default password is installed.\n') name=input('Your name: ').strip() or 'Platform Admin' email=input('Administrator email: ').strip() password=getpass.getpass('Password (at least 12 characters): ') if getpass.getpass('Repeat password: ')!=password: raise ValueError('Passwords did not match.') bootstrap(name,email,password) print('\nAdministrator created. LB Exterior Lighting is ready as an empty business workspace.') if input('Create a SEPARATE fictional demo workspace? [Y/n]: ').strip().lower()!='n': seed_demo();print('Demo workspace created separately from your real business.') elif args.command=='demo': print('Demo business:',seed_demo()) else: initialize();email=input('Administrator email: ').strip().lower() password=getpass.getpass('New password (at least 12 characters): ') if getpass.getpass('Repeat password: ')!=password: raise ValueError('Passwords did not match.') with db(write=True) as conn: row=conn.execute('SELECT * FROM users WHERE email=? AND is_super=1',(email,)).fetchone() if not row: raise ValueError('Platform administrator not found.') conn.execute('UPDATE users SET password_hash=?,active=1,must_change=0 WHERE id=?',(hash_password(password),row['id'])) conn.execute('DELETE FROM sessions WHERE user_id=?',(row['id'],)) audit(conn,dict(row),None,'Recovered admin account on server','users',row['id']) print('Administrator password reset. Existing sessions have been revoked.') except (ValueError,sqlite3.IntegrityError) as exc: parser.exit(1,f'Error: {exc}\n') if __name__=='__main__': main()