Hi all, please pardon the interruption.

I am here today to look for MOD requests in exchange for monetary donations. As you've all see I typically do all the MODs here for free, with only custom requests being "commercial" jobs for me. Today I'm looking to fill any MOD requests in exchange for donations to support a close friend of mine.

My friend is Tony, and he was formerly a Drill Sergeant in the United States Army as well as my Platoon Sergeant in both peace time in Germany and at War in Iraq. Tony has been battling pancreatic cancer now for over a year and money is beginning to get extremely tight. He has been in and out of the VA looking for assistance and they have him running in circles though he has had some success here and there. The money they are spending simply on driving to and from the hospital has become a hardship not to mention of course all of the related medical bills and so on. So I am here doing what I can to translate what I'm capable of into some financial assistance for he and his family. All donations/work from now through the end of the day 7/31/2011 will go directly to Tony and his family. If you should choose to donate and would like to include a personal message please feel free to do so on the PayPal notes section and I will be sure to send it along with the money.

In order to donate please see any page on my website, it is located at the upper right:

http://sudobash.net(http://sudobash.net)

Now as for the MOD requests: I am very busy right now but will take all MODs and work on them in order of their complexity. If I am able to do one persons MOD request that came in much later than anyone elses but it will take me only 30 minutes then of course I'll be knocking that out before any of the more complex ones. Please keep in mind I am working on MODs here not complete builds/rebuilds/etc. I will of course work to get everyones MOD requests filled as soon as possible. Please also keep in mind that I know nothing about Exchange so I will be unable to help with anything related. If you wish to discuss your request prior to donating then deciding if we can work something out that is perfectly understandable. Please send all communications to scott (at) sudobash (dot) net.

Thank you for your time,

Scott Rowley

Note: This subject will be unstickied after 7/31

Hey Scottro,

I just donated for your friend Tony! I hope he gets better!

I implemented your Reports mod and it works great! My problem is making new, custom reports for my needs.

For example what I need done (and i cannot get this working for the life of me) is I used teryakisan's "simple status" mod to show a custom status of a ticket.

Well I want to take that and want to create a custom report of my employees and the status of each report.

For example:

Report Sold By Staff - This will show a pie chart with my employees names and how many tickets are currently in sold status if the ticket was assigned to them

Report Unsold by Staff - Same thing but for unsold status tickets

and so on...

I guess once we get the first one working the other ones are going to be simple..

this is what I did:

Added to the drop down:

<option value="tixSoldbystaff" <?if($_POST=='tixSoldbystaff'){echo "selected";}?>>Tickets Sold By Staff</option>

I think this is where my problem comes in:

I added COUNT(DISTINCT(CASE WHEN ost_ticket.sold=0 THEN ost_ticket.ticket_id END)) as soldvalue but that throws a SQL error

basically I am storing in the sold column of ost_ticket either a NULL, 0, 1, 2 and so up to 8 based on the ticket status.

I am having a hell of a time trying to call these DB queries since I never worked with them and I am a beginner in PHP as well.

Next I added the group by

elseif($_POST == 'tixSoldbystaff'){

$qgroup = "GROUP BY ost_staff.staff_id ORDER BY ost_staff.lastname ";

}

Next I added the code for the pie chart to use but doesn't seem to do anything either.

<? if($_POST == 'tixSoldbystaff'){

if($graphRow == NULL){

$graphRow = Tickets;

$graphRow = Unassigned;

}?>

['<?=$graphRow?> <?=$graphRow?>', <?=$graphRow,

<? } ?>

Continuing with table heading:

elseif($_POST == 'tixSoldbystaff'){

echo "<tr><th>Staff</th><th>Tickets Sold</th></tr>";

}

Table content: (also very buggy)

elseif($_POST == 'tixSoldbystaff'){

if($row == NULL){

$row = Tickets;

$row = Unassigned;

}

echo "<tr style='font-weight: bold;'><td>" . $row. " " .$row . "</td><td>" . $row ." </td></tr> ";

}

Finally the totals but this just shows the total tickets not the total SOLD tickets in status 0 in the sold column of the table ost_ticket

elseif($_POST == 'tixSoldbystaff'){?>

<tr style='font-weight: bold; background-color: #E0E0E0;'><td>Total</td><td><?=$Total;?></td></tr>

<? }

I hope this is enough info to figure out what I'm trying to do :

Thank you for ANY help!

Responded to this via email in case anyone is interested. The MOD is already over 50% done.

MOD is done and functional :)

MOD is done and functional :)

And you did an amazing job! Thanks for helping me out with this!

And you did an amazing job! Thanks for helping me out with this!

Np! Thanks very much for the donation! :)

5 days later

Thanks Scott Awesome mod you did for me I want to thank you beyond measure it works like a charm. :)

Thanks Scott Awesome mod you did for me I want to thank you beyond measure it works like a charm. :)

Fantastic! Thank you very much for the donation. I'll be preparing a gift basket (ok my wife will be...) and we'll be sending it down along with a Visa Gift Card containing the donations.

12 years later
Write a Reply...