最近在建一个外卖送餐的网站，需要接入Xunhupay的（微信和支付宝）支付模块。 网站使用的是foodomaa的整站代码： 需要的技能有： Software Version: PHP 7.x Software Framework: Laravel File Types Included: JavaScript JSJavaScript JSON HTML CSS PHP SQL Layered PNG 如果您感兴趣，可以写信给我，价格好商量。 另外网站还有其它的一些改版工作要做，我们可以具体讨论一下能不能一并做。 等您回复哦……
程序是： 首先 第一步： 随机抽取5个phome_ecms_news里面的id和classid 第二步： 读取phome_ecms_news的id和classid，作为函数使用 第3步： 插入phome_enewspl_1新的内容到数据库 例子：$sql = "insert into phome_enewspl_1(plid, pubid, username, sayip, saytime,id,checked,classid,zcnum, fdnum, userid,isgood,saytext,eipport) values (NULL, '1000310000019701', '', '', unix_timestamp(), '$id', '0', '$classid', '50', '1', '0', '0', '评论内容', '48010')"; 第四步： 更新phome_ecms_news的字段plnum+1并且对应第一步读取的id值 例子：UPDATE phome_ecms_news SET plnum =plnum+1 WHERE id = 20488;
To develop OTD KPI reports on JobBOSS: Calculate OTD archive rate by daily, weekly, monthly, there are two conditions need to be fulfilled, one is quantity delivery fulfillment, the delivered qty should equal to requested qty, another condition is delivered date, the delivered date should equal or be earlier than promised day. Scope: all closed SO which closed on curren...qty, another condition is delivered date, the delivered date should equal or be earlier than promised day. Scope: all closed SO which closed on current day, current week and current month. Set the OTD target If SO was delivered earlier on last month , then the OTD need to be included in last Month’s OTD KPI. by SO + Project number Use Chart display the OTD by day,week and month. Data source: ERP SQL DB Tool: ...
Hi Sunny， 我有个mysql数据库，速度需要提高，你有兴趣和时间帮忙吗？ 这个数据库有两个表的数据量在1千万左右，另外一个在1百万，并不是很大，也做了index，但是不清楚什么原因某些query还是很慢（超过2秒）。 谢谢！ 崔旭
Jie, 我有个mysql数据库，速度需要提高，你有兴趣和时间帮忙吗？ 这个数据库有两个表的数据量在1千万左右，另外一个在1百万，并不是很大，也做了index，但是不清楚什么原因某些query还是很慢（超过2秒）。 谢谢！ 崔旭
该项目需要开发人员，主要技术为： ASP.net/CS/MVC/WCF框架, DIV+CSS，JS(easyui/jquery/native JS/Ajax/Json). 熟悉Oracle数据库, 精通SQL及PL/SQL. 该项目周期大概两个月，之后会有不定期项目需要开发人员 人员需驻场，地点深圳或者天津。
1、精通VB.net，使用以上语言独立开发或深度参与过项目； 2、掌握SQL数据库的使用，能实现复杂查询语句，具备编写存储过程、触发器和函数的编写能力； 3、熟悉ERP、BOM或者MRP。 联系人：陈经理 联系方式：[REMOVED BY FREELANCER.COM ADMIN]
需要开发一套库存及订单管理系统，要求基于数据库（mysql或sql server均可）开发。 库存管理部分，要求对商品的入库出库有良好的输入及确认界面； 订单管理系统，因为是从客户的服务器上下载txt文件（内容为订单），需要将订单纳入数据库，然后根据库存情况判断能否发货，并在最终确定发货日期及发货数量后生成txt文件并上传回客户的服务器。下载及上传txt文件，有客户提供的软件，只要以命令行方式调用即可。 需要按照客户指定格式打印交货单。
...card management system , a need to develop alternatives to achieve full functionality. Features include : And existing interfaces hotel room sales management system ( call each webservice form , with the other engineers do ) ; Membership card classification management , distribution , auditing , enable, payment and other packaging ; Corresponding financial statements , business reports ; Query function ; ( Detailed function menu , see Annex photo ) Claim: We had a similar successful projects ; Autonomously communicate with customers , to explore the details of the demand ; Hotels need to travel to the customer site commissioning and implementation of the ( secondary cities in Sichuan Province ) ; Familiar with business processes better ; Please clearly state y...
android app & SQL/PHP web DB freelance job 詳情請email 查詢
我们目前有一个基于Windos Access 的一个内部应用软件， 我们希望能将其用WINDEV 来重新开发 以便于我们之后的应用。指定使用WINDEV 开发软件。在我们公司坐班工作，直到项目完成。
Requires a database that helps users in our company to organise different packaging specifications for each of our products. Since different customers require different packaging format of the same products, we need to be able to pick from existing packaging format or create new format for each customer. Requires the following functions. 1) Product overview (list all the items, and related different packaging specifications) 2) Functions that allow users to alter and add new packaging format for each item. 3) Functions that allow users to pick different products (and its respective forma) and output the selection to Excel or PDF 4) An import and export function that allows us to import all the existing packaging data into the database.
...charge recharge based procedures, similar to VPNExpress , The implementation of user registration, recharge (Alipay & Paypal), VPN account settings, password changes. The user account, close to expiration reminder, enterprise information submitted invoices, invoice mailing address submitted. The OpenVPN function to read, including account surplus time, monthly bandwidth query, history of bandwidth usage information. The interface is succinct, professional, similar to Bootstrap. We have a billing system Hostbill, so if you can develop Hostbill Api, you can not have the development of Web. 一个OpenVPN收费程序, iOS & Andarid & Website(或者使用Hostbill账单系统) 基于OpenVPN的收费充值程序, 类似VPNExpress , 实现用户注册,充值(Alipay & Paypal),VPN帐号设置,密码变更. 用户帐户, 有接近到期提醒,
SQL注入/代码审计/数据库权限/渗透测试技术 接渗透单子高手，联系电子邮箱：aqcp#（#改成@）语言要求：中文 熟练掌握各种内网渗透测试工具与相关知识，精通常见安全攻防技术：sql注入、xss、文件上传、文件包含、命令执行等漏洞 熟悉linux、unix、Windows、oracle、J2EE等各种环境下WEB的安全配置与安全检查及WEB漏洞防范； 熟悉各种脚本语言(asp,php,jsp,java,net、perl、python等)具备独立挖掘web安全漏洞与入侵手段 具备一定的网络安全知识，对网络安全结构、系统漏洞、入侵检测、病毒防护等有深入理论基础和实践经验； 熟悉渗透测试黑客攻防的步骤、方法、流程、熟练掌握各种渗透测试攻防工具有实际渗透经验者优先； 求大虾接单，脱裤，要求，电话，手机，姓名，邮箱，其他的一概不要。每笔单1000美金起步，根据站的难度而定价格,具体可以详谈，寻找长期合作. 态度认真、中介勿扰,请技术实力说话。
安全测试、漏洞发掘、漏洞渗透测试、安全审核、安全风险、服务器安全漏洞渗透测试评估与分析及加固； 联系QQ：840555737 2、对产品代码进行审视，找出安全漏洞并提出修改建议； 3、研究各种安全技术，编写和维护用于安全测试的攻击工具、防御工具和分析工具； 4、负责公司Web产品涉及到的安全性研究； 5、负责响应公司的安全事件； 6、为公司员工提供信息安全教育及培训。 岗位要求： 1、熟悉渗透测试的各类技术及方法，熟练掌握各种渗透测试工具；熟练操作各类操作系统、应用平台； 2、精通或熟练掌握php/perl/python/javascript/shell等多种脚本语言； 3、熟悉asp,php、jsp等主流的Web安全技术，包括SQL注入、XSS、CSRF等常见的安全漏洞利用； 4、熟悉国内外主流安全产品、工具，如：AppScan扫描器、wvs等； 5、对Web安全测试有自己的理解； 6、熟悉常见攻击和防御办法，熟悉web安全和渗透技术,能自行进行web渗透测试，恶意代码监测和分析； 7、熟悉ddos攻击类型和原理有一定的ddos攻防经验，能有效防御黑客挂马和恶意流量攻击，会熟练搭建负载均衡系统。
网站用途：园区展示官网 开发语言：php 参考网站： 具体要求： 需要设计的页面数量和网站功能参考附件。 代码要求： 无SQL INJECTION, XSS等漏洞；前端通过HTML和CSS有效验证，class和id等命名符合语义化规范；代码逻辑清晰有注释，方便后期修改升级。 网站维护： 服务商需要提供后期维护支持 其他要求： 服务商最好是成都公司，要有对公账号，可开发票。 请报价格、工期、设计师的portfolio以及在什么开源程序的基础上开发。 熟悉prestashop的优先。
网站建设要求是 网站程序语言是PHP 数据库为SQL Server 不需要做到也下几点： 1、网站界面大气大方 2、网站语言必须为 中午--英文 两种语言 根据访问者的IP来主动换语言 3、一般的交友网站的功能都要做到 4、网站主要功能有一下几点 1、在线聊天 2、在线动态 3、介绍好友 4、相册密码功能 5、在线音乐 6、签到 7、等级功能 8、举报-敏感词 5、这里有几个网站可以拿来参考 这是我的QQ号 929471701
I'm looking for a freelancer to assist me with data input tasks. The data to be inputted is sourced online, and it must be accurately and efficiently inputted into our system. Following data entry, the data will be used to update our database. Data Type: - Images - Text Requirements: - Min. 200 Full Described Entities per Week - Proficient in data input, especially sourcing from online databases - Skilled in database updating - Attention to detail to ensure data accuracy - Efficient and timely completion of tasks - Previous experience in similar roles would be beneficial
I'm in need of a skilled developer who is proficient in a variety of programming languages and can work on two key areas of my website. - Basket Featur...registration, the user remains on the registration page. This is not the intended behavior, and I need a solution that will ensure that users are correctly redirected to their profile page post-registration. . This video helps what im trying to say. Ideal candidates for this project should have a strong command of HTML, JavaScript, CSS, PHP, and SQL. In addition, experience with Stripe payment integration and troubleshooting registration processes on websites is highly desirable. Please note that these two tasks are interdependent, and hence, need to be addressed simultaneously.
I am currently facing an issue with my website - when a user registers on the site, instead of being redirected to their profile page ...redirected to their profile page or login page, the system keeps them on the same page. Furthermore, upon this failure to redirect, it shows it is successful when registering but doesn't take to another page. I need someone with strong proficiency in HTML, CSS, JavaScript, PHP, and SQL to diagnose the problem and implement a solution so that after successful registration, users are seamlessly taken to their profile page. The ideal candidate should have: - Significant experience in PHP, HTML, CSS, JavaScript, and SQL. - Proven track record in troubleshooting and rectifying website issues. - Firm understanding of user authentication a...
hello amazon sp installation do you have apibilgi When we query with asin, can we retrieve information about the products? Example: B01234345 brand, sales, ranking, seller, number of offers etc. information
Application code to implement Roomio as a web application in python. You will use the table definition posted at the end of this document.
... All the tables are fed from the main large table (secondly rate table - real time table). Details about the models: ML Model Development: Anomaly Detection Model: Develop a model using Random Forest algorithms to detect unusual patterns in energy usage. SARIMA Forecasting Model: Implement SARIMA models to forecast daily energy requirements, considering seasonal variations. Database: A cloud SQL real time database is preferred. Front end: After analyzing the data, I want to display the results to the user in Flutter with a very simple UI. I want to display: - Total energy consumption. - A graph for the total energy consumption by hour. - Energy consumed for each device. - Energy consumption compared to yesterday's. - Estimated energy consumption by end of t...
I need a talented VB.net developer with a strong background in SQL Server. Key Responsibilities: - Develop software applications using VB.net - Efficiently manage databases - Designing, coding, testing, and debugging software applications using VB.NET. - Calling third-party API - Payment gateway integration - Stored Procedure Ideal Candidate: - Proven experience in VB.net development - Strong familiarity with SQL Server - Good problem-solving skills - Ability to work independently and meet deadlines. Please provide relevant work samples in VB.net development and describe your experience with SQL Server.
I need an expert in SQL Server Report Builder 3.0 to help rejuvenate some lab reports. I require some amendments to be made to the current reports I have. Key Tasks: - Altering the way data is presented within the reports - Incorporating new fields to the current reports In the end, I need the same data results but with improved visibility and understanding. Ideal Skills: - Appropriate familiarity with SQL Server Report Builder 3.0 - Strong grasp of data visualization principles - Detail-oriented and precise to ensure report data remains accurate. Individuals that can deliver these changes precisely and quickly are highly preferred.
I'm looking for a skilled software developer to create a Windows application that focuses on generating data reports from a SQL database. Key Requirements: - The application must be compatible with the Windows platform - The main functionality of the application should be the generation of data reports. - The reports should be sourced from SQL database. Ideal Skills and Experience: - Proficiency in Windows application development - Strong knowledge and experience with SQL database and report generation - Previous experience with data reporting software would be a plus.
I'm in need of a Junior Full Stack Engineer who is proficient with Java, with beginner level experience. The primary task will be to work on implementing Go Live for an assigned project. Ideal skills for the job: - Understanding of Java programming language - Ability to work collaboratively on a team - JSON - XML - SQL - Data Mapping Some experience with project implementation is a plus. Dedicated beginners are also welcome to take their first steps in a real project.
I'm looking for a proficient developer who can add a page to my website that interfaces smoothly with my MySQL database. The website already has formatting etc, so I'm not looking for that. The database stores a variety of exercise data, and the webpage needs to display this data in an intuitive and user-friendly manner. Key webpage features include: - Display of exercise data: Each exercise's description and its difficulty level should be displayed. There's also a column in the database containing YouTube URL links, so another important feature the webpage needs is the ability to watch these exercise videos directly from the webpage. It is a simple database with only one table. - Users should be able to select the exercise they want from ...
I am looking for a skilled and experienced Full stack developer with Hands-on experience in Java Hands-on experience in Angular/ REACT Hands on experience on AWS RDS/AWS S3/Oracle/AWS Athena/ SQL In-depth knowledge in Core Java, Spring framework and RESTful API Services, Apache Camel, CI/CD Jenkins, Containerization Experience with AWS Cloud and its services like EC2, Athena, Lambda, S3, SQS and Cloud Formation Experience in writing JUnit test cases Problem-solving abilities
...handle data export processes, model and create tables and entity relationships, and develop an efficient and scalable database within a tight one-month deadline. ### Responsibilities: - Data Integration: connect and streamline data from multiple sources including ad platforms (like Google Ads, Facebook), website analytics tools (e.g., Google Analytics), CRM systems (e.g., Salesforce), and MAPs (e.g., HubSpot). - **Accelerated Database Design:** Design and implement a robust and scalable database that supports efficient data aggregation and analysis, within a short timeframe. - Entity-Relationship Modeling: Develop and finalize a comprehensive ER diagram that illustrates the database structure and supports urgent marketing analytics requirements. - Efficient ...
Good morning, for my client i need to make an implementation on WooCommerce - on the store the client selects a product and then the website sends a query to the website - provide the number of products on the network. The system will then return a list of places with available quantities of a given product. The system API is in JSON format. An authorization token is required to execute the query.
I'm in need of an experienced backend developer to create a mail parser with the following specifications: - **Email Protocol:** The mail parser should support SMTP, so proficiency in this area is a must. - **Primary Goal:** The primary function of this mail parser should be storing emails in a MySQL database. If you have experience with database integration, this would be a big plus. This project requires expertise in backend development, specifically with an understanding of how SMTP works. You should also be familiar with MySQL and have experience in integrating databases into applications. Please provide examples of similar projects you've worked on in your proposal. Thank you.
I need a VA with Wix store experience, a keen eye for detail, and proficiency in spreadsheet management. You'll be tasked with: - Keyword Optimization: Adjust the product titles on my Wix store to ensure they are optimized for search engines. Experience with SEO would be beneficial for this. - Database Creation: Develop a comprehensive database for all my products. This will include attributes like Product names, Product prices, and Product URLs. - Formatting: The database should contain separate columns for each product attribute. Strong organizational skills and experience with data entry would be ideal. Ultimately, the goal is to streamline the management of my product listings for a smoother business operation. Prior experience with Wix and creating pro...
I'm seeking an experienced .NET developer with over 4 years of expertise in C# programming and SQL databases. Key Responsibilities: - Enhancing existing software application - Adding new functionalities The ideal candidate should possess: - Strong experience in C# programming - Solid knowledge and practical experience with SQL databases Be ready to dive into the project and help us bring significant functionality enhancements to our existing software. Your experience and skills in C# and SQL will be invaluable in this task.
I'm looking for a skilled individual who has a good understanding of Mechanical Engineering and Data Science to help me set up a database that records the live feed of on-board sensors in a car. Key Responsibilities: - Utilizing an On-Board Diagnostic Tool and an app to record the data - Implementing a database to store the collected sensor data - Analyzing the data primarily for predictive maintenance using statistical analysis Ideal Skills: - Mechanical Engineering background - Proficiency in working with On-Board Diagnostic Tools - Strong experience in statistical analysis - Knowledge of database management systems and data analysis tools - Experience in predictive maintenance is a plus This project requires attention to detail, analytical thinking, and the...
I am searching for a Product Analyst who can apply their knowledge towards data analysis, market research, and performance monitoring. Its a small assignment This assignment involves diving into a snowflake database to explore how customers behave. The goal is to find useful information that can help the Product team make decisions to make the business grow. After you uncover insights, you'll suggest changes to the product, like adding new features, making current features better, or even getting rid of features that aren't working well. You need to do the analysis, create graphs to show your findings, share all the code you used, and also come up with a plan for an A/B test to try out one of your suggested changes. Note: Its a short assignment, not spend more than tw...
...performing poorly with slow website loading times and database slowdowns, which is unacceptable as I regularly have more than 500 concurrent visitors. The primary focus of this project will be optimizing the server's Plesk settings, Postgres and MariaDB databases, and PHP 8.2 configuration. Key tasks will include, but are not limited to: - Configuring Plesk for optimal performance, including adjusting server pool size - Identifying and implementing improvements to Postgres and MariaDB settings to reduce slowdowns - Tuning PHP 8.2 to enhance website speed and performance Ideal candidates for this project will have: - Proven experience in optimizing dedicated servers, particularly with Plesk and Almalinux - A solid understanding of database optimization, including ...
I am seeking a detail-oriented freelancer who can expertly transfer text data from PDF files into a database. The ideal candidate should possess the following skills and experience: - Proficiency in working with PDF files - Expertise in data entry tasks - Experience in formatting and structuring databases - Excellent attention to detail Suitable candidates need to handle copious amounts of text data, accurately convert the text-containing PDF files into a structured and organized database. This includes careful validation to ensure no data is lost or misrepresented during the data entry process.
Hi Ashish, this is for the tasks I emailed about.
I'm searching urgently for an experienced PHP architect who can const...items. - Integrating an 'Add to cart and checkout' feature ensuring a simple and smooth transaction process. - Developing order management and inventory tracking system within the admin panel to help me keep track of orders and product stocks. Skills and Experience Required: - Proficient in PHP programming - Experience in developing e-commerce websites - Solid understanding of databases and SQL - Familiarity with different payment solutions Although there is no specific requirement for payment method integration at the moment, the ability to seamlessly add these in the future is essential. My project requires immediate attention and the chosen freelancer needs to be able to commit and delive...
We have a website where the homepage currently loads slowly due to multiple API calls. Despite implementing asynchronous API calls, the page load time is still not meeting our target. We are looking for a skilled developer to optimize the homepage to load within 1 second. we need some one who can : Optimized homepage that loads within 1 second. Cron job implementation for fetching and updating api data of tokens price/5%/24%//etc basically - i want to load data everything from DB only , rather than multiple api calls. thakns
I am looking for...Oracle DBA with experience in both Oracle RAC (Real Application Clusters) and standalone Oracle databases. The primary goal of this project is performance tuning. Ideal Skills and Experience: - Proven experience with Oracle RAC - Proven experience with standalone Oracle databases - Specialization in performance tuning - Familiarity with Oracle Database 19c Key Responsibilities: - Implementing performance tuning strategies - Monitoring and optimizing database performance - Troubleshooting issues related to performance - Ensuring the smooth operation of both RAC and standalone Oracle databases The ideal candidate should have a deep understanding of Oracle databases and be able to provide tailored solutions for enhancing performance on both Oracle RAC and s...
...skilled developer who can build a customized matchmaking database for my internal use. The database will primarily focus on matching investors to investment opportunities. Key Features: - Storing Match Preferences: The database should be able to store various match preferences including minimum/maximum investment, minimum/maximum funding amount, geographical preference, and the type of funding. - User Authentication: As this database will be for internal use only, the user authentication should be secure and limited to specific staff members. No external user authentication is required. - Search Criteria: The database should have search functionality based on the geographic location. Ideal Skills: - Proficiency in database management ...
I'm seeking a proficient individual for constructing an Access database for my project. The principal requirements include: - Experience with Access, as that's the selected database management system. - Expertise in data storage and retrieval is essential. - The database will be storing textual and numerical data. Experience in handling these types of data is crucial. Ideal skills would include an in-depth understanding of Access, database design, data storage/retrieval techniques and knowledge in handling both textual and numerical data. This should make for a streamlined and efficient process. I'm excited for us to kickstart this project together!
The database is on the National Environmental Agency's website, and it includes all of the applications submitted for environmental permits. Here is a link to the database: Please go over all of the records, and filter ones that match all criteria: 1. EIA Screening Application/Statement or EIA Scoping Application/Statement and 2. The application is for an activity in the sea Start a new spreadsheet, and for every such record, meeting the above criteria, add a row to the spreadsheet including: date of the record, screening/scoping, title of the application (translated to English), a url linking to the application on the NEA website. In addition, download the screening/scoping report document, translate it to English with Google translate
We would like to hire a freelancer expert in development of Postgres Database and Synchronization of Data from our Headquarter to our Multiple Area Office (10 No.) and to Multiple Local PC (Around 300 Nos.) locations available in Network.
We have attached the details we need to sync our data from Headquarter to Area Office and than to local PCs and back again. for RFID based application.
I am looking for an expert in RFID technology and .NET programming to integrate the RFID into our current weighbridge system. Key Details: - 3rd Party System was developed using .NET and it does support API or external interface connections. - The task will involve programming to fully integrate the system with RFID technology. Skills and Experience: - Proficiency in .NET programming & SQL Database - Previous experience with RFID technology - Knowledge of API integration - Experience with weighbridge systems would be a huge advantage. Your role will be to ensure the smooth functioning of the weighbridge system post-integration and provide us with a user-friendly, effective RFID solution.
...my WooCommerce website's performance. Here's what I'm experiencing: - Slow page loading - High server load - Database query delays Although I’m already employing caching plugins and techniques for performance optimization, the difficulties persist. My WooCommerce site is hosted on a VPS/Dedicated hosting package. I'm in need of a WooCommerce expert who has significant experience in performance optimization, handling high server loads, and reducing database query delays. The ideal candidate should have: - Proven experience in troubleshooting and improving WooCommerce site performance - Strong knowledge of server management, particularly VPS/Dedicated hosting - Expertise in database management and optimization - In-depth exp...
