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.
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
I have a problem with the product & categorie bases. I have two languages, in spanish worked but in english not. Thanks.
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
...com for color scheme 1. "Search Breeders Page" with result list, similar to Freelancer - like https://www.freelancer.com/search/projects/ 2. "All Breeder Categories" page - with main sections to include "DOGS, CATS, OTHER" a. like https://www.freelancer.com/job/ 3. "Breeder Detail" page - must include the phollowing:
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
We have a Wordpress site that suddenly stopped displayed posts in tags, categories or menus. That is, if you click [login to view URL], it would return "no posts to display" even though the category is showing dozens of posts in the dashboard. The same happens for tags. The menu doesn't display anything. Steps we have taken: 1) Disable all plugins
I already have the possibility to add text under the categories, but in this text i cant configure any style. I would like to be able of editing this text (strong, H1, H2, etc...)
...general information about that category and it's products describing it. A spreadsheet will be provided with 1-3 keywords which can be included in the text. There are 16 main categories as follows: Tablets, Phones, Media Players, Wearable Devices, Sports & Outdoors, Electronic Gadgets, Projectors, Security, Audio & Video, Car Accessories, Health & Lifestyle
Hi, I want someone professional to implement the design on magento front end. I have the design/html already. There are a couple of other fixes, magento extension integration as well.
...products loaded to Prestashop (126.96.36.199) by default they all went to HOME category. We loaded file again after we created Categories - products are assigned to 2 categories and HOME is default. out of 100 products 20 have to categories (HOME and new correct) 80 still seats in HOME How i on those 20 products remove HOME category, that "new correct" will
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 rig...
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.
For this project, I will need the image source and SVG format. There are sample images will be provided and needs to be improved a bit. Preferably if you can follow the google guide to designing icons.
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...
Summary: We have 16 shoe categories on our e-commerce site. Your task is to find 100 shoes throughout the site [login to view URL] for each category and provide the article numbers which you can see on the product detail page.
I need you to build a landing page. budget 600 Rs
I have an apparel website and i need some graphics made for the categories im selling.. Ive attached some images of examples and size of graphics i need. Here's list of Catergories Accessories (Socks,Mugs,Phone Cases and Etc) Jackets Featured (Products that were featuring) Backpacks Hats Mens Apparel (T Shirts, Hoodies,Polo) Womens
I need a freelancer to edit my site so to make it show sub sub-categories. Need to make it compatible with my theme. My system is Opencart version: 188.8.131.52. My theme is [login to view URL]
I need a script that will scrape top 5 eBay auctions categories. The script must find the 2 most commonly used categories in the top 5 auctions and extract categories names and numbers. It will source ISBN from CSV than scrape data one by one and create 2 CSV, first with data from "All Categories" and second CSV with data from "Books, Comics & Magazin...