#164 String Length C# +50 
string str = Console.ReadLine();
string len = 0;
for(int i = 0; i < str.Length; i++)
{
    len++;
}

Let's get string length :| Dummy

Comments
By Manoochehr Mojgani, 2017-12-13 16:47:11
#148 Stock items are SUPER valid JavaScript +49 
// Is this valid?
function validateStockInItems() {
    if (stockInItemsToUpdate.length === 0)
        return true;
    return true;
}

Found in a legacy code base for a stock management system. I will be rewriting said system soon.

Comments
By Anonymous, 2017-12-13 09:15:42
#234 Random C# +47 
string random = "1";
Comments
By Anonymous, 2018-01-11 20:23:55
#147 internationalism Java +46 
int number = -1;
                //todo: refactor this horse shit.
                for (String res: results) {
                    if(number == -1){
                        if(res.toLowerCase().contains("ten") || res.contains("10") || res.contains("１０") || res.contains("十") || res.contains("십")){
                            number = 10;
                        }
                        else if(res.toLowerCase().contains("nine") || res.contains("9") || res.contains("９") || res.contains("九") || res.contains("구")){
                            number = 9;
                        }
                        else if(res.toLowerCase().contains("eight") || res.contains("8") || res.contains("８") || res.contains("八") || res.contains("팔")){
                            number = 8;
                        }
                        else if(res.toLowerCase().contains("seven") || res.contains("7") || res.contains("７") || res.contains("七") || res.contains("칠")){
                            number = 7;
                        }
                        else if(res.toLowerCase().contains("six") || res.contains("6") || res.contains("６") || res.contains("六") || res.contains("육")){
                            number = 6;
                        }
                        else if(res.toLowerCase().contains("five") || res.contains("5") || res.contains("５") || res.contains("五") || res.contains("오")){
                            number = 5;
                        }
                        else if(res.toLowerCase().contains("four") || res.contains("4") || res.contains("４") || res.contains("四") || res.contains("사")){
                            number = 4;
                        }
                        else if(res.toLowerCase().contains("three") || res.contains("3") || res.contains("３") || res.contains("三") || res.contains("삼")){
                            number = 3;
                        }
                        else if(res.toLowerCase().contains("two") || res.contains("2") || res.contains("２") || res.contains("二") || res.contains("이")){
                            number = 2;
                        }
                        else if(res.toLowerCase().contains("one") || res.contains("1") || res.contains("１") || res.contains("一") || res.contains("일")){
                            number = 1;
                        }
                    }
                }

refactor this horse shit.

Comments
By mister MVC, plus grumpy commenter, 2017-12-13 07:28:20
#250 Check if date was posted PHP +46 

$d = explode(".",$request->get("due_date",".."));
foreach ($d as $key => $val) $d[$key]=(int)$val;

if (
	!is_numeric($d[0]) || $d[0]<1 ||$d[0]>31 ||
	!is_numeric($d[1]) || $d[1]<1 ||$d[1]>12 ||
	!is_numeric($d[2]) || $d[2]<2005 ||$d[2]>2100 ) {
    $error["due_date"] = "Missing date.";
}

I think this was the last piece of code the developer wrote .... :D

Comments
By elpado, 2018-02-15 14:41:45
#243 kill me Python +45 
for x,x1 in enumerate(hack):
 
        if hack[x] in letters:
            exception +=1

ffs why

Comments
By just why, 2018-02-05 01:25:30
#44 Letter to number Java +44 
private static int alphabetToNumber(String letter) {
    String s = letter.toLowerCase();
    if (s.equals("a")) {
        return 1;
    } else if (s.equals("b")) {
        return 2;
    } else if (s.equals("c")) {
        return 3;
    } else if (s.equals("d")) {
        return 4;
    } else if (s.equals("e")) {
        return 5;
    } else if (s.equals("f")) {
        return 6;
    } else if (s.equals("g")) {
        return 7;
    } else if (s.equals("h")) {
        return 8;
    } else if (s.equals("i")) {
        return 9;
    } else if (s.equals("j")) {
        return 10;
    } else if (s.equals("k")) {
        return 11;
    } else if (s.equals("l")) {
        return 12;
    } else if (s.equals("m")) {
        return 13;
    } else if (s.equals("n")) {
        return 14;
    } else if (s.equals("o")) {
        return 15;
    } else if (s.equals("p")) {
        return 16;
    } else if (s.equals("q")) {
        return 17;
    } else if (s.equals("r")) {
        return 18;
    } else if (s.equals("s")) {
        return 19;
    } else if (s.equals("t")) {
        return 20;
    } else if (s.equals("u")) {
        return 21;
    } else if (s.equals("v")) {
        return 22;
    } else if (s.equals("w")) {
        return 23;
    } else if (s.equals("x")) {
        return 24;
    } else if (s.equals("y")) {
        return 25;
    } else if (s.equals("z")) {
        return 26;
    } else {
        return 0;
    }
}
Comments
By Anonymous, 2015-07-22 14:54:18
#108 No exception for you! Python +44 
try:
    self._update_plan()
except Exception as e:
    raise Exception('{0}'.format(e))

RIP debuggability

Comments
By Anonymous, 2017-12-12 05:22:22
#176 is between... JavaScript +43 
if (i === 1 || i === 2 || i === 3 || i === 4 || i === 5 || i === 6 || i === 7 || i === 8 || i === 9 || i === 10){
 return true;
}
Comments
By foxy, 2017-12-13 23:25:17
#38 The authentication. HTML +42 
<form>
    Login : <input type=textbox name=login><br>
    Password : <input type=password name=pass><br>
    <input type=button value="OK" onCLick="if (login.value=='admin'&&pass.value=='123456') window.location.replace('admin.php'); ">
</form>
Comments
By Anonymous, 2015-07-22 14:31:42
#45 Number of workers SQL +41 
CREATE FUNCTION [dbo].[get_number_of_workers] 
(
     @number_of_workers varchar(10)
 
)
RETURNS int
AS
BEGIN
 
 
set @number_of_workers = replace(replace(replace(replace(LTRIM(RTRIM(@number_of_workers)), char(9), ''), char(10), ''), char(13),''), char(13)+char(10), '')
 
DECLARE @temp varchar(10)
 
SELECT
    @temp = number_of_workers 
FROM
    (SELECT LTRIM(RTRIM(@number_of_workers)) as number_of_workers) as temp
WHERE
       number_of_workers like  '[0-9]'
    or number_of_workers like  '[0-9][0-9]'
    or number_of_workers like  '[0-9][0-9][0-9]'
    or number_of_workers like  '[0-9][0-9][0-9][0-9]'
    or number_of_workers like  '[0-9][0-9][0-9][0-9][0-9]'
    or number_of_workers like  '[0-9][0-9][0-9][0-9][0-9][0-9]'
    or number_of_workers like  '[0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
    or number_of_workers like  '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
    or number_of_workers like  '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
    or number_of_workers like  '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
    or number_of_workers like  '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
     
     
RETURN CONVERT(INT, @temp)
 
END
Comments
By Anonymous, 2015-07-22 14:59:09
#59 PHP +41 
function mysql_escape_string($str) {
    
    $pattern = [
        '/\x00/',
        '/\n/',
        '/\r/',
        '/\//',
        "/'/",
        '/"/',
        '/\x1a/',
    ];
    
    $replacement = [
        '\\x00',
        '\\n',
        '\\r',
        '\\',
        "\'",
        '\"',
        '\\x1a',
    ];
    
    $res = preg_replace($pattern, $replacement, $str);
    return $res;
}
Comments
By Anonymous, 2016-02-13 18:22:55
#98 This makes me sad :( C++ +41 
extern "C"
{
	#include "gz.cpp"
	#include "md4.cpp"
	#include "socket.cpp"
	#include "tdlini.cpp"
	#include "tdlfs.cpp"

}

:(

Comments
By Anonymous, 2017-10-01 04:08:55
#102 #Why? Java +41 
@RequestMapping(value = "user/getOnlineApplicationsList", produces = "XML/Text; charset=utf-8", method = RequestMethod.POST)
	public @ResponseBody String getOnlineApplicationsList(HttpSession session, HttpServletRequest request,
			@RequestParam("status") int status, @RequestParam("fullname") String fullname,
			@RequestParam("privateNumber") String privateNumber, @RequestParam("phoneNumber") String phoneNumber,
			@RequestParam("applicationIdFrom") String applicationIdFrom,
			@RequestParam("applicationIdTo") String applicationIdTo,
			// @RequestParam("dateFrom") String timeFrom,
			// @RequestParam("dateTo") String timeTo,
			@RequestParam("order") int order, @RequestParam("companyId") int companyId) {
		try {
			TimeFunctions tf = new TimeFunctions();
			StringBuilder ret = new StringBuilder();
			List<OnlineApplication> onlineAppList = new ArrayList<OnlineApplication>();
			List<OnlineApplicationForConsumerLoan> onlineAppListCL = new ArrayList<OnlineApplicationForConsumerLoan>();

			if (companyId == 3) {
				onlineAppList = onlineAppService.getOnlineApps(fullname, privateNumber,
						tf.dateStrToMilliseconds("11-11-1111"), tf.dateStrToMilliseconds("11-11-9999"), 0, 250, order,
						status, phoneNumber, applicationIdFrom, applicationIdTo);
			}
			else if (companyId == 2) {
				onlineAppListCL = onlineAppService.getConsumerOnlineApps(fullname, privateNumber,
						tf.dateStrToMilliseconds("11-11-1111"), tf.dateStrToMilliseconds("11-11-9999"), 0, 250, order,
						status, phoneNumber, applicationIdFrom, applicationIdTo);
			}
		
			else {
				onlineAppList = onlineAppService.getOnlineApps(fullname, privateNumber,
						tf.dateStrToMilliseconds("11-11-1111"), tf.dateStrToMilliseconds("11-11-9999"), 0, 250, order,
						status, phoneNumber, applicationIdFrom, applicationIdTo);
				onlineAppListCL = onlineAppService.getConsumerOnlineApps(fullname, privateNumber,
						tf.dateStrToMilliseconds("11-11-1111"), tf.dateStrToMilliseconds("11-11-9999"), 0, 250, order,
						status, phoneNumber, applicationIdFrom, applicationIdTo);
			}
			for (OnlineApplication onlineApp : onlineAppList) {
				if (onlineApp.getStatus() == 0) {
					ret.append("<br>"
							+ "<table style=\"width:100%; height: 180px; border: 1px solid black; text-align:center; border-collapse: collapse; spacing: 5px;\">"
							+ "<tr style=\"background-color:#85C1E9; height: 20px; font-weight: bold;\">"
							+ "<td>ID</td>" + "<td>თანხა</td>" + "<td>პერიოდი</td>" + "<td>სახელი გვარი</td>"
							+ "<td>დაბ.თარიღი</td>" + "<td>პირადი ნომ.</td>" + "<td>მობილური</td>"
							+ "<td>სამუშაო სფერო</td>" + "<td>კომპანია</td>" + "<td>პოზიცია</td>" + "<td>ხელფასი</td>"
							+ "<td>სტატუსი</td>" + "</tr>" + "<tr>" + "<td>" + onlineApp.getOnlineAppId() + "</td>"
							+ "<td>" + Math.round(onlineApp.getAmount().doubleValue() * 100.0) / 100.0 + "</td>"
							+ "<td>" + onlineApp.getPeriod() + "</td>" + "<td>" + onlineApp.getFullname() + "</td>"
							+ "<td>" + onlineApp.getBirthdate() + "</td>" + "<td>" + onlineApp.getPersonalNumber()
							+ "</td>" + "<td>" + onlineApp.getMobilephone() + "</td>" + "<td>"
							+ onlineApp.getWorkField() + "</td>" + "<td>" + onlineApp.getCompanyName() + "</td>"
							+ "<td>" + onlineApp.getPosition() + "</td>" + "<td>" + onlineApp.getSalary() + "</td>"
							+ "<td>" + getNameForStatus(onlineApp.getStatus()) + "</td>" + "</tr>"
							+ "<tr style=\"background-color:#85C1E9; height: 20px; font-weight: bold;\">"
							+ "<td>მუშ.ხან.</td>" + "<td>დამ.შემოსავალი</td>" + "<td>თვ.გადასახდელი</td>"
							+ "<td>ოჯახ.მდგომ.</td>" + "<td>შვილები</td>" + "<td>დასაქ.ოჯახ.წევრები</td>"
							+ "<td>საერთო შემოსავალი</td>" + "<td>თარიღი</td>" +  "<td>ინკასო</td>" +
							"<td>დადასტურება</td>"+ "<td>უარყოფა</td>" + "<td>წაშლა</td>" + "</tr>" + "<tr>" + "<td>"
							+ onlineApp.getWorkTime() + "</td>" + "<td>" + onlineApp.getAdditionalIncome() + "</td>"
							+ "<td>" + onlineApp.getLoanFreqAmount() + "</td>" + "<td>" + onlineApp.getMaritalStatus()
							+ "</td>" + "<td>" + onlineApp.getChildren() + "</td>" + "<td>"
							+ onlineApp.getWorkingRelatives() + "</td>" + "<td>" + onlineApp.getTotalIncome() + "</td>"
							+ "<td>" + tf.millisecondsToDateStr(onlineApp.getAdditionTime()) + "</td>"
							+ "<td>"+(onlineApp.isIncaso() ? "ინკასო":"არ ადევს")+"</td>" + "<td bgcolor=\"lightgreen\" onclick=\"approveApplication(" + onlineApp.getOnlineAppId()
							+ "," + onlineApp.getCompany() + ")\"><img height=\"20px\" width=\"20px\" src=\""
							+ request.getContextPath() + "/resources/images/accept.png\"></td>"
							+ "<td bgcolor=\"LightCoral\" onclick=\"rejectApplication(" + onlineApp.getOnlineAppId()
							+ "," + onlineApp.getCompany() + ")\"><img height=\"20px\" width=\"20px\" src=\""
							+ request.getContextPath() + "/resources/images/reject.png\"></td>"
							+ "<td bgcolor=\"silver\" onclick=\"deleteApplication(" + onlineApp.getOnlineAppId() + ","
							+ onlineApp.getCompany() + ")\"><img height=\"20px\" width=\"20px\" src=\""
							+ request.getContextPath() + "/resources/images/delete.png\"></td>" + "</tr>" + ""
							+ "<tr><td colspan=\"3\">" + onlineApp.getLoanPurpose() + "</td><td colspan=\"5\">" + onlineApp.getBranch() + "</td></tr></table>" + "<br>");
				} else if (onlineApp.getStatus() == 1) {
					ret.append("<br>"
							+ "<table style=\"width:100%; height: 180px; border: 1px solid black; text-align:center; border-collapse: collapse; spacing: 5px;\">"
							+ "<tr style=\"background-color:#85C1E9; height: 20px; font-weight: bold;\">"
							+ "<td>ID</td>" + "<td>თანხა</td>" + "<td>პერიოდი</td>" + "<td>სახელი გვარი</td>"
							+ "<td>დაბ.თარიღი</td>" + "<td>პირადი ნომ.</td>" + "<td>მობილური</td>"
							+ "<td>სამუშაო სფერო</td>" + "<td>კომპანია</td>" + "<td>პოზიცია</td>" + "<td>ხელფასი</td>"
							+ "<td>სტატუსი</td>" + "</tr>" + "<tr>" + "<td>" + onlineApp.getOnlineAppId() + "</td>"
							+ "<td>" + Math.round(onlineApp.getAmount().doubleValue() * 100.0) / 100.0 + "</td>"
							+ "<td>" + onlineApp.getPeriod() + "</td>" + "<td>" + onlineApp.getFullname() + "</td>"
							+ "<td>" + onlineApp.getBirthdate() + "</td>" + "<td>" + onlineApp.getPersonalNumber()
							+ "</td>" + "<td>" + onlineApp.getMobilephone() + "</td>" + "<td>"
							+ onlineApp.getWorkField() + "</td>" + "<td>" + onlineApp.getCompanyName() + "</td>"
							+ "<td>" + onlineApp.getPosition() + "</td>" + "<td>" + onlineApp.getSalary() + "</td>"
							+ "<td>" + getNameForStatus(onlineApp.getStatus()) + "</td>" + "</tr>"
							+ "<tr style=\"background-color:#85C1E9; height: 20px; font-weight: bold;\">"
							+ "<td>მუშ.ხან.</td>" + "<td>დამ.შემოსავალი</td>" + "<td>თვ.გადასახდელი</td>"
							+ "<td>ოჯახ.მდგომ.</td>" + "<td>შვილები</td>" + "<td>დასაქ.ოჯახ.წევრები</td>"
							+ "<td>საერთო შემოსავალი</td>" + "<td>თარიღი</td>" + "<td>ინკასო</td>"
							+ "<td align=\"center\">კომენტარები</td><td align=\"center\">აპლიკაციის დამატება</td><td align=\"center\">აპლიკაციის უარყოფა</td>"
							+ "</tr>" + "<tr>" + "<td>" + onlineApp.getWorkTime() + "</td>" + "<td>"
							+ onlineApp.getAdditionalIncome() + "</td>" + "<td>" + onlineApp.getLoanFreqAmount()
							+ "</td>" + "<td>" + onlineApp.getMaritalStatus() + "</td>" + "<td>"
							+ onlineApp.getChildren() + "</td>" + "<td>" + onlineApp.getWorkingRelatives() + "</td>"
							+ "<td>" + onlineApp.getTotalIncome() + "</td>" + "<td>"
							+ tf.millisecondsToDateStr(onlineApp.getAdditionTime()) +
							 "<td>"+(onlineApp.isIncaso() ? "ინკასო":"არ ადევს")+"</td>"
							+ "</td><td onclick=\"triggerComments(" + onlineApp.getOnlineAppId() + ","
							+ onlineApp.getCompany() + ")\"><img height=\"20px\" width=\"20px\" src=\""
							+ request.getContextPath() + "/resources/images/comment.png\"></td>"
							+ "<td bgcolor=\"lightgreen\" onclick=\"acceptApplication(" + onlineApp.getOnlineAppId()
							+ "," + onlineApp.getCompany() + ")\"><img height=\"20px\" width=\"20px\" src=\""
							+ request.getContextPath() + "/resources/images/accept.png\"></td>"
							+ "<td bgcolor=\"LightCoral\" onclick=\"rejectApplication(" + onlineApp.getOnlineAppId()
							+ "," + onlineApp.getCompany() + ")\"><img height=\"20px\" width=\"20px\" src=\""
							+ request.getContextPath() + "/resources/images/reject.png\"></td>" + "</tr>"
							+ "<tr><td colspan=\"3\">" + onlineApp.getLoanPurpose() + "</td><td colspan=\"5\">" + onlineApp.getBranch() + "</td></tr></table>" + "</table>"
							+ "<br>");
				} else {
					ret.append("<br>"
							+ "<table style=\"width:100%; height: 180px; border: 1px solid black; text-align:center; border-collapse: collapse; spacing: 5px;\">"
							+ "<tr style=\"background-color:#85C1E9; height: 20px; font-weight: bold;\">"
							+ "<td>ID</td>" + "<td>თანხა</td>" + "<td>პერიოდი</td>" + "<td>სახელი გვარი</td>"
							+ "<td>დაბ.თარიღი</td>" + "<td>პირადი ნომ.</td>" + "<td>მობილური</td>"
							+ "<td>სამუშაო სფერო</td>" + "<td>კომპანია</td>" + "<td>პოზიცია</td>" + "<td>ხელფასი</td>"
							+ "<td>სტატუსი</td>" + "</tr>" + "<tr>" + "<td>" + onlineApp.getOnlineAppId() + "</td>"
							+ "<td>" + Math.round(onlineApp.getAmount().doubleValue() * 100.0) / 100.0 + "</td>"
							+ "<td>" + onlineApp.getPeriod() + "</td>" + "<td>" + onlineApp.getFullname() + "</td>"
							+ "<td>" + onlineApp.getBirthdate() + "</td>" + "<td>" + onlineApp.getPersonalNumber()
							+ "</td>" + "<td>" + onlineApp.getMobilephone() + "</td>" + "<td>"
							+ onlineApp.getWorkField() + "</td>" + "<td>" + onlineApp.getCompanyName() + "</td>"
							+ "<td>" + onlineApp.getPosition() + "</td>" + "<td>" + onlineApp.getSalary() + "</td>"
							+ "<td>" + getNameForStatus(onlineApp.getStatus()) + "</td>" + "</tr>"
							+ "<tr style=\"background-color:#85C1E9; height: 20px; font-weight: bold;\">"
							+ "<td>მუშ.ხან.</td>" + "<td>დამ.შემოსავალი</td>" + "<td>თვ.გადასახდელი</td>"
							+ "<td>ოჯახ.მდგომ.</td>" + "<td>შვილები</td>" + "<td>დასაქ.ოჯახ.წევრები</td>"
							+ "<td>საერთო შემოსავალი</td>" + "<td>თარიღი</td>" + "<td>ინკასო</td>"
							+ "<td colspan=\"3\" align=\"center\">კომენტარები</td>" + "</tr>" + "<tr>" + "<td>"
							+ onlineApp.getWorkTime() + "</td>" + "<td>" + onlineApp.getAdditionalIncome() + "</td>"
							+ "<td>" + onlineApp.getLoanFreqAmount() + "</td>" + "<td>" + onlineApp.getMaritalStatus()
							+ "</td>" + "<td>" + onlineApp.getChildren() + "</td>" + "<td>"
							+ onlineApp.getWorkingRelatives() + "</td>" + "<td>" + onlineApp.getTotalIncome() + "</td>"
							+ "<td>" + tf.millisecondsToDateStr(onlineApp.getAdditionTime()) + "</td>" +
							"<td>"+(onlineApp.isIncaso() ? "ინკასო":"არ ადევს")+"</td>"
							+ "<td colspan=\"3\" onclick=\"triggerComments(" + onlineApp.getOnlineAppId() + ","
							+ onlineApp.getCompany() + ")\"><img height=\"20px\" width=\"20px\" src=\""
							+ request.getContextPath() + "/resources/images/comment.png\"></td>"
							+ ((onlineApp.getStatus() != 2) ? "<td colspan=\"3\" onclick=\"changeStatus("
									+ onlineApp.getOnlineAppId() + "," + onlineApp.getCompany() + "," + 0
									+ ")\"><img height=\"20px\" width=\"20px\" src=\"" + request.getContextPath()
									+ "/resources/images/resume.png\" title=\"აპლიკაციაში დაბრუნება\"></td>" : "")
							+ "</tr>" + "<tr><td colspan=\"3\">" + onlineApp.getLoanPurpose() + "</td><td colspan=\"5\">" + onlineApp.getBranch() + "</td></tr></table>"
							+ "</table>" + "<br>");
				}
			}
			for (OnlineApplicationForConsumerLoan onlineApp : onlineAppListCL) {
				// TODO: change below
				int consCompId = 2;
				if (onlineApp.getStatus() == 0) {
					ret.append("<br>"
							+ "<table style=\"width:100%; height: 180px; border: 1px solid black; text-align:center; border-collapse: collapse; spacing: 5px;\">"
							+ "<tr style=\"background-color:Coral; height: 20px; font-weight: bold;\">" + "<td>ID</td>"
							+ "<td>თანხა</td>" + "<td>პერიოდი</td>" + "<td>სახელი გვარი</td>" + "<td>დაბ.თარიღი</td>"
							+ "<td>პირადი ნომ.</td>" + "<td>მობილური</td>" + "<td>სამუშაო სფერო</td>"
							+ "<td>კომპანია</td>" + "<td>პოზიცია</td>" + "<td>ხელფასი</td>" + "<td>სტატუსი</td>"
							+ "</tr>" + "<tr>" + "<td>" + onlineApp.getId() + "</td>" + "<td>"
							+ Math.round(onlineApp.getLoanAmount() * 100.0) / 100.0 + "</td>" + "<td>"
							+ onlineApp.getLoanPeriod() + "</td>" + "<td>" + onlineApp.getName() + "</td>" + "<td>"
							+ onlineApp.getBirthDate() + "</td>" + "<td>" + onlineApp.getPrivateNumber() + "</td>"
							+ "<td>" + onlineApp.getMobileNumber() + "</td>" + "<td>" + onlineApp.getWorkSphere()
							+ "</td>" + "<td>" + onlineApp.getCompanyName() + "</td>" + "<td>"
							+ onlineApp.getWorkPosition() + "</td>" + "<td>" + onlineApp.getSalary() + "</td>" + "<td>"
							+ getNameForStatus(onlineApp.getStatus()) + "</td>" + "</tr>"
							+ "<tr style=\"background-color:Coral; height: 20px; font-weight: bold;\">"
							+ "<td>მუშ.ხან.</td>" + "<td>დამ.შემოსავალი</td>" + "<td>თვ.გადასახდელი</td>"
							+ "<td>ოჯახ.მდგომ.</td>" + "<td>შვილები</td>" + "<td>დასაქ.ოჯახ.წევრები</td>"
							+ "<td>საერთო შემოსავალი</td>" + "<td>თარიღი</td>" + "<td>ინკასო</td>" + "<td>დადასტურება</td>"
							+ "<td>უარყოფა</td>" + "<td>წაშლა</td>" + "</tr>" + "<tr>" + "<td>"
							+ onlineApp.getWorkPeriod() + "</td>" + "<td>" + onlineApp.getOtherIncome() + "</td>"
							+ "<td>" + onlineApp.getAmountToPayOnOtherLoans() + "</td>" + "<td>"
							+ onlineApp.getMaritalStatus() + "</td>" + "<td>" + onlineApp.getNumberOfChildren()
							+ "</td>" + "<td>" + onlineApp.getEmployedFamilyMembers() + "</td>" + "<td>"
							+ onlineApp.getTotalFamilyIncome() + "</td>" + "<td>"
							+ tf.millisecondsToDateStr(onlineApp.getAdditionTime()) + "</td>" +
							"<td>"+(onlineApp.isIncaso() ? "ინკასო":"არ ადევს")+"</td>"
							+ "<td bgcolor=\"lightgreen\" onclick=\"approveApplication(" + onlineApp.getId() + ","
							+ consCompId + ")\"><img height=\"20px\" width=\"20px\" src=\"" + request.getContextPath()
							+ "/resources/images/accept.png\"></td>"
							+ "<td bgcolor=\"LightCoral\" onclick=\"rejectApplication(" + onlineApp.getId() + ","
							+ consCompId + ")\"><img height=\"20px\" width=\"20px\" src=\"" + request.getContextPath()
							+ "/resources/images/reject.png\"></td>"
							+ "<td bgcolor=\"silver\" onclick=\"deleteApplication(" + onlineApp.getId() + ","
							+ consCompId + ")\"><img height=\"20px\" width=\"20px\" src=\"" + request.getContextPath()
							+ "/resources/images/delete.png\"></td>" + "</tr>"
							+ "<tr><td colspan=\"3\">"+onlineApp.getLoanPurpose()+"</td><td colspan=\"5\" align=\"left\"> " + onlineApp.getBranchOfficeName() + "</td></tr>"
							+ "</table>" + "<br>");
				} else if (onlineApp.getStatus() == 1) {
					ret.append("<br>"
							+ "<table style=\"width:100%; height: 180px; border: 1px solid black; text-align:center; border-collapse: collapse; spacing: 5px;\">"
							+ "<tr style=\"background-color:Coral; height: 20px; font-weight: bold;\">" + "<td>ID</td>"
							+ "<td>თანხა</td>" + "<td>პერიოდი</td>" + "<td>სახელი გვარი</td>" + "<td>დაბ.თარიღი</td>"
							+ "<td>პირადი ნომ.</td>" + "<td>მობილური</td>" + "<td>სამუშაო სფერო</td>"
							+ "<td>კომპანია</td>" + "<td>პოზიცია</td>" + "<td>ხელფასი</td>" + "<td>სტატუსი</td>"
							+ "</tr>" + "<tr>" + "<td>" + onlineApp.getId() + "</td>" + "<td>"
							+ Math.round(onlineApp.getLoanAmount() * 100.0) / 100.0 + "</td>" + "<td>"
							+ onlineApp.getLoanPeriod() + "</td>" + "<td>" + onlineApp.getName() + "</td>" + "<td>"
							+ onlineApp.getBirthDate() + "</td>" + "<td>" + onlineApp.getPrivateNumber() + "</td>"
							+ "<td>" + onlineApp.getMobileNumber() + "</td>" + "<td>" + onlineApp.getWorkSphere()
							+ "</td>" + "<td>" + onlineApp.getCompanyName() + "</td>" + "<td>"
							+ onlineApp.getWorkPosition() + "</td>" + "<td>" + onlineApp.getSalary() + "</td>" + "<td>"
							+ getNameForStatus(onlineApp.getStatus()) + "</td>" + "</tr>"
							+ "<tr style=\"background-color:Coral; height: 20px; font-weight: bold;\">"
							+ "<td>მუშ.ხან.</td>" + "<td>დამ.შემოსავალი</td>" + "<td>თვ.გადასახდელი</td>"
							+ "<td>ოჯახ.მდგომ.</td>" + "<td>შვილები</td>" + "<td>დასაქ.ოჯახ.წევრები</td>"
							+ "<td>საერთო შემოსავალი</td>" + "<td>თარიღი</td>" + "<td>ინკასო</td>"
							+ "<td align=\"center\">კომენტარები</td><td align=\"center\">აპლიკაციის დამატება</td><td align=\"center\">აპლიკაციის უარყოფა</td>"
							+ "</tr>" + "<tr>" + "<td>" + onlineApp.getWorkPeriod() + "</td>" + "<td>"
							+ onlineApp.getOtherIncome() + "</td>" + "<td>" + onlineApp.getAmountToPayOnOtherLoans()
							+ "</td>" + "<td>" + onlineApp.getMaritalStatus() + "</td>" + "<td>"
							+ onlineApp.getNumberOfChildren() + "</td>" + "<td>" + onlineApp.getEmployedFamilyMembers()
							+ "</td>" + "<td>" + onlineApp.getTotalFamilyIncome() + "</td>" +
							"<td>"+(onlineApp.isIncaso() ? "ინკასო":"არ ადევს")+"</td>" +
							"<td>" + tf.millisecondsToDateStr(onlineApp.getAdditionTime()) + "</td>"
							+ "<td onclick=\"triggerComments(" + onlineApp.getId() + "," + consCompId
							+ ")\"><img height=\"20px\" width=\"20px\" src=\"" + request.getContextPath()
							+ "/resources/images/comment.png\"></td>"
							+ "<td bgcolor=\"lightgreen\" onclick=\"acceptApplication(" + onlineApp.getId() + ","
							+ consCompId + ")\"><img height=\"20px\" width=\"20px\" src=\"" + request.getContextPath()
							+ "/resources/images/accept.png\"></td>"
							+ "<td bgcolor=\"LightCoral\" onclick=\"rejectApplication(" + onlineApp.getId() + ","
							+ consCompId + ")\"><img height=\"20px\" width=\"20px\" src=\"" + request.getContextPath()
							+ "/resources/images/reject.png\"></td>" + "</tr>"
							+ "<tr><td colspan=\"3\">" + onlineApp.getLoanPurpose() + "</td><td colspan=\"5\" align=\"left\"> " + onlineApp.getBranchOfficeName() + "</td></tr>"
							+ "</table>" + "<br>");
				} else {
					ret.append("<br>"
							+ "<table style=\"width:100%; height: 180px; border: 1px solid black; text-align:center; border-collapse: collapse; spacing: 5px;\">"
							+ "<tr style=\"background-color:Coral; height: 20px; font-weight: bold;\">" + "<td>ID</td>"
							+ "<td>თანხა</td>" + "<td>პერიოდი</td>" + "<td>სახელი გვარი</td>" + "<td>დაბ.თარიღი</td>"
							+ "<td>პირადი ნომ.</td>" + "<td>მობილური</td>" + "<td>სამუშაო სფერო</td>"
							+ "<td>კომპანია</td>" + "<td>პოზიცია</td>" + "<td>ხელფასი</td>" + "<td>სტატუსი</td>"
							+ "</tr>" + "<tr>" + "<td>" + onlineApp.getId() + "</td>" + "<td>"
							+ Math.round(onlineApp.getLoanAmount() * 100.0) / 100.0 + "</td>" + "<td>"
							+ onlineApp.getLoanPeriod() + "</td>" + "<td>" + onlineApp.getName() + "</td>" + "<td>"
							+ onlineApp.getBirthDate() + "</td>" + "<td>" + onlineApp.getPrivateNumber() + "</td>"
							+ "<td>" + onlineApp.getMobileNumber() + "</td>" + "<td>" + onlineApp.getWorkSphere()
							+ "</td>" + "<td>" + onlineApp.getCompanyName() + "</td>" + "<td>"
							+ onlineApp.getWorkPosition() + "</td>" + "<td>" + onlineApp.getSalary() + "</td>" + "<td>"
							+ getNameForStatus(onlineApp.getStatus()) + "</td>" + "</tr>"
							+ "<tr style=\"background-color:Coral; height: 20px; font-weight: bold;\">"
							+ "<td>მუშ.ხან.</td>" + "<td>დამ.შემოსავალი</td>" + "<td>თვ.გადასახდელი</td>"
							+ "<td>ოჯახ.მდგომ.</td>" + "<td>შვილები</td>" + "<td>დასაქ.ოჯახ.წევრები</td>"
							+ "<td>საერთო შემოსავალი</td>" + "<td>თარიღი</td>" + "<td>ინკასო</td>"
							+ "<td colspan=\"3\" align=\"center\">კომენტარები</td>" + "</tr>" + "<tr>" + "<td>"
							+ onlineApp.getWorkPeriod() + "</td>" + "<td>" + onlineApp.getOtherIncome() + "</td>"
							+ "<td>" + onlineApp.getAmountToPayOnOtherLoans() + "</td>" + "<td>"
							+ onlineApp.getMaritalStatus() + "</td>" + "<td>" + onlineApp.getNumberOfChildren()
							+ "</td>" + "<td>" + onlineApp.getEmployedFamilyMembers() + "</td>" + "<td>"
							+ onlineApp.getTotalFamilyIncome() + "</td>" + "<td>"
							+ "<td>"+(onlineApp.isIncaso() ? "ინკასო":"არ ადევს")+"</td>"
							+ tf.millisecondsToDateStr(onlineApp.getAdditionTime()) + "</td>"
							+ "<td colspan=\"3\" onclick=\"triggerComments(" + onlineApp.getId() + "," + consCompId
							+ ")\"><img height=\"20px\" width=\"20px\" src=\"" + request.getContextPath()
							+ "/resources/images/comment.png\"></td>"
							+ ((onlineApp.getStatus() != 2)
									? "<td colspan=\"4\" onclick=\"changeStatus(" + onlineApp.getId() + "," + consCompId
											+ "," + 0 + ")\"><img height=\"20px\" width=\"20px\" src=\""
											+ request.getContextPath()
											+ "/resources/images/resume.png\"  title=\"აპლიკაციაში დაბრუნება\"></td>"
									: "")
							+ "</tr>" + "<tr><td colspan=\"3\" align=\"left\"> " + onlineApp.getBranchOfficeName()
							+ "</td></tr>" + "</table>" + "<br>");
				}
			}
			return ret.toString();
		} catch (Exception e) {
			e.printStackTrace();
			return "სესხის სტატუსის შეცვლისას დაფიქსირდა შეცდომა: " + e.toString();
		}
	}
Comments
By Anonymous, 2017-11-06 09:59:23
#119 easy-to-maintain database query PHP +41 
public function getProduct($product_id) {
		$query = $this->db->query("SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM " . DB_PREFIX . "product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '" . (int)$this->config->get('config_customer_group_id') . "' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM " . DB_PREFIX . "product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '" . (int)$this->config->get('config_customer_group_id') . "' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM " . DB_PREFIX . "product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '" . (int)$this->config->get('config_customer_group_id') . "') AS reward, (SELECT ss.name FROM " . DB_PREFIX . "stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '" . (int)$this->config->get('config_language_id') . "') AS stock_status, (SELECT wcd.unit FROM " . DB_PREFIX . "weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '" . (int)$this->config->get('config_language_id') . "') AS weight_class, (SELECT lcd.unit FROM " . DB_PREFIX . "length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '" . (int)$this->config->get('config_language_id') . "') AS length_class, (SELECT AVG(rating) AS total FROM " . DB_PREFIX . "review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM " . DB_PREFIX . "review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN " . DB_PREFIX . "manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '" . (int)$product_id . "' AND pd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "'");
		/* ... */

Opencart's Product model

Comments
By opencart, 2017-12-12 12:52:34