|
|
import base64 |
|
|
import os |
|
|
import sys |
|
|
import time |
|
|
from playwright.sync_api import sync_playwright |
|
|
from PIL import Image |
|
|
import pandas as pd |
|
|
|
|
|
def save_html_file(file_name, html_content): |
|
|
with open(file_name, 'w') as file: |
|
|
file.write(html_content) |
|
|
|
|
|
def encode_image_to_base64(image_path): |
|
|
with open(image_path, "rb") as image_file: |
|
|
return base64.b64encode(image_file.read()).decode('utf-8') |
|
|
|
|
|
|
|
|
logo_image_path = r"src/templates_images/Component 3.png" |
|
|
cola_image_path = r"src/templates_images/Frame 52.png" |
|
|
|
|
|
logo_base64 = encode_image_to_base64(logo_image_path) |
|
|
cola_base64 = encode_image_to_base64(cola_image_path) |
|
|
def save_html_file(file_name, html_content): |
|
|
with open(file_name, 'w') as file: |
|
|
file.write(html_content) |
|
|
|
|
|
def encode_image_to_base64(image_path): |
|
|
try: |
|
|
with open(image_path, "rb") as img_file: |
|
|
return base64.b64encode(img_file.read()).decode("utf-8") |
|
|
except FileNotFoundError: |
|
|
print(f"Image not found: {image_path}") |
|
|
return "" |
|
|
except Exception as e: |
|
|
print(f"Error encoding image {image_path}: {e}") |
|
|
return "" |
|
|
|
|
|
|
|
|
def generate_brand_marketing_html(product_image_base64_1, competitor_image_base64_1, product_image_base64_2, competitor_image_base64_2, donts_html, suggestions_html, company_name): |
|
|
return f""" |
|
|
<!DOCTYPE html> |
|
|
<html lang="en"> |
|
|
<head> |
|
|
<meta charset="UTF-8"> |
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0"> |
|
|
<title>Brand Marketing Template</title> |
|
|
<link href="https://fonts.googleapis.com/css2?family=Inter:wght@600&display=swap" rel="stylesheet"> |
|
|
<style> |
|
|
body {{ |
|
|
font-family: 'Inter', sans-serif; |
|
|
margin: 0; |
|
|
padding: 10%; /* Increased padding by 10% */ |
|
|
background-color: #fff; |
|
|
font-size: 6px; |
|
|
}} |
|
|
@page {{ |
|
|
size: A4; |
|
|
margin: 15px; /* Increased margin to 15px */ |
|
|
}} |
|
|
.header {{ |
|
|
display: flex; |
|
|
justify-content: space-between; |
|
|
align-items: center; |
|
|
padding: 10px; /* Increased padding to 10px */ |
|
|
background-color: #FFFFFF; |
|
|
margin-bottom: 15px; /* Increased margin between header and content */ |
|
|
}} |
|
|
.header .logo {{ |
|
|
height: 25px; /* Increased logo height */ |
|
|
}} |
|
|
.container {{ |
|
|
display: flex; |
|
|
flex-direction: column; |
|
|
padding: 10px; /* Increased padding to 10px */ |
|
|
flex-grow: 1; |
|
|
}} |
|
|
h1 {{ |
|
|
font-family: 'Times New Roman', serif; |
|
|
font-size: 22px; /* Increased font size */ |
|
|
font-weight: 500; |
|
|
line-height: 1.2; |
|
|
text-align: left; |
|
|
margin-bottom: 15px; /* Increased bottom margin */ |
|
|
}} |
|
|
h2, p {{ |
|
|
font-size: 13px; /* Increased font size */ |
|
|
font-weight: 400; |
|
|
line-height: 1.4; |
|
|
color: #000; |
|
|
}} |
|
|
.gap {{ |
|
|
font-size: 10px; |
|
|
color: rgb(5, 5, 5); |
|
|
font-weight: 100; |
|
|
}} |
|
|
.examples {{ |
|
|
font-size: 12px; /* Increased font size */ |
|
|
color: green; |
|
|
}} |
|
|
.box-container {{ |
|
|
width: 100%; |
|
|
display: flex; |
|
|
flex-direction: column; |
|
|
align-items: center; |
|
|
margin-top: 15px; /* Increased margin */ |
|
|
}} |
|
|
.wraper {{ |
|
|
width: 100%; |
|
|
height: 220px; /* Increased height */ |
|
|
display: flex; |
|
|
margin: 10px 0; /* Increased margin */ |
|
|
border-radius: 12px; /* Increased border radius */ |
|
|
overflow: hidden; |
|
|
position: relative; |
|
|
}} |
|
|
.div-1 {{ |
|
|
flex: 1; |
|
|
background-color: #ecbdbd; /* Pink background */ |
|
|
display: flex; |
|
|
align-items: center; |
|
|
justify-content: center; |
|
|
}} |
|
|
.div-2 {{ |
|
|
flex: 1; |
|
|
background-color: #e6f9e6; /* Green background */ |
|
|
display: flex; |
|
|
align-items: center; |
|
|
justify-content: center; |
|
|
}} |
|
|
.wraper img {{ |
|
|
max-width: 90%; |
|
|
max-height: 90%; |
|
|
object-fit: contain; |
|
|
border-radius: 8px; |
|
|
}} |
|
|
.vs-text {{ |
|
|
position: absolute; |
|
|
left: 50%; |
|
|
top: 50%; |
|
|
transform: translate(-50%, -50%); |
|
|
font-size: 18px; /* Increased font size */ |
|
|
font-weight: bold; |
|
|
color: black; |
|
|
}} |
|
|
.side-by-side-container {{ |
|
|
display: flex; |
|
|
gap: 35px; /* Increased gap between boxes */ |
|
|
margin-top: 45px; /* Increased top margin */ |
|
|
}} |
|
|
.pink-box, .green-box {{ |
|
|
flex: 1; |
|
|
padding: 18px; /* Increased padding */ |
|
|
margin-top: 15px; /* Increased margin */ |
|
|
border-radius: 15px; /* Increased border radius */ |
|
|
box-sizing: border-box; |
|
|
height: auto; |
|
|
}} |
|
|
.pink-box {{ |
|
|
background-color: #ecbdbd; |
|
|
color: red; |
|
|
text-align: start; |
|
|
display: flex; |
|
|
flex-direction: column; |
|
|
align-items: flex-start; |
|
|
}} |
|
|
.pink-box h6 {{ |
|
|
font-size: 16px; /* Increased text size */ |
|
|
font-weight: bold; |
|
|
margin: 8px 0; /* Increased margin */ |
|
|
color: red; |
|
|
}} |
|
|
.green-box {{ |
|
|
background-color: #e6f9e6; |
|
|
color: green; |
|
|
text-align: start; |
|
|
display: flex; |
|
|
flex-direction: column; |
|
|
align-items: flex-start; |
|
|
}} |
|
|
.green-box h6 {{ |
|
|
font-size: 16px; /* Increased text size */ |
|
|
font-weight: bold; |
|
|
margin: 8px 0; /* Increased margin */ |
|
|
color: green; |
|
|
}} |
|
|
.case-study {{ |
|
|
font-size: 18px; /* Increased font size */ |
|
|
color: green; |
|
|
margin-top: 25px; /* Increased margin */ |
|
|
}} |
|
|
.container1 {{ |
|
|
font-size: 12px; /* Increased font size */ |
|
|
color: green; |
|
|
margin-top: 15px; /* Increased margin */ |
|
|
}} |
|
|
.case2 {{ |
|
|
font-size: 12px; /* Increased font size */ |
|
|
color: rgb(1, 1, 1); |
|
|
margin-top: 25px; /* Increased margin */ |
|
|
}} |
|
|
.case-study img {{ |
|
|
display: block; |
|
|
max-width: 100%; |
|
|
height: auto; |
|
|
margin-top: 25px; /* Increased margin */ |
|
|
border-radius: 10px; /* Increased border radius */ |
|
|
}} |
|
|
</style> |
|
|
</head> |
|
|
<body> |
|
|
<div class="header"> |
|
|
<h1><span style="color:red;">Brand Marketing</span></h1> |
|
|
<img src="data:image/png;base64,{logo_base64}" alt="Logo" class="logo"> |
|
|
</div> |
|
|
<div class="container"> |
|
|
<p>{company_name} should use Brand Marketing effectively as the strategic promotion for identity, products, and services across all channels to create loyalty among consumers.</p> |
|
|
<p class="gap"><span style="color: red;">Issue/Gap:</span> {company_name}'s current brand marketing efforts might not be reaching their full potential. A comprehensive analysis of brand messaging, target audience engagement across channels, and content strategy could reveal opportunities to optimize {company_name}'s marketing approach for greater reach and impact.</p> |
|
|
</div> |
|
|
<h2 class="examples"> Examples:</h2> |
|
|
<div class="box-container"> |
|
|
<div class="wraper"> |
|
|
<div class="div-1"> <img src="data:image/png;base64,{product_image_base64_1}" alt="Product Image"></div> |
|
|
<div class="vs-text">V/S</div> |
|
|
<div class="div-2"> <img src="data:image/png;base64,{competitor_image_base64_1}" alt="Competitor Image"></div> |
|
|
</div> |
|
|
<div class="wraper"> |
|
|
<div class="div-1"> <img src="data:image/png;base64,{product_image_base64_2}" alt="Product Image"></div> |
|
|
<div class="vs-text">V/S</div> |
|
|
<div class="div-2"> <img src="data:image/png;base64,{competitor_image_base64_2}" alt="Competitor Image"></div> |
|
|
</div> |
|
|
</div> |
|
|
<div class="side-by-side-container"> |
|
|
<div class="pink-box"> |
|
|
<h6>Drawbacks in Current Brand Marketing</h6> |
|
|
<p>{donts_html}</p> |
|
|
</div> |
|
|
<div class="green-box"> |
|
|
<h6>How Banao Technologies Can Help</h6> |
|
|
<p>{suggestions_html}</p> |
|
|
</div> |
|
|
</div> |
|
|
<div class="case-study"> |
|
|
<h3>Case Study:</h3> |
|
|
<div class="container1"> |
|
|
<p><span style="color: green;">Coca-Cola Brand Marketing using its iconic red color?</span></p> |
|
|
</div> |
|
|
<div class="case2"> |
|
|
<p>Coca-Cola uses its iconic red color, Spencerian script font, and "Open Happiness" slogan across all platforms, from its website to its social media pages to its countless physical advertisements.</p> |
|
|
<img src="data:image/png;base64,{cola_base64}" alt="Cola" class="cola"> |
|
|
</div> |
|
|
</div> |
|
|
</body> |
|
|
</html> |
|
|
|
|
|
""" |
|
|
|
|
|
|
|
|
def parse_cleaned_file_brand_marketing(file_path): |
|
|
with open(file_path, "r") as file: |
|
|
content = file.read() |
|
|
|
|
|
sections = content.split("==================================================") |
|
|
for section in sections: |
|
|
lines = section.strip().split("\n") |
|
|
if lines and "Brand Marketing" in lines[0]: |
|
|
donts = [] |
|
|
suggestions = [] |
|
|
mode = None |
|
|
for line in lines[1:]: |
|
|
if line.startswith("Don'ts:"): |
|
|
mode = "donts" |
|
|
elif line.startswith("Suggestions:"): |
|
|
mode = "suggestions" |
|
|
elif mode == "donts" and line.startswith("-"): |
|
|
donts.append(line.lstrip("- ")) |
|
|
elif mode == "suggestions" and line.startswith("-"): |
|
|
suggestions.append(line.lstrip("- ")) |
|
|
return "<br>".join(donts), "<br>".join(suggestions) |
|
|
|
|
|
return "", "" |
|
|
|
|
|
|
|
|
def process_brand_marketing(data, base_image_dir, output_file, cleaned_file_path, company_name): |
|
|
|
|
|
brand_data = data[data["Category"] == "Brand Marketing"] |
|
|
|
|
|
if brand_data.empty: |
|
|
print("No Brand Marketing data found in the provided Excel file.") |
|
|
return |
|
|
|
|
|
|
|
|
donts_html, suggestions_html = parse_cleaned_file_brand_marketing(cleaned_file_path) |
|
|
|
|
|
|
|
|
if len(brand_data) < 2: |
|
|
print("Not enough rows for two product and competitor image comparisons.") |
|
|
return |
|
|
|
|
|
|
|
|
brand_row_1 = brand_data.iloc[0] |
|
|
brand_row_2 = brand_data.iloc[1] |
|
|
|
|
|
product_image_path_1 = os.path.join(base_image_dir, brand_row_1["Product_Image_Name"]) |
|
|
competitor_image_path_1 = os.path.join(base_image_dir, brand_row_1["Competitor_Image_Name"]) |
|
|
|
|
|
product_image_path_2 = os.path.join(base_image_dir, brand_row_2["Product_Image_Name"]) |
|
|
competitor_image_path_2 = os.path.join(base_image_dir, brand_row_2["Competitor_Image_Name"]) |
|
|
|
|
|
|
|
|
product_image_base64_1 = encode_image_to_base64(product_image_path_1) |
|
|
competitor_image_base64_1 = encode_image_to_base64(competitor_image_path_1) |
|
|
|
|
|
product_image_base64_2 = encode_image_to_base64(product_image_path_2) |
|
|
competitor_image_base64_2 = encode_image_to_base64(competitor_image_path_2) |
|
|
|
|
|
|
|
|
html_content = generate_brand_marketing_html( |
|
|
product_image_base64_1, |
|
|
competitor_image_base64_1, |
|
|
product_image_base64_2, |
|
|
competitor_image_base64_2, |
|
|
donts_html, |
|
|
suggestions_html, |
|
|
company_name |
|
|
) |
|
|
|
|
|
|
|
|
with open(output_file, "w", encoding="utf-8") as f: |
|
|
f.write(html_content) |
|
|
|
|
|
print(f"HTML file for Brand Marketing has been saved as: {output_file}") |
|
|
|
|
|
|
|
|
if __name__ == "__main__": |
|
|
if len(sys.argv) > 1: |
|
|
company_name = sys.argv[1] |
|
|
else: |
|
|
company_name = "Default_Company" |
|
|
|
|
|
file_path = "Output_File/excel/top_3_sd_results.xlsx" |
|
|
data = pd.read_excel(file_path) |
|
|
|
|
|
base_image_dir = "" |
|
|
|
|
|
|
|
|
cleaned_file_path = "data/output_generated_file/Product_output_cleaned.txt" |
|
|
|
|
|
|
|
|
output_file = "src/templates/brand_marketing.html" |
|
|
|
|
|
|
|
|
process_brand_marketing(data, base_image_dir, output_file, cleaned_file_path, company_name) |
|
|
|
|
|
|
|
|
sys.stdout.reconfigure(encoding='utf-8') |
|
|
|
|
|
def capture_screenshot_with_playwright(html_file_path, screenshot_path): |
|
|
""" |
|
|
Capture a full-page screenshot of the HTML file directly using Playwright. |
|
|
""" |
|
|
try: |
|
|
|
|
|
with sync_playwright() as p: |
|
|
browser = p.chromium.launch(headless=True) |
|
|
page = browser.new_page() |
|
|
|
|
|
|
|
|
page.goto(f"file:///{os.path.abspath(html_file_path)}") |
|
|
|
|
|
|
|
|
page.screenshot(path=screenshot_path, full_page=True) |
|
|
print(f"Screenshot saved: {screenshot_path}") |
|
|
|
|
|
browser.close() |
|
|
|
|
|
except Exception as e: |
|
|
print(f"Error capturing screenshot: {e}") |
|
|
|
|
|
def convert_png_to_pdf(png_path, company_name): |
|
|
""" |
|
|
Convert a PNG image into a PDF strictly named as 'company_name brand marketing.pdf' |
|
|
in the specified folder 'data/reports/template_PDF'. |
|
|
""" |
|
|
try: |
|
|
|
|
|
output_folder = "data/reports/template_PDF" |
|
|
os.makedirs(output_folder, exist_ok=True) |
|
|
|
|
|
|
|
|
pdf_path = os.path.join(output_folder, "brand marketing.pdf") |
|
|
|
|
|
|
|
|
img = Image.open(png_path) |
|
|
img.convert('RGB').save(pdf_path, "PDF") |
|
|
|
|
|
print(f"PDF saved: {pdf_path}") |
|
|
except Exception as e: |
|
|
print(f"Error converting PNG to PDF: {e}") |
|
|
|
|
|
if __name__ == "__main__": |
|
|
|
|
|
html_file_path = "src/templates/brand_marketing.html" |
|
|
|
|
|
|
|
|
screenshot_folder = "data/reports/template_ss" |
|
|
os.makedirs(screenshot_folder, exist_ok=True) |
|
|
screenshot_path = os.path.join(screenshot_folder, "brand_marketing_screenshot.png") |
|
|
|
|
|
|
|
|
os.system("playwright install") |
|
|
|
|
|
|
|
|
capture_screenshot_with_playwright(html_file_path, screenshot_path) |
|
|
|
|
|
|
|
|
convert_png_to_pdf(screenshot_path, company_name) |
