def test_others(self):
self.assertTrue(
JalaliDateTime.fromtimestamp(time.time() -
10) <= JalaliDateTime.now())
self.assertEqual(
JalaliDateTime(1367, 2, 14, 4, 30, 0, 0, pytz.utc).timestamp(),
578723400)
self.assertEqual(
JalaliDateTime.fromtimestamp(578723400, pytz.utc),
JalaliDateTime(1367, 2, 14, 4, 30, 0, 0, pytz.utc),
)
self.assertEqual(
JalaliDateTime(1367, 2, 14, 4, 30, 4, 4444).jdate(),
JalaliDate(1367, 2, 14))
self.assertEqual(
JalaliDateTime(1367, 2, 14, 4, 30, 4, 4444).date(),
date(1988, 5, 4))
self.assertEqual(
JalaliDateTime(1367, 2, 14, 4, 30, 0,
0).replace(tzinfo=pytz.utc).__repr__(),
"JalaliDateTime(1367, 2, 14, 4, 30, tzinfo=<UTC>)",
)
self.assertEqual(
JalaliDateTime(1367, 2, 14, 4, 30, 4, 4444).replace(year=1395,
day=3,
minute=59),
JalaliDateTime(1395, 2, 3, 4, 59, 4, 4444),
)
self.assertEqual(JalaliDateTime.now(pytz.utc).tzname(), "UTC")
self.assertIsNone(JalaliDateTime.today().tzname())
self.assertIsNone(JalaliDateTime.today().dst())
self.assertEqual(
JalaliDateTime(1367, 2, 14, 4, 30, 0, 0).ctime(),
"Chaharshanbeh 14 Ordibehesht 1367 04:30:00",
)
self.assertEqual(
JalaliDateTime(1396, 7, 27, 21, 48, 0, 0).ctime(),
"Panjshanbeh 27 Mehr 1396 21:48:00",
)
self.assertEqual(
JalaliDateTime(1367, 2, 14, 4, 30, 0,
0).replace(locale="fa").ctime(),
"چهارشنبه ۱۴ اردیبهشت ۱۳۶۷ ۰۴:۳۰:۰۰",
)
self.assertEqual(
JalaliDateTime(1397, 12, 1, 23, 32, 0,
0).replace(locale="fa").ctime(),
"چهارشنبه ۰۱ اسفند ۱۳۹۷ ۲۳:۳۲:۰۰",
)
self.assertEqual(
JalaliDateTime(1367, 2, 14, 4, 30, 0, 1, pytz.utc).isoformat(),
"1367-02-14T04:30:00.000001+00:00",
)
self.assertEqual(
JalaliDateTime(1367, 2, 14, 4, 30, 0, 1, pytz.utc).__str__(),
"1367-02-14 04:30:00.000001+00:00",
)
def test_others(self):
self.assertTrue(JalaliDateTime.fromtimestamp(time.time()) <= JalaliDateTime.now())
self.assertEqual(JalaliDateTime(1367, 2, 14, 4, 30, 0, 0, pytz.utc).timestamp(), 578723400)
self.assertEqual(JalaliDateTime.fromtimestamp(578723400, pytz.utc),
JalaliDateTime(1367, 2, 14, 4, 30, 0, 0, pytz.utc))
self.assertEqual(JalaliDateTime(1367, 2, 14, 4, 30, 4, 4444).jdate(), JalaliDate(1367, 2, 14))
self.assertEqual(JalaliDateTime(1367, 2, 14, 4, 30, 4, 4444).date(), date(1988, 5, 4))
self.assertEqual(JalaliDateTime(1367, 2, 14, 4, 30, 0, 0).replace(tzinfo=pytz.utc).__repr__(),
'JalaliDateTime(1367, 2, 14, 4, 30, tzinfo=<UTC>)')
self.assertEqual(JalaliDateTime(1367, 2, 14, 4, 30, 4, 4444).replace(year=1395, day=3, minute=59),
JalaliDateTime(1395, 2, 3, 4, 59, 4, 4444))
self.assertEqual(JalaliDateTime.now(pytz.utc).tzname(), "UTC")
self.assertIsNone(JalaliDateTime.today().tzname())
self.assertIsNone(JalaliDateTime.today().dst())
self.assertEqual(JalaliDateTime(1367, 2, 14, 4, 30, 0, 0).ctime(), "Chaharshanbeh 14 Ordibehesht 1367 04:30:00")
self.assertEqual(JalaliDateTime(1396, 7, 27, 21, 48, 0, 0).ctime(), "Panjshanbeh 27 Mehr 1396 21:48:00")
self.assertEqual(JalaliDateTime(1367, 2, 14, 4, 30, 0, 0).replace(locale="fa").ctime(),
"چهارشنبه ۱۴ اردیبهشت ۱۳۶۷ ۰۴:۳۰:۰۰")
self.assertEqual(JalaliDateTime(1367, 2, 14, 4, 30, 0, 1, pytz.utc).isoformat(),
"1367-02-14T04:30:00.000001+00:00")
self.assertEqual(JalaliDateTime(1367, 2, 14, 4, 30, 0, 1, pytz.utc).__str__(),
"1367-02-14 04:30:00.000001+00:00")
def lead_add(request):
if request.method == "POST" and request.user.is_authenticated \
and request.user.is_staff:
name_and_family = request.POST['name_and_family']
gender = request.POST['gender']
phone_fa = digits.ar_to_fa(request.POST['phone_number'])
phone_en = digits.fa_to_en(phone_fa)
register_status = request.POST['register_status']
operator = request.user
origin = Origin.objects.filter(id=int(request.POST['origin'])).first()
#fields should be validate
if len(name_and_family) > 2 and len(phone_en) > 5 and len(phone_en) < 16 and\
phone_en.isdigit() and len(Lead.objects.filter(phone_number=phone_en)) == 0:
lead = Lead(origin = origin, name_and_family = name_and_family.encode("utf-8"), gender = gender,\
phone_number = phone_en, register_status = register_status,\
led_time = datetime.now(),led_time_jalali = JalaliDateTime.now().strftime("%Y-%m-%d %H:%M:%S"),\
led_time_jalali_str = JalaliDateTime.now().strftime("%c"))
#if lead is registered save operator
if register_status == "K":
lead.registered_by = request.user
else:
lead.registered_by = None
lead.save()
lead.operator.add(operator)
messages.success(request, "You'r new lead has been save")
return HttpResponseRedirect(request.META.get('HTTP_REFERER'))
#if same phone number added by 1 or more operators
elif len(Lead.objects.filter(phone_number=phone_en)) == 1:
lead = Lead.objects.filter(phone_number=phone_en).first()
if request.user in lead.operator.all():
messages.warning(request, "Phone number is repetitive")
return HttpResponseRedirect(request.META.get('HTTP_REFERER'))
else:
if lead.register_status != "K":
lead.operator.add(request.user)
lead.save()
messages.info(request, "lead is repetitive but you added to this lead operators")
messages.success(request, "You'r new lead has been save")
return HttpResponseRedirect(request.META.get('HTTP_REFERER'))
else:
messages.info(request, "lead is repetitive and registered by another operator")
messages.warning(request, "You'r new lead did not changed!")
return HttpResponseRedirect(request.META.get('HTTP_REFERER'))
elif len(name_and_family) <= 3:
messages.warning(request, "Check name and family fileld")
return HttpResponseRedirect(request.META.get('HTTP_REFERER'))
elif len(phone_en) <= 6 and len(phone_en) >= 16 and phone_en.isdigit() is False:
messages.warning(request, "Phone number is in wrong format")
return HttpResponseRedirect(request.META.get('HTTP_REFERER'))
else:
messages.warning(request, "something went wrong")
return HttpResponseRedirect(request.META.get('HTTP_REFERER'))
else:
messages.error(request, "You'r not authorized")
return HttpResponseRedirect(request.META.get('HTTP_REFERER'))
def check_time():
today = JalaliDateTime.now().strftime('%m-%d')
today = time.strptime(today, '%m-%d')
a = '0'
b = '0'
c = 0
missings = db.execute('SELECT day, month FROM days WHERE in_time = ? AND off = ?', (a, c)).fetchall()
print ("you have missing time entris in these days:")
for missing in missings:
m_d = str(missing[0]).zfill(2)
m_m = str(missing[1]).zfill(2)
day = f'{m_m}-{m_d}'
day = time.strptime(day, '%m-%d')
if today < day:
break
else:
print (f'{m_m}-{m_d} Has no ENTER time')
missings = db.execute('SELECT day, month FROM days WHERE out_time = ? AND off = ?', (b, c)).fetchall()
print ("-------------------------------")
for missing in missings:
m_d = str(missing[0]).zfill(2)
m_m = str(missing[1]).zfill(2)
day = f'{m_m}-{m_d}'
day = time.strptime(day, '%m-%d')
if today < day:
break
else:
print (f'{m_m}-{m_d} Has no EXIT time')
def fetch_startup_service(owner, context):
"""get the startup that assign to the requested user and get the custom leader that added by user
Arguments:
owner {OBEJCET} -- requested user
context {DICT} -- a dictionary of context to add it some more context
Returns:
OBJECT -- returns the determined startup
"""
db_startup = get_startup_service(owner=owner)
the_time = JalaliDateTime.now().to_gregorian()
try:
user_mentor = get_startup_service(owner=owner,
rahbar__mentor_user=True)
except:
user_mentor = None
context.update({
'the_time': the_time,
'user_mentor': user_mentor,
'db_startup': db_startup,
})
return db_startup
def test_base(self):
self.assertEqual(JalaliDateTime(1367, 2, 14, 14, 0, 0, 0),
JalaliDateTime.to_jalali(datetime(1988, 5, 4, 14, 0, 0, 0)))
self.assertEqual(JalaliDateTime(1369, 7, 1, 14, 14, 1, 1111),
JalaliDateTime(datetime(1990, 9, 23, 14, 14, 1, 1111)))
self.assertEqual(JalaliDateTime(1369, 7, 1, 14, 14, 1, 9111),
JalaliDateTime(JalaliDateTime(1369, 7, 1, 14, 14, 1, 9111)))
g = JalaliDateTime.now()
self.assertEqual(g.time(), _time(g.hour, g.minute, g.second, g.microsecond))
g = g.replace(tzinfo=pytz.timezone("America/Los_Angeles"))
self.assertEqual(g.timetz(),
_time(g.hour, g.minute, g.second, g.microsecond, pytz.timezone("America/Los_Angeles")))
self.assertEqual(JalaliDateTime.fromtimestamp(578723400, pytz.utc),
JalaliDateTime(1367, 2, 14, 4, 30, 0, 0, pytz.utc))
self.assertEqual(JalaliDateTime.utcfromtimestamp(578723400), JalaliDateTime(1367, 2, 14, 4, 30, 0, 0))
try:
JalaliDateTime._check_time_fields(20, 1, 61, 1000)
except ValueError:
assert True
else:
assert False
try:
JalaliDateTime._check_time_fields("20", 1, 61, 1000)
except TypeError:
assert True
else:
assert False
def export_all(request):
leads = Lead.objects.order_by('-id')
comments = Comment.objects.all()
labels = Label.objects.all()
time = JalaliDateTime.now().strftime("%H:%M %Y-%m-%d")
data = {'comments': comments, 'leads':leads, 'labels': labels, 'time': time}
return render(request,'leads/export/export_all.html', data)
async def job():
async with aiohttp.ClientSession() as session:
start_time = time()
async with session.get(url) as response:
status = response.status
response_body = await response.text()
print('%s: Pinged %s / %.2fms / %d: %s' %
(JalaliDateTime.now(timezone('Iran')).strftime('%Y-%m-%d %H:%M:%S%Z'),
REMOTE_HOST, time() - start_time, status, response_body))
def comment_add(request):
if request.method == "POST" and request.user.is_authenticated \
and request.user.is_staff and len(request.POST['text']) > 0:
get_object_or_404(Lead, id=int(request.POST["id"]))
post = Lead.objects.filter(id=int(request.POST["id"])).first()
author = request.user
text = request.POST['text']
comment = Comment(post = post, author = author, text = text, created_date = datetime.now(), \
created_date_jalali = JalaliDateTime.now().strftime("%Y-%m-%d %H:%M:%S"), \
created_date_jalali_str = JalaliDateTime.now().strftime("%c"))
comment.save()
messages.success(request, "You'r comment has been save")
return HttpResponseRedirect(request.META.get('HTTP_REFERER'))
elif len(request.POST['text']) == 0:
messages.warning(request, "You'r comment text field is empty")
return HttpResponseRedirect(request.META.get('HTTP_REFERER'))
else:
messages.error(request, "You'r not authorized")
return HttpResponseRedirect(request.META.get('HTTP_REFERER'))
def jdatetime(value, arg=""):
try:
if str(value) == "now":
if arg == "": arg = "%Y-%m-%d %H:%M:%S"
resultdate = JalaliDateTime.now()
elif str(value) == "time":
if arg == "": arg = "%H:%M:%S"
resultdate = JalaliDateTime.now()
elif str(value) == "date":
if arg == "": arg = "%Y-%m-%d"
resultdate = JalaliDateTime.now()
else:
if isinstance(value, datetime.date):
resultdate = JalaliDateTime.to_jalali(value)
else:
year, month, day = map(int, value[:10].split('-'))
hour = minute = second = millisecond = 0
if value.find(' ') == 10:
date, time = value.split(' ')
time = time.split(':')
if len(time) == 1:
hour = int(time[0])
elif len(time) == 2:
hour = int(time[0])
minute = int(time[1])
elif len(time) == 3:
hour = int(time[0])
minute = int(time[1])
time = time[2].split('.')
second = int(time[0])
if len(time) > 1:
millisecond = int(time[1])
resultdate = JalaliDateTime.to_jalali(
datetime.datetime(year, month, day, hour, minute, second,
millisecond))
if arg:
return resultdate.strftime(arg)
else:
return resultdate
except Exception as err:
return "jdatetime error:%s" % err
def label_add(request):
if request.method == "POST" and request.user.is_authenticated \
and request.user.is_staff:
get_object_or_404(Lead, id=int(request.POST["lead_id"]))
get_object_or_404(LabelDefinition, id=int(request.POST["label"]))
#if label is uniqe for this lead
if len(Label.objects.filter(label__id=int(request.POST["label"]), post__id=int(request.POST["lead_id"]))) == 0:
post = Lead.objects.filter(id=int(request.POST["lead_id"])).first()
label1 = LabelDefinition.objects.filter(id=int(request.POST["label"])).first()
label = Label(post = post, label = label1, owner = request.user , created_date = datetime.now(), \
created_date_jalali = JalaliDateTime.now().strftime("%Y-%m-%d %H:%M:%S"), \
created_date_jalali_str = JalaliDateTime.now().strftime("%c"))
label.save()
messages.success(request, "You'r label has been changed")
return HttpResponseRedirect(request.META.get('HTTP_REFERER'))
else:
messages.warning(request, "This label exist")
return HttpResponseRedirect(request.META.get('HTTP_REFERER'))
else:
messages.error(request, "You'r not authorized")
return HttpResponseRedirect(request.META.get('HTTP_REFERER'))
def test_pickle(self):
file = open("save.p", "wb")
now = JalaliDateTime.now().replace(tzinfo=pytz.timezone("Asia/Tehran"))
pickle.dump(now, file)
file.close()
file2 = open("save.p", "rb")
j = pickle.load(file2)
file2.close()
self.assertEqual(j, now)
os.remove("save.p")
def test_pickle(self):
file = open("save.p", "wb")
now = JalaliDateTime.now().replace(tzinfo=pytz.timezone("Asia/Tehran"))
pickle.dump(now, file)
file.close()
file2 = open("save.p", "rb")
j = pickle.load(file2)
file2.close()
self.assertEqual(j, now)
os.remove("save.p")
def dashboard_chart_service(investor ,coach ,leader ,referee ,operational, track_info):
"""get the numbers of karmand an the current year of chart
Arguments:
investor {OBJECT} -- the role of investor
coach {OBJECT} -- the role of coach
leader {OBJECT} -- the role of leader
referee {OBJECT} -- the role of referee
operational {OBJECT} -- the role of operational
Returns:
DICT -- returns the current year and all monthes of jalali and numbers of karmands
"""
all_investorses = models.User.objects.filter(role=investor).count()
all_startupses = StartUp.objects.all().count()
all_coaches = models.User.objects.filter(role=coach).count()
all_leaderes = models.User.objects.filter(role=leader).count()
all_operationales = models.User.objects.filter(
role=operational).count()
all_referees = models.User.objects.filter(role=referee).count()
th_year = JalaliDateTime.now().year
chart = (StartUp.objects.filter(created_date__range=[get_date_jalali(int(th_year), month+1, 1), get_date_jalali(int(th_year), month+1, 31)]).count() for month in range(12))
monthes = []
for _ in range(12):
monthes.append(chart.__next__())
status = "وارد پنل مدیریت شد"
status_of_user(track_info, status, 'import-dashboard-administrator')
return {
'farvardin': monthes[0],
'ordi': monthes[1],
'khurdad': monthes[2],
'tir': monthes[3],
'mordad': monthes[4],
'shahrivar': monthes[5],
'mehr': monthes[6],
'aban': monthes[7],
'azar': monthes[8],
'daaay': monthes[9],
'bahman': monthes[10],
'esfand': monthes[11],
'th_year': th_year,
"all_investorses": all_investorses,
"all_startupses": all_startupses,
"all_coaches": all_coaches,
"all_leaderes": all_leaderes,
"all_operationales": all_operationales,
"all_referees": all_referees}
def _send_user_timesheet(user):
j_now = JalaliDateTime.now()
receiver_email = settings.TIMESHEETS_RECEIVER_EMAIL
if not receiver_email:
raise ValueError("No receiver email address.")
if not user.email:
logging.info(
f"User ({user.username}) email not found. Emailing the corresponding timesheet ignored."
)
return
cc_list = []
if user.email:
cc_list.append(user.email)
if user.detail.manager_email:
cc_list.append(user.detail.manager_email)
body_text = f'''Hello, Here is the timesheet of a user at SahaBee. This email is sent automatically by SahaBee,
since the user was actively rollcalling at SahaBee during the last few days.
User Information:
First name: {user.first_name}
Last name: {user.last_name}
Personnel code: {user.detail.personnel_code}
Username (at SahaBee): {user.username}
Sincerely,
SahaBee
-----------------------
Let the good times roll!
https://sahabee.ir
'''
message = EmailMessage(
'SahaBee User Timesheet',
body_text,
from_email=user.email,
to=[receiver_email],
cc=cc_list,
attachments=[(
f'timesheet-{user.detail.personnel_code}.xlsx',
ExcelConverter.generate_excel_file(user, j_now.year,
j_now.month).getvalue(),
'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
)])
message.send()
logging.info(
f"Successfully emailed timesheet of '{user.username}' to '{settings.TIMESHEETS_RECEIVER_EMAIL}'."
)
def test_base(self):
self.assertEqual(
JalaliDateTime(1369, 7, 1, 14, 14, 1, 9111),
JalaliDateTime(JalaliDateTime(1369, 7, 1, 14, 14, 1, 9111)),
)
g = JalaliDateTime.now()
self.assertEqual(g.time(),
_time(g.hour, g.minute, g.second, g.microsecond))
g = g.replace(tzinfo=pytz.timezone("America/Los_Angeles"))
self.assertEqual(
g.timetz(),
_time(
g.hour,
g.minute,
g.second,
g.microsecond,
pytz.timezone("America/Los_Angeles"),
),
)
self.assertEqual(
JalaliDateTime.fromtimestamp(578723400, pytz.utc),
JalaliDateTime(1367, 2, 14, 4, 30, 0, 0, pytz.utc),
)
self.assertEqual(
JalaliDateTime.utcfromtimestamp(578723400),
JalaliDateTime(1367, 2, 14, 4, 30, 0, 0),
)
with pytest.raises(TypeError):
JalaliDateTime._check_time_fields("20", 1, 61, 1000)
with pytest.raises(ValueError):
JalaliDateTime(1367, 2, 14, 25, 0, 0, 0)
with pytest.raises(ValueError):
JalaliDateTime(1367, 2, 14, 22, 61, 0, 0)
with pytest.raises(ValueError):
JalaliDateTime(1367, 2, 14, 22, 1, 722, 0)
with pytest.raises(ValueError):
JalaliDateTime(1367, 2, 14, 22, 1, 0, 1000000)
def create_time_table(period):
print("Creating the time table...")
print('Progress: 0%\r', end='\r')
from_day = 15
to_day = 32
in_time = '0'
out_time = '0'
day_off = 0
months = period
prog = 0
year = int(JalaliDateTime.now().strftime('%Y'))
for month in months:
if month == 0:
year = year - 1
while from_day <= to_day:
try:
day = JalaliDate(year, month, from_day)
day_type = day.strftime('%A')
day_month = day.strftime("%m")
day_date = day.strftime('%d')
prog = prog + 1
from_day = from_day + 1
print(f"\rProgress: {round(100*(prog/31))}%", end='\r')
if day_type != "Panjshanbeh" and day_type != "Jomeh":
date = day.strftime('%Y-%m-%d')
day_off = is_off(date)
else:
day_off = 1
db.execute(
"INSERT INTO days VALUES ('{}', '{}', '{}', '{}', '{}', '{}')"
.format(day_date, day_month, day_type, in_time, out_time,
day_off))
except:
from_day = 1
to_day = 15
break
print(f"Time table created........")
connection.commit()
def _send_user_timesheet(user):
j_now = JalaliDateTime.now()
if not user.detail.work_email:
logging.info(f"User ({user.username}) work email not found. Emailing the corresponding timesheet ignored.")
return
receiver_email = user.detail.work_email
if j_now.day == 1:
# The timesheet of the previous month should be sent in the first day of each month.
report_jdatetime = j_now - timedelta(days=1)
else:
report_jdatetime = j_now
timesheet_file = ExcelConverter.generate_excel_file(user, report_jdatetime.year, report_jdatetime.month).getvalue()
body_text = f'''Hello, Here is the timesheet of you at SahaBee. As soon as possible, forward this email to the Office
This email is sent automatically, since you have actively roll-calling at SahaBee during the last few days.
User Information:
First name: {user.first_name}
Last name: {user.last_name}
Personnel code: {user.detail.personnel_code}
Username (at SahaBee): {user.username}
Sincerely,
SahaBee
-----------------------
Let the good times roll!
https://sahabee.ir
'''
message = EmailMessage('SahaBee User Timesheet',
body_text,
to=[receiver_email],
attachments=[(f'timesheet-{user.detail.personnel_code}.xlsx',
timesheet_file,
'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')])
message.send()
logging.info(f"Successfully emailed timesheet of '{user.username}' to '{settings.TIMESHEETS_RECEIVER_EMAIL}'.")
from datetime import timedelta
from persiantools.jdatetime import JalaliDateTime, JalaliDate
import pytz
import time
one_hour_in_ms = 60 * 60 * 1000
one_day_in_ms = one_hour_in_ms * 24
get_current_epoch = lambda : int(round(time.time() * 1000))
get_tehran_tzinfo_by_epoch = lambda e: JalaliDateTime.fromtimestamp(e//1000, pytz.timezone("Asia/Tehran")).tzinfo # will be used indirectly and by other functions
now = JalaliDateTime.now(tz=get_tehran_tzinfo_by_epoch(get_current_epoch()))
jalali_to_gregorian = lambda j: j.to_gregorian().date() # needed when using plotly
epoch_to_jalali = lambda e: JalaliDateTime.fromtimestamp(e/1000, tz=get_tehran_tzinfo_by_epoch(e))
def utc_date_to_jalali(year, month, day):
return JalaliDate.to_jalali(year, month, day)
def jalali_to_epoch(year, month, day=1, hour=0, minute=0, second=0, milliseconds=0):
tehran_tzinfo = get_tehran_tzinfo_by_epoch(int(JalaliDateTime(year, month, day, hour, minute, second, milliseconds*1000).timestamp() * 1000))
return int(JalaliDateTime(year, month, day, hour, minute, second, milliseconds*1000, tzinfo=tehran_tzinfo).timestamp() * 1000)
today_epoch = jalali_to_epoch(now.year, now.month, now.day)
# ---------------------------------------------------------
def back_days_epoch(n):
d = now - timedelta(days = n)
e = jalali_to_epoch(d.year, d.month, d.day)
x = epoch_to_jalali(e)
if x.hour == 23:
e += one_hour_in_ms
def submit_missings(driver):
try:
db.execute("CREATE TABLE missings (date TEXT, type TEXT, time TEXT)")
except:
print('flushing tables')
db.execute("DROP TABLE missings")
db.execute("CREATE TABLE missings (date TEXT, type TEXT, time TEXT)")
today = JalaliDateTime.now().strftime('%m-%d')
today = time.strptime(today, '%m-%d')
year = JalaliDateTime.now().strftime('%Y')
a = '0'
b = '0'
c = 0
missings = db.execute(
'SELECT day, month FROM days WHERE in_time = ? AND off = ?',
(a, c)).fetchall()
for missing in missings:
m_d = str(missing[0]).zfill(2)
m_m = str(missing[1]).zfill(2)
day_s = f'{m_m}-{m_d}'
day = time.strptime(day_s, '%m-%d')
if today < day:
break
else:
pass
print(f"input ENTER time for {day_s}:")
user_time = input()
type = 'enter'
date = f'{year}{m_m}{m_d}'
db.execute("INSERT INTO missings VALUES ('{}', '{}', '{}')".format(
date, type, user_time))
connection.commit()
missings = db.execute(
'SELECT day, month FROM days WHERE out_time = ? AND off = ?',
(b, c)).fetchall()
print("-------------------------------")
for missing in missings:
m_d = str(missing[0]).zfill(2)
m_m = str(missing[1]).zfill(2)
day_s = f'{m_m}-{m_d}'
day = time.strptime(day_s, '%m-%d')
if today < day:
break
else:
pass
print(f"input EXIT time for {day_s}:")
user_time = input()
type = 'exit'
date = f'{year}{m_m}{m_d}'
db.execute("INSERT INTO missings VALUES ('{}', '{}', '{}')".format(
date, type, user_time))
connection.commit()
missings = db.execute('SELECT date, type, time FROM missings').fetchall()
for missing in missings:
submit_time(driver=driver,
date=missing[0],
time=missing[2],
type=missing[1])
def show_message(stdscr, msg):
# start thread
thread = Thread(target=refresh, args=stdscr)
thread.start()
thread.join()
# Clear and refresh the screen for a blank canvas
stdscr.clear()
stdscr.refresh()
# Start colors in curses
curses.start_color()
curses.init_pair(1, curses.COLOR_CYAN, curses.COLOR_BLACK)
curses.init_pair(2, curses.COLOR_RED, curses.COLOR_BLACK)
curses.init_pair(3, curses.COLOR_BLACK, curses.COLOR_WHITE)
# Initialization
stdscr.clear()
height, width = stdscr.getmaxyx()
# Declaration of strings
title = JalaliDateTime.now().strftime("%A %d %B %Y %H:%M")[:width - 1]
message = msg[:width - 1]
statusbarstr = "Modern University |"
# Centering calculations
start_x_title = int((width // 2) - (len(title) // 2) - len(title) % 2)
start_y = int((height // 2) - 2)
# Render status bar
stdscr.attron(curses.color_pair(3))
try:
stdscr.addstr(height - 1, 0, statusbarstr)
stdscr.addstr(height - 1, len(statusbarstr), " " * (width - len(statusbarstr) - 1))
except curses.error:
pass
stdscr.attroff(curses.color_pair(3))
# Turning on attributes for title
stdscr.attron(curses.color_pair(2))
stdscr.attron(curses.A_BOLD)
# Rendering title
try:
stdscr.addstr(start_y, start_x_title, title)
except curses.error:
pass
# Turning off attributes for title
stdscr.attroff(curses.color_pair(2))
stdscr.attroff(curses.A_BOLD)
stdscr.attron(curses.color_pair(2))
# Print rest of text
stdscr.addstr(start_y + 1, 0, message)
stdscr.attroff(curses.color_pair(2))
# Refresh the screen
stdscr.refresh()
sleep(2)
#======================= change log ============================
# version 1.0
#======================= configs ================================
fileName = 'conf.txt'
with open(os.path.join(sys.path[0], fileName), 'r') as f:
data = f.read().splitlines()
try:
username = data[0]
password = data[1]
except:
print(
"Please put your username and password in the conf.txt file.\nUsername must be in the first line and the password must be in the second line.\nExiting now..."
)
exit()
time_now = JalaliDateTime.now().strftime('%H:%M')
date_now = JalaliDateTime.now().strftime('%Y/%m/%d')
connection = sqlite3.connect("pts.db")
db = connection.cursor()
try:
db.execute(
"CREATE TABLE days (day INTEGER, month INTEGER, day_type TEXT, in_time TEXT, out_time TEXT, off INTEGER)"
)
except:
print('flushing tables')
db.execute("DROP TABLE days")
db.execute(
"CREATE TABLE days (day INTEGER, month INTEGER, day_type TEXT, in_time TEXT, out_time TEXT, off INTEGER)"
)
def draw_menu(stdscr, table, message='----', alter='', status='Enter b to back |'):
# start thread
thread = Thread(target=refresh, args=stdscr)
thread.start()
thread.join()
# Clear and refresh the screen for a blank canvas
stdscr.clear()
stdscr.refresh()
# Start colors in curses
curses.start_color()
curses.init_pair(1, curses.COLOR_CYAN, curses.COLOR_BLACK)
curses.init_pair(2, curses.COLOR_RED, curses.COLOR_BLACK)
curses.init_pair(3, curses.COLOR_BLACK, curses.COLOR_WHITE)
curses.init_pair(4, curses.COLOR_BLUE, curses.COLOR_BLACK)
# Initialization
stdscr.clear()
height, width = stdscr.getmaxyx()
# Declaration of strings
title = JalaliDateTime.now().strftime("%A %d %B %Y %H:%M")
statusbarstr = "Modern University | {}".format(status)
# Centering calculations
start_x_title = int((width // 2) - (len(title) // 2) - len(title) % 2)
start_x_keystr = int((width // 2) - (len(alter) // 2) - len(alter) % 2)
start_y = int((height // 2) - 2)
# Render status bar
stdscr.attron(curses.color_pair(3))
try:
stdscr.addstr(height - 1, 0, statusbarstr)
stdscr.addstr(height - 1, len(statusbarstr), " " * (width - len(statusbarstr) - 1))
except curses.error:
pass
stdscr.attroff(curses.color_pair(3))
# Turning on attributes for title
stdscr.attron(curses.color_pair(2))
stdscr.attron(curses.A_BOLD)
# Rendering title
try:
stdscr.addstr(start_y, start_x_title, title)
except curses.error:
pass
# Turning off attributes for title
stdscr.attroff(curses.color_pair(2))
stdscr.attroff(curses.A_BOLD)
# Print rest of text
stdscr.attron(curses.color_pair(4))
try:
stdscr.addstr(int(start_y / 2) + 1, 0, table)
stdscr.attroff(curses.color_pair(4))
stdscr.addstr(int(start_y / 2) + 1, (width // 2) - 2, message)
stdscr.addstr(int(start_y / 2) + 2, start_x_keystr, alter)
except curses.error:
pass
stdscr.attroff(curses.color_pair(4))
# Refresh the screen
stdscr.refresh()
# Wait for next input
k = stdscr.getch()
return k
def show_time_call(cli: Client, msg: Message):
print("show_time_call")
today = JalaliDateTime.now(pytz.timezone("Asia/Tehran"));
msg.reply_text(today.strftime("%c" + "\n\nTime zone: **Asia/Tehran**"))
from persiantools.jdatetime import JalaliDateTime, JalaliDate
import pytz
today = JalaliDateTime.now(pytz.timezone("Asia/Tehran"))
print(today.strftime("%c"))
import re
p = re.compile(r'^(/)?date$|^(/)?time$|^تاریخ$', re.IGNORECASE)
m = re.search(p, '/تاریخ')
print(m)
def export(request):
data = {}
#operators can not know each other leads
if request.user.is_superuser:
leads = Lead.objects.order_by('-id')
if "operator" in request.GET and len(request.GET["operator"])>0:
data.update( { "operator":int(request.GET["operator"]) } )
operator = request.GET["operator"]
if operator:
leads = leads.filter(operator__id=operator)
else:
leads = Lead.objects.filter(operator__id=request.user.id).order_by('-id')
#search
if "phrase" in request.GET and len(request.GET["phrase"])>0:
data.update( { "phrase":request.GET["phrase"] } )
phrase = request.GET["phrase"]
if phrase:
p_name = leads.filter(name_and_family__icontains=phrase)
p_phone = leads.filter(phone_number__icontains=phrase)
p_comment = leads.filter(comments__text__icontains=phrase)
p_question = leads.filter(question__icontains=phrase)
leads = p_name | p_phone | p_comment | p_question
leads = leads.distinct()
if "origin" in request.GET and len(request.GET["origin"])>0:
data.update( { "origin":int(request.GET["origin"]) } )
origin = request.GET["origin"]
if origin:
leads = leads.filter(origin__id=origin)
if "gender" in request.GET and len(request.GET["gender"])>0:
data.update( { "gender":request.GET["gender"] } )
gender = request.GET["gender"]
if gender:
leads = leads.filter(gender=gender)
if "status" in request.GET and len(request.GET["status"])>0:
data.update( { "status":request.GET["status"] } )
status = request.GET["status"]
if status:
leads = leads.filter(register_status=status)
if "label1" in request.GET and len(request.GET["label1"])>0:
data.update( { "label1":request.GET["label1"] } )
label1 = request.GET["label1"]
if label1:
leads = leads.filter(label__label__color_code=label1)
if "label2" in request.GET and len(request.GET["label2"])>0:
data.update( { "label2":request.GET["label2"] } )
label2 = request.GET["label2"]
if label2:
leads = leads.filter(label__label__color_code=label2)
if "date_from" in request.GET and len(request.GET["date_from"])>0:
date_from = request.GET["date_from"]
if date_from:
date_from_s =date_from.split("/")
date_from = JalaliDate(int(date_from_s[0]), int(date_from_s[1]), int(date_from_s[2])).to_gregorian()
data.update( { "date_from":date_from.strftime("%Y-%m-%d")} )
leads = leads.filter(led_time__gte=date_from)
if "date_to" in request.GET and len(request.GET["date_to"])>0:
date_to = request.GET["date_to"]
if date_to:
date_to_s =date_to.split("/")
date_to = JalaliDate(int(date_to_s[0]), int(date_to_s[1]), int(date_to_s[2])).to_gregorian()
data.update( { "date_to":date_to.strftime("%Y-%m-%d")} )
date_to += timedelta(days=1)
leads = leads.filter(led_time__lte=date_to)
# if there is no date show last month
if "date_from" not in data:
date = datetime.now()
date -= timedelta(days=30)
leads = leads.filter(led_time__gte=date)
date = date.strftime("%Y-%m-%d")
data.update( { "date_from":date} )
if "date_to" not in data:
date = datetime.now()
date += timedelta(days=1)
leads = leads.filter(led_time__lte=date)
date = date.strftime("%Y-%m-%d")
date = data.update( { "date_to":date} )
#leads paginator
paginator = Paginator(leads, 30)
page = request.GET.get('page')
if page:
paged_leads = paginator.page(page)
else:
paged_leads = paginator.page(1)
#page = paginator.get_page(page)
comments = Comment.objects.all()
labels = Label.objects.all()
labels_def = LabelDefinition.objects.all()
origins = Origin.objects.all()
time = JalaliDateTime.now().strftime("%H:%M %Y-%m-%d")
data.update( {'comments': comments, 'leads':paged_leads, 'labels': labels, 'time': time, 'labels_def': labels_def, \
origins:'origins','REGISTRATION_STATUS':REGISTRATION_STATUS, 'GENDER_CHOICES':GENDER_CHOICES,\
'ORIGIN_DESCRIPTION':ORIGIN_DESCRIPTION, 'USER_NAME_AND_FAMILY':USER_NAME_AND_FAMILY,\
'LABELDEFINITION_TAG':LABELDEFINITION_TAG,} )
return render(request,'leads/export/export.html', data)