Pityumajsaii/Titanium
0
1import sqlite3, os2from flask import Flask, request, redirect3from dotenv import load_dotenv4 5load_dotenv()6 7app = Flask(__name__)8 9PORT=int(os.getenv("APP_PORT",5000))10PASS=os.getenv("ADMIN_PASS")11COMPANY=os.getenv("COMPANY_NAME")12PAY=os.getenv("STRIPE_LINK")13 14@app.route("/")15def home():16 db=sqlite3.connect(timeout=30, "data/titanium.db")17 c=db.cursor()18 services=c.execute("SELECT name,price,description FROM services").fetchall()19 db.close()20 21 html=f"<html><body style='background:#111;color:#fff;padding:40px;font-family:Arial'><h1>🔥 {COMPANY}</h1><hr>"22 23 for s in services:24 html += f"<p><b>{s[0]}</b> - €{s[1]}<br>{s[2]}<br><a href='{PAY}'>BUY NOW</a></p><hr>"25 26 html += """27 <h2>Free Consultation</h2>28 <form method='post' action='/lead'>29 <input name='name' placeholder='Name'><br><br>30 <input name='email' placeholder='Email'><br><br>31 <input name='company' placeholder='Company'><br><br>32 <input name='service' placeholder='Wanted Service'><br><br>33 <button>Send</button>34 </form>35 36 <br><a href='/admin'>Admin</a>37 </body></html>38 """39 return html40 41@app.route("/lead", methods=["POST"])42def lead():43 db=sqlite3.connect(timeout=30, "data/titanium.db")44 c=db.cursor()45 46 c.execute("""47 INSERT INTO leads(name,email,company,service,status)48 VALUES(?,?,?,?, 'new')49 """,(50 request.form["name"],51 request.form["email"],52 request.form["company"],53 request.form["service"]54 ))55 56 db.commit()57 db.close()58 59 return "<h1>Lead received.</h1><a href='/'>Back</a>"60 61@app.route("/admin")62def admin():63 if request.args.get("pass","") != PASS:64 return "<h1>Denied. use ?pass=yourpass</h1>"65 66 db=sqlite3.connect(timeout=30, "data/titanium.db")67 c=db.cursor()68 69 leads=c.execute("SELECT count(*) FROM leads").fetchone()[0]70 new=c.execute("SELECT count(*) FROM leads WHERE status='new'").fetchone()[0]71 contacted=c.execute("SELECT count(*) FROM leads WHERE status='contacted'").fetchone()[0]72 fu=c.execute("SELECT count(*) FROM followups").fetchone()[0]73 74 html=f"""75 <html><body>76 <h1>🔥 TITANIUM CRM</h1>77 <p>Total Leads: {leads}</p>78 <p>New: {new}</p>79 <p>Contacted: {contacted}</p>80 <p>Followups: {fu}</p>81 </body></html>82 """83 84 db.close()85 return html86 87app.run(host="0.0.0.0",port=PORT)88