j5rG\(R}S?5S3\"S0\<4S@j5rH\(RS?5S3\"4SAj5rI\(RsSB5SC5rJ\(RwSB5S0\<4SDj5rK\(R}SE5S3\"S0\<4SFj5rL\(RSE5S3\"4SGj5rM\(RsSH5SI5rN\(RwSH5S0\<4SJj5rO\(R}SK5S3\"S0\<4SLj5rP\(RSK5S3\"4SMj5rQ\(RsSN5SO5rR\(RwSN5S0\<4SPj5rS\(R}SQ5S3\"S0\<4SRj5rT\(RSQ5S3\"4SSj5rU\(RsST5SU5rV\(RwST5S0\<4SVj5rW\(R}SW5S3\"S0\<4SXj5rX\(RSW5S3\"4SYj5rY\(RsSZ5S[5rZ\(RwSZ5S0\<4S\j5r[\(R}S]5S3\"S0\<4S^j5r\\(RS]5S3\"4S_j5r]\(RsS`5Sa5r^\(RwS`5S0\<4Sbj5r_\(R}Sc5S3\"S0\<4Sdj5r`\(RSc5S3\"4Sej5ra\(RsSf5Sg5rb\(RwSf5S0\<4Shj5rc\(R}Si5S3\"S0\<4Sjj5rd\(RSi5S3\"4Skj5re\(RsSl5Sm5rf\(RwSl5S0\<4Snj5rg\(R}So5S3\"S0\<4Spj5rh\(RSo5S3\"4Sqj5riSrrjSsrk"StSu\5rl"SvSw\5rm"SxSy\5rn"SzS{\5ro"S|S}\5rp"S~S\5rq"SS\5rr"SS\5rs"SS\5rt"SS\5ru"SS\5rv"SS\5rw"SS\5rx"SS\5ry"SS\5rx"SS\5rz"SS\5r{"SS\5r|\(RS5S5r~\(RsS5S5r\(RsS5S5r\(RsS5S5r\(RsS5S3\"4Sj5r\(RwS5S\s4Sj5r\(R}S5S3\"S\s4Sj5r\(RS5S3\"4Sj5r\(RsS5S5r\(RsS5S3\"4Sj5r\(RwS5S\t4Sj5r\(R}S5S3\"S\t4Sj5r\(RS5S3\"4Sj5r\(RsS5S5r\(RsS5S3\"4Sj5r\(RwS5S\u4Sj5r\(R}S5S3\"S\u4Sj5r\(RS5S3\"4Sj5r\(RsS5S5r\(RwS5S\v4Sj5r\(R}S5S\"S\v4Sj5r\(RS5S\"4Sj5r\(RsS5S5r\(RwS5S\w4Sj5r\(R}S5S\"S\w4Sj5r\(RS5S\"4Sj5r\(RsS5S5r\(RsS5S5r\(RsS5S5r\(RsS5S5r\(RwS5S0\<4Sj5r\(R}S5S3\"S0\<4Sj5r\(RS5S3\"4Sj5r\(RwS5S\x4Sj5r\(R}S5S3\"S\x4Sj5r\(RS5S3\"4Sj5r0SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_0SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_E0SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_GSGS_GSGS_GSGS_GSGS_EGSGSGSGS.Er\<\\0\04\\0\044\GS'GS \0S,\\04GS jrGS \\0S,\04GS jr\(RsGS 5GS\0GS\04GSj5r\(R}GS 5GS\0GS\0S\y4GSj5r\(RsGS5GS5r\(RsGS5GS5r\(RsGS5GS5r\(RsGS5GS5r\(RwGS5S0\<4GSj5r\(R}GS5S3\"S0\<4GSj5r\(RGS5S3\"4GSj5r\(RsGS5GS5r\(RsGS 5GS!5r\(RsGS"5GS#5r\(RsGS$5GS%5r\(RsGS&5GS'5r\(RsGS(5GS)\"4GS*j5r\(RsGS+5\ "GS,GS-GS.94GS/\4GS0jj5r\(RsGS15GS2\"4GS3j5r\(RGS15GS2\"4GS4j5r\(R}GS15GS2\"S0\|4GS5j5r\(RwGS65GS2\"4GS7j5r\(RGS85GS2\"4GS9j5r\(RwGS+5S0\|4GS:j5r\(RsGS;5GS2\"4GS<j5r\(RwGS;5\"GS=54GS2\"GS>\4GS?jj5r\(RsGS@5GSA5r\(RwS5S\r4GSBj5r\(R}GS(5GS)\"S\r4GSCj5r\(RGS(5GS)\"4GSDj5r\(RsGSE5GS)\"4GSFj5r\(RwGSE5\"GS=54GS)\"GS>\4GSGjj5r\(R}GSH5GS)\"GSI\"S\<4GSJj5r\(RGSH5GS)\"GSI\"4GSKj5r\(RsGSL5GS)\"GSI\"4GSMj5r\(RwGSN\mGSO9S0\l4GSPj5r\(RwGSQ5S0\o4GSRj5r\(RwGSS5S0\p4GSTj5r\(RsGSU5GSV5r"GSWGSX\5r\(R}GSY5GSZ\"S\4GS[j5r"GS\GS]\5r\(RwGSU5S\4GS^j5r"GS_GS`\5r\(R}GSa5GSZ\"S\4GSbj5r"GScGSd\5r\(R}GSe5GSZ\"S\4GSfj5r\(RsGSg5GSh5r\(RsGSi5GSj\"4GSkj5r\(RwGSg5GSl\q4GSmj5r\(R}GSi5GSj\"GSl\q4GSnj5r\(RGSi5GSj\"4GSoj5r\(RsGSp5GSq\"4GSrj5r\(RwGSp5\"GS=54GSq\"GS>\4GSsjj5r\(R}GSt5GSq\"GSI\"S\<4GSuj5r\(RGSt5GSq\"GSI\"4GSvj5r\(RsGSw5GSq\"GSI\"4GSxj5r\(RsGSy5GSz5r\(RwGSy5GS{\n4GS|j5r\(RsGS}5GSq\"4GS~j5r\(R}GS}5GSq\"GS{\n4GSj5r\(RGS}5GSq\"4GSj5r\GS:XaSSKr\GR"GSGSGSSGSGS9 gg()datetime timedeltaN)FastAPI HTTPException UploadFileFileResponseQuery) FileResponse) StaticFiles)CORSMiddleware) BaseModelEmailStr) CryptContext)pooling)Optional) load_dotenv) EmailMessageDB_HOST localhostDB_PORT3306DB_USER bullseye_user DB_PASSWORDz4#zqJOSeownWs86cDB_NAMESouthernDirectionsql4bcryptauto)schemes deprecated UPLOAD_DIRuploadsTexist_okz/uploads) directory)name)zhttps://bullseye.mysouth.iozhttp://localhost:40773zhttp://127.0.0.1:40773)GETPOSTPUTDELETEOPTIONS*) allow_originsallow_credentials allow_methods allow_headersbe_pool_ DB_POOL_SIZE15) pool_name pool_sizehostportuserpassworddatabase autocommitc [R5$![RRR a9 [RR [[[[[SS9s$f=f)NT)r7r8r9r:r;r<) connection_poolget_connectionmysql connectorerrors PoolErrorconnectrrrrr!C:\Projects\Bulls Eye\app\main.pyr?r?Bsc  --// ?? ! ! + +  &&  '    sAA76A7cd[U[5(aUR5nUS:waU$S$U$)N) isinstancestrstrip)valuevs rG_blank_to_nonerOQs0% KKMGq%% LrF table_namereturnc[5nURSS9nURSU35 UR5=(d /nUVs1sH+n[ U[ 5(dMUR S5iM- snUR5 $s snf![a [5sUR5 $f=f!UR5 f=f)zKReturn set of column names for the given table. Empty set if table missing.T dictionaryzSHOW COLUMNS FROM Field) r?cursorexecutefetchallrJdictgetclose Exceptionset)rPconncurrowsrs rG_get_table_columnsrbXs  D kkTk*  KK,ZL9 :<<>'RD,0HDqJq$4GNAEE'NDH I 5L   s@C1B B*B?BBB>+C=B>>CCz/items/line-item-rug-mountcv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSz SELECT id, category, name, notes FROM line_item_rug_mount WHERE is_active = 1 ORDER BY category, name errnoz r?rVrWr@rAErrorgetattrr[rXr^r_es rGlist_items_line_item_rug_mountrkg  DkkTk*  KK ||~## $$ q'4(D0     ?B&AB&B#5BB#B&BB##B&&B8payloadc BSS/nUH=nURU5=(d SR5(aM2[SSU3S9e [5nUR 5nUR SURS5URS5[ URS55[URS S 55R5S ;aS OS 45 UR5 SUR0UR5 $!UR5 f=f)Ncategoryr'rIMissing required field:  status_codedetailz INSERT INTO line_item_rug_mount (category, name, notes, is_active) VALUES (%s, %s, %s, %s) notes is_active10falseFalserid rZrLrr?rVrWrOrKcommit lastrowidr[rnrequiredkr^r_s rGcreate_line_item_rug_mountr~F#H  A$"++--C:RSTRU8VW W  Dkkm    J' F#w{{734[#67==?G^^de    cmm$  B(D Dz&/items/line-item-rug-mount/{record_id} record_idc [5nUR5nURSURS5URS5[ URS55[ URSS55R 5S;aSOS U45 URS :Xa [S S S 9eUR5 S S0UR5 $!UR5 f=f)Nz UPDATE line_item_rug_mount SET category=%s, name=%s, notes=%s, is_active=%s WHERE id=%s rpr'rvrwrxryr}rRug Mount line item not foundrssuccessT r?rVrWrZrOrKrLrowcountrrr[rrnr^r_s rGupdate_line_item_rug_mountrs  Dkkm    J' F#w{{734[#67==?G^^de    <<1 C8WX X 4   B9CC(c[5nUR5nURSU45 URS:Xa [ SSS9eUR 5 SS0UR 5 $!UR 5 f=f)Nz+DELETE FROM line_item_rug_mount WHERE id=%srrrrsrTr?rVrWrrrr[rr^r_s rGdelete_line_item_rug_mountrsi  Dkkm AI<P <<1 C8WX X 4   AA--A?z/items/line-item-misc-productscv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSz SELECT id, section, item, `option`, internal_note, notes, price_usd FROM line_item_misc_products WHERE is_active = 1 ORDER BY section, item, `option` rdrerfris rG"list_items_line_item_misc_productsrrlrmcnSS/nUH=nURU5=(d SR5(aM2[SSU3S9e [5nUR 5nUR SURS5URS5[ URS55[ URS 55[ URS 55[ URS 55[ URS 55[ URS 55[ URS55[URSS55R5S;aSOS4 5 UR5 SUR0UR5 $!UR5 f=f)NsectionitemrIrqrrrsz INSERT INTO line_item_misc_products (section, item, `option`, internal_note, notes, price_zar, price_usd, price_eur, price_bwp, is_active) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s) option internal_noterv price_zar price_usd price_eur price_bwprwrxryr}rr~rrs rGcreate_line_item_misc_productsrs[6"H  A$"++--C:RSTRU8VW W  Dkkm    I& F#w{{845w{{?;<w{{734w{{;78w{{;78w{{;78w{{;78[#67==?G^^de   & cmm$  D>F""F4z*/items/line-item-misc-products/{record_id}c[5nUR5nURSURS5URS5[ URS55[ URS55[ URS55[ URS55[ URS55[ URS 55[ URS 55[ URS S 55R 5S ;aSOSU4 5 URS:Xa [SSS9eUR5 SS0UR5 $!UR5 f=f)Na UPDATE line_item_misc_products SET section=%s, item=%s, `option`=%s, internal_note=%s, notes=%s, price_zar=%s, price_usd=%s, price_eur=%s, price_bwp=%s, is_active=%s WHERE id=%s rrrrrvrrrrrwrxryr}rr!Misc products line item not foundrsrTrrs rGupdate_line_item_misc_productsrs+  Dkkm   I& F#w{{845w{{?;<w{{734w{{;78w{{;78w{{;78w{{;78[#67==?G^^de  , <<1 C8[\ \ 4   EE,,E>c[5nUR5nURSU45 URS:Xa [ SSS9eUR 5 SS0UR 5 $!UR 5 f=f)Nz/DELETE FROM line_item_misc_products WHERE id=%srrrrsrTrrs rGdelete_line_item_misc_productsrsi  Dkkm E |T <<1 C8[\ \ 4   rz/items/line-item-half-mountcv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSz SELECT id, category, name, notes FROM line_item_half_mount WHERE is_active = 1 ORDER BY category, name rdrerfris rGlist_items_line_item_half_mountr*rlrmc BSS/nUH=nURU5=(d SR5(aM2[SSU3S9e [5nUR 5nUR SURS5URS5[ URS55[URS S 55R5S ;aS OS 45 UR5 SUR0UR5 $!UR5 f=f)Nrpr'rIrqrrrsz INSERT INTO line_item_half_mount (category, name, notes, is_active) VALUES (%s, %s, %s, %s) rvrwrxryr}rr~rrs rGcreate_line_item_half_mountrArrz'/items/line-item-half-mount/{record_id}c [5nUR5nURSURS5URS5[ URS55[ URSS55R 5S;aSOS U45 URS :Xa [S S S 9eUR5 S S0UR5 $!UR5 f=f)Nz UPDATE line_item_half_mount SET category=%s, name=%s, notes=%s, is_active=%s WHERE id=%s rpr'rvrwrxryr}rrHalf Mount line item not foundrsrTrrs rGupdate_line_item_half_mountr]s  Dkkm    J' F#w{{734[#67==?G^^de    <<1 C8XY Y 4   rc[5nUR5nURSU45 URS:Xa [ SSS9eUR 5 SS0UR 5 $!UR 5 f=f)Nz,DELETE FROM line_item_half_mount WHERE id=%srrrrsrTrrs rGdelete_line_item_half_mountrxi  Dkkm BYLQ <<1 C8XY Y 4   rz"/items/line-item-african-map-mountcv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSz SELECT id, category, name, notes, price_zar, price_usd, price_eur, price_bwp, is_active FROM line_item_african_map_mount WHERE is_active = 1 ORDER BY category, name rdrerfris rG&list_items_line_item_african_map_mountrrlrmc SS/nUH=nURU5=(d SR5(aM2[SSU3S9e [5nUR 5nUR SURS5URS5[ URS55[ URS 55[ URS 55[ URS 55[ URS 55[URS S55R5S;aSOS45 UR5 SUR0UR5 $!UR5 f=f)Nrpr'rIrqrrrsz INSERT INTO line_item_african_map_mount (category, name, notes, price_zar, price_usd, price_eur, price_bwp, is_active) VALUES (%s, %s, %s, %s, %s, %s, %s, %s) rvrrrrrwrxryr}rr~rrs rG"create_line_item_african_map_mountrs9F#H  A$"++--C:RSTRU8VW W  Dkkm    J' F#w{{734w{{;78w{{;78w{{;78w{{;78[#67==?G^^de   " cmm$  D E00Fz./items/line-item-african-map-mount/{record_id}c[5nUR5nURSURS5URS5[ URS55[ URS55[ URS55[ URS55[ URS55[ URS S 55R 5S ;aS OS U4 5 URS :Xa [SSS9eUR5 SS0UR5 $!UR5 f=f)Nz UPDATE line_item_african_map_mount SET category=%s, name=%s, notes=%s, price_zar=%s, price_usd=%s, price_eur=%s, price_bwp=%s, is_active=%s WHERE id=%s rpr'rvrrrrrwrxryr}rrAfrican Map line item not foundrsrTrrs rG"update_line_item_african_map_mountrs   Dkkm    J' F#w{{734w{{;78w{{;78w{{;78w{{;78[#67==?G^^de   $ <<1 C8YZ Z 4   DD::E c[5nUR5nURSU45 URS:Xa [ SSS9eUR 5 SS0UR 5 $!UR 5 f=f)Nz3DELETE FROM line_item_african_map_mount WHERE id=%srrrrsrTrrs rG"delete_line_item_african_map_mountrsi  Dkkm II<X <<1 C8YZ Z 4   rz/items/line-item-skullscv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSz SELECT id, category, name, surcharge_pct, notes FROM line_item_skulls WHERE is_active = 1 ORDER BY category, name rdrerfris rGlist_items_line_item_skullsrrlrmc tSS/nUH=nURU5=(d SR5(aM2[SSU3S9e [5nUR 5nUR SURS5URS5[ URS55[ URS 55[URS S 55R5S ;aS OS45 UR5 SUR0UR5 $!UR5 f=f)Nrpr'rIrqrrrsz INSERT INTO line_item_skulls (category, name, surcharge_pct, notes, is_active) VALUES (%s, %s, %s, %s, %s) surcharge_pctrvrwrxryr}rr~rrs rGcreate_line_item_skullsrF#H  A$"++--C:RSTRU8VW W  Dkkm    J' F#w{{?;<w{{734[#67==?G^^de    cmm$  CD%%D7z#/items/line-item-skulls/{record_id}c [5nUR5nURSURS5URS5[ URS55[ URS55[ URSS55R 5S;aS OS U45 URS :Xa [S S S 9eUR5 SS0UR5 $!UR5 f=f)Nz UPDATE line_item_skulls SET category=%s, name=%s, surcharge_pct=%s, notes=%s, is_active=%s WHERE id=%s rpr'rrvrwrxryr}rrSkulls line item not foundrsrTrrs rGupdate_line_item_skullsrs  Dkkm    J' F#w{{?;<w{{734[#67==?G^^de     <<1 C8TU U 4   CC//Dc[5nUR5nURSU45 URS:Xa [ SSS9eUR 5 SS0UR 5 $!UR 5 f=f)Nz(DELETE FROM line_item_skulls WHERE id=%srrrrsrTrrs rGdelete_line_item_skullsr8si  Dkkm > M <<1 C8TU U 4   rz/items/line-item-pedestal-basescv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSz SELECT id, item, category, internal_note_applicable_to, price_usd FROM line_item_pedestal_bases WHERE is_active = 1 ORDER BY category, item rdrerfris rG#list_items_line_item_pedestal_basesrErlrmc SS/nUH=nURU5=(d SR5(aM2[SSU3S9e [5nUR 5nUR SURS5URS5[ URS55[ URS 55[ URS 55[ URS 55[ URS 55[URS S55R5S;aSOS45 UR5 SUR0UR5 $!UR5 f=f)NrrprIrqrrrsz INSERT INTO line_item_pedestal_bases (item, category, internal_note_applicable_to, price_usd, price_eur, price_zar, price_bwp, is_active) VALUES (%s, %s, %s, %s, %s, %s, %s, %s) internal_note_applicable_torrrrrwrxryr}rr~rrs rGcreate_line_item_pedestal_basesr\s: #H  A$"++--C:RSTRU8VW W  Dkkm    F# J'w{{+HIJw{{;78w{{;78w{{;78w{{;78[#67==?G^^de   " cmm$  rz+/items/line-item-pedestal-bases/{record_id}c[5nUR5nURSURS5URS5[ URS55[ URS55[ URS55[ URS55[ URS55[ URS S 55R 5S ;aS OS U4 5 URS :Xa [SSS9eUR5 SS0UR5 $!UR5 f=f)Nz UPDATE line_item_pedestal_bases SET item=%s, category=%s, internal_note_applicable_to=%s, price_usd=%s, price_eur=%s, price_zar=%s, price_bwp=%s, is_active=%s WHERE id=%s rrprrrrrrwrxryr}rr"Pedestal bases line item not foundrsrTrrs rGupdate_line_item_pedestal_basesr|s   Dkkm    F# J'w{{+HIJw{{;78w{{;78w{{;78w{{;78[#67==?G^^de   $ <<1 C8\] ] 4   rc[5nUR5nURSU45 URS:Xa [ SSS9eUR 5 SS0UR 5 $!UR 5 f=f)Nz0DELETE FROM line_item_pedestal_bases WHERE id=%srrrrsrTrrs rGdelete_line_item_pedestal_basesri  Dkkm F U <<1 C8\] ] 4   rz(/items/line-item-pedestal-shoulder-mountcv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSz SELECT id, category, name, surcharge_pct, notes FROM line_item_pedestal_shoulder_mount WHERE is_active = 1 ORDER BY category, name rdrerfris rG,list_items_line_item_pedestal_shoulder_mountrrlrmc tSS/nUH=nURU5=(d SR5(aM2[SSU3S9e [5nUR 5nUR SURS5URS5[ URS55[ URS 55[URS S 55R5S ;aS OS45 UR5 SUR0UR5 $!UR5 f=f)Nrpr'rIrqrrrsz INSERT INTO line_item_pedestal_shoulder_mount (category, name, surcharge_pct, notes, is_active) VALUES (%s, %s, %s, %s, %s) rrvrwrxryr}rr~rrs rG(create_line_item_pedestal_shoulder_mountrrrz4/items/line-item-pedestal-shoulder-mount/{record_id}c [5nUR5nURSURS5URS5[ URS55[ URS55[ URSS55R 5S;aS OS U45 URS :Xa [S S S 9eUR5 SS0UR5 $!UR5 f=f)Nz UPDATE line_item_pedestal_shoulder_mount SET category=%s, name=%s, surcharge_pct=%s, notes=%s, is_active=%s WHERE id=%s rpr'rrvrwrxryr}rr+Pedestal Shoulder Mount line item not foundrsrTrrs rG(update_line_item_pedestal_shoulder_mountrs  Dkkm    J' F#w{{?;<w{{734[#67==?G^^de     <<1 C8ef f 4   rc[5nUR5nURSU45 URS:Xa [ SSS9eUR 5 SS0UR 5 $!UR 5 f=f)Nz9DELETE FROM line_item_pedestal_shoulder_mount WHERE id=%srrrrsrTrrs rG(delete_line_item_pedestal_shoulder_mountrsk  Dkkm OR[Q]^ <<1 C8ef f 4   rz-/items/line-item-wall-pedestal-shoulder-mountcv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSz SELECT id, category, name, notes FROM line_item_wall_pedestal_shoulder_mount WHERE is_active = 1 ORDER BY category, name rdrerfris rG1list_items_line_item_wall_pedestal_shoulder_mountrrlrmc BSS/nUH=nURU5=(d SR5(aM2[SSU3S9e [5nUR 5nUR SURS5URS5[ URS55[URS S 55R5S ;aS OS 45 UR5 SUR0UR5 $!UR5 f=f)Nrpr'rIrqrrrsz INSERT INTO line_item_wall_pedestal_shoulder_mount (category, name, notes, is_active) VALUES (%s, %s, %s, %s) rvrwrxryr}rr~rrs rG-create_line_item_wall_pedestal_shoulder_mountrrrz9/items/line-item-wall-pedestal-shoulder-mount/{record_id}c [5nUR5nURSURS5URS5[ URS55[ URSS55R 5S;aSOS U45 URS :Xa [S S S 9eUR5 S S0UR5 $!UR5 f=f)Nz UPDATE line_item_wall_pedestal_shoulder_mount SET category=%s, name=%s, notes=%s, is_active=%s WHERE id=%s rpr'rvrwrxryr}rr0Wall Pedestal Shoulder Mount line item not foundrsrTrrs rG-update_line_item_wall_pedestal_shoulder_mountr8s  Dkkm    J' F#w{{734[#67==?G^^de    <<1 C8jk k 4   rc[5nUR5nURSU45 URS:Xa [ SSS9eUR 5 SS0UR 5 $!UR 5 f=f)Nz>DELETE FROM line_item_wall_pedestal_shoulder_mount WHERE id=%srrrrsrTrrs rG-delete_line_item_wall_pedestal_shoulder_mountrSsk  Dkkm TW`Vbc <<1 C8jk k 4   rz/items/line-item-shoulder-mountcv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSz SELECT id, category, name, notes FROM line_item_shoulder_mount WHERE is_active = 1 ORDER BY category, name rdrerfris rG#list_items_line_item_shoulder_mountr`rlrmc BSS/nUH=nURU5=(d SR5(aM2[SSU3S9e [5nUR 5nUR SURS5URS5[ URS55[URS S 55R5S ;aS OS 45 UR5 SUR0UR5 $!UR5 f=f)Nrpr'rIrqrrrsz INSERT INTO line_item_shoulder_mount (category, name, notes, is_active) VALUES (%s, %s, %s, %s) rvrwrxryr}rr~rrs rGcreate_line_item_shoulder_mountrwrrz+/items/line-item-shoulder-mount/{record_id}c [5nUR5nURSURS5URS5[ URS55[ URSS55R 5S;aSOS U45 URS :Xa [S S S 9eUR5 S S0UR5 $!UR5 f=f)Nz UPDATE line_item_shoulder_mount SET category=%s, name=%s, notes=%s, is_active=%s WHERE id=%s rpr'rvrwrxryr}rr"Shoulder Mount line item not foundrsrTrrs rGupdate_line_item_shoulder_mountrs  Dkkm    J' F#w{{734[#67==?G^^de    <<1 C8\] ] 4   rc[5nUR5nURSU45 URS:Xa [ SSS9eUR 5 SS0UR 5 $!UR 5 f=f)Nz0DELETE FROM line_item_shoulder_mount WHERE id=%srrrrsrTrrs rGdelete_line_item_shoulder_mountrrrz/items/line-item-full-mountcv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSz SELECT id, category, base_type, name, surcharge_pct, notes, price_usd FROM line_item_full_mount WHERE is_active = 1 ORDER BY category, base_type, name rdrerfris rGlist_items_line_item_full_mountrrlrmcnSS/nUH=nURU5=(d SR5(aM2[SSU3S9e [5nUR 5nUR SURS5[ URS55URS5[ URS 55[ URS 55[ URS 55[ URS 55[ URS 55[ URS55[URSS55R5S;aSOS4 5 UR5 SUR0UR5 $!UR5 f=f)Nrpr'rIrqrrrsz INSERT INTO line_item_full_mount (category, base_type, name, surcharge_pct, notes, price_zar, price_usd, price_eur, price_bwp, is_active) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s) base_typerrvrrrrrwrxryr}rr~rrs rGcreate_line_item_full_mountrs[F#H  A$"++--C:RSTRU8VW W  Dkkm    J'w{{;78 F#w{{?;<w{{734w{{;78w{{;78w{{;78w{{;78[#67==?G^^de   & cmm$  rz'/items/line-item-full-mount/{record_id}c[5nUR5nURSURS5[ URS55URS5[ URS55[ URS55[ URS55[ URS55[ URS 55[ URS 55[ URS S 55R 5S ;aSOSU4 5 URS:Xa [SSS9eUR5 SS0UR5 $!UR5 f=f)Na UPDATE line_item_full_mount SET category=%s, base_type=%s, name=%s, surcharge_pct=%s, notes=%s, price_zar=%s, price_usd=%s, price_eur=%s, price_bwp=%s, is_active=%s WHERE id=%s rprr'rrvrrrrrwrxryr}rrFull Mount line item not foundrsrTrrs rGupdate_line_item_full_mountrs+  Dkkm   J'w{{;78 F#w{{?;<w{{734w{{;78w{{;78w{{;78w{{;78[#67==?G^^de  , <<1 C8XY Y 4   rc[5nUR5nURSU45 URS:Xa [ SSS9eUR 5 SS0UR 5 $!UR 5 f=f)Nz,DELETE FROM line_item_full_mount WHERE id=%srrrrsrTrrs rGdelete_line_item_full_mountrrrz/items/line-item-skinscv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSz SELECT id, category, skin_type, tanning_type, name, notes, add_on_price_usd FROM line_item_skins WHERE is_active = 1 ORDER BY category, name rdrerfris rGlist_items_line_item_skinsr$rlrmcnSS/nUH=nURU5=(d SR5(aM2[SSU3S9e [5nUR 5nUR SURS5[ URS55[ URS 55URS5[ URS 55[ URS 55[ URS 55[ URS 55[ URS55[URSS55R5S;aSOS4 5 UR5 SUR0UR5 $!UR5 f=f)Nrpr'rIrqrrrsa INSERT INTO line_item_skins (category, skin_type, tanning_type, name, notes, add_on_price_zar, add_on_price_usd, add_on_price_eur, add_on_price_bwp, is_active) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s) skin_type tanning_typervadd_on_price_zaradd_on_price_usdadd_on_price_euradd_on_price_bwprwrxryr}rr~rrs rGcreate_line_item_skinsr;s_F#H  A$"++--C:RSTRU8VW W  Dkkm    J'w{{;78w{{>:; F#w{{734w{{+=>?w{{+=>?w{{+=>?w{{+=>?[#67==?G^^de   & cmm$  rz"/items/line-item-skins/{record_id}c[5nUR5nURSURS5[ URS55[ URS55URS5[ URS55[ URS55[ URS55[ URS 55[ URS 55[ URS S 55R 5S ;aSOSU4 5 URS:Xa [SSS9eUR5 SS0UR5 $!UR5 f=f)Na UPDATE line_item_skins SET category=%s, skin_type=%s, tanning_type=%s, name=%s, notes=%s, add_on_price_zar=%s, add_on_price_usd=%s, add_on_price_eur=%s, add_on_price_bwp=%s, is_active=%s WHERE id=%s rprrr'rvrrrrrwrxryr}rrSkins line item not foundrsrTrrs rGupdate_line_item_skinsr]s/  Dkkm   J'w{{;78w{{>:; F#w{{734w{{+=>?w{{+=>?w{{+=>?w{{+=>?[#67==?G^^de  , <<1 C8ST T 4   rc[5nUR5nURSU45 URS:Xa [ SSS9eUR 5 SS0UR 5 $!UR 5 f=f)Nz'DELETE FROM line_item_skins WHERE id=%srrrrsrTrrs rGdelete_line_item_skinsr si  Dkkm = |L <<1 C8ST T 4   rc[5nUR5nURS5 UR5(dURS5 URS5 UR5(dURS5 URSS9nURS5 UR 5=(d /Vs1sHo3R S5iM nn/nS U;aURS 5 S U;aURS 5 S U;aURS5 SU;aURS5 SU;aURS5 SU;aURS5 SU;aURS5 SU;aURS5 SU;aURS5 U(a#URSSRU5-5 URS5 UR5(dURS5 URSS9nURS5 UR 5=(d /Vs1sHo3R S5iM nn/nS U;aURS!5 S"U;aURS#5 U(a#URS$SRU5-5 URS%5 UR5(dURS&5 URS'5 UR5(dURS(5 URS)5 UR5(dURS*5 URS+5 URS,5 URS-5 UR5(dURS.5 URS/5 UR5(dURS05 URS15 UR5S2nUS2:Xa/S3QnURS4U5 URS55 URS65 UR5(dURS75 URS85 URS95 UR5(dURS:5 URS;5 URS<5 URS=5 UR5n[U(a US2bUS2OS25n URS>5 UR 5=(d /Vs/sHo3S2PM n nU n U H!n U S?- n S@U SA3n URSBX45 M# URSC5 URSD5 UR5(dURSE5 URSF5 UR5(dURSG5 URSH5 UR5(dURSI5 URSJ5 UR5(dURSK5 URSL5 UR5(dURSM5 URSN5 URSO5 URSP5 UR5(dURSQ5 URSR5 UR5(dURSS5 URST5 UR5(dURSU5 URSV5 URSW5 URSX5 UR5(dURSY5 URSZ5 UR5(dURS[5 URS\5 UR5(dURS]5 URS^5 UR5(dURS_5 URS`5 URSa5 URSb5 UR5(dURSc5 O6URSd5 URSe5 URSf5 URSg5 UR5(dURSh5 SiSjSkSlSmSnSoSpSqSqSrSsSt. SuSvSwSxSySzS{S|S}S~SSSt. SSSSlSSSoSqSqSqSSSt. /nUHEnURSUSUSUSUSUSUSUSUSUSUSUSUS4 5 MG UR5 g![a G Nf=f![a G Npf=fs snf![a GN3f=f![a GN f=fs snf![a GNpf=f![a GNIf=f![a GN"f=f![a GNf=f![a GNf=f![a GNf=f![a GN[f=f![a GNZf=f![a GN3f=f![a GN2f=f![a GNf=f![a GNf=fs snf![a GNkf=f![a GNjf=f![a GNVf=f![a GNUf=f![a GNf=f![a GNf=f![a GNf=f![a GNf=f![a GNf=f![a GNf=f![a GNf=f!UR5 f=f)NzSHOW TABLES LIKE 'company_info'aS CREATE TABLE company_info ( id INT AUTO_INCREMENT PRIMARY KEY, company_name VARCHAR(160) NOT NULL, company_registration_number VARCHAR(64) NULL, company_vat_number VARCHAR(64) NULL, veterinary_approval_number VARCHAR(64) NULL, company_physical_address TEXT NULL, company_postal_address TEXT NULL, company_email VARCHAR(160) NULL, company_phone_number VARCHAR(64) NULL, company_mobile_number VARCHAR(64) NULL, company_whatsapp_number VARCHAR(64) NULL, company_website VARCHAR(160) NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; z"SHOW TABLES LIKE 'banking_details'a CREATE TABLE banking_details ( id INT AUTO_INCREMENT PRIMARY KEY, bank_name VARCHAR(160) NOT NULL, account_name VARCHAR(160) NULL, account_number VARCHAR(64) NULL, account_type VARCHAR(64) NULL, branch_code VARCHAR(64) NULL, swift_code VARCHAR(64) NULL, iban VARCHAR(64) NULL, bank_address TEXT NULL, notes TEXT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; TrSz!SHOW COLUMNS FROM banking_detailsrU bank_namez*ADD COLUMN bank_name VARCHAR(160) NOT NULL account_namez)ADD COLUMN account_name VARCHAR(160) NULLaccount_numberz*ADD COLUMN account_number VARCHAR(64) NULL account_typez(ADD COLUMN account_type VARCHAR(64) NULL branch_codez'ADD COLUMN branch_code VARCHAR(64) NULL swift_codez&ADD COLUMN swift_code VARCHAR(64) NULLibanz ADD COLUMN iban VARCHAR(64) NULL bank_addressz!ADD COLUMN bank_address TEXT NULLrvzADD COLUMN notes TEXT NULLzALTER TABLE banking_details , z SHOW TABLES LIKE 'banking_terms'a CREATE TABLE banking_terms ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(160) NOT NULL, term_text TEXT NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; zSHOW COLUMNS FROM banking_termstitlez&ADD COLUMN title VARCHAR(160) NOT NULL term_textz"ADD COLUMN term_text TEXT NOT NULLzALTER TABLE banking_terms z SHOW TABLES LIKE 'master_animal'a CREATE TABLE master_animal ( id INT AUTO_INCREMENT PRIMARY KEY, common_name VARCHAR(100) NOT NULL UNIQUE, dip_pack TINYINT(1) NOT NULL DEFAULT 0, tanning_of_skins TINYINT(1) NOT NULL DEFAULT 0, felting_of_skins_add_on TINYINT(1) NOT NULL DEFAULT 0, full_mount TINYINT(1) NOT NULL DEFAULT 0, shoulder_mount TINYINT(1) NOT NULL DEFAULT 0, wall_pedestal_shoulder_mount TINYINT(1) NOT NULL DEFAULT 0, pedestal_shoulder_mount TINYINT(1) NOT NULL DEFAULT 0, skull TINYINT(1) NOT NULL DEFAULT 0, rug_mount TINYINT(1) NOT NULL DEFAULT 0, africa_map_mount TINYINT(1) NOT NULL DEFAULT 0, half_mount TINYINT(1) NOT NULL DEFAULT 0, open_mouth_add_on TINYINT(1) NOT NULL DEFAULT 0, miscellaneous_manufactured_items TINYINT(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; z(SHOW TABLES LIKE 'master_animal_pricing'a CREATE TABLE master_animal_pricing ( id INT AUTO_INCREMENT PRIMARY KEY, common_name VARCHAR(120) NOT NULL UNIQUE, shoulder_mount_usd VARCHAR(64) NULL, shoulder_mount_eur VARCHAR(64) NULL, shoulder_mount_pula VARCHAR(64) NULL, shoulder_mount_zar VARCHAR(64) NULL, wall_pedestal_shoulder_mount_usd VARCHAR(64) NULL, wall_pedestal_shoulder_mount_eur VARCHAR(64) NULL, wall_pedestal_shoulder_mount_pula VARCHAR(64) NULL, wall_pedestal_shoulder_mount_zar VARCHAR(64) NULL, pedestal_shoulder_mount_usd VARCHAR(64) NULL, pedestal_shoulder_mount_eur VARCHAR(64) NULL, pedestal_shoulder_mount_pula VARCHAR(64) NULL, pedestal_shoulder_mount_zar VARCHAR(64) NULL, full_mount_usd VARCHAR(64) NULL, full_mount_eur VARCHAR(64) NULL, full_mount_pula VARCHAR(64) NULL, full_mount_zar VARCHAR(64) NULL, full_mount_note VARCHAR(160) NULL, skull_usd VARCHAR(64) NULL, skull_eur VARCHAR(64) NULL, skull_pula VARCHAR(64) NULL, skull_zar VARCHAR(64) NULL, rug_mount_usd VARCHAR(64) NULL, rug_mount_eur VARCHAR(64) NULL, rug_mount_pula VARCHAR(64) NULL, rug_mount_zar VARCHAR(64) NULL, tanning_of_skins_usd VARCHAR(64) NULL, tanning_of_skins_eur VARCHAR(64) NULL, tanning_of_skins_pula VARCHAR(64) NULL, tanning_of_skins_zar VARCHAR(64) NULL, felting_of_skins_add_on_usd VARCHAR(64) NULL, felting_of_skins_add_on_eur VARCHAR(64) NULL, felting_of_skins_add_on_pula VARCHAR(64) NULL, felting_of_skins_add_on_zar VARCHAR(64) NULL, africa_map_mount_usd VARCHAR(64) NULL, africa_map_mount_eur VARCHAR(64) NULL, africa_map_mount_pula VARCHAR(64) NULL, africa_map_mount_zar VARCHAR(64) NULL, half_mount_usd VARCHAR(64) NULL, half_mount_eur VARCHAR(64) NULL, half_mount_pula VARCHAR(64) NULL, half_mount_zar VARCHAR(64) NULL, dip_pack_price_usd VARCHAR(64) NULL, open_mouth_add_on_usd VARCHAR(64) NULL, open_mouth_add_on_eur VARCHAR(64) NULL, open_mouth_add_on_pula VARCHAR(64) NULL, open_mouth_add_on_zar VARCHAR(64) NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; zSHOW TABLES LIKE 'customers'a CREATE TABLE customers ( id INT AUTO_INCREMENT PRIMARY KEY, customer_unique_number VARCHAR(50) GENERATED ALWAYS AS (CONCAT('CUST-', LPAD(id, 6, '0'))) STORED UNIQUE, status ENUM('Active','Inactive','On-Hold') NOT NULL DEFAULT 'Active', customer_type ENUM('Export','Local') NOT NULL, first_names VARCHAR(255) NOT NULL, surname VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL UNIQUE, contact_number VARCHAR(50) NOT NULL, whatsapp_number VARCHAR(50) DEFAULT NULL, physical_country VARCHAR(100) DEFAULT NULL, physical_street VARCHAR(255) DEFAULT NULL, physical_province_state VARCHAR(100) DEFAULT NULL, physical_city VARCHAR(100) DEFAULT NULL, physical_postal_code VARCHAR(20) DEFAULT NULL, ship_country VARCHAR(100) DEFAULT NULL, ship_street VARCHAR(255) DEFAULT NULL, ship_province_state VARCHAR(100) DEFAULT NULL, ship_city VARCHAR(100) DEFAULT NULL, ship_postal_code VARCHAR(20) DEFAULT NULL, referred_by VARCHAR(255) DEFAULT NULL, preferred_currency ENUM('USD','EUR','BWP','ZAR') DEFAULT 'USD', citizenship ENUM('South African Citizen','Foreign National') NOT NULL, rsa_id VARCHAR(50) DEFAULT NULL, passport_number VARCHAR(50) DEFAULT NULL, documents TEXT DEFAULT NULL, office_notes TEXT DEFAULT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, CONSTRAINT chk_citizenship_id CHECK ( (citizenship = 'South African Citizen' AND rsa_id IS NOT NULL AND passport_number IS NULL) OR (citizenship = 'Foreign National' AND passport_number IS NOT NULL AND rsa_id IS NULL) ) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; z2DROP TRIGGER IF EXISTS customers_set_unique_numberz ALTER TABLE customers MODIFY customer_unique_number VARCHAR(50) GENERATED ALWAYS AS (CONCAT('CUST-', LPAD(id, 6, '0'))) STORED UNIQUE z%SHOW TABLES LIKE 'customer_documents'af CREATE TABLE customer_documents ( id INT AUTO_INCREMENT PRIMARY KEY, customer_id INT NOT NULL, file_path VARCHAR(512) NOT NULL, file_name VARCHAR(255) DEFAULT NULL, mime_type VARCHAR(100) DEFAULT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, deleted_at TIMESTAMP NULL DEFAULT NULL, INDEX idx_cust_docs_customer_id (customer_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; zSHOW TABLES LIKE 'partners'a CREATE TABLE partners ( id INT AUTO_INCREMENT PRIMARY KEY, partner_unique_number VARCHAR(50) UNIQUE, status ENUM('Active','Inactive','On-Hold') NOT NULL DEFAULT 'Active', partner_type ENUM('Professional Hunter','Outfitter','Professional Hunter & Outfitter','Shipping') NOT NULL, company_name VARCHAR(255) NOT NULL, company_vat VARCHAR(100) DEFAULT NULL, company_email VARCHAR(255) NOT NULL, company_contact_number VARCHAR(50) NOT NULL, company_country VARCHAR(100) NOT NULL, company_street VARCHAR(255) NOT NULL, company_province VARCHAR(100) NOT NULL, company_city VARCHAR(100) NOT NULL, company_postal_code VARCHAR(20) NOT NULL, first_name VARCHAR(100) NOT NULL, surname VARCHAR(100) NOT NULL, email VARCHAR(255) NOT NULL, contact_number VARCHAR(50) NOT NULL, hunting_outfitter_id VARCHAR(100) DEFAULT NULL, comms_local_percent DECIMAL(5,2) DEFAULT NULL, comms_export_percent DECIMAL(5,2) DEFAULT NULL, outfitter_documents TEXT DEFAULT NULL, professional_hunter_id VARCHAR(100) DEFAULT NULL, professional_hunter_permit_type ENUM('Standard','Dangerous Game','Standard & Dangerous Game') DEFAULT NULL, professional_hunter_permit_issue_date DATE DEFAULT NULL, professional_hunter_permit_expiry_date DATE DEFAULT NULL, professional_hunter_documents TEXT DEFAULT NULL, office_notes TEXT DEFAULT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; zSELECT COUNT(*) FROM partnersr))Active OutfitterzSavanna SafarisVAT123zinfo@savanna.examplez 012-345-6789 South Africaz 12 Main RdLimpopo Polokwane0700PeterMasilelazpeter@savanna.examplez 082-000-1111zOUT-001g$@g.@NNNNNzTrusted outfitter)rzProfessional Hunterz Kudu PlainsNzoffice@kuduplains.examplez 011-222-3333rz45 Bushveld Avez North West Rustenburg0299LeratoKhozazlerato@kuduplains.examplez 083-111-2222NNNNzPH-0099zDangerous Gamez 2024-01-10z 2026-01-09zExperienced PH)zOn-HoldShippingzWildShip LogisticsNzcontact@wildship.examplez 021-555-8888rz 78 Dock Stz Western Capez Cape Town8001AishaKhanzaisha@wildship.examplez 084-333-4444NNNNNNNNzPending reviewa INSERT INTO partners ( status, partner_type, company_name, company_vat, company_email, company_contact_number, company_country, company_street, company_province, company_city, company_postal_code, first_name, surname, email, contact_number, hunting_outfitter_id, comms_local_percent, comms_export_percent, outfitter_documents, professional_hunter_id, professional_hunter_permit_type, professional_hunter_permit_issue_date, professional_hunter_permit_expiry_date, professional_hunter_documents, office_notes ) VALUES ( %s,%s,%s,%s,%s,%s,%s,%s,%s,%s, %s,%s,%s,%s,%s,%s,%s,%s,%s,%s, %s,%s,%s,%s,%s ) z1DROP TRIGGER IF EXISTS partners_set_unique_numberz$SHOW TABLES LIKE 'partner_documents'ae CREATE TABLE partner_documents ( id INT AUTO_INCREMENT PRIMARY KEY, partner_id INT NOT NULL, file_path VARCHAR(512) NOT NULL, file_name VARCHAR(255) DEFAULT NULL, mime_type VARCHAR(100) DEFAULT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, deleted_at TIMESTAMP NULL DEFAULT NULL, INDEX idx_partner_docs_partner_id (partner_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; z ALTER TABLE partners MODIFY partner_unique_number VARCHAR(50) GENERATED ALWAYS AS (CONCAT('PART-', LPAD(id, 6, '0'))) STORED UNIQUE zSHOW TABLES LIKE 'quotes'a" CREATE TABLE quotes ( id INT AUTO_INCREMENT PRIMARY KEY, quote_unique_number VARCHAR(50) UNIQUE, partner_id INT DEFAULT NULL, partner_name VARCHAR(255) DEFAULT NULL, order_no VARCHAR(50) NOT NULL, quote_date DATE NOT NULL, order_type ENUM('Local','Export') NOT NULL, customer_id INT DEFAULT NULL, customer_first_names VARCHAR(255) NOT NULL, customer_surname VARCHAR(255) NOT NULL, customer_email VARCHAR(255) NOT NULL, customer_contact_number VARCHAR(50) NOT NULL, customer_country VARCHAR(100) NOT NULL, customer_street VARCHAR(255) NOT NULL, customer_province_state VARCHAR(100) DEFAULT NULL, customer_city VARCHAR(100) NOT NULL, customer_postal_code VARCHAR(20) NOT NULL, company_name VARCHAR(255) NOT NULL, company_physical_address VARCHAR(255) NOT NULL, company_phone_number VARCHAR(50) NOT NULL, company_email VARCHAR(255) NOT NULL, company_vat_number VARCHAR(100) DEFAULT NULL, company_registration_number VARCHAR(100) DEFAULT NULL, company_logo_url VARCHAR(500) DEFAULT NULL, quote_status ENUM('Draft - In Progress','Draft - For Customer Review','Draft - Customer Requested Changes','Draft - Pending Office Approval','Rejected','Accepted - Deposit Due','Accepted - Deposit Received','Accepted - Converted to Order') NOT NULL DEFAULT 'Draft - In Progress', quote_currency ENUM('USD','EUR','BWP','ZAR') NOT NULL DEFAULT 'USD', sub_total DECIMAL(12,2) NOT NULL DEFAULT 0.00, vat_amount DECIMAL(12,2) NOT NULL DEFAULT 0.00, total_amount DECIMAL(12,2) NOT NULL DEFAULT 0.00, deposit_percent DECIMAL(5,2) DEFAULT NULL, deposit_amount_due DECIMAL(12,2) DEFAULT NULL, terms_and_conditions TEXT DEFAULT NULL, payment_details TEXT DEFAULT NULL, office_notes TEXT DEFAULT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, deleted_at TIMESTAMP NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; z/DROP TRIGGER IF EXISTS quotes_set_unique_numberzt ALTER TABLE quotes MODIFY quote_unique_number VARCHAR(50) UNIQUE z SELECT COALESCE(MAX(CAST(SUBSTRING(quote_unique_number, 3) AS UNSIGNED)), 0) FROM quotes WHERE quote_unique_number REGEXP '^Q-[0-9]+' z SELECT id FROM quotes WHERE quote_unique_number IS NULL OR quote_unique_number = '' ORDER BY id r}Q-04dz8UPDATE quotes SET quote_unique_number = %s WHERE id = %szx ALTER TABLE quotes ADD COLUMN deleted_at TIMESTAMP NULL DEFAULT NULL z#SHOW TABLES LIKE 'quote_line_items'a CREATE TABLE quote_line_items ( id INT AUTO_INCREMENT PRIMARY KEY, quote_id INT NOT NULL, item_quantity INT NOT NULL DEFAULT 1, item_type ENUM('Animal','Bird','Administrative') NOT NULL, species VARCHAR(255) DEFAULT NULL, unit_price DECIMAL(12,2) NOT NULL DEFAULT 0.00, total_price DECIMAL(12,2) NOT NULL DEFAULT 0.00, detailed_instructions TEXT DEFAULT NULL, line_item_status ENUM('Draft','Approved','Cancelled') NOT NULL DEFAULT 'Draft', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, INDEX idx_quote_id (quote_id), CONSTRAINT fk_quote_line_items_quote FOREIGN KEY (quote_id) REFERENCES quotes(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; z,SHOW TABLES LIKE 'quote_line_item_processes'a CREATE TABLE quote_line_item_processes ( id INT AUTO_INCREMENT PRIMARY KEY, line_item_id INT NOT NULL, processing_type ENUM('Dip & Pack','Skins','Full Mount','Shoulder Mount','Wall Pedestal Shoulder Mount','Pedestal Shoulder Mount','Skull Mount','Rug Mount','Africa Map Mount','Half Mount','Standalone Bases','Manufactured Product') NOT NULL, processing_subtype VARCHAR(255) DEFAULT NULL, INDEX idx_line_item_id (line_item_id), CONSTRAINT fk_qli_process_item FOREIGN KEY (line_item_id) REFERENCES quote_line_items(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; z"SHOW TABLES LIKE 'quote_documents'ai CREATE TABLE quote_documents ( id INT AUTO_INCREMENT PRIMARY KEY, quote_id INT NOT NULL, file_url VARCHAR(500) NOT NULL, file_name VARCHAR(255) DEFAULT NULL, mime_type VARCHAR(100) DEFAULT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, INDEX idx_quote_doc_quote_id (quote_id), CONSTRAINT fk_quote_documents_quote FOREIGN KEY (quote_id) REFERENCES quotes(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; z!SHOW TABLES LIKE 'quote_hs_codes'a CREATE TABLE quote_hs_codes ( id INT AUTO_INCREMENT PRIMARY KEY, quote_id INT NOT NULL, hs_code VARCHAR(50) NOT NULL, INDEX idx_quote_hs_quote_id (quote_id), CONSTRAINT fk_quote_hs_codes_quote FOREIGN KEY (quote_id) REFERENCES quotes(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; zSHOW TABLES LIKE 'messages'a CREATE TABLE messages ( id INT AUTO_INCREMENT PRIMARY KEY, message_unique_number VARCHAR(50) UNIQUE, customer_id INT NOT NULL, customer_name VARCHAR(255) NOT NULL, message_title VARCHAR(255) NOT NULL, message_status ENUM('Open','Awaiting Reply','Closed','Archived') NOT NULL DEFAULT 'Open', opened_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, last_message_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, assigned_staff_id INT DEFAULT NULL, assigned_staff_name VARCHAR(255) DEFAULT NULL, related_quote_id INT DEFAULT NULL, related_quote_number VARCHAR(50) DEFAULT NULL, message_priority ENUM('Normal','Urgent','Follow-Up') NOT NULL DEFAULT 'Normal', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, INDEX idx_messages_customer_id (customer_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; z1DROP TRIGGER IF EXISTS messages_set_unique_numberz ALTER TABLE messages MODIFY message_unique_number VARCHAR(50) GENERATED ALWAYS AS (CONCAT('MSG-', LPAD(id, 6, '0'))) STORED UNIQUE z"SHOW TABLES LIKE 'message_entries'a CREATE TABLE message_entries ( id INT AUTO_INCREMENT PRIMARY KEY, message_id INT NOT NULL, sender_role ENUM('Customer','Staff') NOT NULL, sender_name VARCHAR(255) NOT NULL, message_header VARCHAR(255) DEFAULT NULL, message_content TEXT NOT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, INDEX idx_message_entries_message_id (message_id), CONSTRAINT fk_message_entries_message FOREIGN KEY (message_id) REFERENCES messages(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; z&SHOW TABLES LIKE 'message_attachments'a CREATE TABLE message_attachments ( id INT AUTO_INCREMENT PRIMARY KEY, entry_id INT NOT NULL, file_url VARCHAR(500) NOT NULL, file_name VARCHAR(255) DEFAULT NULL, mime_type VARCHAR(100) DEFAULT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, INDEX idx_message_attachments_entry_id (entry_id), CONSTRAINT fk_message_attachments_entry FOREIGN KEY (entry_id) REFERENCES message_entries(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; zSHOW TABLES LIKE 'invoices'u CREATE TABLE invoices ( id INT AUTO_INCREMENT PRIMARY KEY, invoice_unique_number VARCHAR(50) UNIQUE, related_quote_id INT DEFAULT NULL, related_quote_number VARCHAR(50) DEFAULT NULL, partner_id INT DEFAULT NULL, partner_name VARCHAR(255) DEFAULT NULL, invoice_date DATE NOT NULL, order_no VARCHAR(50) DEFAULT NULL, order_type ENUM('Local','Export') NOT NULL, customer_id INT DEFAULT NULL, customer_first_names VARCHAR(255) NOT NULL, customer_surname VARCHAR(255) NOT NULL, customer_email VARCHAR(255) DEFAULT NULL, customer_contact_number VARCHAR(50) DEFAULT NULL, customer_country VARCHAR(100) NOT NULL, customer_street VARCHAR(255) DEFAULT NULL, customer_province_state VARCHAR(100) DEFAULT NULL, customer_city VARCHAR(100) DEFAULT NULL, customer_postal_code VARCHAR(20) DEFAULT NULL, company_name VARCHAR(255) NOT NULL, company_physical_address VARCHAR(255) NOT NULL, company_phone_number VARCHAR(50) NOT NULL, company_email VARCHAR(255) NOT NULL, company_vat_number VARCHAR(100) DEFAULT NULL, company_registration_number VARCHAR(100) DEFAULT NULL, company_logo_url VARCHAR(500) DEFAULT NULL, invoice_type ENUM('Pro-Forma Invoice','Tax Invoice') NOT NULL, payment_type ENUM('Deposit','Installment','Final') NOT NULL, invoice_status ENUM('Draft – In Progress','Issued','Partial Payment Received','Paid in Full','Withdrawn') NOT NULL DEFAULT 'Draft – In Progress', invoice_currency ENUM('USD','EUR','BWP','ZAR') NOT NULL, sub_total DECIMAL(12,2) NOT NULL DEFAULT 0.00, vat_amount DECIMAL(12,2) NOT NULL DEFAULT 0.00, total_amount DECIMAL(12,2) NOT NULL DEFAULT 0.00, deposit_percent DECIMAL(5,2) DEFAULT NULL, deposit_amount_due DECIMAL(12,2) DEFAULT NULL, terms_and_conditions TEXT DEFAULT NULL, payment_details TEXT DEFAULT NULL, office_notes TEXT DEFAULT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; z1DROP TRIGGER IF EXISTS invoices_set_unique_numberz ALTER TABLE invoices MODIFY invoice_unique_number VARCHAR(50) GENERATED ALWAYS AS (CONCAT('INV-', LPAD(id, 6, '0'))) STORED UNIQUE z%SHOW TABLES LIKE 'invoice_line_items'a CREATE TABLE invoice_line_items ( id INT AUTO_INCREMENT PRIMARY KEY, invoice_id INT NOT NULL, item_quantity INT NOT NULL DEFAULT 1, item_type ENUM('Animal','Bird','Administrative') NOT NULL, species VARCHAR(255) DEFAULT NULL, processing_type ENUM('Dip & Pack','Skins','Full Mount','Shoulder Mount','Wall Pedestal Shoulder Mount','Pedestal Shoulder Mount','Skull Mount','Rug Mount','Africa Map Mount','Half Mount','Standalone Bases','Manufactured Product') DEFAULT NULL, processing_subtype VARCHAR(255) DEFAULT NULL, unit_price DECIMAL(12,2) NOT NULL DEFAULT 0.00, total_price DECIMAL(12,2) NOT NULL DEFAULT 0.00, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, INDEX idx_invoice_id (invoice_id), CONSTRAINT fk_invoice_line_items_invoice FOREIGN KEY (invoice_id) REFERENCES invoices(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; z#SHOW TABLES LIKE 'invoice_hs_codes'a CREATE TABLE invoice_hs_codes ( id INT AUTO_INCREMENT PRIMARY KEY, invoice_id INT NOT NULL, hs_code VARCHAR(50) NOT NULL, INDEX idx_invoice_hs_invoice_id (invoice_id), CONSTRAINT fk_invoice_hs_codes_invoice FOREIGN KEY (invoice_id) REFERENCES invoices(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; z#SHOW TABLES LIKE 'invoice_payments'ap CREATE TABLE invoice_payments ( id INT AUTO_INCREMENT PRIMARY KEY, invoice_id INT NOT NULL, payment_date DATE NOT NULL, amount DECIMAL(12,2) NOT NULL, notes VARCHAR(255) DEFAULT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, INDEX idx_invoice_payments_invoice_id (invoice_id), CONSTRAINT fk_invoice_payments_invoice FOREIGN KEY (invoice_id) REFERENCES invoices(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; zSHOW TABLES LIKE 'orders'a CREATE TABLE orders ( id INT AUTO_INCREMENT PRIMARY KEY, order_unique_number VARCHAR(50) UNIQUE, related_quote_id INT DEFAULT NULL, related_quote_number VARCHAR(50) DEFAULT NULL, related_invoice_id INT DEFAULT NULL, related_invoice_number VARCHAR(50) DEFAULT NULL, order_type ENUM('Export','Local') NOT NULL, processing_type ENUM('Fully Processed','Dip & Pack','Fully Processed + D&P','Other') NOT NULL, customer_id INT NOT NULL, customer_name VARCHAR(255) NOT NULL, order_delivery ENUM('Shipping Partner','Customer Collect') NOT NULL, deposit_received VARCHAR(100) DEFAULT 'No', instructions_finalised ENUM('Yes','No') NOT NULL DEFAULT 'No', order_paid_in_full VARCHAR(100) DEFAULT 'No', office_notes TEXT DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, INDEX idx_orders_customer_id (customer_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; z/DROP TRIGGER IF EXISTS orders_set_unique_numberz ALTER TABLE orders MODIFY order_unique_number VARCHAR(50) GENERATED ALWAYS AS (CONCAT('ORD-', LPAD(id, 6, '0'))) STORED UNIQUE zSHOW TABLES LIKE 'users'a$ CREATE TABLE users ( id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(64) NOT NULL UNIQUE, email VARCHAR(255) DEFAULT NULL UNIQUE, password_hash VARCHAR(255) DEFAULT NULL, role ENUM('customer','partner','staff','admin','office') NOT NULL DEFAULT 'customer', customer_id INT DEFAULT NULL, partner_id INT DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, last_login DATETIME DEFAULT NULL, password_reset_token VARCHAR(100) DEFAULT NULL, password_reset_expires DATETIME DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; zYALTER TABLE users ADD COLUMN IF NOT EXISTS password_reset_token VARCHAR(100) DEFAULT NULLzWALTER TABLE users ADD COLUMN IF NOT EXISTS password_reset_expires DATETIME DEFAULT NULLz?ALTER TABLE users MODIFY COLUMN password_hash VARCHAR(255) NULLz"SHOW TABLES LIKE 'customer_orders'a< CREATE TABLE customer_orders ( id INT AUTO_INCREMENT PRIMARY KEY, orderUniqueNumber VARCHAR(50) NOT NULL UNIQUE, relatedQuoteNumber VARCHAR(50), relatedInvoiceNumber VARCHAR(50), orderType ENUM('Export', 'Local') NOT NULL, processingType ENUM('Fully Processed', 'Dip & Pack', 'Fully Processed + D&P', 'Other') NOT NULL, customerName VARCHAR(255) NOT NULL, orderDelivery ENUM('Shipping Partner', 'Customer Collect') NOT NULL, depositReceived VARCHAR(100), instructionsFinalised ENUM('Yes', 'No') NOT NULL, orderPaidInFull VARCHAR(100), officeNotes TEXT, date DATE NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; zSO-1001zQ-501zINV-9001ExportzFully ProcessedzJohn DoezShipping PartnerzYes - 01-06-2024NozAwaiting collection preferencez 2024-05-01) orderUniqueNumberrelatedQuoteNumberrelatedInvoiceNumber orderTypeprocessingType customerName orderDeliverydepositReceivedinstructionsFinalisedorderPaidInFull officeNotesdatezSO-1002zQ-502zINV-9002Localz Dip & Packz Jane SmithzCustomer CollectzYes - 15-06-2024YeszYes - 30-06-2024zPaid and readyz 2024-06-10zSO-1003zQ-503zINV-9003zFully Processed + D&Pz Robert BrownzPending depositz 2024-06-20a INSERT INTO customer_orders ( orderUniqueNumber, relatedQuoteNumber, relatedInvoiceNumber, orderType, processingType, customerName, orderDelivery, depositReceived, instructionsFinalised, orderPaidInFull, officeNotes, date ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s) r,r-r.r/r0r1r2r3r4r5r6r7) r?rVrWfetchoner\rXrZappendjoin executemanyintr[)r^r_cur2racolsalterscountsamplesrowmax_seqmissingseqquote_id_to_fillqno sample_ordersorders rG ensure_schemarLsw  Dpkkm  KK9 :<<>> ,  KK< =<<>>  ( ;;$;/D LL< =-1]]_-B-BD-BqEE'N-BDDF$& JKT) IJt+ JKT) HID( GH4' FGT! @AT) ABd" :; :TYYv=NNO  KK: ;<<>>  ;;$;/D LL: ;-1]]_-B-BD-BqEE'N-BDDFd" FG$& BC 8499V;LLM  KK: ;<<>> 0:  KKB C<<>> 35r 23||~~ KK#% N  KKL M  KK   KK? @<<>>   $ 12||~~ KK " H5  KK7 8LLN1%Ez: #,  KKK L   KK> ?<<>>     KK  /0||~~ KK(* X  KKI J  KK   KK ,,.CCCF,>#a&AFG KK '*lln&:&:<&:t&:G<C$+ q3s)n N+%,  KK  9:||~~ KK * BC||~~ KK   89||~~ KK   78||~~ KK  12||~~ KK .  KKK L  KK  89||~~ KK   <=||~~ KK   12||~~ KK+- ^  KKK L  KK  ;<||~~ KK ( 9:||~~ KK  9:||~~ KK   /0||~~ KK 2  KKI J  KK  ./||~~ KK &  wx  uv  ]^ 89||~~ KK 2*3*1,6!)&7$.%7'9-1'+#C( *3*1,6!(&2$0%7'9-2'9#3( *3*1,6!)&=$2%7'+-1'+#4( ;+MZ' 12E:N4OQVWmQnk*E2B,CU>EZo.6G0H%PgJh/0% 2Ff '" q   .   E,        E   6   x   \      ,   |       *      h      0=      N      t      l      6       x sn87g7g/ ;hh"C=h 7h;h,h'-Ah, 7h=7i97n81ii07j 7n8Ajj#7j4k 7n8k*k':n8=i>>n8 j n8jn8 j n8j  n8# j1-n80j11n84 k>n8kn8 kn8kn8 k$ n8#k$$n8' k51n84k55n88k== l n8 l  n8 ln8ln8 l-)n8,l--n80 l>:n8=l>>n8 m n8mn8 m n8m  n8# m1-n80m11n84 n>n8nn8 nn8nn8 n$ n8#n$$n8' n51n84n55n88o c\[5nUR5nSnSn[RS5nUR SU45 UR 5nU(aUR SXCU45 OUR SX#U45 UR 5 g!UR 5 f=f)z6Seed or update the default admin user in the database.adminzadmin@localhostz Admin@123(SELECT id FROM users WHERE username = %sz\UPDATE users SET password_hash=%s, role='admin', email=COALESCE(email, %s) WHERE username=%szUINSERT INTO users (username, email, password_hash, role) VALUES (%s, %s, %s, 'admin')N)r?rV pwd_contexthashrWr:r[)r^r_admin_username admin_email admin_hashrDs rGensure_admin_userrUBs  Dkkm '  %%k2  >@QRlln  KKn.9  KKgj9   s Ardr_rErFrGrara`s# L"Kt"D#*rFrac\rSrSr%Sr\\\S'Sr\\ \S'\ \S'\ \S'\ \S'\ \S'\ \S '\ \S 'Sr \\ \S 'Sr \\ \S 'Sr \\ \S 'Sr\\ \S'Sr\\ \S'Sr\\ \S'Sr\\ \S'Sr\\ \S'Sr\\ \S'Sr\\ \S'Sr\\ \S'Sr\\ \S'Sr\\ \S'\ \S'Sr\\ \S'Sr\\ \S'Sr\\ \S'Sr\\ \S'Srg)CustomerRecordifNr~customer_unique_numberstatus customer_type first_namessurnameemailcontact_numberwhatsapp_numberphysical_countryphysical_streetphysical_province_state physical_cityphysical_postal_code ship_country ship_streetship_province_state ship_cityship_postal_code referred_bypreferred_currency citizenshiprsa_idpassport_number documents office_notesrE)rZr[r\r]r~rr>r^rgrKrrnrorprqrrrsrtrurvrwrxryrzr|r}r~rr_rErFrGrfrffs:B ,0HSM0 K L O%)OXc])&*hsm*%)OXc])-1Xc]1#'M8C='*.(3-."&L(3-&!%K#%)-#-#Ix}#&*hsm*!%K#%(, , FHSM %)OXc])#Ix}#"&L(3-&rFrfc \rSrSr%\\S'Srg)ForgotPasswordRequestirlrEN)rZr[r\r]rr^r_rErFrGrrs OrFrc*\rSrSr%\\S'\\S'Srg)ResetPasswordRequestitoken new_passwordrENrYrErFrGrrs JrFrc8\rSrSr%Sr\\\S'Sr\\ \S'Sr \\\S'Sr \\ \S'Sr \\\S'Sr \\ \S'\ \S '\ \S '\\S '\ \S '\ \S 'Sr\\ \S'Sr\\ \S'Sr\\ \S'Sr\\ \S'Sr\\ \S'Sr\\ \S'Srg) OrderRecordiNr~order_unique_numberrelated_quote_idrelated_quote_numberrelated_invoice_idrelated_invoice_number order_typeprocessing_typerc customer_nameorder_deliverydeposit_receivedinstructions_finalisedorder_paid_in_fullr created_at updated_atrE)rZr[r\r]r~rr>r^rrKrrrrrrrrrrr_rErFrGrrsB )-#-&*hsm**.(3-.(, ,,0HSM0O&*hsm*,0HSM0(, ,"&L(3-& $J $ $J $rFrc\rSrSr%Sr\\\S'Sr\\ \S'\ \S'\ \S'\ \S'Sr \\ \S'\ \S '\ \S '\ \S '\ \S '\ \S '\ \S'\ \S'\ \S'\ \S'\ \S'\ \S'Sr \\ \S'Sr \\\S'Sr\\\S'Sr\\ \S'Sr\\ \S'Sr\\ \S'Sr\\ \S'Sr\\ \S'Sr\\ \S'Sr\\ \S'Srg) PartnerRecordiNr~partner_unique_numberrh partner_type company_name company_vat company_emailcompany_contact_numbercompany_countrycompany_streetcompany_province company_citycompany_postal_code first_namerkrlrmhunting_outfitter_idcomms_local_percentcomms_export_percentoutfitter_documentsprofessional_hunter_idprofessional_hunter_permit_type%professional_hunter_permit_issue_date&professional_hunter_permit_expiry_dateprofessional_hunter_documentsrrE)rZr[r\r]r~rr>r^rrKrrrrfloatrrrrrrrrr_rErFrGrrsB +/8C=/ K!%K#%O L O*.(3-.+/%/,0(5/0)-#-,0HSM059#Xc]9;?)8C=?<@*HSM@37!8C=7"&L(3-&rFrc\rSrSr%Sr\\\S'\\S'Sr \\\S'Sr \\\S'Sr \\\S'Sr \\\S'Sr \\\S 'Sr\\\S 'Sr\\\S 'Sr\\\S 'Sr\\\S 'Sr\\\S'Srg)CompanyInfoRecordiNr~rcompany_registration_numbercompany_vat_numberveterinary_approval_numbercompany_physical_addresscompany_postal_addressrcompany_phone_numbercompany_mobile_numbercompany_whatsapp_numbercompany_websiterE)rZr[r\r]r~rr>r^rKrrrrrrrrrrrr_rErFrGrrsB 15#5(, ,04 4.2hsm2,0HSM0(,M8H%,*.(3-.+/8C=/-1Xc]1%)OXc])rFrc\rSrSr%Sr\\\S'\\S'Sr \\\S'Sr \\\S'Sr \\\S'Sr \\\S'Sr \\\S 'Sr\\\S 'Sr\\\S 'Sr\\\S 'S rg)BankingDetailsRecordiNr~r r rrrrrrrvrE)rZr[r\r]r~rr>r^rKr rrrrrrrvr_rErFrGrrsB N"&L(3-&$(NHSM("&L(3-&!%K#% $J $D(3-"&L(3-&E8C=rFrc>\rSrSr%Sr\\\S'\\S'\\S'Sr g)BankingTermRecordiNr~rrrE) rZr[r\r]r~rr>r^rKr_rErFrGrrsB  JNrFrc\rSrSr%Sr\\\S'\\S'Sr \ \S'Sr \ \S'Sr \ \S'Sr \ \S 'Sr\ \S 'Sr\ \S 'Sr\ \S 'Sr\ \S 'Sr\ \S'Sr\ \S'Sr\ \S'Sr\ \S'Sr\ \S'Srg)MasterAnimalRecordiNr~ common_nameFdip_packtanning_of_skinsfelting_of_skins_add_on full_mountshoulder_mountwall_pedestal_shoulder_mountpedestal_shoulder_mountskull rug_mountafrica_map_mount half_mountopen_mouth_add_on miscellaneous_manufactured_itemsrE)rZr[r\r]r~rr>r^rKrboolrrrrrrrrrrrrr_rErFrGrrsB Hd"d"$)T)J ND ). $.$)T)E4It"d"J#t#-2$d2rFrc\rSrSr%Sr\\\S'\\S'Sr \\\S'Sr \\\S'Sr \\\S'Sr \\\S'Sr \\\S 'Sr\\\S 'Sr\\\S 'Sr\\\S 'Sr\\\S 'Sr\\\S'Sr\\\S'Sr\\\S'Sr\\\S'Sr\\\S'Sr\\\S'Sr\\\S'Sr\\\S'Sr\\\S'Sr\\\S'Sr\\\S'Sr\\\S'Sr\\\S'Sr\\\S'Sr \\\S'Sr!\\\S'Sr"\\\S'Sr#\\\S'Sr$\\\S 'Sr%\\\S!'Sr&\\\S"'Sr'\\\S#'Sr(\\\S$'Sr)\\\S%'Sr*\\\S&'Sr+\\\S''Sr,\\\S('Sr-\\\S)'Sr.\\\S*'Sr/\\\S+'Sr0\\\S,'Sr1\\\S-'Sr2\\\S.'Sr3\\\S/'Sr4\\\S0'Sr5\\\S1'Sr6\\\S2'S3r7g)4MasterAnimalPricingRecordiNr~rshoulder_mount_usdshoulder_mount_eurshoulder_mount_pulashoulder_mount_zar wall_pedestal_shoulder_mount_usd wall_pedestal_shoulder_mount_eur!wall_pedestal_shoulder_mount_pula wall_pedestal_shoulder_mount_zarpedestal_shoulder_mount_usdpedestal_shoulder_mount_eurpedestal_shoulder_mount_pulapedestal_shoulder_mount_zarfull_mount_usdfull_mount_eurfull_mount_pulafull_mount_zarfull_mount_note skull_usd skull_eur skull_pula skull_zar rug_mount_usd rug_mount_eurrug_mount_pula rug_mount_zartanning_of_skins_usdtanning_of_skins_eurtanning_of_skins_pulatanning_of_skins_zarfelting_of_skins_add_on_usdfelting_of_skins_add_on_eurfelting_of_skins_add_on_pulafelting_of_skins_add_on_zarafrica_map_mount_usdafrica_map_mount_eurafrica_map_mount_pulaafrica_map_mount_zarhalf_mount_usdhalf_mount_eurhalf_mount_pulahalf_mount_zardip_pack_price_usdopen_mouth_add_on_usdopen_mouth_add_on_europen_mouth_add_on_pulaopen_mouth_add_on_zarrE)8rZr[r\r]r~rr>r^rKrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr_rErFrGrrsB (, ,(, ,)-#-(, ,6:$hsm:6:$hsm:7;%x};6:$hsm:15#515#526 (3-615#5$(NHSM($(NHSM(%)OXc])$(NHSM(%)OXc])#Ix}##Ix}# $J $#Ix}##'M8C='#'M8C='$(NHSM(#'M8C='*.(3-.*.(3-.+/8C=/*.(3-.15#515#526 (3-615#5*.(3-.*.(3-.+/8C=/*.(3-.$(NHSM($(NHSM(%)OXc])$(NHSM((, ,+/8C=/+/8C=/,0HSM0+/8C=/rFrc\rSrSr%Sr\\\S'\\S'\\S'Sr \\\S'Sr \\\S'Sr \\\S'Sr \\\S 'Sr \\\S 'Sr\\\S 'S rg) DipPackPricingRecordi* Nr~ animal_group compositionrvrrrrhs_coderErZr[r\r]r~rr>r^rKrvrrrrrr_rErFrGrr* pB E8C=#Ix}##Ix}##Ix}##Ix}#!GXc]!rFrc&\rSrSr%\\\S'Srg)EnumUpdateRequesti5 valuesrEN)rZr[r\r]listrKr^r_rErFrGrr5 s IrFrc\rSrSr%Sr\\\S'\\S'\\S'Sr \\\S'Sr \\\S'Sr \\\S'Sr \\\S 'Sr \\\S 'Sr\\\S 'S rg) ri8 Nr~rrrvrrrrrrErrErFrGrr8 rrFc4\rSrSr%\\S'Sr\\\S'Srg)QuoteLineItemProcessRecordiD rNprocessing_subtyperE) rZr[r\r]rKr^r rr_rErFrGr r D s(, ,rFr c\rSrSr%\\S'\\S'Sr\\\S'\ \S'\ \S'Sr \\\S'S r \\S '/r \ \\S 'S rg) QuoteLineItemRecordiI item_quantity item_typeNspecies unit_price total_pricedetailed_instructionsDraftline_item_status processesrE)rZr[r\r]r>r^rKrrrrrrrr r_rErFrGrrI sQN!GXc]!+/8C=/#c#24It./4rFrc\rSrSr%Sr\\\S'Sr\\ \S'\ \S'\ \S'\ \S'Sr \\\S'\ \S '\ \S '\ \S '\ \S '\ \S '\ \S'Sr \\ \S'\ \S'\ \S'\ \S'\ \S'\ \S'\ \S'Sr \\ \S'Sr \\ \S'Sr\\ \S'Sr\\ \S'\ \S'Sr\\\S'Sr\\\S'Sr\\\S'Sr\\\S'Sr\\\S'Sr\\ \S 'Sr\\ \S!'Sr\\ \S"'/r\\\S#'/r\\ \S$'S%rg)&QuoteCreateRequestiT N partner_id partner_nameorder_no quote_daterrccustomer_first_namescustomer_surnamecustomer_emailcustomer_contact_numbercustomer_countrycustomer_streetcustomer_province_state customer_citycustomer_postal_coderrrrrrcompany_logo_url quote_statusquote_currency sub_total vat_amount total_amountdeposit_percentdeposit_amount_dueterms_and_conditionspayment_detailsr line_itemshs_codesrE)rZr[r\r]rrr>r^rrKrcr$rrr'r(r*rr+r,r-r.r/r0rr1rrr2r_rErFrGrrT sc $J $"&L(3-&MOO!%K#%  -1Xc]1!!(, ,15#5&*hsm*"&L(3-&!%Ix%"&J&$(L(5/('+OXe_+*..*.(3-.%)OXc])"&L(3-&,.J().Hd3irFrstartupc,[5 [5 gN)rLrUrErFrG on_startupr6 s OrFz/healthcSn[5nUR5nURS5 UR5 SSS.UbUR 5 $$![ a $f=f![ a>nSS[ U5S.sSnAUbUR 5 $$![ a $f=fSnAff=f!UbUR 5 ff![ a ff=f=f)NzSELECT 1T)okdbF)r8r9error)r?rVrWr:r[r\rKris rGhealthr; s D kkm J $'       :%#a&99       :      sw?A)A A&%A&) B13B,B1B4B B)(B),B11B44C6C  C CCCCz /partnersc[5nURSS9nURS5 UR5UR 5 $!UR 5 f=f)NTrSa SELECT id, partner_unique_number, status, partner_type, company_name, company_vat, company_email, company_contact_number, company_country, company_street, company_province, company_city, company_postal_code, first_name, surname, email, contact_number, hunting_outfitter_id, comms_local_percent, comms_export_percent, outfitter_documents, professional_hunter_id, professional_hunter_permit_type, professional_hunter_permit_issue_date, professional_hunter_permit_expiry_date, professional_hunter_documents, office_notes, created_at FROM partners ORDER BY created_at DESC r?rVrWrXr[r^r_s rG list_partnersr? sN  DkkTk*   ||~  /A Az /company-infoc[5nURSS9nURS5 UR5UR 5 $!UR 5 f=f)NTrSa" SELECT id, company_name, company_registration_number, company_vat_number, veterinary_approval_number, company_physical_address, company_postal_address, company_email, company_phone_number, company_mobile_number, company_whatsapp_number, company_website FROM company_info ORDER BY id DESC r=r>s rGlist_company_inforB sN  DkkTk*   $||~  r@z/company-info/{record_id}c[5nURSS9nURSU45 UR5nU(d [ SSS9eUUR 5 $!UR 5 f=f)NTrSa SELECT id, company_name, company_registration_number, company_vat_number, veterinary_approval_number, company_physical_address, company_postal_address, company_email, company_phone_number, company_mobile_number, company_whatsapp_number, company_website FROM company_info WHERE id = %s rRecord not foundrsr?rVrWr:rr[rr^r_rDs rGget_company_inforG sk  DkkTk*   L# &llnC8JK K  AA!!A3bodyc[5nUR5nURSUR[ UR 5[ UR 5[ UR5[ UR5[ UR5[ UR5[ UR5[ UR5[ UR5[ UR54 5 URnUR!5 SU0UR#5 $!UR#5 f=f)Na INSERT INTO company_info ( company_name, company_registration_number, company_vat_number, veterinary_approval_number, company_physical_address, company_postal_address, company_email, company_phone_number, company_mobile_number, company_whatsapp_number, company_website ) VALUES ( %s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s ) r~)r?rVrWrrOrrrrrrrrrrrrr[rIr^r_new_ids rGcreate_company_inforM s  D&kkm  $!!t??@t667t>>?t<<=t::;t112t889t99:t;;<t334 % @ f~  s DD11Ec[5nUR5nURSUR[ UR 5[ UR 5[ UR5[ UR5[ UR5[ UR5[ UR5[ UR5[ UR5[ UR5U4 5 URS:Xa [!SSS9eUR#5 SS0UR%5 $!UR%5 f=f)Na UPDATE company_info SET company_name=%s, company_registration_number=%s, company_vat_number=%s, veterinary_approval_number=%s, company_physical_address=%s, company_postal_address=%s, company_email=%s, company_phone_number=%s, company_mobile_number=%s, company_whatsapp_number=%s, company_website=%s WHERE id = %s rrrDrsrT)r?rVrWrrOrrrrrrrrrrrrrr[rrIr^r_s rGupdate_company_inforP s   D&kkm   !!t??@t667t>>?t<<=t::;t112t889t99:t;;<t334 ! > <<1 C8JK K 4   s D#EEc[5nUR5nURSU45 URS:Xa [ SSS9eSS0UR 5 $!UR 5 f=f)Nz&DELETE FROM company_info WHERE id = %srrrDrsrTr?rVrWrrr[rs rGdelete_company_inforSG s`  Dkkm  ? ~d.A.AB C ^D,=,=> ? N4+;+;< = >$//: ; ^DII. / ^D,=,=> ? nTZZ0 1  &-:WTQ qW :%,:WTQ qW :xx[)9 9:  +CHH[,A+B*\NZ[ \ +   f~ ;: s7CF++ F:FF+ F%F%A1F+ F++F=c[5nUR5n[S5n/n/nSU;a,URS5 URUR5 SU;a5URS5 UR[ UR 55 SU;a5URS5 UR[ UR55 SU;a5URS 5 UR[ UR55 S U;a5URS 5 UR[ UR55 S U;a5URS 5 UR[ UR55 SU;a5URS5 UR[ UR55 SU;a5URS5 UR[ UR55 SU;a5URS5 UR[ UR55 U(dSS0UR5 $URU5 URSSR!U5S3[#U55 UR$S:Xa ['SSS9eUR)5 SS0UR5 $!UR5 f=f)NrZr z bank_name=%sr zaccount_name=%srzaccount_number=%srzaccount_type=%srzbranch_code=%srz swift_code=%srziban=%srzbank_address=%srvznotes=%srTzUPDATE banking_details SET r WHERE id = %srrrDrs)r?rVrbr;r rOr rrrrrrrvr[rWr<r`rrrrrIr^r_r@updatesparamss rGupdate_banking_detailrn s*  D kkm!"34 $  NN> *FMM$..,I T ! NN, -v}}^DL]L]=^/_ t # NN. /~dNaNa?b1c T ! NN, -v}}^DL]L]=^/_ D NN+ ,fmmN4K[K[<\.] 4  NN? +V]]>$//;Z-[ T> NN9 %v}}^DII5N'O T ! NN, -v}}^DL]L]=^/_ d? NN: & nTZZ6P(Qt$   i  1$))G2D1E^TV[\bVcd <<1 C8JK K 4   sH3K A,K Kc[5nUR5nURSU45 URS:Xa [ SSS9eSS0UR 5 $!UR 5 f=f)Nz)DELETE FROM banking_details WHERE id = %srrrDrsrTrRrs rGdelete_banking_detailrp s`  Dkkm ?)N <<1 C8JK K4   rTz/banking-termsc0[5nURSS9nURS5 UR5=(d /nS[S[4SjnUVs/sH oC"U5PM snUR 5 $s snf!UR 5 f=f)NTrSz,SELECT * FROM banking_terms ORDER BY id DESCrDrQc :URS5=(d SnU(dURS5=(d) URS5=(d URS5nURS5=(dA URS5=(d) URS5=(d URS5nU(aU(aUS U3R5nO,U=(d# U=(d URS 5=(d S nURS 5=(d SnUczURS 5=(db URS5=(dJ URS5=(d2 URS5=(d URS5=(d S nURS5nU(aU(aUSU3OSU3nURS5U=(d S U=(d S URS 5URS5=(d) URS5=(d URS5URS5=(dA URS5=(d) URS5=(d URS5URS 5=(dY URS5=(dA URS5=(d) URS5=(d URS5URS5S.$)Nrr term_sectionheading clause_codecoder'label doc_contextrIr clause_texttextcontentrM descriptionnote Note: Note: r~)r~rrryrrurzr~)rZrL)rDr section_rawclause_code_rawrr~s rG normalize%list_banking_terms..normalize smGGG$,E!ggi0aCGGN4KaswwW`Oa "%''-"8"rCGGFO"rswwW]"rbebibijqbr?*m1_,=>DDFE+Z{Zcggm>TZXZE ,4I GGM2PcggfoPQZI[P_b_f_fgn_oPsvszsz|ItJPNP 776?D+B>BBz/banking-terms/{record_id}c[5nURSS9nURSU45 UR5nU(d [ SSS9eUR S5=(d) UR S5=(d UR S 5nUR S 5=(dA UR S 5=(d) UR S 5=(d UR S 5nUR S5=(dO U(aU(aUSU3R 5O+U=(d# U=(d UR S5=(d SnUR S5=(dz UR S5=(db UR S5=(dJ UR S5=(d2 UR S5=(d UR S5=(d SnUR S5nU(aU(aUSU3OSU3nUR S5U=(d SU=(d SS.UR5 $!UR5 f=f)NTrSz)SELECT * FROM banking_terms WHERE id = %srrDrsrrsrtrurvr'rwrrxryrIrrzr{r|rMr}r~rrr~)r~rr)r?rVrWr:rrZrLr[) rr^r_rDrrurrr~s rGget_banking_termr s   DkkTk* ?)NllnC8JK K'')$U(?U3779CUggm,ff3776?fVYV]V]^eVf  b7Wby+%?%E%E%Gitj`xj`DGDKDKLYDZj`^`GGK(`CGGM,B`cggfo`Y\Y`Y`ajYk`orovovw~o`DGDKDKLYDZ`^` wwv 8A9+XdV4PTvIwwt}u{VXZ  s H'IIc:[5nUR5n[S5nSUR4SUR4/nUVVs/sHupVXS;dM UPM nnnUVVs/sHupXXS;dM UPM n nnSR S/[ U 5-5n URSSR U5SU S3[U 55 URn UR5 S U 0UR5 $s snnfs snnf!UR5 f=f) N banking_termsrrr[r\zINSERT INTO banking_terms (r]r^r~) r?rVrbrrr<r_rWr`rrr[ras rGcreate_banking_termr s  Dkkm!/2 djj ! $.. ) &-:WTQ qW :%,:WTQ qW :xx[)9 9:  )#((;*?)@ <.XY Z +   f~ ;: s6 *FMM$..,It$   i  / '0B/C>RTYZ`Tab <<1 C8JK K 4   sB D'*A,D''D9c[5nUR5nURSU45 URS:Xa [ SSS9eSS0UR 5 $!UR 5 f=f)Nz'DELETE FROM banking_terms WHERE id = %srrrDrsrTrRrs rGdelete_banking_termr3 `  Dkkm = |L <<1 C8JK K4   rTz/master-animalsch[5nURSS9nURS5 UR5=(d /nUHBn[ UR 55H"nUS:wdM US:wdM[ X45X4'M$ MD UUR5 $!UR5 f=f)NTrSa SELECT id, common_name, dip_pack, tanning_of_skins, felting_of_skins_add_on, full_mount, shoulder_mount, wall_pedestal_shoulder_mount, pedestal_shoulder_mount, skull, rug_mount, africa_map_mount, half_mount, open_mouth_add_on, miscellaneous_manufactured_items FROM master_animal ORDER BY common_name r~r)r?rVrWrXrkeysrr[)r^r_r`rars rGlist_master_animalsr? s  DkkTk*   ||~#A!&&(^9m!3:AD$  sAB.B6BB1c [5nUR5nURSURR 5[ [ UR55[ [ UR55[ [ UR55[ [ UR55[ [ UR55[ [ UR55[ [ UR55[ [ UR55[ [ UR55[ [ UR 55[ [ UR"55[ [ UR$55[ [ UR&5545 UR(nUR+5 SU0UR-5 $!UR-5 f=f)Na INSERT INTO master_animal ( common_name, dip_pack, tanning_of_skins, felting_of_skins_add_on, full_mount, shoulder_mount, wall_pedestal_shoulder_mount, pedestal_shoulder_mount, skull, rug_mount, africa_map_mount, half_mount, open_mouth_add_on, miscellaneous_manufactured_items ) VALUES ( %s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s ) r~)r?rVrWrrLr>rrrrrrrrrrrrrrrrr[rKs rGcreate_master_animalrX s_  D!kkm    &&(D'(D../0D5567D)*D,,-.D::;<D5567D$%D()D../0D)*D//01D>>?@  6 f~  s GG00Hz/master-animals/{animal_id} animal_idc([5nUR5nURSURR 5[ [ UR55[ [ UR55[ [ UR55[ [ UR55[ [ UR55[ [ UR55[ [ UR55[ [ UR55[ [ UR55[ [ UR 55[ [ UR"55[ [ UR$55[ [ UR&55U45 UR(S:Xa [+SSS9eUR-5 SS0UR/5 $!UR/5 f=f)Na3 UPDATE master_animal SET common_name=%s, dip_pack=%s, tanning_of_skins=%s, felting_of_skins_add_on=%s, full_mount=%s, shoulder_mount=%s, wall_pedestal_shoulder_mount=%s, pedestal_shoulder_mount=%s, skull=%s, rug_mount=%s, africa_map_mount=%s, half_mount=%s, open_mouth_add_on=%s, miscellaneous_manufactured_items=%s WHERE id = %s rrAnimal not foundrsrT)r?rVrWrrLr>rrrrrrrrrrrrrrrrrr[)rrIr^r_s rGupdate_master_animalr su  D,kkm  &  &&(D'(D../0D5567D)*D,,-.D::;<D5567D$%D()D../0D)*D//01D>>?@ '$ J <<1 C8JK K 4   s G"G??Hc[5nUR5nURSU45 URS:Xa [ SSS9eSS0UR 5 $!UR 5 f=f)Nz'DELETE FROM master_animal WHERE id = %srrrrsrTrR)rr^r_s rGdelete_master_animalr rrTz/master-animal-pricingc[5nURSS9nURS5 UR5=(d /UR 5 $!UR 5 f=f)NTrSzj SELECT * FROM master_animal_pricing ORDER BY common_name r=r>s rGlist_master_animal_pricingr sV  D kkTk*   ||~##  s 8AA(cb[5nUR5nURS/URPURPUR PUR PURPURPURPURPURPURPURPURPURPUR PUR"PUR$PUR&P[)UR*5PUR,PUR.PUR0PUR2PUR4PUR6PUR8PUR:PUR<PUR>PUR@PURBPURDPURFPURHPURJPURLPURNPURPPURRPURTPURVPURXPURZPUR\PUR^PUR`PURbPURdP75 URfnURi5 SU0URk5 $!URk5 f=f)Na- INSERT INTO master_animal_pricing ( common_name, shoulder_mount_usd, shoulder_mount_eur, shoulder_mount_pula, shoulder_mount_zar, wall_pedestal_shoulder_mount_usd, wall_pedestal_shoulder_mount_eur, wall_pedestal_shoulder_mount_pula, wall_pedestal_shoulder_mount_zar, pedestal_shoulder_mount_usd, pedestal_shoulder_mount_eur, pedestal_shoulder_mount_pula, pedestal_shoulder_mount_zar, full_mount_usd, full_mount_eur, full_mount_pula, full_mount_zar, full_mount_note, skull_usd, skull_eur, skull_pula, skull_zar, rug_mount_usd, rug_mount_eur, rug_mount_pula, rug_mount_zar, tanning_of_skins_usd, tanning_of_skins_eur, tanning_of_skins_pula, tanning_of_skins_zar, felting_of_skins_add_on_usd, felting_of_skins_add_on_eur, felting_of_skins_add_on_pula, felting_of_skins_add_on_zar, africa_map_mount_usd, africa_map_mount_eur, africa_map_mount_pula, africa_map_mount_zar, half_mount_usd, half_mount_eur, half_mount_pula, half_mount_zar, dip_pack_price_usd, open_mouth_add_on_usd, open_mouth_add_on_eur, open_mouth_add_on_pula, open_mouth_add_on_zar ) VALUES ( %s,%s,%s,%s,%s, %s,%s,%s,%s, %s,%s,%s,%s, %s,%s,%s,%s,%s, %s,%s,%s,%s, %s,%s,%s,%s, %s,%s,%s,%s, %s,%s,%s,%s, %s,%s,%s,%s, %s, %s,%s,%s,%s ) r~)6r?rVrWrrrrrrrrrrrrrrrrrrOrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr[rKs rGcreate_master_animal_pricingr s  D4kkm  :    '' )-)@)@ BFBZBZ \`\s\s 55 8<7\7\ _c_E_E GKGlGl 00  372R2R  UYTuTu  x|xXxX   ##   &*%8%8   ;?:N:N   QUPcPc   fttxuIuIfJ      !%   15   BF  "" %)$6$6 9=8K8K NRM_M_ )) ,0+D+D GKF`F` cgb{b{ 00 372R2R UYTuTu x|xXxX )) ,0+D+D GKF`F` cgb{b{ ## &*%8%8 ;?:N:N QUPcPc '' ** -1,F,F IMHcHc fjee =- \ f~  s I?JJ.z#/master-animal-pricing/{pricing_id} pricing_idc[5nUR5nURS/URPURPUR PUR PURPURPURPURPURPURPURPURPURPUR PUR"PUR$PUR&P[)UR*5PUR,PUR.PUR0PUR2PUR4PUR6PUR8PUR:PUR<PUR>PUR@PURBPURDPURFPURHPURJPURLPURNPURPPURRPURTPURVPURXPURZPUR\PUR^PUR`PURbPURdPUP75 URfS:Xa [iSSS9eURk5 SS0URm5 $!URm5 f=f)Na UPDATE master_animal_pricing SET common_name=%s, shoulder_mount_usd=%s, shoulder_mount_eur=%s, shoulder_mount_pula=%s, shoulder_mount_zar=%s, wall_pedestal_shoulder_mount_usd=%s, wall_pedestal_shoulder_mount_eur=%s, wall_pedestal_shoulder_mount_pula=%s, wall_pedestal_shoulder_mount_zar=%s, pedestal_shoulder_mount_usd=%s, pedestal_shoulder_mount_eur=%s, pedestal_shoulder_mount_pula=%s, pedestal_shoulder_mount_zar=%s, full_mount_usd=%s, full_mount_eur=%s, full_mount_pula=%s, full_mount_zar=%s, full_mount_note=%s, skull_usd=%s, skull_eur=%s, skull_pula=%s, skull_zar=%s, rug_mount_usd=%s, rug_mount_eur=%s, rug_mount_pula=%s, rug_mount_zar=%s, tanning_of_skins_usd=%s, tanning_of_skins_eur=%s, tanning_of_skins_pula=%s, tanning_of_skins_zar=%s, felting_of_skins_add_on_usd=%s, felting_of_skins_add_on_eur=%s, felting_of_skins_add_on_pula=%s, felting_of_skins_add_on_zar=%s, africa_map_mount_usd=%s, africa_map_mount_eur=%s, africa_map_mount_pula=%s, africa_map_mount_zar=%s, half_mount_usd=%s, half_mount_eur=%s, half_mount_pula=%s, half_mount_zar=%s, dip_pack_price_usd=%s, open_mouth_add_on_usd=%s, open_mouth_add_on_eur=%s, open_mouth_add_on_pula=%s, open_mouth_add_on_zar=%s WHERE id = %s rrPricing not foundrsrT)7r?rVrWrrrrrrrrrrrrrrrrrrOrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr[)rrIr^r_s rGupdate_master_animal_pricingr s  D*kkm  "    '' )-)@)@ BFBZBZ \`\s\s 55 8<7\7\ _c_E_E GKGlGl 00  372R2R  UYTuTu  x|xXxX   ##   &*%8%8   ;?:N:N   QUPcPc   fttxuIuIfJ      !%   15   BF  "" %)$6$6 9=8K8K NRM_M_ )) ,0+D+D GKF`F` cgb{b{ 00 372R2R UYTuTu x|xXxX )) ,0+D+D GKF`F` cgb{b{ ## &*%8%8 ;?:N:N QUPcPc '' ** -1,F,F IMHcHc fjee  %" F <<1 C8KL L 4   s JJ,,J>c[5nUR5nURSU45 URS:Xa [ SSS9eSS0UR 5 $!UR 5 f=f)Nz/DELETE FROM master_animal_pricing WHERE id = %srrrrsrTrR)rr^r_s rGdelete_master_animal_pricingr9 s`  Dkkm E }U <<1 C8KL L4   rTz/items/african-map-mountcv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSz SELECT id, animal_common_name, frame, add_on, base_price_usd, add_on_price_usd, notes FROM african_map_mount ORDER BY animal_common_name rdrerfris rGlist_items_african_map_mountrG rlrmz/items/bird-speciescp[5nURSS9nURS5 UR5=(d /UR 5 $![ R Ran[USS5S:waeURS5 UR5=(d /sSnAUR 5 $![ R Ra3n[USS5S:Xa/sSnAsSnAUR 5 $eSnAff=fSnAff=f!UR 5 f=f)NTrSz~SELECT id, common_name, scientific_name, cites_status, tops_status FROM item_bird_species ORDER BY common_namerdrez}SELECT id, common_name, scientific_name, cites_status, tops_status FROM bird_species ORDER BY common_name r?rVrWrXr[r@rArgrhr^r_e1e2s rGlist_items_bird_speciesr^ s  DkkTk*  KK? <<>'R '" !$$ r7D)T1  >||~++ ??(( 2w-5II    pD#)AD 5D)C1D 2D#D%D7D8D<D =D#DDDD  D##D5z/items/dip-pack-pricingcp[5nURSS9nURS5 UR5=(d /UR 5 $![ R Ran[USS5S:waeURS5 UR5=(d /sSnAUR 5 $![ R Ra3n[USS5S:Xa/sSnAsSnAUR 5 $eSnAff=fSnAff=f!UR 5 f=f)NTrSzSELECT id, animal_group, composition, notes, price_usd, hs_code FROM dip_pack_pricing ORDER BY animal_group, compositionrdrezSELECT id, animal_group, composition, notes, price_usd, hs_code FROM item_dip_pack ORDER BY animal_group, compositionrrs rGlist_items_dip_pack_pricingr} s  DkkTk*  KKL <<>'R '" !$$ r7D)T1  M||~++ ??(( 2w-5II    rz/items/line-item-dip-packcv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSa& SELECT id, category, size_type, name, feet_count, notes, price_zar, price_usd, price_eur, price_bwp, is_active FROM line_item_dip_pack WHERE is_active = 1 ORDER BY category, size_type, name rdrerfris rGlist_items_line_item_dip_packr s  DkkTk*  KK ||~## $$ q'4(D0      rmcnSS/nUH=nURU5=(d SR5(aM2[SSU3S9e [5nUR 5nUR SURS5[ URS55URS5[ URS 55[ URS 55[ URS 55[ URS 55[ URS 55[ URS55[URSS55R5S;aSOS4 5 UR5 SUR0UR5 $!UR5 f=f)Nrpr'rIrqrrrsz INSERT INTO line_item_dip_pack (category, size_type, name, feet_count, notes, price_zar, price_usd, price_eur, price_bwp, is_active) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s) size_type feet_countrvrrrrrwrxryr}rr~rrs rGcreate_line_item_dip_packr s[F#H  A$"++--C:RSTRU8VW W  Dkkm    J'w{{;78 F#w{{<89w{{734w{{;78w{{;78w{{;78w{{;78[#67==?G^^de   & cmm$  rz%/items/line-item-dip-pack/{record_id}c[5nUR5nURSURS5[ URS55URS5[ URS55[ URS55[ URS55[ URS55[ URS 55[ URS 55[ URS S 55R 5S ;aSOSU4 5 URS:Xa [SSS9eUR5 SS0UR5 $!UR5 f=f)Nz UPDATE line_item_dip_pack SET category=%s, size_type=%s, name=%s, feet_count=%s, notes=%s, price_zar=%s, price_usd=%s, price_eur=%s, price_bwp=%s, is_active=%s WHERE id=%s rprr'rrvrrrrrwrxryr}rrDip & Pack line item not foundrsrTrrs rGupdate_line_item_dip_packr s+  Dkkm   J'w{{;78 F#w{{<89w{{734w{{;78w{{;78w{{;78w{{;78[#67==?G^^de  , <<1 C8XY Y 4   rc[5nUR5nURSU45 URS:Xa [ SSS9eUR 5 SS0UR 5 $!UR 5 f=f)Nz*DELETE FROM line_item_dip_pack WHERE id=%srrrrsrTrrs rGdelete_line_item_dip_packr si  Dkkm @9,O <<1 C8XY Y 4   rc [5nUR5nURSURUR[ UR 5UR=(d SUR=(d SUR=(d SUR=(d S[ UR545 URnUR5 SU0UR5 $!UR5 f=f)Nz INSERT INTO dip_pack_pricing ( animal_group, composition, notes, price_zar, price_usd, price_eur, price_bwp, hs_code ) VALUES (%s,%s,%s,%s,%s,%s,%s,%s) Not Applicabler~)r?rVrWrrrOrvrrrrrrrr[rKs rGcreate_items_dip_pack_pricingr s  Dkkm  !!  tzz*2"22"22"22"2t||,  & f~  CC,,C>z#/items/dip-pack-pricing/{record_id}c  [5nUR5nURSURUR[ UR 5UR=(d SUR=(d SUR=(d SUR=(d S[ UR5U4 5 URS:Xa [SSS9eUR5 SS0UR5 $!UR5 f=f) Nz UPDATE dip_pack_pricing SET animal_group=%s, composition=%s, notes=%s, price_zar=%s, price_usd=%s, price_eur=%s, price_bwp=%s, hs_code=%s WHERE id=%s rrrDip & Pack row not foundrsrT)r?rVrWrrrOrvrrrrrrrrr[rOs rGupdate_items_dip_pack_pricingr' s  Dkkm  !!  tzz*2"22"22"22"2t||,  ( <<1 C8RS S 4   s CC;;D c[5nUR5nURSU45 URS:Xa [ SSS9eUR 5 SS0UR 5 $!UR 5 f=f)Nz(DELETE FROM dip_pack_pricing WHERE id=%srrrrsrTrrs rGdelete_items_dip_pack_pricingrH si  Dkkm > M <<1 C8RS S 4   r)dip_pack_pricingr) item_dip_packr) fullmountr)r standard_pose)r special_pose)radd_on)item_full_mountr)rr)rr)rr)african_map_mountframe)rr)item_african_map_mountr)rr) bird_species cites_status)r tops_status)item_bird_speciesr)rr)r variation)rr)item_half_mountr)rr) misc_products sub_category)item_misc_productsr)rtype)rr)item_rug_mountr)rr)rr)rspecial_variation)rr)item_shoulder_mountr)rr)rr)skinsr)rr)rleather_tan_color)rr) item_skinsr)rr)rr)rr)skulls skull_type)rr)rsurcharge_type)r special_base) item_skullsr)rr)rr)rr)rrrr!item_wall_pedestal_shoulder_mountrrr)rrr SAFE_ENUMS column_typec8UR5RS5(d/$XRS5S-URS5n/nSnSnSnU[ U5:a{XnUS:Xa6U(a'US-[ U5:aXS-S:Xa US- o5S- nO-U(+nO%US :XaU(dUR U5 SnOX6- nUS- nU[ U5:aM{U(aUR U5 S U5Vs/sH owS:wdM UPM sn$s snf) Nzenum((r}r^rIFr'r[c3@# UHoR5v M g7fr5)rL).0ss rG #_parse_enum_list.. s/3a 3s)lower startswithfindrfindr_r;)rinneroutcurrentin_quoteichrNs rG_parse_enum_listr s     ) )' 2 2 ((-a/ 0A0A#0F GECGH A c%j. X 9AECJ.51:3D3Q'< 3Yx JJw G MG Q c%j. 7/3/ ;/!7A/ ;; ;s  DDrc |SRUVs/sHnSURSS5-S-PM sn5$s snf)Nr[rz'')r<replace)rrNs rG_quote_enum_valuesr s8 88vFv!S199S$//#5vF GGFs"9z/admin/enums/{table}/{column}tablecolumnc>X4[;a [SSS9e[X4up#[5nURSS9nUR SX#45 UR 5nU(GdUS:Xa%UR SS U45 UR 5nO*US :Xa$UR SS U45 UR 5nU(GdUS :Xa$UR S SU45 UR 5nU(d*US:Xa$UR S SU45 UR 5nU(d*US:Xa$UR S SU45 UR 5nU(d*US:Xa$UR S SU45 UR 5nU(d*US:Xa$UR S SU45 UR 5nU(d*US:Xa$UR S SU45 UR 5nU(d*US:Xa$UR S SU45 UR 5nU(d*US:Xa$UR S SU45 UR 5nU(d [SSS9e[ US=(d S 5US!S":HUS#S$.UR5 $!UR5 f=f)%NrqUnsupported enum columnrsTrSz SELECT COLUMN_TYPE, IS_NULLABLE, COLUMN_DEFAULT FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = %s AND COLUMN_NAME = %s rz SELECT COLUMN_TYPE, IS_NULLABLE, COLUMN_DEFAULT FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = %s AND COLUMN_NAME = %s rrrrz SELECT COLUMN_TYPE, IS_NULLABLE, COLUMN_DEFAULT FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = %s AND COLUMN_NAME = %s rrrrrrrrrrrrrrrrzColumn not found COLUMN_TYPErI IS_NULLABLEYESCOLUMN_DEFAULT)rnullabledefault)rrr?rVrWr:rr[)rr target_table target_columnr^r_rDs rGget_enum_valuesr  s j(4MNN",e_"=L  DBkkTk*    )  lln|+  m, lln!DD  4]C lln=0KK "=1 ,,.C|/@@KK %m4 ,,.C|/GGKK -m< ,,.C|/@@KK &}5 ,,.C|/BBKK (7 ,,.C|/??KK %m4 ,,.C|/CCKK )-8 ,,.C|/DDKK *=9 ,,.C'C@RSS&s='9'?R@M*e3+,  s I J JcX4[;a [SSS9eUR(d [SSS9e[X4up4[5nUR 5n[ UR5nSUSUSUS3nUR U5 UR5 S S 0UR5 $!UR5 f=f) NrqrrszMust include at least one valuez ALTER TABLE `z ` MODIFY `z` ENUM(z ) NOT NULLrT) rrrr?rVrrWrr[) rrrIr r r^r_quotedsqls rGupdate_enum_valuesr>s j(4MNN ;;4UVV",e_"=L  Dkkm#DKK0l^:m_GF8S]^ C 4   s AB..Cz/items/full-mountcv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSzSELECT id, animal_common_name, base_type, standard_pose, special_pose, base_price_usd, add_on, add_on_price_usd, notes FROM fullmount ORDER BY animal_common_namerdrerfris rGlist_items_full_mountrQs  DkkTk*  KKE ||~## $$ q'4(D0     rmz/items/half-mountcv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSzSELECT id, animal_common_name, variation, base_price_usd, add_on, add_on_price_usd, pricing_rule_note, notes FROM half_mount ORDER BY animal_common_namerdrerfris rGlist_items_half_mountres  D kkTk*  KK? ||~## $$ q'4(D0     rmz/items/misc-productscv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSzSELECT id, sub_category, product_name, option_name, price_usd, internal_note FROM misc_products ORDER BY sub_category, product_namerdrerfris rGlist_items_misc_productsrxs  D kkTk*  KKJ ||~## $$ q'4(D0     rmz/items/item-misc-productscv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSzSELECT id, sub_category, product_name, option_name, price_usd, internal_note FROM item_misc_products ORDER BY sub_category, product_namerdrerfris rGlist_item_misc_productsrs  D kkTk*  KKO ||~## $$ q'4(D0     rmc FSS/nUH=nURU5=(d SR5(aM2[SSU3S9e [5nUR 5nUR SURS5URS5[ URS55[ URS 55[ URS 5545 UR5 S UR0UR5 $!UR5 f=f) Nr product_namerIrqrrrsz INSERT INTO item_misc_products (sub_category, product_name, option_name, price_usd, internal_note) VALUES (%s, %s, %s, %s, %s) option_namerrr~) rZrLrr?rVrWrOrrr[rs rGcreate_item_misc_productrs/H  A$"++--C:RSTRU8VW W  Dkkm    N+ N+w{{=9:w{{;78w{{?;<    cmm$  s B*DD z%/items/item-misc-products/{record_id}c [5nUR5nURSURS5URS5[ URS55[ URS55[ URS55U45 UR S:Xa [ SS S 9eUR5 S S 0UR5 $!UR5 f=f) Nz UPDATE item_misc_products SET sub_category=%s, product_name=%s, option_name=%s, price_usd=%s, internal_note=%s WHERE id=%s rrrrrrrMisc product not foundrsrT) r?rVrWrZrOrrrr[rs rGupdate_item_misc_productrs  Dkkm    N+ N+w{{=9:w{{;78w{{?;<     <<1 C8PQ Q 4   s B;CC*c[5nUR5nURSU45 URS:Xa [ SSS9eUR 5 SS0UR 5 $!UR 5 f=f)Nz*DELETE FROM item_misc_products WHERE id=%srrrrsrTrrs rGdelete_item_misc_productr si  Dkkm @9,O <<1 C8PQ Q 4   rz/items/rug-mountcv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSzSELECT id, animal_common_name, type, base_price_usd, add_on, add_on_price_usd, notes FROM rug_mount ORDER BY animal_common_namerdrerfris rGlist_items_rug_mountr"s  D kkTk*  KK> ||~## $$ q'4(D0     rmz/items/shoulder-mountcv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSzSELECT id, animal_common_name, variation, special_variation, base_price_usd, add_on, add_on_price_usd, notes FROM shoulder_mount ORDER BY animal_common_namerdrerfris rGlist_items_shoulder_mountr$s  D kkTk*  KKC ||~## $$ q'4(D0     rmz /items/skinsc[5nURSS9nURS5 UR5=(d /UR5 $![RR aVn[ USS5S:Xa?URS5 UR5=(d /sSnAUR5 $eSnAff=f!UR5 f=f)NTrSzSELECT id, animal_common_name, skin_type, tanning_type, base_price_usd, add_on, add_on_price_usd, surcharge_note FROM skins ORDER BY animal_common_namerdrezSELECT id, animal_common_name, skin_type, tanning_type, base_price_usd, add_on, add_on_price_usd, surcharge_note FROM item_skins ORDER BY animal_common_name) r?rVrWr@rArgrhrXr[ris rGlist_items_skinsr& s  DkkTk*  KK: ||~## $$ q'4(D0 C||~++    s?CACC 5:C/C 0CCC  CC z /items/skullscv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSzSELECT id, animal_common_name, skull_type, base_price_usd, discount_percent, add_on, add_on_price_usd, surcharge_type, surcharge_percent, notes FROM skulls ORDER BY animal_common_namerdrerfris rGlist_items_skullsr(!s  DkkTk*  KK; ||~## $$ q'4(D0     rmz#/items/wall-pedestal-shoulder-mountcv[5nURSS9nURS5 UR5=(d /UR5 $![RR a.n[ USS5S:Xa/sSnAUR5 $eSnAff=f!UR5 f=f)NTrSzSELECT id, animal_common_name, variation, base_price_usd, add_on, add_on_price_usd, notes FROM wall_pedestal_shoulder_mount ORDER BY animal_common_namerdrerfris rGlist_items_wpsmr*5s  D kkTk*  KKQ ||~## $$ q'4(D0     rmz/partners/{partner_id}rc[5nURSS9nURSU45 UR5nU(d [ SSS9eUUR 5 $!UR 5 f=f)NTrSa SELECT id, partner_unique_number, status, partner_type, company_name, company_vat, company_email, company_contact_number, company_country, company_street, company_province, company_city, company_postal_code, first_name, surname, email, contact_number, hunting_outfitter_id, comms_local_percent, comms_export_percent, outfitter_documents, professional_hunter_id, professional_hunter_permit_type, professional_hunter_permit_issue_date, professional_hunter_permit_expiry_date, professional_hunter_documents, office_notes, created_at FROM partners WHERE id = %s rPartner not foundrsrE)rr^r_rDs rG get_partnerr-Hsk  DkkTk*  M llnC8KL L  rHz/quotesFz(If true, return only soft-deleted quotes)r}deletedc[5nURSS9nU(aURS5 OURS5 UR5UR 5 $!UR 5 f=f)NTrSa SELECT id, quote_unique_number, partner_id, partner_name, order_no, quote_date, order_type, customer_id, customer_first_names, customer_surname, quote_status, quote_currency, sub_total, vat_amount, total_amount, deposit_percent, deposit_amount_due, created_at FROM quotes WHERE deleted_at IS NOT NULL ORDER BY created_at DESC a SELECT id, quote_unique_number, partner_id, partner_name, order_no, quote_date, order_type, customer_id, customer_first_names, customer_surname, quote_status, quote_currency, sub_total, vat_amount, total_amount, deposit_percent, deposit_amount_due, created_at FROM quotes WHERE deleted_at IS NULL ORDER BY created_at DESC r=)r.r^r_s rG list_quotesr0esd  D8kkTk*  KK 4 KK 2||~  s AA%%A7z/quotes/{quote_id}quote_idc[5nURSS9nURSU45 UR5nU(d [ SSS9eURSU45 UR 5=(d /n0nU(aUVs/sHofSPM nnS R S /[U5-5nURS US 3[U55 UR 5=(d /H'n URU S /5RU 5 M) UHn URU S/5U S'M URSU45 UR 5=(d /V s/sHoSPM n n URSU45 UR 5=(d /n XCS'XS'XS'UUR5 $s snfs sn f!UR5 f=f)NTrSzk SELECT * FROM quotes WHERE id = %s AND deleted_at IS NULL rQuote not foundrsz| SELECT * FROM quote_line_items WHERE quote_id = %s ORDER BY id r~r[r\z?SELECT * FROM quote_line_item_processes WHERE line_item_id IN (r^ line_item_idrz6SELECT hs_code FROM quote_hs_codes WHERE quote_id = %srwSELECT id, file_url, file_name, mime_type, created_at FROM quote_documents WHERE quote_id = %s ORDER BY created_at DESCr1r2r~) r?rVrWr:rrXr<r_r` setdefaultr;rZr[)r1r^r_quoteitemsitem_id_to_processesrDitem_idsformat_stringspitrar2r~s rG get_quoter>s  D8kkTk*   K   C8IJ J   K  $"79 -23UcD UH3 XXtfs8}&<=N KKQR`Qaabch \\^)r)$//.0A2FMMaP*"6":":2d8R"H; LxkZ+.<<>+?R+?A+?QiL+?A  F K LLN(b #l$j&k 74B s+APUR@PURBP[EURF5P[EURH5P[EURJ5PURL=(d SPURPUPUPUPUPUP[EURN5P[EURP5P[EURR5PUP75 U RTS:Xa [SSS9eU RSU45 U RW5=(d /V s/sHoSPM n n U (a=SRYS/[[U 5-5n U RSU S3[]U 55 U RSU45 UR(GaUR5nURHnURSXR^UR`[EURb5URdURf[EURh5URj=(d S45 URlnURn(dMUR5nURnH5nURSUURp[EURr545 M7 M U RSU45 URt(a7UR5nURtHnURSUU45 M URw5 URSS 9nURS!U45 UR5=(d 0nUURyS"5X$XVUS#.UR{5 $s sn f!UR{5 f=f)$Nc3J# UHoR=(d Sv M g7frNrrlis rGrupdate_quote..L(:" 1 (:!#r8333333?ZARQ@r*USDEURI@BWPY@zKSELECT quote_unique_number FROM quotes WHERE id = %s AND deleted_at IS NULLrr3rsa< UPDATE quotes SET partner_id=%s, partner_name=%s, order_no=%s, quote_date=%s, order_type=%s, customer_id=%s, customer_first_names=%s, customer_surname=%s, customer_email=%s, customer_contact_number=%s, customer_country=%s, customer_street=%s, customer_province_state=%s, customer_city=%s, customer_postal_code=%s, company_name=%s, company_physical_address=%s, company_phone_number=%s, company_email=%s, company_vat_number=%s, company_registration_number=%s, company_logo_url=%s, quote_status=%s, quote_currency=%s, sub_total=%s, vat_amount=%s, total_amount=%s, deposit_percent=%s, deposit_amount_due=%s, terms_and_conditions=%s, payment_details=%s, office_notes=%s WHERE id = %s Draft - In Progressrz3SELECT id FROM quote_line_items WHERE quote_id = %sr[r\z=DELETE FROM quote_line_item_processes WHERE line_item_id IN (r^z0DELETE FROM quote_line_items WHERE quote_id = %s INSERT INTO quote_line_items ( quote_id, item_quantity, item_type, species, unit_price, total_price, detailed_instructions, line_item_status ) VALUES (%s,%s,%s,%s,%s,%s,%s,%s) rkINSERT INTO quote_line_item_processes (line_item_id, processing_type, processing_subtype) VALUES (%s,%s,%s)z.DELETE FROM quote_hs_codes WHERE quote_id = %s=INSERT INTO quote_hs_codes (quote_id, hs_code) VALUES (%s,%s)TrSz4SELECT quote_unique_number FROM quotes WHERE id = %squote_unique_numberr~rZr*r+r,r-r.)>r*sumr1rr+roundr,r-r)r.r?start_transactionrVrWr:rrrrrrcrrr r!r"r#r$r%r&rrrrrOrrr'r(r/r0rrrXr<r_r`rrrrrrrrrrr r2rrZr[)r1rnr*vat_rater+r,r-r.r^r_rDrar: in_clausecur_lirGr4cur_procprcur_hsrvr?row2s rG update_quoterfsz&-%6%6%B!!L(/(:(:LII))W4t#H'.'9'9'E##5QZQeghKiJ+2+?+?+K7''QVW`WmopQqL--O    (W-C-Cu-L"O   8 +0F0F.0X"O   8 +0F0F%0O"O"O7>7Q7Q7]33chiuLQzQjRTUdV  DW  kkm adlcnollnC8IJ J   "" $+$8$8 :A:J:J LSL^L^ `g`r`r ## %,%A%A CJC[C[ ]d]s]s u|vUvU (( +2*A*A DKCbCb eldydy |C|X|X $$ '.&F&F IPHdHd gnf{f{  w99:  =K7KnKn)>  BIAWAW  & (4 6E GY w;;< ?MWMdMd>e hvv}wKwKhL   2 <<1 C8IJ J IH;W#&<<>#7R#79#7QaD#79 $#h-!78I KKWXaWbbcdfkltfu v F T    [[]F(( !"2"2BLL.QSQ[Q[B\^`^k^kmom{m{~LMOMeMe~fiki|i|iG@G  &// <<<#{{}H ll ((J)2+=+=~bNcNc?de+)* DxkR   [[]F((St$) {{d{+ Kh[Y}}$"txx@U7Ven[gcuv ]:\ s'H>W!WDW!6DW!W!!W3z/quotes/{quote_id}/restorec[5nUR5nURSU45 URS:Xa [ SSS9eUR 5 SS0UR 5 $!UR 5 f=f)NzLUPDATE quotes SET deleted_at = NULL WHERE id = %s AND deleted_at IS NOT NULLrrzQuote not found or not deletedrsrTrr@s rG restore_quoterhcsn  D kkm Z K  <<1 C8XY Y 4   rz/quotes/{quote_id}/permanentc[5nUR5nURSU45 URS:Xa [ SSS9eUR 5 SS0UR 5 $!UR 5 f=f)Nz DELETE FROM quotes WHERE id = %srrr3rsrTrr@s rGpermanently_delete_quoterjtsi  D kkm 6 D <<1 C8IJ J 4   rc  URb URO[SUR55nURS:XaSOSnURb URO [ X-S5nUR b UR O [ X-S5nURnUckURS:XaURS:XaSnOHURS:XaURS ;aS nO%URS:XaURS :XaSnOS nURb URO[ XES - -S5n[5nUR5 UR5nURS 5 UR5n [U (a U SbU SOS5n [U (a U SbU SOS5n [!X5S-n SU S3n URS/U PUR"PUR$PUR&PUR(PURPUR*PUR,PUR.PUR0PUR2PUR4PUR6PUR8PUR:PUR<PUR>PUR@PURBPURDP[GURH5P[GURJ5P[GURL5PURN=(d SPURPUPUPUPUPUP[GURP5P[GURR5P[GURT5P75 URVnUR(GaUR5nURHnURSUURXURZ[GUR\5UR^UR`[GURb5URd=(d S45 URVnURf(dMUR5nURfH5nURSUURh[GURj545 M7 M URl(a7UR5nURlHnURSUU45 M URo5 XXXEUS.URq5 $![ra)nURu5 Ue![ra Uef=fSnAff=f!URq5 f=f)Nc3J# UHoR=(d Sv M g7frDrErFs rGrcreate_quote..rIrJr8rKrLrMrNrOr*rPrSrTrUz SELECT COALESCE(MAX(CAST(SUBSTRING(quote_unique_number, 3) AS UNSIGNED)), 0) AS max_seq, COUNT(*) AS row_count FROM quotes rr}r(r)a INSERT INTO quotes ( quote_unique_number, partner_id, partner_name, order_no, quote_date, order_type, customer_id, customer_first_names, customer_surname, customer_email, customer_contact_number, customer_country, customer_street, customer_province_state, customer_city, customer_postal_code, company_name, company_physical_address, company_phone_number, company_email, company_vat_number, company_registration_number, company_logo_url, quote_status, quote_currency, sub_total, vat_amount, total_amount, deposit_percent, deposit_amount_due, terms_and_conditions, payment_details, office_notes ) VALUES ( %s, %s,%s,%s,%s,%s, %s,%s,%s,%s,%s, %s,%s,%s,%s,%s, %s,%s,%s,%s, %s,%s,%s, %s,%s, %s,%s,%s,%s,%s, %s,%s,%s ) rVrWrrXrYr[);r*r\r1rr+r]r,r-r)r.r?r^rVrWr:r>maxrrrrrcrrr r!r"r#r$r%r&rrrrrOrrr'r(r/r0rrrrrrrrrrrr r2rr[r\rollback)rnr*r_r+r,r-r.r^r_row_maxrE row_countnext_seqnext_quote_numberr1rarGr4rbrcrdrvrjs rG create_quoterts&&-%6%6%B!!L(/(:(:LII))W4t#H'.'9'9'E##5QZQeghKiJ+2+?+?+K7''QVW`WmopQqL--O    (W-C-Cu-L"O   8 +0F0F.0X"O   8 +0F0F%0O"O"O7>7Q7Q7]33chiuLQzQjRTUdV  Dd  kkm   ,,.G 0FgajANg'!*2H aP w*Q. #/  . ! "" $+$8$8 :A:J:J LSL^L^ `g`r`r ## &-%A%A DKC[C[ ^e]s]s v}vUvU (( +2*A*A DKCbCb eldydy |C|X|X  $$  '.&F&F  IPHdHd  gnf{f{  w99:  =K7KnKn)> BIAWAW  & (4 6E GY w;;< ?MWMdMd>e hvv}wKwKhL 1# H==    [[]F(( !""2"2BLL.QSQ[Q[B\^`^k^kmom{m{~LMOMeMe~fiki|i|iG@G  &// <<<#{{}H ll ((J)2+=+=~bNcNc?de+),   [[]F((St$) W`MYUgh    MMO    sJLTB7T U "T42U4 U>UUUU  U Uz/quotes/{quote_id}/documentsc[5nURSS9nURSU45 UR5UR 5 $!UR 5 f=f)NTrSr5r=r@s rGlist_quote_documentsrvsT  DkkTk*  F K ||~  1AA .filec\[RR[SU35n[R"USS9 [ [ R"5R55S[R"S5SUR3n[RRX#5n[US5nURURR55 SSS5 [RR!U[5R#SS5n[%5nUR'5nUR)S XURUR*45 UR,n U S U3S .UR/5 $!,(df  N=f!UR/5 f=f) Nquote_Tr$rdwb\/z[INSERT INTO quote_documents (quote_id, file_url, file_name, mime_type) VALUES (%s,%s,%s,%s) /uploads/)r~file_urlospathr<r"makedirsr>rutcnow timestampsecrets token_hexfilenameopenwriterxreadrelpathrr?rVrW content_typerr[) r1rxsafe_dir unique_name file_pathrrel_pathr^r_doc_ids rGupload_quote_documentrs9ww||J& (;s rG list_hs_codesr)s  D kkTk*  KK< =||~~ de||~  ]^||~     s/B5AB%3!B5% B2/B51B22B55Cc[5nUR5nURSUR=(d SURUR UR URURURURURURURURURUR UR"[%UR&5UR(UR*[%UR,5[%UR.5[%UR05[%UR25[%UR45[%UR65[%UR8545 UR:nUR=5 SU0UR?5 $!UR?5 f=f)Na  INSERT INTO partners ( status, partner_type, company_name, company_vat, company_email, company_contact_number, company_country, company_street, company_province, company_city, company_postal_code, first_name, surname, email, contact_number, hunting_outfitter_id, comms_local_percent, comms_export_percent, outfitter_documents, professional_hunter_id, professional_hunter_permit_type, professional_hunter_permit_issue_date, professional_hunter_permit_expiry_date, professional_hunter_documents, office_notes ) VALUES ( %s,%s,%s,%s,%s,%s,%s,%s,%s,%s, %s,%s,%s,%s,%s,%s,%s,%s,%s,%s, %s,%s,%s,%s,%s ) rr~) r?rVrWrhrrrrrrrrrrrrkrlrmrOrrrrrrrrrrrrr[rKs rGcreate_partnerr<sx  D"kkm  "(4+<+<!!4#3#3T5G5GIdId$$d&9&94;P;PRVRcRceie}e}tzz4;N;Nt8894;S;SUYUnUnp~@D@X@XqYt::;^DLpLp=qtIIJN[_\G\GMHtAABNSWSdSdDe # 8 f~  s F%GGc[5nUR5nURSURURUR UR URURURURURURURURURUR UR"[%UR&5UR(UR*[%UR,5[%UR.5[%UR05[%UR25[%UR45[%UR65[%UR85U45 UR:S:Xa [=SSS9eUR?5 SS0URA5 $!URA5 f=f)Na UPDATE partners SET status=%s, partner_type=%s, company_name=%s, company_vat=%s, company_email=%s, company_contact_number=%s, company_country=%s, company_street=%s, company_province=%s, company_city=%s, company_postal_code=%s, first_name=%s, surname=%s, email=%s, contact_number=%s, hunting_outfitter_id=%s, comms_local_percent=%s, comms_export_percent=%s, outfitter_documents=%s, professional_hunter_id=%s, professional_hunter_permit_type=%s, professional_hunter_permit_issue_date=%s, professional_hunter_permit_expiry_date=%s, professional_hunter_documents=%s, office_notes=%s WHERE id = %s rrr,rsrT)!r?rVrWrhrrrrrrrrrrrrkrlrmrOrrrrrrrrrrrrrr[)rrIr^r_s rGupdate_partnerrds  D kkm   T..!!4#3#3T5G5GIdId$$d&9&94;P;PRVRcRceie}e}tzz4;N;Nt8894;S;SUYUnUnp~@D@X@XqYt::;^DLpLp=qtIIJN[_\G\GMHtAABNSWSdSdDe  2 <<1 C8KL L 4   s F+GGc[5nUR5nURSU45 URS:Xa [ SSS9eUR 5 SS0UR 5 $!UR 5 f=f)Nz5UPDATE partners SET status = 'Inactive' WHERE id = %srrr,rsrTrrr^r_s rGdelete_partnerrsk  Dkkm Kj][ <<1 C8KL L 4   rz /partners/{partner_id}/documentsc[5nURSS9nURSU45 UR5UR 5 $!UR 5 f=f)NTrSz SELECT id, file_path, file_name, mime_type, created_at FROM partner_documents WHERE partner_id = %s AND deleted_at IS NULL ORDER BY created_at DESC r=rs rGlist_partner_documentsrsU  D kkTk*   M ||~  rwc\[RR[SU35n[R"USS9 [ [ R"5R55S[R"S5SUR3n[RRX#5n[US5nURURR55 SSS5 [RR!U[5R#SS5n[%5nUR'5nUR)S XURUR*45 UR,n U S U3S .UR/5 $!,(df  N=f!UR/5 f=f) Npartner_Tr$rdr{r|r}r~z`INSERT INTO partner_documents (partner_id, file_path, file_name, mime_type) VALUES (%s,%s,%s,%s)rr~rr) rrxrrrrrr^r_rs rGupload_partner_documentrs;ww||J(:,(?@HKK4(*44678':K:KA:N9OqQUQ^Q^P_`K X3I i # $)).."# wwy*5==dCHH  D kkm n 4==$2C2C D Yxj+AB    rz)/partners/{partner_id}/documents/{doc_id}rcXURS5=(d SR5nU(d [SSS9e[5nUR 5nUR SX1U45 UR S:Xa [SS S9eS S 0UR5 $!UR5 f=f) N file_namerIrqfile_name is requiredrszMUPDATE partner_documents SET file_name = %s WHERE id = %s AND partner_id = %srrDocument not foundrTrZrLrr?rVrWrr[)rrrInew_namer^r_s rGrename_partner_documentrs%+224H 4KLL  D kkm [ z *  <<1 C8LM M4   ABB)c[5nUR5nURSX45 URS:Xa [ SSS9eSS0UR 5 $!UR 5 f=f)NzQUPDATE partner_documents SET deleted_at = NOW() WHERE id = %s AND partner_id = %srrrrsrTrR)rrr^r_s rGsoft_delete_partner_documentrsf  D kkm _    <<1 C8LM M4   rTz2/partners/{partner_id}/documents/{doc_id}/downloadc,[5nURSS9nURSX45 UR5nU(d [ SSS9e[ R R[US5n[ R RU5(d [ SSS9eUS =(d [ R RU5n[XTRS 5=(d S US 9UR5 $!UR5 f=f) NTrSzvSELECT file_path, file_name, mime_type FROM partner_documents WHERE id = %s AND partner_id = %s AND deleted_at IS NULLrrrsr File missingr mime_typeapplication/octet-stream media_typerr?rVrWr:rrrr<r"isfilebasenamer rZr[)rrr^r_rDabs_pathrs rGdownload_partner_documentrs  DkkTk*  E   llnC8LM M77<< C ,<=ww~~h''CG G{#Arww'7'7'AH1E1cIcnvw  C$DDz /auth/login)response_modelc[5nURSS9nURSURUR45 UR 5nU(aUR S5(d [ SSS9e[RURUS5(d [ SSS9eURSUS 45 S US UR S 5S .UR5 $!UR5 f=f) NTrSzKSELECT id, password_hash, role FROM users WHERE username = %s OR email = %s password_hashizInvalid credentialsrsz1UPDATE users SET last_login = NOW() WHERE id = %sr~zLogin successfulrd)rbrcrd) r?rVrWrXr:rZrrPverifyr:r[)rnr^r_rDs rGloginrs  DkkTk* Y   !3!3 4 lln#''/22C8MN N!!'"2"2C4HIIC8MN N G#d)V-c$iQTQXQXY_Q`a  s C C**C<z/auth/forgot-passwordc[5nURSS9nURSUR45 UR 5nU(dSS0UR 5 $[ R"S5n[R"5[SS9-nUR5nURS XEUS 45 S U3n[R"S 5n[[R"S S55n [R"SS5R5S;n [R"S5n [R"S5n U(aU (aU (a[5n SU S'XS'URU S'U R!SUS35 ["R$"XSS9nU (aUR'5 UR)X5 UR+U 5 SSS5 SXGS.UR 5 $!,(df  N#=f![,an[/SU35 SnANCSnAff=f!UR 5 f=f)NTrS%SELECT id FROM users WHERE email = %srbz/If the email exists, a reset link has been sent0r})hourszUUPDATE users SET password_reset_token = %s, password_reset_expires = %s WHERE id = %sr~z&http://localhost:40773/reset-password/ SMTP_HOST SMTP_PORT587 SMTP_STARTTLStrue)rxryeson SMTP_USER SMTP_PASSWORDzPassword Reset InstructionsSubjectFromTozHello, A password reset was requested for your account. If you made this request, click the link below to reset your password. This link will expire in 1 hour. zA If you did not request this, you can safely ignore this email. )timeoutz%[forgot-password] Email send failed: )rbr reset_link)r?rVrWrlr:r[r token_urlsaferrrrgetenvr>rr set_contentsmtplibSMTPstarttlsr send_messager\print)rnr^r_rDr expires_atr?r smtp_host smtp_port smtp_starttls smtp_user smtp_passwordmsgserverrjs rGforgot_passwordrs  D.kkTk* ;gmm=MNllnPQP O%%b)__&);; {{} c D * >eWE IIk*  +u56  /6:@@BF`` IIk*  /2 } C"n!>I'F #MMD ;;E,GWX \\)Cv$)LL:'', DMW\w DC  C=aSABB C sbAH=#DH=$A H0:H*H2H= HHH=H H:"H50H=5H::H==Iz/auth/reset-passwordc [UR5S:a [SSS9e[5nUR SS9nUR SUR 45 UR5nU(d [SSS9eUS [R"5:a [SS S9e[RUR5nUR 5nUR S XCS 45 S S0UR5 $!UR5 f=f)Nr{rq&Password must be at least 8 charactersrsTrSzLSELECT id, password_reset_expires FROM users WHERE password_reset_token = %sz Invalid tokenpassword_reset_expiresz Token expiredzmUPDATE users SET password_hash = %s, password_reset_token = NULL, password_reset_expires = NULL WHERE id = %sr~rbzPassword reset successful) r_rrr?rVrWrr:rrrPrQr[)rnr^r_rDrr?s rGreset_passwordrFs 7   1$4\]]  DkkTk* Z ]]  llnCH H ' (8??+< <CH H#(()=)=> {{} { I & 67  s B;C;;D z/usersc[5nURSS9nURS5 UR5UR 5 $!UR 5 f=f)NTrSz SELECT id, username, email, role, last_login, created_at FROM users ORDER BY username r=r>s rG list_usersrbsN  D kkTk*   ||~  r@c \rSrSr%\\S'Srg)UpdateRoleRequestisrdrENrYrErFrGrrss IrFrz/users/{user_id}/roleuser_idcURR5R5n1SknX#;a [SSS9eUS;aUOUn[ 5nUR 5nUR SX@45 URS:Xa [SS S9eUR5 S S 0UR5 $!UR5 f=f) N>r9rNstaffofficecustomerrq Invalid rolers>r9rNrz(UPDATE users SET role = %s WHERE id = %srrUser not foundrT) rdrLrrr?rVrWrrr[)rrIrdvalidrole_dbr^r_s rGupdate_user_rolerws 99??  " " $D @RS <<1 C8HI I 4   s AB22CcR\rSrSr%\\S'Sr\\\S'\\S'Sr \\\S'Sr g)CreateUserRequestiusernameNrlrdr:rE) rZr[r\r]rKr^rlrrr:r_rErFrGrrs)M $E8H $ I"Hhsm"rFrcURR5R5n1SknX;a [SSS9eURR5nU(d [SSS9eUR b#[ UR 5S:a [SSS9e[5nURSS 9nURS U45 UR5(a [SS S9eUR(a<URS UR45 UR5(a [SS S9eUR (a[RUR 5OSnUR5nURSX0RXa45 URnUR5 SU0UR!5 $!UR!5 f=f)N>rNrrrqrrszUsername is requiredr{rTrSrOUsername already in userEmail already in usezPINSERT INTO users (username, email, password_hash, role) VALUES (%s, %s, %s, %s)r~)rdrLrrrr:r_r?rVrWr:rlrPrQrrr[) rIrdrrr^r_password_hash_valuer?rs rG create_userrsm 99??  " " $D (E NCC}}""$H 4JKK }} S%7!%;4\]]  DkkTk* > L <<>>C8QR R :: KK?$** O||~~#\rSrSr%Sr\\\S'Sr\\ \S'Sr g)UpdateUserRequestiNrrlrE) rZr[r\r]rrrKr^rlrr_rErFrGrrs"Hhsm" $E8H $rFrz/users/{user_id}c[5nURSS9nURSU45 UR5nU(d [ SSS9eUR =(d USR 5nURb UROUSnURS XP45 UR5(a [ S S S9eU(a2URS X`45 UR5(a [ S S S9eUR5nURSXVU45 URS:Xa [ SSS9eUR5 SS0UR5 $!UR5 f=f)NTrSz3SELECT id, username, email FROM users WHERE id = %srrrsrrlz5SELECT id FROM users WHERE username = %s AND id <> %srqrz2SELECT id FROM users WHERE email = %s AND id <> %srz8UPDATE users SET username = %s, email = %s WHERE id = %srr) r?rVrWr:rrrLrlrrr[)rrIr^r_existing new_username new_emailr?s rG update_userrs>  DkkTk* IG:V<<>C8HI I =*)=DDF #'::#9TZZx?P  KlMde <<>>C8QR R  KKLyNb c||~~#s rG get_ordersr sN  DkkTk*   .||~  r@z/orders/{order_id}order_idc[5nURSS9nURSU45 UR5nU(d [ SSS9eUUR 5 $!UR 5 f=f)NTrSa SELECT id, order_unique_number, related_quote_id, related_quote_number, related_invoice_id, related_invoice_number, order_type, processing_type, customer_id, customer_name, order_delivery, deposit_received, instructions_finalised, order_paid_in_full, office_notes, created_at, updated_at FROM orders WHERE id = %s rOrder not foundrsrE)r r^r_rDs rG get_orderrsk  DkkTk*  *K- 0llnC8IJ J  rHrKc[5nUR5nURSURURUR UR URURURURURUR=(d SUR=(d SUR=(d SUR4 5 UR nURSS9nURSU45 UR#5nX5=(d 0R%S5S.UR'5 $!UR'5 f=f)Na0 INSERT INTO orders ( related_quote_id, related_quote_number, related_invoice_id, related_invoice_number, order_type, processing_type, customer_id, customer_name, order_delivery, deposit_received, instructions_finalised, order_paid_in_full, office_notes ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s) r+TrSz4SELECT order_unique_number FROM orders WHERE id = %sr)r~r)r?rVrWrrrrrrrcrrrrrrrr:rZr[)rKr^r_rLr?rDs rG create_orderr:s  D+kkm  $&&**((,,  %%!!##$$&&.$,,4((0D"" %! D{{d{+ KfYWmmoiR__EZ5[\  s D%EEc[5nUR5nURSURURUR UR URURURURURURURURURU45 UR S:Xa [#SSS9eSS0UR%5 $!UR%5 f=f)Na> UPDATE orders SET related_quote_id = %s, related_quote_number = %s, related_invoice_id = %s, related_invoice_number = %s, order_type = %s, processing_type = %s, customer_id = %s, customer_name = %s, order_delivery = %s, deposit_received = %s, instructions_finalised = %s, order_paid_in_full = %s, office_notes = %s WHERE id = %s rrr rsrT)r?rVrWrrrrrrrcrrrrrrrrr[)r rKr^r_s rG update_orderrks  D)kkm  $&&**((,,  %%!!##$$&&,,(("" %" F <<1 C8IJ J4   rc[5nUR5nURSU45 URS:Xa [ SSS9eSS0UR 5 $!UR 5 f=f)Nz DELETE FROM orders WHERE id = %srrr rsrTrR)r r^r_s rG delete_orderrs`  Dkkm 6 D <<1 C8IJ J4   rTz"/customers/{customer_id}/documentsrcc[5nURSS9nURSU45 UR5nUUR 5 $!UR 5 f=f)NTrSz SELECT id, file_path, file_name, mime_type, created_at FROM customer_documents WHERE customer_id = %s AND deleted_at IS NULL ORDER BY created_at DESC r=)rcr^r_r`s rGlist_customer_documentsrsZ  DkkTk*   N ||~  s 3AA"ch[RR[[ U55n[R "USS9 [ [R"5R55S[R"S5SUR3n[RRX#5n[US5nURURR!55 SSS5 [RR#U[5R%SS5n['5nUR)5nUR+SXURUR,45 UR.n U S U3S .UR15 $!,(df  N=f!UR15 f=f) NTr$rdr{r|r}r~zbINSERT INTO customer_documents (customer_id, file_path, file_name, mime_type) VALUES (%s,%s,%s,%s)rr)rrr<r"rKrr>rrrrrrrrrxrrrr?rVrWrrr[) rcrxrrrrrr^r_rs rGupload_customer_documentrs9ww||JK(89HKK4(*44678':K:KA:N9OqQUQ^Q^P_`K X3I i # $)).."# wwy*5==dCHH  D kkm p DMM43D3D E Yxj+AB    s*F1A F FF1z+/customers/{customer_id}/documents/{doc_id}cXURS5=(d SR5nU(d [SSS9e[5nUR 5nUR SX1U45 UR S:Xa [SS S9eS S 0UR5 $!UR5 f=f) NrrIrqrrszOUPDATE customer_documents SET file_name = %s WHERE id = %s AND customer_id = %srrrrTr)rcrrIrr^r_s rGrename_customer_documentrs%+224H 4KLL  D kkm ] { +  <<1 C8LM M4   rc[5nUR5nURSX45 URS:Xa [ SSS9eSS0UR 5 $!UR 5 f=f)NzSUPDATE customer_documents SET deleted_at = NOW() WHERE id = %s AND customer_id = %srrrrsrTrR)rcrr^r_s rGsoft_delete_customer_documentrsf  D kkm a  !  <<1 C8LM M4   rTz4/customers/{customer_id}/documents/{doc_id}/downloadc,[5nURSS9nURSX45 UR5nU(d [ SSS9e[ R R[US5n[ R RU5(d [ SSS9eUS =(d [ R RU5n[XTRS 5=(d S US 9UR5 $!UR5 f=f) NTrSzxSELECT file_path, file_name, mime_type FROM customer_documents WHERE id = %s AND customer_id = %s AND deleted_at IS NULLrrrsrrrrrrr)rcrr^r_rDrrs rGdownload_customer_documentrs  DkkTk*  G  ! llnC8LM M77<< C ,<=ww~~h''CG G{#Arww'7'7'AH1E1cIcnvw  rz /customersc[5nURSS9nURS5 UR5nUUR 5 $!UR 5 f=f)NTrSaI SELECT id, customer_unique_number, status, customer_type, first_names, surname, email, contact_number, whatsapp_number, physical_country, physical_street, physical_province_state, physical_city, physical_postal_code, ship_country, ship_street, ship_province_state, ship_city, ship_postal_code, referred_by, preferred_currency, citizenship, rsa_id, passport_number, documents, office_notes, created_at FROM customers ORDER BY created_at DESC r=)r^r_results rG get_customersr! sS  DkkTk*     rwrc6[5nUR5nURSUR=(d SURUR UR URURURURURURURURURUR UR"UR$UR&UR(UR*UR,UR.UR0UR2UR445 UR@nUR(a UROSU3nUR5nUnS nURS U45 URC5(dO US - nUU3nM6Un Sn URS XRU SU45 URE5 S U0URG5 $![6R8R:a!n[=USS5S:Xa [?SSS9eeSnAff=f![6R8R:a!n[=USS5S:Xa [?SSS9eeSnAff=f!URG5 f=f) NaF INSERT INTO customers ( status, customer_type, first_names, surname, email, contact_number, whatsapp_number, physical_country, physical_street, physical_province_state, physical_city, physical_postal_code, ship_country, ship_street, ship_province_state, ship_city, ship_postal_code, referred_by, preferred_currency, citizenship, rsa_id, passport_number, documents, office_notes ) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s) rrd&rqrrsrr}rOz INSERT INTO users (username, email, password_hash, role, customer_id) VALUES (%s, %s, %s, %s, %s) r~)$r?rVrWrhrirjrkrlrmrnrorprqrrrsrtrurvrwrxryrzr{r|r}r~rr@rArgrhrrr:rr[) rr^r_rjrLrr? candidatesuffixusername_finalrs rGcreate_customerr' sa  D?kkm  KK__083I3I8K_K_aiaqaqs{tBtB++X-E-ExG`G`bjbzbz44h6L6LhNkNk))8+?+?A]A]_g_q_q--x/C/CXE`E`bjbvbvOOX%=%=x?Q?QS[ShSh .&.^^8>>8F89L{{}  LLCi\ R==?? aKF#*VH-I  ##  LL 1DjRXY   f~ S$$ q'4(D0# IJI H<<IJJ"I>>JJJz/customers/{customer_id}c[5nURSS9nURSU45 UR5nU(d [ SSS9eUUR 5 $!UR 5 f=f)NTrSa> SELECT id, customer_unique_number, status, customer_type, first_names, surname, email, contact_number, whatsapp_number, physical_country, physical_street, physical_province_state, physical_city, physical_postal_code, ship_country, ship_street, ship_province_state, ship_city, ship_postal_code, referred_by, preferred_currency, citizenship, rsa_id, passport_number, documents, office_notes, created_at FROM customers WHERE id = %s rCustomer not foundrsrE)rcr^r_rDs rG get_customerr*esk  DkkTk*  N llnC8LM M  rHc[5nUR5nURSURURUR UR URURURURURURURURURUR UR"UR$UR&UR(UR*UR,UR.UR0UR2UR4U45 UR@S:Xa [?SS S9eURC5 S S 0URE5 $![6R8R:a!n[=USS5S:Xa [?SSS9eeSnAff=f!URE5 f=f) Na UPDATE customers SET status = %s, customer_type = %s, first_names = %s, surname = %s, email = %s, contact_number = %s, whatsapp_number = %s, physical_country = %s, physical_street = %s, physical_province_state = %s, physical_city = %s, physical_postal_code = %s, ship_country = %s, ship_street = %s, ship_province_state = %s, ship_city = %s, ship_postal_code = %s, referred_by = %s, preferred_currency = %s, citizenship = %s, rsa_id = %s, passport_number = %s, documents = %s, office_notes = %s WHERE id = %s rdr#rqrrsrrr)rT)#r?rVrWrhrirjrkrlrmrnrorprqrrrsrtrurvrwrxryrzr{r|r}r~rr@rArgrhrrrr[)rcrr^r_rjs rGupdate_customerr,s  DEkkm=  KK:OO**(($$NN++,,--,,44**11))((00&&--((//((OO,,&&))3;8 z <<1 C8LM M 4  $$ q'4(D0#rrrrrPapprr<getcwdr"rmountadd_middlewarerKgetpid _pool_suffixMySQLConnectionPoolr>r?rOr]rbrZrkpostrYrputrdeleterrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr rLrUrWrarfrrrrrrrrrrrr rron_eventr6r;r?rBrGrMrPrSrVrXrhrnrprrrrrrrrrrrrrrrrrrrrrrrrr`r^rrrr rrrrrrrr r"r$r&r(r*r-rr0r>rArfrhrjrtrvrrrrrrrrrrrrrrrrrrrrrrr rrrrrrrrrr!r'r*r,r.rZuvicornrunrErFrGrJs(( MM*-2((#&  ))I{ + bii 6* + ))I /ii '9: ))I6 7H:&A  i YY|RWW\\"))+y%I J  J& *kJ7i H =% YY|RWW\\"))+y%I J  J& *kJ7i H299; --'"))ND12         3 3  %&', &'(6 12#34 45 # 6  )*+, *+D,B 56cD7D 89 c :  &'(, '()6 23344 56 3 7  -./, ./0> 9:#;< <= # >  "#$, #$T%8 ./sT06 12 s 3  *+,, +,T-> 67sT8< 9: s ;  345, 45d68 ?@dA6 BC  D  89:, 9:4;6 DES4F4 GH S I  *+,, +,T-6 67sT84 9: s ;  &'(, '()B 2334D 56 3 7  !"#, "#D$B -.cD/D 01 c 2 rj29 I 'Y':I9 %)%( 'I 'H * *  9   33"00 00d "9 "  "9 "-- 5)5))Xi &06 $%&>/(/((V $%(3(.?(&(V '( 3 )     '( # )   4> '("S"0D")"J *+ S ,  %%P %&'* /. %&3.?'. () 3 *  0 #1##L &'.C./A.(.b )* C +  !" #   "#6'@6$6r ./,S,8Q,0,^ 12 S 3  #$%,  < "#$< $%&0 %&t'B 01t2D 34  5  #$(<%< ./S8L0@ 12 S 3 A6(*NA6%'HA6 : A6 #$B A6 "#@ A64A6%&FA6)*NA6()LA6"#@A6#$BA6$%DA6()LA6 )*N!A6$%&F%A6&$%D'A6(*+P)A6*)*N+A6. !0?A6@4AA6B :CA6D!">EA6H$%DIA6J,-TKA6L!">MA6N)*NOA6P12^QA6R&'HSA6V2WA6X8YA6Z#$B[A6\,]A6^ !<_A6`#$BaA6b()LcA6d6eA6h6iA6j.kA6l!">mA6n :oA6p"#@qA6r8sA6t&'HuA6v$%DwA6z23`{A6|1[8j5dAA6 DsCx%S/1 2AF<#<$s)<2HtCyHSH ()G3GG*GR ()c36G*$ & $  !$ $%&$ %&d'6 01d26 34  5  $ !"$.& ./0$ !"C#8 %e9c d:::z :::z ! 3 "   m3m);mm` &' C (   *+ s , )|,||~ '( 3 )  ()<@ICz*.$+$$$N !""s"-"#"J $% s &  +,s-$ ,-@DS :.. 45S6$ 78 S # 9  =>#s?(- 6<7( !"020#0f !0"6     !c):"&# #( '  FI $% # -B &  % %    $5  F@ !!!H)- --` +3+{++\ ! 3 "  -./& ./BFs)#Z0. 67#s$8$ 9: s C ;  ?@CA$,,AnAAH #$c%2 #$GGG%GT &'  (  z KK dfUrF