[讨论]请假单中如果实现带薪年假的消减(第三问)
亲爱的管理员您好
我在尝试做一个请假的场景:比如说张三还有7天的年休,有一天他有事情要请一天的假,在填写请假单的时候请假单可以自动显示出他剩余年休假为7天,当领导同意后,他的年休假自动减一。我的想法是在数据库建一个包含公司所有人年休假的表(表名假定为:year_vacation),首先张三在填写请假单的时候表单自动在数据库中找到year_vacation表并根据拟稿人的名字将其剩余的年休时间返还到请假单上,之后当请假完成后如果领导同意那么找到数据库中year_vacation表并根据请假天数将拟稿人的剩余年假进行删减,以上简单说就是对数据库中表的查询和修改,但是我在O2OA Service API URL 找了好久没有发现具体的执行方法啊!能不能给一个具体方法截屏?
之前您这边给了一个答复就是:可以使用数据数据表
现在我又一个问题如下:
在“https://www.yuque.com/o2oa/course/mz64w9”中提到“目前在表单和页面中还没有数据表组件,需要通过脚本来进行增删改查的执行。”(附件一)
但是请问
① 这个脚本应该在什么地方写入呢?是附件二中的脚本配置里面吗?还是说其他什么地方?
②这个脚本写好后还有“调用”该脚本,这个调用脚本的语句又应该写在哪里?
因为这个整个页面中能够写脚本的地方太多了 实在不知道应该写在哪里合适
还麻烦您指明
谢谢 1.叫queryTableService的脚本。
http://bbs.o2oa.net/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAIsAAACJCAYAAAAc0cv0AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAABbSSURBVHhe7Z17jBb1ucef5Y6KFxQF5bYCKpgKogmC9VipDSqKyqoRqDlVxNjisecYJG1Qm1hs0sZa28bSxlL/KWCExdJT0xwvKEgWqAUEuQu7Cous4gXxAizinufz2/d597fDu8uwO7sys79v8svMO7d3dp7PfJ/nN+/MbFHXiybUiGrXa08xCApy2rJli3To0EE6duzohrR2uXlBQUdVgCUotgIsQbEVYAmKrQBLUGwFWIJiK8ASFFsBlqDYCrAExVaAJSi2AixBsRVgCYqtAEtQbAVYgmKrVWGpqakJLcHW2mpxWAr9cf600I69mQpNa0m12M1PDf1R1kz+eFDDKioqyo3VjkebyR9vjgrd/NQisBgAX3/9tRtn6DebhwIs8WQQtGtXmwwY+o35Ni8JYFoFFoLvA3L48GHXvvrqKzl06FB+mi0TFF8GRfv27d24BZLPNs2WaS4wLQqLOYRBABDAUV1d7drBgwfdkGkGEMvZekGNy5zDwCCInTp1ks6dO7shjWkGjcHSVGhaBRbfRQ4cOCD79++XL7/80jXGgYZ5LBNgiS+DxQIIJF27dpUTTjjBNca7dOmSDy7Q2HpNUYvB4oNCw0EA4/PPP5fPPvtM9u3b5/64vn37Sq9eveTkk092f3jQsYsTjOO5e/du2bFjhzv5OJ7dunWTk046yUGDy5gDoaYAUwiWxCLGH0EzRwGUvXv3yocffiiDBg2SMWPGyODBg+XUU08NoDRDHDuOIceSY8qx5RhzrDnmHHtiYPFIUs2OmrkKQ99VcJRPPvlERowY4f6woJYRx5ZjzLHmmHPsiQGx8GOThBI5xdkZKDZYqE+wygsvvFD69OmTWyqopcQx5lhzzDn2BgsxSQoUlAgsZnnYHzn0iy++cDVKcJTWE8eaY86xt06ExSUpNQsWn1p2ih4OVJM3KWaDWlccc449MbDepikJh0k0DdHMXej1BLWuOOZRVzmu0hA7YztEnqSxs3TnsiT+Rs7YDz74QMrLy+Xdd9+V9957zxWWnMXHgzjmHHuLA/Lj01wl4izIKGYnOXhZ6R4DCN1S4Hj77bddN9UCwN9K7+PTTz89LoDhmLMf7Bf7R0ySVGJpCJn1Jb2TrS32n55FZWWlbN++XXbu3OnO2BNPPNFd+OJKqV0x5eopF8HsTP6mFY2BxSYJJXb6204xTHIHW1N0O0ktOAhOwnULehinnHJKHg6GhRpXOI+Hk8Q//knHIRu5ohnCtqlDAIRa5OOPP3aXybl8TgMQgGFozQBhHEhsO7hPltVmYaHOIMVs2rRJ3n//fZdGSDO4iEFhkACG/4Md06kPcBJqGuoWu3KaZbUZWLBkrkFQh6xbt865CMEFAHoRgGKAmHMYJAyZh+OwHRyEbdGAhPRlv8tkWZmHBSD27NkjmzdvlvXr17uuLoE/7bTTHCDA0VCaoVG88qstaYZrGDRzEq6WUtfYD6ZNvR0gLcokLAQWKLZt2+YA4ad8AgkguAgQ+CnGWkMuAiBRFwGQjz76yNU7NFISKSzLyhQsdHfpxWzYsMEVrAQYOE4//XQHQiHnYLpBwr0b1CIA4tcivotQAONUAMI4EPbu3dv9kMf6cfS5Qrz5b3+T/Vo3pUmph4WgVlVVydatW+Wdd95x6YDAn3nmmfkub7QOoRkkpBkrVi3FABkOAiDmIgBCt5qbjpiHSw0ZMkQuvvhiKS4udt8RR5UKyYapU+X/pkyRF3/969zUdCi1sFRUVMiiRYvkmWeekdmzZ8vixYtdwPv375+HgBZ1EpqfZkhZlmLMQQCE3hLOAYi7du1ysNBjAkAA4VfeM844I3832tFUrdva9MgjsuHBB2XNihVSri64XYdpUiphoTcza9YsefHFF2X16tUu5bzyyivy5JNPyvLly/PFaxQQzn5chKD7LmJO4herQIKLkNpY76yzzpKzzz67SXXJRytXypuTJ8vGp56Sf2maXKnb7HH55XLLr36VWyIdSh0sFK5AwmV3XOTcc8/NN0B49tlnZdWqVflCFkioJXARq0OAw2DxAaEOARLGqVuAjnoEUPg+XITvYPk4+lq/Y7tC/eYPfiDrFeZluu8Vui9jpk+X/16wQPoOG5ZbMh1KHSwUsKQZfo7nXlS70sp4v379XFCXLFniHAFI/N6MNUsz1psBEC7MMZ11qHfOOeccB0u0aAUWIGObjWnfli3y5r33yoaf/Uz+XV4uyxXKrhddJD9WSG7/5S/lpO7dc0umR6mDhSADBq5BIKPFa48ePdyZD1RWtFqa8SExQHAqq0VIMz179nTAAQU9HYbILuezPNthWEg1uq2qv/9d1qqbbNRhmbrUVt3GZXffLdP+8Q8Zeu21uSXTp9TBAgBWf1gRyzjTGLdaBSgIKgVrtFgFEqazPEUqLsWQzwBCI+UAkaUshtQwFLr5C3Sa1nzt197SRi1i1/zwh/LmW2/JMv3O6oED5T//8AeZ/PTT0l1TWpqVOljMTXxYaAYMsJBGWM6uidDltRuV7OIZgFCLUNtYz8jchNoGmACC6f53sB7XbVhunwfLHk19b91zj2z8059kpX7nG7r+kNtukx8/95z8x5135pZKt1IHCzBY8IDD0g/TSU8EkrvdCSa/A+Ei1BiWoizYfGYZg4Qhy+FGpBt+TWYZ6iPGAYU6prvWGnwGsGod7lm7Vrb97ney7kc/kjVLl8rrCuguTWN3/P73cs+f/yz9UlbENqbUwYITREGhxsAtCCQwUJjSyyGNABAOQpqhEMZxAAMZJHYBjnHbHts3x7Fl+eUHZyoCFv2+A2vWyNaHH5Z1mnpWbN0qb+h3nvmd78h0rU2+d9990kW/L0tKJSwEkaASUM58HxbgYBlchGKVzxZ4nIRG4HEPAKEWwSlYB3di3BwH2Tpumrb2+n3A8rF20Xdo2tn8z3/KEq2J3tZ1r/rpT+V/Sktl0KhRbt2sKXWwAIVdobU0QZAZGjgAYoEHDGsAQB0CJBSppBZzEWSAIB8SHKWdOlIHBeqQFrlVjz4q2x58UFasXy+v6nbaX3ihPDB/vkz6xS/kRHW1rCqVBS4pheB3siKXdAQwOrTuMU5iaQQXIdXgIgiQSEmsiwq5iA9KB122HdtevFje1Z7OBq1HXtHu+Tpd/9I77pD/WrBABmj68WHLolIHCwGkQMU1OioMHTXwDA9ovbBGawgu/9vvOBSsNFwEMHARQAE0ao8GnUTnM2yn2+2kYB5WAPf89reyTUH59+uvy0u6/MH+/eX7Tzwhd82aJT3OPVe+1J4WkGZZqYMFkW4oYovUWfZv3ix7//hH+Wz7drWADnLeeee5WgUXIeCWmkg1fAYSxLgN/VRFK1KI2uu2O+h3fLFqlVRqsbpJU89STUErdZ0Lxo2T++fOle9Oneq2dwAn0+8GPhwsq0olLATY/eKrQ9e0ZujWr5+cr6DQG8I9rI4hbSFzEta1RppycOi4DWkddF2GH86eLeVTpsjqRYvkZXWnKnW0m2fOlClPPy39L71UvtBu8uHqaudAtg2u0ZD2sqhUwoJIK9212O08YIB0+fa3pZOOd8UNSE8KiNUrlmoMBOSDYUFGjNPbqX7vPan8yU9ky4wZUqbOtUznnT5ihNw3b56MnTZNOusy+/ftqy18vW0hvht38VNcVpRaWBCpiKK2s4LRReGxwPmQIAukBfWIlpvXUXtRBxSO8nvvlXV/+Yu8SpdYwRh9//3uB8Dzr7hCDikIX6l7sHwUOoSDAQw9rqwp1bAgLrjVhulI+YG05rtIvum0Lj16yKGNG+VNrUOWLFsmSxS2DkOGyN2aiiY8/ricoM51MHfhztY7YjuRadb7yopSDwtph9+C6PH4wbKzPjosNN5FHap6yxZ57a675FXtTe1VSK7Qovb++fNlxO23O0icm0TWi27bhuYu1C7sV1aUelgQxSwX4uguWxDjNILfTtPXRwrK/2qqWaUF67emT5cpf/2rTPjNb+SsQYNcl1jtxPV2ouuj6DRrAEMPjK57VuqXTMCCuPZiV2I5u6NDa/5ngqpRlQ8qK+XAsGEyVLvH599yi1TrdirLy+UDLXTp3fg9Kdbx12fob9M+m9inrNQvmYEF8XsQAYz+DuQHst5nXadIQeCX4bEPPCAjrrpKummP6istYvdr42owza7+Ag6N1OLXLoW+g8YyDElJWahfMgUL9Qs/JhIkxv0ANtg0mF21x3N6t25ypqayvn36uHt7uWuOazlcq2FbbBNQ7EYo0gvjuA6KbhcZMMDCcmmvXzIFC7IfFwmO7zA0O+Nt3IYaUbe8feYaDunDrv7azwR2oY8fIN16KuokmqWq6PZpiO1R8LJMWpU5WBC/TOMGBMwPWmMNFRqnsQ22B0SAApCAwxDXiPMdLMOyaf45IJOwIHpHKJqOUKHPcQJuy9JwLRoAWOOzv4w13ARXwX0slaVRmYUFSDj7CZABAxBJNR8G+xydDySkKCuM7Z7etLpLZmFB1AnRdGRDa9HPjbVC60a3yxBAKWYNEL8xjQIZiNKmTMOCuMnJ3MXkBzz6ubEWXdb/jCzd0MxNaP40luGpA8bTpszDQiApRP105LeoWzTWosvyGQGAOUljza7V8ABcGlNR5mFB1tWNBryh8bjzzEmiqcbSjTU+27tdeI4aWTGcJrUJWBDuwtlvNUw0+MgHwZ/nf6b5TmIpJtqYh5MACY/LAgm3XXIxD5fjek3a1GZgsW4ugTIAkAFQCIrodCtcgaGQk0QhMSfhSUimsz6vB+EKsd0snia1GVgQvSOCDQB+i4IRnUeQrQvsw2HN4KEO8Z0EWACH9XlLNy9B5HVivDGKaWlTm4KFwHNGE3icxoeDoT+OCKilFStOo5Aw9J2EJwsY2rNJPIjPK8y4SevWW2+VSy65JJWgoDYFC6LYtWAZIA1BAgiFnMQaTsJ7YHwnARLW5b0vvMoMSG6++WYZPXq0+2GSesdATZvaHCyIgPmgFIIk2vzpFKlAAhw0ahLAYR6Q8EJmwLjxxhvlyiuvzL/VAUho9n1pU5uCBRg483kFO+/HNTchLTUGic0j3RgkuIn1bnAe3v3C6925ifymm25ykAAMThbtgaVVbQIWgk2AN27cKEuXLpUFCxbIyy+/7AA4Wu+GcYAADEs3OIktwwt+eDkzkJSUlMjVV1/tnARIqI98UNKuTMNC0ck7WniJ8htvvOF6I6QJbmHABSg+gYXAm4NYY1q0JjFIWIeXA1G4si0K12uvvdbVJ0Diu0mWlElYqEkAg7dWAor91w87u7kgBhD8V3RSk7kIQ5rVJH7hCjgsi5MACa/oGD9+vFx33XUOEmoRAKGlPd00pEzCwn2zuAYAcJbbnW6ME1S7iQnXMVcxJyHdWE2Ck7AtIAEa4OKHyeuvv95BwpugcA8DJWtOElUm/zpcBDhIEdQSBJgLctYjYYgz4B4UvDgJb7gEEEChkcKAiHGchO3dcMMNcs0117hXqAKHbSvrkJgy+VcSRH4Lco+3asoxUCxNMI6zAAPuYekGVwEeXIZpdIHZDpCMGTPGvauO9cxNsphqGlNmnQVIcBSCa2mHZk7AMowDCM3qFa7AcjENJxk7dqxzEtIN65qbtEVQUOZgobgl0AQeZ/FBIdgEmeslNGCy3g29JLrAOMm4ceMcKLyKnc9Z6wI3VZmCxXo2nPnUIEDAhTECjJNYEUuqGTBggHvpD11gCldSFb0bLqgBCa4TIKmvzDkLgFCH8FKfF154wUHDnf44BE7CBTP+KQTuw7UWgKAmARLr3QCIQRJUp8wdDXMRnGHQoEHy0ksvuf9LVFZWJmvXrs3/U2/SEl1gUg7/XAowaLhScJLCyhQsBBhIKG5xEpyC32iGDx8uF1xwgQwdOlQuv/xy5yJcJ+EmJKBhvZBujq5MwsJFOGoVUg7PLOMww4YNc9Bw8xEQARSAmJMEHV3hKAXFVoAlKLYCLEGxFWAJiq0AS1BsBViCYivAEhRbKYFluTxWVHcnfsm8Kje1al6JFP18uRuXFY/l59Mea+SfsbOebaOQ3Ha9bdVrt82VuT+PTn9M97BWy4+Y10jTbTW8F8efUuQs42XOzhrZPXd87nMB3TpHdtfsljm35j43UT0nlLpfr2uWzxR5tMx95/i5u2unPTdRJj5c+7r32lYmulQ95ZfdOUfGu31iudr9mrk8tx7bTplSmoYqZO5tRdJr4kKRR0bpWVp3ZvtqyCFYb+HEXgXnNeY4cZXfdp9JsnD+JOnltt1LJs0XeWhk7rtGPpRbOj1KESwLZVKfHCBSLBOfy7mMnvk1NTNkZO1C9ZR3CL95Z3T+LPda6YSeIpVzpcQCqjD6cB0NppH1XKe21XMmv6lL6belRtlKQ0cTEDxRLGUueGVS/ERhR6rVTCmLpCH77vp1ySgxj2iKk+VrrhQopWlosSt469KQFrT8L7rGBCh9KmSans3FboK6k4LzeAMpDFVUrJbxA2uXjqrOKepqloJOpq1BZ6E9XMgTj0+lFJbRMkMPtB+EGd/LzSokekp9SqVkZyRd9Z4opTsBpkTmVuam5fWQTJooUnJFT+lZPNw5Q20KjGqk7ou/3SpXT/nuUdhZGnO141MprVlQlSx+frhMK57dqJW7lKGRLKsplYm9cxN9OWBKpFS3Xb8e0TRk61w2wwF5LCmwUD1U147sQaVBicHC2WJDG09W9WuWqnlTpeIBPaN7F8v4RxYXPEsBZdRbdF0nS4V3th9xpj9TLKXatS15XqflwXtIRtn8XCvsLCpSXOSaSb7XU7DV1TlJy77DxpNUIrDYTtmtiYnfTFRZIatluBSbM2ybLVM1cC4gdE91bkUFMypk9m10UWfK6MtyPRPX4+jpek92Zh9RQ7i6IbdMvobAWerWsfUKSvcvitE35SzRGCQJTGJRZefYMe484w407rRPSlWvl8rCR0fX1QUDJ6sT1B38skcXSunzq3VGsUx2UBTuSh+b4jtLlRbC8q3ib7wbzDG3u//Y36RP2mZvzQ4kYidp3NrIo6FJqWLbQpk5sMJd+yBgw4vrhwUHKX1geO5TUmrYWUbeOUfES2O9tBCec2dxrrCNXHwr2EhDBmNyhS7HnGNvcUD2nUmoqOtFE9z/NNn12lNuwrGIA4i4m57ndXgeh0cveGCL53IGDx7s5ge1jnhJEU8vcO8xj7/wuAuPuvjgxBXPUuFSwMeQ1ixn8b8cy2OD7BwPbO3YsSM3J6i1xDHn2PsPx5mScJdEkho7RYNCHq2AaJ7+g/Sg1hHHmmPOsScGxMLikpQS2RLUslPYHVTzmAWvtOBFOjzQFdSy4hhzrDnmHHtLPcQkqXoFNRsW2xmGBos9KsqD6StXrgwO04Li2HKM7T009iA/sfBjk4SaVeCa/ELXil1ekMNbk3gpDlU61ti3b1/3DDJnQJL22JZE95jjyevKqFFIPRxPQOHhOh8WGmoKLIUK3ERgQT4wPJzOi3J4rQXQ8OYCGuP8ccxjGf5wWy+ocRFwTjALICcfYJB27HFd/6VFzQEFtQosDIEAaIACl6EBCUOmmQMFWOLLYDHHIIg4CNAwpDGNeX6tclzCYiL4BoxB47uNTbNlguLLIDAgfBexabZMUyExtQosyNzCnMPAsWbzkC0b1Lgs+MBgQ78x3+Y1FxTUarAgHwLGo83kjwc1LB8AxqPN5I83R60Ki6kQDAGQ5qkQEElBYioES4v3X418/4/xp4V27M1UaFpLqlUvdvh/XGjNb62tcGUsKLYCLEGxFWAJiq0AS1BsBViCYivAEhRbAZag2AqwBMVWgCUotgIsQbEVYAmKrQBLUGwFWIJiSuT/AdFUW0GNVODIAAAAAElFTkSuQmCC
2.调用的话 ,,是在您有业务需要的时候调用,根据您的需要来,比如一些人需要在按钮点击是触发,那就在按钮click事件中写即可
页:
[1]