1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 230: 231: 232: 233: 234: 235: 236: 237: 238: 239: 240: 241: 242: 243: 244: 245: 246: 247: 248: 249: 250: 251: 252: 253: 254: 255: 256: 257: 258: 259: 260: 261: 262: 263: 264: 265: 266: 267: 268: 269: 270: 271: 272: 273: 274: 275: 276: 277: 278: 279: 280: 281: 282: 283: 284: 285: 286: 287: 288: 289: 290: 291: 292: 293: 294: 295: 296: 297: 298: 299: 300: 301: 302: 303: 304: 305: 306: 307: 308: 309: 310: 311: 312: 313: 314: 315: 316: 317: 318: 319: 320: 321: 322: 323: 324: 325: 326: 327: 328: 329: 330: 331: 332: 333: 334: 335: 336: 337: 338: 339: 340: 341: 342: 343: 344: 345: 346: 347: 348: 349: 350: 351: 352: 353: 354: 355: 356: 357: 358: 359: 360: 361: 362: 363: 364: 365: 366: 367: 368: 369: 370: 371: 372: 373: 374: 375: 376: 377: 378: 379: 380: 381: 382: 383: 384: 385: 386: 387: 388: 389: 390: 391: 392: 393: 394: 395: 396: 397: 398: 399: 400: 401: 402: 403: 404: 405: 406: 407: 408: 409: 410: 411: 412: 413: 414: 415: 416: 417: 418: 419: 420: 421: 422: 423: 424: 425: 426: 427: 428: 429: 430: 431: 432: 433: 434: 435: 436: 437: 438: 439: 440: 441: 442: 443: 444: 445: 446: 447: 448: 449: 450: 451: 452: 453: 454: 455: 456: 457: 458: 459: 460: 461: 462: 463: 464: 465: 466: 467: 468: 469: 470: 471: 472: 473: 474: 475: 476: 477: 478: 479: 480: 481: 482: 483: 484: 485: 486: 487: 488: 489: 490: 491: 492: 493: 494: 495: 496: 497: 498: 499: 500: 501: 502: 503: 504: 505: 506: 507: 508: 509: 510: 511: 512: 513: 514: 515: 516: 517: 518: 519: 520: 521: 522: 523: 524: 525: 526: 527: 528: 529: 530: 531: 532: 533: 534: 535: 536: 537: 538: 539: 540: 541: 542: 543: 544: 545: 546: 547: 548: 549: 550: 551: 552: 553: 554: 555: 556: 557: 558: 559: 560: 561: 562: 563: 564: 565: 566: 567: 568: 569: 570: 571: 572: 573: 574: 575: 576: 577: 578: 579: 580: 581: 582: 583: 584: 585: 586: 587: 588: 589: 590: 591: 592: 593: 594: 595: 596: 597: 598: 599: 600: 601: 602: 603: 604: 605: 606: 607: 608: 609: 610: 611: 612: 613: 614: 615: 616: 617: 618: 619: 620: 621: 622: 623: 624: 625: 626: 627: 628: 629: 630: 631: 632: 633: 634: 635: 636: 637: 638: 639: 640: 641: 642: 643: 644: 645: 646: 647: 648: 649: 650: 651: 652: 653: 654: 655: 656: 657: 658: 659: 660: 661: 662: 663: 664: 665: 666: 667: 668: 669: 670: 671: 672: 673: 674: 675: 676: 677: 678: 679: 680: 681: 682: 683: 684: 685: 686: 687: 688: 689: 690: 691: 692: 693: 694: 695: 696: 697: 698: 699: 700: 701: 702: 703: 704: 705: 706: 707: 708: 709: 710: 711: 712: 713: 714: 715: 716: 717: 718: 719: 720: 721: 722: 723: 724: 725: 726: 727: 728: 729: 730: 731: 732: 733: 734: 735: 736: 737: 738: 739: 740: 741: 742: 743: 744: 745: 746: 747: 748: 749: 750: 751: 752: 753: 754: 755: 756: 757: 758: 759: 760: 761: 762: 763: 764: 765: 766: 767: 768: 769: 770: 771: 772: 773: 774: 775: 776: 777: 778: 779: 780: 781: 782: 783: 784: 785: 786: 787: 788: 789: 790: 791: 792: 793: 794: 795: 796: 797: 798: 799: 800: 801: 802: 803: 804: 805: 806: 807: 808: 809: 810: 811: 812: 813: 814: 815: 816: 817: 818: 819: 820: 821: 822: 823: 824: 825: 826: 827: 828: 829: 830: 831: 832: 833: 834: 835: 836: 837: 838: 839: 840: 841: 842: 843: 844: 845: 846: 847: 848: 849: 850: 851: 852: 853: 854: 855: 856: 857: 858: 859: 860: 861: 862: 863: 864: 865: 866: 867: 868: 869: 870: 871: 872: 873: 874: 875: 876: 877: 878: 879: 880: 881: 882: 883: 884: 885: 886: 887: 888: 889: 890: 891: 892: 893: 894: 895: 896: 897: 898: 899: 900: 901: 902: 903: 904: 905: 906: 907: 908: 909: 910: 911: 912: 913: 914: 915: 916: 917: 918: 919: 920: 921: 922: 923: 924: 925: 926: 927: 928: 929: 930: 931: 932: 933: 934: 935: 936: 937: 938: 939: 940: 941: 942: 943: 944: 945: 946: 947: 948: 949: 950: 951: 952: 953: 954: 955: 956: 957: 958: 959: 960: 961: 962: 963: 964: 965: 966: 967: 968: 969: 970: 971: 972: 973: 974: 975: 976: 977: 978: 979: 980: 981: 982: 983: 984: 985: 986: 987: 988: 989: 990: 991: 992: 993: 994: 995: 996: 997: 998: 999: 1000: 1001: 1002: 1003: 1004: 1005: 1006: 1007: 1008: 1009: 1010: 1011: 1012: 1013: 1014: 1015: 1016: 1017: 1018: 1019: 1020: 1021: 1022: 1023: 1024: 1025: 1026: 1027: 1028: 1029: 1030: 1031: 1032: 1033: 1034: 1035: 1036: 1037: 1038: 1039: 1040: 1041: 1042: 1043: 1044: 1045: 1046: 1047: 1048: 1049: 1050: 1051: 1052: 1053: 1054: 1055: 1056: 1057: 1058: 1059: 1060: 1061: 1062: 1063: 1064: 1065: 1066: 1067: 1068: 1069: 1070: 1071: 1072: 1073: 1074: 1075: 1076: 1077: 1078: 1079: 1080: 1081: 1082: 1083: 1084: 1085: 1086: 1087: 1088: 1089: 1090: 1091: 1092: 1093: 1094: 1095: 1096: 1097: 1098: 1099: 1100: 1101: 1102: 1103: 1104: 1105: 1106: 1107: 1108: 1109: 1110: 1111: 1112: 1113: 1114: 1115: 1116: 1117: 1118: 1119: 1120: 1121: 1122: 1123: 1124: 1125: 1126: 1127: 1128: 1129: 1130: 1131: 1132: 1133: 1134: 1135: 1136: 1137: 1138: 1139: 1140: 1141: 1142: 1143: 1144: 1145: 1146: 1147: 1148: 1149: 1150: 1151: 1152: 1153: 1154: 1155: 1156: 1157: 1158: 1159: 1160: 1161: 1162: 1163: 1164: 1165: 1166: 1167: 1168: 1169: 1170: 1171: 1172: 1173: 1174: 1175: 1176: 1177: 1178: 1179: 1180: 1181: 1182: 1183: 1184: 1185: 1186: 1187: 1188: 1189: 1190: 1191: 1192: 1193: 1194: 1195: 1196: 1197: 1198: 1199: 1200: 1201: 1202: 1203: 1204: 1205: 1206: 1207: 1208: 1209: 1210: 1211: 1212: 1213: 1214: 1215: 1216: 1217: 1218: 1219: 1220: 1221: 1222: 1223: 1224: 1225: 1226: 1227: 1228: 1229: 1230: 1231: 1232: 1233: 1234: 1235: 1236: 1237: 1238: 1239: 1240: 1241: 1242: 1243: 1244: 1245: 1246: 1247: 1248: 1249: 1250: 1251: 1252: 1253: 1254: 1255: 1256: 1257: 1258: 1259: 1260: 1261: 1262: 1263: 1264: 1265: 1266: 1267: 1268: 1269: 1270: 1271: 1272: 1273: 1274: 1275: 1276: 1277: 1278: 1279: 1280: 1281: 1282: 1283: 1284: 1285: 1286: 1287: 1288: 1289: 1290: 1291: 1292: 1293: 1294: 1295: 1296: 1297: 1298: 1299: 1300: 1301: 1302: 1303: 1304: 1305: 1306: 1307: 1308: 1309: 1310: 1311: 1312: 1313: 1314: 1315: 1316: 1317: 1318: 1319: 1320: 1321: 1322: 1323: 1324: 1325: 1326: 1327: 1328: 1329: 1330: 1331: 1332: 1333: 1334: 1335: 1336: 1337: 1338: 1339: 1340: 1341: 1342: 1343: 1344: 1345: 1346: 1347: 1348: 1349: 1350: 1351: 1352: 1353: 1354: 1355: 1356: 1357: 1358: 1359: 1360: 1361: 1362: 1363: 1364: 1365: 1366: 1367: 1368: 1369: 1370: 1371: 1372: 1373: 1374: 1375: 1376: 1377: 1378: 1379: 1380: 1381: 1382: 1383: 1384: 1385: 1386: 1387: 1388: 1389: 1390: 1391: 1392: 1393: 1394: 1395: 1396: 1397: 1398: 1399: 1400: 1401: 1402: 1403: 1404: 1405: 1406: 1407: 1408: 1409: 1410: 1411: 1412: 1413: 1414: 1415: 1416: 1417: 1418: 1419: 1420: 1421: 1422: 1423: 1424: 1425: 1426: 1427: 1428: 1429: 1430: 1431: 1432: 1433: 1434: 1435: 1436: 1437: 1438: 1439: 1440: 1441: 1442: 1443: 1444: 1445: 1446: 1447: 1448: 1449: 1450: 1451: 1452: 1453: 1454: 1455: 1456: 1457: 1458: 1459: 1460: 1461: 1462: 1463: 1464: 1465: 1466: 1467: 1468: 1469: 1470: 1471: 1472: 1473: 1474: 1475: 1476: 1477: 1478: 1479: 1480: 1481: 1482: 1483: 1484: 1485: 1486: 1487: 1488: 1489: 1490: 1491: 1492: 1493: 1494: 1495: 1496: 1497: 1498: 1499: 1500: 1501: 1502: 1503: 1504: 1505: 1506: 1507: 1508: 1509: 1510: 1511: 1512: 1513: 1514: 1515: 1516: 1517: 1518: 1519: 1520: 1521: 1522: 1523: 1524: 1525: 1526: 1527: 1528: 1529: 1530: 1531: 1532: 1533: 1534: 1535: 1536: 1537: 1538: 1539: 1540: 1541: 1542: 1543: 1544: 1545: 1546: 1547: 1548: 1549: 1550: 1551: 1552: 1553: 1554: 1555: 1556: 1557: 1558: 1559: 1560: 1561: 1562: 1563: 1564: 1565: 1566: 1567: 1568: 1569: 1570: 1571: 1572: 1573: 1574: 1575: 1576: 1577: 1578: 1579: 1580: 1581: 1582: 1583: 1584: 1585: 1586: 1587: 1588: 1589: 1590: 1591: 1592: 1593: 1594: 1595: 1596: 1597: 1598: 1599: 1600: 1601: 1602: 1603: 1604: 1605: 1606: 1607: 1608: 1609: 1610: 1611: 1612: 1613: 1614: 1615: 1616: 1617: 1618: 1619: 1620: 1621: 1622: 1623: 1624: 1625: 1626: 1627: 1628: 1629: 1630: 1631: 1632: 1633: 1634: 1635: 1636: 1637: 1638: 1639: 1640: 1641: 1642: 1643: 1644: 1645: 1646: 1647: 1648: 1649: 1650: 1651: 1652: 1653: 1654: 1655: 1656: 1657: 1658: 1659: 1660: 1661: 1662: 1663: 1664: 1665: 1666: 1667: 1668: 1669: 1670: 1671: 1672: 1673: 1674: 1675: 1676: 1677: 1678: 1679: 1680: 1681: 1682: 1683: 1684: 1685: 1686: 1687: 1688: 1689: 1690: 1691: 1692: 1693: 1694: 1695: 1696: 1697: 1698: 1699: 1700: 1701: 1702: 1703: 1704: 1705: 1706: 1707: 1708: 1709: 1710: 1711: 1712: 1713: 1714: 1715: 1716: 1717: 1718: 1719: 1720: 1721: 1722: 1723: 1724: 1725: 1726: 1727: 1728: 1729: 1730: 1731: 1732: 1733: 1734: 1735: 1736: 1737: 1738: 1739: 1740: 1741: 1742: 1743: 1744: 1745: 1746: 1747: 1748: 1749: 1750: 1751: 1752: 1753: 1754: 1755: 1756: 1757: 1758: 1759: 1760: 1761: 1762: 1763: 1764: 1765: 1766: 1767: 1768: 1769: 1770: 1771: 1772: 1773: 1774: 1775: 1776: 1777: 1778: 1779: 1780: 1781: 1782: 1783: 1784: 1785: 1786: 1787: 1788: 1789: 1790: 1791: 1792: 1793: 1794: 1795: 1796: 1797: 1798: 1799: 1800: 1801: 1802: 1803: 1804: 1805: 1806: 1807: 1808: 1809: 1810: 1811: 1812: 1813: 1814: 1815: 1816: 1817: 1818: 1819: 1820: 1821: 1822: 1823: 1824: 1825: 1826: 1827: 1828: 1829: 1830: 1831: 1832: 1833: 1834: 1835: 1836: 1837: 1838: 1839: 1840: 1841: 1842: 1843: 1844: 1845: 1846: 1847: 1848: 1849: 1850: 1851: 1852: 1853: 1854: 1855: 1856: 1857: 1858: 1859: 1860: 1861: 1862: 1863: 1864: 1865: 1866: 1867: 1868: 1869: 1870: 1871: 1872: 1873: 1874: 1875: 1876: 1877: 1878: 1879: 1880: 1881: 1882: 1883: 1884: 1885: 1886: 1887: 1888: 1889: 1890: 1891: 1892: 1893: 1894: 1895: 1896: 1897: 1898: 1899: 1900: 1901: 1902: 1903: 1904: 1905: 1906: 1907: 1908: 1909: 1910: 1911: 1912: 1913: 1914: 1915: 1916: 1917: 1918: 1919: 1920: 1921: 1922: 1923: 1924: 1925: 1926: 1927: 1928: 1929: 1930: 1931: 1932: 1933: 1934: 1935: 1936: 1937: 1938: 1939: 1940: 1941: 1942: 1943: 1944: 1945: 1946: 1947: 1948: 1949: 1950: 1951: 1952: 1953: 1954: 1955: 1956: 1957: 1958: 1959: 1960: 1961: 1962: 1963: 1964: 1965: 1966: 1967: 1968: 1969: 1970: 1971: 1972: 1973: 1974: 1975: 1976: 1977: 1978: 1979: 1980: 1981: 1982: 1983: 1984: 1985: 1986: 1987: 1988: 1989: 1990: 1991: 1992: 1993: 1994: 1995: 1996: 1997: 1998: 1999: 2000: 2001: 2002: 2003: 2004: 2005: 2006: 2007: 2008: 2009: 2010: 2011: 2012: 2013: 2014: 2015: 2016: 2017: 2018: 2019: 2020: 2021: 2022: 2023: 2024: 2025: 2026: 2027: 2028: 2029: 2030: 2031: 2032: 2033: 2034: 2035: 2036: 2037: 2038: 2039: 2040: 2041: 2042: 2043: 2044: 2045: 2046: 2047: 2048: 2049: 2050: 2051: 2052: 2053: 2054: 2055: 2056: 2057: 2058: 2059: 2060: 2061: 2062: 2063: 2064: 2065: 2066: 2067: 2068: 2069: 2070: 2071: 2072: 2073: 2074: 2075: 2076: 2077: 2078: 2079: 2080: 2081: 2082: 2083: 2084: 2085: 2086: 2087: 2088: 2089: 2090: 2091: 2092: 2093: 2094: 2095: 2096: 2097: 2098: 2099: 2100: 2101: 2102: 2103: 2104: 2105: 2106: 2107: 2108: 2109: 2110: 2111: 2112: 2113: 2114: 2115: 2116: 2117: 2118: 2119: 2120: 2121: 2122: 2123: 2124: 2125: 2126: 2127: 2128: 2129: 2130: 2131: 2132: 2133: 2134: 2135: 2136: 2137: 2138: 2139: 2140: 2141: 2142: 2143: 2144: 2145: 2146: 2147: 2148: 2149: 2150: 2151: 2152: 2153: 2154: 2155: 2156: 2157: 2158: 2159: 2160: 2161: 2162: 2163: 2164: 2165: 2166: 2167: 2168: 2169: 2170: 2171: 2172: 2173: 2174: 2175: 2176: 2177: 2178: 2179: 2180: 2181: 2182: 2183: 2184: 2185: 2186: 2187: 2188: 2189: 2190: 2191: 2192: 2193: 2194: 2195: 2196: 2197: 2198: 2199: 2200: 2201: 2202: 2203: 2204: 2205: 2206: 2207: 2208: 2209: 2210: 2211: 2212: 2213: 2214: 2215: 2216: 2217: 2218: 2219: 2220: 2221: 2222: 2223: 2224: 2225: 2226: 2227: 2228: 2229: 2230: 2231: 2232: 2233: 2234: 2235: 2236: 2237: 2238: 2239: 2240: 2241: 2242: 2243: 2244: 2245: 2246: 2247: 2248: 2249: 2250: 2251: 2252: 2253: 2254: 2255: 2256: 2257: 2258: 2259: 2260: 2261: 2262: 2263: 2264: 2265: 2266: 2267: 2268: 2269: 2270: 2271: 2272: 2273: 2274: 2275: 2276: 2277: 2278: 2279: 2280: 2281: 2282: 2283: 2284: 2285: 2286: 2287: 2288: 2289: 2290: 2291: 2292: 2293: 2294: 2295: 2296: 2297: 2298: 2299: 2300: 2301: 2302: 2303: 2304: 2305: 2306: 2307: 2308: 2309: 2310: 2311: 2312: 2313: 2314: 2315: 2316: 2317: 2318: 2319: 2320: 2321: 2322: 2323: 2324: 2325: 2326: 2327: 2328: 2329: 2330: 2331: 2332: 2333: 2334: 2335: 2336: 2337: 2338: 2339: 2340: 2341: 2342: 2343: 2344: 2345: 2346: 2347: 2348: 2349: 2350: 2351: 2352: 2353: 2354: 2355: 2356: 2357: 2358: 2359: 2360: 2361: 2362: 2363: 2364: 2365: 2366: 2367: 2368: 2369: 2370: 2371: 2372: 2373: 2374: 2375: 2376: 2377: 2378: 2379: 2380: 2381: 2382: 2383: 2384: 2385: 2386: 2387: 2388: 2389: 2390: 2391: 2392: 2393: 2394: 2395: 2396: 2397: 2398: 2399: 2400: 2401: 2402: 2403: 2404: 2405: 2406: 2407: 2408: 2409: 2410: 2411: 2412: 2413: 2414: 2415: 2416: 2417: 2418: 2419: 2420: 2421: 2422: 2423: 2424: 2425: 2426: 2427: 2428: 2429: 2430: 2431: 2432: 2433: 2434: 2435: 2436: 2437: 2438: 2439: 2440: 2441: 2442: 2443: 2444: 2445: 2446: 2447: 2448: 2449: 2450: 2451: 2452: 2453: 2454: 2455: 2456: 2457: 2458: 2459: 2460: 2461: 2462: 2463: 2464: 2465: 2466: 2467: 2468: 2469: 2470: 2471: 2472: 2473: 2474: 2475: 2476: 2477: 2478: 2479: 2480: 2481: 2482: 2483: 2484: 2485: 2486: 2487: 2488: 2489: 2490: 2491: 2492: 2493: 2494: 2495: 2496: 2497: 2498: 2499: 2500: 2501: 2502: 2503: 2504: 2505: 2506: 2507: 2508: 2509: 2510: 2511: 2512: 2513: 2514: 2515: 2516: 2517: 2518: 2519: 2520: 2521: 2522: 2523: 2524: 2525: 2526: 2527: 2528: 2529: 2530: 2531: 2532: 2533: 2534: 2535: 2536: 2537: 2538: 2539: 2540: 2541: 2542: 2543: 2544: 2545: 2546: 2547: 2548: 2549: 2550: 2551: 2552: 2553: 2554: 2555: 2556: 2557: 2558: 2559: 2560: 2561: 2562: 2563: 2564: 2565: 2566: 2567: 2568: 2569: 2570: 2571: 2572: 2573: 2574: 2575: 2576: 2577: 2578: 2579: 2580: 2581: 2582: 2583: 2584: 2585: 2586: 2587: 2588: 2589: 2590: 2591: 2592: 2593: 2594: 2595: 2596: 2597: 2598: 2599: 2600: 2601: 2602: 2603: 2604: 2605: 2606: 2607: 2608: 2609: 2610: 2611: 2612: 2613: 2614: 2615: 2616: 2617: 2618: 2619: 2620: 2621: 2622: 2623: 2624: 2625: 2626: 2627:
<?php
abstract class Db1 {
static $DB_HANDLER = null;
static function open($isDatabaseAvailable = true) { return static::$DB_HANDLER = new mysqli(Config1::DB_HOST, Config1::DB_USER, Config1::DB_PASSWORD, ($isDatabaseAvailable)? Config1::DB_NAME:null); }
static function close() { return static::$DB_HANDLER->close();}
static function exec($query, $closeDbOnFinished = true, $isDatabaseAvailable = true, $throwError = true, $asMultipleQuery = false){
static::$DB_HANDLER = Db1::open($isDatabaseAvailable);
if(!static::$DB_HANDLER) throw new Exception('MySQLi DB_HANDLER not initialized'."<br/><hr/><br/>Error in db:[" . String1::toArrayTree(static::$DB_HANDLER->error_list) . "] dbString:[" . static::$DB_HANDLER->error . "]");
$data = static::$DB_HANDLER->{ $asMultipleQuery? 'multi_query': 'query' }($query) or ($throwError? die("InValid Query [ ".static::errorHandlerAndSolution()." ] "): $data = null);
if($closeDbOnFinished) Db1::close();
return $data;
}
private static function errorHandlerAndSolution(){
$error = static::$DB_HANDLER->error;
if(!Config1::DEBUG_MODE) throw new Exception(Console1::println("EXDB001 Error Occured, please enable debug mode to view more"));
$suggestion = '';
$runFunction = function($className, $functionName) use (&$suggestion){
Object1::getExecutedClass($className, true, function($class) use ($functionName, &$suggestion){
if($class!==Model1::class) $suggestion .= "<li><hr/><a href='".Form1::callController($class, $functionName).'?token='.token()."'>Run ".$class."::$functionName Now</a></li>";
});
};
if(String1::contains('Unknown column', $error)) {
$suggestion .= '<li>Please update Model Fields and run tableReset() method on Model. e.g User::tableReset() </li>';
$runFunction(Model1::class, "tableReset()");
}
else if(String1::containsMany(['Table', 'doesn\'t exist'], $error, 'and')){
$suggestion .= '<li>Please run tableCreate() method on Model in config onDebug(){...}. e.g User::tableCreate() </li>';
$runFunction(Model1::class,"tableCreate()");
}
Console1::println( '<h3>Ehex DB Error</h3>'.$error.(!empty($suggestion)? "<h3>Suggestion</h3><ul>$suggestion</ul>": ''));
return $error;
}
static function databaseCreate() { if (!static::exec( "CREATE DATABASE IF NOT EXISTS `" . Config1::DB_NAME."` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci", true, false)){ throw new Exception( "Cannot create Database 'Database'. WHY? [" . (static::$DB_HANDLER->error) . "]"); } }
static function destroyDatabase() { static::exec( "DROP DATABASE " . Config1::DB_NAME, true);}
static function tableCreate(...$modelList){
static::databaseCreate();
$tableRunBuffer = '';
$logBuffer = '';
$logFormat = "<br/><br/><hr/><h5> Creating Table for [%s]</h5><hr/> %s";
foreach ($modelList as $model) {
if(empty($model)) continue;
$modelInstant = (new $model());
$createQuery = '';
if( method_exists($modelInstant, 'toTableCreateQuery') ) $createQuery = $modelInstant->toTableCreateQuery();
else $model::tableCreate();
$tableRunBuffer .= $createQuery;
$logBuffer .= sprintf($logFormat, $model, $createQuery);
}
if(empty($tableRunBuffer)) return;
Session1::setStatus('Creating DB Table(s)', $logBuffer);
Db1::exec($tableRunBuffer, true, true, true, true);
}
static function tableCreateAll(){ return static::tableCreate(...app_model_list() ); }
static function tableReset(...$modelList){ static::databaseCreate(); foreach ($modelList as $model) $model::tableReset(); }
static function tableResetAll(){ static::tableReset(...app_model_list()); }
static function tableDestroy(...$modelList){ foreach ($modelList as $model) $model::tableDestroy(); }
static function tableDestroyAll(){ static::tableDestroy(...app_model_list()); }
static function tableSaveBackupAll($optionalBackupFolderName = 'all'){
$path = path_asset("backups".DIRECTORY_SEPARATOR."$optionalBackupFolderName");
$result = []; foreach (array_keys(app_db_table_list()) as $tableName) $result = $tableName::tableSaveBackup(rtrim($path, DIRECTORY_SEPARATOR).DIRECTORY_SEPARATOR.$tableName.'.model.json');
Session1::setStatus("Backup Completed", "Backed Up (".count($result).") Models", 'success');
return $result;
}
static function tableLoadBackupAll($optionalBackupFolderName = 'all', $clearExistingData = true){
$result = FileManager1::getDirectoryFiles(path_asset("backups".DIRECTORY_SEPARATOR."$optionalBackupFolderName"), true, function($path) use ($clearExistingData){
if(String1::endsWith($path, '.model.json')){
$modelNameFromFileName = Array1::getFirstItem(explode('.', FileManager1::getFileName($path)));
return $modelNameFromFileName::tableLoadBackup($path, $clearExistingData);
}
});
return $result;
}
static function tableClearBackupAll($optionalBackupFolderName = 'all'){ return FileManager1::deleteAll(path_asset("backups".DIRECTORY_SEPARATOR."$optionalBackupFolderName"),true); }
static function createClassTable($tableQuery) {
$result = static::exec($tableQuery);
if($result) return true;
die("Cannot create tableInfo [ ".substr($tableQuery, 0, 37)." ]");
}
static function getTableColumnAndTypeList($tableName = 'users', $fullType = false){
$fieldAndTypeList = [];
foreach (static::exec("SHOW FIELDS FROM $tableName") as $field){
$type = ($fullType || !String1::contains('(', $field['Type']))? $field['Type']: substr($field['Type'], 0, strpos($field['Type'], '('));
$fieldAndTypeList[$field['Field']] = $type;
}
return $fieldAndTypeList;
}
static function getExistingTables($withModelName = true){
if(isset(Page1::$_VARIABLE['__getExistingTables'][$withModelName])) return Page1::$_VARIABLE['__getExistingTables'][$withModelName];
$allTableName= [];
foreach (static::exec("SHOW TABLES;") as $db=>$table) $allTableName[] = $table['Tables_in_'.Config1::DB_NAME];
if(!$withModelName) return Page1::$_VARIABLE['__getExistingTables'][$withModelName] = $allTableName;
$modelNameAndTableName = [];
array_map(function($modelName) use ($allTableName, &$modelNameAndTableName){
if(in_array($modelName::getTableName(), $allTableName)) $modelNameAndTableName[$modelName] = $modelName::getTableName();
}, app_model_list());
return Page1::$_VARIABLE['__getExistingTables'][$withModelName] = $modelNameAndTableName;
}
static function getExistingModels(){
if(isset(Page1::$_VARIABLE['__getExistingModels'])) return Page1::$_VARIABLE['__getExistingModels'];
return Page1::$_VARIABLE['__getExistingModels'] = array_keys( static::getExistingTables(true) );
}
}
interface Controller1RouteInterface{
static function getIndexView();
static function getShowView($id);
static function getManageView();
static function getEditView($id);
static function getCreateView();
static function processSave($id = null);
static function processDestroy($id);
}
interface Model1ActionInterface{
static function getMenuList();
static function manage();
static function getDashboard();
static function processSave($id = null);
}
interface Model1PageInterface{
static function processUpdatePage();
static function manage();
}
abstract class Model1 extends Controller1 {
public static $FLAG_SHOW_EXEC_QUERY = false;
public $__COLUMN_SQL_PROPERTY_LIST = [];
public static $EXECUTED_MESSAGE = '';
public static $SQL_VARCHAR_STRING_LENGTH = 350;
public static $SQL_TIMESTAMP_FORMAT = 'Y-m-d h:1:s';
public static $FIX_COLUMN = ['id', 'created_at', 'updated_at'];
public static $PRIMARY_KEY_NAME = 'id';
public static $TABLE_NAME = null;
public function __construct($column_and_value = []){
$filterArray = ($column_and_value);
if(empty($filterArray)) return null;
foreach ($filterArray as $key=>$value){
$this->{$key} = $value;
}
return $this;
}
static function getTableName(){
if(isset(static::$TABLE_NAME) && !empty(static::$TABLE_NAME)) return static::$TABLE_NAME;
$convertToSnakeCase = function($value){ return $word = preg_replace_callback("/(^|[a-z])([A-Z])/", function($m) { return strtolower(strlen($m[1]) ? "$m[1]_$m[2]" : "$m[2]"); }, $value); };
$pluralize = function($singular) { return String1::pluralize($singular); };
return strtolower($convertToSnakeCase( $pluralize(((string)static::getModelClassName())) ));
}
function getModel($addMethod = true){ return Object1::cast($this, static::getModelClassName(), $addMethod); }
function getPreviousModel($sortColumnName = null) {
$sortColumnName = $sortColumnName? $sortColumnName:static::$PRIMARY_KEY_NAME;
$data = static::exec("SELECT * FROM ".static::getTableName()." WHERE ".$sortColumnName." < ".$this->{$sortColumnName}." ORDER BY ".$sortColumnName." DESC LIMIT 1 ", true, true );
return $data? $data[0] : ResultStatus1::falseMessage('Previous Record Not Found');
}
function getNextModel($sortColumnName = null){
$sortColumnName = $sortColumnName?$sortColumnName:static::$PRIMARY_KEY_NAME;
$data = static::exec("SELECT * FROM ".static::getTableName()." WHERE ".$sortColumnName." > ".$this->{$sortColumnName}." ORDER BY ".$sortColumnName." ASC LIMIT 1 ", true, true );
return $data? $data[0] : ResultStatus1::falseMessage('Next Record Not Found');
}
static function getModelClassName($asFriendly = false){ return $asFriendly? ucwords(String1::convertToSnakeCase(static::class, ' ')): static::class; }
function __call($func, $params){
if(String1::startsWith($func, 'with')) $this->{ lcfirst(String1::replaceStart($func, 'with', '')) } = $params[0];
return $this;
}
static function withId($id, $idField = 'id', array $othersField = []){ return static::findOrInit( array_merge([$idField=>$id], $othersField)); }
static function getDbTableField($fullType = false){ return Db1::getTableColumnAndTypeList(static::getTableName(), $fullType); }
static function getFixColumn(){ return array_flip(static::$FIX_COLUMN); }
static function toModelColumnValueArray($objectInstance = null){
$pureVariable = [];
foreach (get_object_vars($objectInstance? $objectInstance: new static) as $key=> $value) if(!String1::startsWith($key, '__')) $pureVariable[$key] = $value;
return array_merge($pureVariable, static::getFixColumn() );
}
function toArray(){ return static::toModelColumnValueArray($this); }
static function exec($query, $normalizeAndListAsArray = false, $makeArray_ArrayObject = false){
if(static::$FLAG_SHOW_EXEC_QUERY) return $query;
$normalizeAndListAsArray = $makeArray_ArrayObject? true: $normalizeAndListAsArray;
if( !$query || trim($query) == '') return null;
try{
$result = ($normalizeAndListAsArray)? @static::mysqli_fetch_all_assocArray(@Db1::exec($query), $makeArray_ArrayObject): (Db1::exec($query));
static::$EXECUTED_MESSAGE = 'Action Successful';
if($makeArray_ArrayObject && $result && is_array($result) ) return Object1::toArrayObject(true, $result);
else return $result;
}catch (Exception $ex){ static::$EXECUTED_MESSAGE = $ex->getMessage(); return null; }
}
static function getMessage(){ return static::$EXECUTED_MESSAGE; }
static function mysqli_fetch_all_assocArray($queryOutput, $makeArray_ArrayObject = false ){
$buf = [];
while ($row = @mysqli_fetch_assoc($queryOutput)) { $buf[] = $makeArray_ArrayObject? static::findOrInit($row): $row; }
return $buf;
}
static function mysqlFilterValue($str){
Db1::open();
$str = @trim($str);
if (get_magic_quotes_gpc()) $str = stripslashes($str);
return mysqli_real_escape_string(Db1::$DB_HANDLER, $str);
}
static function query($otherTableNames = []){
$tableNames = (static::getTableName())? array_merge([static::getTableName()], Array1::toArray($otherTableNames)): $otherTableNames;
return QB::table($tableNames);
}
static function raw(){ return QB::class; }
function form($visibleField = [], $invisibleField = [], $hiddenField = null){ return new HtmlForm1($this, $visibleField, $invisibleField, $hiddenField? $hiddenField: static::$FIX_COLUMN); }
static function formMake($findModelById = -1, $visibleField = [], $invisibleField = [], $hiddenField = null){
$newModel = ($findModelById && $findModelById>0)? static::find($findModelById): null;
return new HtmlForm1($newModel? $newModel->getModel(false): (new static()), $visibleField, $invisibleField, $hiddenField? $hiddenField: static::$FIX_COLUMN);
}
static function xcrud($table_name = null, $order_by = 'id', $query = null) {
$xcrud = Xcrud_instance();
$xcrud->table(static::getTableName());
if($order_by) $xcrud->order_by($order_by, 'desc');
if($table_name) $xcrud->table_name($table_name);
if(!String1::is_empty($query)) $xcrud->query($query);
return $xcrud;
}
static function findIn($textValues = [], $inColumn = [], $selectColumn = [], $logic = 'OR', $operator = ' = ', $otherQuery = ''){
$columnList = static::tableColumnMerge($selectColumn);
$selectWhere = static::toWhereValuesInColumnsQuery($inColumn, $textValues, $logic, $operator);
$selectWhere = ("SELECT $columnList FROM ".static::getTableName()).((trim($selectWhere)!='')? ' WHERE '.$selectWhere:'').' '.$otherQuery;
$result = static::exec($selectWhere, true, false);
return $result? $result : ResultStatus1::falseMessage('Record Not Found!');
}
static function findOrInit($key_value_array = [], $findValue = null, $findColumn = 'id'){
$foundModel = (!empty($findValue))? static::find($findValue, $findColumn, '', [], false): [];
$mergeData = array_merge(Object1::toArray($key_value_array), $foundModel);
$data = (count($mergeData) < 1) ? static::toModelColumnValueArray(): $mergeData;
return empty($data) ? ResultStatus1::make(false, 'Empty Model', null): Object1::toArrayObject(true, Object1::convertArrayToObject($data, static::getModelClassName()) );
}
static function findOrFail($id_or_value, $inColumnName = 'id', callable $errorCallback = null){
$model = static::find($id_or_value, $inColumnName);
if($model) return $model;
if($errorCallback) return $errorCallback();
$status = ucfirst(static::getModelClassName())." ($id_or_value) Not Found";
Session1::setStatus(ucfirst(static::getModelClassName()).' Failed', $status);
$backUrl = Url1::backUrl();
$returnUrl = url('/error404');
if($backUrl !== Url1::getPageFullUrl()) $returnUrl = $backUrl;
Url1::redirect($returnUrl);
return Console1::println($status, true);
}
static function find($id_or_value, $inColumnName = 'id', $andOtherQuery = '', $selectColumn = [], $convertToModel1 = true){
$id_or_value = (is_array($id_or_value) && isset($id_or_value['id']) )? $id_or_value['id']: $id_or_value;
$tableName = static::getTableName();
$columnList = static::tableColumnMerge($selectColumn);
$result = static::exec("SELECT $columnList FROM `$tableName` WHERE `".(($inColumnName === 'id')? static::$PRIMARY_KEY_NAME: $inColumnName)."` = '$id_or_value' $andOtherQuery limit 1", true, false);
if(static::$FLAG_SHOW_EXEC_QUERY) return $result;
if(!$convertToModel1) return (!empty($result))? $result[0]: null;
$newObject = ($result)? Object1::toArrayObject(true, Object1::convertArrayToObject($result[0], static::getModelClassName()) ): null;
return ($result && (count($result)>0)) ? $newObject : ResultStatus1::falseMessage('Record Not Found!');
}
static function findMany($column_and_value = [], $logic = ' AND ', $operator = ' = ', $selectColumn = []){
$selectWhere = static::toSelectWhereQuery($column_and_value, $selectColumn, $logic, $operator);
return static::exec($selectWhere, true, false);
}
static function findAgainst($valueA = 'samtax01', $valueB = '123456', $search_in_columnA_list = ['user_name', 'email'], $search_in_columnB_list = ['password'], $againstLogic = ' AND ', $logic = ' OR ', $operator = ' = ', $selectColumn = []){
$columnList = static::tableColumnMerge($selectColumn);
$columnA_plus_valueA = [];
foreach (array_flip($search_in_columnA_list) as $key=> $value)
$columnA_plus_valueA[$key] = $valueA;
$columnB_plus_valueB = [];
foreach (array_flip($search_in_columnB_list) as $key=> $value)
$columnB_plus_valueB[$key] = $valueB;
$query = "SELECT $columnList FROM `".static::getTableName()."` WHERE ".
" (".Array1::mergeKeyValue($columnA_plus_valueA, $operator, $logic, "`%s`", "'%s'")." )"
.$againstLogic.
" (".Array1::mergeKeyValue($columnB_plus_valueB, $operator, $logic, "`%s`", "'%s'")." )";
return static::exec($query, true, false);
}
function update($column_and_value = []){ return static::exec($this->toUpdateQuery($column_and_value))? $this: null; }
function delete($deleteFromModel1FileLocator = false){
if($deleteFromModel1FileLocator) Model1FileLocator::deleteAll($this);
@FileManager1::deleteAll($this->getFilePath(), true);
@rmdir($this->getFilePath());
return static::exec($this->toDeleteQuery());
}
static function deleteBy($id_or_value, $inColumnName = 'id', $deleteFromModel1FileLocator = false){ $model = static::find($id_or_value, $inColumnName); if($model) return $model->delete($deleteFromModel1FileLocator); else return ResultStatus1::falseMessage('Model Not Exist!'); }
function alter($asAdd_orElseModify = true, $keyAndParameter = ' `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7 '){ return static::exec($this->toAlterQuery($asAdd_orElseModify, $keyAndParameter)); }
static function deleteMany($whereColumn_and_value = [], $logic = ' AND ', $operator = ' = '){ return static::exec(static::toDeleteWhereQuery($whereColumn_and_value, $logic, $operator));}
static function updateMany($update_column_and_value = [], $whereColumn_and_value = [], $logic = ' AND ', $operator = ' = '){
return static::exec(static::toUpdateWhereQuery($update_column_and_value, $whereColumn_and_value, $logic, $operator));
}
static function all($column_and_value = [], $selectColumn = [], $logic = ' OR ', $operator = ' = '){ return static::exec( static::toSelectWhereQuery($column_and_value, $selectColumn, $logic, $operator), true ); }
static function tableCreate($columnSetSQLProperty = [], $initDefaultRowList = [], $silent = false){
if(in_array(static::getTableName(), Db1::getExistingTables(false)) ) return Session1::setStatusIf($silent,'Table Exists', "Cannot re-create table (".static::getTableName()."), Table Exists!" );
$status = static::exec( (new static())->toTableCreateQuery($columnSetSQLProperty) );
if(!empty($initDefaultRowList) && (static::count() < 1)) foreach ($initDefaultRowList as $row) static::insert($row);
Session1::setStatusIf($silent,'Table Create', 'Table '.static::getTableName().' Create Query...<hr/>'.(new static())->toTableCreateQuery($columnSetSQLProperty));
return $status;
}
static function generateDemoData($count = 1, $ignoreColumn = ['id'], $fieldAndPossibleValueArrayList = ['id'=>['2', '4', '5']], $initField = [], $convertToModel = true){
$resultData = EasyGenerator::fillModelArray(static::getDbTableField(), $ignoreColumn, $fieldAndPossibleValueArrayList, $count);
$buff = [];
foreach ($resultData as $fieldRow) $buff[] = $convertToModel? static::findOrInit(array_merge($fieldRow, $initField)): array_merge($fieldRow, $initField);
return $buff;
}
static function tableCreateWithDemoList($insert = true, $count = 1, $ignoreColumn = ['id'], $fieldAndPossibleValueArrayList = ['id'=>['2', '4', '5']], $initField = []){
static::tableCreate();
if(!$insert) dd(static::generateDemoData($count, $ignoreColumn, $fieldAndPossibleValueArrayList, $initField, false));
dd(static::insertMany(...static::generateDemoData($count, $ignoreColumn, $fieldAndPossibleValueArrayList, $initField, false)));
}
static function tableDestroy(){ return static::exec( static::toDropTableQuery() ); }
static function tableTruncate(){ return static::exec("TRUNCATE `".static::getTableName()."`"); }
static function tableReset($addBackupToSession = true, $backupAndRestore = true, $optionalBackupFilePath = null) {
$allTableData = [];
if($backupAndRestore) $allTableData = static::tableSaveBackup($optionalBackupFilePath, $addBackupToSession);
$tableTruncateAction = (static::tableDestroy() && static::tableCreate());
if($tableTruncateAction && $backupAndRestore) static::insertMany(...$allTableData);
return $allTableData;
}
static function tableLoadBackup($fromFilePath = null, $clearExistingData = true){
static::tableCreate( [], [], true);
if($clearExistingData) static::tableTruncate();
$allTableData = Array1::readFromJSON($fromFilePath);
return ($allTableData)? static::insertMany(...$allTableData): false;
}
static function tableSaveBackup($saveToFilePath = null, $addBackupToSession = true){
$backupName = static::getTableName().'_'.String1::convertWordToSlug(now());
$saveToFilePath = $saveToFilePath? $saveToFilePath: path_asset('backups').DIRECTORY_SEPARATOR.$backupName.'.model.json';
$allTableData = static::selectMany(false, '');
if($addBackupToSession) {
Session1::set($backupName, $allTableData);
Session1::setStatus('Table Backup Information', "Ehex Has Just Backed Up DB Table (".static::getTableName().") Information to Model (".static::getModelClassName().") information. <br/>Therefore, We added additional Backup to your Session should anything goes wrong. <br/><br/><h5>Back Up Name : $backupName<hr><small><code><em>view it with : </em> Session1::get('$backupName')</code> </small></h5>");
}
if($saveToFilePath) {
if(Array1::saveAsJSON($allTableData, $saveToFilePath)) {
Session1::setStatus(static::getTableName().' Backed Up', static::getTableName().' backup saved to '.$saveToFilePath, 'success');
return $allTableData;
}
else throw new Exception(Console1::println("<h4>Failed to Save Backup</h4>").'Backup Failed');
}
return $allTableData;
}
static function tableDataClone($limitRowToClone = null) {
$allTableData = [];
$index = 0;
foreach (static::selectMany(true, '') as $table) {
$allTableData = static::insertMany($table);
$index ++; if ($limitRowToClone && ($index === $limitRowToClone)) break;
}
Session1::setStatus('Table ('.static::getTableName().') Cloned');
return $allTableData;
}
static function insert($column_and_value = [], $uniqueColumnKey = [], $uniqueColumnLogic = 'OR', $replaceOldEqualRow = false) {
if($replaceOldEqualRow) static::deleteMany($column_and_value, ' AND ', '=');
$uniqueColumnKey = static::tableColumnExpand($uniqueColumnKey);
$allQuery = ''; $query1 = false; $query2 = false;
$extractUniqueValue = Array1::getCommonField(null, $column_and_value, array_flip($uniqueColumnKey));
if(!empty($extractUniqueValue)) $allQuery .= String1::toString($query1 = static::findMany($extractUniqueValue, " $uniqueColumnLogic ", ' = ', array_merge([static::$PRIMARY_KEY_NAME], $uniqueColumnKey)));
$allQuery .='<br/>'. String1::toString( $query2 = (new static())->toInsertQuery($column_and_value));
if(static::$FLAG_SHOW_EXEC_QUERY) return $allQuery;
if($query1 && count($query1) > 0 ){
$existKey = [];
foreach ($query1 as $fetchedData){
foreach ($uniqueColumnKey as $uniqueDataKey) {
if(trim(strtolower($fetchedData[$uniqueDataKey])) === trim(strtolower($column_and_value[$uniqueDataKey]))) $existKey[] = String1::convertToCamelCase($uniqueDataKey, ' ');
}
}
return ResultStatus1::falseMessage(implode(" And ", $existKey).' Exists');
}
else return (Db1::exec($query2, false))? static::find(Db1::$DB_HANDLER->insert_id): ResultStatus1::falseMessage('Unable to Execute Query');
}
static function insertMany(...$column_and_value){ $buff = []; foreach ($column_and_value as $cl) $buff[] = static::insert($cl); return $buff; }
static function insertOrUpdate($column_and_value = [], $insertUniqueColumnKey = [], $insertUniqueColumnLogic = ' AND ', $primary_key_name_to_find_exists_model = null){
$primary_key_name_to_find_exists_model = $primary_key_name_to_find_exists_model? $primary_key_name_to_find_exists_model: static::$PRIMARY_KEY_NAME;
if(isset($column_and_value[$primary_key_name_to_find_exists_model]) && !empty($column_and_value[$primary_key_name_to_find_exists_model]) && $column_and_value[$primary_key_name_to_find_exists_model]) {
$result = static::find($column_and_value[$primary_key_name_to_find_exists_model], $primary_key_name_to_find_exists_model);
if($result) return $result->update($column_and_value);
}
return ( static::insert($column_and_value, $insertUniqueColumnKey, $insertUniqueColumnLogic));
}
static function selectMany($asArrayObject = false, $whereRawClause = '', $selectColumn = []){
$tableName = static::getTableName();
$columnList = static::tableColumnMerge($selectColumn);
return static::exec("SELECT $columnList FROM `$tableName` $whereRawClause ", true, $asArrayObject);
}
static function selectManyAsList($where = '', $selectColumnName = 'id'){
$selectColumnName = Array1::makeArray($selectColumnName);
$result = static::selectMany(false, $where, $selectColumnName);
return ($selectColumnName && (count($selectColumnName) === 1))? static::singleColumnList($result, static::tableColumnExpand($selectColumnName[0]) [0]): $result;
}
static function selectManyAsKeyValue($where = '', $keyColumnName = 'id', $valueColumnName = 'name'){
return static::arrayValueToKeyValue( static::selectMany(true, $where, Array1::filterArrayItem([$keyColumnName,$valueColumnName])), $keyColumnName, $valueColumnName);
}
private static function arrayValueToKeyValue($queryArrayResult = [], $keyForOption = 'id', $keyForValue = 'name'){
$dataBuf = [];
foreach ($queryArrayResult as $key=> $value) $dataBuf[$value[$keyForOption]] = $value[$keyForValue];
return $dataBuf;
}
static function count($where = '', $columnQuery = ['count(*)as data'], $returnAsSingleColumn = true){
$result = static::selectMany(true, $where, $columnQuery);
return ($returnAsSingleColumn)? static::singleColumnList($result, 'all_data')[0]: $result;
}
private static function tableColumnMerge($selectColumn = [], $default = '*'){ return is_array($selectColumn)? (($selectColumn && !empty($selectColumn))? implode(',', array_keys(array_flip($selectColumn))): '*'): String1::isset_or($selectColumn, $default); }
private static function tableColumnExpand($selectColumn = ''){ return is_array($selectColumn)? $selectColumn: (($selectColumn && !empty($selectColumn))? explode(',', $selectColumn): []); }
static function singleColumnList($arr = [], $columnKeyName = null){
$buf = [];
foreach ($arr as $key => $value) $buf[] = ($columnKeyName)? $value[$columnKeyName]: $value;
return $buf;
}
static function exists($column_and_value = [], $logic = ' OR '){
$selectWhere = static::toSelectWhereQuery($column_and_value, ["`".static::$PRIMARY_KEY_NAME."`"], $logic);
return static::exec($selectWhere, true);
}
static function getAllQueryHelp() {
$break = '<br><hr><br>';
$buf = '<div style="margin:20px;"><h2><a href="https://ehex.xamtax.com">Ehex Model</a></h2><hr> Table name is (' .static::getTableName().')<br/> <small>Model Includes MYSQL CRUD Generator and Model function is Callable from Form Action</small>
'.$break.
"<h4>Create table</h4>". static::toTableCreateQuery().$break.
"<h4>Drop table</h4>". static::toDropTableQuery().$break.
"<h4>Add Foreign Option table</h4>". static::toForeignLinkAdd().$break.
"<h4>Insert Query</h4>". static::toInsertQuery(static::toModelColumnValueArray()).$break.
"<h4>Update Query</h4>". (new static())->toUpdateQuery(static::toModelColumnValueArray()).$break.
"<h4>Delete Query</h4>". (new static())->toDeleteQuery().$break.
"<h4>Select Query</h4>". static::toSelectAllQuery().$break.
"<h4>Alter Query</h4>". static::toAlterQuery().$break.
"<h4>Find Against Query</h4>".$break;
$buf .= $break.$break.'<h2>MODEL TABLE COLUMN</h2><div style="padding:10px;">';
foreach (static::toModelColumnValueArray() as $key=>$value){ $buf .= ($break.$key.' = '.$value.' <strong>[ '.static::convertToMySqlDataType($key, $value).' ]</strong>'); }
$buf .= '</div>';
$buf .= $break.$break.'<h2>ALL CALLABLE FUNCTION</h2><div style="padding:10px;">';
$param = String1::contains('?', Url1::getPageFullUrl())? explode('?', Url1::getPageFullUrl())[1]: null;
foreach (get_class_methods(static::getModelClassName()) as $method) {
$full_link = Form1::callApi(static::getModelClassName().'@'.$method.'(...)'. ($param? '?'.$param: '') );
$buf .= ("<h3>function $method(...) <br/><a href='$full_link' target='_blank'>$full_link</a></h3><hr/>" );
}
return $buf;
}
static function help(){
ob_start();
echo Console1::dd( static::getAllQueryHelp() );
return ob_get_clean();
}
static function toAlterQuery($asAdd_orElseModify = true, $keyAndParameter = ' `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7 '){
$sqlQuery = 'ALTER TABLE `'.static::getTableName().'` ';
$sqlQuery .= (($asAdd_orElseModify)?'ADD ':'MODIFY ')." $keyAndParameter;";
return $sqlQuery;
}
function toDeleteQuery(){ return "DELETE FROM `".static::getTableName()."` WHERE `".static::$PRIMARY_KEY_NAME."` = '".$this->id."'"; }
static function toSelectAllQuery($value = '', $key = 'user_id', $selectColumn = []){
$columnList = static::tableColumnMerge($selectColumn);
return "SELECT $columnList FROM `".static::getTableName()."` WHERE `$key` = '$value'";
}
static function toDropTableQuery(){
return "DROP TABLE `".static::getTableName()."` ";
}
static function toForeignLinkAdd($myForeignReferenceKeyName = 'user_id', $foreignTableName = 'users', $foreignTablePrimaryId = 'id', $deleteCascade = true){
$foreignKey = '`'.static::getTableName().'_'.$myForeignReferenceKeyName.'_foreign`';
$sqlQuery = 'ALTER TABLE `'.static::getTableName().'` ';
$sqlQuery .= " ADD KEY $foreignKey (`$myForeignReferenceKeyName`); ";
if($deleteCascade){
$sqlQuery .= 'ALTER TABLE `'.static::getTableName().'` ';
$sqlQuery .= " ADD CONSTRAINT $foreignKey FOREIGN KEY (`$myForeignReferenceKeyName`) REFERENCES `$foreignTableName` (`$foreignTablePrimaryId`) ON DELETE CASCADE ";
}
return $sqlQuery;
}
static function getSafeParamOnly($column_and_value = []){
$filterArray = Array1::getCommonField(function ($data){
return static::mysqlFilterValue($data);
}, $column_and_value, Array1::initEmptyValueTo(static::toModelColumnValueArray(), ''));
if(isset($filterArray[static::$PRIMARY_KEY_NAME])) unset($filterArray[static::$PRIMARY_KEY_NAME]);
if(isset(static::getFixColumn()['updated_at'] )) $filterArray['updated_at'] = date(static::$SQL_TIMESTAMP_FORMAT);
if(isset($filterArray['created_at'] )) unset($filterArray['created_at']);
return $filterArray;
}
function toUpdateQuery($column_and_value = []){ return static::toUpdateWhereQuery($column_and_value, [static::$PRIMARY_KEY_NAME=>$this->id]); }
function save($removeEmptyData = true, $uniqueColumnKey = [], $logic = 'OR'){
$filterColumn = ($removeEmptyData)? Array1::filterArrayItem($this->toArray()): $this->toArray();
return static::insertOrUpdate($filterColumn, $uniqueColumnKey, $logic);
}
static function saveDefault($variableEqualValueArrayList = [], $optionalName = ''){
$exists = Object1::convertObjectToArray( file_session_get(static::getTableName().$optionalName, []) );
return file_session_save(static::getTableName().$optionalName, array_merge($exists, Array1::toArray($variableEqualValueArrayList)), true);
}
static function getDefault($optionalName = '', $asFullModel = false) {
$data = file_session_get(static::getTableName().$optionalName, []);
$obj = empty($data)? (new static): new static(static::getSafeParamOnly($data));
$obj->{'id'} = (isset($obj->{'id'}) && isset($obj->{'id'})> 0)? isset($obj->{'id'}): 1;
return $asFullModel? Object1::toArrayObject(true, Object1::convertArrayToObject($obj, static::getModelClassName()) ): $obj;
}
static function resetDefault($optionalName = '') { return file_session_remove(static::getTableName().$optionalName); }
static function toUpdateWhereQuery($update_column_and_value = [], $where_column_and_value = [], $logic = ' AND ', $operator = ' = '){
$filterArray = static::getSafeParamOnly($update_column_and_value);
if(empty($filterArray)) return null;
$whereQuery = Array1::mergeKeyValue($where_column_and_value, $operator, $logic, "`%s`", "'%s'");
$tableData = static::toModelColumnValueArray();
$toDataTypeFormat = function ($key, $value) use ($tableData){
return static::saveToDbAs(gettype($tableData[$key]), $value);
};
$sqlQuery = 'UPDATE `'.static::getTableName().'` SET ';
$i = 0;
$total = count($filterArray);
foreach ($filterArray as $key=>$value ) {
$sqlQuery .= " `$key` = '".static::mysqlFilterValue( $toDataTypeFormat($key, $value) )."' ";
if($i < $total-1) $sqlQuery .= ', ';
else $sqlQuery .= ($whereQuery)? " WHERE $whereQuery ": '';
$i++;
}
return $sqlQuery;
}
static function toWhereValuesInColumnsQuery($columnsToSearchFrom = [], $textToSearch = [], $logic = 'OR', $operator = '='){
$columnsToSearchFrom = Array1::filterArrayItem($columnsToSearchFrom);
$textToSearch = Array1::filterArrayItem($textToSearch);
$whereQuery = '';
for($m=0; $m< count($columnsToSearchFrom); $m++){
if($m != 0) $whereQuery .= ' '.$logic.' ';
for($i=0; $i< count($textToSearch); $i++){
if($i != 0) $whereQuery .= ' '.$logic.' ';
$whereQuery .= ' '.$columnsToSearchFrom[$m].' '.$operator."'$textToSearch[$i]'";
}
}
return $whereQuery;
}
static function whereValuesInColumnsAsRaw($columns = [], $values = [], $logic = 'OR', $operator = '=', $query = null){
$columns = Array1::filterArrayItem($columns);
$values = Array1::filterArrayItem($values);
$whereQuery = '';
$whereArray = [];
for($m=0; $m< count($columns); $m++){
if($m != 0) $whereQuery .= ' '.$logic.' ';
for($i=0; $i< count($values); $i++){
$category = $values[$i];
if($i != 0) $whereQuery .= ' '.$logic.' ';
$whereQuery .= ' '.$columns[$m].' '.$operator.' ? ';
$whereArray[] = $category;
}
}
return $query? $query->whereRaw( $whereQuery, $whereArray): ['query'=>$whereQuery, 'value'=>$whereArray];
}
static function whereValuesInColumnsAsBuilder($query, $columns = [], $values = [], $logic = 'OR', $operator = '='){
if(strtoupper($logic) == 'OR') $query->where('created_at', '=', 'just_include_and');
foreach($columns as $column){
foreach($values as $value){
strtoupper($logic) == 'OR'? $query->orWhere($column, $operator, $value): $query->where($column, $operator, $value);
}
}
return ( $query );
}
static function toWhereBuilder($column_and_its_value = [], $logic = ' OR ', $operator = ' = ', $keyWrap = "`%s`", $valueWrap = "'%s'"){ return " WHERE ".Array1::mergeKeyValue($column_and_its_value, $operator, $logic, $keyWrap, $valueWrap); }
static function toSelectWhereQuery($column_and_value = [], $selectColumn = [], $logic = ' OR ', $operator = ' = '){
$columnList = static::tableColumnMerge($selectColumn);
$where = !empty($column_and_value)? static::toWhereBuilder($column_and_value, $logic, $operator,"`%s`", "'%s'"): '';
return "SELECT $columnList FROM `".static::getTableName()."` ".$where."; ";
}
static function toDeleteWhereQuery($column_and_value = [], $logic = ' OR ', $operator = ' = '){
$where = !empty($column_and_value)? static::toWhereBuilder($column_and_value, $logic, $operator, "`%s`", "'%s'"): '';
return "DELETE FROM `".static::getTableName()."` ".$where."; ";
}
static function toInsertQuery($column_and_value = []){
$filterArray = static::getSafeParamOnly($column_and_value);
if(isset( static::getFixColumn()['created_at'] )) $filterArray['created_at'] = date(static::$SQL_TIMESTAMP_FORMAT);
if(empty($filterArray)) return null;
$sqlQuery = 'INSERT INTO `'.static::getTableName().'` ';
$sqlQueryObjectVar = '';
$sqlQueryClassVar = '';
$tableData = static::toModelColumnValueArray();
$toDataTypeFormat = function ($key, $value) use ($tableData){
return static::saveToDbAs(gettype($tableData[$key]), $value);
};
$i = 0;
$total = count($filterArray);
foreach ($filterArray as $key=>$value ) {
$sqlQueryClassVar .= "`$key`";
$sqlQueryObjectVar .= "'".$toDataTypeFormat($key, $value)."'";
if($i < $total-1) { $sqlQueryObjectVar .= ', '; $sqlQueryClassVar .= ', '; }
else $sqlQuery .= "( $sqlQueryClassVar ) VALUES ( $sqlQueryObjectVar ); ";
$i++;
}
return $sqlQuery;
}
static function toTableCreateQuery($sqlColumn_equal_propertyValue = []){
$allColumns = static::toModelColumnValueArray();
$filterArray = Array1::removeKeys($allColumns, [static::$PRIMARY_KEY_NAME]);
$sqlQuery = 'CREATE TABLE IF NOT EXISTS `'.static::getTableName().'` (';
$sqlQuery .= '`'.static::$PRIMARY_KEY_NAME.'` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(`'.static::$PRIMARY_KEY_NAME.'`),';
$i = 0;
$total = count($filterArray);
foreach ($filterArray as $key=>$value ) {
$sqlQuery .= '`'.$key.'` '.static::convertToMySqlDataType($key, $value, true, $sqlColumn_equal_propertyValue);
if($i < $total-1) $sqlQuery .= ', ';
else $sqlQuery .= ') ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;';
$i++;
}
return $sqlQuery;
}
static function convertToMySqlDataType($variableName = '', $variableValue = '', $addAttribute = true, $sqlColumn_equal_propertyValue = []){
if(isset( $sqlColumn_equal_propertyValue[$variableName] )) return $sqlColumn_equal_propertyValue[$variableName];
$dataType = gettype($variableValue);
if(String1::endsWith($variableName, '_at')) {$dataType = 'timestamp'; }
else if($dataType == 'NULL'){
if(String1::endsWith($variableName, '_date')) $dataType = 'date';
else if(String1::endsWith($variableName, '_time')) $dataType = 'time';
else if(String1::endsWith($variableName, '_datetime')) $dataType = 'timestamp';
}
$defaultValue = function() use ($variableValue, $dataType){ return @String1::toString(@Value1::typecast($dataType, "'$variableValue'", 'NULL', false)); };
$dataTypeList = array(
'boolean'=>'BOOLEAN' . (($addAttribute)?' NULL DEFAULT '.String1::toBoolean($variableValue, '1', '0').' ':''),
'double'=>'INTEGER' . (($addAttribute)?' NULL DEFAULT '.$defaultValue().' ':''),
'integer'=>'INTEGER' . (($addAttribute)?' NULL DEFAULT '.$defaultValue().' ':''),
'object'=>'BLOB' . (($addAttribute)?' NULL DEFAULT NULL ':''),
'array'=>'BLOB' . (($addAttribute)?' NULL DEFAULT NULL ':''),
'string'=>'VARCHAR('.static::$SQL_VARCHAR_STRING_LENGTH.')' . (($addAttribute)?" COLLATE utf8mb4_unicode_ci NULL DEFAULT ".$defaultValue()." ":''),
'unknown type'=>'TEXT' . (($addAttribute)?' NULL DEFAULT NULL ':''),
'resource'=>'TEXT' . (($addAttribute)?' NULL DEFAULT NULL ':''),
'timestamp'=>'TIMESTAMP' . (($addAttribute)?' NULL DEFAULT NULL ':''),
'date'=>'DATE' . (($addAttribute)?' NULL DEFAULT NULL ':''),
'time'=>'TIME' . (($addAttribute)?' NULL DEFAULT NULL ':''),
'NULL'=>'TEXT' . (($addAttribute)?" COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL ":'')
);
return isset($dataTypeList[$dataType])? $dataTypeList[$dataType]: 'TEXT';
}
static function saveToDbAs($dataType, $value){
return ($dataType === 'array')? base64_encode(serialize($value)): String1::toString($value);
}
static function getFromDbAs($dataType = 'array', $value){
return ($dataType === 'array')? unserialize(base64_decode($value)): String1::toString($value);
}
function getAssetDirectory($uploadMainDirectory = 'uploads') {
$realPath = path_asset($uploadMainDirectory.DIRECTORY_SEPARATOR.static::getTableName().DIRECTORY_SEPARATOR.$this->id); if(!is_dir($realPath)) FileManager1::createDirectory($realPath);
$pathUrl = asset($uploadMainDirectory.DIRECTORY_SEPARATOR.static::getTableName().DIRECTORY_SEPARATOR.$this->id);
return ['path'=>$realPath, 'url'=>$pathUrl];
}
function getFilePathAndUrl($file_name = '', $uploadMainDirectory = 'uploads', $onlyIfExists = true) {
$realPath = $this->getAssetDirectory($uploadMainDirectory)['path'].DIRECTORY_SEPARATOR.$file_name;
$pathUrl = $this->getAssetDirectory($uploadMainDirectory)['url'].DIRECTORY_SEPARATOR.$file_name;
return !$onlyIfExists ? ['path'=>$realPath, 'url'=>$pathUrl]: ((file_exists($realPath))? ['path'=>$realPath, 'url'=>$pathUrl]: null);
}
function deleteAssetDirectory($uploadMainDirectory = 'uploads') {
$path = $this->getAssetDirectory($uploadMainDirectory)['path'];
return (is_dir($path)) ? FileManager1::deleteAll($path, true): false;
}
function uploadFile($source_url = null, $file_name = null, $addUrlToModel1FileLocator = false, $compress=true, $uploadMainDirectory = 'uploads'){
if(empty($source_url)) return null;
if(is_array($source_url)) return $this->uploadFile($source_url['tmp_name'], $file_name? $file_name: time().'_'.$source_url['name'], $addUrlToModel1FileLocator, $compress, $uploadMainDirectory);
$path = $this->getAssetDirectory($uploadMainDirectory)['path'];
$file_name = (($file_name)? $file_name: time().'_'.rand(100, 999).'.jpg');
if(FileManager1::upload($source_url, $path.'/'.$file_name, $compress)){
$url = $this->getFileUrl($file_name);
return $addUrlToModel1FileLocator? Model1FileLocator::insertUrl($this, $url, $file_name): $url;
}else return false;
}
function getFileUrl($file_name = '', $orDemoPictureUrl = '...', $uploadMainDirectory = 'uploads') {
if($orDemoPictureUrl === '...') $orDemoPictureUrl = HtmlAsset1::getImageThumb();
$path = $this->getFilePathAndUrl($file_name, $uploadMainDirectory);
return ($path) ? $path['url']: (!empty($orDemoPictureUrl)? ($orDemoPictureUrl): null);
}
function getFilePath($file_name = '', $uploadMainDirectory = 'uploads'){ $path = $this->getFilePathAndUrl($file_name, $uploadMainDirectory); return ($path) ? $path['path']: null; }
function getFilePathList($filterExtensionList = [], $recursive = false){ return FileManager1::getDirectoriesFiles($this->getFilePath(), $filterExtensionList,[], -1, $recursive ); }
function getFileUrlList($fromModel1FileLocator = false, $filterExtensionList = [], $recursive = false){ return $fromModel1FileLocator? Model1FileLocator::selectAll_fromDb($this): array_map(function($key){ return Url1::pathToUrl($key); }, FileManager1::getDirectoriesFiles($this->getFilePath(), $filterExtensionList,[], -1, $recursive)); }
function deleteFile($file_name = '', $uploadMainDirectory = 'uploads'){
$path = $this->getFilePath($file_name, $uploadMainDirectory);
return ($path) ? unlink($path): false;
}
}
abstract class AuthModel1 extends Model1 {
public static $FIX_COLUMN = ['id', 'created_at', 'updated_at', 'last_login_at'];
static function register($request = null, $uniqueColumn = ['email', 'user_name']){
return static::insert( (($request)? $request: $_REQUEST), $uniqueColumn);
}
static function login($user_name_or_email, $password, $search_in_likely_column_name = ['email', 'user_name'], $search_in_likely_column_password = ['password']){
if(String1::is_empty($user_name_or_email) || String1::is_empty($password)) return ResultStatus1::falseMessage('Invalid login details');
$result = static::findAgainst($user_name_or_email, $password, $search_in_likely_column_name, $search_in_likely_column_password, ' AND ', ' OR ', ' = ');
if(static::$FLAG_SHOW_EXEC_QUERY) return $result;
$user = null;
if($result && !empty($result))
$user = User::find($result[0]['id']);
if($user){
Config1::onLogin($user->getModel());
if( isset(array_flip(static::$FIX_COLUMN)['last_login_at']) ) {
Session1::set('last_login_at', $user['last_login_at']);
if($user->update(['last_login_at'=>date(static::$SQL_TIMESTAMP_FORMAT)])) Session1::saveUserInfo($result[0]);
}
return $result[0];
}
else return ResultStatus1::falseMessage('Credentials Not Found');
}
static function re_login(){
$userInfo = static::getLogin(false, null);
Session1::deleteUserInfo(true);
if($userInfo) static::login(String1::isSetOr($userInfo->user_name, $userInfo->email), $userInfo->password);
}
static function getLogin($orRedirectToLoginPage = true, $on_failed_redirect_to = '/login', $redirectMessage = 'Session Expired, Please login again'){
$user = Session1::getUserInfo($orRedirectToLoginPage, url($on_failed_redirect_to), $redirectMessage, static::getModelClassName());
$user['last_login_at'] = Session1::get('last_login_at');
return $user;
}
static function isLoginExist(){ return Session1::isLoginExists(); }
static function isGuest(){ return !Session1::isLoginExists(); }
static function isAdmin($redirectToLoginPageIfGuest = false, $column_value = ['admin'], $column_name = 'role'){
if(!User::isLoginExist()) return $redirectToLoginPageIfGuest? redirect(routes()->login, ['Login Required', 'Please login', 'error']): false;
User::re_login();
$column_value = Array1::toArray($column_value);
$current_role = User::getLogin()[$column_name];
foreach ($column_value as $value){
if($current_role == $value) return true;
}
return false;
}
static function getAllowedRoleLogin($column_role_list = ['admin'], $column_role_name = 'role', $on_failed_redirect_to = '/login', callable $onSuccessCallBack = null, callable $onErrorCallBack = null, $errorMessage = 'You do not have permission to visit this page, Please login again', $errorTitle = 'Access Denied'){
$login = User::getLogin(true, $on_failed_redirect_to, $errorMessage);
if(User::isLoginExist() && in_array($login[$column_role_name], Array1::toArray($column_role_list))) { if($onSuccessCallBack) return $onSuccessCallBack(); return $login; }
else {
if($onErrorCallBack) $onErrorCallBack();
else {
Session1::setLastAuthUrl(Url1::getPageFullUrl());
redirect(url($on_failed_redirect_to), [$errorTitle, $errorMessage, 'error']);
}
}
}
static function logout($redirectTo = '/'){ return Config1::onLogout().Session1::deleteUserInfo()? Url1::redirectIf($redirectTo, 'Logout Successfully!', true): Session1::setStatus('Failed', 'Logout Failed', 'error'); }
function uploadAvatar($source_url = null, $name = 'avatar.jpg'){
$result = $this->uploadFile($source_url, $name, false);
if($result) if( $this->update(['avatar'=>$result]) ) return $result;
return false;
}
function getAvatar($name = 'avatar.jpg', $orDemoPictureUrl = '...'){
if($orDemoPictureUrl === '...') $orDemoPictureUrl = HtmlAsset1::getImageAvatar();
return $this->getFileUrl($name, $orDemoPictureUrl);
}
static function uploadMainFile($source_url = null, $unique_file_name = null, $user_id = 1) { return static::withId($user_id)->uploadFile($source_url, $unique_file_name); }
static function getMainFileUrl($file_name = null, $user_id = 1, $orDemoPictureUrl = '...') { return static::withId($user_id)->getFileUrl($file_name, $orDemoPictureUrl); }
static function getMainFilePath($file_name = null, $user_id = 1, $uploadMainDirectory = 'uploads') { return static::withId($user_id)->getFilePath($file_name, $uploadMainDirectory); }
static function deleteMainFile($file_name = null, $user_id = 1){ return static::withId($user_id)->deleteFile($file_name); }
}
class Model1FileLocator{
private static $model = null;
private static function initClass() {
if(static::$model) return static::$model;
$className = '__'.static::class;
$code = 'class '.$className.' extends Model1{
public $id = 0;
public $file_name = null;
public $file_url = null;
public $other_url = null;
public $model_name = \'\';
public $model_id = 0;
public $tag = null;
public $created_at = null;
}';
eval($code);
static::$model = new $className();
return static::$model;
}
static function toModel(){ static::initClass(); return static::$model; }
static function tableCreate() { static::initClass(); return static::$model::tableCreate(); }
static function tableTruncate() { static::initClass(); return static::$model::tableTruncate(); }
static function tableReset() { static::initClass(); return static::$model::tableReset(); }
public static function insertAll_fromFile_toDb($model, $append = false){
static::initClass();
if(!$append) static::$model::deleteMany(['model_name'=>$model->getModelClassName(), 'model_id'=>$model->id]);
$allFile = array_map(function($row) use ($model) {
return ['model_name'=>$model->getModelClassName(), 'model_id'=>$model->id, 'file_name'=>FileManager1::getFileName($row), 'file_url'=>Url1::pathToUrl($row) ];
}, $model->getFilePathList());
return static::$model::insertMany(...$allFile);
}
public static function insertUrl($model, $file_url = null, $file_name = null, $tag = null, $other_url = null){
static::initClass();
if(!$file_url) return false;
$file_name = (!$file_name && String1::startsWith($file_url, 'http'))? time().'_'.rand(1,80).'_'.FileManager1::getFileName($file_url): $file_name;
return static::$model::insert(['model_name'=>$model->getModelClassName(), 'model_id'=>$model->id, 'file_name'=>$file_name, 'file_url'=>$file_url, 'tag'=>$tag, 'other_url'=>$other_url ], [], 'OR',true)? $file_url: false;
}
public static function uploadFiles_andInsertUrl($model, $fileRequest, $append = true){
static::initClass();
foreach (Array1::normalizeLinearRequestList($fileRequest) as $file) $model->uploadFile($file);
return static::insertAll_fromFile_toDb($model, $append);
}
public static function find($model = null, $file_name = null, $orDemoPictureUrl = null){
$file = static::find_inFile($model, $file_name, $orDemoPictureUrl);
return $file? $file: static::find_inDb($model, $file_name);
}
public static function find_inFile($model = null, $file_name = null, $orDemoPictureUrl = '...'){ return $model->getFileUrl($file_name, $orDemoPictureUrl); }
public static function find_inDb($model = null, $file_name = null, $urlOnly = true){
static::initClass();
$whereClause = "WHERE model_name = '".$model->getModelClassName()."' AND model_id = '$model->id' AND file_name='$file_name' limit 1 ";
return $urlOnly? static::$model::selectManyAsList($whereClause, 'file_url')[0]: static::$model::selectMany(true, $whereClause)[0];
}
public static function selectAll($model = null){
return array_unique(array_merge(static::selectAll_fromFile($model), static::selectAll_fromDb($model)));
}
public static function selectAll_fromDb($model, $urlOnly = true, $asObject = false){
static::initClass();
$whereClause = "WHERE model_name = '".$model->getModelClassName()."' AND model_id = '$model->id' ";
return $urlOnly? static::$model::selectManyAsList($whereClause, 'file_url'): static::$model::selectMany($asObject, $whereClause);
}
public static function selectAll_fromFile($model, $extension = [], $recursive = false){ return $model->getFileUrlList($extension, $recursive); }
static function deleteAll($model = null){
static::initClass(); $model->deleteAssetDirectory(); return static::$model::deleteMany(['model_name'=>$model->getModelClassName(), 'model_id'=>$model->id]);
}
static function delete($model = null, $file_name = null){ static::delete_fromFile($model, $file_name); return static::delete_fromDb($model, $file_name); }
static function delete_fromFile($model, $file_name = null){ return $model->deleteFile($file_name); }
static function delete_fromDb($model, $file_name = null){ static::initClass(); return static::$model::deleteMany(['model_name'=>$model->getModelClassName(), 'model_id'=>$model->id, 'file_name'=>$file_name]); }
static function delete_fromDb_byFieldName($uniqueField = -1, $columnName = 'id'){ static::initClass(); return static::$model::deleteBy($uniqueField, $columnName); }
}
abstract class Auth1{
public static $USER_CLASS = User::class;
private static $USER_LOGIN = null;
static function user($redirectOnFailed = false){
if(static::$USER_LOGIN) return static::$USER_LOGIN;
return static::$USER_LOGIN = static::$USER_CLASS::getLogin($redirectOnFailed);
}
static function get($fieldName = null, $defaultOnNull = null){ return $fieldName? String1::isset_or(static::user()[$fieldName], $defaultOnNull): static::user(); }
static function id(){ return String1::isset_or(static::user()['id'], null); }
static function userOrInit(){ return static::id()? static::$USER_CLASS::getLogin(false): static::$USER_CLASS::findOrInit(); }
static function isGuest(){ return static::$USER_CLASS::isGuest() === true; }
static function isAdmin($redirectToLoginPageIfGuest = false, $column_value = ['admin'], $column_name = 'role'){ return static::$USER_CLASS::isAdmin($redirectToLoginPageIfGuest, $column_value, $column_name);}
static function getAllowedRoleLogin($column_role_list = ['admin'], $column_role_name = 'role', $on_failed_redirect_to = '/login', callable $onSuccessCallBack = null, callable $onErrorCallBack = null, $errorMessage = 'You do not have permission to visit this page, Please login again', $errorTitle = 'Access Denied'){
return static::$USER_CLASS::getAllowedRoleLogin($column_role_list, $column_role_name, $on_failed_redirect_to, $onSuccessCallBack, $onErrorCallBack, $errorMessage, $errorTitle);
}
}
abstract class Api1 extends ServerRequest1 {
public static $api_id = '';
public static $api_key = '';
public static function isApiAuthValid(){
return isset($_REQUEST['token'])? is_token_valid($_REQUEST['token']): false;
}
}
abstract class Controller1 extends Api1 {
}
abstract class DbPref1{
static $model = null;
private static function initClass(){
if(static::$model) return static::$model;
$className = '__'.static::class;
$code = 'class '.$className.' extends Model1 {
//pref var
public $id = -1;
public $user_id = -1;
public $key = "";
public $value = null;
public $name = "";
}';
eval($code);
static::$model = new $className();
return static::$model;
}
static function toModel(){ static::initClass(); return static::$model; }
static function tableCreate() { static::initClass(); return static::$model::tableCreate(); }
static function tableTruncate() { static::initClass(); return static::$model::tableTruncate(); }
static function tableReset() { static::initClass(); return static::$model::tableReset(); }
public static function save($name, $object_or_keyValueArray = null, $user_id = '', $replace = true){
static::initClass();
$data = get_parent_class($object_or_keyValueArray) == Model1::class? $object_or_keyValueArray->toArray(): Array1::toArray($object_or_keyValueArray);
$query = $replace? static::$model::toDeleteWhereQuery([ 'name'=>$name, 'user_id'=>$user_id ], ' AND ', ' = '): '';
foreach (Array1::toArray($data) as $key=>$value) { $query .= static::$model::toInsertQuery(['key'=>$key, 'value'=>$value, 'name'=>$name, 'user_id'=>$user_id]); }
return Db1::exec($query, true, true, true, true);
}
public static function delete($name = null, $user_id = ''){ return static::deleteRaw(['name'=>$name, 'user_id'=>$user_id], ' AND ', ' = '); }
public static function deleteRaw($where = ['name'=>'', 'user_id'=>''], $login = ' AND ', $operator = ' = ' ){ static::initClass(); return (true == Db1::exec(static::$model::toDeleteWhereQuery($where, $login, $operator))); }
public static function normalizeRawRows(array $rowList = []){
$objBuffer = [];
$rowId = [];
foreach ($rowList as $row) {
$objBuffer[$row['key']] = $row['value'];
$rowId[$row['key']] = @$row['id'];
}
$objBuffer['__id'] = $rowId;
return $objBuffer;
}
public static function get($name, $user_id = '', $convertToClassName = null){
$data = static::normalizeRawRows( static::getRawRows(['name'=>$name, 'user_id'=>$user_id]) );
return $convertToClassName? Object1::toArrayObject(true, Object1::convertArrayToObject($data, $convertToClassName) ): $data;
}
public static function getMany($nameLike = '_', $user_id = '', $nameFormat = '%{data}%'){
static::initClass();
$buffList = [];
$query ='SELECT name FROM '.static::$model::getTableName()." where name like '".String1::replace($nameFormat, '{data}', $nameLike)."' AND user_id = '$user_id' group by `name` ";
foreach (static::$model::exec($query, true, false) as $data){
$buffList[] = static::normalizeRawRows( static::getRawRows(['name'=>$data['name'], 'user_id'=>$user_id]) );
}
return $buffList;
}
public static function getManyIfStartWith($namePrefix = '_', $user_id = ''){ return static::getMany($namePrefix, $user_id, '{data}%'); }
public static function getManyIfContain($name = '_', $user_id = ''){ return static::getMany($name, $user_id, '%{data}%'); }
public static function getManyIfEndWith($nameSuffix = '_', $user_id = ''){ return static::getMany($nameSuffix, $user_id, '%{data}'); }
public static function getRawRows($where = ['name'=>'', 'user_id'=>''], $login = ' AND ', $operator = ' = ' ){
static::initClass();
$query =' SELECT * FROM '.static::$model::getTableName().' '. static::$model::toWhereBuilder($where, $login, $operator, "`%s`", "'%s'");
return static::$model::exec($query, true, false);
}
public static function getByUser($user_id = ''){
return static::normalizeRawRows( static::getRawRows(['user_id'=>$user_id]) );
}
public static function exists($name, $user_id = ''){ return !empty(static::getRawRows(['name'=>$name, 'user_id'=>$user_id])); }
}