Simple db / web service to sync data from API and then report on differences
$250-750 USD
Paguhet në dorëzim
We run an IT service company and we bill a monthly flat rate based on devices and computers at our clients. We use software called IT Glue to document and track this infrastructure. We need a database created that tracks the devices and computers that we are actually billing for (along with a few other manual billing items). This database will be populated by querying the IT Glue API, and then allow our billing staff to review the changes before updating the invoice amounts stored in the database.
For our database, this schema should do the trick:
CUSTOMERS
ID (syncs from ITGlue API, pk)
Name (syncs from ITGlue API)
tax (calculate sales tax or not - t/f we assign this in database, default to true)
CONFIGURATIONS (this is what IT Glue calls computers, servers, and devices)
ID (syncs from ITGlue API, pk)
customer ID (syncs from ITGlue API, fk to CUSTOMERS)
Status (pre-deploy, active, decommissioned, deleted, syncs from ITGlue API)
name (syncs from ITGlue API)
type (syncs from ITGlue API - computer, device, server, etc)
PRODUCTS (these are the kinds of things we invoice for: devices, computers, 3rd party apps, etc.)
ID (pk)
Description (examples include "computers" "devices" "Antivirus licenses" "Backup 100GB increment", etc.)
type (service, rental, subscription)
Rate (this is in dollars)
LINE_ITEMS
ID
Customer (fk)
product (fk)
Units (how many of the product)
Detail (comma separated list of "configurations" included in "units" as of last update)
Updated (timestamp)
~~
Interface loads to just two buttons:
[sync glue] [billing report]
SYNC GLUE does this:
Pull list of clients from ITGlue API > populate to our database if there are any chnages
Pull list of configurations > populate our database with any changes
Result page loads with results from sync event
:: Customers: x records unchanged, x records updated > list of records updated;
:: Configurations: x records unchanged, x records changed or added > list of records updated
BILLING REPORT
Loop through all customer IDs (sorted by name)
For each customer:
Pull line item for computers. Print it to the screen. Explode "detail" into array variable of computer IDs - this is the list of computers that were billed as of last update.
Query: select all configurations of the "computer" types (servers, computers, laptops), and status "active." Print current billing list vs current real-world list (two columns) with formatting to highlight discrepancies. Summarize with "line item" quantity difference and a link to accept changes.
Do the same thing for devices line item.
Pull the other line items (backup 100GB, Antivirus seats, MS Office subscription, etc.) and print them to the screen.
Add up all line items for bill total including subtotals by product type (service, rental, subscription). Calculate sales tax depending on tax flag in customer table. Display another line for grand total including tax.
Repeat this for each customer. This can all be just dumped onto one big report page that just scrolls.
At the bottom, summarize company-wide totals by category (service, rental, subscription, tax) and then grand total for monthly billing.
ID Projekti: #17302235
Rreth projektit
Është zgjedhur fitues:
Hi There, I am good in API integration and I have integrated different types of API for different sites. I can work with IT Glue API. Looking forward Thank You
32 profesionistë freelancer dërguan një ofertë mesatare prej $554 për këtë punë
Okay i can update db and API as you asked but i need to first review the current setup of it...can we discuss more on freelancer inbox to get detail understanding about project ? I have relevant skills and experienc Më shumë
Hello! Do you have the API documentation for "IT Glue"? I'll need access to your server and can get started immediately. I have a 99% project completion rate and a 4.99 reputation (out of max 5.0 from more than Më shumë
Hi, I have experience of working on similar projects, I can help to develop automated script for sync data from api. Please let me know about time when you would be available so we can discuss further. Please see Më shumë
HI There, I can assist you with Simple db / web service to sync data from API. I am very passionate about quality of my work, You will be pleased working with me. Let's have a quick chat to discuss it further. You Më shumë
Hi there. While there are quite a few good devs bidding i think that my experiece will set me apart and in good stead with this project. Ive been coding for 18 years professionally and about 25 years in total. But le Më shumë
Hello friend, I am so interested in developing web service to sync data from API and then report, I am an expert web developer, having years of experience. It would be ideal if you Feel allowed to get in touch with m Më shumë
Hello, I have reviewed your description that you are looking for a PHP developer to create web service to sync data from API and then report on differences. => Prestashop / E-commerce Expert. => 7+ Years of Experi Më shumë
We are very interested in this project. We have read your project details and are very much confident in completing all these requirements. We are working in IT industry since last 7 years. We are providing service Më shumë
Hi I'm c# developer with 12 years experience on .net framework and related tools. I'll create application with c# .net to sync sql database from api and and generate some reports. please send me a message to have di Më shumë
Hi client, see my portfolio for more PHP project information. I am PHP developer having 6 years of experience in software development. please start your discussion with me. thanks.
I have extensive 5 years of experience in database programming. My work won't disappoint you. Relevant Skills and Experience Mysql, oracle, plsql, webservic