...arti panjang dari Chart of Account bisa dinamis tanpa perlu merubah coding program. Yang saya perlukan adalah : 1. Desain database untuk Financial Accounting (mySQL based) 2. Query untuk menghasilkan laporan yang diinginkan : - Laporan Jurnal - Laporan General Ledger - Laporan Trial Balance - Laporan Balance Sheet - Laporan Profit & Loss
...database using Google's Firebase platform, and I need to periodically query that database using the Cloud Firestore REST API. This requires a so-called separate "service account". More info here: [login to view URL] The fields I need to query in the Firestore database are structured as follows: users > uid > uploaded-files
...website's SQL query is not being able to handle this huge database and few SQL queries are being executed very slowly. The website is hosted in a very good dedicated VPS, so hosting server is fine for the huge database but the website's SQL query need to be modified so that it can load and perform faster. My VPS >> "MySQL Slow Query" log s...
Our website (WordPress and Gravity Forms) has an online offering system. Clients can ask online for a quote and our server mails the offer (in pdf) to the client. Our office uses MS Access and we want to make queries from MS Access (VBA) to the database made by Gravity Forms on our website (I think the small database is stored on our site and know it is a sql-database) . So I am looking who know...
I am looking to rename multiple choice answers client side (php file) that are showing as numbers. Example what I now have in my PHP file: 'sql_query' => "SELECT element_10,element_2,element_3,element_5,element_4,element_6,element_8,element_9 FROM ap_form", Here's what I need element_5 has 2 choices Choice 1 is showing up 1 I would like it to be MA Choice 2 is ...
I have a CSV sheet w/ all the appointments made at different locations which have the client ID number. I would like to take the clie...locations which have the client ID number. I would like to take the client ID from the appointment table and match it with the Client Table to find out their name, number and email and which location they booked at.
we have a GET function which pulls all records. Now we need new endpoint for filtering those records based on date, type etc DB is Mongo
Hi All i have a table like attached image needs first negative balance date followed by second last positive balance means 7769 . -3752...like attached image needs first negative balance date followed by second last positive balance means 7769 . -3752.86 2018-08-10 08:06:35 1 min job for expert send query in your reply budget : 500 INR
create endpoint/API to filter notifications based on Read/unread, type, date range. we already have an api to GET all Notifications. but no api for filtering PERL, MONGO Get ready with team viewer plz
I have MongoDB collection. I have to group the documents in that collection based on the monthly cycle. For example, the cycle date is 20 of each month. I have to group the documents like 20/06/2018 to 19/07/2018 , 20/07/2018 to 19/08/2018.
...[login to view URL] . 4. If all files are available , run a Cmd file “[login to view URL]” and halt the long polling for next 16 hours. 5. If any of the file is not present , email to the email address set by variable “ EmailVO “ with content as name of missing files and subject as “ Missing files / Today date and day / current time” an...
I need someone to write a simple sql query to copy fields between tables
hey ! i have a project of perl programming used in bioinformatics. For this assignment you need to provide the following things: A rough outline that clearly shows how the problem can be broken down into subproblems. Pseudo code that describes how the problem can be implemented. A Perl program that implements the program according to the instructions
we have a form for insert data, we need on submit to create a query before to process to check if data exist and IF exist show a modal with alert and name of data else process
I need someone freelancer to help me to fix the query below: select count(distinct p.products_id) as total from (products p) left join manufacturers m on (m.manufacturers_id=p.manufacturers_id) left join specials s on p.products_id = s.products_id left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id left join zones_to_geo_zones gz on
I am looking for the scripts that can induce latency between two micro services deployed on AWS.
Query on Office 365 Excel Online to export the data. No bootstrapping. Need to use Dojo or jQuery, or find a way to get it into that format for me to use.
Project Duration: 1 Hour Project Overview When trying to run this query: SET `description` = REPLACE(`description`, 'â€™', ''') WHERE `description` like 'â€™%' We get the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right synt...
I am currently getting a 500 error on my website. I traced it back to an SQL query (SELECT XYZ FROM zip_code INNER JOIN city ON zip_code.city_id = city.city_id INNER JOIN region ON city.region_id = region.region_id INNER JOIN country ON region.country_id = country.country_id). The INNER JOIN country ON region.country_id = country.country_id part of
Scrape from a google spreadsheet into a database on Azure or EC2, and create a UI for non-technical people to query. Make sure certain users can add but cannot delete data from the db. Also the UI should sanitize and validate the data before entering it int the database.
Requiero programadores para darle mantenimiento y desarrollo de nuevas funcionalidades a un ERP desarrollado en Linux, Perl y MYSQL. El trabajo es por objetivos y completamente freelance la forma de pago a convenir. Se busca en primera instancia el mantenimiento y desarrollo de nuevas funcionalidades. En segunda etapa el mejoramiento de la UI y finalmente
I have installed ActivePerl on centos and from command line work . When i start same command from task cron job of plesk i have this error Can't locate XML/[login to view URL] in @INC (you may need to install the XML::Twig module) (@INC contains: /opt/ActivePerl-5.26/site/lib /opt/ActivePerl-5.26/lib) at [login to view URL] line 8. BEGIN failed--compilation aborted at [login to view URL] lin...
I have a quick issue I just need some advice on Fixing or a slight change of code. JSON Response is being presented to the app however, it won't append to the Dictionary that I'm trying to use. Paying a maximum of $30AUD for this as it is a quick code fix. Just needs a simple fix.
Select rows to display the columns: name of product/service assign alias as “ProductService”, quantity sold of product (invoice detail), employeeID who is assigned to the invoice; where the employee ID equals 1; sort by name of product/service ascending.
SELECT [login to view URL], SUM([login to view URL] * [login to view URL]) as price FROM Customers INNER JOIN Invoice ON [login to view URL] = [login to view URL] INNER JOIN InvoiceDetail ON [login to view URL] = [login to view URL] group BY [login to view URL] I CAN"T SEEM TO GET THE Customers.Firstname...etc... because of the SUM... I can get one or the other but not both...
This work involves a pdf file of shipping labels with multiple pages that needs to be sorted based on a reference number in a text file that matches a label/page within a pdf file.. ie A list of alpha numeric letters/numbers are given vertically in a text file that need to be searched within the pdf file and as the pdf file finds the queries within its pages (which is one per page), it creates a n...
Ok, let try, I am new to these tech issues. I created a blog with blogger, actuall...paypal for subscriptions, but paypal has a function where they will generate usernames and passwords for clients subscribing to my subscription but I would need to install a perl script, well anyways I have attached a file where you can actually read the instructions.