AFTECH.RO

dont forget about the credited amount on the client's account as well to be shown on the invoice as Credit and balance it with future invoices

i like these ones (with that slogan) :D 1.  2.  3. 

i`m inclining to the number 2 as logo, simple and modern in the same time. will go great as web logo and on business cards, t-shirts and so on :d...

I recommend something else, but we will chat about that when we will have the chance. Not exactly what i had in mind for the asset service history, but this...

just donw know the echo for day/last month/year and so on :d once i`ll get one example, i can figure it out. tried few things from google but did not...

got this far :d //Get Total tickets this unassigned $sql_total_tickets_unnassigned = mysqli_query($mysqli,"SELECT COUNT(`ticket_id`) AS total_tickets_unassigned FROM tickets WHERE ticket_assigned_to = '0' AND ticket_status = 'open';"); $row = mysqli_fetch_array($sql_total_tickets_unnassigned); $total_tickets_unnassigned =...

@wrongecho feel free to jump in if you figure out the SQL queries. This is where i`m stuck for the past 2 days, so i need help from anyone that...

Hey @johnnyq, that`s great. I didnt considered the session_company_id as i only have one company on my end as MSP, but you are right, for those who using multiple companies,...

@wrongecho, @johnnyq and everyone else... there's a saying...."if you are not failing, your not succeeding" so let`s fail as much as we can in order to succeed big time :D

getting somewhere, but need further tests https://www.plus2net.com/sql_tutorial/date-lastweek.php this week SELECT COUNT(`ticket_id`) AS `total_tickets_week` FROM `tickets`WHERE WEEKOFYEAR(`ticket_created_at`)=WEEKOFYEAR(CURDATE()) previous month SELECT COUNT(`ticket_id`) AS `total_tickets_lastmonth` FROM `tickets` WHERE MONTH( `ticket_created_at` ) = MONTH(...