The mssql database you are currently using is slow to search You want to improve the speed of this slow search speed.
# 2013년6월 ~ 2013년12월 : 고양시 상수도 블록시스템 - 고객사 : 고양시청 - 근무사 : (주)제이앤씨시스템 계약직 - 사용기술 : Java, Spring, Oracle, ibatis, amchart, eazy-ui # 2014년1월 ~ 2014년3월 : 고양시 상수조 블록시스템 GIS적용 - 고객사 : 고양시청 - 근무사 : (주)제이앤씨시스템 계약직 - 사용기술 : Java, Spring, Oracle, iBatis, O2Map, OpenGIS # 2014년4월 ~ 2014년11월 : 주유소 누유관리 모니터링 시스템 - 고객사 : (주)에스티모빅 - 근무사 : 프리랜서 - 사용기술 : Java, Spring, MySql, MyBatis, jqgrid, bootstrap, daum map API, plot-chart # 2014년12월 ~ 2015년2월 : 생산관리 ERP설계 - 고객사 : (주)금강이엠씨 - 근무사 : 프리랜서 - 사용기술 : mockup UI tool # 2015년3월 ~ 2014년4월 : 블루투스 BLE 비콘통신 Android 개발 - 고객사 : (주) 바이트시스템 - 근무사 : 프리랜서 - 사용기술 : Android (블루투스 BLE 비콘통신, 서버 소켓통신) # 2015년7월 ~ 2014년8월 : 임베디드 리눅스장비 웹관리 프로그램 - 고객사 : (주)제이앤씨시스템 - 근무사 : (주)제이앤씨시스템 계약직 - 사용기술...
php, mysql, word press, bootstrap, jquery , ajax, html5 (모바일웹, 앱) 기술 우대
안드로이드에서 월별 달력의 해당일자에 맞춰 주문내용(총금액, 건수, 미배송건수)을 보여주려 합니다. Eclipse 소스를 원합니다. 달력은 월별로 이동이 되어야 하고, 현재일자는 배경색을 달리해서 표시가 되어야 합니다. 주문이 없는 날은 표시가 안 되면 됩니다. 일자를 선택하면 그 날 주문한 상품의 이름,수량이 보였으면 합니다. 주문상세내용이 보였으면 합니다. 그리고, 원격 Database 접속정보와 관련된 쿼리는 아래와 같습니다. OS는 windows 2012 , 데이터베이스는 MS-sql이고, 원격주소, 계정, 암호는 실제 내용을 알려드릴 수 없는 점 양해바랍니다. 현재 디비접속은 이런 형식으로 하고 있습니다. -> ,1000 (사이트주소,포트번호) , 계정 : Testaccount , 암호 : Test 입니다. 금액 쿼리 : Select replace(convert(varchar, cast(Isnull(Sum(Ori_price*qty),0) as money),1),'.00','') as Orderamt from Orderdetail where Convert(Varchar(8), Order_date,112) = '달력 일자' and DelYN='N' 금액은 붉은 색 글씨로 표시되었으면 합니다. 주문 건수 : Select count(Order_id) from Orders where Convert(Varchar(8), Order_date,112) = &...
...developer to make specific improvements to my existing PHP application and enhance its integration with QuickBooks Online. CURRENT: We have a QuickBooks Online application that syncs invoices from QuickBooks Online to two MySQL database tables (order headers and order lines). This application works correctly but we want to add a condition to the INSERT statement in this program so only invoices that have a custom field populated will get synced to these tables. The custom field name to check is "Online Order Number". Requirements: - Modify functionality of existing program to only INSERT records to MySQL table when invoice record contains a value in custom field "Online Or...
I'm in need of a skilled JavaScript developer to create a sophisticated web rich text linkage. I'd like this linkage to connect seamlessly with data from a web spreadsheet. The ideal candidate for this project would be comfortable with Onlyoffice, as I'm looking for advanced document collaboration features integrated into the solution. Key Points: - Develop a web rich text linkage that interfaces with a web spreadsheet - Expertise in JavaScript is mandatory - Familiarity with Onlyoffice for advanced document collaboration is a big plus - The solution should be hosted on an on-premise server If you have the skills and experience to deliver a reliable and feature-rich solution, please reach out.
I'm seeking a professional web developer, extremely proficient in PHP and MySQL who can upgrade sales and users modules in our POS system. - Abilities: You should have substantial experience and demonstrated proficiency in building complex, user-friendly websites. Your PHP and MySQL skills must be exemplary. - Preferred Framework: I don't have a particular PHP framework preference. You can use the one you're comfortable with.
I'm looking for a Laravel expert to integrate Google Sheets into my system. Specifically, I want to connect it with a form on my site for seamless data handling. I have an html form php file on my server (built in laravel). I would like a passcode (no username) added to the form that captures the user connected to the passcode when the form is submitted. I would like the data sent to Google Sheets when a user submits the form. The Google sheet is complex. I would like the form data sent to 1 of 13 sheets. It should search for the sheet name, date, and user (from the html form) to find the correct sheet and row to insert the data from 5 fields.
I'm looking for someone with experience with APIs and SDKs in Python who can guide me through successfully connecting to the Kwenta SDK. Your main task will be to help me connect it, so I can execute the order. I'm looking for someone who can explain things clearly and concisely, and is available to answer any follow-up questions I may have.
Olá, tenho um sistema simples de gestão feito em PHP com BD em MySQL, gostaria de converter esse BD para trabalhar de forma Multi Tenant (varias empresas no mesmo banco de dados em uma unica instalação), e tambem criar um painel administrativo para ativar e desativar essas empresas.
I’m seeking a skilled developer to convert my existing PortVB Desktop App into an iOS/Mac Desktop App. It a small tool that runs on a Windows PC and reads some flat XML files and inserts/updates a mySQL database. We need the same program to be able run on a iOS/Mac desktop. I have all the VB Project files/ Source code. - Skills in app development for iOS/Mac, ideally with previous experience in app conversion - Knowledge of data syncing, user authentication, and offline access, in case these features need to be incorporated - Familiarity with contacts management, communication, scheduling, calendar integration, and file/document management functionalities for potential focus areas - Creative design skills to poten...
...and other information from the ESP32 in real time. This is crucial for monitoring and making informed decisions. - **Graphical User Interface**: A clean, user-friendly interface is necessary for easy operation. Think about intuitive design and clear displays. - **Bluetooth Connectivity**: The app must be able to connect seamlessly to the ESP32 via Bluetooth. Reliable connectivity is a must. Interactions: - **Button presses**: The app will have buttons for the user to send commands to the ESP32. These should be responsive and intuitive. - **Text commands**: The user should also have the ability to input text commands. Think about a text box or prompt for this. - **Slider controls**: Some controls should be in the form of sliders....
...working in the unclaimed funds sector, I'm seeking a seasoned cold calling and appointment setting professional. Your main responsibility will be to contact individuals based in North America to assist them in the recovery of unclaimed funds. Here's a bit more about what I'm looking for: * Extensive experience in cold calling, preferably in the unclaimed funds or similar financial sector. * Familiarity with the North American market, and understanding the nuances involved in setting appointments in this region. * Excellent communication and rapport-building skills. * Experience in dealing with individuals rather than businesses. * Highly organized and able to manage and keep track of multiple a...
We are seeking an experienced developer or team to create a comprehensive web software and database system for the remote monitoring and control of cathodic protection stations (SKZ) equipped with TE-RCU control units. This project involves developing web applications, database design, and integration of communication modules for real-time data acquisition, SMS/GPRS control, and SCADA system interfacing. More details will be sent in private.
...WordPress, .NET Middleware, Azure Integration, and SDK Development Job Overview: We are seeking an experienced Full-Stack Developer to spearhead the development and integration of key system components within our e-commerce platform. The successful candidate will lead initiatives to enhance user interactions by developing a WordPress plugin, building a robust .NET middleware API, and integrating advanced Azure-based messaging services. Additionally, the role involves creating an SDK to facilitate easy integration for third-party AI bot services. This position is crucial for ensuring that our platform not only meets current technological standards but also adapts to future advancements and user needs, enhancing both the scalability and functionality of our se...
I'm in need of an experienced Linux and Server Admin who can help me with the following tasks: - Linux and Server Administration: Proficient in CentOS, you'll be managing my server and ensuring its optimal performance. - Web and App Installation: You'll be responsible for installing and configuring various websites - coded in PHP, Node.js, and React - on the server. Additionally, you'll need to install Flutter and React Native apps. The ideal candidate should have advanced understanding and practical experience in Linux system administration, server administration, and web/app installation. Proficiency in PHP, Flutter, and React Native is required. -------------------------------------------------------------------------------...
I'm looking for a talented and experienced web developer to enhance my existing betting website with new features and a fresh design. The primary goal is to make the site more engaging for users and ultimately boost its profitability. Key Project Details: - Fix the user interface - Integrate automatically payments - Implement API connectivity: Successful candidates should be able to seamlessly connect the website to relevant APIs to support the new features. Requirements: - Proven experience in web development, particularly in the betting industry, is highly preferred. - Proficiency in UI/UX design to ensure the website is not just functional but aesthetically pleasing. - Familiarity with API integration is ...
I am in need of a seasoned digital marketer who can proficiently handle SEO, social media management, and email marketing tailored to reach local customers. This role requires a keen understanding of how to effectively drive lead generation. Specific responsibilities include: * SEO: Optimize my website's organic search rankings to improve lead generation * Social Media Management: Craft and execute a strategic social media plan to connect with the local customer base * Email Marketing: Develop a captivating and result-driven email campaign The ideal freelancer: * Experience with SEO, social media management, and email marketing * Proven track record of lead generation * Understanding of local market demographics and trends * Strong an...
I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.
...domain that I'm looking to sell. It was originally intended for an e-commerce website. As I'm not planning to develop a website using this domain, I'm interested in finding potential buyers who can make the most of its e-commerce potential. Key Points: - The domain is ideal for e-commerce purposes, which makes it a great opportunity for someone in the online sales space. - I'm particularly interested in connecting with individual entrepreneurs, small to medium businesses, and potentially large corporations who are searching for a domain that fits an e-commerce website. I'm looking for someone who can help me find potential buyers and close the sale. This job will require: - Strong networking skills and an understand...
I'm in need of a skilled individual who is proficient in blockchain and wallet analysis, specifically on the Arbitrum blockchain. The project involves analyzing transaction patterns and wallet balances and activities. Key Requirements: - Proficiency in blockchain analysis, particularly on the Arbitrum blockchain - Ability to identify patterns and trends in transactions - Proficient in analyzing wallet balances and activities Deliverables: - A comprehensive report that includes methodology, analysis, and conclusion - The report should be presented in a combination of written format and visual presentation (charts and graphs) Please note that I will provide you with access to the necessary pages and data on Arbiscan. Your task ...
...This will enable us to create precise and engaging content that resonates with our target audience. We are in search of a skilled translator who is culturally aware, as our Chinese-speaking audience depends on us for content creation. In order to be relevant and accessible, it is important for the content to align with the local beliefs, practices, and trends. Furthermore, it is crucial to ensure that your tone and style align with the brand's voice and meet the expectations of your audience. Make sure to thoroughly review every detail for accuracy and cultural relevance. Ensure that the tone and style remain consistent, in line with our high quality standards. Ensure the highest level of quality in every project, prov...
I'm on the lookout for an experienced GDPR solicitor who can provide sound advice and representation on legal issues...volume of potentially sensitive phone call records. Here are the main tasks that the right candidate should be prepared to handle: * Legal Guidance: I need expert advice on how to navigate legal disputes related to potential data breaches involving phone call records. * Legal Representation: The ideal candidate must be well-versed in representing an organization during any potential legal dispute, with an emphasis on data breaches. If you have a thorough understanding of GDPR compliance, with a particular emphasis on data breach protocols - I would like to hear from you. Is there a demonstrated record of successful GDPR lega...
I need a bash script that can import and export data from my database to CSV files. Ideal candidate should be able to: - Create a bash script that can effectively import and export data - Have experience working with database management systems such as MySQL, PostgreSQL, or MongoDB - Ensure that the script securely creates user accounts and manages their access to the database. The script will be used for daily database management tasks, so it needs to be reliable, secure, and efficient.
I am in need of a skilled Java developer to create a comprehensive CRUDS (Create, Read, Update, Delete, Search) functionality for a ticket tracker application. The application should be backed by a MySQL database.
...developer to update my iPad app to fix a server connection issue. The app is currently unable to connect to the server, and this problem needs to be resolved. Once the update is complete, the app should be submitted to the Apple Store, and I require it to be compatible with iOS 12 and earlier. Key Requirements: - Fix the server connection issue preventing the app from connecting - Update the app to be compatible latest ios firmware - Submit the updated app to the Apple Store You should have: - Prior experience in iOS app development, particularly with server connection issues - Ability to navigate Apple's submission process and ensure the app meets their requirements - Proficiency in iOS ...
See attached detailed description of project. Ideal Skills: - Proficient in pHp 8 - Extensive experience in database integration, particularly with MySQL® - Strong problem-solving skills - Attention to detail and thorough testing - Previous experience with file processing in pHp I'm looking for a professional who can work efficiently and deliver high-quality results. If you believe you possess the necessary skills and experience for this project, I look forward to reviewing your bid.
I'm in need of a skilled WordPress plugin developer who can create a WordPress plugin for me. The plugin will be used to integrate Gravity Forms with our custom SaaS CRM. Key Requirements: - Integration of Gravity Forms with a custom SaaS CRM: The plugin should seamlessly connect the data collected from Gravity Forms to our custom CRM system - Urgent Timeline: I need this project done ASAP, so I'm looking for someone who can commit to this timeline Ideal Skills and Experience: - Proven experience in WordPress plugin development - Strong knowledge in integrating WordPress with external systems - Familiarity with Gravity Forms and CRM systems. It's beneficial if you have worked with custom CRMs before, though not mandatory
I...a skilled Shopify Public App developer to create an app for my business. The app should have the following features: - Custom Order Date Options: The ability to include unique Delivery Date options and configurations on my Shopify store. - Advanced Pickup: a customer chooses a pickup location to pick up her/his order and also uses third-party Google map API for pincode verification for pincode included or excluded for the delivery As a successful freelancer, past work is crucial. Please include examples of previous Shopify Public Apps you've developed or similar projects you have completed. This will give me a better understanding of your expertise in this area. Require Technology -> Node.js -> React.js -> Javascript -> jQuery -> REST...
I'm in need of an expert blockchain developer, specifically experienced in Solana, to work on a bot development project. The key functionalities of this bot will focus on trade execution. Key Project Details: - Primarily, you will be working on a bot that executes trades within the Solana ecosystem. - Familiarity with Jito Bundles, Raydium, and Jupiter DEX is a huge plus. - The bot should be developed using Node.js. Requirements: - Proficient in Solana blockchain development. - Strong expertise in Node.js. - Proven experience in developing trading bots. - Prior experience working with Jito Bundles, Raydium, and Jupiter DEX is highly desired. - A good understanding of trade execution strategies in the blockchain context. Please note:...
...experienced developer to work on a web project of mine. The project involves HTML, CSS, JavaScript, and some light database functions. The work will mainly focus on: - Implementing text input fields and dropdown menus: These are crucial elements for user interaction and data input. Your job would be to make them look and function as required. - Basic database functions: While the exact nature of these is yet to be decided, they will likely include retrieving and adding data. Your task will be to integrate these functions seamlessly into the site. Ideal skills for this project would include: - Proficiency in HTML, CSS, and JavaScript, with experience in creating user-friendly and responsive UIs. - Familiarity with basic database...
I am looking for a developer who could develop a iOS IPhone app. It should do following Use a authentifcation based on a MySQL database table (for login) store that login as session that I not need each time again login. Create a connection between that MySQL and grab data and display that on app. Store that data like on cache that I can see that data also offline. I only will answer to developer who native language are English or German and who could show some iOS work.
We have two sites on windows server that we would like to move to linux, without having to rewrite code for both sites. The current code is ASP and ASPX (vbscript) with Acess dbase. I am looking for someone that can make our ASP and ASPX pages to work on linux server with mysql dbase. We have a VPS on godaddy server, that we can host the two sites on. You are only qualified if you have done this many times before. You may not use our sites to "try" to do this after doing research, we only want experienced individuals on this.
Develop a WeChat/Alipay app for a large-scale event in Hong Kong, you need to use it on WeChat/Alipay. It can be used by people in Hong Kong, Macau and China. The functions are mainly used to view event information, videos, reminder functions, mini games, contact customer service, and connect Department external website
i need my aws rds mysql connceted with retool. it gives error and i am unable to link it. i need help fast so only if you can help in this moment not in 1 h
...aim is to achieve brand recognition rather than professionalism or engagement. So, my ideal freelancer will have the following skills and experience: - Logo and clothing design - Knowledge of youth trends - Success in creating logos that boost brand recognition What I'm looking for: - Creativity: I want unique designs that will capture the attention of young adults - Fusion: The logo and clothing designs should integrate seamlessly with each other. - Longevity: The designs should be timeless, so that they remain relevant and attractive to the intended audience over a long period of time. This project is all about brand recognition, so the designs you come up with need to be compelling, visually striking and be able to convey my brand's ide...
I'm in need of an experienced PHP MySQL developer to handle data management and manipulation, database design and optimization, as well as web application development for my project. The goal is to create a robust e-commerce website with the following features: - Product listing and details - Payment gateway integration Ideal candidates should have a rich background in PHP MySQL, web application development, particularly in e-commerce platforms, and database design and optimization. Your skills in crafting systems that are user-friendly, secure, and streamlined will be essential. Emphasizing on data management and security is also paramount in this project. Let's connect if you possess these ski...
I'm currently facing an issue with my MySQL replica. Although there are no errors, the data isn't being synced and the "Seconds_Behind_Master" is consistently increasing. I'm looking for a professional who can help me with this problem. I can't give you access to the server(s) but we can troubleshoot together. Key Requirements: - Expertise in MySQL command line - In-depth understanding of MySQL replication mechanisms - Experience in troubleshooting replication lag - Ability to work quickly and efficiently Max 50 euros. Thank you.
I require professional support in aiding my design and create a stunning newsletter with custom banners. I have crafted the wireframe for this email newsletter, however I need it to be heavily enhanced, and beautified, with the banners designed. I also have additional work on a sharpoint site that Im creating. So a professional with attention to detail and remarkable graphic design will be highly sought after. I can upload the content of the below attached wireframe once we connect. ---------------------------- I am seeking a skilled and experienced graphic designer to craft remarkable newsletters and banners for my newsletter. To ensure the designs align with our exact brand guidelines, high attention to detail is essential. Key Projec...
...seeking an imaginative designer to create unique abstract graphics for a line of t-shirts primarily targeting young adults. The designs should be trendsetting and appeal to their creative and vibrant tastes. Skills and Experience required: - Proven experience in Graphic Design, specifically in t-shirt designs - Proficiency in design software including Adobe Illustrator and Photoshop - Experience in creating abstract art designs - Ability to understand and connect with the intended audience demographic What I need from you: - Develop captivating and innovative abstract designs for my t-shirt line - Ensure designs resonate with the tastes and preferences of young adults. Your designs will be a crucial part of my brand identi...
...an expert to help configure my Cyclecloud HPC cluster. This is a specific project with the following requirements: - Configuring the cluster for machine learning and simulations tasks - Ensuring the cluster can handle large data processing in a timely manner - Implementing efficient resource utilization strategies - Validating the performance of the cluster with real-world workloads The ideal candidate for this role should have: - Proven experience in configuring Cyclecloud HPC clusters - A strong understanding of machine learning and simulation requirements - The ability to optimize resource utilization and improve scalability - Excellent communication and problem-solving skills read the specs: What I would like to do is to set up a Cyc...
...looking for a talented Android developer to build a secure and feature-rich mobile application along with a Laravel-based admin panel for remote management. Responsibilities: Develop an Android application (minimum Android 8) with the following functionalities: Read incoming SMS and identify target keywords. Send identified keywords to a designated remote server. Receive and display SMS messages triggered from the admin panel. Implement a sync button to synchronize SMS data and send details to the remote server. Design and develop a secure admin panel using Laravel 10, MySQL 8, and PHP 8: User registration and management. Device registration with approval workflow. Device blocking functionality. SMS panel to send SMS commands to registe...
...via global free-to-play mobile games. Our mission is to championing social good and the sustainability of our ecosystems through games. Want to join a small but experienced and passionate game dev team as a full stack developer? Develop and manage code and infrastructure such as cloud server, backend databases, APIs, and automation scripts. Help build powerful game ops tools with simple frontend UI. - - - Job Specs: - Create backend solutions and integrate with cloud platforms like AWS and Digital Ocean. - Design and deploy modern frontend user interfaces using the latest UI technologies. - Build secure and scalable mobile app REST APIs. - Manage databases using MySQL and NoSQL. - Use DevOps tools to monitor and scale applications. Looking For: - ...
I'm in need of a professional who has extensive experience with SharePoint, Power Apps, Power Automate, and secondary Power BI . I need support for my consultant indian time 8:30 pm to 11:30 pm Monday to Friday. 12$/hourly.. payment every saturday vai peayplea. I already have other indian guys who are working with me since 2019 to present. This support will be on zoom meeting. Which we will provide u and u will connect with my consultant for support.
To create a precise 3D model of a small-sized charging case for the AirPods Pro 2 in Blender, here's a detailed plan based on your specifications. Specifications Recap: PCB and Battery Dimensions: 33 x 40 x 10 mm AirPods Pro 2 Dimensions: Height (H): 30.9 mm Width (W): 21.8 mm Depth (D): 24.0 mm Design Requirements: The case should connect to the top and be formed like a butterfly. The two circular charging metals at the bottom should be positioned to the left and right. The part of the AirPods Pro 2 that goes into the ears should stick up 15 mm above the case. Steps to Create the 3D Model in Blender: Set Up Blender: Open Blender and delete the default cube. Model the Charging Case: Create the Main Body: Press Shift + A to add...
It is necessary finish a web application in python + django regard the statistic of stocks. So it is necessary: some fetaures of some filter; -. make some change to mysql database and api to datafeed. -. verify the formulas and add some features; -. make better the design. - create an admin page with security login and import stocks manually. Please answer only if you can show similar experiences
...good understanding of how to market and cater to a diverse target audience including art collectors, crypto enthusiasts, and the general public, as well as traders and investors. To successfully carry out this project, the freelancer will need: - Expertise in NFTs and the digital asset landscape - Strong familiarity with the OpenSea platform and other NFT marketplaces - Proven experience in digital marketing and sales - Adequate understanding of art, crypto, and the general public's interests - An ability to connect with potential collectors, crypto enthusiasts, traders and investors Payment Terms: Payment to the freelancer is made upon the sale of unique Matryoshka KF NFTs. After successfully selling the NFT token ...
...WordPress Developer to join our team. As a WordPress Developer, you will be responsible for both the frontend and backend development of our WordPress websites. Your main tasks will include creating and editing custom themes and plugins, optimizing website performance, and implementing new features (such as translating plugin language, or overwriting some existing AI features). The ideal candidate should have strong knowledge of WordPress, PHP, MySQL, and frontend technologies such as HTML, CSS, and JavaScript. Responsibilities: - Develop and maintain WordPress websites - Create custom themes and plugins - Optimize website performance - Implement new features and functionalities Requirements: - Proven work experience as a WordPress Developer - Strong prof...
I'm in need of an experienced professional who can create a 60-second animated video ad for my company. The primary aim of this ad is to appeal to a business professional audience. Key aspects of the project include: - A 60-second duration: The video must be engaging and concise, delivering the brand message effectively within this timeframe. - Animated style: I'm looking for a visually appealing and creative animated video. This will require a skilled animator with a good understanding of business communication. - Audience-centric approach: The video should be tailored specifically for business professionals in terms of content, style, and tone. The ideal candidate for this project will have: - A strong portfolio of animated videos, preferably wit...
Busco desarrollador web para realizar una página exclusivamente con Java, Javascript, HTML, CSS (puede usar Bootstrap) con base de datos MySQL utilizando XAMPP (phpmyadmin) y Apache NetBeans/Eclipse como entorno. La pagina tiene que tener un inicio de sesión/registro de 2 tipos de usuario (usuario cliente y administrador). La pagina tendrá un menú de navegación en la parte superior con varias pestañas: inicio (introduccion a la web, ultimas noticias, etc), videojuegos (aqui estaran todos los videojuegos de la web con un filtro de busqueda por genero y plataforma sacado de la base de datos donde se ve el nombre de cada uno, foto de su portada, genero, plataforma, fecha de lanzamiento, etc. y alguna opcion para ponerles nota, opinar, a&...
