Saya...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
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 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.
I need a GET function that will query a remote PostgreSQL table that contains latitude and longitude of different items so you can generate a link to open in Google Maps app with route where optimize:true I will provide access to table and google maps api key That's all
...definition rules given in the json file, data in CSV file should be loaded to Kafka and using Kafka streaming, data needs to be transformed to 3NF form and loaded to GCS/Google Big Query . The main objective is,When schema changes , dynamically the code should absorb the changes in kafka without modification in the code. Skillsets: Big Data-Kafka,Spark-Scala
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
...in configuring 5 Alphavantage timeseries reports in powerBI. 1. Five reports in powerBI - Daily (3 - stocks, forex, crypto); Intraday (1-stocks), Sector(1) 2. You need to google list of global stock codes and their company names, in BSE NSE NYSE and their tickers codes and add it is a column in teh reporting. We need end user to filter and compare
...flight information from Google Flights. The tool should run using an interface (mask) that lets me choose the following: - Departure Airport (code) - Destination Airports (codes separated by a comma) - Departure Date - Return Date - Class of flight (multiple selection must be available for all classes, which means the query will run once for each class
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.
I need someone to write a simple sql query to copy fields between tables
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
...example data downloaded from Google Search Console about a fictional bike company called "Example". Google Search Console allows us to download data about our website to see how we are ranking for given search terms. To explain the columns if you are not familiar; queries are the actual search term that has been typed into google, clicks are the amount of
...activation code and press Deactivate Button. Fire query to my-sql database to check if the activation code is valid. If code is invalid then display error message saying “Invalid Activation Code.” If the activation code is valid to go page 2. Page 2: Display verified activation code on the top. Have google re-captcha check box. Once captcha verified then
...2) The tool must take each keyword and run a query in Google with "allintitle:keyword". 3) Google will return a number of results from the above query. For example, Google returns the following text: "About 92 results" 4) The tool must store each keyword with the number of results (from allintitle query) in a new CSV file for expor...
Hi Hanad A., I noticed your profile and would like to see if you can assist me with my query and what sort of costs i would be looking at (I have just put the basic £10 to start a conversation with you, not trying to insult you). I have had an app created that I would like to overhaul/upgrade a little and was thinking a freelancer would suit me better
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.
...upc, Google's PLA id, our product name, our inventory quantity), plus a checkbox based upon sql query results we will provide. Add 3 buttons with the indicated functionality to the window, Pause, Remove, Un-pause. The buttons will interact with our Google PLA products and apply the indicated results to product listings. Amazon data will not be affected
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...
I need you to build a landing page. budget 600 Rs
...HTML5, and CSS3 Integration of multiple applications and systems (APIs, Solr, Lucene etc.,) Familiarity with SQL/NoSQL databases and their declarative query languages Cloud hosting (Azure, AWS, Google) Proficient understanding of code versioning tools, such as Git or Bitbucket...
...compare, review, and purchase products. The back-end will need to sort data and receive calls from the front-end. Requirements 1. Use MEAN Stack a. integrate API’s such as google maps, Paypal, email, etc., b. Supports front-end development using HTML/CSS/Angular JS (Single Page Application) 2. Build out an application database that connects to server
I have a query in place and would like to create a form with drop down boxes that allows the user to run the query based on the criteria they select. I have started the form but am struggling with linking the combo boxes to the query.
[login to view URL] Need 5 sheets 3 Form 1 query With users. To my webpage. All the info is in 3 google docs in the link. I use wordpress but you can use any method. Please tellme the final price, I will not pay more than your price. take your time to see the 3 documents. I need this in my web page
Hi , we want to promote my blog....blog. i want promote it, digital marketing as it display at google first page with some keywords. we have very less page in blog do we need more pages? [login to view URL] [login to view URL] Please check and let me know cost and time estimation for this task. If you have any query your most welcome. Thanks.
...create Mongodb query. It's maybe not the most complex query you ever find but we have not too much experience in MongodDB and how to use all this features. The query will cover all the basis filters and the use of the geospatial feature (just a simple search of maxdistance usign coordinates, we already have this). Basically, the query has to: Search